ETL Developer Resume

SUMMARY

8 Years experience in SDLC from requirements gathering to delivery for complex data warehouse applications.
Expert in ETL methodologies and data warehousing concepts with excellent troubleshooting skills.
Excellent leadership skills in leading teams to develop customized applications. Proficient in converting business requirements into technical specifications.
Superior analytical, time management, collaboration and communication skills.
Cheerful personality, positive attitude and team player.

TECHNICAL SKILLS

ETL tools: Ab Initio (Version 3.13), SSIS, DM Express

Programming Languages: UNIX Shell Scripting (K - shell) and Oracle PL/SQL

Platform: Windows XP and UNIX

Database: Oracle 11g, SQL Server 2008

Tools: Toad

Schedulers: ESP Workstation

Domain/Functional Area: Life Sciences

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

As SME of the Longitudinal Rx (LRx) system played an integral role in the smooth execution of this highly critical project. Identify problem areas and provide innovative, cost effective solutions to complete the deliverables within the targeted timelines.
Redesign, develop and implement an existing Application from Abinitio to DM Express.
Used Abinitio to perform Data Investigations to identify and resolve any data concerns.
Received multiple appreciations from management for complete ownership of this highly critical project and dedication to deliver the project within the tight deadlines.

Technologies used: UNIX, Oracle, Pl/SQL, Abinitio, ESP Workstation

Confidential, PA

ETL Developer

Responsibilities:

Built new data warehouse and subsidiary data marts to source data from a new ODS system.
Managed and coordinated an offshore team of 7 associates with various modules in parallel development.
Expedited large volume testing for QA team by automation using Abinitio.

Technologies used: UNIX, Oracle, Pl/SQL, SQL Server, Abinitio, ESP Workstation

Confidential, PA

ETL Developer

Responsibilities:

Single handedly built new process and standards for delivering custom deliverables for new product. This project followed agile methodology.
Built custom SSIS jobs and developed reusable code which could be used for different deliverables improving the efficiency and reducing time required for building each deliverable.
Developed into SME of the system and provided data mining solutions to client service team.
Maintained high standards of quality in deliverables and was received multiple appreciations from clients.
Automated various processes to expedite the client delivery and maintain quality standards.

Technologies used: SSIS, T-Sql, SQL Server Database, Mainframe, Microsoft Visual SourceSafe