We provide IT Staff Augmentation Services!

Data Integration Consultant Resume

New York, NY


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.


  • ETL / ELT Development
  • Data Warehouse Development
  • Requirements Gathering
  • Performance Tuning
  • Database Architecture
  • End - user Support
  • Data Modeling
  • Python Programming


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

Languages: SQL, Python, Java, T-SQL, PL/SQL, Stored procedures, XML, ASP.NET, C#, Perl, VB, DHTML, JavaScript, VBScript, UNIX Shell Script, DOS

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

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

Tools: Oracle ODI 11g, Oracle ODI 12c, Informatica 9.x, Salesforce CRM, Siperian MDM, TOAD, SQL Developer


Data Integration Consultant

Confidential, New York, NY


  • Project-based consultant for Callidus SaaS implementations including TrueComp Commissions, Workflow and T&Q
  • Develop custom integrations using Oracle PL/SQL, SQL, Informatica, ODI, SFTP, SAP, API
  • Meet with consultants and clients on design specifications, testing and ongoing product support

ODI / ETL Consultant

Confidential, New York, NY


  • Led the development and testing of Oracle ODI mappings and packages that integrate data from Oracle to Hyperion Planning and Essbase data warehouse
  • Migrated Oracle ODI 11g mappings and packages to Oracle ODI 12.2.1
  • Developed error handling procedures used to notify users of data load errors using Python
  • Documented new procedures to be handed off for ongoing support

Lead ETL Developer

Confidential, New York, NY


  • Led the development, testing, and implementation of ETL processes that were used to integrate enterprise-wide data from SQL Server to Oracle DWH using Oracle Data Integrator (ODI) 12c, PL/SQL, and Python.
  • Oversaw data modeling and database architecture of enterprise-wide ETL projects
  • Mentored team of four ETL developers and guided them through project life cycles
  • Configured new Oracle ODI ETL environments and provided backup administrative support
  • Interacted with business users to gather requirements and design integration solutions
  • Initiated performance tuning effort to bring high latency data loads closer to real-time
  • Created algorithms for the ingestion of POS data from Amazon and other vendors into data warehouse where data was used for Business Intelligence reporting

Technical Analyst

Confidential, New York, NY


  • Led the development of ETL mappings and workflows used to integrate investment accounts between Back Office and Salesforce CRM
  • Provided administrative support of all dedicated Informatica servers
  • 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


  • 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

Confidential, 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

Hire Now