SUMMARY

• About 7 years of experience in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Online Transaction Processing(OLTP)and Data Warehousing(OLAP)/Business Intelligence(BI) applications.
• Proficient knowledge in data profiling and develop conceptual, Logical and Physical Data Models.
• Worked extensively on CA Erwin in several projects in both OLAP and OLTP applications.
• In depth knowledge and working experience in Data modeling (Multi - Dimensional& Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, 3NF, Fact and Dimension tables.
• Implemented Slowly Changing Dimensions-Type I, II& III in Dimension tables as per the requirements.
• Worked with project and business teams throughout the software development life cycle to deliver a data model that is consistent with business needs and architectural standards.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes and data relationships.
• Working experience in both traditional Waterfall and sprinted Agile Methodologies.
• Created mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, domain definitions and corporate Meta data definitions.
• Experience in using Forward Engineering and Reverse Engineering functionality.
• Expertise in requirements gathering from users and in supporting user requests for Data Analysis and Reporting.
• Strong understanding of relational databases, querying and building.
• Experience in creating Views for the Data Model.
• Excellent Team player to work with Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers and Business users.
• Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions.
• Good communication and presentation skills.
• Self-motivated and able to work with little supervision.

TECHNICAL SKILLS

Data Modeling Tools: CA Erwin, MS Visio, Power Designer.

Data Base Tools: Oracle, DB2, Teradata, netezza, SQL server.

ETL Tools: Informatica, Abinitio, Oracle Warehouse Builder.

Reporting Tools: SAS, Cognos.

Operating Systems: Windows, LINUX, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Data Modeler

Responsibilities:

• Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.
• Designed Relational Data Model for Enterprise Data Warehouse using CA 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 and business rules in accordance with the Corporate Data Dictionary etc.
• Widely implemented Normalization methods up to third normal form (3NF).
• Worked with DBA to create Physical Data Model (PDM).
• Resolved data type inconsistencies between the Source systems and Data Warehouse.
• Worked with ETL to develop source to target data mapping with transformation rules, physical naming standards, datatypes, domain definitions and corporate Meta data definitions.
• Designed tables for staging and integration layers.
• Created one on one views for downstream users.
• Used Forward Engineering to generate Data Definition Language (DDL).
• Implemented SQL scripts to modify data to resolve the assigned defects.
• Involved in the critical Design review of the finalized database model.

Environment: CA Erwin 9.0, Teradata 14.0, Oracle12g, MS Excel 2010, Abinitio 3.0.

Confidential, TX

Data Modeler

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements.
• Used the Ralph Kimball Methodology for Data Warehouse and Data Mart designs.
• Designed data layer schema using Star and Snowflake Data Models for Enterprise Data Warehouse using CA Erwin.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Developed a Conceptual model using Erwin and Visio based on requirements analysis.
• Created Dimensional Model by Identifying required Facts and Dimensionsusing Logical Data Model.
• Created best-fit Physical Data Model from the LDM.
• Designed Source to Target mapping document with transformation rules, physical naming standards, datatypes and domain definitions for ETL team.
• Implemented the standard naming conventions and created domains in the data model.
• Created and maintained views for the Data Model.
• Generated DDL statements by Forward Engineering and run the SQL scripts.
• Updated SQL scripts when required to resolve issues.
• Used Reverse Engineering to create E-R Diagram to connect to the existing model.
• Redefined many attributes and relationships in the Reverse-Engineering model.

Environment: CA Erwin 8.2, Microsoft Visio 10, Oracle 11g,MS SQL Server2012, oracle ware house builder 11g, Windows 2007.

Confidential, SD

Data Modeler

Responsibilities:

• Gathered complete business and technical requirements byorganizing with Business Analysts and Subject Matter Experts on a regular basis.
• Analyzed various Source Systems and Operational Data Store and research the tables/entities required for the project.
• Designed and Implemented Operational Data Store for dispute management using power designer.
• Participated in design review meeting with business and SME’s to verify the conceptual models.
• Designed and maintained theLogical /Physical Dimensional Data modelsfollowed by generating the DDL statements and physically running them in both test and dev environments for physical creation of tables.
• Worked with DBA to perform intensive data profiling and reverse engineered various already existing databases in order to discern the necessary data relationships underlying general and specific information needs.
• Developed Source to Target mappings for ETL support.
• Participated inmeetingswiththe ETL coding and development team to co-ordinate the process of workflow among the team.
• Created one on one views and involved in the critical Design review of the finalized database model.

Environment: Power Designer 15, DB2 V9.7, Netezza 6, IBM Infosphere data stage 8.5, Cognos 8.1.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements.
• Worked on profiling source data to determine the key consistency, data type, size, etc.
• Worked on logical and physical model using Erwin based on requirements.
• Worked with DBA to create the physical model and database objects.
• Worked closely with ETL team in loading and mapping the data.
• Created Source-to-target (S2T) mapping document as part of Data Analysis.
• Designed tables for staging and integration layers.
• Involved in data migration from staging to integration.
• Implemented the standard naming conventions.
• Worked with DBA in designing to cater initial and incremental load.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Database triggers etc.).
• Dealt with different data sources ranging from flat files, Excel, Oracle, and SQL Server.
• Communicating with the project team throughout all stages of design, managing time effectively, and work on project timelines simultaneously in demanding deadline driven environment.

Environment: CA Erwin 7.2, Oracle10g, UNIX, MS Excel 2007, Oracle ware house builder 10g, SAS 9.2, SQL server10.