endorsedCompleted

ETL & Analytics Platform with PostgreSQL for Veterinary Marketing Company

Services Covered:

Custom Software Development

Industry

Advertising & Marketing

Duration

6 months

Budget

50K - 199K

Start Date

1 March 2020

Team Size

6-10 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

75/100

Good

Project Capability Score (PCS) estimates how capable Nelito Systems Pvt. Ltd. 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

Vet Marketing Pro

Kent, United States of America

Project Summary

Neoito designed the architecture and implemented an ETL and analytics platform for a veterinary marketing-technology company, setting up a PostgreSQL database and connecting it to Google Data Studio. They built approximately 70 API calls and created dashboards to aggregate API and marketing data for redundancy testing and analytics. The client praised Neoito's professionalism, daily communication, and adherence to deadlines; the project was acquired eight months into the partnership.

Key Challenges

Aggregate API call data flows and marketing data flows into a single analytics dashboard.
Build an ETL platform to consolidate disparate data sources for analytics.

Project Deliverables

Project architecture and technical design
PostgreSQL database
Google Data Studio dashboards
~70 API integrations / API calls
Documentation and technology handover

Project Solution

Neoito defined the system architecture, set up a PostgreSQL database to load and store marketing and API data, and connected that database to Google Data Studio for visualization. They developed roughly 70 API calls to pull data from multiple sources for redundancy testing and built dashboards from the consolidated database. Neoito also prepared documentation and transferred technology to the acquiring company when the project was sold.

Project Outcome

Product generated the required data and met architectural goals.
API calls were implemented correctly and supported redundancy testing.
The project was acquired after eight months, indicating commercial validation.
Neoito met deadlines and communicated daily throughout the engagement.

Platforms

Tech Stack

PostgreSQL

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Through Neoito's expertise, a credible and detailed API database was generated, seamlessly contributing to the project's success. It only took eight months before the client's project was acquired by another company. The team was professional and communicative throughout their partnership.”
River Morrell
CEO
Date: 03/05/2021