Andrew Hong, Developer in Austin, TX, United States
Andrew is available for hire
Hire Andrew

Andrew Hong

Verified Expert  in Engineering

Data Warehouse Developer

Location
Austin, TX, United States
Toptal Member Since
October 27, 2021

Andrew is a seasoned data architect and data engineering leader and developer with 20 years of experience providing consultative and technical leadership focused on requirement gathering, solution architecture design, data warehouse, data integration, data modeling, and analysis, ETL, data strategy and roadmaps, data quality, data management, and big data platforms in AWS and Azure Cloud. He is a well-recognized expert in the enterprise data management field who presented in over 10 conferences.

Portfolio

Peak Consulting Group
Python, Azure, PostgreSQL, Azure Data Lake, Databricks...
LeanDNA
Amazon Web Services (AWS), Amazon SageMaker, MySQL, Python, Pentaho
Infosys
SAP, SAP HANA, Data Warehousing, ETL

Experience

Availability

Part-time

Preferred Environment

SAP HANA, Pentaho, SQL Server BI, ETL, Data Warehousing, Amazon Web Services (AWS), Python, Snowflake, Azure, Python 3

The most amazing...

...thing I've achieved is presenting over 10 sessions on data warehouse, business intelligence, and SAP HANA at SAP conferences.

Work Experience

Principal Data Scientist

2021 - PRESENT
Peak Consulting Group
  • Led the design and development of data science and data analytics solutions on Microsoft Azure and AWS cloud.
  • Designed and developed ELT data pipelines for high-performance data feed into Data Lake and SQL databases.
  • Designed and developed back-end REST API functions using Python on Azure and AWS cloud.
Technologies: Python, Azure, PostgreSQL, Azure Data Lake, Databricks, Amazon Web Services (AWS), Data Science, T-SQL (Transact-SQL)

VP of Data Analytics

2015 - 2021
LeanDNA
  • Managed the data team in designing and building AWS-based data analytics solutions to drive customer value. Led the data strategy and vision, innovation, data analytics solution design, and SAP/ERP integration. Drove solutions for key customers.
  • Spearheaded the development of the LeanDNA Connect data integration product that is reusable and capable of integrating with common ERP, including SAP and SAP HANA.
  • Led the data science and analytics in the areas such as inventory prediction model using ML in AWS SageMaker, algorithms in optimizing order policy for every part, action-based intelligence, and demand forecasting using Prophet with seasonality.
  • Oversaw solution deployment for key customers in pilot programs and drove the business results in inventory reduction/shortage management that led to an expansion from pilot to the enterprise.
Technologies: Amazon Web Services (AWS), Amazon SageMaker, MySQL, Python, Pentaho

Senior Principal

2013 - 2015
Infosys
  • Oversaw selling, delivering, and growing services capabilities in BI, including SAP HANA in-memory analytics and big data solutions. Led the SAP HANA and big data COE and also led large-scale BI/SAP HANA and big data engagements with key clients.
  • Managed the SAP S/4 HANA and BW HANA migration for a large chemical manufacturer.
  • Led the SAP data management engagement for a leading pharmaceutical company.
  • Spearheaded the sales and delivery of SAP HANA and enterprise data warehouse roadmap for a large oil and natural gas company.
  • Led the sales and delivery SAP HANA implementation for real-time inventory analytics for a $20 billion global oilfield services company.
  • Led the big data solution architecture design for a media entertainment client to enable customer churn analysis and targeted ads. The solution involves customer data lake, EDW, data marts, data visualization and analysis, and machine learning.
Technologies: SAP, SAP HANA, Data Warehousing, ETL

Associate Partner

2006 - 2013
IBM
  • Responsibilities include selling and developing new business, expanding existing services, managing client relationships at executive/senior management levels, growing SAP Business Analytics service offerings, and leading client engagements.
  • Managed the largest Information management implementation workstream of over $15 million a year for IBM’s multi-year global SAP program.
  • Led the SAP BI and MDM strategy project for a global consumer appliances company.
  • Managed SAP BI program for Lenovo’s Global SAP implementation and deployment.
  • Served as BI strategy lead for a global Fortune 100 automotive and heavy equipment manufacturer.
  • Acted as SAP BI strategy lead for a global SAP consolidation and reporting (SEM-BCS) project. The client was a global consumer product company based in the UK.
  • Served as SAP BI strategy advisor for a BI strategy project at a global steel manufacturer based in Brazil.
Technologies: SAP, Data Warehousing, ETL, IBM InfoSphere (DataStage), Data Quality, SAP HANA, SAP BW on HANA

Principal Software Engineer

The client is a pre-IPO software company that provides investment management cloud-based software for the financial industry. I led the design and development of a client reporting solution, a critical component of the investment management solution.

Data Architect

I worked as a data architect on a project to design and build a new generation of experience ratings using Microsoft Azure, Databricks, Python, and C# (front-end).

I led the design and development of a data model, data pipelines, API (Python), and C# front-end.

