SUMMARY

• 8+ years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in Online Transactional processing (OLTP) and Online Analytical Processing (OLAP), Data Warehousing concepts and ETL Environment.
• Experienced in developing Conceptual, logical models and physical database design for OLTP and OLAP systems using ER Studio and Erwin.
• Expertise in Star schema and Snowflake schema, FACT & Dimensions, Additive and Semi additive facts, Base level fact, Aggregate Fact, Fact less fact, Grain, Data Sparsity, Degenerate dimensions, Junk dimensions, Conformed Dimensions, Hierarchies of Dimensions and Rapid Changing Dimensions.
• Excellence in delivering Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Extensive experience with Normalization (1NF, 2NF, 3NF,BCNF), Super Types, Sub types, Discriminators, Domain, Referential integrity rules and Denormalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Understanding & working knowledge of CDC (Change Data Capture), SCD (I,II,III) and Hybrid SCD.
• Well versed in system analysis, Relational and Dimensional Modeling and implementing RDBMS specific features.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle (V - Model, Waterfall and Agile).
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
• Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimizing the model.
• Participated in JAD sessions for understanding and gathering the business requirements to create Data Mapping documents, use cases, work flows and Power Point presentations, write functional specifications and queries.
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages, Views and Materialized views using SQL/PL SQL. Performance tuning and query optimization techniques in transactional and data warehouse environments.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.5.1, 8x

Data Modeling: ERStudio 11.0, 9.5, 9.1, 8, Erwin8, 7.2.

Databases: Oracle 11g/10g/9i, DB2, SQL Server 2008,Teradata

Job Scheduling & Other tools: TFS 2015, TOAD, SQL Developer, Quality Center9.2, ALM 11.5, Lync, Spark and WinScp.

Environment: UNIX Windows 7/XP/2000.

Methodologies and Others: SDLC Agile, Waterfall, V-model, STLC, PL/SQL, SQL, UNIX Commands.

Functional Knowledge: Retail, Banking, Telecom, Insurance and Healthcare.

PROFESSIONAL EXPERIENCE

Confidential, Lake Forest, IL

Data Modeler

Responsibilities:

• Closely worked with data architects and SMEs to understand the requirement and movement of data.
• Identified and Analysis of various facts from the source system (OLTP) and business requirements to be used for the data warehouse.
• Had meetings with offshore team to understand data model for EMS system.
• Did reverse engineering of Event Management System.
• Found out relationships between entities and redundancy of data columns in EMS.
• Created data lexicon for EMS system so that naming standards can be followed.
• Designed star schema, Hierarchies and Snow Flake schemas for reporting as per BRD.
• Analyzed and defined primary keys, Surrogate keys, Dimensions and Fact according to business requirements.
• Created document for views and mapping sheets to map source columns from source to target.
• Generated data definition language (DDL) scripts using the data modeling tool and manually for the creation of physical objects like tables, indexes, constraints, views and materialized views.
• Created DDL scripts using ERstudio and co-coordinated with DBA’s to apply the data model changes.
• Reviewed Change management requests for DDL to implement changes.
• Worked on enhancing and monitoring SQL Queries using TOAD and SQL Server management S
• Helped in migrating ERStudio diagrams from rep 6.5 to rep 7.0.
• Upgraded ERSTUDO version 9.5 to 11.0.
• Analyzed Old models and defined their dimension (SCD 0,1,2) and facts(Cumulative, aggregate) how they are populating data into tables by looking into PL/ SQL packages and with discussing with ETL developers.
• Co-ordinated with QA team to test and validate data.

Environment: ERstudio 11.0, 9.5, Share point 2013, Oracle 11g, ODI, OWB, PL/SQL,, SQL Server 2008, Microsoft SQL Server Management Studio 2008 R2, Window 8, Lync, Microsoft outlook Toad 12.6, TFS 2015, Microsoft Excel.

Confidential, Farmington Hills, MI

