PROFESSIONAL SUMMARY:

• Around 14 years of IT experience in management, Data Modeling, implementation, development and testing various Data Warehouse Systems and Business Intelligence applications
• Demonstrated expertise in Data Architecture, Conceptual, Logical and Physical Data Modeling and Design.
• Experienced in gathering functional, technical requirements and translate the requirements into data models, preparing Data Mapping documents and ETL Design Specifications
• Strong Domain knowledge in T&H, Retail, Healthcare and Financial sectors like Stock exchange
• Experienced in working with Data Management team to determine and define data transform requirements, design ETL process to Migrate Data from Legacy Systems into New Core Systems
• Strong design skills in Logical Data modeling, Physical Data modeling and Metadata Management for OLTP (Relational) and OLAP (Dimensional).
• Extensive experience in Reverse engineering and Complete Compare Data models using data modeling tool ERWIN 9.6 from disparate systems and analyzing the same.
• Well versed in forward engineering Data models and creating Physical Database schema and objects using Data modeling tool like ERWIN 9.6
• Proven ability to carry out peer review of Data models by quickly understanding the requirements of different systems.
• Functional exposure to SAP S/4HANA database
• Excellent facilitation skills and strong analytical skills to understand and define data requirements.
• Ability to function in cross functional team with technical and non - technical peers and managers.
• Ability to coordinate with the business group and application group and to validate the model in a non technical language, from their respective perspectives.
• Hands on experience in ETL design & development using DataStage, SSIS
• Knowledge of Tableau tool functionality

TECHNICAL SKILLS:

Operating Systems: Windows Server 2008 R2 IIS, Windows NT 4/XP/200X/9x Windows 7/8, UNIX (Sun Solaris 10/8, AIX 5.x/4.x, Linux), NCR UNIX (MP-RAS)

Data Modeling: ERWIN 9.6 / Visio 2010

ETL & BI Tools: MS SQL Server 2012 SSIS, IBM Infosphere DataStage and QualityStage 8.X Informatica 8.x, Teradata Utilities (Multiload, Fastload, Fastexport, TPump) and Cognos 7.x( Power Play and Impromptu )

RDBMS: MS SQL Server 2012, Teradata 15.10, Oracle 11g/10g/9i/8i/7.x, DB2 v9.1/7.x

Programming: SQL, PL/SQL, XML, HTML, Shell Script

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Enterprise Data Modeler

Responsibilities:

• Interact with the business and BAs to understand project requirements & specifications
• Prioritize various tasks, such as business analysis, ETL development and Cognos \ Hyperian Reporting
• Design and develop models to create or update OLTP databases
• Generate metadata reports and creating mapping documents for application development
• Updating OLTP & EDW databases with user requests to support ongoing business applications
• Reverse engineering, Forward engineering and Complete Compare features used to verify and confirm changes with previous version models
• Models are versioned with Documentum

Environment: Erwin 9.6, Windows Server2008 R2 IIS, Teradata SQL Assistant, SQL Developer, MS SQL Server 2012, Windows 7 Enterprise, HP Application Lifecycle Management, Documentum

Confidential, Eden Prairie MN

Data Modeler

Responsibilities:

• Participate in JAD sessions with the business and BAs to understand project requirements & specifications and design the application
• Designed a Logical and physical Data Model for healthcare customer data for OLTP database.
• Creating and maintaining OLTP database design document with detailed description of logical entities and physical tables, preparing High Level and Low-Level Application Design Document creating custom metadata reports using Erwin tool and documentation of all Entities, Attributes, Relationships and all deliverable artifacts
• Updating data models to implement on boarding new entities and enhancements
• Work with offshore team on ETL Design, Development and coding for Data load and Validation
• Conducting code reviews with client to get approval from the business & Architect team.
• Support to UAT teams in System testing & regression testing activities
• Promoted Code Deployments across all environments.

Environment: Windows Server2008 R2 IIS, SQL Client, MS SQL Server 2012, Windows 7 EnterpriseERWIN 9.1, HP Application Lifecycle Management. Subversion

Confidential, Moline IL

Data Modeler/ETL Lead

Responsibilities:

• Participate in business requirements sessions, ETL Architecture meetings, define ETL best practices, to design and develop the conceptual and logical data models & ETL jobs
• Feasibility analysis and technical review of Functional specifications and mock up screens
• Deriving the Physical data model after doing technical feasibility analysis
• Designing the technical design document from Functional specifications
• Designing solutions to provide integration ideas of various functional and business critical systems
• Develop logical and Physical model for OLTP databases in using Erwin tool. Used Model Mart for the models on a shared environment. Recommend and develop new key words and abbreviation in the naming standards file. Used Macros for the naming standards
• Onsite project development of MME modules where offshore is restricted
• Work with offshore team on ETL Design, Development and coding for Data load and Validation
• Promoted Code Deployments across all environments.
• Support to CQA, UAT teams in System testing & regression testing activities
• Configuring common framework tables(CFW) and code versioning with subversion
• Scheduling jobs in Dev, QA & Prod environments with help of TWS team
• Warranty support to all migration projects

