Summary
Overview
Work History
Education
Skills
Timeline
Generic

ALAN WANG

Atlanta

Summary

Results-driven Senior Data Analytics Consultant with extensive experience at The Home Depot, leveraging expertise in Google BigQuery and Tableau to enhance reporting efficiency. Successfully automated complex reporting processes, saving over 1,000 hours in labor. Proven ability to lead cross-departmental collaborations, ensuring data integrity and delivering actionable insights.

Overview

10
10
years of professional experience

Work History

SENIOR DATA ANALYTICS CONSULTANT

Inspire11
Atlanta
10.2023 - Current
  • Company Overview: Clients: A $24 billion American food services distributor and a retail supplier of heavy equipment components
  • Refactored reports from Google BigQuery to Snowflake using optimized SQL methods to make performance faster and more readable to the Merchandising Department at a Fortune 100 company.
  • Recreated 10+ SAP reports from SAP into Tableau for the Logistics department at a Fortune 100 company.
  • Led efforts for testing data models against SAP and production level data to ensure an easy transition into an enterprise wide data model to be used by the business.
  • Led retirement efforts on an antiquated Syntellic Reporting System into a fully automated Snowflake/ Sigma Reporting for the Logistics Department at a Fortune 100 company.
  • Clients: A $24 billion American food services distributor and a retail supplier of heavy equipment components

BUSINESS INTELLIGENCE MANAGER

The Home Depot
Vinings
08.2022 - 10.2023
  • Led team of 6 analysts on reporting for Distribution Business Intelligence.
  • Managed over 30+ reports in Tableau based reporting systems.
  • Owner of the Cloud Capacity Storage savings/slots usage for all of supply chain.
  • Led remediation efforts for over 100+ scripts in GBQ from SQL Server.
  • Cross collaborated with multiple departments to ensure data quality and precise metrics are captured through Tableau based reporting.

SENIOR DATA ANALYST

The Home Depot
Vinings
07.2020 - 08.2022
  • Led development on the RDC (Rapid Distribution Center) Reporting Suite for the Business Intelligence team, creating 80% of the dashboards in the suite utilizing Google Bigquery and Tableau.
  • Transitioned 10+ complex excel based reports into an automated Tableau based reporting utilizing MS SQL Server and Tableau.
  • Led weekly calls for RPMs to validate reporting for the RDC Reporting Suite, which both acted as a customer service hub for users and enhancements planning.
  • Generated Tableau reports to help solve RDC Distribution issues, translating complex information into easily digestible presentations to senior leadership.
  • Cross collaborated with multiple departments to ensure data quality and precise metrics are captured through Tableau based reporting.

DATA ANALYST

The Home Depot
Vinings
07.2019 - 07.2020
  • Executed the transition of manual Excel based reporting into automated Tableau based reporting.
  • Led development of the Crown Bolt Reporting Suite, which included: DC Daily Report, On Time Dashboard, Shipped Orders Status, Crown Bolt Weekly Capture, Gap Time, Regional Backlog, Gold Cup, and Daily Labor Planning.
  • Transitioned the Auto RTS Compliance dashboard into a clean, presentable dashboard ready to be viewed by senior leadership.

MARKET INTELLIGENCE ANALYST

QTS
Suwanee
12.2015 - 01.2018
  • Led development on multiple dashboards designed to analyze both customers and the data center market, saving analysts 1,000+ hours in manual work, which resulted in $30,000 in labor saved.
  • Structured and created a report involving 1,000+ different customers and organized the internal customer data to find points of improvement for each customer, which produced key information to maintaining the company's customer base.

RESEARCH ANALYST

Yardi Matrix
Denver
01.2015 - 12.2015
  • Researched variables relating to the multifamily market. Integrated an automation process to generate the reports every month using Excel, Adobe InDesign and Tableau for process improvements across the template blueprints.

Education

The University of Georgia
Athens, GA
01.2019

Georgia State University
Atlanta, GA
01.2014

Skills

  • Google Bigquery
  • Snowflake
  • Sigma
  • Tableau
  • Excel
  • Python
  • Alation

Timeline

SENIOR DATA ANALYTICS CONSULTANT

Inspire11
10.2023 - Current

BUSINESS INTELLIGENCE MANAGER

The Home Depot
08.2022 - 10.2023

SENIOR DATA ANALYST

The Home Depot
07.2020 - 08.2022

DATA ANALYST

The Home Depot
07.2019 - 07.2020

MARKET INTELLIGENCE ANALYST

QTS
12.2015 - 01.2018

RESEARCH ANALYST

Yardi Matrix
01.2015 - 12.2015

The University of Georgia

Georgia State University

Similar Profiles

CREATE PROFILE
ALAN WANG