Client:

API:

Data Integration:

I synchronized the database between Mews and Onda’s personal PostgreSQL database to enable seamless integration with Tableau for real-time data visualization and daily financial check-ins.

Database Synchronization: Established and maintained routine syncs between Mews’ API and Onda’s internal PostgreSQL database, ensuring consistent and reliable data transfers.

Data Organization: Structured and optimized the data to make it easily usable within Tableau, enabling Onda to conduct efficient daily financial reviews and reporting.

Automated Workflows: Automated data sync processes to reduce manual intervention and ensure timely updates for accurate financial tracking.

Database: PostgreSQL

Visualization Tool: Tableau

APIs: Mews API, Custom Data Pipelines

Improved Onda’s financial reporting accuracy by ensuring that their internal database was always in sync with the latest data from Mews.

Enabled Onda to make more informed business decisions by providing them with a reliable and up-to-date data source for their daily financial check-ins.

This project demonstrates my expertise in database management, data integration, and workflow automation, showcasing my ability to streamline data pipelines for business intelligence tools.