
Stephen Lai
Technology / Internet
Services offered
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
Experience
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)
Education
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
Professionals in the same Technology / Internet sector as Stephen Lai
Professionals from different sectors near Manhattan, New York
Other users who are called Stephen
Jobs near Manhattan, New York
-
Data Analyst
4 weeks ago
TechChain Talent New York County, NYData Analyst role to analyze and optimize client suite of products focusing on user behaviour and product performance. · Analyse user and product data across all platforms. · Provide actionable insights to improve user experience and product performance. · ...
-
Data Analyst
1 month ago
Tandym Group Stamford, CTA leading media and entertainment company is seeking a Data Analyst to join a driven and highly motivated team within Media Operations. · Work across the Fulfillment organization, understand voice of customer, operational requirements, and pain points · Use business acumen to tho ...
-
Financial Data Analyst
2 days ago
Veolia | North America TeaneckThe Financial Data Analyst partners with the Director of Finance, Senior Leaders, and Finance Team to assist with automating processes and reporting, · Deliver FP&A support to Director of Finance, Manager, and Finance Team: Collaborate with monthly reporting, variance analysis, b ...