Robert Guare Email & Phone Number

Leicester, GB

Nottingham, England, United Kingdom

• Public sector engagement
• Data analysis to support multiple legacy systems to cloud migration
• Legacy system research to build source to target data mapping
• Data extraction
• Ad-hoc reporting

• Part of central team handling sensitive data for group wide commercial reporting
• Promoted MS Power BI to help modernise key reporting in British Gas
• Developed enterprise level business reporting using a variety of technologies including Power BI, SSAS and Excel Services
• Developed the first multi-dimensional data model to be used as the single source of reporting BG Business customer online activity which removed 6 separate business generated report
• Translated business requirements into viable MI reporting from defining specifications, to query writing, report building and publishing
• Produced range of artefacts including shaping / design, technical and logical models, data flows and release documentation

Leicester

• Analyst within commercial team, analysing performance and offering assessments for improvement to BG Management
• Delivered a new Customer Renewals Process, following the collapse our delivery partner resulting in a £900k increase in collected revenue
• Mapped key process changes to improve the Customer Journey
• Created and analysed large datasets to identify areas for improvement
• Acted as key liaison / escalation point between BG Sales, Operations & IS in resolution of system & operational issues

Leicester, England, United Kingdom

• Analyst within the product team, advised on the shaping, selling and delivery of the new BusinessCare commercial maintenance product
• Provided key input into the commercial agreement and product delivery with our delivery partner Connaught Compliance PLC
• Defined the necessary BG Sales system changes to implement an automated sales export / reporting process with Connaught Compliance PLC