Jonathan Staple Email & Phone Number

Croydon, England, United Kingdom

As a key analyst for Zotefoams, I specialise in database implementation and Power BI reporting, ensuring streamlined operations and informed decision-making. My responsibilities range from:- Leveraging SQL to extract data from Microsoft 365 and Dynamics CRM, maintaining accurate stock levels and integrating customer-related data.- Establishing and adhering to milestones to ensure timely delivery of project objectives, fostering efficiency and accountability.- Preparing… Show more As a key analyst for Zotefoams, I specialise in database implementation and Power BI reporting, ensuring streamlined operations and informed decision-making. My responsibilities range from:- Leveraging SQL to extract data from Microsoft 365 and Dynamics CRM, maintaining accurate stock levels and integrating customer-related data.- Establishing and adhering to milestones to ensure timely delivery of project objectives, fostering efficiency and accountability.- Preparing, structuring, and standardizing Excel files to optimize data entry processes and enhance data quality.- Designing dynamic Power BI dashboards with DAX measures to provide real-time insights into stock levels and other critical metrics.- Extracting data from diverse sources such as MS Excel, MS Project, and SharePoint for storage within SQL databases, ensuring comprehensive data analysis capabilities. Show less

- Managing daily forecast reports using excel to analyze and filter through large data and utilizingVLOOKUPS to present the sales forecast daily.- Presenting findings from forecasts and contributing information during meetings to see potential for growth.- Collaborating with other departments such as Finance, Marketing and design to gather data requirements and give analytical support.- Gathering Data from various sources such as Insights analyst and Powerbi to… Show more - Managing daily forecast reports using excel to analyze and filter through large data and utilizingVLOOKUPS to present the sales forecast daily.- Presenting findings from forecasts and contributing information during meetings to see potential for growth.- Collaborating with other departments such as Finance, Marketing and design to gather data requirements and give analytical support.- Gathering Data from various sources such as Insights analyst and Powerbi to present findings to linemanager and offer potential solutions.- Developing Power Bi dashboards daily to show sales and profit margins for each department within the company Show less

London, England, United Kingdom

In my internship role assisting with database implementation and design for various SMEs, I undertook the following tasks:Gathering Requirements: I collaborated closely with stakeholders to comprehensively understand project objectives and requirements, ensuring alignment with business needs.Database Design: Leveraging SQL expertise, I designed databases to optimize data gathering processes, ensuring efficient storage and retrieval of information while adhering to best… Show more In my internship role assisting with database implementation and design for various SMEs, I undertook the following tasks:Gathering Requirements: I collaborated closely with stakeholders to comprehensively understand project objectives and requirements, ensuring alignment with business needs.Database Design: Leveraging SQL expertise, I designed databases to optimize data gathering processes, ensuring efficient storage and retrieval of information while adhering to best practices.Data Cleansing: I conducted thorough data cleansing processes to enhance data quality, identifying and rectifying inconsistencies, errors, and duplication within the database.Data Transformations (Normalization): Utilizing normalization techniques, I transformed raw data into structured formats, ensuring data integrity and reducing redundancy to facilitate efficient data management.Developing Qlik Sense Dashboards: I created interactive and visually appealing Qlik Sense dashboards to present key metrics and insights derived from the database, catering to the needs of key stakeholders and facilitating data-driven decision-making. Show less

During my time at Total Energies, I was entrusted with the responsibility of analysing gas consumption data using SQL to ensure accurate billing for customers on a monthly basis. Here's a breakdown of my tasks:MySQL Database Querying: I proficiently utilized MySQL to query the database and extract pertinent customer information, ensuring accurate and efficient retrieval of data necessary for analysis.Excel Data Analysis: Leveraging Excel, I performed in-depth analysis of data… Show more During my time at Total Energies, I was entrusted with the responsibility of analysing gas consumption data using SQL to ensure accurate billing for customers on a monthly basis. Here's a breakdown of my tasks:MySQL Database Querying: I proficiently utilized MySQL to query the database and extract pertinent customer information, ensuring accurate and efficient retrieval of data necessary for analysis.Excel Data Analysis: Leveraging Excel, I performed in-depth analysis of data pulls, utilizing pivot tables and other functionalities to glean valuable insights quickly. This allowed for a comprehensive understanding of customer consumption patterns and billing accuracy.Power BI Report Development: I adeptly developed Power BI reports to visualize and display customer energy consumption trends over time. These reports provided key stakeholders with actionable insights into consumption patterns, enabling informed decision-making and strategic planning. Show less