Sales Data Analyst

Gary Chen

** ******* **. ***. *-i New York, NY **038

646-***-**** ***********@*****.***

EXPERIENCE

Canon U.S.A., Inc. Melville, NY

Data Analyst - ITCG Sales Support & Analytics Division April 2018 – May 2020

● Optimize, update, and maintain data across multiple databases to ensure the sales team has the most up to date sales and inventory information at all times

● Maintain clear communication between different internal teams and external vendors to properly align company and vendor sales goals and product allocation plans

● Maintain a rolling 6-month sales forecast for wholesale vendor channels to give proper estimations of future sales broken down by SKU level

● Analyze the latest market and seasonality trends to provide call outs for upside orders for personally assigned accounts

On Hand Inventory Workbook Conversion:

- Reworked an Excel Workbook into a Tableau format to give internal sales team and upper VP management a fresher and cleaner interface to monitor the most current inventory, cost of goods, and weeks of supply on all National accounts for top selling product categories

- Prepped a SQL database joined with an Excel file to factor out brick and mortar display models from countable inventory

- Able to publish and input a story analysis of National Account Inventory and sales progress to capitalize on growth opportunities to increase revenues

Consumables Profitability Analysis:

- Created Excel and Tableau workbooks to calculate precise ink profit margins on a given year for office specialty supply channels to give account executives insight on the most profitable ink product lines and SKU’s

- Provided supply channels with the exact front end and back end profit margins on previous quarters’ to investing more resources in the CLI consumables category

- The workbooks captured consumables remained profitable ($25MM + per year) in a slightly declining market for office specialty stores and captures an average of 450,000 units of ink sold each week through all sales channel Stony Brook University Stony Brook, NY

Undergraduate Teaching Assistant, Mathematical Statistics August 2017 – December 2017

● Assisted in helping over 100 students understand the theories of Mathematical Statistics

● Managed and provided feedback to over 100 students on assignments, exams, and projects

● Maintained clear communication between the professor and students to ensure students met deadlines and stay up to date with course material through blackboard Northwestern Mutual New York, NY

Financial Adviser Assistant May 2016 – August 2016

● Scheduled consultations and maintained multiple professional calendars for financial representatives

● Compiled and maintained a prospect database of over 2,000 leads built through referrals

● Worked closely with the financial advisers to develop appropriate financial plans for clients EDUCATION

Stony Brook University – College of Engineering and Applied Sciences Stony Brook, NY Bachelor of Science in Applied Mathematics and Statistics Bachelor of Arts in Economics December 2017

GPA: 3.2/4.0

Deakin University Victoria, Australia

Study Abroad Program Spring 2014

Clubs and Organizations

Stony Brook Economics Club, Member August 2017 – December 2017 Omicron Delta Epsilon International Honor Society, Member Skills: Advanced in Excel, Intermediate in SQL, Intermediate in Tableau, and Basic in Python

Contact this candidate