SUMMARY

• 10 Years of Total IT Experience
• 5 Years of Experience in leading / managing teams
• 5 Years of Customer Facing experience in the United States
• Experience in technologies like ETL Informatica, CDC Real Time, Mainframe, etc.
• Experience in verticals like Healthcare, Retail, Consumer Goods and Telecom domains
• Managed projects in Agile and Waterfall models.
• Certifications Certified Scrum Master, AHM250 Healthcare, Retail L0 and L1.

Primary Skills

Lead Skills

• 10 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Retail and Telecom verticals.
• Actively participated / chaired project meetings involving various project stake holders, vendors and User teams located in various geographies.
• Worked extensively in technologies like Informatica ETL, Mainframes, Cognos, Microsoft SQL Server, Oracle, DB2, MQ, and XML etc.
• Reviewing project deliverables like Source/Target Mapping specification documents, Design, Informatica mappings etc.
• Conducted budget planning meetings of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
• Raising Risks and Issues. Coming up with Mitigation plans. Escalating to appropriate people.
• Acted as a single point of contact and guiding Users Acceptance Testing. Including addressing Users Testing issues, environment setup, defects follow up, timelines.
• Adept in providing Analytical Support to key business Applications /solutions
• Exceptional ability to maintain and build client relationships, able to comfortably converse with all facets in the client's organization.
• Effective communication skills and coordination skills involving teams like those are globally located.
• Knowledge of Microsoft Project plan
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non - technical audiences
• Thorough Understanding of Software Development Life Cycle SDLC, involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Acted as liaison between management/development team, QA and Business Users.
• Managing reports, analysis and decision-making for a change request.
• Project Schedule, Project Tracking and Team Management
• Generating metrics / reports from various tools like Quality Center and presenting to executive team.

Technical Skills-

• Worked in technologies like Data Warehousing Informatica ETL using Informatica Power Center 9.5.1/8.6. Source Analyzer, Repository Manager, Mapping Designer, Mapplets, Transformations, Workflow Manager, Task Manager .
• Change Data Capture using Power Exchange and SQL Server 2008.2012.
• Experience in creating mappings, mapplets, SCD Type-1/2 and reusable objects using Informatica
• Experience in Data Masking MD5 .
• Experience in coming up with Design patterns.
• Database experience using Oracle 11g/10g, IBM DB2, MS SQL Server, flat files, XML files, COBOL VSAM files.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Designed and developed efficient Error Handling methods and implemented across the Datawarehouse
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Highly Skilled with the Integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML files and IBM Mainframe COBOL files.
• Experience in Dimensional Data Modeling using Star, Snowflake Schema, Fact Dimensions tables, Physical Logical Data Modeling using Erwin.
• Skilled in Unit Test, System Integration Test and UAT
• Strong knowledge of complete System Software development Life Cycle SDLC of Data warehousing, Decision Support System.
• Experience in Mainframe programming COBOL, JCL, MQs, VSAM and DB2

Domain Skills

• Healthcare Eligibility and Claims systems
• Consumer Goods
• Retail Store Applications
• Telecom - Provisioning

PROFESSIONAL EXPERIENCE

Confidential

Role: ETL Lead

Responsibilities:

• Understanding the Source and Target applications.
• Understanding functionalrequirements.
• Participate in meetings to finalize Design Patterns.
• Preparing Source/Target Mapping documents.
• Supervise and review the work of programmers.
• Created Logical Architecture documents for the team and presented PPT's as on-boarding process for new team members.
• Designed and developed Batch and Reconciliation process for data load.
• Change Data Capture CDC through Power Exchange 9.5.1
• Scheduling meetings with Data Architects/SMEs/Developers/Admins to address the roadblocks.
• Raising the Issues/Risks and coming up with Mitigation plans.
• Masking data for the PHI columns
• Created Reusable transformations and developed mappings using mapplets.
• Based on the logic, Developed various mappings mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner transformations in the mapping.
• Developed and Implemented Informatica parameter files to filter the data from the source system on a daily basis.
• Created Informatica Mappings to load Dimension Fact tables.
• Developed mappings to implement type 2 slowly changing dimensions.
• Created Materialized views for summary tables for better query performance.
• Involved in all levels of testing including Unit, System, Integration, Regression testing.
• Creating and reviewing Test cases for Unit Test, System and Integration Tests.
• Used various debugging techniques to debug the design issues in the mappings

Environment: Informatica PowerCenter 9.5.1, PowerExchange 9.5.1, Cognos 8 /10, Oracle 10i, Microsoft SQL Server, Flat files, Cobol files, Snipping Tool, Microsoft Outlook, Lync.

Confidential

Role: Sr. ETL Developer

Main objectives are

• Replace the American Girl AG ecommerce and call center capability that currently services the AG Direct and Programs, Fisher Price FP, Barbie Collector BC, and Hot Wheel Collector HWC businesses
• Provide 360 /multi-channel view of the customer in real-time
• Integrate best in class web analytics tool IBM Coremetrics
• Integrate and leverage ecommerce and call center capability with content management CMS, analytics, mobile, social, Endeca Search, Digital Asset Management DAM and other third party systems/tools

