PROFESSIONAL SUMMARY:

• Over 9 years of experience in the IT industry and have proficiency in Data modeling, Data analysis, system analysis and ETL development.
• Full life-cycle systems development experience at corporate enterprise levels, dedicated to deployment of Business Intelligence System applications extracting the data from Data Warehouses, ODS, Data Marts, with the help of ETL tools for optimizing Business Decision Support Systems.
• Had good experience in understanding and gathering the business requirements by conducting and participating in joint application development (JAD) sessions by interacting with the end users and then converting them into the data bus matrix and also creating the conceptual diagrams and use case diagrams.
• Very strong in Data Integration skills, data modeling, data analysis skills, and data warehousing skills, Star, Snowflake, & dimensional data modeling, extensive OLAP analytical skills, , and Business Intelligence applications using Ralph Kimball and Bill Inmon methodologies.
• Experienced in using ER Studio Repository to store the data in the repository so that they can be checked out and checked in by the other members in the team.
• Strong and dealt with data modeling concepts like star schema, junk dimensions, different types of OLAP systems like ROLAP and MOLAP, granularity, rapidly changing dimensions, fact less fact tables, junk dimensions, families of stars, transactional tables, snapshot and aggregate fact tables.
• Core experience with Data Mapping, Conceptual, Logical, and Physical data modeling (3NF) using Erwin E/R Studio and ER studio data architect9.0, with both transactional (ODS) and dimensional (EDW) constructs. Developed enhancements to the Master Data Management Initiative, focusing on corrections and extensions to the master data.
• Experienced in forecasting the data space requirements using the features like Capacity planning, mapping source to target data using data lineage feature and also calculating the impact analysis.
• Proficiency in implementing Normalization, Denormalization, Change data capture(CDC), DB2 and Terra data.
• Had good knowledge in HIPAA EDI standards, 21 CFR part 11, GMP, GLP.
• Involved in creating macros to meet the requirements, data dictionaries and maintained metadata for each model.
• Was involved in understanding the structure and making changes to the underlying database using the reverse engineering technique.
• Proficiency in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Implemented Slowly Changing Dimension methodology like SCD1, SDC2, SDC3 and SDC6 for accessing the full history of accounts and transaction information
• Expertise in SQL/PLSQL programming, developing & executing Packages, Views, cursors, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views, Clusters, Indexes, Sequences etc...
• Extensively worked on various transformations such as Expression, Aliasing, Joins, Constraints, Create, Alter Database, Update Strategy, Union, Normalizer, and Sequence Generator etc. to load consistent data in to Oracle, SQL and Teradata databases.
• Maintained good relationships with the clients, understanding the business requirements and delivering the desired results within the proposed time frame.

TECHNICAL SKILLS:

TOAD, SQL Developer, Oracle SQL Plus

Data Modeling

Erwin Data Modeler , ER Studio Data Architect 9.0, OLAP, ROLAP, MOLAP, Sybase Power Designer

Programming Languages

SQL, PL/SQL, C, C++, Java.

Environment

Windows 2000,NT

Other

MS-Office, MS- Excel, Ms- Word, Power Point

KNOWLEDGE AND TRAINING

• Application Development
• Data Warehousing
• Data Analysis
• Terra data
• Logical and physical Data Modeling
• Data Architecture
• Erwin
• Oracle 7/8x/9i/10g/11g
• Sybase Power Designer

PROFESSIONAL EXPERIENCE:

Confidential,Madison WI
Oct 2011 to Present

American Family Insurance is the biggest client of Causality and Property Insurance in Madison WI. The project with AMFAM deals with updating their old legacy systems DB2 systems with new Advance systems with Oracle Database. This includes designing all the source systems and their intermediate Data Warehouse which they call Conformed Storage Area and building Analytical Data Marts (ADL) with the new requirements. The project follows the agile workshop with a lot of releases and daily updates about the project in scrum meetings.

Responsibilities:

