Experience

ROCK Insurance Group
• United Kingdom
• Financial Services
• 1 - 100 Employee
• Senior Data Analyst

  • Mar 2022 - Present


Global Freight Solutions Ltd

• United Kingdom
• Transportation, Logistics and Storage

• Revenue Data Analyst

  • Mar 2019 - Feb 2022

  Using SQL to extract, analyse and report on supplier, operational and customer data. Analysing supplier invoicing data to dispute overcharges with suppliers and pass on surcharges to customers where applicable. Creating models to report customer margins and produce operational data to import into business dashboards. Producing analysis on new customer margins for the sales director and HR so that they can pay their account managers commission for new business. Generating ad-hoc analysis for account managers and directors to expose issues causing customer margins to drop and suggesting possible resolutions. Supporting the Accounts team in month end duties, provisioning cost and sale relating to the reporting month and journaling these ready for posting. Working for three months without a direct manager, time keeping, setting expectations for other departments, delegating tasks to the team and communicating directly with the CFO. Working on projects using sprint and scrum management techniques to develop new analytical software for the business. Creating VBA macros in Excel to automate and pass on work to other members of my team. Using Datacamp, an online teaching platform, to advance Python programming skills and develop knowledge to become a Data Scientist. Updating cost and sale rates in the billing system to ensure accuracy of data. Using Sisence, a dashboard analytics platform to produce visual reports for the company. Show less



Ascenti

• United Kingdom
• Wellness and Fitness Services
• 200 - 300 Employee

• Data Analyst

  • May 2018 - Mar 2019

  Confident using SQL, including pivot functions, sub queries and loops, able to build reports to pull patient data and produce ad hoc statistics for the company leaders, making them easily accessible on the intranet. Completing weekly and monthly tasks promptly to a professional standard. Learning 70% of the team's monthly reporting duties within 3 months, completing them to a high standard and delivering them to customers. Good skills in presentation of work, including advanced use of Excel using pivot tables, product formula, indexes and vlookups using these tools to create new management reporting information using numerous data sources. Approachable, took ownership of tasks and effectively managed their own workload. Show less



Lockheed Martin

• United States
• Defense and Space Manufacturing
• 700 & Above Employee

• Financial Analyst Intern

  • Sep 2016 - Aug 2017

  Using SAP accounting software to manage ledger accounts, journals, invoices and charge codes. Creating multiple reports each week for different business units. Improving excel spreadsheets to assist fellow employees with their daily tasks. Reconciling and submitting payroll files for over 2000 employees. Billing and logging payments made from business units back to the company. Taking on the role of engagement lead, organising team events and a food drive for a local charity. Helping with audits, providing billing details and explaining business processes when a senior employee was absent. Completing tasks above the role to an exceptional standard. Holding and presenting meetings for management both in person and via Skype to employees in the US. Creating and updating guides to help with routine processes for future interns. A member of the interview panel and process for selecting the future intern. Show less



Initially Yours Ltd

• Sales Assistant

  • Jul 2014 - Sep 2015

  Checking and ordering stock to ensure sufficient supplies. Using tills, serving and advising customers. Taking phone calls for customer queries and complaints. Taking charge of the shop while the manager is absent, showing leadership and responsibility to higher management. Serving at busy and challenging times being polite, professional and efficient. Checking and ordering stock to ensure sufficient supplies. Using tills, serving and advising customers. Taking phone calls for customer queries and complaints. Taking charge of the shop while the manager is absent, showing leadership and responsibility to higher management. Serving at busy and challenging times being polite, professional and efficient.