SUMMARY

• Overall 8+ years of Industry experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• 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 indatamart design and creation of cubes using dimensionaldatamodeling - 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 DataWarehouse 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 inDatawarehouse 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 theDataModel and followed company standard for Project Documentation.
• Expertise in Normalization techniques fordataconsistency and Flexible Database design.
• Expertise database normalization method defined by E.F CODD (3NF-Third Normal Form).
• Strong Database experience using Oracle 11g/10g/9i, XML, DB2, Teradata, SQL server, Big data and NoSQL.
• Experience in SQL and good knowledge in PLSQL programming and developed Stored Procedures and Triggers.
• Hands on experience in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments.
• Experienced indatamodeling includingdatavalidation/scrubbing and operational assumptions
• Extensive exposure in designing ETL process to load IDS, EDW and Data mart environments in Erwin using Kimball approach.
• Expert in data validation, cleansing, consolidation and mining for sense, consistency and accuracy and compliance standards.
• Experienced in Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML)
• Good experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modifieddatabase design document with detailed description of logical entities and physical tables.
• Experienced in Strong in Source to Targetdatamapping, Standardization Document Slowly Changing Mapping Creation, Star/Snowflake Schema Mapping Creation, RDMS, BuildingData Marts and Meta Data Management.

TECHNICAL SKILLS

Data Warehousing: Informatica 9.1/8.6/7.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, Data Stage 8.x

Reporting Tools: Business Objects6.5, XIR3, Cognos 8 Suite

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server, UDB DB2 9.x, Teradata, MS Access 7.0

Programming: SQL, PL/SQL, UNIX Shell Scripting, VB Script

Environment: Windows (95, 98, 2000, NT, XP), UNIX

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Data Analyst / Data Modeler

Responsibilities:

• Highly performed the mapping effort for various development teams by mapping their applicationdatarequirements to the model and providing consistent standardized language for communication between the development teams.
• Experienced in Gathering and analyzed existing physicaldatamodels for in scope applications and proposed the changes to thedatamodels according to the requirements.
• Experienced in Refined the existing model resulting from project teams mapping theirdatarequirements for existing systems to thedatamodels as a part of the SDLC project methodology.
• Experienced in Team Lead with end-to-end grasp of the entire software development life cycle (SDLC) including analysis, design, development and testing of software applications
• Worked with the Business and the ETL developers in the analysis and resolution ofdatarelated problem tickets and other defects.
• Good Experienced in Generated and DDL (DataDefinition Language) scripts using ERWIN 7.2 and assisted DBA in Physical Implementation ofdataModels.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram) using Erwin7.2
• Worked withdatain the tables to analyze and modify by writing DML scripts.
• Experienced in Creating Source- Target SQL scripts for all the transformation rules mentioned in the mapping document.
• Experienced in Analyzeddatafrom different perspectives and summarized it into useful information byDataMining Techniques.
• Experienced in Periodic checking of all databases with DBCC commands for maintainingdataconsistency and integrity.
• Good Coordinated with back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Highly created functional decomposition diagrams and Context Diagrams.
• Experienced in Extensively used MS Visio for representing existing and proposeddataflow Diagrams.
• Highly Participated in JAD sessions to solve the revolving issues between the executive teams and developers.

Environment: ERWIN 7.2, Power Designer 12.5, DATAFLUX 6.1, PL/SQL Developer, Oracle 9i, SQL/PL SQl, SQL Navigator, Windows NT 4.0, UNIX, Microsoft Access, Microsoft Visio, SQL Server 2000, MS PowerPoint, MS Access, Microsoft Excel.

Confidential, Livonia, MI

Sr. Data Analyst / Data Modeler

Responsibilities:

• Experienced in Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Highly Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Experienced in Writing several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Good experienced in Metrics reporting, data mining and trends in helpdesk environment using Access
• Highly Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Experienced in Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Highly involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Good experienced in Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Good knowledge in Identify & record defects with required information for issue to be reproduced by development team.
• Experienced in Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.

Environment: - MS SQL Server 2008 client & SERVER, MS office, Legacy - Mainframes, Titanium, Rational Clear Quest, Clear Case.

Confidential, Overland Park, KS

Sr. Data Analyst / Data Modeler

Responsibilities:

• Good experienced in Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Highly involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Highly Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.
• Highly Created DML code and statements for underlying & impacting databases.
• Experienced in Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Highly Perform data reconciliation between integrated systems.
• Experienced in Metrics reporting, data mining and trends in helpdesk environment using Access
• Good experienced in Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Highly extensively used MS Access to pull the data from various data bases and integrate the data.
• Good experienced in Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Highly Responsible for different Data mapping activities from Source systems to Teradata
• Experienced in Assisted in the oversight for compliance to the Enterprise Data Standards
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data
• Worked with Excel Pivot tables.
• Highly create and Monitor workflows using workflow designer and workflow monitor.
• Good experienced in Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Experienced in Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Business Objects XIR2, ETL Tools Informatica 8.6, Oracle 10G, Teradata V2R12, Teradata SQL Assistant 12.0

Confidential

Data Modeler/Analyst

Responsibilities:

• Experienced in Gathering Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Highly Responsible for the analysis of business requirements and design implementation of the business solution.
• Experienced in developing Entity-Relationship diagrams and modeling Transactional Databases and Data warehouse using tools like Erwin, ER/Studio and Power Designer.
• Experienced in Using ERWIN r7.3 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Good Identifying the Facts and Dimensions from the business requirements and developed the logical and physical models using ERStudio 7.1/7.5.
• Experienced in Using Teradata Fast Load utility to load large volumes ofdatainto empty Teradata tables in the Data Mart for the Initial load.
• Highly generated comprehensive analytical reports by running SQL queries against current databases to conductData Analysis.
• Experienced in Using Teradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Experienced in Handled performance requirements for databases in OLTP and OLAP models.
• Highly Involved inDataMapping activities for thedata warehouse.
• Highly developed complex Stored Procedures for SSRS (SQL Server Reporting Services).
• Experienced in Created database objects like tables, indexes, synonyms, views, materialized views etc.
• Highly Documented ER Diagrams, Logical and Physical models, business process diagrams and process flowdiagrams.
• Highly Created complex SQL server 2008 and Oracle stored procedures and triggers in support of the applications with Error handling.
• Experienced in Creating mappings, mapplets and reusable transformations in Informatica. Also used several transformations like expression, Aggregator, Lookups, Joiner, Normalizer, Router, update strategy, Filter, Union, Sequence Generator, Stored Procedure, Source qualifier, XML transformation, etc.
• Good Experienced in Fine-tuned the mappings using push down optimization, session partitioning, bulk load, fast load, etc.

Environment: Informatica Power Center 9.5.1, DataStage 8.1, Teradata 13.11, Oracle 9i, Microsoft SQL Server 2008, SVN tool, Sybase Power Designer 16.1, BTEQs, MLoads, Fast Load, UNIX scripting, PLSQL Programming