• Involved in several Architecture meetings, SAD Review meetings, Daily Scrums, Release Retrospectives and weekly Modeler meetings.
• Designed new American Family Advance customer systems
• Designed ODS,EDW and Marts for customer systems
• Highly involved in depth in Customer Subject Area
• Designed Household systems and was involved in meetings, SAD sessions on grouping customers to Household,
• Involved in discussions in standardizing Addresses of Customer by applying Code1 standards, National Change of Address
• Involved in modeling source systems, ODS, EDW and Marts for Policy Center Subject Area
• Heavily involved in Policy Center subject area discussions, designing different type or risk dimensions, policy dimensions, endorsements, limits and deductibles
• Identified and designed Analytical Data Marts for policy activities, Risk Activities and designed models which give their snapshots monthly, Quarterly and yearly
• Worked extensively in a project of Reference Master which is a concept used with every clients of single source all codes and descriptions which needs look up.
• Worked with Data Governance team in providing rules of conformity of codes for different reporting purposes and for providing definitions for new requirements.
• Worked in Modeling different coverage’s that are widely used in Insurance Industry
• Designed and modeled several kinds of tables like Associative tables, transactional tables, Base tables, Delta tables, Junk Dimensions, Reference tables.
• Used ER Studio, ER studio Repository and ER studio Portal as modeling tool
• Involved in Modeling Logical and Physical models from the conceptual models,
• Developed physical models and applied class words, naming standards, added new acronyms, abbreviation’s if needed.
• Applied Kimball Technologies like Normalization, Bridge tables, conformed dimensions, junk dimensions, transactional tables, slowly changing dimensions tables like type 1 called base tables, type 2 called Delta tables in AMFAM.
• Worked with Relational Models , star schemas, Dimensional models

Confidential,Tampa, FL
Role: Data Modeler/Architect
June 2011 to August 2011

Wellcare Health Plans Inc had its IT office located in Tampa, .The project in Wellcare deals with changes to the data models considering the data coming from 4010 and keeping in mind of the 5010 data. The project deals with identifying new fields coming from the implementation guides of the 4010 and 5010 and adding those fields to the data models.

Responsibilities:

• Involved in JAD sessions in understanding the business requirements and from the BRD document and implementing the changes in the model.
• Used the Implementation guides of 4010 and 5010 of all Institutional, Professional and Dental.
• Identified the ODS source table names and creating them in data model.
• Used Sybase Power Designer as a Data Modeling tool.
• Applied changes to the logical data model and generating the physical model out of it taking care of the indexes, foreign key constraints, references, and then generating the ddl out of the model and giving it to the developers to go on with the deployment and development.
• Used 4010 and 5010 Guides and worked with the EDI transactions like 835, 837, 820.
• Used the techniques like star flake, bridge table, confirmed dimensions, flattening out the dimension in the cases where they need to be implemented.
• Involved in Normalization of data to remove redundancy.
• Collected data from the source OLTP systems and implemented the changes in the model.
• Involved in the data migration, data lineage and also studying the data impact analysis.

Confidential,Detroit, MI
Role: Data Modeler
May 2009 to June 2011

Blue Cross and Blue Shield of Michigan (BCBSM) which is formed in 1939 are providing health care services to the people of Michigan more than 70 years. The project deals in translating business goals and strategies into IT implications and implementations. The project deals in creating predictive data models which can be used to target costumers for direct marketing campaigns and to extract and aggregate consumer data as needed for model development.

Responsibilities:

• Involved in understanding the business process from the business requirement document, interacting in the JAD sessions and generating the bus matrix
• Had good knowledge in HIPAA EDI standards, 21 CFR part 11, GMP, GLP.
• Involved in creating the conceptual diagrams, use cases and Entity relationship diagrams if needed by the requirement.
• Used techniques like the degenerate dimensions for creating unique policy number.
• Involved in creating star schemas, family of stars, snowflake schemas, and confirmed dimensions.
• Forecasted the data requirement for the tables using the capacity planning tool.
• Interacted with multiple users to collect Requirements and converted them into a Design Document
• Involved in Normalization of data to remove the redundant data.
• Implemented the 2nd level slowly changing dimension (SCD) while any modification on the data base to track the changes on the table over a particular period of time.
• Involved in the data migration, data lineage and also studying the data impact analysis.
• Involved in all phases of Software Development Life cycle (SDLC) from requirement, design and testing
• Collected the data from different OLTP systems based on the requirement.
• Mapped data from the OLTP system to the OLAP systems.
• Dealt with reverse engineering in cases where needed to study the underlying database.
• Developed Data models logical, physical and Dimensional.
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules.
• Involved in all phases of data quality assurance.
• Generated the Exception error list, reports, and correction list.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries

