James Langtry Email & Phone Number

Liverpool, Nsw, Au

Sydney, New South Wales, Australia

Sydney, New South Wales, Australia

• Popularized the use of power BI at Zip by collating a wide array of close to real time operations data and presenting it in interactive dashboards customized to the specific needs of each team it’s shared with.• Created a new work order planning process that factors in inputs from all of the stakeholders at Zip, manufacturing capacities and am responsible for using that to plan the day to day production of Zips flagship product, the hydrotap.• Created a new report to quickly… Show more • Popularized the use of power BI at Zip by collating a wide array of close to real time operations data and presenting it in interactive dashboards customized to the specific needs of each team it’s shared with.• Created a new work order planning process that factors in inputs from all of the stakeholders at Zip, manufacturing capacities and am responsible for using that to plan the day to day production of Zips flagship product, the hydrotap.• Created a new report to quickly recalculate the implications of delayed component deliveries brought on by COVID-19 so better decisions on strategic use of air freight can be made sooner, minimizing or negating the impact to productivity on the factory floor.• Support the new planning process with multiple reports that begin with SQL queries drawing from the ERP system, merging in other useful data sources and tailoring each report to clearly provide insights for every day operations.• Host supply reviews with the sales teams, collecting their forecasts and insights then presenting that at the monthly demand review with the operations management to plan capacities. • Daily reporting to the Executive team and wider business on production, backlogs and invoicing figures.Working closely with the various sales teams to understand their needs and objectively plan allocating resources evenhandedly to achieve the best DIFOT result possible for the company.• Work closely with the teams on the manufacturing floor and warehouse to understand and overcome constantly moving challenges and acting as the intermediary between the sales team and operations.• Was selected to go on a 6 day leadership training program hosted by SIRF roundtables which covered: management types, change management, employee engagement, giving & receiving feedback, time management and developing strategies. Show less

Condell Park

• Find novel applications for SQL queries & power query M formula language to efficiently pull big data from our ERP system and turn it into easily refreshable and understandable reports.• Built refreshable reports for the Exec, Finance, Engineering, Purchasing, Warehouse, Export, operations, and sales teams to streamline processes that were being done in very manual time-consuming ways and am often called into projects to provide analysis support.• Supported the purchasing team… Show more • Find novel applications for SQL queries & power query M formula language to efficiently pull big data from our ERP system and turn it into easily refreshable and understandable reports.• Built refreshable reports for the Exec, Finance, Engineering, Purchasing, Warehouse, Export, operations, and sales teams to streamline processes that were being done in very manual time-consuming ways and am often called into projects to provide analysis support.• Supported the purchasing team creating reports that identify issues before they become stock outs; the most in depth being the running stock on hand report that calculates our SOH week by week for our thousands of components factoring in purchase orders, typical demand, lead times and assigning a level risk which the purchasing manager can then use to follow up with the appropriate purchasing officer quickly.• Made Zips DIFOT (Delivery In Full On Time) report from scratch using power BI and am responsible for presenting the results with the rest of the company each month.• Support new team members with training and writing new standard operating procedures they can use which include process mapping out of MS Visio• Be part of the Zips Master Data Improvement Committee where we filled gaps and used the more complete datasets to drive improved analysis and in particular our suppliers metrics which was used in price negations. • Recalculate and propose changes to the safety stock levels to the rest of the operations team on a quarterly basis and report daily on current stock levels against these set targets.• Run SLOBs analysis and recommend what can be disposed of. Show less

Sydney, Australia

• Analyze and report on short dated inventory to minimize wastage by advising the sales team which stock to target for promotions.• Proficiency with the ERP system Microsoft AX not only for day to day use but to the extent of creating work instructions for warehouse personnel and internal suppliers. • Travelling interstate periodically to assist internal suppliers with warehouse and supply chain management.• Stocktake and reconcile SOH at contract manufacturers and… Show more • Analyze and report on short dated inventory to minimize wastage by advising the sales team which stock to target for promotions.• Proficiency with the ERP system Microsoft AX not only for day to day use but to the extent of creating work instructions for warehouse personnel and internal suppliers. • Travelling interstate periodically to assist internal suppliers with warehouse and supply chain management.• Stocktake and reconcile SOH at contract manufacturers and packers. • Work with 3rd party auditors to transparently report inventory accuracy. • Solely held accountable for reporting all inventory movements and adjustments to the finance team on a monthly basis. • Accurately create daily/weekly delivery schedules based on information provided by contract manufacturers and 3rd party packers. • Continually evaluate inventory holdings at all storage facilities to ensure stock is in the right place at the right time with the most efficient movements possible.• Develop and maintain SOPs, Work Instructions and Process Maps for all inventory processes.• Very high proficiency with Excel to turn raw SOH and transaction data exports into clear, concise inventory reports for any department that may require it. Show less

Sydney

• Responsible for coordinating the receipt of the vast majority of inbound traffic at our 10,000 square meter 3PL warehouse.• Understand and react to the needs of our clients that come from a wide range of industries including; Airlines, Telecommunications, industrial machinery and wholesale food. • Organise personnel and assisting with training, whilst also compiling budgets and invoices.• Consolidating buying power in order to better negotiate with suppliers and lower… Show more • Responsible for coordinating the receipt of the vast majority of inbound traffic at our 10,000 square meter 3PL warehouse.• Understand and react to the needs of our clients that come from a wide range of industries including; Airlines, Telecommunications, industrial machinery and wholesale food. • Organise personnel and assisting with training, whilst also compiling budgets and invoices.• Consolidating buying power in order to better negotiate with suppliers and lower overheads.• Ensure that received shipments have undergone the appropriate customs and quarantine checks and booking the appropriate treatment/inspections where necessary. • Monitoring deliveries, ensuring customer satisfaction and maintaining accurate logs of all transportation and goods.• Communicate effectively since the job primarily involves liaising with clients, couriers and other operational departments.• Continuing my education through the ascertainment of various industry certificates such as "Dangerous goods by sea - Awareness" & "RACA security essentials training"• Applying fundamental IT knowledge in order to maintain and expand the capabilities of hardware such as custom printer, bar-code scanners and making use of software macros. Show less

Unanderra