Enosis Outsourcing logo
EndorsedendorsedOngoing

Custom Data Portal Dev for Cannabis Retailers Collective

Services Covered:

Custom Software Development • Website Development
Project hero — replace with case study imagery
Industry
Industry

Agriculture

Duration
Durationinfo-circle

9 months

Budget
Budget

50K - 199K

Start Date
Start Date

1 May 2022

Team Size
Team Size

1-5

Engagement Model
Engagement Model

Offshore

Project Capability Score (PCS)

gauge meter
72/100
Good

Project Capability Score (PCS) estimates how capable Novatore Solutions is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

map Canada

Project Summary

Novatore Solutions developed a custom data portal for a retail cannabis collective, building ingestion, reconciliation, and analytics capabilities using PostgreSQL, React.js, and Power BI. The vendor implemented a reconciliation engine that normalizes multiple input formats and produces reports and invoices for producers and retailers. The engagement began with a discovery phase and remains ongoing since May 2022.

Key Challenges

  • Build a data portal to collect and reconcile retailer data
  • Translate reconciled data into industry analytics for partners

Project Deliverables

  • A custom data portal built from discovery through implementation
  • Data ingestion capability for retailers to upload or connect POS data
  • A reconciliation engine that normalizes multiple report formats and produces clean reports and statements
  • Analytics visualization UI (Power BI) for users
  • API connections to POS providers for automated data pulls

Project Solution

Novatore Solutions conducted a discovery phase and developed the portal from scratch using PostgreSQL and React.js with Power BI for analytics. They built data ingestion pipelines and connectors to allow retailers to send data, developed a reconciliation engine to normalize multiple report formats and generate statements and invoices, and are building the UI and API integrations to connect to POS providers for automated data retrieval.

Project Outcome

  • Processes an average of 2 million lines of data per month from retailers
  • Reconciliation throughput improved from roughly three weeks to results provided within a day (retailers now have one week to upload; engine returns results within a day)
  • Novatore met project deadlines approximately 90% of the time

Platforms

  • WebWeb

Tech Stack

  • PostgreSQLPostgreSQL
  • React.jsReact.js

Client Endorsement

Overall Review Rating

4.5star

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Novatore Solutions has developed a reconciliation data system that processes an average of 2 million data lines per month, improving the client’s processes significantly. They communicate effectively through Google Meet and WhatsApp. Novatore Solutions uses Git for project management.”

Shakir Tayabali

CEO

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by Novatore Solutions

See All Projects by Novatore Solutions