PROFESSIONAL SUMMARY:

• 8+ years of experience in IT industry, with expertise in Data Modeling, Data Analysis and Design.
• Dimensional Data Modeling experience using ER/Studio, Erwin, Multidimensional Data Modeling Schema - Star Join Schema, Snowflake modeling, Fact & Dimension tables, Conceptual, Physical & Logical Data modeling.
• Complete knowledge of Data Warehouse Methodologies Ralph Kimball & Bill Inmon Methodologies. Experienced in building ODS, EDW, Staging and maintaining metadata repository.
• Expert in data analysis, design, development, implementation and design and code reviews for Extraction, Transformation and Loading (ETL).
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Strongly capable of handling VLRDB (Very Large Relational Data Bases) of about 15TB with expert level working knowledge of the architecture involved.
• Expertise in Normalization/De normalization techniques for optimum performance in relational and dimensional database environments.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions).
• Expert at Full SDLC processes involving Requirements Gathering, Source Data Analysis, Creating Data Models, and Source to target data mapping, DDL generation, performance tuning for data models.
• Strong working knowledge and background in multiple databases such as Oracle, SQL Server, DB2, and Sybase.
• Strong experience in writing SQL and PL/SQL, Transact SQL programs for Stored Procedures, Triggers and Functions.
• Responsible for interacting with business users to identify information needs and business requirements for reports.
• A very good understanding of different working domains like Education, Financial, Banking, Insurance, Health Care and capable of blending in any environment.
• Excellent team member with interpersonal and communication skills, highly motivated, result oriented with strong analytical, organizational, presentation and problem solving skills.
• Expert in developing effective working relationships with client team to understand support requirements, developed tactical and strategic plans to implement technology solutions, and effectively manage client expectation.

TECHNICAL SKILLS:

Data Modeling: ER/Studio 9.0/7.6.1/7.5.1/7.0, Erwin 7.3/7.0/6.5

ETL Tools: Informatica 8.6/7.1.4/6.0/5.0, SSIS, Data Services 3.2, Datastage 8.5

Databases: Oracle 11i/10g/9i/8i/7.x, SQL Server 2008/2005/2000, DB2 UDB 9.x/8.x/7.x, Sybase 12/11

Programming Skills: SQL, PL/SQL, T-SQL, C, C++, C#, HTML, DHTML, XML

Operating Systems: Win 95/NT/98/2000/XP, Win 7,Win 8 LINUX

Tools: Toad 8.5/7.4/7.3, MS-Office, MS-Visio, Ultra edit, SQL Developer

Reporting Tools: Business Objects XI R3 v 3.1/ XI R2, SSRS, Cognos, SSAS

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Modeler

Responsibilities:

• Involved in gathering complete requirements by organizing and managing meetings with Business Analysts, Data Stewards and subject matter experts on a regular basis.
• Interacted with business users to clarify on business logic required for the data models.
• Analyzed OLTP source systems and Operational Data Store and research the tables/entities required for the project.
• Designing the measures, dimensions and facts, matrix document for the ease of designing.
• Analyzed the specifications and identified the source data from disparate data sources like Oracle, MS SQL Server and flat files that needs to be moved to data warehouse.
• Designed and maintained the Logical /Physical dimensional data models and generating the DDL statements and working with the database team in creating the tables, views, keys in the database.
• Performed Data profiling and identified the risks involved with data integration to avoid time delays in the project.
• Generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures.
• Performed Data scrubbing for removing incomplete, irrelevant data and maintained consistency in the target data Warehouse by cleaning the dirty data.
• Worked on specifications given by the Data governance team and Data quality team that required managing the master data from all the business units and ensuring data quality across the enterprise.
• Validate the models with the production data and developed the Source to Target mapping matrix, an expert solutions to design and develop the mappings for the loading of data, to the ETL developers.
• Conducted frequent meetings with my ETL coding and development team to co-ordinate the process and to efficiently organize and distribute the workflow among the team.

Environment: Orac1e 11i, ER Studio 9.0, Microsoft Visual Source Safe, SSIS, SQL Server 2008, T-SQL, PL/SQL, TOAD 8.5.

Confidential, New York

Senior Data Modeler

Responsibilities:

• Gathered and analyzed requirements from the end users and converted functional specifications to technical specifications documents.
• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Created Data Model from scratch which involved a complete life cycle implementation that encompassed business requirement gathering, analyzing their source systems; and then building financial data mart in order to provide functionality for their reporting purposes.
• Created conceptual, logical & physical data models with Erwin and did design review meetings with other team members in order to finalize the model.
• Implemented advance modeling concepts like Bus Matrix Architecture, Resolving Multi Valued dimensions, and Conform dimensions, Junk dimensions, Degenerate dimensions in designing multi dimensional model.
• Created and developed Slowly Changing Dimensions tables SCD2, SCD3 to facilitate maintenance of history.
• To maintain the consistency and quality of the data worked with Data Governance, Data Profiling and Data Quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.
• Developed and maintained enterprise data dictionary by interacting with data steward, data governance team.
• Divided model into subject areas for reflecting understandable view to business as well as data model reviewers.
• Created DDL for physical model using Erwin and handed over to the DBA team.