Responsibilities:

• Involved in the Study of the business logic and coordinate with the client to gather user requirements and understanding the physical system and the terms and conditions for the Datamarts.
• Worked with Data Modelers to create Best-Fit Physical Data Model.
• Created technical specification documents like system design and detail design documents for the development of Informatica Extraction, Transformation and Loading ETL mappings to load data into various tables in Data Marts, and defining ETL standards.
• Created Mapping Specification document to explain how to process the data from source to the target tables.
• Designed and developed ETL process using Informatica tool to load data from wide range of sources such as Oracle, Flat Files and XML.
• Worked on Inbound, Outbound and Carve-out Data Feeds and developed mappings, sessions, workflows.
• Based on the logic, Developed various mappings mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in the mapping.
• Developed mapping to implement Type 1/2 SCD.
• Developed and Implemented Informatica parameter files to filter the data from the source system on a daily basis.
• Converted PL/SQL code Stored Procedures, Functions and Packages to Informatica ETL code
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality
• Fine-tuned Informatica Code for performance optimization
• Used various debugging techniques to debug the design issues in the mappings.

Environment: Informatica 9.1/8.6.1, Cognos 8 /10, Oracle 9i, XML files, Flat files, Snagit, WinSCP, Ms-office, Ms-Visio, ALM.

Confidential

Role: ETL Test Lead

Responsibilities:

• Reviewing the requirements, design and participating actively in walkthrough meetings.
• Understanding the Business Rules
• Analyzing Informatica mappings, workflows and running sessions.
• Running queries through SQL Station and validating the results.
• Running Cognos Reports and validating.

Project Planning

• Preparing and presenting Master Test Plan and Strategy to Client / project management and providing suggestions for smooth and cost effective execution.
• Identifying Risks and Issues. Coming up with Mitigation plans.
• Customer Interaction and reporting status as well of risks/issues to Customer on weekly basis.
• One point contact for senior management, development team and Client.
• Review and validate estimations done by offshore leads.
• Recruitment, Staffing, Identifying training needs of team, mentoring and career development.
• Continuously identify process improvements and value ads for better cost savings.
• Preparing for engagement reviews and quality assurance Audits
• Conducting meetings and calls involving various teams and vendors located in different regions.
• Preparing test metrics PPTs and presenting
• Database Testing - Querying ORACLE tables through SQL developer tools and validating databases for correctness of the data.
• Test Planning After initial Kick Off meeting coming up with Test Plan which delineates Testing Approach, in Scope and Out of Scope, Risks, Environment/Resource needs and Timeline.
• Test Design Creating Test Scenarios, Test Cases, Mapping Test Cases to Requirements and ensuring complete coverage, Creating the Test Environment and Test Data.
• Test Execution Executing the Test Cases in various cycles and marking them Passed/Failed in Microsoft TFS tool.
• Defect Management Raising Defects for the failed Test Cases and following up with developers for resolving them.

Environment: Informatica 9.1/8.6.1, Cognos 8 /10, Oracle 9i, XML files, Flat files, Snagit, WinSCP, Ms-office, Ms-Visio, ALM.

Confidential

Role: Mainframe OnsiteLead

Responsibilities:

• Participating in Requirements gathering meetings and understanding the requirements.
• Preparing Design document.
• Preparing Development Timelines and Estimations.
• Coding in Mainframe Cobol
• Preparing/updating Jobs in JCL Job Control Language
• Preparing Unit Test Plans and conducting Unit Testing
• Supporting System and User Testing teams

Onsite Lead activities,

• Conducting daily offshore calls to impart the knowledge and client expectations.
• Resolving the issues/risks of the team.
• Reviewing the offshore deliverables.
• Participating in daily/weekly status meetings and updating the status.
• Coordinating for Environment setup.
• Acting as a liaison between and client

Environment: Mainframe, COBOL, JCL, REXX, VSAM, DB2, HP Quality Center, CICS, ClearCase.

Confidential

Mainframe Offshore Lead / Developer

Responsibilities:

• Requirement Gathering
• Preparing Design documents
• Coding in Mainframe Cobol
• Preparing/updating Jobs in JCL Job Control Language
• Preparing Unit Test Plans and conducting Unit Testing
• Supporting System and User Testing teams

Offshore Lead activities,

• Conducting the reviews for offshore deliverables including code reviews.
• Conducting Walkthrough calls with Onsite/Client for offshore deliverables.
• Identifying Risks and Issues. Coming up with Mitigation plans.
• Preparing Daily and weekly status reports.
• Coordinating for Environment setup.
• Preparing Estimations and timelines.
• Preparing for engagement reviews and participating in Audits

Environment: Mainframe, COBOL, JCL, REXX, Expediator, VSAM, DB2, HP Quality Center, CICS, VSS.