Pawanjit Rana
Leicester
Summary
Energy specialist with expertise in analytical and technical skills, focused on evaluating energy performance and identifying efficiency improvements through data-driven insights. Proficient in analyzing large datasets and developing interactive dashboards using Tableau and Microsoft Excel to track energy consumption trends and inform strategic decisions. Experienced in data analysis, reporting, and visualization, translating complex energy data into actionable recommendations that enhance operational efficiency and sustainability. Combines knowledge of energy management with IT tools and analytical techniques to optimize performance and support data-driven energy solutions.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
Work history
Energy consultant
Eon Next
Leicester
2023.11 - Current
- Provided expert advice on latest renewable technologies for enhanced sustainability.
- Worked closely with various stakeholders; fostered a culture prioritising sustainability.
- Analyzed large energy consumption datasets using Tableau and Microsoft Excel to identify inefficiencies and recommend cost-saving energy strategies.
- Utilized SQL queries to retrieve and structure energy consumption data from internal databases for deeper analytical evaluation.
- Produced technical reports and dashboards translating complex analytical results into clear insights for non-technical stakeholders and management.
- Led smart meter focal team with precise objectives and deadlines for RTS customers, which included objective handling and pulling data of all customers with RTS meters and actively converting them to Smart.
- Performed statistical analysis on utility and operational datasets to detect anomalies, energy wastage patterns, and opportunities for sustainability improvements.
- First line of customer support answering and dealing with customer queries from booking appointments, configurating smart, ability to pay conversation and sales by using kraken system.
- Built interactive dashboards in Tableau to visualize energy usage trends, enabling stakeholders to monitor performance and support data-driven decision-making.
Retail assistant
TK Maxx
Leicester
2022.10 - 2023.01
- Maintained clean shop floor, promoting a welcoming environment.
- Delivered excellent customer service by answering queries and providing product information.
- Participated in seasonal sale preparations by arranging promotional displays strategically.
- Assisted in stock replenishment to maintain store appearance.
- Monitored stock levels and updated inventory data using Microsoft Excel, helping maintain accurate product availability reports.
- Analyzed daily sales data and created simple reports in Microsoft Excel to identify high-performing products and peak sales periods.
- Used digital customer databases and Customer Relationship Management (CRM) systems to record customer feedback and support targeted promotions.
- Used barcode scanning and digital inventory tools to streamline data entry processes and improve the efficiency of stock management systems.
Education
Bachelor of Science - Cyber Security
De Montfort University
Leicester 2020.09 - 2023.09
A-Levels - Business studies, IT, Geography
The City Of Leicester College
Leicester 2018.09 - 2020.09
Skills
- Data Analysis & Visualisation: Microsoft Excel, Tableau, data reporting
- Database management and data modelling
- Agile teamwork and collaboration
- Time management and project planning
- Data visualisation and dashboard creation
- Basic statistical analysis
- Customer Service Satisfactory
- Independent critical Thinking
Languages
English
Native
Punjabi
Fluent
Hindi
Intermediate
References
References available upon request.
Timeline
Energy consultant
Eon Next
2023.11 - Current
Retail assistant
TK Maxx
2022.10 - 2023.01
Bachelor of Science - Cyber Security
De Montfort University
2020.09 - 2023.09
A-Levels - Business studies, IT, Geography
The City Of Leicester College
2018.09 - 2020.09