Aiden Guo
Chino Hills,CA
Summary
Strategic Senior Data Analyst with 9+ years of experience driving business impact through statistical analysis, data modeling, and BI solutions. Expert in full data lifecycle management, including database handling, ETL, and data transformation. Proficient in Tableau, Power BI, Google Analytics, SAS, and Excel for developing dashboards and performance insights. Strong analytical background in regression, forecasting, and predictive modeling across supply chain, e-commerce, and manufacturing domains. Proven leader in Agile environments, with strengths in stakeholder communication and cross-functional team mentoring.
Overview
9
9
years of professional experience
Work History
Senior Data Analyst
Vivet.Inc
Tustin, CA
08.2022 - Current
- Spearheaded a successful company-wide data warehouse migration to support the integration of four major furniture brands, significantly improving data accessibility, reporting accuracy, and enabling a 900% increase in combined sales volume post-merger.
- Acted as a key technical lead in the ERP system migration from legacy platforms to SAP S/4HANA. Oversaw business process configuration, data validation and migration, and facilitated system integration and user acceptance testing (SAT/UAT).
- Managed a multimillion-dollar initiative, “ARTISTE241,” a custom furniture configuration platform. Delivered solutions in web design, 3D rendering integration, part-level demand forecasting, and end-user application development—contributing to a 15% boost in annual sales.
- Wrote complex SQL queries to extract, transform, and validate data for reporting and project tracking, reducing report turnaround time by 3 days and supporting over 15 cross-functional projects monthly.
- Developed and delivered comprehensive training for over 100 employees across 12 departments on dashboard and project tracking tools, significantly enhancing cross-functional collaboration, and improving project tracking efficiency.
Data Analyst
A.R.T. Furniture, Inc.
Ont, CA
02.2016 - 07.2022
- Designed and executed complex SQL queries to extract, transform, and validate data for reporting and analytics, reducing report turnaround time by 3 days and supporting over 15 cross-functional projects per month.
- Built and maintained robust dashboards using Power BI and Tableau to track sales performance, inventory turnover, vendor KPIs, and shipping lead times, driving more informed decision-making.
- Automated monthly performance reporting processes save over 40 labor hours monthly and enhance reporting accuracy and timeliness.
- Developed scalable data pipelines and ETL workflows using SSIS to integrate ERP and retail system data into the enterprise data warehouse, eliminating over 300 manual data entry errors annually, and saving 120+ hours of manual work.
- Leveraged predictive analytics and demand forecasting to reduce inventory holding costs by 18% and improve supply chain efficiency.
- Conducted deep-dive exploratory data analysis to uncover insights on customer behavior and product trends, leading to a $500K improvement in revenue forecasting, and a $150K reduction in churn-related costs.
Education
Bachelor of Science - Data Analysis
University of California, Los Angeles
Los Angeles, CA12-2014
Skills
Tools & Platforms:
Microsoft Excel, Microsoft Access, SQL, My SQL, R, SAS, Power BI, Tableau, Alteryx, Google Analytics
Leadership & Collaboration:
Stakeholder liaison, cross-functional team leadership, talent development, executive reporting & narrative-building
Industry Knowledge:
Logistics & supply networks, digital commerce, industrial manufacturing, operational strategy
Accomplishments
Dean’s List – Awarded for achieving top academic standing across multiple semesters
First Place – Data Visualization Challenge – Won university-hosted competition for best use of Tableau/Power BI in storytelling
Timeline
Senior Data Analyst
Vivet.Inc
08.2022 - Current
Data Analyst
A.R.T. Furniture, Inc.
02.2016 - 07.2022
Bachelor of Science - Data Analysis
University of California, Los Angeles
Similar Profiles
Kylie HootonKylie Hooton
Host/Busser, Service Partner, Trainer, Server, Safety Liaison, Bartender, Marketing Coordinator at Islands Fine Burgers and DrinksHost/Busser, Service Partner, Trainer, Server, Safety Liaison, Bartender, Marketing Coordinator at Islands Fine Burgers and Drinks
Kelan MoffattKelan Moffatt
Desktop Support Engineer at Cox AutomotiveDesktop Support Engineer at Cox Automotive
Katherine PhanKatherine Phan
Patient Care Technician at Cottage HospitalPatient Care Technician at Cottage Hospital
Simon AgustinSimon Agustin
Food Vendor at Cane Coffee CompanyFood Vendor at Cane Coffee Company
Jonathon NanceJonathon Nance
Senior Data Analyst /Lead Data Analyst at Two Kings CasinoSenior Data Analyst /Lead Data Analyst at Two Kings Casino