Joshua Smith Email & Phone Number

England, United Kingdom

Assist in a project to transition the year end date from March to September in the reporting system Cognos ControllerAutomate and add control to various processes through the creation of workflows within SharepointWork with Microsoft Power BI to produce reports and dashboards which have been requested by the businessAssist in leading and implementing a Global Data Integration project, consolidating sales data from over 90 different databases.Lead a business wide Data Literacy programmeSuccessful delivery of the first cross divisional Power BI dashboard, including the lead of the project, dealing with stakeholders, communicating and delivering.Valuable experience in project management, change management and further experience in communication to stakeholders

Transition current reports structure to a new divisional structure.Develop reports to analyse ‘true cost’ of specific areas – Freight, Production, Polymer.Costing exercise to calculate new standard cost build-up of all products.Automate current ways of working through Process improvement, report generation and information processingTransition item selling price function from Sales to Finance.Assist in the different stages of the reporting cycle. Budget, Forecast, Month end reporting.Successful implementation of a cross functional project transitioning the selling pricing function from Sales to FinanceAutomated multiple processes which significantly improved the time taken to deliver specific reportsCalculation of the new standard cost of all items of the site. Was able to implement first hand costing techniques gained from CIMA Studies.

Supported in the transition from one tax reporting system to another (Cognos – CCH) which included; mass cleanse and migration of all key data, and major data manipulation for both testing and reporting processes.Aid in the year end external reporting; calculating the Corporation Tax and Deferred Tax liabilities, and providing cash tax analysis.Process improvement in specified areas to improve accuracy and insight.Improved and simplified the ‘Tax Model’ used to calculate the CT and DT Liabilities of a £3.7bn company.Created a model used to accurately analyse the prior year adjustment required for all material sites using a balance sheet approach.Took the lead in crucial strategic meetings with external parties whilst liaising with key stakeholders.investigating figures to ensure accuracy and completeness.Take certain areas of reporting and improve the accuracy, process and insight of those areas. Specific areas to cover include Water and Electricity which collates data from over 220 sites

Supported the Group Finance monthly reporting cycle and helped to produce the Monthly internal reports used by management for strategic decisions.Assisted in the production of both internal and external year end and half year reports specifically investigating figures to ensure accuracy and completeness.Take certain areas of reporting and improve the accuracy, process and insight of those areas. Specific areas to cover include Water and Electricity which collates data from over 220 sites

Testing Manager for NAV implementation: Maintaining log of all User Acceptance Testing (UAT) scripts, results and issues raised. Responsible for supporting non-finance user testing by documenting & checking accounting results from their tests.Report Development, taking certain areas of reporting and improve the accuracy, process and insight of those areas. Report Creation, building dynamic informative reports from scratchData migration and reconciliation between Navision and SageDocumentation: process notes and user guidesCreation of multiple informative management reports including a Mass Balance and Sales ForecastUnderstand the recycling side of the Berry business. The model, processes and how it differs from a standard production siteExperience in a new ERP system, project management and team communications.Gained understanding of process flow of recycling site and interconnection with ERP, underpinned by importance of accurate and timely data.

Supported in the transition from one ERP system to another (Triton – Microsoft AX) which included; mass cleanse and migration of all key data, mapping of journal posting profiles, calculation of more accurate cost prices, and setup and testing of all fundamental processes within the system.Aid in the daily and monthly reporting requirements of the site. Monthly interest calculation of intercompany loans in addition to investigating unsolved intercompany differences.Gained understanding of process flow of manufacturing site and interconnection with ERP, underpinned by importance of accurate and timely data.Experience in a new ERP system, project management and team communications

Chartered Institute Of Management Accounting, Accounting And Business/Management

Education record

Bachelor Of Arts (Ba), Accounting And Finance, 2.1

Activities and Societies: NTU Lacrosse Vice President of Events, Captain