Data Integration Consultant Resume
New York, NY
SUMMARY:
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.
HIGHLIGHTS:
- ETL / ELT Development
- Data Warehouse Development
- Requirements Gathering
- Performance Tuning
- Database Architecture
- End - user Support
- Data Modeling
- Python Programming
TECHNICAL SKILLS:
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
PROFESSIONAL EXPERIENCE:
Data Integration Consultant
Confidential, New York, NY
Responsibilities:
- 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
Responsibilities:
- 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
Responsibilities:
- 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
Responsibilities:
- 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
Contractor
Confidential, New York, NY
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
Senior Programmer Analyst
Confidential, Commack, NY
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