Greg Guenther Email & Phone Number

Usa

Data Integration Consulting

San Jose, Ca

Analyst and lead developer for eBay-PayPal data sharing. Implemented secure, high volume data sharing as the company split into two separate companies. Analyst and lead developer for Global Operations customer sentiment text mining project for scanning social media, customer service, and paid survey sources. Developed data platform for government CFPB compliant customer sentiment reporting. Tools used include Teradata DBMS, Python, Hadoop HDFS, Spark.

San Francisco Bay Area

Technical Lead on project migrating data mart from Oracle DBMS to Teradata platform. Developed ETL flows for Teradata DB target using Wells Fargo ETL framework based on Ab Initio tools. ETL analyst for data warehouse assessment project and for Ab Initio 3.1 version upgrade project. Provided security briefings and system performance assessments resulting in significant improvement.

Los Gatos, Ca

Analyst and developer on IT project moving systems from in-house data center to cloud-based Amazon EC2 hosting. Refactored processes for new cloud architecture and tools. Tools included Python, Pig, Hadoop, Ab Initio, Teradata, and Amazon Redshift

Merrimack, Hn

Technical Lead and Business Analyst on next-generation personnel data warehouse pilot project. Documented business rules from existing systems. Migrated existing Informatica ETL code to new data model. Designed ETL software development framework for project.

Wilmington, De

Technical Lead on ETL project for the replatform of Card Services Data Warehouse from Oracle to Teradata. Developed and documented methods and procedures for ETL developers to follow in the ETL replatform process. Designed and developed Ab Initio ETL utility infrastructure for use by the ETL project team. Developed Teradata Stored Procedures and functions as part of ETL framework. Daily team communication and problem solving on a wide range of technical issues and design decisions.

San Jose, Ca

Developed extract transform and load (ETL) systems for Customer Service Data Warehouse, Merchandising, and Ad Networks. ETL application development using Ab Initio on Unix. Application data sources included Oracle, MSSQL, Teradata, LDAP, and SAP flat files. Toolset included Ab Initio, Unix Korn shell, and Perl. Team tech lead for ETL project moving Customer Service Data Warehouse from Oracle to Teradata. Designer for ETL on machine learning based merchandising system to increase purchase per visit. Designer and developer for ETL systems for eBay Ad Network online advertising portal.

Hartford, Connecticut Area

Developed data warehouse ETL systems to feed a newly developed data warehouse designed to integrate data from personal lines systems including Auto, Boats, an Homes systems. Ab Intio ETL with Teradata database target.

Cincinnati, Oh

Developed systems for data warehouse extract transform and load (ETL) having a material impact on company profitability. Lead designer/developer for ETL processing systems including daily sales, scan-based trading, direct store delivery, competitive price check, and DSD invoice reclamation. Created automated graphical tracking for ETL runtimes, file delivery statistics, and database space utilization. Specified database schema and physical layouts. Executed database query analysis and performance tuning. Designed generalized data migration utilities. Shared team support responsibilities for production ETL systems. One of the top ten largest commercial data warehouses at the time.