Andrew F. Email & Phone Number

Sydney, Nsw, Au

Sydney, New South Wales, Australia

Sydney

Sydney, Australia

Migrated replenishment production from simple estimation to a Triple Exponential Smoothing forecast, implemented in SQL for data warehousing, R for processing and Excel for presentation and reportingImproved DIFOT metrics across all channels for indent and replenishment product from ~78% to 94%Built the toolchain for business-wide production planning, including integration to existing ERP platformDocumented the Axapta sales process optimal UX model as part of an upgrade… Show more Migrated replenishment production from simple estimation to a Triple Exponential Smoothing forecast, implemented in SQL for data warehousing, R for processing and Excel for presentation and reportingImproved DIFOT metrics across all channels for indent and replenishment product from ~78% to 94%Built the toolchain for business-wide production planning, including integration to existing ERP platformDocumented the Axapta sales process optimal UX model as part of an upgrade project, including the natural links into production, reporting and finance Show less

Developed a data warehousing solution for the Trade channelProduced reporting around ANZ transfer pricing opportunities and competitor analysisEstablished a direct marketing system for the Trade channelPerformed scenario analysis on a rebate program to drive contributionEmployed web scraping of online retailers to build a comprehensive competitor price databaseSupplied analysis of enterprise systems capabilities and their applicability to various segments of… Show more Developed a data warehousing solution for the Trade channelProduced reporting around ANZ transfer pricing opportunities and competitor analysisEstablished a direct marketing system for the Trade channelPerformed scenario analysis on a rebate program to drive contributionEmployed web scraping of online retailers to build a comprehensive competitor price databaseSupplied analysis of enterprise systems capabilities and their applicability to various segments of the firm Show less

Highly varied role with a primary focus on operationsConsolidated and cleansed customer records and migrated the business to CapsuleCRMBuilt direct marketing systems with MailChimp including design, copy, analysis and promotionsInitiated social media programs using Facebook, LinkedIn and TwitterProvided customer support resolution for escalated issuesAssisted with IT solutions and administration

Development, testing and defect resolution of a trade promotion planning and forecasting toolUtilised T-SQL and related SQL Server technologies to produce client integration solutions as well as cross-client enhancementsProduced code for a user interface developed in Java including data visualisation elementsGenerated reports for the web in Reporting Services and for Excel through Analysis ServicesLiaised closely with clients to produce specification documents… Show more Development, testing and defect resolution of a trade promotion planning and forecasting toolUtilised T-SQL and related SQL Server technologies to produce client integration solutions as well as cross-client enhancementsProduced code for a user interface developed in Java including data visualisation elementsGenerated reports for the web in Reporting Services and for Excel through Analysis ServicesLiaised closely with clients to produce specification documents, user documentation, reporting tools and for resolution of any system issues encountered during deployment or general use Show less

Re-factored the firm’s costing model with a simplified activity-based costing approach, permitting greater operational and marketing efforts to be directed at value generating productsManaged the implementation of a transactional integration between the accounting and inventory control systems and equivalent systems in the 3PL warehouseDeveloped and implemented a cycle-count programme and ABC analysisEnhanced sales modelling to better understand the differences between… Show more Re-factored the firm’s costing model with a simplified activity-based costing approach, permitting greater operational and marketing efforts to be directed at value generating productsManaged the implementation of a transactional integration between the accounting and inventory control systems and equivalent systems in the 3PL warehouseDeveloped and implemented a cycle-count programme and ABC analysisEnhanced sales modelling to better understand the differences between sales channels and the influence of seasonal cycles Show less

Maintained and further developed sales reporting tools to monitor performance across three channels, numerous customers and several thousand line items to support decision makingProduced forecasts and other modelling to determine inventory levels and order generation then liaised with more than twenty suppliers and other partners to improve supply chain efficiency

M.Comm., Funds Management

B.Sc., Computer Science & Mathematics

Hsc, Mathematics, Computing Studies, Business Studies; English