Data Analyst

Alvin Loi

408-***-**** ● San Jose, CA ● *****.**.***@*****.***

SKILLS

SQL Tableau Excel Python

EXPERIENCE

Sales Account Manager Trainee July 2019 – Nov 2020 Sensient Technologies Turlock, CA

● Cleaned, organized, analyzed, and disseminated multiple years of sales data using SQL and Tableau with attention to detail and accuracy.

● Utilized data to uncover YOY sales trends and proposed pricing updates across product lines and customer group to improve profit margins and total revenue.

● Uncovered pricing sensitivity across multiple customers groups.

● Researched market trends in CPG, utilizing syndicated data, internal data, etc.

● Reported monthly sales forecast, results, and areas of improvement to GM.

● Rotated through the major departments of the company, including Customer Service, Quality, Sales, Marketing, Technical Services, and Production.

● Built business case around new technology implementation, and presented to executive team.

● Created marketing collateral for sales team.

● Involved in multiple fields of data entry.

Sales and Marketing Intern June 2018 - Sept 2018

Pacific Farms Oakland, CA

● Cleaned and automated sales data using Excel onto pivot tables and dashboards to update CEO on real-time sales performance.

● Developed and automated sample warehouse inventory management system for in-house R&D samples using Excel.

● Developed sample data entry platform on Excel improving efficiency and accuracy by 500%( approx. time it takes to walk to warehouse, and sift through inventory).

● Performed market research on suppliers, competitors, and customers to prepare for IFT tradeshow. Cal Poly Food Science Club July 2018 – July 2019

Public Relations Officer San Luis Obispo, CA

• Increased member participation at Winter Fancy Food Show by 740%.

• Increased industry/plant tour events by 300%.

• Organized plant tours and tradeshow events.

Evergood Sausage Company June 2017- Sept 2017

Quality Intern San Francisco, CA

• Supervised workers to ensure productivity and adherence to GMPs.

• Reported to Quality Manager regarding daily activities.

• Involved in QC activities ensuring regulatory and quality compliance. EDUCATION

California Polytechnic State University: San Luis Obispo Bachelor of Science in Food Science June 2015 – June 2019

• Triathlon Club

• Food Science Club

• Biochemistry Club

LANGUAGES

English Mandarin Cantonese Spanish

Contact this candidate