PROFESSIONAL SUMMARY:

• Business Intelligence professional experienced in designing Data Integration and Analytics solutions for Retail, Healthcare and Energy and Utility industries. Accomplished Technical Lead Engineer coordinating teams of analysts and developers on various Data warehouse and Reporting projects.
• 14 years 2 months of data warehousing experience in the areas of ETL design, development, testing and Production support.
• Expertise in Oracle Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data like Flat Files, XML Files, Oracle, SQL Server into Data Warehouse/Data Marts using Informatica.
• Experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Oracle.
• Strong Exposure with Middleware Technologies like ETL.
• Working experience in UNIX shell scripting.
• Strong analytical skills in managing business applications and data - warehouse solutions.
• Extensive experience with development, testing, debugging, implementation, documentation and production support.
• Excellent communication, client interaction and problem solving skills.
• Quick adaptability to new technologies and zeal to improve technical skills.
• Good analytical, programming, problem solving and troubleshooting skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Data Stage

Databases:: Oracle, Microsoft SQL Server, my SQL

Web Services: SOAP

Database Utilities:: Toad, SQL Developer

Reporting:: Business Objects, Cognos, SSRS

Operating Systems:: Windows, Unix, Linux

Languages:: SQL, PL/SQL, Unix shell scripting

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Technical Lead

Responsibilities:

• Perform maintenance and Support of the Credit Risk, Emptoris and Energy Credit Manager Applications.
• Monitoring the automation process using HP Tools and create incidents/service requests in ServcieNow tool and resolving Credit Risk, Emptoris and Energy Credit Manager integrations/process issues that occur during the daily monitoring run.
• Handles Disaster Recovery for Credit Risk application on every year and Emptoris application on alternative year, update Disaster Recovery plan for Credit Risk and Emptoris applications information using LDRPS (Living Disaster Recovery Planning System).
• Gathering requirements from business/functional consultants and analysis of the requirements for Enhancements of existing Process/reports and new requirements and develop reports using SSRS tool for Credit Risk application MSBI reports and develop integrations/process using Informatica PowerCenter 9.6.1. tool, Oracle Database, DataStage tool, Unix shell scripting and Cognos reports for Credit Risk, Emptoris and Energy Credit Manager Applications.
• Handling Application Vulnerability Management for Credit Risk, Emptoris and Energy Credit Manager Application servers and perform find Vulnerabilities using Archer tool and apply related patches on these Credit Risk, Emptoris and Energy Credit Manager Application servers.
• Implement the automatic scripts using Unix Shell Scripting and batch script to automate the Credit Risk, Emptoris and Energy Credit Manager integrations/process.
• Create technical design and mapping specification documents for enhancement and new development tasks for Credit Risk, Emptoris and Energy Credit Manager integrations/process.
• Review the code developed by peers for Credit Risk, Emptoris and Energy Credit Manager integrations/process and provide my inputs/findings to peers.
• Perform UAT and Production deployment support for Credit Risk, Emptoris and Energy Credit Manager integrations/process.
• Communication with Offshore team and Client Partners, this should also include weekly updates to Representatives from Client Business Partners.
• Responsible for meeting deadlines on design, development, testing for Credit Risk, Emptoris and Energy Credit Manager integrations/process with efficient and effective team work.
• Sharing functional knowledge with offshore team for Credit Risk, Emptoris and Energy Credit Manager applications.

Confidential

Informatica Technical Lead

Responsibilities:

• Gave reverse KT to the client after getting initial KT from the outgoing vendor.
• Solved change points for the customer related to MDM, ETL Informatica as well as Unix shell scripting Application Development and Unit Testing.
• Providedsupport of bug fixes and issues reported.

Confidential

Informatica Technical Lead

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Developed PL/SQL scripts.
• Developed Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Performed review of the code and status updating to onsite team
• Performed UAT and Production deployment support.

Confidential

Informatica Technical Lead

Responsibilities:

• Analyzed the requirements and design.
• Created of ETL Technical Design documents and mapping specification document.
• Performed allocation of work to team members and partially involving in build activities.
• Helped the offshore team resolve the technical issues faced during
• Performed development and Unit testing of the ETL.
• Performed review of the code and status updating.
• Performed UAT and Production deployment support.

Confidential

Informatica Technical Lead

Responsibilities:

• Understanding existing eco system databases and RMS functionality.
• Responsible for requirement gathering from respective functional consultants.
• Designed and developed mappings to transform data from Eco system to the target RMS database.
• Involved in designing of intermediate data model that is required for data migration.
• He perform involved in the tuning of mappings and scripts for optimizing the performance by using the best practices in Informatica.
• Responsible for knowledge transfer of business requirements to the team.
• Responsible for meeting deadlines with efficient and effective team work.

Confidential

Senior Informatica Developer

Responsibilities:

• He perform involved in preparation of low- level design document.
• He develop mappings/sessions in informatica.
• He perform involved in preparation of unit test cases for ETL.
• He perform to knowledge transfer and share work with peers.

Client: Confidential Inc

Role: Senior Informatica Developer

Description:

The project entails providing ETL services for Confidential, which include maintenance and support of all ETL Infrastructure and applications. The project entails in helping JDI business to move data from one application to another. The main customer for the ETL team is the Business Intelligence team in Johnson Diversey. The business intelligence team has built many data marts, data warehouses, ODS etc which are used by the business people for day to day reporting. The sources for these BI systems are the ERP systems in JDI like JD Edwards. The Global BI Team supports the data flow from JDE to the various datamarts in the Rapid Decision Suite.

Responsibilities:

• Involved in preparation of low- level design document.
• Developed mappings/sessions in informatica.
• Involved in preparation of unit test cases for ETL.
• Involved in knowledge transfer and share work with peers.

Confidential

Informatica Developer

Responsibilities:

• Developed the new mappings by using informatica 7.1, created corresponding sessions and workflows to load the data.
• Involved in preparation of low- level design document.
• Performed developed mappings/sessions in informatica.
• Involved in preparation of unit test cases for ETL.
• Updated tech leader regularly on status of project.
• Involved in review of the code and status updating to onsite team

Confidential

Informatica Developer

Responsibilities:

• Developed the new mappings by using informatica 7.1, created corresponding sessions and workflows to load the data.
• Involved in preparation of low- level design document.
• Involved in preparation of unit test cases for ETL.
• Update tech leader regularly on status of project.
• Review of the code and status updating to onsite team.
• Performed UAT and Production support.