Skip to content
Back to Projects

Business Analysis

Bridging Business Requirements to ERP Features

Translated executive direction into BRD/SRS documents and department-specific data marts, bridging the gap between business needs and Odoo ERP development.

Data Analyst & Business Analyst — FP Logistics~1 year
Data ModelingMetabaseOdoo ERP

The Challenge

Leadership had a clear direction for new logistics ERP features, but developers needed precise specifications, and each department needed its own reporting view without duplicating effort across the data warehouse.

The Solution

  • Applied advanced SQL for data transformation and designed department-specific Data Marts from the Data Warehouse for Metabase and Looker Studio reporting.
  • Translated executive direction into Business Requirement Documents (BRD) and Software Requirement Specifications (SRS) for Odoo ERP developers.
  • Designed data models and prepared factual test data to validate features before production deployment.
  • Ran end-user training sessions and built internal automation tools with Apps Script on Google Sheets.

The Result

  • Developers received unambiguous specifications, reducing rework on new ERP modules.
  • Each department got a reporting view tailored to its needs without duplicating warehouse logic.
  • Features were validated against realistic test data before going live, reducing production issues.

Stack

SQLMetabaseLooker StudioOdoo ERPGoogle Apps Script

Have a similar data problem? Let's talk about it.

Get in Touch