Đức Trần • analytics engineer

Đức Trần / DUSTIN

Clear data.
Confident decisions.

Data engineering, grounded in business.

I’m Đức Trần (Dustin). With experience in data pipelines and enterprise ERP, I connect data engineering with the realities of business operations.

Explore my work Download CV Get in touch
Đức Trần (Dustin)
PEOPLE'S POLICE (CAND)
IT SUPPORT and Operations
BRAVO HCM
ERP Implementation Specialist
Estuary Solution
Junior Data Engineer
univ of Finance marketing
Valedictorian GPA 3.7/4.0

Selected work.

From source data to analytical models, and the enterprise systems I have helped implement.
Data Pipeline
⤢
SQL Server → Snowflake

AdventureWorks Modern Data Platform

Production-grade ELT pipeline syncing SQL Server CDC to Snowflake Bronze/Gold via dlt (Python), modeled with dbt Core and visualized in Metabase BI.

dbt Core Snowflake dlt SQL Server CDC Docker
Enterprise ERP
⤢
THACO / Loc Phuc

Enterprise ERP BRAVO (THACO & Loc Phuc)

Implemented purchasing, inventory, and accounting workflows at THACO and jewelry material-loss tracking at Loc Phuc Jewelry.

SQL Server SSIS T-SQL FIFO Costing Power BI
Big Data
⤢
Spark → Delta Lake

End-to-End Big Data Lakehouse with Spark & Airflow

A distributed data pipeline using Kafka, PySpark Structured Streaming, Delta Lake, and Airflow orchestration.

Apache Spark PySpark Kafka Delta Lake Airflow
Data Pipeline
⤢
Infrastructure / CAND

Round-the-Clock IT Infrastructure / People's Police

Supporting networks, the National Population Database, and GTEL emergency fire alarm systems for the Fire Prevention, Fighting & Rescue Police Team, Area 15.

Linux Ubuntu pfSense VLAN WireGuard Monitoring
01 EXECUTIVE STATEMENT // BUSINESS OVERVIEW

Bridging the Gap from Raw Transactions to Executive Decisions

01 // OPERATIONAL CONTEXT & SCOPE

I build automated reporting and analytics systems serving mission-critical units: Executive Leadership (BOD), Procurement, Warehouse Operations, and Commercial Sales. Replacing cumbersome manual spreadsheets, the platform automatically updates business performance, delivery schedules, safety stock alerts, and revenue metrics the moment transactions occur.

02 // BUSINESS VALUE & STRATEGIC BRIDGE

Grounded in enterprise ERP implementation across dozens of large-scale business workflows, I deeply understand end-user pain points when reported numbers diverge from operational reality. Rather than passively waiting for tech tickets, I actively collaborate with department heads to dissect core questions: What decision does this metric drive, and how does it impact cash flow? From there, I transform raw data into audit-ready KPI engines that drive productivity and protect gross margins.

SOURCES MANAGED ELT DATA LAKE LOAD WAREHOUSE + TRANSFORM CONSUMERS direct sync → Snowflake (skip S3) client SaaS apps CRM · ads · billing client databases Postgres · MySQL </> client APIs REST · webhooks event streams Snowplow · Segment flat files SFTP · spreadsheets Fivetran managed connectors Automated ELT · CDC 150+ SOURCES sync: 5-min batch S3 Lake raw archive daily partitions PARQUET COPY INTO S3 → Snowflake external stages FAST LOAD Snowflake + dbt Snowflake DW raw · analytics schemas dbt models stg → int → marts dbt Tests & CI/CD PR checks · schema audit dbt build ✓ omni Omni BI BI · dashboards Client Teams embedded · self-serve Apache Airflow schedules ingestion · dbt runs · data-quality checks · CI/CD
⚙️ Explore a data node
STAGE DETAIL

Select a node in the diagram to explore its architecture and example code. 

-- Data node source code
02 CAREER // WORK EXPERIENCE

Work Experience.

