SUMMARY

• 11 years of IT experience in the Analysis, Design, Development, Testing, Implementation and documentation of application software in Data Warehousing, ETL (Informatica Power Center) Process, Oracle SQL and PL/SQL.
• Expertise in implementing complex business rules by creating robust Mappings, Sessions and Workflows using Informatica Power Center.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica Power Center tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
• Extensively worked on Design, Development, Deployment and Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (DB/Files) to different targets (DB/Files).
• Experience in designing/developing complex mapping using transformations like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Sequence Generator, Connected and Unconnected Lookup, Update Strategy, stored procedure and Implementing SCD Type 1 and Type 2
• Good conceptual knowledge of Oracle 9i/10g/11g, Data Warehouse Concepts, ETL.
• Strong experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
• Strong experience in working on ESP (Scheduler) for scheduling of ETL workflows, solving production job failures.
• Good knowledge of Teradata development using BTEQ utility scripts.
• Good understanding of Data modeling concepts ER Diagrams, Use Cases, Excellent analytical, problem solving skills with strong technical background and interpersonal skills.
• Good knowledge of USA healthcare and health insurance domain. AHM - 250 Certified.
• Good knowledge of Banking and Finance domain.
• Strong SDLC skills including the ability to work through the entire development cycle from gathering requirements through implementation including documentation. Have worked in Waterfall model and Agile.
• Efficient team player with excellent communication skills and good interaction with users. Ability to interact with people at all levels like business people, senior level managers and delivering solutions on time by working proactively in team based environments.

TECHNICAL SKILLS

Data Warehousing: InformaticaPower Center 10.1,9.x,8.x, Starand Snowflake Schema

ETL Tools: Informatica Power Center

Databases: Oracle 11g/10g/9i, Teradata (BTEQ)

Scheduling Tools: ESP Scheduler, InformaticaScheduler

Operating Systems: UNIX, Linux, Windows XP/7

Scripting: Shell Scripting

Language: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Greenwood Village, CO

ETL/Informatica Lead Developer

Responsibilities:

• Responsible for understanding complex business logic to design and develop quality code.
• Responsible for SIT/UAT support for QA/Testers.
• Responsible for helping onshore and offshore team with any issues in queries for analysis.
• Responsible for helping offshore team members for their queries on design, unit test cases and on other queries related to various day to day tasks.
• Responsible for working with Release Management team and performing all the documentation and steps for Code Release Implementation to Production and supporting the jobs during Production Release.
• Responsible for taking daily tasks status call with offshore team members.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Modified existing mappings for enhancements of new business requirements.
• Participated in daily standup calls, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Responsible for testing the mappings and ensure that the mappings do the transformations as proposed.
• Involved in creating tasks, mappings, workflows to load various dimensions.
• Developed mapping parameters and variables to support SQL override.
• Responsible to make it sure that team uses ETL standards to develop mappings.
• Responsible for reviewing code with offshore and onshore to ensure good quality of code.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union to develop robust mappings in the Informatica Designer.
• Involved in Performance tuning at source, target, and mapping and session levels.
• Applied slowly changing techniques in mappings.
• Defined Target Load Order Plan for loading data into Target Tables.
• Resolved various Production issues of High Priority in short span of time.
• Responsible for helping Production Support team for failures that cannot be handled by them.
• Worked with other teams like Database Administrators and Informatica Admins to quickly resolve the production issues.
• Responsible for writing BTEQ scripts as per business requirement to read data from Teradata tables and write into Teradata tables after applying business logic.
• Responsible for developing Informatica mappings that load data into Teradata Database tables.
• Responsible for writing ESP code to schedule jobs using ESP scheduler.

Environment: InformaticaPower Center 10.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Teradata (BTEQ), SQL, Oracle 11g, Putty, WinSCP, Toad, Shell Scripting, ESP Scheduler.

Confidential, Colorado

ETL/Informatica Developer

Responsibilities:

• Responsible for understanding complex business logic to design and develop quality code and fix defects.
• Responsible for developing mappings using Informatica Power Center Designer 9.1 to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Filter, Update Strategy, Router, Sequence Generator, Sorter and Joiner transformations.
• Responsible for doing high level and detailed analysis in fixing the high, medium level incidents which is raised by business users based on monthly releases.
• Responsible for coordination with offshore team and work as a team when needed.
• Knowledge transfer to new hires in the team or training existing team members about new processes or activities.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Modified existing mappings for enhancements of new business requirements.
• Responsible for testing the mappings and ensure that the mappings do the transformations as proposed.
• Involved in creating tasks, mappings, workflows to load various dimensions.
• Developed mapping parameters and variables to support SQL override.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union to develop robust mappings in the Informatica Designer.
• Involved in Performance tuning at source, target, and mapping and session levels.
• Resolved various Production issues of High Priority in short span of time.
• Responsible for helping Production Support team for failures that cannot be handled by them.
• Worked with other teams like Database Administrators and Informatica Admins to quickly resolve the production issues.
• Responsible for writing ESP code to schedule jobs using ESP scheduler.

