Data-Driven (Excel) Solutions for Barclays and Cabot Aviation

Barclays Management Reporting System

At Barclays, I developed a suite of Excel spreadsheets designed to streamline and enhance their management reporting. These spreadsheets were integrated with a central Access database to extract and present data efficiently. The solution generated detailed reports that analyzed regional sales and assessed the performance of mortgage sellers, providing crucial insights for management to make informed decisions.

Cabot Aviation Contact Matching Tool

For Cabot Aviation, I crafted a custom Excel-based tool to automate and optimize their email marketing process. The challenge was to match contact details from Microsoft Outlook with flight operator data for targeted mailshots.

Requirements Overview from Cabot Aviation:

"The database we subscribe to comes from www.flightglobal.com and is a comprehensive resource listing every commercial aircraft and its operator. While the database includes contact details for these operators, they are often limited. We needed a way to generate a list of, for example, B747 operators and cross-reference it with our own contact list in Microsoft Outlook for efficient email campaigns. We typically perform mailshots like this a few times per month for different aircraft types. You can export this list into any format, such as Excel."

Solution:

I developed a sophisticated spreadsheet that automatically extracted and matched email addresses from Outlook to the relevant flight operator data. This streamlined the process of creating and sending targeted email campaigns, saving time and increasing the efficiency of their marketing efforts.

These projects highlight my ability to understand complex business requirements and deliver tailored, data-driven solutions that drive productivity and efficiency.

Project information

  • CategoryBanking/Airlines
  • Client Barclays and Cabot
  • Technology Excel, Access, VB