SUMMARY:

• Around 7 years of IT experience in the field of Business Requirement Analysis, Data Analysis, Data warehousing, ETL Development and Data Modeling.
• Proficient in Microsoft SQL database management, Software Development Life Cycle (SDLC), Agile and Waterfall methodologies for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Extensive knowledge in Metadata Management, Data Mapping, Data Cleansing, Data Manipulation and Performance Tuning techniques.
• Experienced Data Modeler with strong conceptual, Logical and Physical Data Modeling skills for various environments and business processes.
• Experience in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints in T - SQL.
• Excellent knowledge of Bill Inmon and Ralph Kimball methodologies to design databases.
• Extensive experience using Data modeling tools like Erwin and ER Studio
• Experienced in working with RDBMS like Oracle 10g/ 9i/ 8i, Microsoft SQL Server 2008 R2 and Teradata.
• Proficient in designing database using Star and Snowflake schemas with a very good understanding of fact and dimensional tables.
• Experienced in Normalization and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Generated DDL scripts from the physical models for implementing Data Modeling changes and worked on comparing and merging the data models.
• Experience in Development, support and Maintenance for the ETL (Extract, Transform and Load) processes and writing SQL Queries to perform end-to-end ETL validations.
• Experience analyzing database performance with SQL profiler and Optimizing Indexes to significantly improve performance.
• Experienced in management and implementation of database models, dataflow diagrams, database schemas and scripts to support a robust data management infrastructure.
• Experience in data analysis to track data quality and for detecting/correcting inaccurate data from the databases.
• Excellent team player working closely with ETL Developers, Database administrators, Business Analysts and support teams.
• Impressive presentation as well as communications skills with very good leadership qualities.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin Data modeler r 7.1/7.2/7.3/8.2 , ER Studio 9.1/9.5, Power Designer 11.0/12.0/12.5/15 , MS Visio

ETL Tools: Informatica 7.1.3/8, SQL Server Integration Services (SSIS)

Web Technologies: HTML, HTML5, XHTML

BI Tools: SQL Server Analysis services (SSAS), SQL Server Reporting Services (SSRS), Visual Studio

Databases: Oracle 9g/10g/11g, MSSQL servers 2000/2005/2008 , Teradata V2R5/V2R 6/12, DB2, MS Access 2003/2007/2010

SQL, TSQL, PL: SQL, HTML, XML

PROFESSIONAL EXPERIENCE:

Sr. Data Modeler

Confidential, Belvidere, IL

Responsibilities:

• Understood database design and gathered system requirements from the team and collected specific requirements meeting for business needs.
• Developed the conceptual data model after gathering requirements from business users using Erwin
• Designed Logical and Physical data models using data provisioning and consumption techniques.
• Performed source to target mapping by identifying the source from existing databases.
• Implemented data strategies and data cleansing rules and performed data profiling and validity to build data flows.
• Reverse Engineered Physical Data model from SQL scripts and databases.
• Converted ERD model in Relational Data Model and also coordinated new data development ensuring consistency and integration with the existing data warehousing software.
• Implemented Snowflake schema to ensure no redundancy in the database.
• Implemented DML scripts for recovery of data of and worked with the different teams to identify and analyze the duplicate objects from the Database and performed appropriate action.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for different purposes following SQL code standards.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Analyzed functional and non-functional data elements for data profiling and mapping from source to target data environment.
• Worked on Dimensional Modeling techniques to develop the data marts using Erwin/ ER Assistant.
• Developed a star schema data warehouse model for the proposed central model.
• Performed Enterprise Data Warehouse validation and analysis to identify the accurate data source.
• Developed OLTP system by designing Logical and eventually Physical Data Model from the Conceptual Data Model by reviewing the business requirements.
• Identify required dimensions and fact using Power Designer tool for the Dimensional Model.
• Use the SQL Data Modeler tool to develop a Conceptual Model based on business requirements analysis. ­

Environment: Erwin, Teradata, SQL Data Modeler, Power Designer, ER Assistant, SQL Management Studio, MS Excel, MS Access, flat files.

Data Modeler/Analyst

Confidential, Indianapolis, IN

Responsibilities:

• Participated in all phases including design, coding, testing and documentation and also performed analysis and provided reports as required by business.
• Performed reverse engineering on the existing data model to understand data flow.
• Designed ER diagrams, logical model and physical model as per business requirements.
• Translated business requirements into detailed, production-level technical specifications, new features and enhancements to existing technical business functionality.
• Developed normalized logical and physical data models to design OLTP system for insurance application.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin
• Developing the Data Mart for the base data in Star Schema and used Snow-Flake Schema in developing the data warehouse for the database.
• Performed forward engineering to create a Physical Data Model with DDL that best suits the requirements gathered.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Responsible for defining the naming standards for data warehouse and Identifying and documenting detailed business rules and Use Cases based on requirements analysis.
• Generated ad-hoc SQL queries to fetch data from legacy DB2 and SQL Server database systems.
• Used Erwin for reverse engineering to connect to existing database to create graphical representation in the form of Entity Relationships.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Developed OLAP Cubes by using SQL SERVER Analysis Services (SSAS) and defined data sources, data source views, Dimensions, Measures, Hierarchies and Attributes.
• Worked on SSAS storage and partitions, Aggregations, calculation of queries with MDX and developing reports using MDX and SQL.
• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build data Models.

