PROFESSIONAL SUMMARY:

• Total 14 years of IT experience in designing and developing in the field of Business Intelligence/Data warehousing.
• 10 years of experience in using Informatica Power Centre ETL tool including Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Knowledge in design of Extract, Transform, Load environment using Informatica Power Center, currently working on Informatica 10.2.
• Strong understanding of Data Warehousing Life Cycle and Business Intelligence.
• Good knowledge of dimensional data modeling, star schema/snowflakes schema, fact and dimension tables.
• Understanding of Oracle PL/SQL programming.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Normalizer, Union, Unconnected / Connected Lookups and Aggregators.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Data modeling experience using Star Schema/Snowflake modelling, Fact and Dimensions tables data modelling.
• Skilled in performance tuning of ETL processes and SQL queries.
• Hands on experience in tuning ETL, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings/jobs, and sessions.
• Experience in Insurance, Money Transfer and Payment Services domains, Banking domains.
• Experienced in interacting with business users, business analysts. IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Experienced in Problem Management (Root Cause Analysis), Release Planning & Implementation, giving presentations, Knowledge Transfer.
• Excellent communication, presentation and interpersonal skills and ability to prioritize and coordinate work across different geographic locations.

TECHNICAL SKILLS:

Languages: C#, SQL, PL/SQL

Database servers: Oracle 11g, SQL server and DB2

ETL Tools: Informatica Power Centre, Informatica Power Exchange

Scheduling Tool: Control M, Automic, ESP, Autosys

Databases: Oracle, Sql Server 2000/2005, Ms Access, Sybase, DB2

Database Tools: SQL Developer, SQL server management studio

Versioning Tools: CVS, Perforce

Scripting Languages: Unix Shell Scripting

Operating System: Windows 2003, 2008, XP and Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix

Informatica Technology Lead

Environment:

Database: Oracle

ETL Tool: Informatica 10.2

Scheduling tool: Control M, Automic

Responsibilities:

• Event management/Job Monitoring
• Incident Management
• Problem Management
• Release/Change/Patching Management
• Capacity Management
• Knowledge Management
• Communication Management
• Operations Management
• Enterprise Initiatives
• Service Transition
• Service Improvement - Automation
• Business Request & Audit Requests Fulfilment
• Service Measurement & Reporting

Confidential, Irvine

Informatica Technology Lead

Environment:

Database: Oracle

ETL Tool: Informatica 9.6.1

Scheduling tool: Autosys

Responsibilities:

• Estimation of user stories.
• Design and development of code.
• Unit testing, integration testing
• Peer code review

Confidential

Informatica Technology Lead

Environment:

Database: Oracle

ETL Tool: Informatica 9.6.1

Scheduling tool: ESP

Responsibilities:

• Gather requirements from Client/Onsite.
• Leading a team of 4 members at Offshore.
• Resolving all environmental issues.
• Analysed the High Level Design and Technical Specification Documents .
• Worked on Requirements analysis, Design, development, Quality Assurance and Operations support.
• Assigning the tasks to the team members and help them in developing the code and unit testing.
• Developed several Mappings and Mapplet using corresponding Source, Targets and Transformations.
• Extensively worked on transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator and Rank.
• Expertise in tuning the mappings and sessions to optimize the performance.
• Reviewing the code before delivering it to the client/onsite.
• Resolving technical and design issues.
• Documentation of various standards, best practices & review process documents to be used as guidelines.
• Single point of contact for SIT/UAT and Performance testing phases.
• Single point of contact for all the deployments.
• Worked on production related documentation.
• Given Knowledge transfer to Application Support Group.
• Given expert solution to the users for problems in Informatica.
• Mentored new team members with continuous knowledge transfer.

Confidential

Informatica Technology Lead/Onsite Co-ordinator

Environment:

Database: Oracle

ETL Tool: Informatica 9.6.1

Operating system: Unix

Scheduling tool: ESP

Responsibilities:

• Worked in client location Confidential International, Minneapolis, MN, USA.
• Gather requirements from Client.
• As an Onsite Co-ordinator I have interacted with different teams, SMEs, process & system owners to clarify the requirements.
• Also ensured to complete SIT, UAT and performance testing process.
• Contributing to the system architecture design.
• Setting up the infrastructure in co-ordination with client infrastructure team.
• Analysed the High Level Design and Technical Specification Documents .
• Requirements analysis, Design, development, Quality Assurance and Operations support.
• Reviewing the code before delivering it to the client.
• Documentation of various standards, best practices & review process documents to be used as guidelines.
• Was involved in Value Addition Activities (e.g. Audit remediation, Process automation, Defect prevention etc.)

Confidential

Informatica Technology Lead

Environment:

Database: Oracle

ETL Tool: Informatica9.0.1

Responsibilities:

• Gather requirements from Client/Onsite.
• Leading a team of 4 members at Offshore.
• Analysed the complex requirements and designed the ETLs for data cleansing and conversion.
• Designed ETLs for Audit and Error Handling.
• Coding and testing of Informatica ETLs for Data extraction and Loading.
• Created SQL queries for handling Audit and ETL requirements.
• Tuned applications both at the application and DB level for performance enhancement.
• Created UNIX scripts for scheduling jobs and notification services.
• Issue handling and fixing
• Documentation of various standards, best practices & review process documents to be used as guidelines.

Confidential

Informatica Technology Lead

Environment:

Database: DB2

ETL Tool: Informatica

Scheduler Tool: Autosys

Responsibilities:

• Gather requirements from Client/Onsite.
• Impact Analysis.
• Designing, Coding.
• Unit testing and data validations.
• Helping the team in resolving the technical/non-technical issues.

Confidential

Informatica Programmer Analyst

Environment:

Database : DB2

ETL Tool : Informatica

Scheduler Tool: Autosys

Responsibilities:

• Impact analysis.
• Tools development.
• Unit testing and validations.
• Helping the team in resolving the technical/non-technical issues.
• Prepared documents like Technical design document.

Confidential

Informatica Programmer Analyst

Environment:

Database : DB2

ETL Tool : Informatica

Scheduler Tool: Autosys

Responsibilities:

• Leading a team of 4 members at Offshore.
• Gather requirements from Client/Onsite.
• Impact Analysis.
• Building mappings according to standards.
• Created sessions and workflows following standards both for Full and Incremental loads.
• Configuration management.
• Unit testing and data validations.
• Helping the team in resolving the technical/non-technical issues.
• Prepare the road-map for the completion of tasks and plan to share the work among the team as per each individual capability.
• Prepared documents like Technical design document and Data mapping document.
• Reports were generated using Actuate reporting tool.