2nd year Accounting and Management student at the University of Bath, with hands-on experience in a purchase ledger role. Currently working with a consultant to implement Jedox, a Business Intelligence (BI) tool, into the business, focusing on financial consolidation and business analytics. Actively developing my technical and financial skills alongside my academic studies.In my spare time, I am applying knowledge of Python, SwiftUI and PostgreSQL to develop an app for iOS.
-
Self EmployedFull Stack Developer | MarketerBath, Gb
-
Purchase Ledger ClerkCreo Medical Jul 2024 - PresentChepstow, Wales, United Kingdom- Rebuilt an IFS transformation workbook to convert Concur expenses into an IFS-compatible format, significantly reducing manual data processing time by approximately 10 hours bi-weekly.- Developed a financial dashboard in Excel to analyze cash flows of existing and new products, including revenue, costs, gross margin, NPV, and IRR calculations. Utilised to support the board in making informed financial decisions.- Created VBA-powered workbooks to automate purchase ledger tasks, including automatically sending emails to chase suppliers and streamlining IFS journal entries to allocate headcount to the correct cost centers efficiently.- Produced Management Account Pack with BI integration. This included constructing a P&L Summary, Balance Sheet, Cash and Debt, KPI Summary, Headcount Summary and Graphs. -
Self EmployedDigital Marketer And Website Developer Nov 2023 - Present- Created an advanced Excel workbook for client and appointment databases using VBA forms. Automated invoice creation with a quick-save feature. Developed an overview sheet to calculate gross and net profit, and Return on Investments, including graphs and charts to summarize data.- Built and designed websites for clients that rank at the top of search results through successful SEO optimisation; designs that outcompete local competitors. - Reduced my costs to offer great value in comparison to other website builders, driving business growth. - Designed and printed business cards that generate additional income for clients.
-
Shift LeaderCaffè Nero Aug 2021 - Nov 2023Cowbridge, Wales, United Kingdom- Calculated Stock Levels and Total Revenue at the end of day- Gained an ability to work in a faced-paced environment- Formed positive working relationships with peers
Dylan Johns Education Details
-
1St In Business Analytics - Year 1 -
Business - A* | Geography - A | Maths - B -
Seren Summer School Certificate
Frequently Asked Questions about Dylan Johns
What company does Dylan Johns work for?
Dylan Johns works for Full Stack Developer | Marketer
What is Dylan Johns's role at the current company?
Dylan Johns's current role is Self Employed.
What schools did Dylan Johns attend?
Dylan Johns attended University Of Bath, Cowbridge Comprehensive School, Jesus College Oxford.
Who are Dylan Johns's colleagues?
Dylan Johns's colleagues are Jack Coleman, Robin Franklin-Kench, Leszek Koczaja, Frederick Thornton, Gavin Wallace, Malcolm White, Janine Perryman Benavente.
Not the Dylan Johns you were looking for?
-
-
Dylan Johns
London -
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial