SUMMARY:

• Analytical, results - driven, and performance-focused professional, offering over 8 years of experience in Extract Transform Load (ETL) development, application consulting, data warehousing, and production management. Known for exceptional skill to lead and implement process changes and provide business solutions toward continuous organizational growth. Skilled Confidential executing various initiatives with focus on driving strategy. Articulate communicator.

TECHNICAL SKILLS:

Database Software: Oracle 2005, Teradata, Netezza, SQL server

Extract Transform Load Tools: Informatica 9x

Reporting and Data Archiving Tools: Spotfire 7.0.0 and Informatica ILM 6.1.1

Programming: Microsoft SQL

Microsoft Applications: Excel, Visio, Word, and PowerPoint

Operating Systems: Windows Server 2003 and UNIX.

PROFESSIONAL EXPERIENCE:

ETL Team Lead/Technical Specialist

Confidential, Melbourne, FL

Responsibilities:

• Devise an Extract Transform Load (ETL) Informatica solution for data integration.
• Expertly formulate Informatica Mappings, workflows, reusable mapplets, and transformations.
• Provide expert supervision to a team comprised of ETL developers Spotfire report developers with a total team size of 8.
• Collect requirements for Informatica 9x ETL mappings and workflows development.
• Perform data modeling as well as performance improvements, code review, and data analysis and design.
• Relay dependencies and risks to stakeholders.
• Identify sprints and deliverables while streamlining the agile process during project implementation.
• Led the development of best practices and standards and performed code migration.
• Closely monitor onshore and offshore operations including India Development Center.

ETL team lead/technical specialist

Confidential

Responsibilities:

• Designed ETL Informatica Solution and successfully built Spotfire Analytics Reports.

ETL team lead/technical specialist

Confidential

Responsibilities:

• Maximized performance through the use of Teradata utilities like FastLoad, MultiLoad, and Tpump.

Team Lead

Confidential, New York, NY

Responsibilities:

• Systematically compiled requirements and performed in-depth impact analysis.
• Spearheaded the development of Informatica ETL reusable mapplets, mappings, and workflows.
• Conceptualized and produced code reviews and Design reviews of ETL projects across the BI-DW capability in the organization
• Created estimations and plans for ETL code execution.
• Rendered guidance to new staff from universities.
• Took full charge of conducting code migration while establishing best practices and standards.
• Successfully developed the ILM Infrastructure setup and ILM installation to Linux server as well as Power Exchange on Windows server.
• Built a three-way communication and connection among Power Exchange, ILM, and z/OS.
• Produced a technical design for data archiving and retirement.
• Exhibited superior talents in creating and executing retirement jobs for the safe retirement of DB2 and VSAM datasets.
• Obtained the Best Project in the BI/DW vertical with the highest customer satisfaction index rating of 4.9/5.
• Maintained active coordination between Onshore and Offshore teams in India.

Team lead and developer

Confidential

Responsibilities:

• Interpret requirements in close coordination with the Offshore Team.
• Spearheaded the execution of the payroll module.

Team lead and developer

Confidential

Responsibilities:

• A data mart structured in Netezza DB and transactional data from the ODS to be loaded into the data mart through the use of Informatica ETL tool.

Application Consultant

Confidential

Responsibilities:

• Expertly carried out data modeling through the use of Bill inmon approach.
• Conceptualized and developed Informatica Mappings and workflows through UNIX Scripts.
• Actively dealt with the Informatica power center installation 9.1 HIGH AVAILABILITY and management.
• Developed a reusable mapplet for validation of item parts in an invoice, used by more than 13 ETL mappings
• Fulfilled role as Production Support Team lead.
• Played an integral role in implementing high availability architecture.
• Served as a driving force in realizing the Analytics project on KPIs through the new dashboard model proposal which brought approximately €123K revenue to the company.
• Minimized process time by over 500% and down to 2hours from 10 to 12 hours through the implementation of a unified data model for all billing system’s complex data.
• Earned client appreciation during the onsite visit Confidential The Hague, Netherlands regarding data model and designs.

Application consultant

Confidential

Responsibilities:

• Effectively formulated Informatica mappings and workflows for various interfaces.
• Performed comprehensive unit testing and integration testing.
• Actualized the continuous performance improvement of existing ETL code.
• Acquired various recognitions including Ace in Accenture year 2009 for outstanding project contributions as well as Extra Mile for demonstrating project assistance.
• Played an instrumental role in guiding and transforming new hires into software engineers through s.

Software Engineer

Confidential

Responsibilities:

• Served as a driving force in building complex ETL mappings and workflows and code migration.

Software Engineer

Confidential

Responsibilities:

• Applied industry expertise in developing more than 14 ETL interfaces with XML and Flatfile sources.