SUMMARY

• Around 10 years of experience in Analysis, Design, Development and Implementation of DW & BI applications using Informatica PowerCenter 9.5, Oracle 11g/10g, TERADATA 13.x Databases, DB2, Netezza & SQL Server Databases - SQL Level, Data Modeling & Dimensional Modeling and Unix Shell Scripting.
• Experience in leading Onsite/Offshore team, as an Onsite ETL Lead/Solution Architect, providing ETL Solutions for new projects and BAU (Business As Usual) project using Informatica PowerCenter tools
• Experience in gathering business requirements, gap analysis, and creating technical specifications document for application development.
• Experience in Implementing Dimensional Modeling - SCD Type I, II & III
• Experience in developing, maintaining and enhancing ETL code for huge Datawarehouses with heterogeneous sources
• Extensive knowledge on Informatica Architecture (Informatica Certified), involved in Repository setup, Domain configuration and Environmental setup
• Experience in using various Tuning techniques to improve performance in Mappings, Sessions, Workflows, used PDO - PushDown Optimization, Session Partitioning
• Experience in working with various types of source/targets, flat files like fixed width, CSV, VSAM files and relational types like SQL Server, Oracle & Teradata database tables, used TPT- Teradata Parallel Transport connection loader
• Extensively worked on various scheduling tools viz., Informatica Scheduler, ControlM, & Crontab
• Quick turnaround on providing solutions and workarounds for Production job failures in Informatica & Oracle Procedures and provides workarounds in quick turnaround to avoid user impacts.
• Experience in automating ETL process, file transfers and calling stored procedures using Shell scripts.
• Experience in using issue tracking and ticketing tools like Peregrine, HP Quality Center & ITSM for UAT & Production Implementations
• Performed overall project status & issue tracking, analysis, architecture, design, development, testing (Unit testing/System Integration testing/User Acceptance testing) and implementation of data warehousing / business intelligence initiatives.
• Experience in developing Database Packages, Stored Procedures, Functions, Database Triggers and implementing advanced features of Database objects like Collections, Indexes, Materialized Views, Table Partitions and Parallel Processing techniques.
• Involved in SQL tuning of using Explain plans, SQL Trace Utilities.
• Strong knowledge and experienced on Banking and Financial domains application development.
• Ability to work collaboratively in a team environment and has the ability to handle multiple tasks under pressure
• Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the top management executives, business sponsors and MIS department.

TECHNICAL SKILLS

Databases: ORACLE (11g/10g), TERADATA 13.x, DB2, and SQL Server

Languages: SQL, PL/SQL, UNIX Shell Scripting

Database Tools: TOAD, PL/SQL Developer, TERADATA SQL Assistant, SQL Loader

ETL Tool & BI: Informatica PowerCenter 9.1, Hyperion

Design Tools: Microsoft Visio, CA ERWin 7.3

Testing & Others: HP Quality Center, Control - M

Operating Systems: Windows NT/XP, UNIX

Domain Knowledge: Banking and Financial Services

PROFESSIONAL EXPERIENCE

Confidential, Libertyville, Illinois

Informatica Developer Lead

Responsibilities:

• ETL Architect in the analysis, design and development, testing of the application.
• Interaction with the Process owners on regular basis in consolidating and analyzing the requirements and create the understanding documents.
• Involved in the analysis of existing Informatica code, design and standards for VCI to FIS application conversion
• Developing ETL mappings to extract automotive finance data from Leasepak, Remarketing, CQM, MAPS and other source systems and sending them to FIS through file transfer protocols
• Involved in enhancing existing mappings to facilitate the loading of data into the FIS Data Warehouse applications faster
• Tuned mappings/sessions to extract data using session partitions & parallel reads
• Migrating Informatica code between Development, TEST & Production repositories for testing & implementations
• Creating mapping and session parameters as per the requirements and passing values through windows
• Involved in code review for mappings, sessions, workflows & Unix files used for job run
• Worked on deriving test strategies for various types of data loads & data comparisons
• Written testcases & test scenarios and prepared test validation queries in Oracle & Sybase databases
• Prepared peer review checklists, unit test cases, comparison testcases
• Prepared delivery artifacts like release notes, unit testcases & comparison test results
• Worked on end-end details testing for System, Integration, and User Acceptance test phases
• Provide QA/UAT/Post-Implementation testing support after delivery
• Collaborated with Business owners & analysts and developers in complex and large data warehouse project design and development

