Candidates About

Paul Zangre

IT professional with a focus on data integration and more than 15 years of experience in developing technical solutions in order to meet the needs of business users.

QUALIFICATION HIGHLIGHTS

PROFESSIONAL EXPERIENCE

Data Integration Consultant, 2017 – 2018

The Nth Power, Telecommute, Brooklyn, NY

·         Led the development and testing of ODI 12c mappings and packages that integrate data to Hyperion Planning and Essbase

·         Developed error handling procedures used to notify users of data load errors using Python

·         Migrated ODI 11g mappings and packages to ODI 12c

·         Documented new procedures to be handed off for ongoing support

Lead ETL Developer, 2014 – 2017

Macmillan Publishers, New York, NY

·         Led the development, testing, and implementation of ETL processes that were used to integrate data from SQL Server to Oracle DWH using Oracle Data Integrator (ODI) 12c, PL/SQL, and Python.

·         Strategically redesigned data load mappings to improve processing time from two hours down to two minutes, bringing updates closer to real-time

·         Installed, configured, and administered ODI environments, agents, and repositories.

·         Interacted with business users to gather requirements and design integration solutions

ETL Developer, 2012 – 2013

FXCM, Inc., New York, NY

·         Led the development of mappings and workflows used to integrate investment accounts between Back Office and Salesforce CRM

·         Gathered requirements from business users to develop integration solutions

·         Scheduled integration processes to run automatically and provided ongoing global production support

·         Created complex queries used to extract data from Oracle databases using SQL

Production Support Consultant, 2010 - 2011

WebMD, New York, NY

·         Designed and developed databases used in mobile applications

·         Developed queries used to upload healthcare data into web-based applications via SQL Server

·         Wrote SQL queries used to extract data and generate reports for business users

Senior Programmer Analyst, 2001 – 2008

Forest Laboratories, Inc., Commack, NY

·         Played a lead role in the upgrading of a proprietary data integration system

·         Determined, with application development team, how to maintain customer data management application changes and ETL changes as requested by business leaders in accordance with FDA compliance; programming included the use of Oracle 10g database system, Informatica PowerCenter 8, MDM application development environment, PL/SQL, UNIX Shell Scripting, MS Access and MS Excel

·         Extracted healthcare data from relational databases using UNIX Shell Script, SQL querying, TOAD and SQL*Plus

·         Designed and developed applications used by management to make business decisions; development included the use of .NET, HTML, SQL Server and JavaScript

·         Handled tasks in enterprise-wide data management system, such as, supporting end-users, analyzing data and monitoring data integrity

·         Worked with Oracle database administrator to troubleshoot and resolve issues of production system, as well as optimize system performance

Data Team Supervisor, 1999 - 2001

MSC Industrial Direct Co. Inc., Melville, NY

·         Supervised data mining team aimed at loading and cleansing production data for optimum accessibility on e-commerce website

·         Interviewed applicants for database editor positions

·         Developed in-house database management applications in MS Access and MS Excel

·         Established enterprise-wide business rules for new and existing product data

TECHNICAL SKILLS

Platforms: Linux, UNIX (Sun, AIX), Windows Server

Programming Languages: Python, Java, Jython, SQL, T-SQL, PL/SQL, XML, ASP.NET, C#, Perl, VB, DHTML

Scripting Languages: JavaScript, VBScript, UNIX Shell Script, DOS

Databases/RDBMS: Oracle, MS SQL Server, Hyperion Essbase

Business Applications: Microsoft Office Suite, Visio, Business Objects, Confluence

EDUCATION

Bachelor’s Degree in Information Science, Minor in Business, 1999

State University of New York, Oswego, NY

Oracle Data Integrator 12c Certification, 2014