Summary

• Over 8 years of IT experience.
• Experience using ACORD as the Insurance Industry standard
• Vast experience in Data modeling for ODS and DW using Erwin.
• Good understanding of Reverse and Forward Engineering, Logical and Physical
• Strong Experience of Data Warehousing and Systems Architecture.
• Efficient in all phases of the development life cycle, coherent with Data Cleansing, Data Conversion, Performance Tuning, System Testing.
• Excellent background working with clients, designers, programmers and DBAs to identify requirements.
• Ability to analyze needs and product requirements to create a design.
• Experienced in Implementing Normalization/denormalization techniques for optimum performance in OLTP/OLAP database environments.
• Deep exposure to ER and process diagrams, along with good documentation skills.
• Experience with formal software development methodologies including Waterfall and Agile Methodologies XP, Scrum , etc.
• Strong oral and written communication skills.
• Ability to function well within a team and excellent individual contributor.
• Excellent in customer/vendor relationships.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Extensive experience in the development, implementation and integration of strategies within a team oriented analytical skills.
• Excellent listener. Listens to what people are saying and try to get into their shoes to help better understand the situation and needs and act according to it.

Expertise includes

• Data analysis and modeling
• Defining, documenting and implementing enterprise data modeling standards
• Use case analysis
• Requirements business rules gathering and analysis
• Source To Target mapping
• Professional training
• Project/Team Leadership

Technical Skill Set

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler

Responsibilities:

• Involved a very in-depth level of policy administration understanding which was at the business level.
• Review the overall PAS program context diagrams.
• Gathering Functional and Non-Functional Requirements FNFR .
• Create Phase 1 versions of context diagrams and assumptions for ALIP and the surrounding systems review with stakeholders
• Was involved in doing the Lexical Analysis of the Policy Print data.
• Worked on ACORD as the Insurance standard tool used by Allianz for their PAS Print project.
• Mapped the Functional and Non-Functional requirements data attributes which were required by Allianz to ACORD standard.
• Worked on gathering the Business Description for the FNFR data attributes by meeting various SME's and Business Analyst.
• Created a high level ACORD xml message which was/will be used as standard by other teams SIG team and QA team for their enrichment process and for printing the Policy data.
• Was involved in segregation of ACORD xml message also called as ACORD 1203 xml message , each for different streams Prospectus, Policy Print, Statement, Confirms Correspondence .
• Was involved in Planning and estimating the requirements and the time it takes for the completion of the process.
• Was involved in mapping the gathered FNFR data attributes with the ALIP source staging tables.
• Was involved in creation of Conceptual Design Documentation for the final deliverables and for further enhancement of the Detailed Design Documentation.

Environment: ACORD 2.4, Erwin 7.3, SQL Server 2008, Microsoft Office Suite, ORACLE 11g, PL/SQL, Informatica.

Confidential

Systems Analyst, Senior Data Modeler / ETL Developer

Responsibilities:

• Assessing the information needs of the users and defining database requirements.
• Develop/Review Conceptual Data Model with the Functional team.
• Design the Logical data model based on the business rules captured from business requirement gathering sessions.
• Review data model, entity and attributes logical model to ensure that they are according to the Thompson Corporation's naming standards document
• Converting logical data model into physical data model.
• Normalize and De-normalize the model based on the user and development team's requirement.
• Integration Data Design Batch Updates
• Producer Publisher Data Design Real time updates

Confidential

Data Modeler / ETL Developer

Responsibilities:

• Assessing the information needs of the users and defining database requirements.
• Utilize Erwin to create logical/physical data models.
• Performance Tuning of complex queries and Database.
• Develop/Review Conceptual Data Model with the Functional team.
• Design the Logical data model based on the business rules captured from business requirement gathering sessions.
• Review data model, entity and attributes logical model to ensure that they are according to the CMS naming standards document
• Converting logical data model into physical data model.
• Normalize and De-normalize the model based on the user and development team's requirement.
• Review database, table, view and column model to ensure that they are according to the CMS naming standards document.
• Liaising with the Information Architecture group for the approval of Data model.
• Forward engineer the data model to create the scripts to be executed in the Database.
• Processing changes requested in the Data model as the project moved through design and development phases.
• Introduced logical data modeling into the initial OLTP, DataMart and ODS development process leading to less re-work in later phases.
• Participate in design, source-to-target mapping, meta data creation and review.
• Liaising with multiple vendor teams to access the impact of the change requests.

Confidential

Data Modeler / Developer

Responsibilities:

• Made presentations to team and across the segment on technical issues
• Updated and enhanced technical skills to keep at par with evolving technology
• Developed scripts for this DW which was in Unix.
• Worked with the DBAs with any database related and Oracle SQL scripting issues as required.
• Worked hand in hand with the Management about the various process of Project Life cycle, and did analysis on how to go ahead with it.
• Data analysis and Modeling
• Utilize Erwin to create logical/physical data models.
• Create data model and Mapping Document for individual table.
• Decide Migration strategy for Large number of data.
• Writing stored procedure and function for data migration
• Understand Unix shell script and implement it
• PL/SQL performance Tuning
• SQL and PL/SQL Tuning

Confidential

Data Modeler / ETL Developer

Responsibilities:

