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
Similar Profiles
Nikhil LNikhil L
Sales and Service Engineer at Niterra India Pvt Ltd (Formerly NGK Spark Plugs)Sales and Service Engineer at Niterra India Pvt Ltd (Formerly NGK Spark Plugs)
David RoyceDavid Royce
Account Executive – OEM Division at Niterra North America, Inc. (Formerly NGK Spark Plugs (U.S.A.), Inc.)Account Executive – OEM Division at Niterra North America, Inc. (Formerly NGK Spark Plugs (U.S.A.), Inc.)
HAMZA MASSOUKHAMZA MASSOUK
Package Handler at NGK Spark Plugs U.S.APackage Handler at NGK Spark Plugs U.S.A
Mackenzie WiseMackenzie Wise
Front Desk Receptionist at Moss EyecareFront Desk Receptionist at Moss Eyecare
LATORIA THOMASLATORIA THOMAS
Special Education Teacher at Special School District of LouisianaSpecial Education Teacher at Special School District of Louisiana