SUMMARY:

• Around 9+ years of experience in data modeling and data analysis, production support, database management, strategic analysis, requirements gathering, application and decision support.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN and Power Designer. 
• Proficient in data mart design and creation of cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema. 
• Well versed in Normalization / De normalization techniques for optimum performance in relational and dimensional database environments. 
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment. 
• Experienced in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer. 
• Hands on experience with modeling using ERWIN in both forward and reverse engineering cases
• Experienced with DDL and DML including Joins, Functions, Indexes, Views, Constraints, Primary Keys and Foreign Keys. 
• Extensive experience in Data warehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions. 
• Expertise in working with business users as part of requirements gathering and converting them into technical solution. 
• Deployed naming standard to the Data Model and followed company standard for Project Documentation. 
• Expertise in Normalization techniques for data consistency and Flexible Database design. 
• Expertise database normalization method defined by E.F CODD (3NF-Third Normal Form). 
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling. 
• Designed the PL/SQL procedures for getting the data from all systems to Data Warehousing system.
• Experienced in Data transformation and Data mapping from source to target database schemas and also data cleansing. 
• Experienced in using SSRS and Cognos to create and manage reports. 
• Excellent understanding and exposure to SQL queries and PL/SQL stored procedures, triggers, functions and packages. 
• Strong experience in Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for effective and optimum performance in OLTP and OLAP environments. 
• Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using Erwin tool. 
• Experienced in writing Data Transformation and Data Cleansing rules for Data Mapping documents in Data Warehouse projects. 
• Good understanding of Teradata SQL Assistant, Teradata Administrator and data load/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export. 
• Worked in many Software Development Life Cycle (SDLC) implementations, performing process planning, documentation, functional and system design, implementation, unit testing, integration testing, and regression testing and system maintenance. 

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, MS DOS, Sun Solaris. 

Languages: C, Java, HTML, SQL, PL/SQL, XML 

Databases: Oracle, SQL Server, Teradata, Sybase, MSAccess, DB2 

Modeling Tools: ERWIN r 9.1, Embarcadero, ER/Studio, MSVisio, Sybase Power Designer

Reporting Tools: Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x / 6.x, Cognos7.0/6.0. 

ETL Tools: Informatica Power Center 7.1/6.2, Data junction, Ab-Initio, Data Stage, SSIS. 

Others: MS Office, TOAD, BTEQ, Fast Load, Multi Load, Fast Export

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, OH

Sr. Data Analyst/Data Modeler

Responsibilities:

• Created logical data model from the conceptual model and it's conversion into the physical database design using ERWIN. 
• Mapped business needs/requirements to subject area model and to logical enterprise model. 
• Worked with DBA's to create a best fit physical data model from the logical data model 
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities. 
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design. 
• Developed the data warehouse model (star 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 ERWIN tool. 
• Worked on the Snow-flaking the Dimensions to remove redundancy. 
• Worked on Metadata exchange among various proprietary systems using XML. 
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project. 
• Created high level ETL design document and assisted ETL developers in the detail design and development of ETL maps using Informatica. 
• Responsible for creating the staging tables and source to target mapping documents for the ETL process. 
• Involved in Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server. 
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions. 
• Helped in migration and conversion of data from the Sybase database into Oracle database, preparing mapping documents and developing partial SQL scripts as required. 
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems 
• Used ERWIN for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information. 
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement. 
• Participated in performance management and tuning for stored procedures, tables and database servers. 

Environment: Windows 7, Teradata 14, ERWIN r9.1, SQL server 2005/2008, Business Objects XI, MS Excel 2010, Informatica 7.3., SQL Server 2000/2005, Rational Rose, Oracle 8i, TOAD for Data Analysis,  Teradata SQL Assistant 13.0.

Confidential, Gardner, KS

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Extensively analyzed Ralph-Kimball Methodology and implemented it successfully. 
• Created logical, physical data models and Meta Data to support the requirements 
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin. 
• Walked through the Logical Data Models of all source systems for data quality analysis 
• Created Tasks, Workflows and Worklets using Workflow Manager.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and, sequence buffer length. 
• Automated load run on Informatica sessions through UNIX Corn, PL/SQL scripts and implemented pre and post-session scripts, also automated load failures with successful notification through email. 
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin / Star Schema. 
• Led enterprise logical data modeling project (in third normal form) to gather data requirements for OLTP enhancements.
• Converted third normal form ERDs into dimensional ERDs for data warehouse effort. 
• Analyzed IMS Data using IMS tools such as Xponent and Xponent Plantrak, regarding segmentation & profiling. 
• Involved in mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping, inclusive of logical names, physical names, data types, domain definitions, and corporate meta-data definitions. 
• Converted physical database models from logical models, to build/generate DDL scripts. 
• Maintained warehouse metadata, naming standards and warehouse standards for future application development. 
• Extensively used ETL to load data from DB2, Oracle databases. 
• Built, managed, customized ETL (Extraction, Transformation, and Loading) Mappings & workflows using Informatica workflow manager & Designer tools. 
• Extensively worked on ETL transformations Lookup, Update Strategy, Joiner, Router and Stored procedure transformations. 
• Designed and developed Informatica mappings for data loads and data cleansing. 
• Maintained Meta Data Repository for storing table definitions, table spaces and entity definitions. 
• Tuned Informatica Mappings for optimum performance and scheduling ETL Sessions. 
• Deployed naming standard to the Data Model and followed company standard for Project Documentation. 

Environment: Erwin 4.0, Informatica Power Center 7.0/6.2(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), SQL Server 2000(Query Analyzer, DTS, TSQL), Oracle 9i/8i, PL/SQL, SQL* Loader, TOAD, Business Objects 6.0, Sun Solaris 2.7.

Confidential, Southfield, MI

Sr. Data Analyst/ Data modeler

Responsibilities:

• Performed data analysis and profiling of source data to better understand the sources. 
• Created logical data model from the conceptual model and it's conversion into the physical database design using Erwin. 
• Worked with DBA's to create a best-fit Physical Data Model from the logical data model. 
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities. 
• Interacted with the database administrators and business analysts for data type and class words. 
• Conducted design sessions with business analysts and ETL developers
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement. 
• Created ER Diagrams, Data Flow Diagrams, grouped and created the tables, validated the data, identified PK/ FK for lookup tables. 
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool. 
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model. 
• Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner. 
• Involved in ETL mapping documents in data warehouse projects. 
• Created high level ETL design document. 
• Involved in extensive Data Analysis on the Teradata and Oracle Systems querying and writing in SQL and TOAD. 
• Assisted the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes. 
• Involved in extensive data analysis on the Teradata and Oracle systems querying and writing in SQL and TOAD. 
• Used SQL joins, aggregate functions, analytical functions, group by, order by clauses and interacted with DBA and developers for query optimization and tuning. 
• Conducted several Physical Data Model training sessions with the ETL Developers. Worked with them on day-to-day basis to resolve any questions on Physical Model. 

Environment: Oracle 11g, SQL Server 2005/2008, Teradata 14, MS Access, Teradata, Data stage, Erwin r8.0, Windows XP, MS Excel, Business Objects XI, SSIS, MS Access, Teradata, Data stage, Erwin8.0, Windows XP, Excel, Informatica.

Confidential, Plano, TX

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Facilitated JAD sessions for project scoping, requirements gathering & identification of business subject areas. 
• Identified and documented detailed business rules and use cases based on requirements analysis. 
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN. 
• Developed Logical Model from the conceptual model. 
• Worked with DBA's to create a best-fit Physical Data Model from the logical data model. 
• Used forward engineering to generate DDL from the Physical Data Model and handed it to the DBA. 
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions. 
• Designed STAR schema for the detailed data marts and plan data marts consisting of confirmed dimensions. 
• Used ETL methodology for data extraction, transformations and loading in a complex Enterprise Data Warehouse (EDW). 
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse content. 
• Assisted in Data Stage Server jobs to load data from sequential files, flat files and MS Access. 
• Used Data Stage Manager for importing metadata from central repository. 
• Involved in extracting, cleansing, transforming, integrating and loading data into different Data Marts using Data Stage Designer. 
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects. 
• Used Erwin's reverse engineering to connect to existing database and ODS to graphically represent the Entity Relationships. 
• Involved in Performance tuning by leveraging oracle explain utility and SQL tuning. 

Environment: Oracle 9i, SQL Server 2005/2008, DB2, Microsoft Transaction Server, Erwin, Teradata 14, Crystal Reports, SSIS/SSRS, Informatica, MS-SQL server manager, Microsoft Access, MS Excel, MS Visio, Rational Rose, Requisite Pro

Confidential, Lincolnshire, IL

Data Analyst/ Data Modeler

Responsibilities:

• Involved in dimensional modeling of the data warehouse to design the business process. 
• Designed star schemas and bridge tables to control slowly changing dimensions.
• Developed ER and Dimensional Models using Erwin advanced features.
• Created physical and logical data models using Erwin. 
• Done extensive bulk loading in to target using Oracle SQL Loader. 
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in writing UNIX shell scripts for Informatica ETL tool to automate sessions. 
• Involved in M-LOAD, Fast-load and T-pump loading to migrate data from Oracle to Teradata. 
• Created BT queries and stored procedures in Teradata. 
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation. 
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. 
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades. 

Environment: Erwin 4.0, Informatica PowerCenter 7.1/6.2(Power center Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle 9i, DB2 8.0, PL/SQL, Teradata V2R3, MS SQL Server 2000, Business Objects 5.1, MS Access, UNIX Shell scripting, Windows XP.