Learn Data Skills
Jon Vasquez

Jon Vasquez

Data analyst

Haas School of Business, UC Berkeley | Birmingham, AL

Technologies

My Portfolio Highlights

My New Workbook

Project: Evaluate a Manufacturing Process

My New Workbook

Project: Analyzing Unicorn Companies

My New Workbook

Project: Evaluate a Manufacturing Process

Creative and versatile data analyst with 14+ years of multifaceted analytics experience as an operations director, sales executive, and project management leader.

My Work

Take a look at my latest work.

DataLab

Project: When Was the Golden Era of Video Games?

DataLab

Project: Analyzing Motorcycle Part Sales

DataLab

Project: Evaluate a Manufacturing Process

DataLab

Project: Analyzing Unicorn Companies

DataLab

Project: When Was the Golden Era of Video Games?

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Power BI
Data Manipulation in SQL
Data Visualization in Power BI
Introduction to DAX in Power BI

My Work Experience

Where I've interned and worked during my career.

Veho | Jun 2023 - Jan 2024

Sr. Operations Analyst, Demand Planning

Hired to scale and sharpen demand planning (forecasting) process for 500M/month parcel delivery network. Produced weekly operational forecasts used for resource planning by warehouse, transportation, and marketplace teams across five US regions. Data analyst role supported Sales and Marketing with key account insights and bespoke reporting ahead of quarterly business review and board meeting cycles. ➤ Improved forecast accuracy 10% by installing a quality control monitoring process. -Introduced client-specific defect detection logic and created a root cause remediation playbook that replaced subjective decision making with repeatable best practices. -New process removed single point of failure, documented tribal knowledge, and brought company wide-transparency to how forecasting works. ➤ Lowered capacity utilization costs 10% by enriching existing SQL reports. -Defined business logic to classify package dimensions (small, med, large, etc.) that enabled the Marketplace team to assemble denser package delivery routes. -Denser routes led to more intelligent pricing that reduced average cost per package. We no longer paid the same price to deliver packages of different sizes. ➤ Automated forecast assessment process by developing a set of quality dashboards in Google Sheets that ingested purpose-built PostgreSQL queries I wrote. -Created statistical tools (control charts, Pareto charts, histograms, etc.) and standard operating procedures (SOPs) to better assess forecast accuracy and to ensure weekly scoring workflow could be distributed across team members. -Cleaned, filtered, and transformed client-provided forecast data by creating bespoke translation workflows for 8 clients across the meal-kit and retail industries.
Show More

Bravely | Nov 2021 - Jun 2022

Director Of Operations

Actively recruited to build the Operations department. This entrepreneurial role was responsible for establishing process and analytics capability ahead of aggressive growth. Managed 2 direct reports and was responsible for coach (contractor) acquisition and coaching session fulfillment metrics. Reported to CEO ➤ Reduced supply acquisition cycle time by 53% (17 to 8 weeks) by overhauling unstructured recruiting process and introducing visibility into capacity utilization analytics. -Reengineered contractor recruiting process by documenting and analyzing process flow chart to remove bottlenecks, redundancies, and avoidable handoffs. Implemented lightweight database (Airtable) to centralize and record decision making. -Created a data pipeline from Salesforce.com to Google Sheets that translated deal flow data into precise fulfillment forecasts and coach recruiting schedules. -Built a process KPI dashboard and established a weekly review cadence with peer directors to anticipate spikes in demand and proactively set sales expectations. ➤ Quantified pathways to increase gross margin 6% by reducing platform cancel and no-show rates that had gone previously unnoticed. -Conducted and presented financial analysis spanning multiple data sources to executive leadership team. -Quantified actionable recommendations through retroactive impact modeling, benchmarking against academic research, and conducting user interviews.

Bellhop | Mar 2020 - Apr 2021

Director, Partner Success

After successful turnaround of Carrier Ops department, tapped to create the Partner Success department. Responsible for adapting B2C sales and scheduling workflows to operationalize B2B partnerships that gave exposure to valuable recurring revenue streams. Managed team of 9 (including 6 call center reps) and reported to VP of Sales. ➤ Scaled client account base 4x from (5 to 20) accounting for 15% of company revenue within six months of launching the team. -Defined a new set of processes and SOPs to standardize client-specific booking workflows, and month-end client billing. -Created a B2B pricing model that provided guardrails for partnership deal negotiations. Pricing math took into account operational constraints, historic performance and trends, and profitability requirements.

Bellhop | Nov 2018 - Mar 2020

Director, Carrier Acquisition

Hired to turn around the Carrier (truck) Operations team, which had been hobbling revenue growth. Inability to recruit and retain carriers forced us to turn away business and consistently low job quality resulted in high discounts rates. Managed 8 direct reports, owned transportation P&L line item (highest cost driver), and reported to COO. ➤ Enabled 100% YoY revenue growth by fixing the truck recruiting process. -Introduced a new recruiting workflow by implementing Salesforce.com -Restructured team into generalist role into specialist sales and quality functions. -Deployed Tableau dashboards to increase visibility and drive accountability. ➤ Reduced average truck cost 15% by conducting sales analysis to define market-specific contractor payment rates. Rolled out commission program to drive compliance.

IPC Global | Sep 2016 - Aug 2018

Account Executive

• Quota-carrying role responsible for winning new business and growing account base revenue. • Developed negotiation skills with focus on client finance and economics challenges. • Positioned analytics solutions to companies with fragmented data landscapes.

Qlik | May 2015 - Sep 2016

Account Executive

• After completing MBA, took this role to learn sales process and develop expertise in enterprise business intelligence software. • Top rep in the world for education services licenses (227% quota attainment). • Closed 16 new customers in industries spanning financial services to professional sports.

The Advisory Board Company | Oct 2012 - May 2015

Associate Director, Performance Technologies

Consulting management role focused on establishing software implementation department to support the launch of a mobile nurse rounding product aimed at a nation-wide customer base of over 100 healthcare providers and hospital systems. Managed 4 direct reports and was responsible for a portfolio of 60+ software implementations involving user training, infrastructure setup, and data integration. - Developed data integration procedure to ingest realtime hospital data into proprietary cloud based analytics platform. -Created a turnkey software implementation template that increased capacity for simultaneous deployments from 4 to 10. Efficiencies realized by collaborating with Product Management, Software Development teams, and Data Services teams.

ActiveStrategy, Inc. | Apr 2009 - Oct 2012

Senior Consultant

•Led client facing software implementation projects for customers across a broad set of industries including industrial materials, consumer packaged goods, and municipal and federal government. •Key focus areas included project management, account renewal and growth, and executive stakeholder management and communication.

ActiveStrategy, Inc. | Apr 2008 - Apr 2009

Sr. Associate

•Developed project management and data integration subject matter expertise. •Acquired the Certified Project Management Associate (PMI) credential, and achieved a working command of structured query language (SQL) and database design.

My Education

Take a look at my formal education

Master of Business Administration - MBA University of California, Berkeley, Haas School of Business | 2015
Bachelor's degree, MathematicsUniversity of California, Berkeley | 2005

About Me

Jon Vasquez

Director turned data analyst, specializing in applying business analysis and analytics to reveal insights through SQL queries, advanced excel, and data storytelling.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free