Regulatory reporting and back office functions at a banking client.

Solely responsible for MIS reporting, presenting to all levels of the business. Adhoc reporting and the daily report. Developed views and marts on the data warehouse (T-SQL). Data mining and reporting using SSRS and SSAS. Developed business applications using VBA in Excel and Access. Analysed data in response to requests from the marketing department for information regarding their email and DM campaigns.Turned a 24 man hour weekly sample labelling process… Show more Solely responsible for MIS reporting, presenting to all levels of the business. Adhoc reporting and the daily report. Developed views and marts on the data warehouse (T-SQL). Data mining and reporting using SSRS and SSAS. Developed business applications using VBA in Excel and Access. Analysed data in response to requests from the marketing department for information regarding their email and DM campaigns.Turned a 24 man hour weekly sample labelling process in to a 4 hour process by developing a data driven Access VBA application running queries on the data warehouse and printing labels on a label printer. Drove profit by calculating new demand planning rates of sale, as a query on the data warehouse, input to a spreadsheet with stock levels and output to SAP.Other: some queries in Cognos TM1. Show less