Computer Engineering graduate and Data Analyst with hands-on experience in SQL, Python, relational database modeling, and automated report generation. Proven track record of designing database schemas, synchronizing system data, and building automated reporting workflows that transform raw transactional data into actionable business reports. Strong technical foundation in extracting, transforming, and analyzing data using PostgreSQL, MySQL, Excel, and cloud platforms.
I have a strong track record of building data-driven systems and reporting solutions, including:
1. POFSIS Sales & Analytics Systems - Developed Python and PostgreSQL-backed reporting workflows to compute sales reports, service availment metrics, and real property analytics. Designed database schemas and ensured data synchronization across customer bookings, products, and memberships.
2. MDRRMO Automated Excel Reporting - Designed a MySQL database system with dynamic ODBC synchronization to automatically export and update dynamic Excel reports, streamlining reporting workflows.
3. Expensia Financial Analytics App - Designed transactional database models using MongoDB, building custom date-range reporting modules and dynamic financial dashboards to analyze monthly spending patterns.
4. IT Asset Data Auditing (Nauts and Vectors) - Audited and managed central IT asset databases in Google Sheets and Microsoft Excel, standardizing workflows to improve data integrity and tracking accuracy.
Passionate about writing efficient SQL queries, optimizing database workflows, and turning complex data into clean, actionable dashboards and intuitive business insights.
