SUMMARY

• About 7 years of professional and extensive experience in Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Expert in Dimensional and Relational Modeling.
• Experience in various Pharmaceutical, Financial and Banking Sector domains.
• Experience in gathering, analyzing the business requirements and creating Business Requirement Document (BRD), Technical Specification Document.
• Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Experience in modeling OLTP and OLAP using tools likeErwin r8/r7.1/7.2, Sybase Power designer 12.1 and E - R Studio.
• Well versed in Kimball/Inmon data warehouse Philosophies. Experienced in Normalization/De-normalization techniques for optimum performance in OLTP and OLAP environments.
• Proficient in Software Development Life Cycle (SDLC), Project management methodologies and Microsoft SQL server database management.
• Expert in using Agile Data Modeling methodologies.
• Extensive experience in Data Mapping
• Experience in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, SQL server. Experience in data cleansing, data transformation, data mapping from source to target database.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 7.0/4/0, Power Designer, Embarcadero E-R Studio.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio.
• Worked with various RDBMS like Oracle 9i/10g/11g,SQL Server 2005/2008, DB2 UDB

TECHNICAL SKILLS:

• Oracle Designer
• Microsoft Analysis Services
• Business Objects
• PL - SQL
• T-SQL
• HTML
• XML
• VB.NET
• Microsoft SQL Server 00/08r2
• Teradata 13
• Netezza
• Oracle 10g/11g
• MS Access
• Microsoft Office 2010
• Microsoft Project 2010
• Microsoft Visio
• Share point Portal Server 2003/2007.
• Linux
• UNIX
• Windows
• Agile

PROFESSIONAL EXPERIENCE:

Data Modeler/Data Analyst

Confidential, McClean, VA

Responsibilities:

• Developed a Conceptual model using Erwin based on requirements analysis.
• Produced functional decomposition diagrams and defined logical data model.
• Designed a logical and physical data model using database tool Erwin r8.0.
• Used forward engineering to create DDL from Physical Data Model, based on the requirements from the Logical Data Model.
• Conducted team meetings and Joint Application Design (JAD) session.
• Involved in implementing data warehouse along with architects and data governance teams and consulted the team on the design issues and implementations.
• Conducting the meetings with business users to gather data warehouse requirements.
• Interacted with the Business Analyst, QA team in their testing and DBA’s.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Designed multiple facts and dimensions and implemented data marts.
• Identified and tracked the slowly changing dimensions (SCD I and II) and determined the hierarchies in dimensions.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Involved in Data Mapping activities for the data warehouse.
• Developed monthly summary and downstream data marts from enterprise wide databases in accordance with reporting requirements with dimensions like time, customers, services and accounts.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Handled performance requirements for databases in OLTP and OLAP models.
• Reverse engineered from Toad database to Erwin and generated SQL script through forward engineer in Erwin.

Environment: ERWIN 8.2/9.1 oracle 11g, Teradata 13, SQL server 2008,SSIS, SSRS, MS Excel, Toad for MySQL 6.3

Data Modeler / Data Analyst

Confidential, Westchester, PA

Responsibilities:

• Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing system.
• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards. Conducted Design discussions to come out with the appropriate Data Mart.
• Defined and processed the facts, dimensions. Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling methodology using ER Studio.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using ER studio with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Involved in the integration of data coming from different sources.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts toTeradatadata warehouse.
• Mapped the data between Source and Targets.
• Created data model for the star schema using ER studio, created DDL scripts for static dimensions.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data
• Imported millions of records from .CSV files .TXT files using SQL * LOADER and Test Importer.

Environment: Teradata, Oracle 9i/10g, SQL, ER Studio, Teradata, HTML, TOAD, SQL * LOADER, MS OFFICE.

Data Modeler/Analyst

Confidential, King of Prussia, PA

Responsibilities:

• Built an Operational Data Store (ODS) for transactional system.
• Created Audit Balance Control (ABC) data model, which helps ETL developers to keep track of records from source to target.
• Provided Data quality reports to ETL developers.
• Involved in designing Golden records model, which is used for master data management.
• Created Conceptual, Logical, and Physical data models for operational data store.
• Reviewed Business Case Documents and Business Information Models in detail with Business Analysts, and created all created the data models based on these Business Information models.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models using Erwin - Forward/Reverse Engineer Databases. Performed the roles of data analyst & data modeler.
• Verify data model/schema designs against the business requirements.
• Performed highly complex data analysis for a business intelligence solution.
• Created Source to Target mappings for moving data from one platform to the other.
• Gathered Business Requirements & Business Process Analysis (User & Source Driven); Developed Use Cases; Performed the roles of data analyst & data modeler
• Created Data Flow diagrams for better understanding of data flow within the applications.
• Created Business Information Models.
• Reviewed Data Models with Business and Systems Analysts.

Environment: Teradata, Erwin 8.2.5, Toad Data Analyst, Oracle SQL developer, MS Visio, MS Excel.

Data Analyst/Data Modeler

Confidential, Denver, CO

Responsibilities:

• Worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Analyzed and evaluated existing system for assessing how it supported functions
• Implemented Referential Integrity using primary key and foreign key relationships.
• Involved in Dimensional modeling of the Data.
• Identified the Facts and Dimensions.
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Produced functional decomposition and logical models into an enterprise data model.
• Employed process and data analysis to model a Customer Information Business System.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Created physical data models using forward engineering.
• Modeled a database to store customer demographic and other data.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Developed Logical data model using ERwin.
• Used Erwin for relational database and dimensional data warehouse designs.
• Involved in Data Mapping.
• Conducted logical data model walkthroughs and validation.
• Conducted team meetings and JAD sessions.
• Helped the DBA in creating the physical database design and QA team in their testing.

Environment: Oracle 10g, Toad, ERWIN, Crystal reports 9, Windows XP, Informatica Power Center, Teradata, DB2.