SUMMARY

• Over 9 Years of IT experience in Designing, Development and Implementation of Data Warehouses & Data marts with Informatica PowerCenter 9.x/8.x/7.x/6.x as an ETL tool.
• Extensive experience in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and Production.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process.
• Strong working experience on DSS (Decision Support Systems) applications, directly responsible for the Extraction, Transformation and Load (ETL) of data from Legacy Systems using Informatica.
• Worked extensively with complex mappings using Expression, Joiner, Router, Lookup and Update strategy, Source Qualifier, Aggregator to develop and load data in to different target types.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica Power Center.
• Experience in programming with PL/SQL (Stored Procedures, Stored Functions, Cursors, and Database Triggers).
• Worked extensively with debugger and tuning of ETL processes to improve the overall performance.
• Experience in integration of various data sources like Teradata, Oracle, SQL Server, DB2 into staging area.
• Experience in writing Unit test plans and Unit testing.
• Experience in Oracle and Other Utilities/tool.
• Experience in writing shell and Perl scripts.
• Automated few of the tasks using shell and Perl scripts.
• Implemented GPG encryption and Decryption.
• Developed Auto code review tool which reduced time spent on code review activity.
• Possess excellent communication and interpersonal skills with ability to work independently and as part of a team.
• Experienced in leading the team from Onsite and Offshore as Informatica Lead
• Experienced in developing universe for Business Objects.
• Designing dashboards, reports in Business objects.
• Excellent analytical, problem solving, communication, technical, multi - tasking and a motivated team player/lead with excellent inter-personal skills
• Strong leadership skill and able to build and maintain good personal relationship with Client.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.x/8.x/7.x/6.x, Data stage

RDBMS: DB2, Oracle 10g/9i/8i, Teradata, HIVE

Reporting Tools: Business Objects

Languages: Perl, C,Shell Scripting

OS: Sun Solaris UNIX, Linux, Windows NT/2000.

Utilities/Tools: Toad, SQL* Loader, PL/SQL, Core FTP

PROFESSIONAL EXPERIENCE

Confidential

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.6, Workflow Manager, Repository Manager and Designer.
• Created UNIX shell script to transport flat files from different source systems to the ETL server
• Created Mapplets for reusable business rules.

Environment: Informatica Power Center 9.6, Oracle 11g,Teradata, UNIX, Control-M,Gateway

Confidential

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.5, Workflow Manager, Repository Manager and Designer.
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created shell script to Decrypt the files.
• Created the shell Script to Encrypt the files using public key of the downstream system.

Environment: Informatica Power Center 9.1.0, Oracle 11g, UNIX, MS SQL Server, Varicent, TIDAL, Accurev & HP Quality Center

Confidential

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements
• Prepared the estimation & schedule for different phases of project life cycle.
• Involved in client requirement’s session with Business people.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.5, Workflow Manager, Repository Manager and Designer.
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created UNIX shell script to transport flat files from different source systems to the ETL server.
• Worked on performance tuning of mappings, sessions, Target and Source.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Involved in creating and running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Created Shortcuts, reusable transformations and Mapplets to use in multiple mappings.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures.
• Created conversion scripts
• Created profiles and Scorecard in IDQ
• Created Logical Data Objects in Informatica IDQ.
• Created unit & System Test Plan and Test Cases in different testing phases.
• Participate in daily & weekly Calls with management and from the client side as well to discuss the development status & ways to improve the productivity.
• Review the code and update the review documents to make sure the code is with in Development Standards

Environment: Informatica - PowerCenter 9.5, Informatica IDQ, Oracle 11g, PL/SQL, Unix,Toad,Teradata

Confidential

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Analyzing the system and customer requirements
• Prepared the estimation & schedule for different phases of project life cycle.
• Involved in client requirement’s session with Business people.
• Analyzed and Created Fact tables and Dimension Table for storing the historical data.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.1, Workflow Manager, Repository Manager and Designer.
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookups, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created UNIX shell script to transport flat files from different source systems to the ETL server.
• Worked on performance tuning of mappings, sessions, Target and Source.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Involved in creating and running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Created Shortcuts, reusable transformations and Mapplets to use in multiple mappings.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures.
• Created unit & System Test Plan and Test Cases in different testing phases. (Unit, Integration, System, Regression and End to End).
• Presented the Test Plan & Test Case of all testing phase to client
• Involved in different test execution - Unit, System test, Regression and End to End
• Reviewed the test cases & test results of Unit, System test and Regression test
• Develop & Review the code and update the review documents to make sure the code is with in Development Standards.
• Participate in daily & weekly Calls with management and from the client side as well to discuss the development status & ways to improve the productivity.
• Assign the tasks to the resources in the team & make sure that the delivery will be in the agreed deadlines.
• Organize KT to the new Team members & make them comfortable with the project understanding along with the application knowledge
• Explained the system requirements & solved all the technical & functional issues faced by team members
• Having a good hold on L3 production support as well.
• Migrated mappings, mapplets and workflows from Development to Testing and then testing to UAT.