Environment: IBM InfoShere DataStage and QualityStage 8.5 /8.7, Ascential DataStage 7.5.3, IBM Infosphere Information Server Manager 8.5, MS SQL Server, Sybase SQL Advantage 12.5.1, Oracle 10g/11g, PL/SQL, SQL * PLUS, Windows 7 Enterprise, AIX, TWS scheduling tool, Erwin r8, HP Application Lifecycle Management, Reflection Standard Suite 2011 R2

Confidential, Bluebell PA

Team Lead

Responsibilities:

• Participate in business requirements sessions, ETL Architecture meetings, define ETL best practices, guidelines in design and develop ETL jobs to load RDS Tables and to migrate Pharmacy claims data
• Interact with the management and BAs to understand and spec out the scope of tasks/ projects, provide with time estimates
• Conducting WPR sessions to get approval from the business & Architect team
• Create Source to target mapping (ETL Mapping) from source systems into target systems (RDS Tables & CVS files).
• Work with offshore team on ETL Design, Development and coding for Data loading and Data Validation
• Promoted Code Deployments, Job Exports in job migration process across all environments using Clear case version management tool.
• Scheduling jobs in Dev, QA & Prod environments with help of Zeke team

Environment: IBM InfoShere DataStage and QualityStage 8.5 / Ascential DataStage 7.5.3, DB2 v9.1, Oracle 11g, Windows XP/ 7 Enterprise, AIX, PL/SQL, SQL * PLUS, Zeke scheduling tool, Clear quest

Confidential, Downers Grove IL

Sr ETL Developer

Responsibilities:

• Participate in ETL Architecture meetings, define ETL best practices, guidelines on performance tuning for the ETL jobs to load Data mart Tables
• Create Source to target mapping (ETL Mapping) from source systems into target systems (Data Marts).
• Work on ETL Design and coding for Data loading, Data cleansing and Data Validation
• Interact with the management and BAs to understand and spec out the scope of tasks/ projects, provide with time estimates
• Tested each parallel job and reviewed the results to make sure the data is populated correctly in datamart.
• Promoted Code Deployments, Job Exports in job migration process between dev and test environments using PVCS version management tool.

Environment: IBM WebSphere Enterprise DataStage 7.5.3, Oracle 11g/10g, Windows XP Pro, UNIX (AIX 5.4) and IBM eServer pSeries, PL/SQL, SQL * PLUS, SQL Loader for Oracle

Confidential, Downtown Chicago

Data Developer

Responsibilities:

• Analyze, design, develop and test data integration solutions including design and development of ETL (Extract, Transform & Load) JOBs using DataStage ETL Suite.
• Designed and implemented new reusable DataStage components to address business needs
• Developed Technical design Specification (TDS) documents and Source to Target mapping documents (STM) for each feed
• Designed and Developed DataStage Shared Containers, DataStage PX common repeatable modules/jobs to be used in future releases
• Developed DataStage jobs to migrate data from legacy to ODS for the Bridge project
• Designed & developed an outbound feed process to provide data to cars.com affiliates, dealers and partners
• Diagnosed, identified solutions for the intakes submitted by QA and other teams
• Promoted Code Deployments, Job Imports, Job Exports in job migration process between dev, test and prod environments using version control.
• Updated oracle procedures & fine tuned sql queries for better performance of OLTP database.

Environment: IBM WebSphere Enterprise DataStage 7.5.2, Oracle 9i/10g, Windows XP Pro, UNIX (AIX 5.4) and IBM eServer pSeries, IBM TWS, Toad for Oracle v9.7

Confidential, Raleigh, NC

Sr QA Analyst

Responsibilities:

• Developed comprehensive test plans
• Developed and executed test scripts based on technical specifications & documentation
• Manually tested each system functionality
• Bug fix verification as per incremental release
• Developed and maintained the automated regression test suites for each increment
• Classified test script failures by metrics code with technical expertise

Environment: C, C++, Java, SQL Server, Windows 2000/XP Pro, AIX, COGNOS Impromptu

Confidential, Chicago Downtown

QA Engineer

Responsibilities:

• Developed and tested the functionality of each use case manually
• Developed and maintained the automated regression test suites for each increment
• Bug fix verification as per incremental release
• Reporting bugs to Project Manager using ClearDDTS tool
• Run the regression test suites after each increment of SBT
• Designed the test cases by using Domain Analysis approach
• Developed extended use cases for each use case.
• Involved in performing twenty cycles of System Testing on a stabilized system to test Profile/Performance, Fault Tolerance, Stress & Configuration.

Environment: QA partner/Silk 5.0.3, Java 1.2.2, Corba, Oracle 8i, Windows NT 4.0, Sun Solaris 2.6, ClearDDTS, NFS Maestro, FileAid-CS, ClearCase 4.0