Frederick Salt

Frederick Salt

Information / Business Analyst

Followers of Frederick Salt290 followers
location of Frederick SaltWest Midlands, England, United Kingdom

Connect with Frederick Salt to Send Message

Connect

Connect with Frederick Salt to Send Message

Connect
  • Timeline

  • About me

    Technical Product Owner at Rascal Solutions Ltd

  • Education

    • Solihull College

      2004 - 2005
      National Diploma IT Practitioners (Software Development)
    • Four Dwellings High School

      1998 - 2002
    • Stanford University

      2015 -
      SQL
  • Experience

    • Arval - BNP Paribas Group

      Dec 2006 - Jul 2009
      Information / Business Analyst

      - Producing detailed adhoc reports from multiple data sources for large corporate customers with 40000+ fleet cars- Retrieval of data from various systems and data warehouses using many languages and programmes, which include; SQL, Microsoft Access and Linux- Use of a wide array of tables that contain transactional information, account information to tables with only a few key fields- Automation of current reports with a view of removing human error & increasing speed and efficiency- Improving old access databases and creating new databases to suit customer needs.- Planning, implementing and running of a series new access databases for Pan Government contacts- Producing Key Performance Indicator reports for quarterly customer analysis- Creating and producing monthly sales and productivity reports for management- Major project involvement with re-designing of current systems- Setting requirements for new systems- Analysis of systems that were in place and identifying key areas of improvement- Writing of macros in VBA in all Microsoft suite applications including Outlook- Use of Excel (with complex formulas, graphs and pivot tables) to present the information in an accessible layout for the customer.- Analysis of contracts- Producing Ratebooks (multi quote spreadsheets) of thousands of vehicles- Identifying and applying discounts to vehicles - Auditing other peoples work to ensure accuracy - Bringing the old procedure documentation in line with current company policy. Show less

    • Microsoft

      Aug 2009 - Aug 2009
      Excel Specialist

      - Creation of a reporting suite for royalty payments, after a discussion with Microsoft production of the reports was moved from Excel to Access.- Automating of the reporting suite to as little clicks as possible with VBA and SQL. - Ensuing that the database would easy to maintain in the event new vendors were added.- Documentation of the entire processes including local work instructions for users and also a document for and advanced users that may wish to change any coding.- Debugging and rewriting all other macros in the finance department that they were unhappy with at the time. Show less

    • Serrula Research Ltd

      Sept 2009 - Dec 2014
      Director of IT

      - Creates and maintains all databases and all automated reporting systems undertaking the ongoing review to ensure fit for purpose.- Project manages all analytical projects ensuring the planning and prioritisation of multiple projects running concurrently.- Project manages all international projects. - Main point of contact for clients on projects. - Runs reports (both ad-hoc and regular) for external clients, providing clear and concise commentary to ensure understanding of findings.- Halved staffing costs on projects through automation of regularly ran projects.- Manages and distributes workload to 20+ staff. - Mentors, coaches and motivates team and conducts regular performance reviews.- Acts as main point of contact for clients and stakeholders providing insight when applicable.- Enforces standard company policies and procedures.- Reports profit and loss figures.- Manages suppliers and call centres.- Plans and manages company telephone system.- Plans all IT infrastructure, from servers to desktops including management of hardware lifecycles Show less

    • Rascal systems

      Dec 2014 - now

      - Developed and communicated a clear product vision aligned with business goals.- Defined product, prioritized features, and ensured alignment with stakeholders.- Collaborated with cross-functional teams to gather and analyse requirements.- Translated business needs into detailed user stories, acceptance criteria, and technical specifications.- Coached team members on Scrum principles, roles, and ceremonies.- Supported a team of UK based and Offshore Development teams of 25 staff- Supported self-organization and empowered the team to make decisions.- Engaged with customers, end-users, and executives to gather feedback and refine product features.- Orchestrated product releases, coordinating feature launches and bug fixes.- Facilitated daily stand-ups, sprint planning, sprint reviews, and retrospectives.- Ensured effective communication and collaboration within the Scrum team.- Delivered a large scale legacy vb6 system replacement product ontime and on budget- Ensured timely delivery by managing dependencies and resolving bottlenecks through continuous improvement and implementing best practices to enhance team productivity.- Incident management of production incidents. - Fostered a collaborative and transparent work environment.- Active member of the scrum alliance Show less - Identified key savings with use of automation the Microsoft office suite.- Removed 12 manual processes within the first month and freed up 30 hours per week of ‘man’ hours.- Heavy involvement in project meetings with a view of diversification from core products.- A member of the Project board in the development of solutions- Reduced theft from one supermarket accounted for a saving of 30% per annum on one product line- Creation of new report for clients to provide more insight into the data that was currently being gathered- Reviewed both reporting requirements and reporting tools currently in use.- Streamlined current reports to clients removing duplication of data from reports though negotiation. Show less

      • Product Owner

        Feb 2020 - now
      • Commercial Analyst

        Dec 2014 - Feb 2020
  • Licenses & Certifications