Passionate about leveraging tech & data for business optimization. Experienced Business Analyst adept at creating advanced Excel & SQL-powered Power BI dashboards for strategic insights. Proficient in SQL & data migration. BA (Hons) in Politics & International Relations.Core Skills:Power Bi Dashboards & Visualisations.Advanced Excel including Power Query.SQL - SSMS, Azure, DB creation, Legacy migration, aggregate functions, View creation.
Field Sales Solutions
View- Website:
- fieldsalessolutions.com
- Employees:
- 381
-
Power Bi DeveloperField Sales SolutionsLoughborough, Gb -
Business Analyst & Power Bi DeveloperToyota Material Handling Uk Oct 2023 - PresentLeicester, England, United Kingdom- Developed a comprehensive fleet 'Vehicle off road' tracking dashboard for 300+ engineers. Real-time parts order tracking and security. Implemented High-Level KPI trackers for Senior Management. This quickly became the Rank #1 used report across the entire UK organisation.-Led the successful ETL Migration of 6.8M Records from Legacy profitability records into a new SQL database.- Spearheaded the creation and implementation of automated Power BI Dashboards, seamlessly integrating live SQL (SSMS) database tables and Power Automate for streamlined KPI reporting. These dashboards significantly reduced manual efforts, saving several hours weekly for executive operations managers.- Currently managing a large-scale project for the migration of quarterly profitability and operational KPIs, involving comprehensive data pipeline planning and development across multiple departments and sources.-Optimized existing business reports and KPIs through in-depth analysis of departmental processes, resulting in the development and implementation of creative Excel and Power BI solutions.Responsibilities:- Conduct needs assessments with business stakeholders to establish Dashboard reporting requirements.- Provide analytical, commercial, and financial support to drive divisional objectives within the after-sales team.- Identify and develop new data modeling tools and concepts to enhance operational efficiency.- Deliver comprehensive divisional KPI reporting to support decision-making processes.- Support month-end financial reporting activities and the budgeting process throughout the fiscal year.- Provide internal and external customer support, ensuring satisfaction and efficient resolution of issues.- Maintain, update, and improve all reporting systems to ensure accuracy and relevance.- Conduct variant and exception analysis to identify key issues and support resolution efforts.- Perform balance sheet reconciliations and ensure financial accuracy and compliance. -
Revenue Assurance Data AnalystSiemens Jul 2022 - Oct 2023Nottingham, England, United Kingdom- Manage the creation & distribution of key operational service metrics.- Data analysis of Engineering works including job volumes, record quality, sales & revenue volumes etc.- Excel pivots, formula, power query, Macros.- Data manipulation and presentation.- Dashboard and KPI metrics through Excel, Power BI & DOMO.- Process & workflow optimisation.- SQL Database Querying Fundamentals.- Process Mapping- Creation of workflow documentation for project partners to process devised optimisations. (Visio)- Initiate, develop and deliver revisions on existing business process' & data streams.- Regularly compile, analyse and present over £1M worth of invoice data monthly to both internal and external partners at various levels of operations.- Generate business insights into Invoicing and revenue data. Recently reviewed existing billing techniques exposing a potential 7.54% increase in month-to-month revenue.- Data cleaning, manipulation & presentation in Microsoft Excel. -
Nhs Test & Trace Customer SupportSitel Group Jul 2021 - Oct 2021Communicated with the public during the Corona Virus pandemic to compile and collect personal sensitive data in alignment with GDPR regulations. Provided empathic and compassionate customer service to vulnerable and at risk people. Organised necessary medical specialist consultations between relevant parties. Utilised translation services to support communication to a diverse population. Provided tailored healthcare related support for positive COVID patients."It’s with a heavy heart I will process your resignation, you have been a fantastic agent and I will be sure to make that clear in the event you return." - Line Manager, Irwin Davison. -
Various Hospitality RolesStonegate Group Feb 2016 - Dec 2019VariousExperienced a series of different hospitality roles including leadership positions. Provided excellent customer service, driving increasing sales and improving customer retention within high pressure environments. As a shift-supervisor/Team leader I supervised staff training and development ensuring staff were capable of their respective roles whilst simultaneously fostering a relationship of openness and compassion. Experienced a high degree of responsibility Managing the day-to-day business logistics including shift Rotas, stock ordering & delivery, cash handling, banking, premises security, etc. Controlled and managed conflicts between the staff or public through de-escalatory tactics ensuring all parties were happy with the outcome Specific dates & establishments:Bartender:Location: The Phantom, Loughborough, England.Dates: July 11th 2019- 6th December 2019.Bartender/Mixologist:Location: Vodka Revolution, Loughborough, England.Dates: November 11th, 2018 – 10th July 2019Waiter/Bar staff:Location: Potters kiln, Harvester, Lowestoft Dates: July 2nd, 2018 – August 20th, 2018.Team Leader/Shift supervisor: Location: Three Hammers Pub, St Albans, England.Dates: September 2016 – May 2017.Bar Staff Team Member: The Flag & Firkin, Watford, England.Dates: February 17th 2016 – September 2016. -
Technical Support EngineerEmis Health Jan 2016 - Feb 2016Watford, United KingdomProvided technical support to clients for their bespoke Pharmacy prescription software. Tracked and logged technical problems in order to analyse and implemented solutions. -
Junior Technical AnalystNetcall Plc Apr 2014 - Dec 2015Hemel Hempstead, United KingdomProblem-solving & Analytical Skills - Conducted in-depth analysis of technical issues within custom software, employing analytical reasoning to identify root causes. - Collaborated cross-departmentally to formulate cooperative resolutions for challenging technical problems. - Oversaw the implementation of software and hardware solutions, utilizing both on-site and remote support technologies, such as VPN and PuTTY. Technical Proficiency - Acquired substantial computer literacy, honing desktop support, and IT skills during problem-solving processes. - Gained hands-on experience in Oracle database management and familiarity with SQL scripts, contributing to a comprehensive technical skill set. Communication and Customer Interaction - Communicated effectively with a diverse client base, logging detailed notes on technical issues, and prioritizing problems based on urgency. - Delivered excellent customer service through both phone and face-to-face interactions, ensuring client satisfaction and issue resolution. -
Sony Playstation Campaign Technical Support EngineerSitel Oct 2013 - Mar 2014Watford, United KingdomI have had the pleasure of working for the SONY Playstation Customer technical support line on a full time contract. Naturally, this gave me considerable experience working with the general public, objection handling complaints and assisting customers with technical support. Day-to-Day involved accepting calls, Ticket logging and providing fantastic customer service through expert technical support at a standard set by SONY playstation.
Ross Webb Education Details
-
Central Bedfordshire College45 Distinctions.
Frequently Asked Questions about Ross Webb
What company does Ross Webb work for?
Ross Webb works for Field Sales Solutions
What is Ross Webb's role at the current company?
Ross Webb's current role is Power Bi Developer.
What schools did Ross Webb attend?
Ross Webb attended Loughborough University, Central Bedfordshire College.
Who are Ross Webb's colleagues?
Ross Webb's colleagues are Bethany Peverell, Julie Brassington, Vicky Richards, Gary Yeomans, Oliver Moffat, Tom Gittings, Paul Murphy.
Not the Ross Webb you were looking for?
-
1hp.com
-
1technipenergies.com
-
3acandco.com, acandco.com, gmail.com
2 1-256-4XXXXXXX
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