Hands-on trajectory from engineering my first data pipelines and enterprise ERP consulting to 24/7 mission-critical IT infrastructure operations.

05/2025 - PRESENT

People's Police (CAND)

HO CHI MINH CITY, VIETNAM

IT Support & Operations

Infrastructure & National Database

Directly operating, maintaining, and providing 24/7 mission-critical IT support in a high-discipline environment: managing internal LAN infrastructure, National Population Database operations, automated fire alarm transmission systems, and digital document workflows across administrative units.

  • Configured and managed internal LAN/VLAN networks, enforcing network security policies and secure routing across operational departments.
  • Administered and operated the National Population Database system - ensuring high availability, data integrity, and strict security compliance.
  • Monitored and maintained 24/7 automated fire alarm transmission systems, ensuring zero-downtime communications for command and emergency dispatch.
  • Deployed and provided end-user technical support for digital document workflows, eliminating paperwork and accelerating administrative turnaround.
LAN / VLAN National Database Fire Alarm Systems Document Workflow Network Security 24/7 Operations
01/2024 - 02/2025

BRAVO Software JSC (BRAVO ERP)

HO CHI MINH CITY, VIETNAM

ERP Implementation Specialist

Purchasing, Warehouse & Asset Management

Consulted, configured, and deployed enterprise BRAVO ERP systems across complex production and retail workflows for tier-1 enterprises (THACO, Loc Phuc Fine Jewelry). Bridged real-world business requirements with underlying relational data models in SQL Server.

  • THACO Project (Truong Hai Auto): Deployed Purchasing Management module - standardized PR → PO → Receiving flows; engineered stored procedures for procurement tracking and vendor debt reconciliation.
  • Loc Phuc Fine Jewelry: Implemented Purchasing, Inventory & Asset Management modules - designed strict material yield tracking achieving 0.01g precision for precious jewelry manufacturing.
  • Engineered and optimized dozens of complex Stored Procedures, Views, and SQL queries for executive BI reports, reducing month-end data processing time by 70%+.
  • Led Data Migration and Validation from legacy databases to ERP; trained key business users and resolved real-time operational tickets during high-stakes go-live phases.
SQL Server Bravo ERP Framework Stored Procedures Data Migration Purchasing Module Warehouse 0.01g Audit Performance Tuning
06/2023 - 08/2023

Estuary Solution

HO CHI MINH CITY, VIETNAM

Junior Data Engineer

First Data Pipelines & Reporting Foundation

The foundational launchpad for my data engineering journey: where I first built production data pipelines, implemented end-to-end ETL jobs extracting raw records, and developed operational analytics reports.

  • Built foundational ETL pipelines: ingested raw transactional records from disparate sources, applied data cleaning and standardization before loading into analytical schemas.
  • Developed initial business intelligence reports and operational dashboards, visualizing key operational KPIs for data-driven business reviews.
  • Applied Python scripting and SQL to automate recurring data jobs, replacing repetitive manual spreadsheet manipulation with automated runs.
  • Cultivated core data quality mindset: understanding data lineage principles, data verification, and reconciliation from source transactions to final business metrics.
Python SQL Server ETL Pipelines Data Reporting Data Cleaning Data Quality
CAREER CHRONOLOGY // MILESTONES

Key Milestones & Growth Trajectory.

Defining milestones that shaped my journey: from UFM Valedictorian and enterprise ERP implementations to 24/7 public safety infrastructure and modern analytics engineering.

05/2025 - PRESENT

🔥 Public Security Duty - Infrastructure & IT Support & Operations

Fire Prevention, Fighting & Rescue Police Team Area 15
03/2026

🏆 Data Engineer Associate Certificate - DataCamp

DataCamp Professional Certification
01/2024 - 02/2025

⚙️ ERP Implementation Specialist

BRAVO Software JSC (BRAVO ERP)
01/2024

🏅 SQL (Advanced) Certificate - HackerRank

HackerRank Skill Certification
06/2023 - 08/2023

💻 Junior Data Engineer

Estuary Solution
10/2020 - 04/2024

