JOHN RODRIGUEZ
South Ripley
Summary
Driven Supply Chain Specialist with 10+ years of experience overseeing compliance, inventory management, customer care, and logistics control. Adept at translating raw data into actionable insights through advanced analytics, automation, and data visualization (e.g., Power BI) to drive measurable cost savings and operational efficiencies. Recognized for successfully implementing Transport Management Systems, optimizing reporting processes, and boosting revenue through innovative solutions that align with evolving business needs. A loyal, dependable team leader, skilled in cross-functional collaboration, performance metrics, and stakeholder training, with a proven track record in continuous improvement, strategic decision-making, and operational excellence.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Supply Chain Analyst
Container Exchange
07.2021 - Current
- Project-managed and implemented a new Transport Management System (TMS), including user training for 300+ staff across 80+ QLD sites.
- Designed and developed automated Power BI reports, enhancing analytics capabilities and enabling data-driven decision-making.
- Managed comprehensive data processes (ETL, transformation, modelling) to improve reporting efficiency and accuracy for the operations team.
- Created operator-focused reports that facilitated a 30% reduction in logistics costs.
- Optimized freight consolidation processes by evaluating carrier performances regularly, enhancing overall shipment efficiency rates across the board.
- Conducted in-depth analyses of logistics, site capacities, on-site movement, and equipment utilization, generating cost-saving insights.
- Managed supplier relations, resulting in improved communication, timely deliveries, and enhanced collaboration for future projects.
- Presented monthly performance reports to senior management, providing actionable recommendations for continuous improvement and cost optimization.
- Developed contingency plans proactively which resulted in minimal disruption during periods of unexpected supply chain events or emergencies.
- Conducted in-depth risk assessments for logistics and supply chain operations, initiating preventative measures that minimized potential disruptions.
- Conducted comprehensive data analysis to identify trends and opportunities for process improvement in the supply chain.
- Conducted data analysis to identify bottlenecks in supply chain and develop solutions to optimize operations.
- Supported senior company leaders by delivering reports outlining performance to drive process improvements.
- Developed and maintained automated reporting solutions to expedite invoice processing, enabling 30+ invoices to be completed within the first week each month.
- Identified and implemented process improvements to streamline business-as-usual tasks and enhance operational efficiency.
- Supported key commercial decisions by providing robust cost models, forecasting, and analysis for supplier evaluations, tender processes, and contract negotiations.
- Collaborated cross-functionally to improve reporting systems, data quality, and reporting timelines, ensuring high-quality information for strategic planning.
Supply Chain Analyst
Defiance Maize
03.2021 - Current
- Designed and developed basic ERP functionality within Microsoft excel (2012) with view of migrating to Office 365 in the future
- Mapped processes to holistically examine business flow and identify improvement opportunities
- Performed system analysis, documentation, testing, implementation and user support for platform transitions
- Used analytical models and mathematical analysis to create and maintain key performance metrics
- Optimized execution of supply chain by forecasting, scheduling orders and balancing inventory levels for over [44] accounts
- Managed production levels, identified material shortages and monitored inventory levels to meet order delivery requirements
- Led implementation of effective supply chain planning systems while improving sales and operations planning processes for distribution network
- Continuously assessed current reporting techniques and developed improvements to boost accuracy
- Enhanced data integrity by applying meticulous attention to detail when reviewing and analyzing data maintenance processes
- Implemented improved reporting techniques, resulting in performance deficiencies identification
- Analyzed reporting functions and efficiency to reduce error rates and increase efficiency by 400%
- Automated multiple reporting tasks through creation of reporting tools
- Used Power Query (Office 365 - Excel) to generate required reports and optimize query creation
- Studied movement of goods to identify gaps in efficiency and other areas needing improvement
Supply Planner & Controller
Capilano
08.2019 - 03.2021
- Designed and developed forecasting model based on managing capacity, product by product forecast, quality testing requirements, and safety stock levels with constant adherence to cost efficiency
- Designed and developed reporting model to visually articulate budget vs actual performance and expenses for operations and finance data
- Submitted monthly to senior leaders and directors
- Collaborated with internal teams to improve outputs to meet demand and supply requirements, ensuring inventory integrity targets for finished goods
- Created reports to maintain open dialogue with product and service users and key suppliers, facilitating communication and helping prioritize opportunities
- Drove key performance indicators and continuous improvements throughout logistics and supplier operations
- Devised and implemented short-term and long-term plans, optimizing supply chain management, and improving value relating to annual expenditures
- Achieved DIFOT of 99% across various high profile customers through adaptive demand and production planning
- Improved achievement to plan (performance) from 60% to 120% efficiency
- Analyzed and reviewed least cost path for SLOB stocks
- Worked closely and communicated effectively with various internal stakeholders including QA/QC, Marketing, Procurement, Warehouse, and Senior Management
- Troubleshooted issues that impacted production, budget and/or schedule
- Identified potential risk to production and initiate risk management
- Integrated financial and operation plans with strategic objectives to deliver improved operational and financial results to boost customer satisfaction, profitability and working capital
- Oversaw supply chain and supported tech transfer projects, batch release testing, change management and resolution of customer complaints
- Balanced demand and supply while aligning volume and mix to achieve production objectives
- Maintain balance between export orders and domestic stock levels to ensure alignment with procurement, packaging, warehousing and logistics
Supply Chain Analyst
George Weston Foods
12.2016 - 06.2019
- Company Overview: George Weston Foods is one of the largest consumer products companies in Australia
- It is a wholly owned subsidiary of Associated British Foods Plc
- Its brands include Tip Top and Top Taste
- Along with Goodman Fielder, it is one of the two main commercial bread manufacturers in Australia
- Ensure stock availability, logistics scheduling and freighter relationship management, ensuring that supplier invoice validations to grain handler agreements and stock movements are accurate in tonnes and dollars
- Responsible for the timely and accurate processing of commodity Stock Transfers, and movements within commodity positions in business through the commodity SAP grain system
- Making sure internal controls are followed and that movements processed in SAP grain is timely and accurate
- Design and implement execution delivery plans to ensure commodity deliveries align with demand forecast presented by demand planner
- Drive and negotiate cost savings across the supply chain for commodity logistic movements
- Responsible for all communications with transport providers, including relationship management, conflict resolution, problem solving, ensuring maximum efficiency and ensuring that supply chain savings are captured
- Establish and manage best practice benchmarks and performance measures for freight providers, conducting monthly SRM reviews
- Assessing freight carrier value through freight tender process
- Conducting monthly site meeting in VIC and QLD for future CI opportunities
- Ensure relevant cost data is maintained and managed in SAP, that correct data is captured for management of internal orders to minimize errors
- Provide monthly reporting comparing actual v's budget assumptions
- Ensuring that SAP entry related to commodity movements is done timely, accurately & communicated to internal and external stakeholders
- Grain Invoice validations to cost conditions
- Designed and developed arbitrary logistical planning and scheduling tool
- Designed and developed arbitrary financial planning tool to forecast execution plan based on current inventory, contracts, and costs compared to internal budget
- Resolved complaints and eliminated delays by collaborating with vendors and updating strategies
- Collaborated with management, sales, and engineering to adjust plans and maintain targets
- Completed supplier reviewed to manage over [6] supplier relationships
- Kept adequate supply flow to meet production needs
- Automated office operations, and managed client correspondence, stock record tracking, scheduling, and data communications
- Increased on-time transport arrivals by managing logistics, travel route planning, arrival date confirmation and cargo verification
- Sustained safety protocol to ensure proper, cost-effective, and safe handling of equipment and material usage
- Adjusted production schedules to account for issues such as supply interruptions or labor shortages
- Used analytical models and mathematical analysis to create and maintain key performance metrics
- Studied movement of goods to identify gaps in efficiency and other areas needing improvement
- George Weston Foods is one of the largest consumer products companies in Australia
- It is a wholly owned subsidiary of Associated British Foods Plc
- Its brands include Tip Top and Top Taste
- Along with Goodman Fielder, it is one of the two main commercial bread manufacturers in Australia
Project Coordinator
HAYS
07.2016 - 12.2016
- Developed new analytics tool to allow senior management to understand the impact of each project
- Designed work and company process flow charts Analyzing stock data and generating reports for Project managers, Operations Managers and Directors
- Served as the single point of contact for project scheduling and changes
- Monitored team progress and enforced deadlines
- Delivered status reports to operations manager for budgeting and planning purposes
- Liaising with Suppliers for incoming stock and all inquiries needed by different departments of the business and/or clients
- Liaising with 3PL companies to assure all deliveries arrive to destination on-time and clients are aware of any delays that may incur
- Investigate stock discrepancies
- Reconcile return and service orders against all stock
- Ensuring all purchase order ETAs are entered into the system
- Raising Purchase orders for equipment and materials needed on-site
Data Analyst
Australian Pharmaceutical Industries
02.2015 - 06.2016
- Reduced organizational operating costs by 20% by streamlining processes
- Identified 'bottlenecks' and implemented new and improved processes and policies
- Documented process flows and developed requirements for functional improvements and enhancements
- Design and develop macros to be able to generate reports and other company requirements
- Analysis of data from internal departments and external sources for the Retail and Wholesale part of the business and amending them with an emphasis on high accuracy
- Maintenance, validation, and organization of product information with records to ensure all product information is accurate and aligned
- Communicating with Directors and key stakeholders of businesses for claims issues and other matters
- Vendor change over process which includes the price changes and promotions
- Validation and update of article information in SAP based on information supplied by vendors
- Generating reports for different aspects of the business
- Advanced usage of Microsoft excel to export & import data from SAP (Using macros to efficiently complete tasks and reports)
- Analyzed SAP transactions to build logical business intelligence model for real-time reporting needs
- Identified and documented detailed business rules and use cases based on requirements analysis
Project Coordinator
Telstra Business Centre
01.2015 - 09.2015
- Coordinating site inspections/installations with 3rd party installers
- Provisioning client orders
- Rectifying client issues and opt to make the best possible improvements
- Liaising with account managers, service executives and sales manager
- Creating orders via TBS tool
- Liaising with Finance companies, business communication solutions companies and telecommunications engineers to process client orders
- Assuring daily pipeline of activities/orders are up to date
- Sorting weekly sales reports to archive sales processed and being processed
- Submitting Blitz reports for clients
- Analyzing site inspection reports from telecommunications engineers
- Planning and organizing site visits, new connection installations, porting connections from different providers, installation of new phone systems & connections from main exchange to PABX
- Oversee all current jobs and activities being done & assuring they are up to date and no delay will occur
- Scanning and archiving client contracts and financial paperwork
- Reporting weekly to sales manager regarding current updates on projects & orders
- General product information provision to clients post-sale
Logistics Coordinator
Trivett
01.2013 - 12.2014
- Resolve customer orders and complaints via phone & email
- Manage weekly and monthly database records
- Conduct weekly toolbox for colleagues
- Dispatching and manifesting daily metro and interstate deliveries
- Assuring OH&S is kept within the warehouse
- Recording all deliveries and sales made for the day by using Microsoft Excel
- Coordinating with different 3rd party logistics for daily deliveries (TNT, STARTRACK, TOLL, AAE, AIR ROAD, CEVA & DHL)
- Ensuring daily KPI is achieved through successful leadership
- Reporting to Operations manager for progress report
Education
Master of Science - Information Technology
De La Salle University
07-2023
Bachelor of Science - Information Technology
De La Salle University
01.2012
High School Diploma -
St. Andrew's Cathedral
01.2008
Skills
- Proficient in ERP systems (SAP, QAD)
- Skilled in system integration and multi-plant operations
- Advanced Power BI reporting and SharePoint integration (including Excel-linked dashboards)
- Data analysis, database design, and data management
- Expertise in Office 365 suite and Microsoft Visual Basic
Technical & Systems Expertise
- Comprehensive supply chain planning and execution
- Managing logistics operations to meet supply and demand requirements
- Experience in supply chain management strategies and optimization
- Effective project management skills, guiding initiatives from concept to completion
Supply Chain & Logistics
Project & Stakeholder Management
Certification
Certifications & Professional Development
- Certificate of Debt Collection – Compliance Environment (CreditWise)
- Certificate of Achievement – Preventing Bribery and Corruption (Associated British Foods)
- Agile Fundamentals (Scrum/Kanban principles, Agile mindset and practices)
Additional Information
Used Microsoft Excel to develop inventory tracking spreadsheets., Designed and implemented a scalable infrastructure capable of processing large amounts of data, boosting efficiency by 80%., Handled several high-level projects simultaneously, successfully delivering each of them in less time than was expected., Monitored and assessed issues that arose with clients, ensuring immediate resolution which promoted stronger relationships and resulted in more lucrative projects., System Integration Aligned office departments and increased inter-department communication and data sharing., Project Management Coordinated with third-party development team on engineering and professional service activities and tasks.
Timeline
Supply Chain Analyst
Container Exchange
07.2021 - Current
Supply Chain Analyst
Defiance Maize
03.2021 - Current
Supply Planner & Controller
Capilano
08.2019 - 03.2021
Supply Chain Analyst
George Weston Foods
12.2016 - 06.2019
Project Coordinator
HAYS
07.2016 - 12.2016
Data Analyst
Australian Pharmaceutical Industries
02.2015 - 06.2016
Project Coordinator
Telstra Business Centre
01.2015 - 09.2015
Logistics Coordinator
Trivett
01.2013 - 12.2014
High School Diploma -
St. Andrew's Cathedral
Master of Science - Information Technology
De La Salle University
Bachelor of Science - Information Technology
De La Salle University
Similar Profiles
Srishti KalyankarSrishti Kalyankar
Global Team Lead - GSC at MatchBox Exchange - Container LogisticsGlobal Team Lead - GSC at MatchBox Exchange - Container Logistics
Shreyas AgrawalShreyas Agrawal
Customer Support Specialist at MatchBox Exchange - Container LogisticsCustomer Support Specialist at MatchBox Exchange - Container Logistics
MD SULEMAN KHANMD SULEMAN KHAN
Senior Accountant at ATLANTIC CONTAINER LINE PVT.LTD and JAYPEE CONTAINER LINE PRIVATE LIMITEDSenior Accountant at ATLANTIC CONTAINER LINE PVT.LTD and JAYPEE CONTAINER LINE PRIVATE LIMITED
Coen CebulskiCoen Cebulski
Production Assistant at MOCO Food ServicesProduction Assistant at MOCO Food Services
Jack LovejoyJack Lovejoy
Shift Fitter at Orora Beverage CansShift Fitter at Orora Beverage Cans