Prezneil Mayandoc

Prezneil Mayandoc

About

Detail

Data Engineer
Province of Pampanga, Philippines
Contact Prezneil regarding: 
work
Full-time jobs
Starting at PHP180k/month ~USD2.91k/month

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • G
    Senior Data Engineer
    Go For Zero
    Jan 2023 - Apr 2025 (2 years 4 months)
    Wrestled Shopify orders, GA events, and CRM notes into a single Power BI/Tableau dashboard—so every Go For Zero team saw the same customer, from first click to last purchase. Less time arguing, more time acting. ● Built a custom attribution model in Python/R, automated with Airflow, so marketing saw which campaigns brought loyal customers-no more guessing. ● Automated DBT/Airflow data quality checks; set up PowerShell alerts for instant issue detection. Data issues dropped, trust soared. ● Orchestrated a lake house across AWS/GCP with Databricks; analysts queried anything, anywhere-reporting time halved, single source of truth. ● Built ETL of sustainability metrics (Fivetran, DBT, Power BI), pulling from Shopify, logistics, APIs-weekly rep
  • Nium
    Senior Data Engineer
    Nium
    Feb 2020 - Nov 2022 (2 years 10 months)
    Implemented a nightly data relay with Airflow/Fivetran, stitching transactions from dozens of banks into Snowflake. Built DBT models to unify currencies, time zones, and compliance—cut reconciliation from days to hours, enabling finance to close books before EU markets opened. ● Built a Power BI fraud dashboard with real-time DAX outlier detection and row-level security—first flagged transaction stopped before leaving the country, fraud losses down 30% in Q1. ● Overhauled marketing ROI: pulled clickstream/campaign data into BigQuery, built a Markov model in Python, surfaced insights in Looker Studio—marketing shifted 25% of spend to high-performing channels, boosting qualified leads. ● Scripted Python data checks for missing fields, broken
  • H
    Data Engineer
    Healius Limited
    Feb 2013 - Dec 2019 (6 years 11 months)
    Orchestrated a daily pipeline for Healius with Airflow/Python, pulling pathology records from legacy/cloud systems into Snowflake. Error handling caught schema changes overnight, ensuring 7,600+ scientists and analysts had clean, reliable data every morning—no surprises, no delays. ● Built a Power BI dashboard for 2,000+ collection centre managers, surfacing real-time test turnaround outliers and bottlenecks—turnaround times dropped within a month. ● Analyzed years of test results in R, cleaned messy data, surfaced trends, and visualized in Tableau—helped the clinical council spot emerging outbreaks early. ● Designed a star schema for Business Objects, handling joins and mismatched keys—cross-source reports ran in seconds, users stopped dr
Education verified_user 0% verified
  • University of Technology Sydney
    Bachelor of Science - BS, Computer Science
    University of Technology Sydney
    Mar 2009 - Nov 2012 (3 years 9 months)