Frank Ray is owner and director of Frank Ray & Associates, a software engineering consultancy he founded in 2011. Frank is a software engineer who has worked as a self-employed software developer, business analyst and project manager for the last 20 years.
A complete list of every client and project Frank has worked on (either personally or as a contractor and supplier and/or through his associates) is detailed below, illustrating the depth and breadth of business and technical expertise gained over many years.
We absolutely love doing this stuff, please get in touch if we can help your business too.
Return to main website: http://www.frankray.net
April 2019 July 2019
An assisted living complex for people over 65 had nearly finished construction and the separate accounting systems needed to be integrated tightly. An EPOS till had been installed in the restaurant, Yardi Voyager procured for resident management, GoCardless for Direct Debit payment collections and Sage 200 to produce management accounts. I worked with the FD to understand accounting triggers, agree required data flows, worked with the suppliers to agree import / export schemas, oversaw supplier customisation work, and wrote and tested custom C# .Net integration code. Training and support was provided to the FD regarding new month end processes.
Mar 2018 - Feb 2019
Business Analyst to several development teams building front-end web applications to GDS standards. Worked closely with Product Owners, Delivery Manager, UX, Solution Architecture, Technical Lead, QA to define product backlogs and embed Agile, Scrum, SAFe across all aspects software development.
Performed a comprehensive assessment of issues in the team for senior management
Implemented Agile across multiple sub-teams using Scrum and JIRA
Standardised Scrum boards (layouts, column mappings, workflow, statuses)
Ran Scrum ceremonies (backlog refinement, retrospectives, sprint planning, daily stand-ups)
Defined backlogs, wrote acceptance criteria and developed mockups, ran backlog refinement sessions
Managed all aspects of an offshore development team in Poland
Performed release co-ordination in a Continuous Integration (CI) environment with complex dependencies
JIRA administrator and single point of contact for all JIRA matters across the teams
Co-ordinated a Scrum Master community of practice to better support each other
Dec 2017 - Mar 2018
Business Analyst on a digital discovery project for Adult Social Care which investigated if the content on NHS Choices is serving the general public well, and if not, how best to change it. Interviewed patients (some nearing end of life) and their carers, GPs and hospital discharge staff to understand needs, investigated technical platform capabilities and roadmap, made recommendations for improvement.
Oct 2017 - Dec 2017
Business Analyst on a digital discovery project related to Brexit. Interviewed HMRC staff to develop a current as is model for a key UK international trade function, mapped stakeholders and documented their operational roles, and developed future to be models for post Brexit including the implications of each.
Sep 2017 - Nov 2017
Business Analyst who performed a comprehensive operational assessment of an NHS mental health service available to Londoners. The service had successfully transitioned through the discovery, alpha, beta stages; and required assurance prior to significantly scaling out to the general public. Interviewed programme staff and suppliers, uncovered areas for improvement, and presented recommendations to the head of a London CCG.
Apr 2017 - Jul 2017
Business Analyst for a digital discovery project that investigated, proposed and assessed areas for digital service transformation within schools. Mapped the overall education landscape and thoroughly researched current problems and issues that the education system faced. Sourced databases and compiled a master data set for analysis as well as investigated the teacher supply market and why teachers have been leaving the profession.
Interviewed internal stakeholders involved in school finance and data collection
Analysed financial returns and account consolidation performed by academies and LA maintained schools
Identified key transformation opportunities for further development
Sized, scoped and costed opportunities to facilitate management decision making
Championed Agile, worked as Scrum Master conducting daily stand ups and performed Agile coaching
Embedded the use of digital tools including Slack, Trello, Confluence and G-Suite
Jun 2015 Mar 2017
National Information Board (NIB) Mobile Health Apps Assessment and Uptake worstream
Member of a multi-organisation programme to provide an accredited set of NHS and social care apps direct to citizens through the NHS Choices website. Designed and validated the process to assess and issue NHS kitemarks to the best performing mobile health apps.
Managed a project budget of £400k and 4 external suppliers (around 10 people in total).
Actively involved in the sourcing, evaluation, and award decisions regarding suppliers.
Defined work package specifications and coordinated delivery across 4x separate suppliers.
Oversaw the market research and design work that resulted in a prioritised user needs catalogue.
Architected the assessment process, wrote user guides, maintained editorial control of the question set.
Ran a pilot across 8 mobile apps to test the assessment process, covering diabetes and mental health.
Performed all project coordination and administration tasks due to very little project support.
Replace legacy marketing CRM platform
An initiative to replace a legacy CRM which had 100 million records and contained 6 million registered campaign users. A full business case for the replacement was produced that demonstrated substantial cost savings over a year 4 period, which was accepted and sent to Department of Health for approval.
Managed a project budget of £250k and an external supplier team of 8 people.
Clarified and defined the project scope into a single PID that was approved.
Navigated the Government spend controls and approval processes to obtain initial supplier budget.
Defined the required work packages and submission templates for the procurement tender.
Facilitated the evaluation and scoring of supplier responses in compliance to Crown regulations.
Gathered to-be system requirements, oversaw reference architecture, ensured traceability.
Filled Product Owner (PO) and Quality Assurance (QA) roles to ensure successful delivery.
Managed a large number of stakeholders many of whom had competing interests and views.
Dec 2012 Feb 2015
The Top Secret - Project Amsterdam
The evaluation and proposal of digital initiatives that could add new revenue streams to the existing corporate Treasury business. A challenging project that attempted to generate a further £40M pnl.
Managed a project budget of £350k for an external strategy consultancy engagement.
Interviewed existing clients, identified missing business capabilities, outlined new propositions.
Considered the creation of new business units, additional products and services for existing clients, takeover and white-label opportunities, non-compete partnerships to strengthen current offering.
Clearly outlined limitations to future business development and presented solutions to management.
Participated in the London Fintech scene and developed a strong network of key enablers.
Investigated different innovation models, performed research into mobile and social digital trends.
Developed new ways of working, designed and ran a hack-a-thon, produced a short documentary.
Treasury Online Corporate Banking Platform
A new corporate online banking platform to complement the existing telephone and postal channels. Worked closely with the business stakeholders to translate their needs into formal deliverables.
Managed a project budget of £900k and an internal team of 12 people (perm and contractors).
Defined roles and responsibilities, interviewed and hired team members, promoted good morale.
Gathered requirements and worked with business stakeholders to prioritise features.
Validated functional and non-functional requirements, including regulatory compliance.
Presented system designs to technical and non-technical audiences for approval.
Developed functional specifications, UI prototypes and wireframes ready for development.
Modelled client on-boarding processes and defined public-facing website security measures.
Embedded an iterative delivery method which produced regular releases every 2 weeks.
Oct 2012 Dec 2012
A regulatory controls project to collect and populate a single Procedures / Controls inventory. A fixed-term, 3 month contract with an American consultancy to project manage the data collection efforts in London.
Travelled to Boston to present a project plan to the Chairman and COO for approval.
Responsible for tracking the London workstream and ensuring delivery of the Statement of Work.
Delivered a 90 minute project overview and technical demo to Executives/Managing Directors.
Provided technical training sessions to the business users of the toolset (Excel, MS Access, VBA).
Provided support to front-office staff that populated templates with regulatory control information.
Conducted working groups with Securities Finance, FX, Research, WM Reuters and Portfolio Solutions.
Worked with Risk Ops / Audit / Compliance to collate regulatory reporting requirements.
Mar 2012 Aug 2012
Helped run a global Request for Proposal (RFP) to purchase a User Experience Platform (UXP) that could consolidate the various online banking applications into a single platform offering.
Collected end-user business requirements from Private Bank, Capital Markets and Wealth & Investment.
Technically reviewed and validated functional and non-functional platform requirements.
Presented requirements to senior management in UK, South Africa and Australia for acceptance.
Responsible for managing vendor communication and running conference calls to address questions.
Coded an Excel scoring model to validate the vendor responses for timely decision making.
Developed a business case for an internal solution, determined infrastructure needs and licensing costs.
Interviewed Private Bank staff about proposed security measures for online banking.
Nov 2011 Dec 2011
A short-term consultancy to help prepare the four development teams for an upcoming Solvency II audit.
Documented current development standards, selected industry best practices for adoption.
Identified team morale issues and obstacles which hindered previous knowledge sharing attempts.
Modelled the current and ideal incident and change management processes using UML.
Identified ways to improve QA/testing, presented the benefits of an iterative development cycle.
Worked with technical team leaders to develop a buddy program and knowledge sharing initiatives.
Developed good working relationships across management, team leaders, developers and testers.
August 2009 June 2011
Designed and developed (as part of a small team) a Silverlight 4 application to store and manage client documents throughout the deal lifecycle. The thin client interfaced with the strategic document storage solution and was responsible for presenting user specific document views, enforcing deal level permissions, and providing full audit history.
A custom, latency monitoring application used to calculate, record and report trade timings throughout the FX trading systems. Consisting of high volume databases and services optimised for real-time execution, this system was critical to the revenue generating divisions of the investment bank. I developed a web portal that provided management reporting, support information and self-service configuration. Successfully pre-sold and onboarded two new internal customers (Algorithmic and High Frequency Trading), developed a WCF service interface, provided support and ongoing bug fixes.
[C# .Net 4.0, ASP.Net, AJAX, WCF, Visual Studio 2010, SQL Server 2005, TeamCity, Agile Development]
September 2008 June 2009
Working as the lead architect within the Fixed Income Exotics department to develop management reporting solutions for their parallel computing estate. Involved in the strategic development of capacity planning, reporting and self-service management tools for their DataSynapse grid computing (comprising of 24 thousand host computers). Utilised C# ASP.Net and Reporting Services to provide front-end portals. Designed and implemented a department wide WCF service interface to coordinate all data access (serving data from 34x Oracle databases) and enforce enterprise policies such as caching and auditing. Sole C# .Net developer responsible for full development lifecycle, including enterprise and application design, implementation and documentation.
[Fixed Income Exotics, C#, ASP.Net
July 2007 August 2008
A middle-office project to consolidate the numerous fund administrator data feeds and provide a consistent view of the various funds (rolled up and individually) at any given point in time. The solution was a web-based portal used by the finance department to report trial balance, and the marketing department to view client holdings and transactions. Responsible for analysing the current 'band-aid' solution - this being separately maintained Access and Excel files - and consolidating this into a single integrated SQL Server 2005 database. Performed data migration and developed import jobs using SSIS for ongoing data feeds (ftp and InvestOne). Gathered reporting requirements from marketing and finance users and implemented these using Reporting Services.
[C#, ASP.Net 2.0 and 3.5, AJAX, WCF, Visual Studio 2005/2008, SQL Server 2005, SQL Server Integration Services (SSIS), Reporting Services]
January 2006 July 2007
The redevelopment of an ASP &
VB 6 workflow system used to provision applications and other resources to bank
employees. Responsible for designing the system architecture, specifically
middle tier OO class design, evaluation of Windows Workflow Foundation with on-site
[C#, Win Forms, ASP.Net, AJAX, GUI Development, Visual Studio 2005, XML Web Services, Windows Workflow Foundation (WWF), SQL Server 2005, 3-Tiered Architecture]
August 2005 December 2005
The redevelopment of legacy systems that handle new insurance policies, claims processing and road-side assistance requests. Employed to design and implement the C# windows application for the internal call centre. Successfully designed and implemented the client framework required by 9 other developers across 3 development teams. Responsible for introducing XP practices into the development process and mentoring other developers in test driven development (TDD).
[C#, Win Forms, GUI Development, Visual Studio 2005, Rational Rose XDE, Design Patterns, Agile and Extreme Programming (XP), Service-Oriented Architecture (SOA), XML Web Services]
December 2004 May 2005
The Government body responsible for the running of public buses, trains and ferries.
The redevelopment of legacy ticketing software to allow external travel agents and members of the public to book regional rail journeys online. Service-oriented architecture involving two client applications (Windows and Web) with a shared business layer and a range of enterprise services deployed across different physical servers. Successfully designed and implemented the Web Client and secure internet site that can be found at http://www.transwa.wa.gov.au
May 2002 November 2004
Unisys West is a joint venture between Unisys and BankWest
Customer One (Bronson Project), BankWest (HBOS
The redevelopment of legacy call centre software for extranet access via a web browser. First project in a range of initiatives to upgrade and reengineer the banks existing Java software to a standard, enterprise-wide .Net framework. Employed as an architect/developer based of my previous experience developing large-scale, enterprise software. Successfully designed and implemented a range of reusable .Net server controls as part of the standard framework.
A major .Net WinForms development
to consolidate and reengineer the existing courts administration and management
systems into one single, cross-jurisdiction, department wide application.
Employed as a technical consultant to design and develop software for the
District Court, Supreme Court and
· Helped developed an application to generate class definitions and database persistence logic from a Rational Rose model. This was used extensively on the project to allow a purely model driven development approach.
Owner of the Document Lodgment
Wizard used by front counter staff to process and capture
· Designed a custom reporting system used in the generation of client and management reports. Sourced business requirements from the users and developed the initial prototype.
February 2000 May 2002
Burswood, Western Australia
Honeywell is an international engineering firm offering a wide range of products and services in 95 countries and employing over 57,000 people. The Honeywell Software Centre is a large Australian division that services the oil and gas industry, providing custom and off-the-shelf software to customers such as Alcoa, Woodside, and Western Mining.
A major product development commissioned by Chevron and Exxon to provide management reporting to over 150 production sites across the United States. The system was designed as a client-server architecture and development used the latest Microsoft technology, including Internet Explorer 5.5, MS-SOAP and MS-XML3.
· Participated in a development team of five people. Involved in the requirements elicitation with the customer and the development of the software specification.
· Designed client and server software using the latest object-oriented design methodologies, including Rational Rose and UML.
· Developed ActiveX controls and Internet Explorer binary behaviours in C++ using DHTML and ATL. Developed COM objects for server-side data handling and transformation. XML and data binding was used to transfer data between server and client.
A product that performs production accounting so that current and historical running costs of a plant can be examined. Involvement was to implement the second major release of the product in a development team of three people. Development included several Visual Basic applications and ActiveX controls, and a Windows service written in C. Experience in SQL queries and MS-SQL7 database development. Responsible for on-going telephone support.
Honeywell Software Centre has ISO9000 certification and uses a structured development process for all software.
October 1998 March 1999
West Perth, Western Australia
The Institution of Engineers, Australia is the corporate body overseeing the practise and conduct of professional engineers in Australia. The Institution provides many services including the accreditation of Australian engineering university courses and raising public awareness of engineering in the community.
A multimedia website and CD-ROM that was developed to promote engineering as a career option to high school students. A national project initiated by the WA division and made possible through a national Science and Technology grant of $25,000. Over 10,000 copies of the CD-ROM have been produced and distributed nationally to high schools.
· Attended initial meetings with the client and developed the software specification.
· Recruited and managed a development team of fifteen engineering students, a media student, and a graphic artist.
· Managed the technical development and was responsible for meeting technical milestones and delivering on-time.
· Responsible for resource acquisition and the collection of content. Contacted companies including Energex, Clough, and Western Mining to seek their assistance. Arranged site visits and obtained the rights to videos, photos, other online content etc.
The CD-ROM and website was updated and enhanced in August 2000.
The website may be found at http://www.ieaust.org.au/emih
July 1998 February 2000
Nedlands, Western Australia
The Lions Eye Institute is a non-profit, charitable organisation that provides medical care and scientific research into the cause and cure of blinding eye disease.
A system to automate the testing of printed circuit boards was developed as an industry linked project for the Bachelor of Engineering degree course. The system tested the components used in the new Eye:Q solid-state laser developed at the Lions Eye Institute for corrective eye surgery. Development included electronic circuit design and construction, embedded controller programming in C, and Windows programming in Borland C++ Builder.
This prize recognises Australias most outstanding final year student project in the fields of electronic, electrical, communication or computer engineering. National finalists were chosen based on a written submission and a live presentation. Judging criteria included:
· The level of potential benefit to the community from the project, such as the possibilities for further commercialisation, or for environmental benefits.
· The students presentation, including verbal skills and the ability to handle questions from the judging panel.
June 1998 - August 1998
West Perth, Western Australia
Wrote a proposal and won the contract to develop an internet site for a telecommunications study of the Great Southern Region conducted by Peter Farr and his team of consulting and research firms. Experience in contract work and an understanding of consulting practices.
December 1997 - February 2000
Sun-Imago Research Centre
East Perth, Western Australia
· The design and implementation of the Imago internet site and New Media Village gateway.
· The design and implementation of the Western Australian Learning Server.
· Coordinated and actively participated in an internet mentor scheme for school teachers and principals.