SUMMARY

• Nearly 7+ years of professional experience and in - depth knowledge in the Information Technology industry with a comprehensive knowledge in the area of data modeling and data analysis for the OLTP and OLAP environment in Windows and Unix platforms for various domains.
• Nearly 7 years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling along with designing and supporting of various applications in OLTP, ODS, Enterprise Data Warehousing, Data Mart, OLAP and ETL environment
• Expert in designing and implementing Data Model Applications using oracle environment for various domains
• Proven ability in gathering and translating business requirements into technical designs and development of the physical aspects of a specified design
• Excellence capability of delivering Conceptual, Logical and Physical Data Models for various projects in both new enterprise application development environment as well as existing application modification environment
• Experienced in identifying entities, attributes, metrics, and relationships with a proven ability of assigning keys and optimizing the model
• In - depth understanding of Waterfall, Spiral and Agile methodologies of Software Development Life Cycle (SDLC) from requirement analysis through design, development and implementation
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as de-normalized Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies
• Extensive experience in using ER modeling tools such as ERwin and ER/Studio.
• Excellent SQL and PL/SQL programming skills and used it to develop Stored Procedures, Triggers, Functions,Packages
• Extensive experience with Normalization(1NF, 2NF, 3NF) and De-normalization techniques for improving database performance in OLTP and Data Warehouse/Data Mart environments
• In-depth knowledge of the principles of Data Warehousing, Fact Tables, Dimension Tables, Star and Snowflake Schema, Primary and Foreign Key concepts, Referential Integrity and Slowly changing dimensions (Type I, Type II and Type III)
• Extensively worked on Forward and Reverse Engineering process, generated DDL scripts and Indexing strategies for implementing changes in Data Modeling
• Hands on experience in creating Erwin reports in RTF, HTML format based on the requirements, published data model in Model Mart, created files using naming conventions, coordinated with DBA teams to apply the data model changes.
• Experienced in identifying the Facts and Dimensions from the Enterprise Architecturefor designing the Star and Snowflake Schema
• Experience in logical/physical database design and review sessions to determine and describe data flow and created sources to target data mapping documents
• Extensive working knowledge with ETL developers to test and validatedataattributes and with other business analysts to assuredatais integrated consistency regardless of the source systems
• Excellent problem solving and analytical skills with exceptional ability to learn new technologies efficiently with a proven written and oral communication skills

TECHNICAL SKILLS:

Analysis and Modeling Tools: ERwin 7.2/7.0,8.0; Sybase Power Designer; Oracle Designer; ER/Studio, MS Visio

ETL Tools: Informatica Power Center 8.6.1/9.5

Languages: SQL; PL/SQL; T-SQL; XML; HTML; UNIX Shell Scripting

Databases: MS SQL Server 2008/2005; Oracle11g/10g/9i; DB2 V9.5; Teradata V2R6.1; MS Access 2000

Operating Systems: Windows 7/XP/2000/98; UNIX (Sun Solaris 10); Linux

Project Execution Methodologies: RalphKimball and Bill Inmon data warehousing methodologies; Rational Unified Process (RUP); Rapid Application Development (RAD);Joint Application Development (JAD)

PROFESSIONAL EXPERIENC

Data Analyst

Confidential, Spring Field, IL

Responsibilities:

• Gathered business requirements through participating in various meetings with difference cross functional teams such as business stake holders, business analysts, application architects, technical architects, ETL developers and IT analysts on a scheduled basis;
• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization;
• Extensively analyzed the data recodes, and profiled it before moving forward to building data marts;
• Responsible for loading, extracting and validation of client data.
• Analyzed the functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Analyzed raw data, drawing conclusions & developing recommendations after discussing with different business users, cross functional teams, and DBAs.
• Created the conceptual model for the data warehouse with emphasis on insurance (life and health), mutual funds and annuity using ERwin data modeling tool.
• Developed logical/ physical data models using ERwin across the subject areas based on the specifications and established referential integrity of the system.
• Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
• Demonstrated that tables are appropriately modified according to the BRD.
• Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Created the DDL scripts using ERwin and source to target mappings for ETL developer to bring the data from JDE to the warehouse.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Worked on Database Normalization and converting datasets to 3NF.
• Worked with the DBA to implement performance query tuning of the database when needed.
• Involved with ETL team for writing T-SQL scripts to manipulate data for data loads and extracts.
• Worked with Toad to understand the existing tables and load the new designed tables.
• Involved in data entry, data auditing, creating data reports & monitoring all data for accuracy.
• Involved in updating metadata repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• 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 DBAs’ to apply the data model changes.
• Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.