Environment: InformaticaPower Center 10.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Oracle 11g, PL/SQL, SQL, Putty, WinSCP, Toad, Shell Scripting, ESP Scheduler.

Confidential, Colorado

ETL/Informatica Developer and System Analyst

Responsibilities:

• Responsible for understanding the business requirements as a System Analyst for sub projects and create the Functional Requirement and mapping documents.
• Responsible for understanding the requirements for tickets created by business as a System Analyst for production defects and create analysis document on how to fix the issue.
• Working as a Developer on the code development of sub projects and production defect fixes.
• Involving in the full development lifecycle starting from requirements gathering from business users on sub projects and production issues and do high level and detailed analysis, developing mappings, unit testing, code reviews, SIT/UAT support in QA environment and working in production deployment activities.
• Developing mappings using Informatica Power Center Designer 9.1 to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Filter, Update Strategy, Router, Sequence Generator, Sorter and Joiner transformations.
• Responsible for doing high level and detailed analysis in fixing the high, medium level incidents which is raised by business users based on monthly releases.
• Responsible for coordination with business to get clarification on the business requirements and working on the high level and detailed analysis of the issue and the fix.
• Responsible for coordination with offshore team and work as a team when needed.
• Responsible for monitoring batch jobs using ESP scheduler.

Environment: InformaticaPower Center 10.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Oracle 10g, SQL, Putty, WinSCP, Toad, Shell Scripting, ESP Scheduler.

Confidential, California

ETL/Informatica Developer and Team Lead

Responsibilities:

• Responsible for doing analysis and fixes for production failures for all CDW applications.
• Responsible for working on Production load monitoring for 7 applications which CDW is supporting - KPCC CO, QCare CO, MAS Diamond, NW Diamond, OH Diamond, SF/CSI and GA Tapestry.
• Responsible for involving in the full development lifecycle starting from requirements gathering from business users on production issues and do high level and detailed analysis, developing mappings, unit testing, code reviews, SIT/UAT support in QA environment and working in production deployment activities.
• Responsible for developing mappings using Informatica Power Center Designer 8.6 to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Filter, Update Strategy, Router, Sequence Generator, Sorter, Normalizer and Joiner transformations.
• Responsible for doing high level and detailed analysis in fixing the high, medium level incidents which is raised by business users based on quarterly releases
• Responsible for coordination with the release manager on analysis results related to release items.
• Responsible for coordination with business to get clarification on the business requirements and working on the high level and detailed analysis of the issue and the fix.
• Working on SOX documentation and Remedy CRQ.
• Responsible for coordination with offshore resources to keep track of their progress and distribute work to them.

Environment: InformaticaPower Center 9.5/9.6 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Putty, WinSCP, Toad, Shell Scripting.

Confidential

ETL/Informatica Developer

Responsibilities:

• Responsible for doing analysis and fixes for production failures for all CDW applications.
• Responsible for working on Production load monitoring for 7 applications which CDW is supporting - KPCC CO, QCare CO, MAS Diamond, NW Diamond, OH Diamond, SF/CSI and GA Tapestry.
• Responsible for involving in some enhancement work on these applications
• Responsible for preparing the weekly and daily reports for those applications.

Environment: InformaticaPower Center 8.x/9.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Putty, WinSCP, Toad, Shell Scripting.

Confidential

ETL/Informatica Developer

Responsibilities:

• Responsible for providing support to all Informatica applications
• Responsible for analyzing and solving issues arising during the end to end process right from getting the source files till generating the target files generated after processing files using Informatica (ETL tool).
• Responsible for reporting and keeping track of the issues through several Incident Management Systems like Global Incident Management System(GIMS), DBSymphony and JIRA
• Responsible for providing production support as an L2 resource.

Environment: InformaticaPower Center 8.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Oracle 9i, Putty, WinSCP, Toad, Shell Scripting.

Confidential

Shell/Perl Scripting Developer

Responsibilities:

• Responsible for supporting analysis for the requirements.
• Responsible for Development of the scripts (Perl and Shell) needed during the Data Migration phase of the project.
• Responsible for Executing the Unit Test Plans.
• Responsible for Providing SIT/Post production support.
• Responsible for Maintenance of local source repository.
• Responsible for Peer reviews on the deliverables (code, unit test plans).

Environment: Shell Scripting, Perl scripting, UNIX, Central Database Server.

Confidential

Java Developer

Responsibilities:

• Responsible for Execution of Unit Test Plans
• Responsible for Providing IST/Pre-production support
• Responsible for Simulation of IST issues.

Environment: Java, UNIX, Oracle.