OBJECTIVE:

To continue to work in a challenging and fast paced environment, constantly growing as an experienced, and computer savvy data warehouse expert who is passionate about what he does.

PROFESSIONAL SUMMARY:

• Gained 10 and more years of IT experience on Data warehouse ETL tool - Informatica PowerCenter. 1 and more years of experience on Informatica’s Cloud Services( Confidential ).
• Strong experience in using Informatica Cloud Services( Confidential ), Oracle, UNIX, Business Objects, Control-M.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Quality experience in interfacing with client, handling client’s expectation, strong communication, interpersonal and leadership skills. Extensively involved in the project initiation, plannings, meetings and test closures.
• Strong background in implementing Proof of Concepts (POC) for the ETL design, testing procedures, migration techniques and defect management workflows.
• Knowledge in all phases of development and testing life cycle of the project.
• Good experience in preparation and review of design documents, development estimations, test cases, test plans and test executions.
• Worked extensively in the domain of Banking and Finance.
• Participate in Functional Spec, review meetings, working with business management team to ensure ETL development requirements are appropriately identified and included in the business requirements.

TECHNICAL SKILLS:

Data Warehousing Tools: Informatica 10.1/9.5.1/8.6/7.0 , Informatica Cloud Services ( Confidential )SAP Business Objects, Cognos, Data Analyzer, Power Exchange, Control - M.

Databases: Amazon Redshift (AWS), PL/SQL, RDBMS, Oracle 11/10g/9i/8i, MS SQL Server 2005/2000.

Programming Languages: SQL, PL/SQL, SQL Plus, HTML, XML, C, C++, UNIX Shell Scripting.

Tools: /Utilities: Oracle PL/SQL Developer, TOAD, Jenkins, Subversion.

Operating Systems: Windows 9X/2000, Windows XP, UNIX, Linux.

WORK HISTORY:

Confidential

Senior Associate

Responsibilities:

• Working as a Senior Associate on Data warehousing Tools for one of the world's fastest growing providers of technology Company.
• Technically lead independently the supporting application used in retail business for the Insurance client at their US location.
• Analyze business requirements and functional specifications for the applications and estimated/developed the ETL specifications on Informatica Cloud Services ( Confidential ).
• Help develop Confidential mappings, mapping configurations, task flows.
• Prepare connections, Import Power Center mapplets and prepare the error handling document to maintain the error handling process.
• Parameterized the mappings and increased the re-usability.
• Implement performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Help migrate and provide support to the code developed.
• Design and implement a plan for all types of data movement or modification requested and approved by management.

Confidential

Senior Consultant

Responsibilities:

• Worked as a Senior Consultant on Data warehousing Tools in one of the world's foremost providers of consulting, technology and outsourcing Company.
• Technically lead independently the supporting application used for revenue reporting on Informatica Cloud Services ( Confidential ).
• Build mappings, mapping configurations, task flows on Confidential . Configure schedules, connections, data replication tasks, run time environments on Confidential .
• Analyzed business requirements and functional specifications for the applications and estimated/developed the ETL specifications.
• Develop mappings and Unit test mappings with the test data.
• Implement performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Design and implement a plan for all types of data movement or modification requested and approved by management.

Confidential

Associate

Responsibilities:

• Working as an Associate on Data warehousing Tools for a global financial services company based in USA.
• Technically lead independently the supporting application.
• Analyze requirements for new requirements and estimate/develop/understand the ETL and Business Objects specifications.
• Develop Power Center mappings and Unit test mappings with the test data.
• Make necessary amendments to the BO universe and create BO reports on top of the requirements gathered.
• Provide support to the code developed.
• Design and implement a plan for all types of data movement or modification requested and approved by management.

Confidential

I.T Analyst

Responsibilities:

• Worked as an I.T Analyst on Data warehousing tool - Informatica for Confidential and deployed on a project assignment with one of the world’s leader in energy domain British Petroleum.
• Technically lead all the applications as supported by the BP-ISE for both US and UK.
• Analyzed business requirements and functional specifications for the applications and estimated/developed the ETL specifications.
• Extracted data from oracle database and flat files and staged into a single place and applied business logic to load them in the central oracle database.
• Parameterized the mappings and increased the re-usability.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs using UNIX shell scripting.
• Provided support to the code developed for the code residing on QA and for initial days in production.

Confidential

Software Engineer

Responsibilities:

• Analyze requirements for Confidential module, seek business logics from the client, gain functional knowledge on the Confidential insurance subject, design program and technical specification documents.
• Estimate the ETL efforts needed to help build Confidential module and develop the ETL specifications.
• Develop mappings and Unit test mappings with the test data.
• Extensively used Informatica debugger to figure out the problems in mapping.
• Also involved in troubleshooting existing ETL bugs.
• Analyze requirements for TTP module, seek business logics from the client, gain functional insights on the subject, design program and technical specification documents.
• Estimate the ETL efforts needed to help build module and develop the ETL specifications.
• Develop mappings and Unit test mappings with the test data.

Confidential

Software Engineer

Responsibilities:

• Programmer for Stock Plan Services Next Generation Reporting for a leading financial services company based in USA.
• Confidential is a cost effective engine for acquiring, converting and developing PWI households. It provides stock plan administration services to large corporate employers, to gain access to employee households with equity compensation assets.
• Develop mappings and Unit test mappings with the test data.
• Provide support to the code developed when the code is in QA and for initial days in production.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Design and implement a plan for all types of data movement or modification requested and approved by management.
• Develop mappings and Unit test mappings with the test data.