TOBI AGORO
Summary
Detail-oriented analytical thinker with superior consultative skills. Applies critical thinking to achieve complex business objectives, transforming data into meaningful insights. Possesses strengths in research, negotiation and cost-benefit analysis. Ability to handle multiple projects simultaneously with a high degree of accuracy. Organized and dependable candidate successful at managing priorities with a positive attitude.
Overview
10
10
years of professional experience
10
10
years of post-secondary education
Work history
Senior Data Analyst
Mercedes-Benz
Milton Keynes
04.2022 - Current
- Working closely with the team of digital agents, supporting the maintenance of a resource roadmap, creation of requirements and monitoring performance; working with agency analysts to deliver monthly and quarterly site performance reviews
- Curate data within Google Analytics and internal databases to provide insights to the Digital Sales team to inform the strategic direction, design and iteration of digital functionality of the Online Showroom to increase lead conversion
- Liaising with stakeholders to verify technology alignment, recommending solutions against project specifications.
- Producing written documentation and facilitated business decision-making through dynamic visual presentations to report data to influence key stakeholders through the use of Power Bi Dashboards, Salesforce, SQL and Excel.
- Devising and leading operational changes to generate significant improvements and measurable results in line with business objectives.
- Employ relational and hierarchical databases to create ad hoc reports, receiving 100% positive senior management feedback.
- Analyse large CSV/XLSX/XSLM/XLSB files in Excel using an array of formulas and tools (Vlookup, Index Match, IF statements, Pivot tables, VBA Coding); drawing meaningful conclusions and providing actionable recommendations to senior stakeholders.
Data Analyst
Alphabet GB, BMW Group
Farnborough
11.2018 - 03.2022
- Working with sales colleagues to advise and build commercial pricing and profitability proposals for tenders; taking market and competitive conditions into account while aligning with internal strategy
- Collaborating on variety of change projects with high level stakeholders from commercial, operations, finance, HR and compliance to improve business operations and increase efficiencies
- Leveraged market and competitor data to identify market opportunities and gaps.
- Analysed large datasets, drawing meaningful conclusions and providing actionable recommendations.
- Designed rich and engaging data visualisations through QlikView and Excel to share key insights.
- Trained end-users to capture new reports and use dashboards.
- Wrote functional specifications for systems developers and completed regular updates to incorporate changes.
- Generated multiple monthly and quarterly reports from extracted data in Excel using =SUM/Vlookups/Index Match/IF/Pivot Tables/ Charts and Graphs for analysis.
Insurance Claims Analyst
ERGO
Birmingham
10.2016 - 12.2017
- Lowered outstanding balances within 3 months by 20% through weekly reviews of collection reports
- Managed large client portfolio, prioritising claims in line with complexity and demand.
- Collected and reported monthly expense variances and explanations which reduced expenses by 10%
- Created macros for large database sheets which reduced manual input errors by 50%.
- Investigated suspected cases of fraud and theft involving small numbers of transactions or complex systems.
- Compiled general ledger entries on short schedule with 100% accuracy.
- Organised and carried out month-end, quarterly and year-end processes.
- Provided data science teams with in-depth claim analyses for enhanced modelling.
Broker Relation Assistant
Munich Re Group
London
03.2017 - 05.2017
- Analysed projects for capital deployment and implemented structures within multi-million pound deals
- Read and correctly interpreted documentation to understand key details and make accurate judgments about data.
- Worked with large volumes of data, completed accurate calculations, and presented results in required formats.
- Supported field insurance team with timely processing of enrolments, policy changes, and cancellations.
- Monitored organisation's performance against competitors by using annual report figures and creating pivot tables and charts to make global comparisons
- Met with multiple existing and prospective clients each week with a success rate of 1 in 3 in selecting appropriate insurance policies.
Quality Assurance Trainee
BMW Group
Oxford
08.2014 - 08.2015
- Managed BWM testing templates to perform automobile mechanical procedures using car diagnostic software and presented as direct reports for weekly senior meetings
- Produced internal manuals for car diagnostic software within regional based teams for training purposes
- Conducted root cause analysis of collated mechanical problems identified by team members
- Reports were submitted to regional management for review prior to group submissions
- Responsible for organisation of and meetings for mechanical problems with regional and head office teams to conduct root cause analysis and problem-solving events in the UK
- Maintenance of engineering cars, making sure vehicles were being used frequently for testing purposes, and updating them with pre released software to find any issues that will need investigations on either through standard every day driving or arranging track days
- Produced a range of standard documents in an accurate and timely manner- Accurately performed various data processing tasks using a variety of systems.
Education
BA (Hons) - Accounting
University of Bedfordshire
09.2012 - 05.2016
A-Levels -
Seven Kings High School
09.2010 - 05.2012
GCSEs - GCSE
Royal Docks Community School
09.2005 - 05.2010
Skills
- Data mapping
- Good organisation and time management
- Good knowledge of economical applications ie SPSS and Gretl
- Advanced Excel modelling and VBA coding
- SAP expert
- SAF expert
- SAS expert
- QlikView
- Salesforce CRM System expert
- Forecasting and planning
- Agile methodologies
- Jira
- Power Bi Profeciency
Interests
- Car sales entrepreneur; car Salesman for all sell new and used vehicles. Cars are purchased from auctions and are fixed and sold on a profit.
- BMW Group Ambassador Brand ambassador for the BAME community - I help to encourage the minority to join the group by providing a detailed overview of what a career at the group will entail and also educate the wider group in why we need to promote diversity and the positive impact this provides.
- Private Landlord
Timeline
Senior Data Analyst
Mercedes-Benz
04.2022 - Current
Data Analyst
Alphabet GB, BMW Group
11.2018 - 03.2022
Broker Relation Assistant
Munich Re Group
03.2017 - 05.2017
Insurance Claims Analyst
ERGO
10.2016 - 12.2017
Quality Assurance Trainee
BMW Group
08.2014 - 08.2015
BA (Hons) - Accounting
University of Bedfordshire
09.2012 - 05.2016
A-Levels -
Seven Kings High School
09.2010 - 05.2012
GCSEs - GCSE
Royal Docks Community School
09.2005 - 05.2010