Ben Jolly Email & Phone Number

Greater London, England, United Kingdom

Newcastle-Upon-Tyne, England, United Kingdom

Data Platform lead for the rollout of Procurement, Supply Chain Long-Term Planning, and Forecast and Replenishment projects, facilitating the generation of business analytical insights in Azure for presentation in Power BI.Key highlights of my personal contributions and responsibilities include:• Gathering 900+ requirements from business stakeholders.• Thorough research and investigation to identify tables and fields from sources including SAP, Ariba, Sharepoint and Azure Cosmos DB. Solutions architected to seamlessly integrate with existing infrastructure without compromising functionality.• Intricate configuration of 75+ APIs to extract and process data from Ariba.• Designed and developed 65+ Azure Data Factory (ADF) pipelines alongside the enhancement of an additional 110+. • Devised a sophisticated ADF trigger network, leveraging pipeline dependencies to optimize overnight job runtime while preventing overload on compute resource.• 135+ PR merges to the Master branch.• Supported Greggs’ Azure CSP migration from Avanade to a self-managed infrastructure by harnessing the capabilities of Terraform.• Instrumented improved agile methodologies and redesigned the scrum framework to enhance work productivity and efficiency across all Data streams.• Training and leadership to team members and colleagues, including work assignment, demonstration of processes, standardising best practices, reviewing work and availability for guidance and questions.

Newcastle Upon Tyne, England, United Kingdom

Through this role I have gained proficiency in data lakehouse architecture and Azure data-warehousing, utilizing skills in T-SQL, ETL, Python, Apache Spark, Databricks and key Azure services including Azure Data Factory, Azure Logic Apps, Azure Data Lake Storage (ADLS) Gen 2 and Azure SQL Database.I have gained experienced in Agile methodologies with a DevOps CI/CD mindset, incorporating Git integration and orchestrating end-to-end build and deployment processes for BI systems across multiple environments.Additional responsibilities and contributions include:• Leveraged linked service connections to access and copy source data. Medallion architecture data lakehouse design utilizing Databricks and ADLS Gen2 for cleaning, conforming and preparing data. Seamless data surfacing to Azure SQL Database for business consumption and Power BI reporting.• Application of Kimball methodology and dimension modelling to design and implement robust Fact and Dimension tables.• Weekly deployments to the Develop and Test environment alongside pre and post-deployment scripts.• Co-ownership of monthly UAT and Production releases.• Weekly pull request (PR) review of colleagues' work before committing changes to Develop.• Investigating and resolving Test and UAT ADF pipeline failures.• Business as usual (BAU) tasks involving investigation of stakeholder queries, missing and incorrect data.• Out of hours (OOH) support to address real time Production failures and implement fixes to minimise business downtime.• Infrastructure enhancements to improve performance, efficiency, and execution speeds.• Exhaustive testing in collaboration with Basis Team to ensure optimal performance of ADF copy activities, avoiding memory constraints for daily jobs and historical loads.• Extensive debugging and testing with Test and Power BI teams to ensure data validity and stakeholder satisfaction.• Technical support for testers and business analysts.

Salford, England, United Kingdom

𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀:1. Designed a load balanced and auto scalable track and trace web app built using HTML, CSS and Java Script hosted using Flask on an EC2 instance. Designed to allow sport coordinators to track of COVID-19 outbreaks within teams.2. Modelled and expensed architecture for a multinational private medical company to securely upload their patient database to AWS. Provisioned additional features such as SES and SMS notifications to allow patients to book appointments and strategized options to migrate select objects to Azure or Google Cloud where required.3. Derived and implemented a machine learning algorithm to a predictive maintenance use case which generated regular signals about equipment condition and health to predict the need for maintenance or not. 𝗪𝗼𝗿𝗸 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲:- Live industry experience focused on the connection of factory floor sensor networks to AWS Cloud infrastructure- Selection, purchase and implementation of £6,000 of hardware to realize business insight, efficiency improvements, and business gains.- Development of cost-efficient architecture to store and display sensor data and set the foundation for predictive maintenance and object detection systems.

Windermere, England, United Kingdom

Produced a comprehensive preliminary economic and feasibility study for the use of tethered gas balloons in an outdoor pursuit’s environment.

Lancaster, United Kingdom

𝗥𝗼𝗹𝗲𝘀 𝗜𝗻𝗰𝗹𝘂𝗱𝗲:- Regulating the club's daily activities - Responsibility for the development and growth of the club, attracting new members by founding new teams to increase competitiveness and reward commitment- Securing a world class coach to improve club development- Overseeing payment for coaching, membership fees, travel arrangements & development funding- Negotiating sponsorships with local pubs and businesses to provide post-match dinners and provide current and future financial support for the club- Management of entry into North West Counties Squash regional leagues- Organising the purchase of club apparel- Charity fundraising through events management𝗘𝗻𝗱 𝗼𝗳 𝘁𝗲𝗻𝘂𝗿𝗲 𝗿𝗲𝘀𝘂𝗹𝘁𝘀:- Secured sponsorship with FGH Security, Mint Lancaster, Live Suite Media and Sultans of Lancaster, and kit production deals with EV2 Sportswear and AWsme Sports- Three teams won their respective leagues in the 2019-20 season- Full membership intake increased from 50 to 82 in 15 months and the bank account realized a £500 profit by June 2020- Amassed 36 recreational members by April 2020, five of whom progressed to join the university squads

Lancaster, United Kingdom

𝗥𝗼𝗹𝗲𝘀 𝗜𝗻𝗰𝗹𝘂𝗱𝗲:- Organising day events to professional PSA tournaments and National Squash Centre trips- Coaching for casual players and those with a goal to progress to competitive squash - Coordinating weekly social events - Arranging the logistics and finances for post-match meals

Lancaster, United Kingdom

Tasked with the design and retrofitting of existing aeration cascades to create optimal conditions for both the oxidation of ferrous iron and CO2 release in mine water.

Master Of Engineering - Meng, Chemical Engineering, First Class

A-Levels, Mathematics Geography Physics And French