SUMMARY

• Seven years of IT experience as Data Modeler and Data Analyst in Insurance, Manufacturing, Airport Parking, Financial, Pharmaceutical, Telecommunication.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML.
• Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME’s to obtain domain level information of projects.
• In depth understanding of Gap Analysis for AS - IS and TO-BE business processes, risk, impact and feasibility analysis.
• Proficient in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Understanding in development of Conceptual, Logical and PhysicalModels for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Good understanding of Agile (SCRUM) and Waterfall technologies.
• Extensive work experience in Entity-Relationship diagrams, Dimensional Modeling (Star Schema/ Snowflake Schema) and Data Warehousing.
• Proficient in Normalization (1NF/2NF/3NF) /De-normalization techniques in relational/dimensional database environments.
• Skillful in Data Analysis using SQL on Oracle, MS SQL Server, DB2 & Teradata.
• Excellent experience in trouble shooting SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Involved in the maintenance of enterprise metadata repositories.
• Expertise in Physical Modeling for multiple platforms such as Oracle/Teradata/ SQL Server/DB2.
• Identified Slowly Changing Dimensions and hierarchies.
• Designed data marts using Ralph Kimball and Bill Inmon dimensional data modeling techniques.
• Extensively worked on Forward Engineering and Reverse Engineering.
• Experienced in Performance Tuning on oracle databases by leveraging explain plans, and tuning SQLqueries.
• Proficient in writing DDL, DML commands using SQL developer and Toad.
• Expertise in performing User Acceptance Testing (UAT) and conducting end user training sessions.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS

Data Modeling Tools: Erwin7/8, MS Visio 2007/2010, ER Studio, Oracle Designer.

Database Tools: Microsoft SQL Server 2008 Oracle 9g/10g/11g, PL/SQL, MS Access,Teradata.

Reporting & Other Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), OLAP(Online Analytical Processing), Multi-dimensional Cubes and Business Intelligence & Development Studio, SQL BI

ETL Tools: SSRS, SSAS, SSIS (SQL Server Integration Services), Data Transformation Services (DTS), Informatica.

Environment: Windows, UNIX, Linux.

Languages: SQL, PL SQL, T SQL, XML,VB Script, Java Script.

Packages: Microsoft Office 2007/2010, Microsoft Project 2010, Microsoft Visio, Share point Portal Server 2003/2007.

PROFESSIONAL EXPERIENCE

Confidential, Northbrook, Illinois

Sr. Data Modeler / Data Analyst

Responsibilities:

• Worked with Business Analyst for requirements gathering, business analysis and project coordination.
• Developed aConceptual Model and Logical Modelusing Erwin based on requirements analysis.
• Created the best fit Physical Data Model based on discussions with DBAs and ETL developers.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Worked on data mapping process from source system to target system.
• Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Extensively used Star and Snowflake Schema methodologies.
• Worked on Slowly Changing Dimension tables.
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose.
• Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Environment: Erwin r8.2, Oracle SQL Developer, Oracle Data Modeler, Teradata 14, SSIS, Business Objects, SQL Server 2005/2008, ER/Studio Windows XP, MS Excel.

Confidential, Indianapolis, IN

Sr. Data Modeler / Data Analyst

Responsibilities:

• Coordinated in requirements gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Developed Conceptual model using Erwin based on requirements analysis.
• Worked with Business Analyst during requirements gathering and business analysis to prepare high level Logical Data Models and Physical Data Models.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
• Prepared data dictionaries and Source-Target Mapping documents to ease the ETL process and user’s understanding of the data warehouse objects
• Implemented the slowly changing dimension (Type II) and determined the hierarchies in dimensions.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML.
• Exhaustively collected business and technical Metadata and maintained naming standards.
• Extensively used reverse engineering feature of Erwin to save the data model with production.
• Used Erwin data model mart for storing different versions of the model.
• Involved in maintenance of models and loading models to Metadata Repository.
• Involved in data analysis of the Teradata.
• Responsible for integrating the work tasks with relevant teams for smooth transition from testing to implementation phase.

Environment: Erwin 8.0, SQL, SQL Server 2012, Teradata, SQL Assistant 12.0/13.11, Data stage 8.1, DB2.

Confidential, Atlanta, GA

Data Modeler / Data Analyst

Responsibilities:

• Demonstrated strong analytical skills in identifying and resolving data exchange issues.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management.
• Executed enterprise Data Governance strategies in line with the organization’s business strategies and objectives.
• Good experience in data analysis querying and writing in SQL and TOAD.
• Extensively used Data Tools to maintain consistent data.
• Performed Data Stewardship roles like implementing data standards, creating metadata and managing databases.
• Performed data conversion from multiple sources and verified validation test on the converted data.
• Good understanding and experience with the entire Data Migration process from analyzing the existing data, cleansing, validating, translating tables, converting and subsequent upload into new platform.
• Used E.F Codd’s Normalization (1NF, 2NF & 3NF) and Denormalization techniques for effective performance in OLTP and OLAP systems.
• Designed data models in Dimensional Modeling (DM) environment.
• Executed SQL queries to retrieve data from databases for analysis.
• Created Data Model Reports and Data Dictionary (DD) using ERWIN.
• Developed normalized Logical and Physical database models to design OLTP system for enterprise applications.
• Performed forward engineering operations to create a physical data model with DDL that best suits requirements from the logical data model.

Environment: CA Erwin 8, Oracle10g, SQL server 2012, IBM DB2, Informatica Power Center 8.6, SQL BI 2008, Oracle BI, Visual Studio, SSIS&SSRS, SQL server management studio 2012.

Confidential, New York City, NY

Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in developing Conceptual Data Model and conducted controlled brainstorming sessions with project focus groups.
• Identified the Objects and relationships between the objects to develop a logical model and translated the model into physical model using Forward Engineering in ERWIN.
• Conducted logical data model walkthroughs and validation.
• Used Model Marts to understand different versions of data models existing in the system.
• Involved in dimensional modeling in identifying the Facts and Dimensions and different hierarchies.
• Used Erwin tool for relational database and dimensional data warehouse designs.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Worked extensively on SQL querying using Joins, Alias, Functions, Triggers and Indexes.
• Managed all indexing, debugging andquery optimization techniques forperformance tuning usingT-SQL.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Worked with business analyst to design weekly reports using combination of Crystal Reports.
• Understood existing data model and documented suspected design affecting the performance of the system.

Environment: Erwin 7.2, SQL Server 2008, SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, TOAD.

Confidential

Data Modeler

Responsibilities:

• Interacted with the business users on regular basis to consolidate and analyze the requirements.
• Identified, formulated and documented detailed business rules and use cases based on requirements analysis.
• Identified the Entities and the relationships between the Entities to develop a logical model and later translated into physical model.
• Developed Facts & Dimensions using ERWIN.
• Used Normalization up to 3NF and De-normalization for effective performance.
• Developed Star and Snowflake schemas using dimensional data models.
• Involved in designing OLAP data models and extensively used slowly changing dimensions (SCD).
• Enforced Referential Integrity for consistent relationship between parent and child tables.
• Strong working experience in Extract/Transform/Load (ETL) design and implementation in areas related to Teradata utilities such as Fast Export and MLOAD for handling multiple tasks.
• Extracted data from databases like Oracle, SQL server and DB2 using Informatica to load it into a single repository for data analysis.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems.
• Compared data with original source documents and validated data accuracy.
• Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Experienced in data migration and cleansing rules for the integrated architecture (OLTP, ODS, DW).
• Worked on multiple data marts in Enterprise Data Warehouse (EDW).
• Involved in generating reports and maintaining the data base.

Environment: Erwin r7.0, SQL/MS SQL Server, MS Analysis Services, Windows NT, MS VisioXML, Informatica.

Confidential

Data Modeler / Analyst

Responsibilities:

• Created documents for technical & business user requirements during requirements gathering sessions.
• Transformed project data requirements into project data models for OLAP and OLTP systems using ERWIN.
• Involved in modeling business processes through UML diagrams using Rational Rose.
• Developed logical data model into the physical database design for data marts using Bill Inmon methodology and recommended technical approaches for good data management practices.
• Created dimensional model for the reporting system by identifying required facts and dimensions using ERWIN.
• Reverse engineered the database structure from the existing application using Sybase power designer.
• Developed Data Migration and Cleansing rules.
• Developed data mapping documents between legacy, production and user interface systems.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Turned SQL queries to make use of data base indexes, and analyzed the data base objects.
• Involved in the mapping of data sources and analytics, with the goal of ensuring data quality.
• Experienced in data cleansing for accurate reporting. Thoroughly analyzed the data and integrated different data sources to process matching functions.

Environment: ERWIN r7.2, PL/SQL, MS SQL, SQL Server 2008, Sybase 12, Ms Visio, Business Objects, Windows NT, Linux, Sybase Power Designer.