Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Cathy Villarreal

Monroe

Summary

Results-driven Aftermarket Supervisor with expertise in Excel budget tracking, accounts receivable management, and workbook creation. Possesses a comprehensive understanding of team dynamics and demonstrates the ability to effectively coordinate cross-functional team projects. Skilled in conflict resolution and performance optimization, committed to fostering a productive work environment and driving team success.

Overview

10
10
years of professional experience
1
1
Certification

Work History

SUPERVISOR- NATIONAL SALES ADMINISTRATION

Niterra/NGK Spark Plugs
09.2023 - Current
  • Manage designated staff including direction, training, and outputs
  • Lead, train, motivate and coach team to meet departmental and customer objectives
  • Ensure onboarding process that includes trainings to be conducted and be successful for new hires during their introductory period
  • Maintain departmental training material to be current
  • Responsible for coordination of existing National accounts and potential new business as acquired by National Sales Department
  • Act as a liaison between the National Sales Manager and the customer
  • Resolve any issues that relate to customers
  • Maintain account reconciliation report
  • Tracking all account deductions and issuing credits
  • Fulfilling Return requests/Managing budget.
  • Process customer orders for NGK products including special order projects, as needed
  • Manage, monitor, and report customer PO fill rates
  • Complete various forms of reports and other paperwork related to department activities
  • Generate Business Intelligence (BI) reports
  • Monitor obsolesce and superseded part numbers related to customer PO's and make necessary adjustments in SAP as needed
  • Access and navigating customer portals

DATA ANALYST

Driv
10.2019 - 04.2023
  • Assisted in managing Driv Inc largest aftermarket account-$250M in account responsibilities for MOOG Steering & Suspension, FeI-Pro Gaskets, Wagner Brake Products, Champion Plugs, Walker Exhaust and Monroe Shocks for Advance Auto Parts &CARQUEST
  • Resolved financial discrepancies and outstanding issues on payments/deductions
  • Coordinated and facilitated monthly meetings between Customer Financial Services and Sales Departments
  • Maintain an account reconciliation report in order to effectively recognize and proactively address large issues
    Responsible for planning, creating, and tracking yearly multi-million returns budgets in Excel using pivot tables,
    macros, formulas and VLOOKUP's.
  • Initiated, directed, and participated in weekly status reviews with Driv and Advance senior management covering cataloging, pricing, marketing, supply chain, EDI, IT, and financial budgets across corporate functions.


  • Processing and tracking POs for weekly replenishment order, running reports, obtaining part status, and checking
    inventory from our manufacturing plants
  • Power BI reporting on daily inventory use, monthly and quarterly sales numbers
  • SharePoint and One drive cloud usage for storing and sharing reports and files
    • Assist in preparing/analyzing customer reports
    • Entered al; credits for the account that were due to the customer. (Marketing, fines, rebates, changeovers)
  • Managed and ensured compliance with contractual agreements related to
    terms and conditions of sale: pricing, returns, warranty, credits and deductions.

CUSTOMER SERVICE REPRESENTATIVE

Tenneco Automotive
09.2014 - 10.2019
  • Assisted in managing Driv Inc largest aftermarket account-$250M in account responsibilities for MOOG Steering & Suspension, FeI-Pro Gaskets, Wagner Brake Products, Champion Plugs, Walker Exhaust and Monroe Shocks for Advance Auto Parts & CARQUEST
  • Resolved financial discrepancies and outstanding issues on payments/deductions
  • Coordinated and facilitated monthly meetings between Customer Financial Services and Sales Departments
  • Maintain an account reconciliation report in order to effectively recognize and proactively address large issues
  • Responsible for planning, creating, and tracking yearly multi-million returns budgets in Excel using pivot tables, macros, formulas and VLOOKUP's
  • Initiated, directed and participated in corporate cross functional weekly status reviews between Driv and Advance Senior management regarding cataloging, pricing, marketing, supply chain, EDI, IT and financial budgets
  • SAP-PTA/EP1 experience
  • Processing and tracking POs for weekly replenishment order, running reports, obtaining part status, and checking inventory from our manufacturing plants
  • Power BI reporting on daily inventory use, monthly and quarterly sales numbers
  • SharePoint and One drive cloud usage for storing and sharing reports and files
  • Assist in preparing/analyzing customer reports
  • Entered all BA credits for the account that were due to the customer (Marketing, fines, rebates, changeovers)
  • Managed and ensured compliance with contractual agreements related to terms and conditions of sale: pricing, returns, warranty, credits and deductions
  • Main CSR contact for two tops accounts for DRiV, which is over $200MM worth of business
  • Manage multiple product lines for retail customers totaling 7 million in sales
  • Troubleshoot incoming calls from direct customers and sales reps
  • Create and maintain customer profiles
  • Build customer loyalty by providing superior service to meet or exceed the needs and expectations of internal and external customers
  • Manage and maintain multiple email boxes
  • Run and distribute weekly reports to plant management
  • Ensure data and comments are accurately updated on daily reporting
  • Coordinate order fill and shipment logistics with both Production Planning and the Distribution Center teams
  • Analyze, reconcile and identify root cause of order fill and customer fines
  • Prepare corrective action as required
  • Identify and investigate cost saving opportunities
  • Advises customers on substitution or material matter of parts
  • Enter customer claims in database and initiate corrective actions and follow up
  • Apply sales policies, pricing, transportation and shipping information
  • Coordinate and process new store inventory and store changeovers
  • Monitor first-time orders to ensure delivery guidelines are met
  • Assist with the recruitment and implementation of customers to electronic ordering
  • Facilitate resolution of customer concerns and deductions

Education

ASSOCIATE OF ARTS - INFORMATION TECHNOLOGY,CUSTOMER SUPPORT

University of Phoenix
05.2014

Skills

  • Proficiency in MS Office applications
  • Customer service
  • Annual Returns
  • Back-order monitoring
  • Time Management
  • Team development
  • Problem Solving Skills
  • EDI experience
  • Proficiency in MS Office applications
  • Strong SAP knowledge
  • Continuous improvement
  • PowerBI
  • Account Reconciliation
  • Inventory Oversight
  • Process Improvement
  • Dispute resolution
  • Staff education and training
  • Team collaboration

Certification

  • Delta Black Belt Certification-Business Insights

Black Belt Level 1 Certification, Delta Associates, Inc, 2022

Timeline

SUPERVISOR- NATIONAL SALES ADMINISTRATION

Niterra/NGK Spark Plugs
09.2023 - Current

DATA ANALYST

Driv
10.2019 - 04.2023

CUSTOMER SERVICE REPRESENTATIVE

Tenneco Automotive
09.2014 - 10.2019

ASSOCIATE OF ARTS - INFORMATION TECHNOLOGY,CUSTOMER SUPPORT

University of Phoenix
Cathy Villarreal