Project Outline

Close Brothers were in the process of building a financial reporting system to facilitate internal ad-hoc reporting and reduce performance issues with the Company's live internet system. The live system was used by brokers to upload and consume data intensively throughout the day.

The role

I was engaged to work with another tester to verify the Excel component of the solution and provide performance measurements of the reporting server against the live version. The component comprised of a 400+ collection of Excel Workbooks with built-in SQL queries and VBA driven automation functionality.

Project Info

  • Client: Close Brothers Premium Finance
  • Engagement Partner: Birlasoft
  • Job title: Systems Tester
  • Date: 2014
  • Technologies: Excel, Oracle
  • Lessons learnt: Standardization of reports greatly simplifies the testing process.