Environment: Informatica PowerCenter 9.6, Oracle 11g, SQL, PL/SQL, Sybase Adaptive Server, Rapid SQL- RDBMS, UNIX Scripting, and MS SharePoint portal.

Confidential, Downers Grove, Illinois

Datawarehouse Lead

Responsibilities:

• Leading the Offshore ETL team in the analysis, design and development, testing of the application.
• Interaction with the Process owners on regular basis in consolidating and analyzing the requirements and create the understanding documents.
• Involved in the analysis of existing Informatica code, design and standards
• Converting Oracle SQL Loader jobs into ETL mappings and converting Informatica Oracle mappings into Informatica Netezza mappings by designing the mappings to be compatible with Netezza database
• Involved in enhancing existing mappings to facilitate the loading of data into the Netezza Data Warehouse applications faster
• Designed concurrent workflows to run through Unix shell scripts with dat & template files
• Migrating Informatica code source repository to Development repository for Netezza conversion
• Creating mapping and session parameters as per the requirements and passing values through unix
• Worked on converting the sql queries as per Netezza standards
• Involved in code review for mappings, sessions, workflows & Unix files used for job run
• Worked on deriving test strategies for various types of data loads & data comparisons
• Prepared peer review checklists, unit test cases, comparison testcases
• Prepared delivery artifacts like release notes, unit testcases & comparison test results
• Provide QA/UAT testing support after delivery

Environment: Informatica PowerCenter 9.1, Netezza 7.0, Oracle 11g, SQL, PL/SQL, Toad - Oracle, UNIX Scripting, and MS SharePoint portal.

Confidential, Irving, Texas

DW & BI Lead ETL Informatica Lead

Responsibilities:

• Leading the ETL team in the analysis, design and development, Testing and Implementation phase of the application.
• Interaction with the business users / applications on regular basis in consolidating and analyzing the requirements and create the technical design documents.
• Involved in the Architecture design technique, data modeling and the various phases in building the ICDW data warehouse application.
• Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation.
• Creating ETL mappings and enhancing existing mappings to facilitate the loading of data into the Data Warehouse applications.
• Creating Informatica Job schedules on various tools Informatica Scheduler, ControlM & using PMCMD command.
• Implemented performance tuning logics, Partitioning & Push down Optimization techniques on Targets, Sources, mappings, and sessions to provide maximum efficiency and performance.
• Development of PL/SQL programs like Packages, procedures, functions, triggers, materialized views etc in the application development.
• Developed and optimized complex queries for data retrieval and modification using Explain plan, SQL Trace Utilities for better performance.
• Handled data partitioning design methods and indexing techniques on the application.
• Creating high level and low level functional specification and Technical specification document for application development.
• Built and maintaining strong business relationships with cross functional team.
• Handling team on the development phase, code review and analyzing programs to identify and fix issues on the application.
• Developing Shell Script programs for the job/process automation in UNIX environment.
• Oversees the design/development and supports the data models/structures and ETL. Performs quality testing prior to UAT, and reports progress throughout the project and enhancement life cycle.
• Handling application release activities for UAT phase and production release for the application users using ITSM tool.
• Providing Level 3 production support as needed offering timely, instantly sound problem resolution.
• Create, maintain and tracking of end users business issues in application.
• Managing resource allocation, project timelines strategies and project status document.

