Home Blog About
Avatar



Will Otty | Software Developer at FDM.

Will is a graduate of the University of Warwick with a degree in Engineering Business Management. He has experience in the finance and technology sector, having worked as an auditor at PwC and a data analyst at Vodafone. During University, he learned to code using MATLAB, C, Java and Python. While auditing digital technologies at large financial institutions, Will's attention to detail was critical to him carrying out his daily tasks. At all times, he had to maintain high-quality work often to very tight deadlines. In addition, Will managed his time alongside studying towards the ACA qualification, having passed 3 exams while at the firm. As part of an extracurricular student project, Will managed the finances for a team of 40 students. He organised a group of 10 people to create and lead engaging pitches for investors. It was essential for Will to organise colleagues, collate ideas and resources effectively to ensure investment was secured. His team generated over £50,000 in investment. Will would like to work within the technology industry where he can apply his skills.


Projects

Building A Website

Burger

Learning Java

Burger

Building An Electric Skateboard

Burger

CV

Python Developer | HSBC | 06/2022 - 09/2022
Will utilised python to ingest and manipulate data for internal audit dashboards.
  • Automation Development: Provided code to automate the production of Qlik Sense dashboards using Python.
  • Manual Testing: Verified quality of data sources of Qlik Sense dashboards using SQL.
  • Database Development: Scripted SQL code to manipulate and load data into SQL from CSVs.
  • Dashboard Creation: Created Qlik Sense dashboards to aid audit analytics.

Data Engineer | Lloyds of London | 02/2022 - 03/2022
Will worked on porting legacy systems over to a data lake.
  • Checked reconciliations of data from ingested data match data lake.
  • Utilised Databricks to transform data to a standardised format for business intelligence.

Software Development Training | FDM Academy | 06/2021 - 02/2022
Will learnt fundementals of software development and data engineering to become industry ready.
  • Java Application Development
  • Object-Oriented Programming
  • Python Fundamentals
  • Relational Databases
  • Data Visualisation Foundation
  • Excel and VBA
  • Professional Skills

Will has worked for PwC providing excellent assurance for FTSE 100 companies.
  • Managed time effectively which enabled him to learn ACA qualification, passing 3 exams covering accounting, technology, and assurance in his spare time.
  • Diligently audited cash accounts assuring business operation.
  • Liaised with clients to ensure work was done to a satisfactory degree.
  • Gathered evidence to support assurance for large companies.
  • Worked effectively in large teams to meet tight deadlines.

Will provided excellent customer service skills on the support line in the government sector.
  • Swiftly diagnosed and fixed IT issues in a fast-paced environment.
  • Created 3 articles to assist other consultants on fixing issues, one of his articles was used by consultants over 130 times.
  • Learned to identify persisting issues and flag fixes to reduce call-in rate and solve time.

Will was responsible for proposing and implementing technologies to improve the business from VOIP to cloud server migration.
  • Managed IT effectively during merger to ensure nominal operation.
  • Established remote working procedures for the organisation.
  • Spearheaded azure cloud integration throughout charity, transferring legacy domain systems onto cloud.
  • Reduced phone system operating costs by 10%, negotiating pricing and ensuring enhancements of services.
  • Maintained and administered computer networks and environments, including computer hardware, software, and applications.

Will founded a sponsorship team, creating a collaborative environment of 10 people to build an extensive sponsorship network.
  • Secured over £50,000 in funding from companies such as Delta, Michelin, Catapult & AVL.
  • Met HRH Prince of Wales to showcase prototype motorcycle design.
  • Created financial reporting framework to review project's financial status and prepared weekly reports to ensure team was on track with deadlines.
  • Coordinated marketing campaign raising £1000 and increased brand awareness from flyers, social media and events.
  • Liaised with academics and industry experts to gain further understanding of complex components of project.

Will created automations and dashboards to digest data and identify valuable insights within the finance function.
  • Created Tableau dashboard relating exit interviews and employee retention.
  • Automated production of manager performance reports using VBA, increasing scope from 12 to 200 seniors. Reduced creation time from 50 working hours to being distributed in 12 minutes.
  • Utilised data-driven insights to provide strategic recommendations to enhance manager appraisals.
  • Conducted workshops to teach a group of 7 employees how to use AlterYX.

Will learnt to hone his problem solving and analytical skills while at University.
  • Mathematics and Data Science
  • Engineering Design
  • Automation and Robotics
  • Introduction to Business Management
  • International Business Strategy