SUMMARY:

• He has over 35 years of experience in Information Technology.
• His experience includes expert level knowledge with Talend Open Studio, Business Objects, advanced skills with Oracle, DB2, Sybase, MySql database development and architecture design and systems integration.
• He has demonstrated superior proficiency in solutions architecture, data and systems analysis, software development, development project leading and project management, and has exceptional analytical problem solving skills developed over years of experience with various technologies.

TECHNICAL SKILLS:

Software: PL/SQL and SQLPLUS L, MS VC++, Borland C++ Talend Open Studio for ETL, MDM, ESB, Hortonworks Big Data, Talend and Bonitasoft BPM, BODS XI, Informatica, Oracle JAVA, Android SDK, Google Maps Android API v2, ANT, PERL, MS VB, VB .NET, GNU C++, Assembler, Power Builder Seagate Crystal Reports Crystal Reports Server. Cognos Impromptu version 6.0, and 7 Cognos PowerPlay Transformation Server Oracle Business Intelligence suite.

Operating Systems: LINUX Red Hat 6.0 Ubuntu, Mint IBM AIX (UNIX) Sun SunOS, Solaris, BSD

Databases: Oracle, Sybase, IBM DB2, MySQL, MongoDB, BaseX, Netezza, MS SQL Server

PROFESSIONAL EXPERIENCE:

Confidential

PRINCIPLE CONSULTANT

Responsibilities:

• Architected and lead the conversion redevelopment of the existing BODS ETL jobs to Talend ETL jobs and included data preparation for MDM consumption
• Mentored the development resources on the proper use of the Talend Studio and best practices and job design patterns
• Planed and executing the development, test, and deployment.

Confidential

PRINCIPLE CONSULTANT

• Installed Talend Server components, Apache Tomcat, Talend Administration Center, Talend Commandline, Apache Karaf, Talend Job Server, Talend AMC, Apache SVN and Oracle MySql on a development Windows Server for the intial prof of concept.
• Mentored the development team on programming with JAVA and the use of Talend Functions and components, logging, error handling, and deployment methods.
• Installed and configured Redhat servers in the development, test, and production environments, and installed all Talend Server components.
• Trained DevOps Admin resources in the use of the Talend Administration Center and Server deployment architecture.
• Managed and tracked the ETL development efforts and reported progress to management.
• Organized and directed the generation of unit design documentation for ETL jobs.
• Wrote the Server Installation Guide, Architecture Documents, Standard Operating Procedure Document for DevOps Admin resources, Best Practices document, and all run books.
• Authored custom components for use with Talend Studio using Java.
• Worked with DevOps resources to move the legacy production architecture to a SOA for all system conversion projects.
• Authored the MDM POC for future roadmap development efforts.

Confidential

SENIOR CONSULTANT III

• Partner Relations Manager between Talend, Hortonworks, and Illuminations works, responsible for Talend ETL/BPM/ESB/Big Data development throughout the organization. Additionally trained and supported consults deployed to client sites for ETL/ESB and Big Data.
• Development staff for the SAV A011 Secure Asset View project. Maintained the data model using Erwin for the Teradata based IDW portion of the project and coded all automation LINUX Red Hat 6.0 shell scripts to be used with Informatica.
• Technical lead for the SBIR AF141 Failure Mode and Effective Analysis (FMEA) Error Handling Engine (EHE) proof of concept with partner company Purduco. Conducted design and coding of BPM work flow processes, backend database data modeling and design and coding of tables, triggers and stored procedures, Design and coding of Talend ESB services and ETL processes, designed and directed the coding of the User Experience Web Front end. Technologies used with Talend DI/ESB, BonitaSoft BPM, MySql, NodeJS.
• Technical lead for the UIMS in - house demo/Training and Proof of concept system using LINUX Red Hat 6.0. Deployed solutions were Talend MDM and in house built source system simulation processes using Talend ETL/DQ/ESB/MDM/BPM, and Java.
• Architected Multiple Talend MDM development projects for the Air Force for supply chain management.
• Coordinated all Talend and BonitaSoft in-house training, Managed all Partnership activities between ILW LLC and Talend, ILW LLC and BonitaSoft.
• As a member of the Illumination Works Data Services team, Mr. Mayer has lead the development team at Luxottica in Mason Ohio to re-engineer the client CDW/ODS/CRM systems ( Oracle, Netezza, Mysql), and conducted data and systems analysis, design, and development of new Talend ETL jobs required for replacing existing defective C# code, LINUX Red Hat 6.0 shell scripts for automation, and database stored procedures.

