GNRC | Generic LTD

The Problem: The company relies on multiple online platforms to understand their customers. They have attempted to create BI dashboards in the past. However, without a set up that connects their data together, there is a limit to what they can understand. Their aim was to better understand customers by connecting all customer information together in one place, without having to spend alot of money on maintaining the system.
The Solution: Using AWS Web Services, we extracted, validated, transformed and stored their data on the cloud. We included the provision of structured convension and alerting to make sure their data is looked after. We then connected this data to Tableau. Within Tableau, we defined how all analytical tables were related, and demonstrated how it could be used. We provided training and documentation to ensure the client could internally handle any issues with their system, while also offering to provide routine maintenance if needed. We made sure at each stage to reduce cost to the bare minimum.

The Problem: The company relied heavily on large spreadsheets, particularly key KPI documents, which took 1–2 minutes to load. This delay was causing inefficiencies during time-sensitive meetings. The CEO requested a solution to significantly reduce loading times but explicitly prohibited the use of database technologies (SQL, NoSQL, etc.).
The Solution: A custom solution was developed using VBA, key-value stores, Python, and cron jobs. This approach optimized the data retrieval and processing workflow, reducing spreadsheet load times from 1–2 minutes to just 1–2 seconds. The solution met all restrictions while dramatically improving efficiency.

The Problem: The client relied on a template spreadsheet with VBA for budgeting across multiple projects. Occasionally, bugs would arise, and fixing these issues across all 300+ spreadsheets was a time-consuming process, often taking hours or even days.
The Solution: We developed a VBA-based solution capable of replacing the backend VBA code in any module type (sheet, workbook, form, class, or generic module) across multiple spreadsheets. The only input required to execute this process was the file paths of the spreadsheets, making it highly efficient. This approach drastically reduced the time required for code updates, ensuring consistency and freeing up valuable resources.

The Problem: The client’s revenue management team was spending excessive time manually exporting reports from their system and copying and pasting data into their workflows. This repetitive, time-consuming process diverted their focus away from analyzing and acting on the data.
The Solution: We located and reviewed the system's API documentation, guided the client through the process of activating their API, and developed Python scripts to automate data extraction and transformation. The processed data was seamlessly integrated into their existing system, eliminating manual tasks and allowing the revenue management team to concentrate on strategic decision-making.

The Problem: The client's revenue management team needed deeper insights into their hotel's booking trends. They wanted a solution to analyze seasonal patterns and evaluate performance against historical data and targets.
The Solution: We developed a fully configurable dashboard that allowed users to select specific dates, date ranges, and custom date types (e.g., low-demand or high-demand periods). The dashboard provided detailed booking trends compared to previous years, along with separate reports for each room type (e.g., double, king, single).
Key features included:

The Problem: A Portfolio Manager (PM) at a hedge fund needed a system to monitor, store, and manage data for the systematic trading of stocks across global regions. The solution had to operate seamlessly for daily trading without requiring dedicated technical support.
The Solution: An automated data pipeline was designed to extract, transform, and load (ETL) all necessary data, including reference data for thousands of global stocks, systematic indicators, and reporting metrics. A tailored dashboard for each region provided real-time insights into the quality of data loads and transformations prior to market open.
Comprehensive reports, including P&L, trading-day analytics, and key statistics, were developed, automated, and integrated into the system. A persistent alerting mechanism monitored for errors, incomplete data loads, or process interruptions. Where possible, the system autonomously addressed issues, notifying the PM of critical fixes or unresolved problems.
This robust solution operated without daily support, requiring updates only for new data needs or changes in data formats. It ensured reliable, efficient trading operations for years, aligning perfectly with the PM's requirements.

The Problem: The client needed automated, scheduled reporting to meet strict regulatory compliance requirements.
The Solution: Working closely with a compliance officer who outlined the client's regulatory needs, we developed a robust reporting system to fulfil all MiFID II requirements. The system extracted, transformed, and generated detailed and summary reports, ensuring complete compliance in the trading environment.
Given the time-sensitive nature of some requirements, an alert mechanism was implemented to monitor report generation and delivery. In the event of delays or issues, the system notified both the technical team and compliance officers, enabling timely resolution and ensuring adherence to regulations.

The Problem: Navigating the vast array of supplements, herbs, and spices used in complementary medicine is challenging. Books and research papers often lack an organized way to classify these substances based on their relevance to different conditions, making it difficult for users to find reliable information.
The Solution: We developed a relational database and application to streamline access to information on herbs and supplements. Using research papers and detailed notes, we compiled data on herbs, including their indications, biological activities, contraindications, dosages, and other key properties. The application allows users to search and query herbs by common or Latin names and filter based on specific properties.
To enhance reliability, we introduced a scoring system for each herb, reflecting the number of research papers supporting its properties and actions. This system provided users with a measure of evidence-based credibility, making it easier to navigate and utilize the data effectively.