Jesus Vega
Oakland,CA
Summary
I am a data-driven business analyst with nearly a decade of experience in sales performance analysis, reporting automation, and pricing analysis within the food and beverage industries. My background includes building and optimizing reporting tools, analyzing category and product performance, and collaborating cross-functionally with sales, finance, and operations teams. I have a strong command of Excel, Power Query, VBA, and CRM systems, which I’ve used to streamline processes, train colleagues, and deliver actionable insights that drive revenue growth, and operational efficiency.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Sales Performance Analyst
RNDC
Pleasanton, CA
05.2024 - Current
- Identified opportunities for improving business processes through automation and technology solutions.
- Prepared ad-hoc reports based on requests from internal customers or external stakeholders.
- Collaborated with analysts from other states to create best-in-class reporting practices.
- Optimized existing reports that were being used in other states to run more efficiently and with fewer errors using Power Query and Macros.
- Worked with the finance team on cost analysis for new pricing models.
- Created and maintained reports tracking sales progress toward monthly goals and forecasts, and identified areas of risk.
- Created customizable price elasticity reporting tools to ensure our products are optimally priced in all geographical areas.
Business Analyst
RNDC
Pleasanton, CA
06.2020 - 04.2024
- Created and maintained sales and forecasting reports to track our progress toward program goals.
- Collaborated with sales representatives and warehouse teams to ensure we had sufficient inventory levels across all of our CA warehouses to meet our sales forecasts and goals for each month.
- Worked closely with the portfolio managers to create and maintain reports to track our progress towards portfolio short-term and long-term goals and commitments.
- Trained other analysts to use our CRM systems.
- Conducted insightful, ad hoc analyses to investigate ongoing or one-time operational issues.
Customer Intelligence Analyst
Young's Market Company
Pleasanton, CA
01.2018 - 05.2020
- Reviewed product schematics for customer accounts, and recommended changes to improve the customer’s sales, as well as Young’s product placements.
- Created and maintained price elasticity reports for our sales representatives to ensure all products were priced at optimal retail prices.
- Collected and organized display and ad data to track promotional goals.
- Created and maintained item performance reports to identify any items that were at risk of being discontinued, and helped our sales representatives create a plan to save products from being discontinued or recommend another product from our portfolio for a swap.
Customer Solutions Coordinator
The Save Mart Companies
Dublin, CA
11.2015 - 12.2017
- Built promotional calendars for optimal promotional effectiveness.
- Built reporting tools to evaluate the performance of the promotional event as a whole, and the individual performance of each product in the promotional event.
- Continually analyze category trends and customer buying patterns.
- I wrote recommended orders for promotions for each store based on their past sales history and inventory on hand.
- Trained coworkers on how to use the new reporting tools created.
- Created Excel reports with VBA tools to automate processes.
Education
Bachelor of Science - Accounting
California State University, East Bay
Hayward, CA12-2012
Skills
- Data analysis and reporting
- Sales forecasting and trend analysis
- Inventory management
- Cost analysis and price elasticity
- Power Query expertise
- CRM systems management
- Project management and collaboration
- Excel and Power BI proficiency
- Training and development
- SQL experience
- Python and Java experience
- Process automation
- Macros and VBA knowledge
- Microsoft PowerPoint proficiency
- Effective communication
Languages
Spanish
Native/ Bilingual
Certification
- WSET II Wine & Spirits
Timeline
Sales Performance Analyst
RNDC
05.2024 - Current
Business Analyst
RNDC
06.2020 - 04.2024
Customer Intelligence Analyst
Young's Market Company
01.2018 - 05.2020
Customer Solutions Coordinator
The Save Mart Companies
11.2015 - 12.2017
Bachelor of Science - Accounting
California State University, East Bay
Similar Profiles
Gary ORTEZGary ORTEZ
Route Driver at RNDCRoute Driver at RNDC
Blake SgambaBlake Sgamba
District Sales Manager at RNDCDistrict Sales Manager at RNDC
Roy SanchezRoy Sanchez
Chain Sales Consultant at RNDCChain Sales Consultant at RNDC
Michelle StanwoodMichelle Stanwood
Sales Representative at RNDCSales Representative at RNDC
Marlenne GarciaMarlenne Garcia
Retail Cashier at BurlingtonRetail Cashier at Burlington