We provide IT Staff Augmentation Services!

Sr. Associate Resume

Teaneck, NJ

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

  • Informatica PowerCenter 9.6, Oracle DB 11g, TOAD for Oracle
  • Oracle Warehouse Builder 10g, SQL*Plus

PROFESSIONAL EXPERIENCE

Confidential, Teaneck, NJ

Sr. Associate

Responsibilities:

  • ETL development in a CRM application.
  • Involved in requirement gathering and estimations
  • Provide Technical Design Documentation
  • Involved in all testing phases.
  • Provide test plans and test results.
  • Involved in Production Implementation and validations.

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.

Hire Now