Embedded Files
I.T. and Business Process Areas of Expertise
Michael is a very experienced project manager, implementer and tester for financial software and manufacturing, logistics, sales and plannng software containing finance relevant data, in both large and small company environments, including:
Business Transformation:
Strategy and business improvement ideas
Finance and business transformation
Financial Systems Design and Architecting:
Legal entities, Profit Centre divisions, Cost Centres
GL Chart of Accounts
Inventory Valuation
Standard and current costing
Sales and profitability planning
Forecasting using predictive analytics & AI
Software Packages:
SAP & SAP Business Warehouse
Microsoft Dynamics 365
Microsoft Office, especially Excel including VBA
Microsoft Power BI including DAX, M Lanaguage
Xero
Group reporting including data drawn from multiple disparate systems (see example below)
In an ideal World, whether a business is big or small, it is best to have all financial, logistics, sales, production and engineering systems on the same large Enterprise Resource System supported by the associated Business Warehouse and Reporting suite
However, most businesses through organic and inorganic growth end up with multiple disparate systems
Michael has extensive experience in drawing together finance data extracted from these differenct data sources to report consolidated financial results assigned to legal entities and divisional profit centres
For Sales and Margin reporting, data extracted from multiple sources into a data lake or warehouse is used to dissect detailed pricing and discounts and detailed product costs in order to "sliced and dice" by product, customer and geography
Sales and Margin projects completed have involved SAP CO-PA module and SAP BW along with extra detail extracted from non SAP data sources (e.g. for freight and other unassigned cost of sales) to enrich the data and provide extra insights for reporting
Relevant Experience
Page updated
Google Sites
Report abuse