jlbillyf

Developed and supported category growth strategies to improve profitability, drive sales, and optimize inventory levels. Partnered with NAMs to identify data-driven opportunities for growth and operational efficiency. Designed, maintained, and enhanced analytics dashboards and performance reports in Power BI and Excel to track key metrics and KPIs. Optimized demand forecasting models in higher accuracy, adjusting for missed SKUs and aligning with sales inputs. Prepared monthly demand review and Monthly Business Review preparation including product category mix and sales trend analysis. Supported national sales teams with customer insights, promotional analysis, and inventory planning recommendations. Conducted market research and competitive analysis using IRI, Quantium data to inform marketing and product strategies. Regularly monitored key retail metrics: weeks of cover, customer stock-on-hand, ROI, trade spend, and rebate utilization. Translated business requirements into accurate and interactive data visualization and analytics. Collaborated with IT teams on systems consolidation, data integration, and data pipeline development. Designed and Developed ETL/ELT. Automated data extraction process from large amounts of trade spends documents. Transformed raw sales, inventory, marketing and supply chain data into usable formats. Designed and build the efficient data models using DAX and power query. Ensured performance and security of data connection into Azure, snowflake database and various of SQL databases and ODATA. Delivery adaptive role-based trainings and smoothen the impact of new report onboardings. Gathering feedback to continuously improve PBI reports.

Business partnering & Reporting. Partnered with managers and department heads to align financial strategies with business goals. Conducted weekly performance reviews and provided variance analysis. Updated live maps for daily production plans and divisional timesheets. Delivered insightful analysis and recommendations for decision support. Participated in R&D activities and calculated expenditures. Managed RCTI to ensure accurate supplier payments. Supported internal safety committee with incident summaries. Finance management & Tax. Monitored daily cashflow for group businesses. Maintained fixed asset register and monthly depreciation templates. Managed month-end processes and general ledger accounts. Prepared and lodged monthly group BAS and IAS. Supervised Accounts Assistant to ensure completion of AR and AP activities. Data Modelling, Systems and Process improvement. Maintained GL mapping and connections for multiple databases. Designed and built divisional production costing models. Developed financial models, sales forecasts, and budgets. Improved purchase order and billing processes, reducing errors by 30% and processing time by 40%. Optimized inventory systems, creating functional dashboards for the sales team. Revised maintenance schedule reports to ensure compliance with safety regulations.

Prepared and analyzed financial statements using Power BI. Oversee the month-end and year-end closing processes including accounts reconciliation and journal entries. Communicated complex financial ideas and findings to non-financial background stakeholders. Collaborated with cross-functional teams to create budgets and forecasts and monitored actual performance against budgeted figures and provided variance analysis. Conducted financial analysis to identify trends, opportunities, and risks and Made recommendations for improving financial performance and cost control. Contributed to development of financial planning and assessed the financial impact of business decisions. Participated in special financial projects such as system implementations, process improvement and sales projections. Leveraged technology to streamline financial processes and automate reporting, resulting in a 70% reduction in processing time. Prepared and filed tax returns accurately and on time across different countries, including AU, NZ, UK, and the US.

Directed finance, analysis, accounting operations for 20M annual turnover business. Managed EMDG scheme and claimed over $150K rebates for business cost reduction. Maintained financial records including AP, AR, general ledger entries and reconciliations. Processed inventory management for over 1000 SKUs in ERP system. Liaised with bank manager for updates of assets records and trade finance planning. Prepared and analyzed financial statements and KPIs to identify trends, variances, and area of improvements. Conducted regular internal audits and procedures development to enhance internal controls. Lodged BAS, IAS, FBT, and company tax returns. Provided support to ATO Audits by preparing necessary documentation and responding to auditor inquiries. Processed database backups to secure financial information. Maintained financial databases, the accounting system and internal control system. Provided ad hoc support to team.