Clement Villalard

Business Development Executive

United Kingdom6 yrs 1 mo experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Over five years of experience in BI and data analysis.
  • Expertise in developing interactive dashboards using Power BI.
  • Proven track record in energy management and efficiency.
Stackforce AI infers this person is a Business Intelligence Developer specializing in Energy Management and Data Analysis.

Contact

Skills

Core Skills

Business Intelligence (bi)Data AnalysisEnergy ManagementEnvironmental Consulting

Other Skills

Power BIMicrosoft FabricPythonExcelSQLData VisualizationETLData ModelingEnergy EfficiencyMicrosoft Power BIProject ManagementMicrosoft ExcelBREEAMData ScienceStatistics

About

🇬🇧 Welcome to my English profile. Pour consulter mon profil en français, vous pouvez changer la langue du profil dans la section en haut à droite. I’m a Business Intelligence Developer and Data Analyst with over five years experience turning data into actionable insights through automated dashboards and reporting solutions. I help organisations harness data to shape strategy, improve performance, and enable smarter decision-making. I specialise in developing interactive, user-friendly dashboards in Power BI, with expertise across Power Query, data modelling, DAX, visualisation, distribution, and access management. I am experienced in connecting Power BI to a wide range of data sources, including SQL Server, APIs, third-party platforms, SharePoint, and Excel. In addition to dashboard development, I provide tailored analysis and streamline complex processes by automating workflows with SQL, Python, Excel and Microsoft Fabric. Alongside my full-time role, I’m open to selective freelance or contract BI projects that align with my expertise. Contact Details: ☎ +44 7857923055 ✉ clement_villalard@outlook.com

Experience

6 yrs 1 mo
Total Experience
2 yrs 7 mos
Average Tenure
4 yrs 4 mos
Current Experience

Sustainable energy first

Business Intelligence Developer

Jun 2023 – Present · 2 yrs 11 mos · Remote

  • Developing, distributing, and maintaining bespoke Energy Management Dashboards/Reports for customers using Power BI.
  • Developing internal reports that drive efficiency with Power BI.
  • Multilinear Regression Analysis with Excel or Power BI.
  • Automating time-consuming and repetitive tasks using Python and Excel.
  • Ad-hoc Data Analysis
  • Tools used on a daily basis: Power BI, Microsoft Fabric, Python, Excel, SQL
Power BIMicrosoft FabricPythonExcelSQLBusiness Intelligence (BI)+1

Businesswise solutions

2 roles

Senior Data Analyst

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

Power BIData AnalysisETLSQLBusiness Intelligence (BI)

Data Analyst

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.
Power BIData AnalysisETLSQLBusiness Intelligence (BI)

Freelance

Business Intelligence Developer and Consultant

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.
Power BIData AnalysisETLBusiness Intelligence (BI)

PĂ´le d'equilibre territorial et rural (petr) dieppe pays normand

Energy Consultant

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
Energy EfficiencyData AnalysisMicrosoft Power BIProject ManagementEnergy Management

Greenaffair

Jr. Environmental efficiency consultant

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.
BREEAMData AnalysisMicrosoft ExcelEnvironmental Consulting

Inex bet

Internship: HVAC engineer

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.
Microsoft Excel

Education

ESAIP, École Supérieure Angevine en Informatique et Productique

Master degree in health

Jan 2015 – Jan 2018

Hochschule Heilbronn - Hochschule fĂźr Technik, Wirtschaft und Informatik

ERASMUS Study period — Environmental technology

Jan 2017 – Jan 2017

VILNIUS TECH - Vilnius Gediminas Technical University

ERASMUS Study period — Management and Physics

Jan 2016 – Jan 2016

LycĂŠe Malherbe

Preparatory classes for the grandes ĂŠcoles (CPGE)

Jan 2013 – Jan 2015

Stackforce found 2 more professionals with Business Intelligence (bi) & Data Analysis

Explore similar profiles based on matching skills and experience