Environment: ERwin r9/9.1, Oracle 11g, Toad for Oracle 10, SQL Server 2012/2014, DB2, MS Excel, MS Access, Microsoft Visual Studio.

Data Modeler/Data Analyst:

Confidential, Palatine, IL

Responsibilities:

• Worked with Application Development team to decide and implement naming Standards, domains, multiple subject areas.
• Developed Stored procedures to handle large amount of data manipulation.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Worked on identifying Facts from Existing relational Models and sub Models and Dimension tables from the existing models of data marts.
• Worked extensively on normalization techniques to normalize data into 3rd Normal Form (3NF).
• Implemented forward Engineering on DB2 databases to transform them into SQL Server 2008 using ERWIN.
• Extensively worked with financial and healthcare data.
• Worked on T-SQL statements for retrieval of data and involved in Performance Tuning of T-SQL queries
• Designed and maintained various data models using Erwin Design Tool and Erwin Model Manager.
• Involved in creating and updating System Design Specification (SDS) document.
• Taking the business rules and requirements into considerations; developed the specifications document for the Informatica ETL mappings to load the data into target database.
• Prepared ad-hoc reports with the use of Crystal Reports 9.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic

Environment: ERwin, Informatica, SSMS, SQL Server, MS-Office, XML, T-SQL, PowerPoint, MS Visio and MS Outlook.

Data Modeler

Confidential

Responsibilities:

• Developed OLAP system by designing Logical and Physical Data Model from the Conceptual Data Model.
• Analyzed and presented the gathered information in graphical format for the ease of business managers.
• Performed Source to target mapping by developing the mapping spreadsheets.
• Identified required dimensions and Facts using Erwin tool for the Dimensional Model.
• Developed the star schema of the data warehouse by De-normalizing the existing Database.
• Developed the Data model with enforced Referential Data Integrity and produced an efficient database design
• Extensively used the Erwin tool to develop a Conceptual Model based on business requirements analysis.
• Optimized and updated UML Models (Visio) and Relational Data Models for various applications.
• Implemented ETL techniques for Data Conversion, Data Extraction and Data Mapping for different processes as well as applications.
• Played a key role in optimizing the database by cleansing the redundant data. Reversed Engineered the data model by redefining various attributes and their relationships.
• Extensively worked on Data Governance rules for MDM architecture.
• Ensured data model consistency by developing best practices for coding and standard naming conventions.
• Introduced foreign keys and normalized the existing data structure to maintain Referential Integrity.
• Worked with the ETL team to provide source to target mapping to implement incremental, full and initial loads into the target data mart.
• Data Consistency was maintained by evaluating and updating logical and physical data models to support new and existing projects.
• Reviewed different codes, tests and designs to ensure no bottlenecks in the systems and to recommend required update if any.
• Generated various reports using SQL Server Report Services (SSRS) for business analysts and the management team.
• Well experienced in documenting data relationships, business rules, allowed rules, evolved glossary and codes.

Environment: Teradata, Oracle 9i, TOAD 9.7, SSRS, Erwin Data Modeler 7.3, SSRS, SSIS.

Data Modeler/Data Analyst

Confidential

Responsibilities:

• Worked with Business Analysts team gathering requirements and preparing functional specifications and translating them to technical specifications.
• Worked with Business users to prepare Conceptual, Logical and Physical Data Models.
• Reverse Engineered the existing data marts and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Worked with the team to develop a Data Warehouse at the lowest level of grain for each of the Dimensions involved.
• Created Entity Relationship Diagrams (ERD), Functional diagrams, Data flow diagrams and enforced referential integrity constraints.
• Designed a STAR schema for sales data involving shared dimensions (Conformed) for other subject areas.
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Defined facts, dimensions and designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using ER Studio.
• Developed Data mapping, Data Governance, Transformation and Cleansing rules for the Data Management involving OLTP, ODS and OLAP.
• Normalized the database based on the new model developed to put them into the 3NF of the data warehouse.
• Designed logical and physical data models, Reverse engineering, Complete compare for Oracle and SQL server objects using Erwin.
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
• Developed scripts that automated DDL and DML statements used in creations of databases, tables, constraints, and updates.

Environment: ER/Studio, Teradata 13.1, SSIS, Excel, T-SQL, SSRS, Tableau, SQL Server, Oracle 11g/10g, SQL, MicroStrategy, XML, SQL Loader.

Data Analyst

Confidential

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Applied data warehousing methodologies in enhancing the existing data model
• Implemented Star Schema, snowflake methodologies in enhancing data warehouse.
• Maintained technical documentations for tables, views, procedures and SQL scripts and mapping creating report models for building Ad-hoc Reports Using SSRS, Crystal Reports9 and Excel Spreadsheet creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Enhanced existing facts and dimensions based on the business requirements.
• Performed gap analysis where applicable to make sure there are no data anomalies.
• Followed standards and best practices in indexing and partitioning where performance can be a concern.
• Performed data conversions from flat files into a normalized database structure.
• Supported ETL team in understanding the process and creating/enhancing the ETL maps.
• Supported QA by providing assistance in writing the SQL prototypes as needed.

Environment: SQL Server, SSRS, crystal reports, T-SQL, SQL Profiler, MS Excel, MS Access