Sr. Associate Resume Teaneck, NJ - Hire IT People

SUMMARY

15 years experience in ETL development using Oracle Warehouse Builder and Informatica PowerCenter. 19 years experience on Oracle RDBMS. Proven communication and problem - solving skills. Works well with all levels of personnel from various departments.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Teaneck, NJ

Sr. Associate

Responsibilities:

Confidential, Philadelphia, PA

Lead Application Developer

Responsibilities:

Gathered requirements and the functional specs provided by the data architects and Business analysts and created technical specs documents for all the mappings
Involved in all phases of SDLC from requirement, design, development, testing, production implementation and support for production environment.
Extracted data from various sources which include the Mainframe, oracle databases and SQL Server into the Oracle tables using Informatica Mappings and Sessions
Extensively used PowerCenter to design multiple mappings with embedded business logic. Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.

Team Leader/Application Development Manager

Confidential

Responsibilities:

Lead and managed the CPL Data Warehousing/Business Intelligence group which is responsible for building, maintaining and providing support of the various data marts and BI reports utilizing Oracle Warehouse Builder, Informatica PowerCenter and Oracle BI Discoverer.
Departments being supported include Marketing, Telesales & Service and Policy Holders Services.
Works with Business Analyst when gathering requirements and business rules.
Develop and maintain good relationship with the internal customers.
Assist and guide team members on OWB usage when necessary. This includes trouble shooting and enhancing the mappings.
Along with the DBA, determines when it is appropriate to upgrade the Oracle DB and its supporting tools such as OWB and Discoverer.
Stays abreast of the current technologies especially the Oracle database, OWB and Discoverer.

Senior Programmer/Analyst

Confidential

Responsibilities:

Spearheaded the creation of the MDDB system for the Marketing department using Oracle Express and Sales Analyzer.
In 2000 successfully redesign the OLAP system in OWB.
Converted all the FOX PRO reporting systems to Oracle database using OWB.
Developed Forms and Reports in Oracle 7 for the Marketing department.

Programmer/Analyst

Confidential

Responsibilities:

Mainframe Programmer for the Vantage admin system using COBOL II.
Responsible for the development, maintenance and support of the Documerge system.
Provided support for the TOTAL-PLUS system using Assembler language.
Responsible for the development, maintenance and support of the Documerge system.
Responsible for the development, maintenance and support of the Documerge system.