Post Job Free

Resume

Sign in

Sales Analyst

Location:
Irvine, CA
Posted:
December 14, 2020

Contact this candidate

Resume:

Dustin Price

adinl3@r.postjobfree.com *** Siena, Lake Forest, CA 92630 714-***-****

PROFESSIONAL EXPERIENCE

SG Inc., Anaheim, CA 2014 - Current

SG Inc. is a top selling amazon merchant that specializes in footwear and apparel Supply Chain Analyst

• Utilize pivot-tables, slicers, and v-lookup formulas in Excel to generate interactive dashboards tracking key performance metrics and highlighting sales related data-points

• Developed custom excel dashboards to track customer success KPI’s and maintain a high seller rating

• Leveraged excel to create an economic order quantity model to help optimize the frequency of our orders and to better understand our true holding costs which help determine our purchasing decisions

• Made use of excel to build a model to better understand our target inventory reordering points with uncertain demand to minimize ordering, shortage, and holding costs while maintaining high service levels

• Validate invoices to identify any discrepancies

• Team with warehouse associates to reduce error rates and keep customer satisfaction high

• Perform monthly physical inventory audits to reduce and reconcile discrepancies

• Serve as primary point of contact to resolve customer feedback issues by phone and email Ernst & Young (EY), San Francisco, CA 2011 - 2014

Ernst & Young is a global accounting and consulting firm Business Development Analyst

• Managed MTD, QTD, and YTD sales pipeline reporting for the offices state & local tax professionals

• Built and maintained Excel dashboards that allowed firm partners to view their current pipelines by industry, location, size, revenue, and duration to ensure each firm partner reached their goals

• Partnered with senior management to choose key metrics, create & select visualizations, and ensure quality assurance of end client deliverables

• Conducted due diligence using internal research databases to find potential clients

• Took initiative and oversaw engagement planning and economics, including confidential client communications, and ensuring budgets were not exceeded

Palumbo Bergstrom LLP, Irvine, CA 2008 - 2011

Palumbo Bergstrom is a real estate and construction defect law firm Clerk

• Helped prepare transactional documents, briefs, pleadings, and ensured their timely filing

• Maintained scheduling, firm correspondence, billable time, and the firm filing room EDUCATION

University of California, Irvine (UCI) 2005 - 2009 B.A. Political Science

Colorado State University (CSU-Online) Current - 2021 M.S. Finance

SKILLS & CERTIFICATES

Excel with Wayne: Certificate in Supply Chain Management DataCamp: Intermediate Spreadsheets (Excel/Google Sheets) DataCamp: Data Analysis in Spreadsheets (Excel/Google Sheets) DataCamp: Analyzing Big Data in SQL (In Progress/30 Hours) Excel with Wayne: Complete Microsoft Excel Training Course (In Progress/60 Hours)



Contact this candidate