Create Your First Project

Start adding your projects to your portfolio. Click on "Manage Projects" to get started

.pro-gallery-wix-wrapper {display: block !important;} .pro-gallery-wix-wrapper .gallery-item-container {opacity: 1 !important; display: block !important;}

Automating Group Finance Month End Reporting

Project type

Data and Analytics

Date

2018 - 2019

Client

Scottish distiller & retailer with circa £1bn p.a. turnover

Role

Analysis and Requirements Lead

Automating Group Finance Reporting by ingesting multiple ERP systems data in to to a MS Sql Server data warehouse. Merging, transforming, standardising to common chart of accounts with data aggregation using SSIS with auto scheduling of report pack to users inboxes at each month end. This had been a manual labour intensive and time pressured process each month end using a plethora of spreadsheets to knit the data together and produce the report pack.