• Responsible for maintaining standards for data modeling with Oracle.
• Utilized Erwin to create physical, logical models to generate DDL for DBA's.
• Responsible for integrity and creation of logical and physical data models
• Creation of CDM, LDM, and PDM
• Responsible for creation and maintenance of all data models for Loan Servicing Project
• Responsible for the transformation of LDM to PDM including source-to-target mappings and generation of DDL
• Responsible for collection and definition of meta-data.
• Created and maintained LDM and PDM for new Oracle centralized loan servicing DataMart.
• Transformed LDM to PDM, including source-to-target ETL mappings and generation of DDL.
• Developed scripts for this DW which was in Perl
• Made presentations to team and across the segment on technical issues
• Was actively involved from Development of the Project till the implementation to Production.
• Actively worked with the DBAs to get access and other Oracle related issues that was a major hurdle during the initial phases of this project.
• Took owner ship single handedly and worked onto complete the project

Environment: Erwin 7.3, Toad for Oracle, Microsoft Office Suite, ORACLE10g/11g, PL/SQL, SQL, Business Objects Data Integrator BODI , AIX OS, Vision, Unix Shell scripting, Perl scripting.

Confidential

Data Modeler/ETL Developer

Responsibilities:

• Created LDM, PDM, and generated DDL for various reporting applications within the Oracle Warehouse.
• Utilized ERwin to create logical/physical data model.
• Responsible for the creation of Conceptual data model CDM , LDM, and PDM for new EDW
• Responsible for maintaining enterprise standards for data modeling
• Identify, collect and profile source/application data for Warehouse implementation
• Work with off-shore SAP Business Objects Data Integrator ETL and development teams to provide source to target mappings as well as ETL specs, and business requirements
• Worked with migration team to replace Oracle data Warehouse with Teradata Warehouse.
• Administrator for CA Model Mart

• Lead the team as a senior data modeler in designing and developing aspects.
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• Created and maintained Logical Data Model LDM for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Generated high-level data access documentation for processes.
• Designed Metadata Repository to store data definitions for entities, attributes mappings between data warehouse and source system data elements.
• Documented Data Flow, Granularity requirements, Hierarchy requirements and Product Attributes by Stakeholder groups.
• Conducted all data model reviews as appropriate during project lifecycle.
• Generated First-cut Relational model for DBA
• Coordinated with project DBA to update the physical database model to incorporate high-level design changes table de-normalization, type-code column additions, etc. as they occur
• Profiling data for discrepancy.
• Maintained data model and synchronized it with the changes to the database.
• Developed stored procedures and triggers. Provided input to resolve data limitation and issues.
• Documented Technical Business User Requirements and participated in information and requirements gathering sessions.
• Ensured that business requirements can be translated into data requirements
• Provided other data analysis services, as required

Environment: ERwin 7.3, Toad, Microsoft Office Suite, ORACLE10g/11g, PL/SQL, SQL, Teradata implementations.

Confidential

Data Modeler / Architect / ETL Developer

• Role includes capacity planning, understanding the interfaces for data capturing and the overall technical design of the application related to data warehouse for Risk Information
• Worked with the ETL developers to understand the infrastructure and processes.
• Worked as data modeler to capture the metadata and store this information in Erwin.
• Experience in deriving physical data models from a logical data model and reverse engineering a physical data model
• Experience developing both OLTP and Data Warehousing data models.
• Knowledge of reporting and ETL technologies/methods, including data warehouses, operational data stores, data marts, star and snow-flake schemas.
• Developed use cases, workflow and conversion requirements.
• Prepared business process models used Visio to create use case diagrams
• Ensured data model designs are consistent with client's architectural roadmap and promote extensibility and usability throughout the organization and its external partners and customers

• Analyzed the systems, met with end users and worked with business units in defining the requirements of the project
• Designed logical and physical data models for business users to determine common data definitions and establish referential integrity of the system
• Worked closely with the technical team in analyzing the data and creating the Data Model in Erwin
• Designed data model structure and E-R Modeling with all the related entities and relationship with each entities based on the rules provided by the business manager using ERwin
• Developed mappings, mapplets and sessions between source systems and warehouse components using BODI
• Developed number of complex Data Integrator mappings, mapplets and reusable transformations for the product line profitability systems to facilitate daily, monthly loading of Data
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, sequence generator in extracting data in compliance with the business logic developed
• Developed and scheduled various Pre and Post Sessions, workflows for all Mappings to load data from Source files, Tables to Target tables
• Developed and tested all the backend programs, BODI mappings and update processes
• Created and monitored Sessions and Workflows in the Workflow Manager of Business Objects Data Integrator
• Managed the Metadata associated with the ETL processes used to populate the data warehouse
• Responsible for optimizing mappings, ETL procedures and STAR schemas for improving performance in querying and loading
• Developed the design documents that illustrate program development, logic, coding, testing, changes and corrections

Environment: SAP Business Objects Data Integrator, ORACLE 9i, SQL, PL/SQL, MS-Visio, ERwin, SQL Loader, Win 2000/NT

Confidential

Sr. Technical Support Associate

Responsibilities

• included providing technical support hardware and software to Dell customers across Canada in the 'Home and Small Business' segment
• Additional responsibilities included providing software support to Laptop segment apart from their desktop range of computers
• Made presentations to team and across the segment on technical issues
• Updated and enhanced technical skills to keep at par with evolving technology
• Helped Dell employees with their analytical and time management skills
• Apart from supporting the team responsible for the segment of work I was involved in, I helped improve customer handling techniques and enhanced their communication skills, leading to increased revenues across the segment