We provide IT Staff Augmentation Services!

Data Integration Consultant Resume

Brooklyn, NY

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

Hire Now