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)