Stephen Lai

Strategic and analytical professional with over 5 years of experience in e-commerce and technology industries. Proven track record of collaborating with cross-functional teams to execute projects and transform data into actionable insights

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.

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

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

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