SUMMARY

• Thirteen years of IT experience in total out of which 10 years of extensive experience in designing, developing and implementing Data Warehouse Projects using Informatica, SQL Server & Unix shell scripting
• Expertise in Business Requirement gathering and converting the same into Technical Specification documents (HLD & LLD)
• Data modelling knowledge using Dimensional Data Modelling, Star Schema Modelling, Snow Flake Modelling, FACT and Dimensions tables
• Well versed in Informatica PowerCenter 9.0.1/8.6.1/8.1.1/7.1.3
• Extensively experienced with RDBMS skills in Sybase and SQL Server. Good experience with Unix Shell scripting.
• Expertise in Data warehousing, Data migration and Data Integration projects as ETL Solution Architect, DW Lead and ETL Developer
• Worked in onshore - offshore model as a coordinator for different geographical locations.
• Performance Tuning at Mapping Level, Session Level, Source Level and Target Level.
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems.
• Proficient in designing and developing various transformations
• Extensively worked on Informatica Designer Components -- Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Code Migration across application regions using Deployment group.
• Setting up User, Groups and Manage connection, permissions using Admin console.
• Experience in SQL Server stored procedure programming.
• Proficient in writing UNIX shell scripting.
• Expert in tuning performance of SQL queries and ETL processes
• Possess excellent interpersonal and communication skills, quick learner and a good team player

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.0.1/8.6.1/8.1.1/7.1.3 , Informatica PowerexchangeBusiness Objects XI R2, Composite 5.0

Database: SQL Server, Sybase 12.5.3, DB2 UDB, Oracle 10i, Teradata

Languages: UNIX shell scripting, SQL, PL/SQL, Perl scripting, C#

Operating Systems: Windows, UNIX

Scheduling Tools: Autosys

Other tools: HP Quality Center 10.0, Embarcadero ER Studio 8, Microsoft Project 2007, Perforce, VSS, Toad, Putty

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead

Responsibilities:

• Provided technical leadership and guidance to the development team for the design and development of highly complex or critical ETL architecture and leading industry practices
• Collaborated with business analysts and release teams, providing input on architectural design recommendations, driving standards, plan and execute effective transition to production operations
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Engage Data Architecture team for Data Modelling and create database objects based on design.
• Co-ordination with offshore for design discussions, code review and mentoring.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union and Update Strategy.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug sessions by using session / workflow logs.
• Mapping of functional data elements to database fields and come up with database procedure and view design.
• Perform Code review and unit testing at various levels of ETL.
• Involved in migrating Mappings, Sessions and Workflows from dev to test and UAT environments and prepare patch for deployment into Production environment.
• Integration of UNIX shell with Informatica PMCMD command utilities for executing workflows
• Impact analysis of objects impacted in the migration process from Informatica PowerCenter 8.1.1 to 8.6.1
• Identify resources and split work load among them for effective execution of tasks in a timely manner
• Create repositories and folders required in target Informatica environment to facilitate migration of components
• Create relational and non-relational connection objects in target Informatica repository environment
• Change hard coded data in source code to variables to facilitate ease of move from one environment to another
• Movement of code from 8.1.1 to 8.6.1 using export and import / folder copy options
• Critical issues like multi character delimiter files, automated sequence generations and data type mismatches were tested for conformance in the new environment.
• Creation of parameter files in appropriate UNIX locations and point them to the right folders for creation of workflows logs, session logs, input files, output files and relational connection objects
• Validate code and execute informatica workflows in target Informatica environment and ensure accuracy of results in Informatica 8.6.1 environment
• Tracking Production failures and debug sessions by using session / workflow logs
• Performance tuning of mappings during UAT stage and maintenance phases.
• Perform Code review and unit testing at various levels of ETL.
• Involved in migrating Mappings, Sessions and Workflows from dev to test and UAT environments and prepare patch for deployment into Production environment.
• Integration of UNIX shell with Informatica PMCMD command utilities for executing workflows

Confidential

Technical Lead/ ETL Consultant

Responsibilities:

• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Worked with Task Developer, Worklet Designer and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed invalid mappings and troubleshoot technical problems of the database.
• Performance tuning of mappings during maintenance phases.
• Tracking Production failures and debug the sessions by utilizing session logs / workflow logs.
• Functional analysis and track down data elements to be sent to PWC. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Perform Code review and unit testing at various levels of ETL.
• Integration of UNIX shell script with Informatica PMCMD command utilities.
• Actively participated in design discussions and prepared design documents (HLD & LLD) for certain Load Stages.
• Shared & provided details about all design & transformation rules document with the team & guided them to build the necessary components.
• Worked with team members to prepare coding Standards, ETL Specification & Test case documents template. Provided Informatica PowerCenter/Powerexchange technical consultation to offshore team members & helped in resolving key technical issues
• Assisted Project Business Analysts by providing key Design & Data mapping inputs for documenting the FSD. Involved in QA Test plan & Testcase review meetings. Worked with Release Management team in migrating the components to QA environment for QA testing. Provided necessary technical assistance in fixing QA defects
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Perform Code review and unit testing at various levels of ETL.
• Integration of UNIX shell script with Informatica PMCMD command utilities.
• Performance tuning of mappings during maintenance phases.

Environment: Informatica PowerCenter 8.1.1, Informatica Powerexchange 8.1.1, COBOL, VSAM, DB2 UDB, UNIX, Mainframe, Business Objects, Autosys, VSS

Confidential

Responsibilities:

• Managed the end to end delivery of the Confidential from design to Build and test
• Involved in high level design and architecture for operational data store using Informatica, Sybase and Business Objects
• Provided Informatica PowerCenter/Powerexchange technical consultation to offshore team members & helped in resolving key technical issues
• Analysed the Source system thoroughly by going through the Mainframe reverse engineering documents, querying the DB2 UDB database to capture data quality issues & prepared the Source system Analysis document.
• Actively worked with project manager, data modeller & designers to come-up with Build estimate
• Reviewed Low Level Design & Testcase documents, Informatica, Sybase & Unix components
• Assisted Offshore Team members in clarifying any Informatica, Sybase stored procedures & Shell script related queries
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Perform Code review and unit testing at various levels of ETL.
• Integration of UNIX shell script with Informatica PMCMD command utilities.
• Performance tuning of mappings during maintenance phases.
• Involved in the support for System Testing & Performance Testing
• Created few Business object universe and reports

Environment: Informatica PowerCenter 8.1.1, Informatica Powerexchange 8.1.1, COBOL, VSAM, DB2 UDB, UNIX, Mainframe, Business Objects, Autosys, VSS

Confidential

Responsibilities:

• Worked as a Technical Leader in the team
• Identifying the list of Components & Doing Design and Efforts Estimation.
• Prepared Source System Analysis & Requirement Analysis documents.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Perform Code review and unit testing at various levels of ETL.
• Integration of UNIX shell script with Informatica PMCMD command utilities.
• Involved in the support for System Testing & Performance Testing.
• Performance tuning of mappings during maintenance phases.

Environment: Informatica Power Center 7.1.3, UNIX Shell scripting, Sybase, Autosys

Confidential

PL/SQL Developer

Responsibilities:

• Identifying the list of Components & Doing Design and Efforts Estimation.
• Prepared Source System Analysis & Requirement Analysis documents.
• Designed and developed stored procedures, triggers and SQLs for display and calculation purposes
• Perform Code review and unit testing of stored procedures which were eventually displayed in RVW front end (ERP)
• Involved in the support for System Testing & Performance Testing.
• Performance tuning of stored procedures during maintenance phases.

Environment: SQL Server 2000, ASP, Visual Basic, RVW

Confidential

PL/SQL Developer

Responsibilities:

• Identifying the list of Components & Doing Design and Efforts Estimation.
• Prepared Source System Analysis & Requirement Analysis documents.
• Designed and developed stored procedures, triggers and SQLs for display and calculation purposes
• Perform Code review and unit testing of stored procedures which were eventually displayed in RVW front end (ERP)
• Involved in the support for System Testing & Performance Testing.
• Performance tuning of stored procedures during maintenance phases.

Environment: SQL Server 2000, RVW