Summary
Overview
Work History
Education
Skills
Certification
Timeline
BusinessAnalyst
Peter  Hills

Peter Hills

Business Intelligence Analyst - Power BI
Burwash,East Sussex

Summary

A seasoned data analyst and automation specialist with a track record of over six years in delivering data-driven solutions and insights to meet diverse business needs. My expertise encompasses a wide range of data-related tools and platforms, making me a versatile asset to any organization. With a strong background in data modeling, data visualization, and automation, coupled with specialized knowledge in finance-related data analysis, I bring a holistic approach to driving business success through data-driven decision-making.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Business Intelligence Analyst

HPS Civils Limited
Crowborough
09.2015 - 05.2023

Financial Responsibilities and Expertise:
Preparation of Management Accounts and Financial Reporting:

  • Proficient in preparation of comprehensive management accounts, providing senior management with crucial insights into financial performance.
  • Regularly generated detailed reports on profit and loss statements and balance sheets, facilitating informed decision-making.
  • Produced regular reports on cashflows and conducted cashflow forecasting, ensuring effective cash management and financial stability.
  • Demonstrated expertise in integrating accounting packages with databases, streamlining financial data management and reporting processes.
  • Ensured accurate and real-time financial data flow between systems, enhancing data accuracy and reducing manual efforts.
  • Responsible for delivering monthly project and company performance reports to management teams. These reports included key financial metrics, enabling data-driven decisions for ongoing projects and overall company strategy.
  • Created self-service reporting functionality for senior management for the complete dataset.

Professional Achievements and Wider Expertise:
Automated Material and Plant Buying Solution (25% Reduction in Time to Site):

  • Successfully created an automated material and plant buying solution by collaborating with staff members and suppliers.
  • Resulted in 50% reduction in order workloads, significantly enhancing efficiency.
  • Reduced time to site by an impressive 25%, improving project timelines and productivity.

Real-Time Spend Forecasting (5% Cost Savings)

  • Leveraged live data to provide real-time spend forecasting to senior management.
  • Eliminated credit limit overspend, resulting in cost savings of up to 5%.

Data Modeling and DAX Optimization (30% Reduction in Refresh Times):

  • Developed and optimized an efficient data model, improving data refresh times by 30%.
  • Utilized best practice coding and DAX calculations to enhance data processing.

Process Automation (30-40 Hours Monthly Savings per Employee):

  • Implemented and maintained automated processes, including email communications, file and photo transfers, and data synchronization.
  • Achieved significant time savings of 30-40 hours per month per employee.

Slack Integration for Time Savings (Up to 50%):

  • Set up and maintained Slack app across the organization for internal communications.
  • Integrated automated processes to routinely transfer data, resulting in site and admin time savings of up to 50%.

Collaborative Development and Training:

  • Collaborated closely with staff members throughout development and User Acceptance Testing (UAT) phases for new data processes, automation tools, and visualizations.
  • Provided necessary training and support to ensure successful implementation and adoption.

Professional Gardener

National Trust And Private Estates
Oxford
04.2013 - 08.2015

Successfully maintained and improved the gardens of both National Trust property, Greys Court, Henley, and Coppid Hall private estate in Oxfordshire.

Demonstrated expertise in horticultural practices, including plant propagation, training, pruning and tree care for a variety of fruit trees, roses and other ornamental plants.

Effectively managed maintenance of herbaceous borders, ornamental and exotic gardens resulting in consistent high-quality appearance of these areas.

Trainee Surveyor

Adkin Rural & Agricultural
Oxford
02.2010 - 09.2012

Worked closely with rural landowning clients to manage their properties and farmland effectively.

Successfully carried out residential and commercial lettings, and management, resulting in increased revenue for the clients

Assisted with estate valuations accurately and efficiently, contributing significantly to the decision-making process of clients

Helped develop natural environment management plans that helped improve biodiversity and sustainability on client's land

Efficiently handled Single Farm Payment subsidy applications, ensuring maximum returns for clients while adhering strictly to legal guidelines.

Education

Bachelor of Science - Real Estate Management

Oxford Brookes
Oxford
09.2006 - 2009.09

Skills

    Microsoft Power BI

undefined

Certification

Microsoft Power BI Analyst Associate - PL300

Timeline

Microsoft Power BI Analyst Associate - PL300

08-2023

Business Intelligence Analyst

HPS Civils Limited
09.2015 - 05.2023

Professional Gardener

National Trust And Private Estates
04.2013 - 08.2015

Trainee Surveyor

Adkin Rural & Agricultural
02.2010 - 09.2012

Bachelor of Science - Real Estate Management

Oxford Brookes
09.2006 - 2009.09
Peter HillsBusiness Intelligence Analyst - Power BI