JACQUELINE HOLME
Winston Hills,Australia
Summary
Analytical thinker with strong data manipulation and interpretation skills, experienced in database management and supply chain planning. Possess extensive background in developing, managing and analyzing complex data sets to facilitate accurate and efficient decision-making processes.
Overview
24
24
years of professional experience
Work History
Purchasing Officer
Snap On Tools Australia Pty Ltd.
10.2022 - Current
- Automating routine data analysis tasks on, freeing up time for more complex analysis.
- Set forecast levels, review stock levels and place recommended orders as per correct protocol.
- Collaborate with buyers for special events and seasonal promotions to maintain adequate product stock and drive sales.
- Review purchasing arrangements with 30 suppliers including price, delivery, performance, and discounts to achieve supply chain costs.
- Manage the supplier contracts to ensure compliance with company policies and legal requirements, safeguarding against potential risks.
- Manage international shipments, ensuring compliance with customs regulations and minimizing shipment delays due to documentation errors.
- Approval of Customs Entries and Invoices adding all freight charges to database for monthly reporting.
- Ensure all receipts match Supplier invoices and follow up discrepancies internally and externally where required.
- Updating of price tapes for purchasing from suppliers and sales to dealers.
- Maintain Item and Bill of Material set up in ERP system.
- Streamlined by implementation of automated part number set up templates for uploading.
- Reporting of Purchasing and Consigned Inventory Reports to Executive Management using access database.
- Produce monthly reports using advanced Excel spreadsheet functions.
- Maintain all Production Control related Applications in ERP system and WMS database.
- Consult with Accounts Team to ensure Received Not Invoiced reports cleared as per correct protocol.
- Implementation of Local Purchase In-transit look up for quick efficient ETA inquiries
- Fostering strong relationships with internal stakeholders by providing timely updates on procurement activities and addressing any concerns promptly.
Senior Parts Data Analyst
Hitachi Construction Machinery (Australia) Pty Ltd
03.2020 - 10.2022
- Primary contact for all planning related data maintenance on over 150K SKU's for 12 locations.
- MRP-related data maintenance (Buyer Groups, Coverage Groups, Item Coverages).
- MRP / Planning-related support.
- SQL Database maintenance for all ERP (MRP-related) and planning related data kept up to date at agreed intervals.
- SKU maintenance and price updates.
- Helped manage large-scale databases to ensure timely access to critical information for key stakeholders.
- Updated and developed scripts and queries to extract data manipulate data from multiple sources.
- Weekly SQL Database maintenance and validation.
- Monthly SQL Database maintenance and validation.
- Provision of high-level customer service to HCA stake holders.
- Periodic data analysis and management reporting.
- Provision of documentation required for internal and external audits.
- Participation in ad-hoc system cleansing activities.
- Support for procurement team / manager in day-to-day operations, management, and reporting of key tasks.
- Identification and implementation of actions required for continuous improvement.
- Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.
- Created a highly effective report driven by SQL code to automate the process of updating the MRP Item Coverage settings daily to significantly impact efficiency and improved operations by taking into consideration stock levels on Item Change related parts.
- Created a highly effective report driven by SQL code to automate the process of reviewing effective SKU Override on a weekly basis for maintenance into Planning Tool by end of trading every week.
- Created a highly effective report driven by SQL to identify overstocks at Branch level.
- Generated ad-hoc reports to evaluate specific business requirements.
Demand Planner – Parts
Hitachi Construction Machinery (Australia) Pty Ltd
06.2019 - 03.2020
- Evaluated demand planning processes and forecast accuracy to identify deficiencies and improvement opportunities.
- Analyzed historical data to identify patterns, trends, and seasonality for use in demand forecasts.
- Weekly maintenance of all planning related data into an SQL database.
- Create, review, and update weekly SKU data in the ERP item coverage tables associated with the MRP planning module.
- Identify and engage with branch locations to verify system forecasts against actual requirements including AMT plans, blend planned demand with system forecasts.
- Actively engage in new machine introduction and population change analysis and manage SKU override functionality in planning tool for required slow moving support stock.
- Assist with Supply Chain modelling.
- Reduced inventory costs by optimizing safety stock levels and effectively managing obsolete items.
- Presented monthly forecast updates to senior management, highlighting key changes and risks in the demand outlook.
- Ran weekly fill rate reports to highlight potential issues and corresponding solutions.
- Assisted in the implementation of a new Demand Planning software system that increased efficiency and improved collaboration among departments involved in the S&OP process.
Part Co-Coordinator
Hitachi Construction Machinery (Australia) Pty Ltd
04.2015 - 06.2019
- Maintain customer KPIs, while maintaining overall inventory value and health.
- Manage Demand Planning Systems, analytical and Master Data tools to maintain control and visibility of robust parts supply.
- Manage and Develop purchasing, allocation and order release processes while providing continuous improvements.
- Identify and provide initiative-taking solutions to improve customer satisfaction and meet expectations.
- Collaborate with operational, IPG teams/managers to maintain and advance Spare Parts KPIs.
- Conduct Sales & Operations Processes (S&OP) to obtain necessary data from Regional Parts & IPG Teams to optimize purchase recommendations.
- Management of critical stock report, backorders, inbound shipment, as well as ad-hoc reporting.
- Engage with Supply Chain and Sales Team providing efficient and effective support to kit building activities.
Purchasing Officer
Snap On Tools Australia Pty Ltd.
04.2001 - 01.2015
Education
Excel level INTERMEDIATE/ADVANCED -
Trainers Direct Pty Ltd
Sydney, NSW01.2023
SQL Course: Level 1 -
University of Sydney (Centre of Continuing Education)
Sydney, NSW01.2021
SQL Course: Level 2a -
University of Sydney (Centre of Continuing Education)
Sydney, NSW01.2021
Certificate of Achievement - Microsoft Access Level 1
Linked Training
Sydney, NSW01.2012
Certificate of Achievement - Microsoft Excel Level 3
Linked Training
Sydney, NSW01.2012
Certificate II - Computer Applications for the Office
TAFE of NSW Nirimba Campus
Sydney, NSW01.2005
Statement of Attainment - Business Skills for the Office (MYOB / Bookkeeping)
TAFE of NSW Nirimba Campus
Sydney, NSW01.2005
Statement of Attainment - Computer Skills for the Office
TAFE of NSW Nirimba Campus
Sydney, NSW01.2001
Skills
- Excel
- SQL
- Access
- ERP systems
- Reporting
- Analytical thinking
- Data manipulation
- Data interpretation
References
- Mark Hibberd, Master data Team Leader, 0419 268 703
- Louise Hope, Quality and Safety Manager, 02 9837 9187
Career Overview
Currently working at Snap-On Tools Australia in a small Purchasing Team but previously worked for seven years in the CSG Parts Team for Hitachi Construction Machinery (Australia) Pty Ltd in various roles including Senior Parts Data Analyst. I have a proven history in data analysis, meeting deadlines, negotiating pricing and delivery timeframes for all purchasing/manufacturing needs. With the experience to forecast product demand and adapt it to any re-ordering system to meet the 'Just in Time' philosophy.
Timeline
Purchasing Officer
Snap On Tools Australia Pty Ltd.
10.2022 - Current
Senior Parts Data Analyst
Hitachi Construction Machinery (Australia) Pty Ltd
03.2020 - 10.2022
Demand Planner – Parts
Hitachi Construction Machinery (Australia) Pty Ltd
06.2019 - 03.2020
Part Co-Coordinator
Hitachi Construction Machinery (Australia) Pty Ltd
04.2015 - 06.2019
Purchasing Officer
Snap On Tools Australia Pty Ltd.
04.2001 - 01.2015
Excel level INTERMEDIATE/ADVANCED -
Trainers Direct Pty Ltd
SQL Course: Level 1 -
University of Sydney (Centre of Continuing Education)
SQL Course: Level 2a -
University of Sydney (Centre of Continuing Education)
Certificate of Achievement - Microsoft Access Level 1
Linked Training
Certificate of Achievement - Microsoft Excel Level 3
Linked Training
Certificate II - Computer Applications for the Office
TAFE of NSW Nirimba Campus
Statement of Attainment - Business Skills for the Office (MYOB / Bookkeeping)
TAFE of NSW Nirimba Campus
Statement of Attainment - Computer Skills for the Office
TAFE of NSW Nirimba Campus
Similar Profiles
Christopher WolfeChristopher Wolfe
Store Manager at Snap On Tools- GL TOOLSStore Manager at Snap On Tools- GL TOOLS
Jerred EngvallJerred Engvall
Sales Associate at Snap-On ToolsSales Associate at Snap-On Tools
Michael MurrieMichael Murrie
NewTool Returns at Snap On Tools FranchiseNewTool Returns at Snap On Tools Franchise