JOSH DEV PH

ABOUT

SOLVING PROBLEMS THROUGH
ANALYTICS SOLUTIONS.

January 2025 - Present

Consultant

Z-Lift Solutions, Inc.

  • Supported the implementation of enterprise-wide Data Governance and Customer 360 initiatives, improving customer master data quality and reducing duplicate records by 20%.
  • Led the design of conceptual, logical, and physical data models to enable unified customer analytics capabilities.
  • Standardized ETL/ELT pipelines, data definitions, and transformation logic to improve scalability, maintainability, and governance compliance.

March 2024 - Present

Data Analyst & Data Engineer

Unity Outsourcing

  • Designed and implemented a centralized data warehouse capturing over 90% of organizational project management data.
  • Optimized Power BI datasets and refresh processes, reducing refresh times from 4 hours to 5 minutes.
  • Delivered dashboards and reports covering approximately 80% of business reporting requirements.

November 2024 - January 2025

Data Engineering Consultant

FTW Foundation

  • Designed and developed the organization's internal data warehouse to support analytics and reporting initiatives.
  • Established foundational data structures and ETL processes for scalable reporting.

April 2022 - November 2024

Business Intelligence Specialist, ETL Developer

SM Prime Holdings, Inc.

  • Implemented an AML sanction screening platform achieving approximately 85% screening effectiveness.
  • Developed automated workflows that reduced tardiness memo processing from 3 days to 10 minutes.
  • Built and optimized ETL pipelines that reduced report delivery times from 2-3 hours to under 5 minutes.

May 2023 - December 2023

Software Developer

Pivotal Peak Digital Health Solutions

  • Led performance enhancements for a patient blood pressure registry, improving application responsiveness by 10%.
  • Delivered technical training and system onboarding to 37 Rural Health Units across three provinces.

September 2022 - September 2023

Python Developer

Freelance

  • Developed Python automation tools integrating web scraping and APIs to streamline business processes.
  • Automated e-commerce account provisioning workflows, reducing manual effort by 40%.

June 2020 - March 2022

Business Systems Support

Collabera Philippines

September 2019 - June 2020

Communications Coach

iOPEX Technologies

April 2016 - September 2019

Associate Training Officer

Sykes Philippines

CERTIFICATIONS

Databricks Certified Data Engineer Professional

Databricks · August 2026

Microsoft Certified: Fabric Analytics Engineer Associate

Microsoft · May 2024

TECHNICAL SKILLS

Data Engineering

ETL/ELT, Data Warehousing, Data Modeling, Data Integration, Analytics Engineering, Databricks

Programming

Python, SQL, R, VBA

Analytics & BI

Power BI, Microsoft Fabric, DAX, Power Query

Databases

SQL Server, PostgreSQL, MongoDB, Amazon Redshift, Snowflake

Tools & Platforms

Azure, AWS, SSIS, Prefect, Docker, Flask, FastAPI, Linux, Git

EDUCATION & TRAINING

Forecasting and Time Series Analysis

University of the Philippines National Engineering Center (UP NEC) · August 2026

Prescriptive Analytics

University of the Philippines National Engineering Center (UP NEC) · August 2026

BS in Business Administration major in Marketing Management

Polytechnic University of the Philippines

MY EXPERTISE

I design and build end-to-end analytics solutions, including ETL/ELT pipelines, dashboards and reports, and machine learning models that aim to address business challenges.

My experience spans SQL, Python, Databricks, Microsoft Fabric, Talend, SSIS, Docker, API integrations, data modeling, and automation.

I care about solutions that are technically sound but also understandable, maintainable, and tied to a real business outcome.

DOWNLOAD MY RESUME

CORE DATA PRACTICES

DATA
ENGINEERING

Designing and building scalable data pipelines and data platforms. Designs business data models for better performance and scalability.

DATA
ANALYTICS

Turning data into insights through analysis and visualization. Creating reports and dashboards to communicate findings effectively.

MACHINE
LEARNING

Train machine learning models to uncover patterns and make predictions. Balances technical excellence with business relevance.

AUTOMATION
& OPTIMIZATIONS

Identify process bottlenecks and implement solutions to improve efficiency and data quality.