Environment: Informatica PowerCenter 9.1, Oracle 11g, TERADATA 13.x, SQL, PL/SQL, Toad - Oracle, Teradata SQL Assistant, UNIX Scripting, Control - M, HP Quality Center, and MS SharePoint portal.

Confidential, Columbus, Ohio

DW & BI Lead ETL

Responsibilities:

• Leading 7 members ETL team in the analysis, design and development, Testing and Implementation phase of the application.
• Interaction with the business users / applications on regular basis in consolidating and analyzing the requirements and create the technical design documents.
• Having great level of exposure in Dimensional Modeling, Data Modeling & ETL Design
• Involved in the Architecture design technique, data modeling and the various phases in building the ICDW data warehouse application.
• Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation.
• Creating ETL mappings and enhancing existing mappings to facilitate the loading of data into the Data Warehouse applications.
• Generating Hyperion Reports for Student Loan reporting
• Creating Informatica Job schedules on various tools Informatica Scheduler, ControlM & using PMCMD command.
• Implemented performance tuning logics, Partitioning & Push down Optimization techniques on Targets, Sources, mappings, and sessions to provide maximum efficiency and performance.
• Development of PL/SQL programs like Packages, procedures, functions, triggers, materialized views etc in the application development.
• Developed and optimized complex queries for data retrieval and modification using Explain plan, SQL Trace Utilities for better performance.
• Handled data partitioning design methods and indexing techniques on the application.
• Creating high level and low level functional specification and Technical specification document for application development.
• Built and maintaining strong business relationships with cross functional team.
• Handling team on the development phase, code review and analyzing programs to identify and fix issues on the application.
• Developing Automation Shell Script programs for the job automation in UNIX environment to avoid manual intervention.
• Oversees the design/development and supports the data models/structures and ETL. Performs quality testing prior to UAT, and reports progress throughout the project and enhancement life cycle.
• Handled application release activities for UAT phase and production release for the application users.
• Provided Level 3 production support as needed offering timely, instantly sound problem resolution.
• Create, maintain and tracking of end users business issues in application & provided workarounds & permanent fix.

Environment: INFORMATICA Power Center 8.6, Oracle 10g, SQL, PL/SQL, DB2, UNIX Shell Scripting, Hyperion reporting tool.

Confidential, Seattle, Washington

ETL Developer

Responsibilities:

• Key member in Informatica ETL Development team involved in end-end SDLC Process steps viz., Requirements Gathering, analysis, design and development, Testing and Implementation phase of the application.
• Developed Informatica mappings with various types of Informatica source and targets (RDBMS, XML and Flat files)
• Handled the full development process SDLC life cycle of ETL code for error-free implementation.
• Prepared Unit test plan and test case documents which assures quality.
• Used Oracle & Teradata targets & source tables
• Creating ETL mappings and enhancing existing mappings to facilitate the loading of data into the Data Warehouse applications.
• Developed and optimized complex queries for data retrieval and modification using Explain plan, SQL Trace Utilities for better performance.
• Creating high level and low level functional specification and Technical specification document for application development.
• Worked on SQL Server sources & SQL Server reporting - Query Analysis
• Developing Automation Shell Script programs for the job automation in UNIX environment to avoid manual intervention.
• Oversees the design/development and supports the data models/structures and ETL. Performs quality testing prior to UAT, and reports progress throughout the project and enhancement life cycle.
• Handled application release activities for UAT phase and production release for the application users.
• Provided Level 2 & 3 Production Support as needed offering timely, instantly sound problem resolution & temporary workarounds until the permanent fix being implemented.
• Create, maintain and tracking of end users business issues in application & provided workarounds & permanent fix.
• Creating technical design documents, Unit Test Scripts using Application Implementation Methodology.

Environment: Informatica PowerCenter 6.x, 7.x,8.1, Oracle 9i, TERADATA, SQL, PL/SQL, Toad - Oracle, SQL Server, Teradata SQL Assistant, UNIX Scripting, HP Quality Center, and MS SharePoint portal.