Confidential, California

PRINCIPLE CONSULTANT

• CRM development using MySQL on Linux Ubuntu Mint
• Website development using PHP for management of clients and payment tracking
• Audit report development for accounting

Confidential, San Francisco, California

ETL and SQL Developer

• Website development using PHP and bash scripting on Linux Redhat for automated batch processing
• Transactional Database Development using MySQL
• Security issues mitigation and custom reporting
• Remote administration of the product catalog database

Confidential, California

Systems Engineer

• Data warehousing ETL, data migration and profiling/cleansing of hierarchical and historical changed and legacy data on Oracle, SQLServer, and MySQL.
• Master Data Management in conjunction with Business Process Management and ESB.
• Enterprise Service Bus to connect multiple disparate systems using Apache ActiveMQ, Karaf, Java 6.2 and 7.

Confidential, California

ETL developer

• Conducted defect analysis and coded corrections on existing BODS code.
• Developed new fill gap code for processes that were not considered in the original design.
• Assisted in the data analysis of legacy financial data to be loaded into the SAP Banking Module.

Confidential, Chicago, Illinois

Data Migration Consultant

• Conducted source data analysis on customer and Sales data from 12 remote legacy data warehouse systems for the purpose of migrating to SAP.
• Designed and coded BODS ETL and Unix shell scripts to support the legacy data migration effort to be run on an automated monthly basis until the legacy systems can be retired.
• Reported the condition and general data health of the legacy data to the client for potential corrective actions, before the data could be loaded into the SAP data structure with the LSMW.

Confidential, San Francisco, California

Designer and Technical Analyst

• Created and updated the RTM, WBS, and RICEF list and scheduled delivery for all functional requirements and functional and technical design artifacts.
• Responsible for managing a team of BA/TA/QA resources to identify application, system, and testing technical requirements
• Worked with the business subject matter experts to translate the business processes and needs into technical requirements and designs.Responsible for the functional and technical design of the AUDI-REC calculation engine and user interfaces
• Designed the AUDI Calculations Engine
• Designed the heat rate to power generation conversion calculations as they apply to ambient weather conditions and natural gas usage for power plants.

Confidential, San Francisco, California

Process Lead/Testing Coordinator/Data Analyst/Code Deployment Coordinator

• Defined, planned, coordinated, and guided technical and business testing with QA and business resources, development resources, data architect, release management leads and project managers for the date driven SDLC Agile modular deployment of the ESP EBI EDW.
• Built ETL product POC for dataload to staging using Talend Studio.
• Authored and coordinated peer reviews of all testing documentation and plans and mentored the creation of test cases. All technical and business test cases were maintained in MQC/HPQC.
• Designed Crystal Reports for Bi data and business rules alignment, prior to productionalizing the BI EDW.

Confidential, San Francisco, California

Lead ETL Developer

• Responsible for the design and coordinating the coding of the Enterprise Data Warehouse ETL processes using Business Objects Data Integrator (BODI) XI, pl/sql, and UNIX shell scripts for EDW patches, upgrades, and balancing strategies.
• Developed coding and deployment standards for development of the EDW using BODI XI.
• Authored all technical ETL design documents for all dimensions of phase 2 of the EDW.