Sales Analyst

ROMAN SANDOVAL

***** ****** **** **** ***** City, CA 94587

510-***-**** Email: ************@*****.***

PROFESSIONAL SUMMARY

Detail oriented professional with over 14 years experience in Analytics. Knowledgeable in general accounting, budgeting, and journal entry. Strong interpersonal skills, an innovative problem solver, and adept at implementing innovative practices and procedures to improve efficiency.

RECENT EMPLOYMENT EXPERIENCE

GAP INC., San Francisco, CA

2020-Present

SR. Analyst – Operations HQ Finance

Manage budgets totaling over $35M annually for Gap Legal and Government Affairs and complete month-end closing procedures including preparing journal entries to reconcile operating budget

Manage Benefits Reserve by analyzing spending trends and determining how the various discrepancies to forecasted budget will affect the yearly Reserve balance

Facilitate meetings with business partners to review monthly expenses and adjust the operational budget to reflect any changes in planned spending

Conduct comparable analysis of prior year’s budgets and partner with cross functional team to create Zero Based Budget for fiscal year 2021

ROSS DRESS FOR LESS, Dublin, CA

2018-2019

SR. Allocation Analyst

Analyzed weekly sales data to identify emerging sales Trends and created allocation strategy to maximize inventory and profit margin.

Analyzed historical sales history and created Weekly Sales Curves for 200+ stores which allowed the correct amount of inventory flow into stores.

Allocated Inventory for all New Ross Stores ensuring all stores opening inventory meet their Inventory Target

Communicated to Senior Leadership Regional concerns and strategies that ensured all stores ended the month in-line to the Inventory Target.

CHARLOTTE RUSSE, San Francisco, CA

2015-2018

Allocation Planner

Led monthly business reviews with Management by recording and reviewing data, across all departments and classes, and presented key learnings, made action plans, and sales forecasts for Quarterly Business Reviews.

Worked collaboratively with the Real Estate department to open stores in new markets and close current stores in underperforming areas by analyzing sales and traffic data to support decision making.

Created ad hoc reporting that identified the best trends and styles that maximized sales and margin in the sweaters department across all 550 Charlotte Russe stores. This effort lead to a 140%-unit sales comp and the fastest inventory turns the department had seen in 5 years.

Contributed to the successful launch of the new plus size department by analyzing data and making recommendations on inventory levels. Those efforts lead to 75% improvement in margin dollars from fiscal 2015 – 2016.

ORCHARD SUPPLY HARDWARE, San Jose, CA

2012-2015

Replenishment Analyst

Forecasted, ordered, and allocated all merchandise to support new merchandise resets, all display directives, and advertising events for goods in my department to increase inventory turn, minimizing residual overstock and reduce the amount of markdown dollars needed.

Successfully managed department budget during the company’s bankruptcy by creating reporting and tracking of all open orders with committed dollars to stay within the budget.

COST PLUS WORLD MARKET, Oakland, CA

2006-2012

Planning Analyst

Led monthly meeting with planning department to make recommendations based on analyzing sales trends, patterns, and inventory weeks of supply so orders could be placed, received and budgets were successfully met.

Forecasted weekly sales and inventory for Snacks and Drinks departments to ensure all stores had appropriate levels of inventory to meet sales goals.

Created tops down buy plan and exit strategy for the Halloween Shop to meet the margin dollars’ budget and ensure this key seasonal shop was a financial success.

POTTERY BARN KIDS, San Francisco, CA

2005-2006

Order Management Specialist

Worked with domestic and international vendors to track all purchase orders to ensure timely arrival into the DC to support floor setup and promotional launches.

Coordinated and executed the entire brand’s markdown process by partnering with the VP of Inventory Management to generate a report to assist creating a selling strategy.

Generated and published the Top 40 Report to support Buyers, Planners, and Distribution Analysts in their pursuit to monitor the business performance and create action plan in a timely manner.

SKILLS

Advanced experience in Excel (including VLOOKUP, SUMIF, Pivot Tables, Macros, etc.), Power Point, MS Suite, Hyperion Essbase, Oracle Financials (OBIEE), Micro-Strategies, Business Objects (SAP), Access Database, Peoplesoft, Certified levels I & II Manhattan Automated Replacement System, JDA, RMS Inventory System, FSHM Term (POM), IBM AS-400

Contact this candidate