Database Synchronization Specialist | Mews & Onda Integration
Ben Hansen
Like this project
Posted Jan 8, 2025
Synchronized data between Mews and Onda’s PostgreSQL database to enable seamless integration with Tableau for real-time financial reporting.
Likes
0
Views
6
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.
Key Responsibilities:
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.
Tech Stack:
Database: PostgreSQL
Visualization Tool: Tableau
APIs: Mews API, Custom Data Pipelines
Impact:
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.