Michael Roberts Email & Phone Number

Remote

Remote

Solihull

• Assist in build of data warehouse, including requirements gathering with business
• Use Microsoft stack to facilitate data warehouse build, predominantly SSIS as ETL tool and SSRS as reporting function
• Create internal processes within BI team for reporting structures, using SSRS as front end application
• Develop documentation and governance standards within team
• Work on various projects as both BA/project manager and developer
• Create and maintain SSAS cubes as… Show more

Sutton Coldfield

• Rebuild SSRS reports (Report builder 3.0)
• Build new internal processes for reporting procedures
• Use of full BI stack (2008R2/2012)

Bescot, Walsall

Manage, design, and deliver the data warehouse and marts for reporting and analytics using best practice and the strategic toolset.Use the Microsoft BI Stack to build, report and analyse data.Build and maintain front and back-end ETL solutions.Codd Data Modelling Third Normal Form.

Walsall, United Kingdom

• Assist in creating new processes and procedures within the team.
• Develop standards and controls across the full Microsoft stack.
• Manage 10+ developers.
• Project manage a project to decouple operational data from the data warehouse and rebuild the warehouse adhering to Kimball methodolgy

Assist in build of new Data Warehouse from disparate systems - source through to warehouse - using SSIS and SSMS. MDS creation and implementation for internal customer use and process maintenance.Design and implement automated SQL job structure to load daily data warehouse packages and procedures.Creation of Process adherence routines using.

Key process manager in the re-structure of the Revenue Management System and processes. Responsibilities lay in designing and subsequently managing all aspects of the project which relate to Collections. This involves managing the processes and teams as a whole, but also designing and implementing - down to the finest detail - the operational.

RWE NPower, Larch House KingswinfordManagement of Corporate accounts with ledgers in excess of £10 million per month.Producing detailed debt reports and presentations for Industrial and Commercial accounts and Purchasing Organisations.Identification of trends, fluctuations and forecasts through data analysis.Cross functional liaising amongst divisional.

Overseeing Contract Management process and analysisWeekly and Month end reconciliations, involving gross margin, accrued and deferred income, and sales projections.Purchase invoice reconciliation and Journal reconciliation, at month and year-end.

Completing VAT and Environment agency returns, maintaining fixed asset register and deal with fixed asset accounting and ensuring reconciliation of various control accounts including creditors and VAT. Overseeing purchase ledger and work of purchase ledger administrator. Overseeing payments of suppliers.Accruals, prepayments and reserves.