Data Modeler

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Identified and Analysis of various facts from the source system and business requirements to be used for the data warehouse (Kimball Approach).
• Checked for all the modeling standards including naming standards, entity relationships on model and for comments and history in the model.
• Analyzed Logical Data Model (LDM) and Physical Data Model from OLTP systems included documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Worked with data architects and IT architects to understand the movement of data and its storage.
• Designed star schema and Snow Flake schemas for reporting as per BRD.
• Analyzed and defined primary keys, Surrogate keys, Dimensions and Fact according to business requirements.
• Developed Logical data model using ER/studio and created physical data models using reverse engineering.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
• Updated and deleted column definitions as per requirement document according to referential integrity rules.
• Created technical mapping documents for the development team.
• Generated data definition language (DDL) scripts using the data modeling tool and manually for the creation of physical objects like tables, indexes, constraints, views and materialized views.
• Created DDL scripts using ERstudio and co-coordinated with DBA’s to apply the data model changes.
• Provide gap analysis to DBA for changing in data models and maintained traceability matrix for every change.
• Created and updated documents on project and team SharePoint sites for collaboration on documentation and sharing development updates with management and business groups.
• Worked on enhancing and monitoring SQL Queries using TOAD and SQL Developer.
• Co-ordinated with QA team to test and validate the reporting system and its data.
• Suggested effective implementation of the applications, which are being developed.

Environment: ERstudio 9.5, Oracle 11g, Window 7, Informatica IPC 9.5.1, Toad 12.6, ALM 11.5, Microsoft Excel.

Confidential, Charlotte NC

Data Modeler

Responsibilities:

• Interacted with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Set technical direction for projects to ensure data aligns to the strategic vision of data warehouse.
• Improved reporting/ad-hoc query performance by suggesting indexes & aggregations.
• Created and maintained physical & business model in ERwin.
• Identify Custom and Core tables and Dimensions etc.
• Worked on the Payment Business Mart which basically generated report of payments done by customers in various facilities.
• Worked on general maintenance work to maintain and improve the already existing models
• Created a list of domains in ERwin and worked on building up the data dictionary for the company.
• Synched up the models by reverse engineering, compare model and merge model from database to the original models
• Identified and tracked the slowly changing dimensions (SCD I, II, III & Hybrid/6) and determined the hierarchies in dimensions.
• Create and maintained metadata including table, column definitions.
• Worked on building up a Meter Business Mart which tracked various meter readings at different point of times for various customers and measured the demand and consumption of a customer.
• Worked on generating a report on ‘Customer Analytics’ project which calculates the average usage of a customer in the past and predicts the future demand.
• Updated existing models to integrate new functionality into an existingapplication.
• Interacted with the front end customers and resolved BI tickets as accordingly.
• Prepared data elements and current state diagrams of existing data warehouse.
• Created DDL scripts for implementing data modeling changes. Created ERwin reports in HTML, RTF format depending upon the requirement, published data model in model mart, created naming convention files, co-coordinated with DBA to apply the data model changes.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Assisted the ETL Developers and Testers during the development and testing phases.

Environment: Erwin 8, Oracle 10g, DB2, Toad, Quality Centre 9.2, Informatica 8X, UNIX.

Confidential, Kanas city, KS

Data Modeler

Responsibilities:

• Analyzed the data models of the source systems (OLTP) to develop Data Models for OLAP systems for BI reporting.
• Normalized the tables/relationships to attain at optimum and efficient relational schemas.
• Designed Snowflake Schemas by normalizing the dimension tables as per the requirement.
• Migrated data from various sources into main database and performed necessary conversions. Created and modified stored procedures, functions and views.
• Applied business rules in the database using Constraints.
• Involved in performance tuning of queries to achieve high response times.
• Analyzed and resolved performance bottlenecks exception and reconciliation reports. Performed various SQL Server data administration functions.
• Worked with data governanceteam and data compliance teams to maintain the data models, metadata and data dictionaries to define source fields and its definitions.
• Involved in developing metadata repository, data dictionary documentation using interface diagrams and flow charts.

Environment: Erwin 7.2, Oracle 9i, SQL Server, UNIX, Toad.

Confidential, Detroit, MI

Data Modeler / Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Part of the team responsible for the analysis, design and implementation of the business solution.
• Conducted logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Used Model Mart of ER/studio for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Created data mapping documents from source to target systems.
• Performed data profiling in the source systems.
• Performed User Acceptance Testing (UAT), Unit Testing and Documenting.
• Redesigned some of the subject areas and introduced some new entities and attributes as per the requirements and also supported database modifications.
• Designed different type of Star Schemas for detailed data marts and planned data marts in the OLAP environment.
• Developed Conceptual, Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Identified and processed the facts and dimension tables.
• Worked with report developers for building OLAP CUBEs for ad hoc reporting.
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation phase.
• Assisted end users, operations and testing teams by providing them with the necessary documents.

Environment: Oracle 9i and SQL Server2005, ER/studio.