LeanDNA Supply Chain Analytics for Manufacturing Companies

http://www.leandna.com
Led the data analytics team in designing and building cloud-based data analytics solutions to drive customer value in inventory reduction. Drove data analytics strategy and vision, innovation, data analytics solution design, and SAP/ERP integration. Drove solutions for key customers. Grew the company from seed stage to Series B with ARR over $6,000,000 and achieved product-market fit.

Led the development of the LeanDNA Connect data integration product that is reusable and capable of integrating with common ERP, including SAP and SAP HANA. The toolset used includes Pentaho Data Integration, RDB in AWS Cloud Platform, AWS SageMaker, Python, MySQL, Snowflake, SQLite, and Looker (Embedded Analytics).

Led the product lifecycle, data science, and data analytics in the following areas:

• LeanDNA inventory prediction model using ML and data analytics using AWS services.
• LeanDNA algorithms in optimizing order policy for every part.
• Action-based intelligence.
• Executive dashboard in visualizing the inventory reduction opportunities and actions.
• Demand forecasting model using time series with seasonality.
• Led solution deployment for key customers in pilot programs and drove the business results in inventory reduction.

Big Data Solution for Media Entertainment Client

Led the big data solution architecture design for a media entertainment client to enable customer churn analysis and targeted ads. The solution involves customer data lake, EDW, data marts, data visualization and analysis, and machine learning.

Master Data Management for a Pharma Client

Led the MDM solution architecture design for a pharmaceutical client to enable central master data management and integrate master data across SAP, Salesforce, data warehouse, and other systems. The solution involves MDM, data quality, ETL, and data integration.

Looker Embedded Analytics for LeanDNA Cloud-based Supply Chain Analytics

Designed and developed supply chain dashboards and integrated them into the LeanDNA supply chain analytics SaaS application.

• Designed the overall cloud solution architecture using Looker as embedded analytics inside LeanDNA cloud-based application.
• Used Looker ML for creating data modeling, views, and Looker ML dashboards.
• Designed and built the data models using Looker ML with the back end of SQL database and Snowflake.
• Designed and built supply chain dashboards using Looker ML dashboard for key supply chain metrics such as supplier on-time delivery and quality, providing capabilities to drill down into lower-level dashboards and detail reports.
• Performed super user training to use Looker for ad-hoc analysis to address business questions.

Insurance Company Modern Data Platform

Acted as a data architect for a re-insurance company, led the design and development, data architecture design, data ingestion, and data pipeline in Azure, Databricks, structured, and unstructured data. Enabled data analysis and data science.

Data Architecture and Visualization for Fleet Management Software

The client is a SaaS software company that provides fleet management software. Led the design and implementation of Looker dashboard implementation and data architecture improvement. The dashboard provides a set of operational KPIs to improve efficiency and lower cost. Led the development of the data model, dashboards, widgets, visualization, and overall data architecture.

Data Science and Data Analytics Program for Insurance Client

Led the data analytics team in designing and developing data analytics/data science projects, including:
• Experience Rating tool for actuaries to evaluate historical losses, premium, development, and insight into insurance premiums.
• Intelligent email form recognition system in gaining the insight from emails and insurance claim forms to understand the policy information, claim type, nature of loss, and other key information.
Architected the solution platform using Microsoft Azure, including REST API, data lake, ELT, and front-end.

Data Engineer

I designed and developed the data model, ETL data pipelines, and dashboard using Looker for Client's Fleet Management Software Solution. The solution uses Google GCP Cloud, Looker Dashboard Solution, and RDBMS.

Languages

SQL, T-SQL (Transact-SQL), Python, Snowflake, Python 3

Libraries/APIs

Pandas

Paradigms

ETL, Business Intelligence (BI), Database Design, Data Science, Agile Project Management

Platforms

SAP HANA, Pentaho, Oracle, Amazon Web Services (AWS), Alteryx, Databricks, Google Cloud Platform (GCP), Azure, Kubernetes, Docker, AWS Lambda

Storage

MySQL, Databases, Microsoft SQL Server, Database Architecture, Data Pipelines, SAP S4 HANA Cloud Services, PostgreSQL

Other

SAP, Data Warehousing, SAP BW on HANA, Data Engineering, Data Architecture, Data Profiling, Data Cleansing, Data Queries, SAP BusinessObjects (BO), Machine Learning, Data Quality, Reverse Engineering, SAP FICO, MDM, ServiceNow, Data Build Tool (dbt), Azure Data Lake, Analytics, LookML, Logistics

Frameworks

Hadoop, Apache Spark, Spark

Tools

SQL Server BI, Amazon SageMaker, IBM InfoSphere (DataStage), Tableau, Microsoft Power BI, Looker

1994 - 1996

Master's Degree in Electrical and Computer Engineering

University of Illinois at Urbana-Champaign - Urbana, IL

AUGUST 2008 - PRESENT

IBM Ascendant Project Management Methodology

IBM

JUNE 1999 - PRESENT

Certified SAP Project Manager

SAP