Andrew Hong, Data Warehouse Developer in Austin, TX, United States
Andrew Hong

Data Warehouse Developer in Austin, TX, United States

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.
Andrew is now available for hire

Portfolio

  • Peak Consulting Group
    Python, Azure, PostgreSQL, Azure Data Lake, Databricks, AWS, Data Science
  • LeanDNA
    AWS, Amazon SageMaker, MariaDB, MySQL, Python, Pentaho, SQLite
  • Infosys
    SAP, SAP HANA, Big Data Architecture, Data Warehousing, ETL

Experience

Location

Austin, TX, United States

Availability

Part-time

Preferred Environment

SAP HANA, Pentaho, Oracle, SQL Server BI, ETL, Data Warehousing, AWS, Python, Snowflake, Azure

The most amazing...

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

Employment

  • 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, AWS, Data Science
  • 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: AWS, Amazon SageMaker, MariaDB, MySQL, Python, Pentaho, SQLite
  • 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, Big Data Architecture, 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

Experience

  • 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.

Skills

  • Languages

    SQL, Python, Snowflake
  • 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
  • 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, AWS, Data Quality, Reverse Engineering, SAP FICO, MDM, ServiceNow, Data Building Tool (DBT), Azure Data Lake
  • Frameworks

    Hadoop, Apache Spark, Spark
  • Tools

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

Education

  • Master's Degree in Electrical and Computer Engineering
    1994 - 1996
    University of Illinois at Urbana-Champaign - Urbana, IL

Certifications

  • IBM Ascendant Project Management Methodology
    AUGUST 2008 - PRESENT
    IBM
  • Certified SAP Project Manager
    JUNE 1999 - PRESENT
    SAP

To view more profiles

Join Toptal
Share it with others