SUMMARY:

Highly motivated and results driven IT professional with vast experience of ETL and Data Integration development and implementation of business solutions in various corporate industries. Proven track record as Technical Lead on successful large project deliveries with ability to acquire, assemble and integrate different technologies into an automated, stream lined production environment. Technical platforms include Informatica, DB2 EEE, SYBASE, Oracle, SQL Server, Teradata and UNIX.

TECHNICAL SKILLS:

Operating Systems: DB2 EEE, Teradata 13.10, Sybase, Oracle, SQL Server, UNIX HP & SUN, Informatica

PROFESSIONAL EXPERIENCE:

Data Warehouse Consultant

Confidential, Somers, NY

Responsibilities:

• Perform duties as Lead ETL Developer on baseline and investment project initiatives.
• Design, develop and implement over 1000+ of complex ETL Informatica processes, DB2 stored procedures, Teradata BTEQ scripts.
• Supervise ETL resources on development and production support activities.
• Provide on call 24 x 7 production support on rotating basis for over 1000+ processes.
• Provide knowledge transfer to on - shore and off-shore developer resources.
• Perform code reviews of all ETL processes to maintain a level of standards and performance.
• Create and maintain Autosys and Control-M job schedules.
• Prepare test cases, perform testing and documentation in Mercury Quality Center tool for production migration approvals.
• Collaborate with DBAs to resolve database performance issues on both source and target databases.
• Interact with business users and team leads in correlating business specification, identifying data sources and development strategies.
• Designed and developed voice pick near real time interface for retrieving messages from queue and loading into DB2 DWH.
• Performed duties and led the technical direction as the lead ETL architect, designer and technical developer on DB2 NextGen Data Warehouse and DB2 to Teradata Data Warehouse Re-platform projects.
• Developed and documented ETL standards and guidelines for company-wide usage.
• Enhancement and maintenance of data extracts to downstream reporting systems.
• Received multiple customer/application appreciation awards.
• Utilized Informatica v5 thru v9.5, Teradata 13.10 / DB2 EEE / AIX & HP Unix / Oracle / Siebel / Sybase /SQL Server.

Confidential, San Francisco, CA

Senior Data Warehouse Consultant

Responsibilities:

• Performed the role of Informatica system administrator for multiple projects
• Installed and configured PowerCenter and Informatica Power Plugs on Sun Unix systems.
• Installed and configured BW Integration Server on Sun Unix system.
• Performed performance tuning on all Informatica mappings before production implementation.
• Acted as the subject matter expert (SME) for all corporate data warehouse projects.
• Developed and implemented Informatica change management process.
• Developed and implemented Informatica security setup.
• Developed design and prototype for data ETL processes from overseas to U.S. data base.
• Utilized Informatica versions 4.7.1, 4.7.2, & 4.7.3, Oracle 8i / HP Unix
• Acted as a co-project manager responsible for the full life cycle of the multiple concurrent business unit data warehouse projects at The Hartford.
• Performed duties as the Informatica administrator for all code migrations.
• Performed duties as a technical lead and prototyped the initial design for a blue print/best practice for each of the multiple projects to follow for their mappings.
• Designed, developed, tested and implemented medium complexity mappings when required.
• Provided training for The Hartford employees and The Hartford consultants.
• Performed initial setup for Informatica implementation/management process for The Hartford.
• Developed code vs. folder migration and naming conventions.
• Utilized Informatica versions 4.6, Oracle 8i / HP Unix / AS400.

Confidential, Groton, MA

Responsibilities:

• Performed duties as technical resource on data warehouse project. Informatica ETLs.
• Developed and documented business rules to business logic for developers
• Developed several very complex mappings for tracking mail order business process.
• Provided training Confidential employees as I was the only ETL developer in the IT department.
• Partnered with Oracle consultant to setup database design and performance of load strategies.
• Utilized Trillium for data cleansing.
• Utilized Informatica versions 4.6, Oracle 7.5 / Sun Unix / AS400.

Confidential, Westborough, MA

Responsibilities:

• Performed duties as team lead for Informatica ETL team.
• Documented current business rules/logic for implementation approvals by Anderson.
• Designed and developed several hundred medium complexity slowly changing dimension mappings with heterogeneous sources, targets, connected and unconnected lookups, stored procedures, and update strategies.
• Provided training to Confidential employees and Confidential consultants using Informatica in best practice development.
• Utilized Informatica versions 4.5 & 4.6, Oracle 7.5 / Sun Unix / SQL 6.5 / IBM mainframe.

Confidential, Malvern, PA

Information Systems (MIS) Developer

Responsibilities:

• Performed duties as developer than lead developer on the Corporate Strategic Data Warehouse project utilizing SQL Server, SSIS data transformations and Web based pivot tables for reporting.
• Developed Time and Expense Entry system project, utilizing Lotus Notes email entry system to flat files to upload into main frame TAPS for corporate employee time tracking system.
• Performed duties as a developer and support for the Employee Time and Absence Tracking System .
• Performed duties as a developer and support for the Events Tracking system.
• Performed duties on the CICS upgrade project and Y2K readiness project.
• Provided on call support during non-business hours for all MIS systems.
• Received employee recognition, achievement and merit awards.
• Utilized SQL Server, SSIS, Lotus Notes.