Data Integration Consultant Resume Brooklyn, NY - Hire IT People

SUMMARY:

As an IT professional with a focus on data integration I have more than 15 years of experience in gathering requirements and conceptualizing technical solutions in order to meet the needs of business users.

EXPERTISE AREA:

ETL / ELT Development
Data Warehouse Development
Requirements Gathering
Performance Tuning
Data Analysis
End - user Support
Data Modeling
Object-oriented Programming

TECHNICAL SKILLS:

Platforms: 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 12c, MS SQL Server, Hyperion Essbase

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

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

Data Integration Consultant

Responsibilities:

Led the development and testing of ODI 12c mappings and packages that integrate data to Hyperion Planning and Essbase
Developed error handling procedure 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

Confidential, New York, NY

Lead ETL Developer

Responsibilities:

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
Created complex SQL queries used to extract, analyze and transform data
Interacted with business users to gather requirements and design integration solutions

Confidential, New York, NY

Lead Data Integrator

Responsibilities:

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

Confidential, New York, NY

Contractor

Responsibilities:

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

Confidential, Commack, NY

Senior Programmer Analyst

Responsibilities:

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

Confidential, Melville, NY

Data Team Supervisor

Responsibilities:

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

We provide IT Staff Augmentation Services!

Data Integration Consultant Resume

Brooklyn, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship