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 database and transforming using SSIS with auto scheduling of report pack to users inboxes at each month end. This had been a manual labour intensive process using spreadsheets to knit the data together.