🎓 University of Finance - Marketing (UFM)

Class Valedictorian - GPA 3.7 / 4.0
Verified Credentials

Professional certifications & Academic credentials.

Professional assessments of SQL and data engineering skills, alongside my academic qualifications.

HackerRank SQL (Advanced) Certificate
VERIFIED CREDENTIAL • TOP GLOBAL

HackerRank SQL (Advanced)

Advanced SQL certification covering window functions, recursive CTEs, gaps & and islands, and complex query problems.

✓ Validated • Certified Verify certificate ↗
DataCamp Data Engineer Associate Certificate
ASSOCIATE CERTIFICATION

DataCamp Data Engineer Associate

Assessment of data pipeline design, warehousing, modeling, data quality, and cloud security foundations.

✓ Validated • Certified Verify certificate ↗
🎓
Valedictorian / GPA 3.7/4.0
UFM / BACHELOR'S DEGREE WITH DISTINCTION
ACADEMIC EXCELLENCE • OFFICIAL LOOKUP

Management Information Systems Valedictorian / UFM

Graduated as class valedictorian in Management Information Systems with a GPA of 3.7/4.0. Open the degree details and use the official UFM portal to verify the record.

✓ MSSV: 2021010131 Look up degree →
SELECTED

writing

Reflections on university, enterprise projects, service discipline, and the path to Analytics Engineering. Open an article to read the full story.

FEATURED ARTICLE / TECHNICAL DEEP DIVE

Deep Dive: Building a Data Platform with CDC, dlt, Snowflake & dbt Core

How can OLTP transactions reach a cloud warehouse with low latency and limited production impact? A detailed look at Change Data Capture, LSN-based deduplication, and Kimball star schemas.

March 5, 2026 • 12 min read Read the full article →
CAREER DEVELOPMENT 7 min read / March 20, 2026

From UFM Valedictorian to Analytics Engineering

➔
ERP ARCHITECTURE 9 min read / February 15, 2026

Lessons from Implementing ERP at THACO & Loc Phuc

➔
SERVICE DISCIPLINE 8 min read / January 28, 2026

18 Months in the People's Police: Looking Inside Network Infrastructure

➔
DISCIPLINED LEARNING 6 min read / December 18, 2025

Learning Data Engineering During Service & Earning Professional Certifications

➔
Browse All Five Blog Posts ➔
Get in Touch

Let's start a conversation.

I welcome conversations about data architecture, enterprise data modeling, and opportunities to work together.

Contact details

Send an email, connect on a professional network, or use the form to send a question draft.

EMAIL trandc3015@gmail.com
PROFESSIONAL NETWORKS
BASED IN
Ho Chi Minh City, Vietnam

Your message opens in your email app. Review the draft and press Send there.

🎓
UIS UFM / OFFICIAL DEGREE LOOKUP

Degree Verification / University of Finance - Marketing

LOOKUP DETAILS USE THE UNIVERSITY PORTAL TO VERIFY
Full name
TRẦN ĐỨC
Student ID
2021010131
Date of birth
22 (22/04/2002)
✓ DEGREE DETAILS / UIS UFM LOOKUP
Certificate number: UFM-7017587
Full name TRẦN ĐỨC (Tran Duc)
Student ID 2021010131
Date and place of birth April 22, 2002 / Ho Chi Minh City (Male)
Degree level & Study mode Bachelor's / Full-time (DHCQ2020 cohort)
Field of study Management Information Systems
Specialization Business Informatics
Graduation classification Excellent / Class valedictorian, GPA 3.7/4.0
Degree certificate number UFM-7017587
Degree register number 3292/20DTH3_3/2024
Graduation year / Issue date 2024 / Issued November 11, 2024
Open the UFM Lookup Portal ↗

* Use the University of Finance - Marketing's official degree lookup portal to verify these details (uis.ufm.edu.vn/TraCuuVanBang). Opening the portal also copies student ID 2021010131 for convenient lookup.

Email copied: trandc3015@gmail.com