ETL lead Resume

PROFILE:

Over 10 years of solid experience in Core datawarehouse, BI.
Deep experience in providing technology leadership, architecture guidance in large global BI program implementations for Confidential 500 customers across industries - Banking and Financial Service, Healthcare and Manufacturing.
Extensively worked on Informatica 9.6.1, Informatica Administration, Business Object XI R3 report development and administration, Xcelsius, and also proficient in scheduling tool Appworx/Autosys, UNIX, Oracle 11g
Exposure in the Production support projects and also in development projects as Technical Lead.
Have experience to design and build data warehouse.
Exposure in project management. Successfully worked in teams of various sizes to achieve personal and team goals.
Got many customer appreciations for the nice work done.

SKILL:

Natural Languages: Proficient in English, Moderate in Spanish

Operating systems: UNIX, Linux, Windows 7

Languages: SQL, Unix shell scripts

Databases: Oracle 11g, SQL Server

Primary Skill: Informatica 9.6.1, 9.5.1, 9.1, 8.6, 8.0, 7.6, Business Object XI R3, Business Object Xcelsius, Appworx, Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Technologies Used: Informatica 9.6.1, 9.5.1, Business Object, Confidential, Autosys

OS: Linux, Windows

ETL lead

Responsibilities:

Was actively involved in Confidential installation in prod and non-prod environment
Was actively involved in System and integration testing, User acceptance testing and setup disaster recovery environment
Was responsible to address Confidential feed failures and setup file transfer through Confidential internal tool - NDM and daily/monthly/quarterly report generation
Was responsible for RCA of failure of Production jobs, coordinating with upstream system owner and IT managers, Confidential Business team and for small enhancement project.
Was actively involved to schedule the jobs through Autosys.

Confidential

Technologies Used: Informatica 9.6.1, 9.5.1, Confidential, Appworx

OS: Linux, Windows

ETL lead

Responsibilities:

Worked as senior developer and Informatica administrator and co-ordinated with offshore team to develop the ETL
Was actively involved in System and integration testing, User acceptance testing
Become overall technical lead once Confidential Release I went live and continued in production support team till Confidential Release III went live.
Involved in Informatica administration, Informatica server setup, Disaster recovery environment setup
Was responsible for RCA of failure of Production jobs, coordinating with upstream system owner and IT managers and for small enhancement project.
Supervised many automation projects to reduce the human error and save manual effort and to create Standard Operating Procedures (SOPs)
Project 3:

Confidential

Technologies Used: Informatica 9.1.0, Informatica 9.0.0, Business Object XI R3, Xcelsius

OS: Sun Solaris, Windows

Senior developer

Responsibilities:

Design and development of ETL for small/large enhancement project and BO report and dashboard based on ad hoc request.
Informatica administration and Business object administration.
Monitoring on daily ETL and reporting jobs, scheduling of new jobs based on business request
Creating standard SOPs and involved in automation project which save times and human effort simultaneously.

Confidential

Senior developer

Technologies Used: Business Object Xcelsius 2008, Business Object XI R3, Informatica 8.1.6, Oracle 10g

OS: Windows XP

Responsibilities:

Confidential

Senior developer

Technologies Used: Business Object XI R3, Informatica 8.1.6, Oracle 10g

OS: Windows XP

Responsibilities:

As a team member involved actively in DW environment setup from scratch
Analysis of the BSD docs sent from Onsite
Creating Metadata XML file.
Creating Oracle Metadata Insert statement for PEU and ET on specific BDB .
Developing Informatica Mapping and Workflow
Used most of the Transformations such as Source Qualifier, Aggregator, Lookups, Filters, Sequence generator, Expression, Update strategy, Joiner, Normalizer etc.
Used Informatica workflow manager to create sessions. Workflows to run the mappings.
Developing Unit Test Plan and test cases.
Executing Unit Test Cases.
Bug Fixing of the associated mapping (if any).
Ensure quality of deliverables by following pre-defined standards and templates
Day to day coordinating between onsite and offshore from offshore.