Environment used: Oracle11g, Erwin7.3, Windows XP, PL/SQL, and MS OFFICE 2007 SUITE INCLUDING EXCEL AND MS ACCESS.

Confidential,IL
Role: Data Modeler/Data Architect
May 2008 to May 2009

Sears is the fourth largest retail chain in the United States. The project in sears deals in providing analytical and design leadership in IT&G re-engineering initiatives which needs to have strong data profiling, modeling and profiling skills. The project also deals in data modeling, design and analysis of for both project and day to day support of Enterprise data warehousing, data marts and future systems. The project also deals with maintaining the Teradata.

Responsibilities:

• Involved in creating conceptual models, use case diagrams,
• Experience in using ARTS data model.
• Had Good understanding of several retail frameworks like Zachman and RUP
• Created logical models from the existing entity relationship diagrams(ER diagrams) and converted them into physical models.
• Obtained data from different main frame systems and mapped them to the data bases.
• Designed Star Schema for dimensional modeling and used methodologies of Degenerate dimension, Role Playing dimension, Faceless fact table, Aggregate fact table, Rapidly Changing dimensions etc.
• Application of techniques like star schema, snow flake schema, conformed dimensions, family of stars, conformed dimensions in creating the data models.
• Used 3 levels of slowly changing dimensions to update the data in the database.
• Was involved in creating some MACROS for making the process run better and also created data dictionaries for the different data type and defined their domains.
• Involved in Mapping of Data elements between multiple database systems.
• Responsible for Relational data modeling(OLTP) using ERwin (Logical and Physical)
• Involved in maintaining DB2 and Teradata in the project.
• Modified the existing database objects to meet the expanding business requirements.
• Involved in Capacity planning, data lineage, and also calculating the Impact analysis.
• Created database objects like Tables, Indexes, Sequences and Views etc
• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries
• Developed various Forms for the application involving modules to segregate the data.
• Written Stored Procedures to perform Validations on data and to move data from staging tables into the Base tables.
• Responsible for creating the technical design document.
• Involved in Development, Testing and Maintenance of the System.

Environment used: Oracle 10g, Erwin, ER studio data architect, DB2 and Teradata.

Confidential,Richmond, VA
Role: Data Modeler
May 2007-May 2008
Capital One is a U.S based bank holding company specialized in credit cards, auto loans, home loans, banking and saving products. The project here is to define data requirements and business rules, gathering and refining those data requirements and to write data definitions for metadata and finally to generate review models for accuracy, adherence to standards and architectural conformity.

Responsibilities:

• Interacted with multiple users to collect business Requirements and converted them into a Business requirement document.
• Directed the people under Supervision to work as a team to implement the various tasks delegated to them in the most efficient way (On-shore and off-shore).
• I was involved in creating entity relationship diagrams and then converting them into logical and physical model
• I also dealt with reverse engineering the underlying database and understanding the entity relationships.
• I was involved in updating the existing database by adding the new requirements.
• I updated the logical model by designing new dimensions, facts in the fact table and dimension table as per the requirement.
• Involved in all phases of SDLC from requirement, design, develop and testing.
• Studied the existing ODS by reverse engineering the underlying data base.
• Developed Data models logical, physical and Dimensional (Snow Flake Schema)
• Extensively worked over the online tracking system TEAM TRACK for work-requests, database change request issues.
• Extensively worked on DALs (Data Access Layer) which means changes in DATABASE (Create, modify, alter, etc.) on the Tables, view, MVs (materialized view), Stored Procedures.
• Involved in forecasting the table space requirement’s using Capacity Planning tool
• Experienced in source to target data mapping using Data lineage technique and also calculating the impact on the data flow using Impact Analysis.
• Involved in Normalization of data to remove the redundant data
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules.
• Developed Dynamic SQL to build complex queries.
• Created Schemas, Databases, Tables, Views and Indexes
• Wrote Row Level and system level and DML level Triggers
• Generated the Exception error list, reports, and correction list.
• Involved in Data development, modify tables, views, Materialized View, stored procedures.
• Involved in gathering data from OLTP systems and creating ER diagrams.
• Participated in Unit testing, Integration testing, User Acceptance testing.

Environment used: Oracle 10g, SQL, PL/SQL, ER Studio