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)