Environment: Informatica - PowerCenter 9.1,Oracle 11g,PL/SQL,UNIX,TOAD and Windows NT/2000.

Confidential

ETL Consultant

Responsibilities:

• Participate in calls with business users to understand well about the requested change or new development for a particular functional area.
• Involved in designing of Informatica mappings by translating the business requirements.
• Keep the management updated about the development status daily and weekly & suggest new areas of development by using the technical expertise.
• Prepared the estimation & schedule for different phases of project life cycle.
• Participate in daily & weekly Calls with management and from the client side as well to discuss the development status & ways to improve the productivity.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 9.1- Server, Workflow Manager, Repository Manager and Designer.
• Involved in developing the Perl script.
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data.
• Created Unit&System Test Plans and Test cases in different Testing phase (Unit,Integration,System, Regression and End to End).
• Created Mapplets for reusable business rules.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Presented the Test Plan & Test Case of all testing phase to client

Environment:Informatica - PowerCenter 9.1,Oracle 11g,PL/SQL,UNIX,TOAD and Windows NT/2000.

Confidential

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, Concept documents and ETL specifications.
• Analyzing the system and customer requirements.
• Prepared the estimation & schedule for different phases of project life cycle.
• Analyzed and Created Fact tables and Dimension Table for storing the historical data.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center Designer.
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookup, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created UNIX shell script.
• Worked on performance tuning of mappings, sessions, Target and Source.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Involved in creating and running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Reviewed the test cases & test results of Unit, Int System and Regression test
• Delveop & Review the code and update the review documents to make sure the code is with in Development Standards.
• Participate in daily & weekly Calls with management and from the client side as well to discuss the development status & ways to improve the productivity.
• Assign the tasks to the resources in the team & make sure that the delivery will be in the agreed deadlines.
• Organize KT to the new Team members & make them comfortable with the project understanding along with the application knowledge
• Explained the system requirements & solved all the technical & functional issues faced by team members
• Having a good hold on L3 production support as well

Environment: Informatica - PowerCenter 8.6, Oracle 11g, PL/SQL, UNIX, TOAD and Windows XP.

Confidential

Senior Developer

Responsibilities:

• Involved in the technical design document
• Involved in the developing workflows and Tasks in the workflow manager based on the business requirements.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center Designer
• Created Mapplets for reusable business rules
• Preparing and reviewing data flow mapping test cases.
• Created UNIX shell script for data loading
• Worked as configuration manager and performed reviewing and promotions to copy the workflows and mappings through Clear Quest Tool
• Participate in Daily & weekly Calls with client
• Involved in code review activity

Environment: Informatica - PowerCenter 7.1, Oracle 9i, PL/SQL, UNIX, TOAD and Windows XP.

Confidential 

Software Engineer

Responsibilities:

• Design new package spec. and body with new procedure and functions with Transformation logic.
• Table creation with composite primary key constraints using Indexes and table spaces.
• Involved in Partitions creation.
• Involved in creating mapping and workflow.
• Involved in creating Autosys scripts which helps in scheduling the jobs.
• Tracing the queries by using Explain plan,Auto Trace.
• Involved in unit testing.
• Involved in the Implementation of data retention strategy for IRSR tables

Environment: Informatica - PowerCenter 7.1, Oracle 9i, PL/SQL, UNIX, TOAD and Windows XP.

Confidential

Software Engineer

Responsibilities:

• Design new package spec. and body with new procedure and functions with Transformation logic.
• Developed the mappings and workflows as per the Business logic using Informatica.
• Developed reusable Transformations.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Involved in creating Autosys scripts which helps in scheduling the jobs
• Involved in creating shell scripting
• Involved in unit testing.
• Participate in Daily & weekly Calls with client

Environment: Informatica – PowerCenter 6.1, Oracle 9i, PL/SQL, UNIX, TOAD and Windows XP.