Environment: ERwin, Oracle 11g, PL/SQL, SQL*Plus, Toad, HTML, XML, UNIX.

Confidential, St. Louis, MO

Data Modeler/Data Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users;
• Map business needs/requirements to subject area model and to logical enterprise model;
• Created logical data model from the conceptual model and it’s conversion into the physical database design using Power Designer;
• Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities;
• Developed the data warehouse dimensional models &schema for the proposed central model for the project.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using ER/Studio tool.
• Worked on the Snow-flaking the Dimensions to remove redundancy whenever required;
• Used 3NF normalization logic to store the relational database into the data warehouse;
• Developed logical and physical data models using ER/Studio tool across the subject areas based on the specifications and established referential integrity of the system.
• Analyzed the existing Operational Data Store systems to understand the entities and attributes for using them in the dimensional models;
• Involved and identified the Facts and Dimensions for creating and managing the dimensional models;
• Implemented the standard naming conventions for the facts, dimensions, entities and attributes of the logical and physical models;
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the Logical Data Models;
• Reviewed the logical model with the business users, ETL teams, BDAs, and testing teams to provide information about the data models according to the business requirements;
• Worked with ETL developers to understand and create the source to target mappings documents;
• Created the logical model for the EDW with approximate entities and attributes using ER/Studio. The logical model was fully attributed till 3rd normalize form and contains both current and history tables;
• Worked with the client and off shore team to make sure that the reports and dashboards are delivered on time;
• Involved in high level ETL design review sessions and assisted ETL developers in the detail design and development of ETL maps using Informatica;
• Used SQL on a wide scale for analysis, performance tuning and testing.

Environment: ER/Studio, Oracle 11g, PL/SQL, SQL*Plus, Toad, DB2, MS Excel, HTML, XML, UNIX.

Confidential, Cleveland OH

Data Modeler/Data Analyst

Responsibilities:

• Closely worked with business analysts in the process of requirements gathering for various application specific databases;
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements;
• Developed the logical data models and physical data models that confine existing condition/potential status data fundamentals and data flows using Power Designer;
• Created the DDL scripts using Power Designer and source to target mappings for ETL developer to bring the data from JDE to the warehouse;
• Worked on Database Normalization and converting datasets to 3NF;
• Worked with Toad to understand the existing tables and load the new designed tables;
• Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards;
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Power Designer after analyzing the database systems that is currently in use;
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design;
• Ensured that the logical model is compliant with the conceptual model and all the high-level business rules and integrated and document;
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology;
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata;
• Used data profiling tools and techniques to ensure data quality for data requirements;
• Extensively used SQL for performance tuning.

Environment: Power Designer, Oracle 9i, Oracle Designer, SQL Server 2008, Crystal Reports 9, XML, Rational Rose and SQL Server Reporting Services.

Confidential, Hartford, CT

Data Modeler/Data Analyst

Responsibilities:

• Interviewed the end users for gathering information to determine requirements, data, report requirements, analysis, metadata, performance and data quality;
• Participated in JAD sessions with various teams to finalize the required data fields and their formats;
• Developed Logical and Physical Data models for according to the new business requirements by using Erwin;
• Extensively used Agile methodology according to the Organization Standards to implement the data models;
• 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 plan data marts in the OLAP environment;
• Used Entity-Relationship Diagramming to create new database design via Erwin;
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements for projects;
• Developed the logical and physical data models that confine existing condition/potential status data fundamentals and data flows using Erwin;
• Ensured that the logical model is compliant with the conceptual model and all the high-level business rules and integrated and document;
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology;
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata;
• Used data profiling tools and techniques to ensure data quality for data requirements.
• Extensively used SQL for performance tuning;
• Developed and executed queries in SQL for reporting using Toad;
• Worked with the business users and ETL developers to analysis and resolve the data related problem tickets and other defects.

Environment: Erwin, Windows XP, SQL Server 2005/2008, SQL, Oracle 8i, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro.