Stephen Lai

E-Commerce Operations Analyst - Siren Imports (Part-time, Remote)                                                                                 11/2021-Current

• Produced 5+ Tableau dashboards with in-depth analysis on KPIs such as profit, number of orders, sales by region, page visits, user demographics, user reviews, lost shipping and returns. Used SQL to provide real-time insights to adjust promotions, policies, pricing, presented weekly report to executive.
• Analyze competitors' pricing and product information, leading to online store recommendations that increased conversion rates, reduced cart abandonment, boosted revenue by 10%.
• Designed and implemented multivariate 6 step email campaign with A/B testing to 600+ YouTube and Instagram influencers.

Data Analyst Intern - G-Formance (Full-time, Taiwan)                                                                                                          05/2022-07/2022

• Collaborated on a team of 3 data analysts to build ETL Pipeline, using SQL to join product data from various sources, cleaned and transformed data using Power Query, migrated 17,000+ SKUs to ERP which automatically filled product data with Amazon and Walmart APIs. 
• Delivered Amazon ad reports to improve KPIs like AcoS for 20+ product categories (headlights, taillights, fender flares, tow mirrors, fog lights, etc.) contributing to decisions on which products to adjust spend on. 
• Updated a multi-million-dollar Amazon page, refining the storefront layout, optimizing listings, and enhancing promotional strategies.

Business Analyst - HiTech Handymen (Chapel Hill, NC)                                                                                                 03/2020 - 11/2021

• Created a sales dashboard using Tableau, getting real-time data using SQL. Analyzed and interpreted number of clients, service revenue, turnaround time, inventory expenses, and generated reports on where to improve. 
• Implemented automated alerts tied to repair milestones, ensuring timely notifications for ordering parts, laptop repair pickups and IT consulting on-site appointments, improved service delivery time by over 31%. 

Certifications: Microsoft Excel: Advanced Excel Formulas & Functions, Google Data Analytics, Microsoft Power BI Desktop for Business Intelligence, Tableau, SQL, MTA (Microsoft Technology Associate) 2021, Data camp Data Analyst Professional Certification

Technical Skills: Python (Pandas, NumPy, Matplotlib, Seaborn, SciPy, Scikit-learn), SQL, Tableau, Power BI, Microsoft Excel, Data Cleaning, Power Query, Pivot Tables, Google Analytics, PostgreSQL, MongoDB, Postman, Node.js, GCP, C#, HTML/CSS, JavaScript, React.js, Visual Studio Code, GitHub, CRMs (HubSpot, Pipedrive, Salesforce)

National Taiwan University (Study Abroad) - Taipei, Taiwan   

Global Master of Business Administration, Class of 2024 GPA: 3.73 Worked while completing full-time degree. 

Relevant Courses: Statistics and Data Analysis, Financial Management, Financial Reporting, Management Accounting

Thesis: TalentForge Custom XR App Development for Employee Training and Immersive Learning

North Carolina State University - Raleigh, North Carolina
    Bachelor of Science in Business Administration, Class of 2016