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.