Apr 2023 – Jun 2023 · 2 mos · Nelson, England, United Kingdom · Hybrid

Sep 2021 – Apr 2023 · 1 yr 7 mos · Nelson, England, United Kingdom · Hybrid

• Key Results:
• Live Energy Dashboards/Reports Development and Maintenance.
• Integrated data from diverse sources including CSV files, Excel spreadsheets, SQL Server databases, web services, and SharePoint.
• Sub-Metering Data Analysis
• Conducted detailed analysis on extensive volumes of sub-metering data with granularity as fine as five seconds.
• Managed data for various utilities such as electricity, gas, water, and effluents.
• Statistical and Predictive Modelling
• Performed modelling and multilinear regression analysis to understand and predict energy consumption patterns.
• Service Delivery Tracking
• Designed and implemented an Excel-based tracking system to monitor the delivery of key services provided by the Energy Management Team.
• Climate Change Agreement Management
• Managed compliance and reporting related to Climate Change Agreements (CCAs).
• SECR Reporting
• Energy Sensors Stock Management
• Oversaw the inventory and management of energy sensors.
• Process Automation Involvement
• Participated in the automation of various energy management processes to enhance efficiency and accuracy.

Jan 2022 – Present · 4 yrs 4 mos · Remote

• Developed interactive Power BI reports for clients via freelancing platforms such as ComeUp, delivering actionable insights and automated dashboards.
• Designed and implemented a Stock and Inventory Dashboard for a local health store, streamlining inventory tracking and reporting processes over several weeks.
• Built full BI solutions for small businesses and personal projects, including data modeling, dashboards, ETL pipelines, and analytics workflows using Power BI, DAX, Power Query, SQL, and Excel.

Mar 2019 – Aug 2020 · 1 yr 5 mos · Dieppe, Haute-Normandie, France · On-site

• Key results:
• Membership of 25 towns representing a total population of around 30,000 inhabitants.
• Energy and carbon assessments of 103 buildings of different types (Townhall,
• gymnasium, library, schools, …) representing a total floor surface of 22,300 sqm.
• Collect, analysis and management of 3 651 MWh of primary energy consumption data in
• total for the buildings. Various fluids managed (electricity, propane, natural gas,
• domestic fuel, wood).
• Collect, analysis and management of water consumption data.
• Collect, analysis and management of 1,672 MWh of primary energy consumption data for public lighting.
• Technical and structural solution recommendations to save around 44 000 € per year in total.
• Oral presentations and environmental awareness during several meetings (one of which
• with over 30 mayors).
• Analytic and reporting tools used: Excel and power BI

Mar 2018 – Dec 2018 · 9 mos · Région de Boulogne-Billancourt, France

• Assisting experimented consultants on certification “BREEAM in Use” and “HQE
• Exploitation”. Two labels assessing the environmental efficiency of buildings in operation. More than 10 sites assessed (essentially shopping centres)
• Conducting various technical studies such as lifecycle analysis, luminous pollution,
• carbon footprint calculation,...
• Assessing Heat loss for 3 office buildings thanks to the software Climawin.
• Creating tools on Microsoft Excel to ease the assessment of assets according to two
• French labels: OsmoZ and R2S.

Jul 2017 – Aug 2017 · 1 mo · Région de Montreuil, France

• Internship alongside engineering consultants. Creation of a technical library of HVAC solutions with excel.