Environment: Orac1e 11i, ER Studio 9.0, Microsoft Visual Source Safe, SSIS, SQL Server 2008, T-SQL, PL/SQL, TOAD 8.5.

Confidential

Data Modeler/Analyst

Responsibilities:

• Responsible for taking requirements from business users, understanding business needs by scheduling meeting at regular basis.
• Analyzed OLTP source systems and Operational Data Store and research the tables/entities required for the project.
• Implemented dimension model (logical and physical data modeling) in the existing architecture using ER Studio.
• Implemented advance modeling concepts like accumulating snap shot grain, periodic grain, transactional grain, factless facts.
• Conducted data model review meetings with development, and data team to communicate business requirements.
• Generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures.
• Worked on specifications given by the Data governance team and Data quality team that required maintaining database policies and managing the master data from all the business units and ensuring data quality across the enterprise.
• Worked on Data profiling to check invalid values, nulls percentage and data related in tables..
• Developed Source to Target matrix which contains the transformation logic and handed it over to ETL Team.
• Assisted Business Intelligence team in generating various interactive reports.
• Implemented Performance tuning at source, target, mapping, session and system levels.
• Performed testing on a data warehouse platform, including data integrity and data validation.

Environment: Oracle 9i, MS SQL Server 2005, DB2 UDB 7.2, Informatica Power Center 7.1.4, TOAD 8.5, SQL, PL/SQL, UNIX Shell Scripting, ER Studio 8.0, Star Schema, Flat files and MS-Office tools.

Confidential, Madison, WI

Data Analyst/Modeler

Responsibilities:

• Gathered business requirements by organizing and managing meetings with business stake holders, development sub-dimension teams and analysts on a scheduled basis.
• Involved in design and development of data warehouse environment, liaison to business users and technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
• Implemented four step design process comprising of analyzing business process, identify the grain, used star schema design for building fact and dimension tables.
• Identified multiple dimensions and fact tables. Used advance data modeling concepts of degenerated dimension,, factless fact table, aggregate fact tables in multidimensional model.
• Applied Master Data Management to create and maintain consistent, complete, contextual, and accurate master data.
• Generated DDL’s for the models and handed it over to the DBA team.
• Performed data cleansing/scrubbing for removing incorrect data in a database, incomplete, improperly formatted, or duplicated for ensuring the consistency in the target system.
• Worked on Informatica Power Center source analyzer, warehouse designer, mapping designer, workflow manager, mapplets and reusable transformations.
• Did design reviews as well as code reviews of ETL mappings and worked in parallel with ETL developers.
• Worked with DBA to trace the bottlenecked queries and did performance tuning.

Environment: Erwin 6.5, Informatica Power Center 6.0, SQL Server 2005, PL/SQL, Windows NT, MS Office Tools.

Confidential, Simsbury, CT

Data Analyst

Responsibilities:

• Interacted with business users to clarify on business logic required for the data models.
• Involved in gathering complete requirements by organizing and managing meetings with Business Analysts, Data Stewards and subject matter experts on a regular basis.
• Analyzed OLTP source systems and Operational Data Store and research the tables/entities required for the project. Designing the measures, dimensions and facts matrix document for the ease while designing.
• Analyzed the specifications and identified the source data from disparate data sources like Oracle, MS SQL Server and flat files that needs to be moved to data warehouse.
• Designed and maintained the Logical /Physical dimensional data models and generating the DDL statements and working with the database team in creating the tables, views, keys in the database.
• Performed Data profiling and identified the risks involved with data integration to avoid time delays in the project.
• Performed Data scrubbing for removing incomplete, irrelevant data and maintained consistency in the target data warehouse by cleaning the dirty data.
• Worked on specifications given by the Data governance team and Data quality team that required managing the master data from all the business units and ensuring data quality across the enterprise.
• Validate the models with the production data and developed the Source to Target mapping matrix, an expert solutions to design and develop the mappings for the loading of data, to the ETL developers.
• Conducted frequent meetings with my ETL coding and development team to co-ordinate the process and to efficiently organize and distribute the workflow among the team.

Environment: ER Studio 4.5, Informatica Power Center 5.0, Oracle 8i, SQL Server 2005, Flat files, SQL/PL SQL, Win 2000/NT.

Confidential

Database Developer

Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams.
• Established frameworks for ER modeling, database design and schema maintenance.
• Created normalized models for various OLTP applications.
• Involved in the coding of stored procedures and triggers using PL/SQL for various business requirements.
• Designed and developed all the tables, views for the system in Oracle.
• Modifying the database design and as necessary from time to time upon information given by the application users and developer.
• Designing and developing forms validation procedures for query and update of data.

Environment: Oracle 8.0, PL/SQL, Forms 4.5, Reports 2.5, Windows NT.