Michael Roberts Email & Phone Number

Cannock, Gb

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 • 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 needed• Architect and build Reporting Data layer, for use in creating Power BI models, reports and datasets• Use of full stack (VS2017/2019) Show less

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 SSISConsultative approach to new MI projects to enable internal customers to obtain maximum results, offering alternative approaches to the… Show more 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 SSISConsultative approach to new MI projects to enable internal customers to obtain maximum results, offering alternative approaches to the current reporting structures.Dashboard and Balanced Scorecard reporting for Operations. This includes drill-down and drill-through reporting functionality with a rich User Interface showing various means of data analysis.Consolidation of multiple reporting mechanisms using SSRS into a single layered reporting platform, offering slices of information at different levels from the Board of Directors to Operational business as usual.Delivering accurate MI projects on time and budget within agreed target dates.Documentation of the data models, schema and data dictionary.Currently working towards Microsoft accreditation in SQL server and data warehousing. Show less

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 mechanisms.Building MI and operational analysis reports through SQL SSRS and SSIS.Building data warehouse solutions within Management… Show more 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 mechanisms.Building MI and operational analysis reports through SQL SSRS and SSIS.Building data warehouse solutions within Management StudioUsing Business Intelligence Development studio to analyse operational process flows, automate and schedule account level process movement through analysis.Process and workflow changes, trend and system analysis, predictive modelling using SPSS Clementine predictive software and in house data.To highlight trends which may adversely effect achievement of results, and to provide recommendations relating to the achievement of Service Level Agreements.Steering the project management to realise the vision outlined at an operational and predictive analytics level. Mentoring Team managers in the fundamentals of using predictive analytics as a tool for maximising cash collections. To strategically develop and oversee a series of processes to allow accurate and timely reporting of all aspects of Echo's Operational procedures.To operate, administer and enhance revenue collection systems and software so that all revenue strategies are processed accurately.Design and oversee testing of new processes. Write training documentation and be involved in rolling out training to staff. Show less

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 departments, team members and senior managers. Assistance in the strategic planning and implementation of debt collection… Show more 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 departments, team members and senior managers. Assistance in the strategic planning and implementation of debt collection and meeting the team objective to close the overall debt gap from customers that left the company with remaining debtFollowing audit processes to resolve complex mis-allocation of payments across accounts.Provide reporting for Team Managers for internal meetings.Provide extensive audits on payments across group and site accounts.Presentational meetings for Industrial and Commercial customers and for in-house forums. Collating information and reporting on aged debts. Show less

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.