Data + AI systems for real workflows

Open to Data & AI Engineering roles

I build data and AI systems that survive real workflows.

I am Weijian (Tim) Zhang, a data engineer and AI-driven pipeline architect. I work across the full chain: ingestion, modeling, retrieval, evaluation, service design, and cloud deployment, with delivery experience spanning Hong Kong GovTech, insurance fraud detection, clinical gait AI, multinational retail enterprise data platforms, and commercial bank data middle-platform programs.

Featured work includes an award-winning SRR Agentic Case Processing System, MCC FWA insurance fraud graph intelligence, GaitGPT bidirectional clinical gait translation bridge, and enterprise warehouse modernization. The resume points here; the portfolio shows the systems.

View Selected Work Start a Conversation

Best Fit

Data Engineer, AI Engineer, applied ML/LLM engineer, or hybrid data + AI product roles.

Strongest Areas

Agentic workflows, clinical/financial AI, retrieval pipelines, data quality automation, and FastAPI services.

What Teams Get

Someone who can connect warehouse discipline, model behavior, and production pragmatism.

Publications, Patents & Awards

External recognition, IP disclosures, and research work in progress.

This is the compact signal layer for outcomes beyond delivery: competition recognition, patent disclosure materials, and manuscript work that is still positioned as in preparation.

Manuscript From Symptoms to Signals

An Evidence-Bounded Bidirectional Framework for Video-Based Gait Informatics; manuscript in preparation.

Patent 01 File-Driven Intelligent Case Processing System and Method for Public-Service Complaint Workflows

U.S. provisional filed 17 Jun 2026, Application No. 64/092,622, covering file-driven intake, retrieval, quality control, rollback, and response drafting.

USPTO electronic acknowledgement receipt for SRR U.S. provisional application 64/092,622
Patent 02 Method and System for Evidence-Threshold-Constrained Translation Between Clinical Gait Semantics and Quantitative Gait Indicators

U.S. provisional filed 17 Jun 2026, Application No. 64/092,416, covering evidence-threshold-constrained translation between clinical gait semantics and quantitative gait indicators.

USPTO electronic acknowledgement receipt for GaitGPT U.S. provisional application 64/092,416
Patent 03 Vision-Link Discovery

Patent disclosure in preparation for multi-model fusion that discovers cross-modal visual relationships inside file knowledge graphs.

Selected Projects

A few systems that show how I think, build, and measure impact.

These projects are arranged around the kind of work I am targeting: hybrid data and AI engineering roles where product usefulness depends on both infrastructure discipline and intelligent workflow design.

Award-Winning GovTech Case

SRR — Agentic Case Processing System

Hong Kong · 2025–2026

Technical Lead · 99.4% contribution · Lingnan Cup 2nd Prize · RMB 10,000 prize · Guangzhou TV segment · CIC AI Award showcase · LUX incubation showcase · U.S. provisional filed · Public reference implementation

Three-stage repo evolution

  1. 01 Original baseline SRR-Case-Processing-System
  2. 02 Agentic system SRR-Agentic-Case-Processing-System
  3. 03 Public showcase srr-agentic-case-processing

12/12 requirements delivered before the public showcase version.

View SRR-Project-Team
3 repository stages from original to public showcase
17 pluggable atomic capabilities
12/12 requirements delivered
TV-Featured Project Evidence SRR was shown in a Guangzhou TV segment covering the fourth Lingnan Cup. The project is presented here as both a working AI system and a public-facing competition case, connecting technical delivery with external recognition.
SRR product video thumbnail showing input parsing and task routing architecture SO_PRD25 product video Background -> pain points -> solution -> future roadmap Open video CIC AI Award video thumbnail showing the SRR workflow showcase CIC AI Award showcase Construction-sector exhibition material built from the SRR workflow story Open video

Situation

Hong Kong public-service SRR handling relied on multi-channel materials, manual routing, historical lookup, and repeated field interpretation.

Task

Turn the process into a controllable case-processing system that could parse ICC 1823, TMO, and RCC inputs, extract A-Q fields, and draft traceable replies.

Action

Designed a seven-layer agentic architecture with 17 atomic capabilities, pgvector + RRF retrieval, three-tier evaluation, Best-of-N repair, and rollback logic.

Result

Delivered 12/12 requirements, then converted the work into a public reference repo, TV-covered case, CIC AI Award showcase material, LUX incubation booth, award proof, and U.S. provisional Application No. 64/092,622.

Code Public SRR reference implementation Open GitHub repository Media WeChat feature coverage Official article and team photos Competition Lingnan Cup case page Case topic and finalist listing Showcase CIC AI Award exhibition context Construction industry AI adoption track Showcase LU Xcelerator (LUX) launch Official Lingnan press release Media LUX on-site exhibition coverage Official WeChat recap
SRR team with senior Architectural Services Department representatives at the CIC AI Award booth
On-site exchange and group photo with senior Architectural Services Department representatives at the CIC AI Award booth.
SRR team presenting during the final defense session
Live Lingnan Cup final moment explaining workflow automation, case routing, and public-service value.
SRR seven-layer agentic system architecture diagram
Seven-layer agentic architecture with parsing, routing, retrieval, quality gates, and fallback logic.
SRR assistant extracting case fields and drafting replies
Interaction view showing extracted fields, similar-case handling, and draft-reply workflow.
Lingnan Cup second prize award photo
Lingnan Cup final: Second Prize for the Hong Kong Lingnan University team.
SRR team celebrating the Lingnan Cup second prize outside Lingnan Hall
Team celebration outside Lingnan Hall after the Second Prize result, with project title and Hong Kong Lingnan University team sign visible.
Close-up of the Lingnan Cup second prize trophy and certificate folder
Second Prize trophy close-up: physical award proof from the fourth Lingnan Cup case analysis final.
Lingnan Cup second prize certificate for the SRR case project
Second Prize certificate naming the SRR case: from paperless handling to automated civic-service workflow.
Award reflection from Lingnan Cup coverage
Award reflections highlight hands-on AI implementation, real business data, and civic-service problem solving.
Official Lingnan College webpage showing competition photo gallery without browser interface
Official website feature: cropped to the webpage itself, showing the SRR team in the Lingnan Cup photo gallery and recap.
Official competition topic listing naming the SRR project
Official topic listing: Hong Kong SRR civic-service processing case among finalist reports.
SRR project team at the Architectural Services Department booth
ArchSD booth evidence: SRR demo setup with the on-site exhibit, certificate, and team members.
Live SRR demonstration to CIC exhibition visitors
Live explanation moment: demonstrating the SRR assistant workflow to event visitors.
CIC AI Award booth discussion around the SRR exhibit
Booth discussion with stakeholders: connecting SRR case intake, routing, retrieval, and response drafting to field-service operations.
USPTO electronic acknowledgement receipt for SRR U.S. provisional application 64/092,622
USPTO acknowledgement receipt for U.S. provisional Application No. 64/092,622, filed 17 Jun 2026.
SRR booth at the LU Xcelerator LUX opening exhibition
SRR booth at the 21 Aug 2026 LU Xcelerator (LUX) opening exhibition, Lingnan University.

Python 3.11+, FastAPI, PostgreSQL 15, pgvector, OpenAI GPT-4o, Cloud Run, Cloud SQL, Docker

Agentic AI RAG Evaluation GovTech
Open SRR GitHub Official competition coverage

InsurTech Graph Intelligence

MCC FWA — Insurance Claims Fraud Graph Intelligence

Enterprise collaboration · 2026

Core Developer · GraphDB foundation · Claims adjudication workflow · Neo4j validation · Spanner Graph-ready design

Pipeline shape

  1. 01 Claim ingestion 38,659 medical claim JSON files
  2. 02 Property graph Claim, Event, Doctor, Hospital, Diagnosis, Receipt, BillingItem, BreakdownItem, AmountFeature
  3. 03 Review workflow Risk paths, related entities, and amount anomalies (graph queries)

Graph first because FWA risk often appears in relationships, not a single field.

38,659 medical claim JSON files converted
1.61M graph nodes generated for entity-level investigation
2.57M edges connecting claim paths and evidence trails

Graph Pipeline

Claim JSON -> Property Graph -> Risk Paths -> Claims Review

The system turns raw claim records into portable nodes and edges, validates paths in Neo4j, and prepares the model for future Google Spanner Graph deployment.

Situation

Insurance FWA review faces high claim volume, sparse confirmed fraud labels, and risk signals that often hide across patients, providers, diagnoses, receipts, and amount patterns.

Task

Create a data foundation that lets reviewers inspect risk paths instead of reading isolated claim fields or opaque model scores.

Action

Converted 38,659 claim JSON files into a 1.61M-node / 2.57M-edge property graph, validated paths in Neo4j with three business queries (claim evidence path / same-item high-amount / provider-clustering), and built portable nodes/edges CSV extraction on a FastAPI async-batch service.

Result

The output shifts the review surface from approve/reject labels to a queryable, traceable evidence chain: suspect paths, related entities, and amount anomalies an assessor can audit. (GNN risk-ranking and a medical-necessity agent are the next-step roadmap.)

Graph Schema 9 node families

Claim, event, provider, diagnosis, receipt, billing, breakdown, and amount-feature entities.

Validation Neo4j local POC

Single-claim path inspection helps explain why entities are linked in a review trail.

Deployment Path Spanner Graph-ready

Portable CSV extraction keeps the graph foundation independent from one graph database.

Project Landing Page MediConCen FWA claims intelligence landing page Open project page Partner Company MediConCen official company page Open official page
Redacted thumbnail of the MCC FWA claim graph preview
Redacted Screenshot Neo4j graph path preview
Redacted thumbnail of the MCC FWA claims processing dashboard
Redacted Screenshot Claims processing workflow UI

Python, FastAPI, JSON/CSV pipelines, Neo4j, Google Spanner Graph-ready design, LangChain/LangGraph, OpenRouter LLMs

Insurance FWA GraphDB Claims Adjudication Explainable Review Healthcare AI

Enterprise collaboration; private claim data and client artifacts are intentionally omitted.

Award-Winning Clinical AI

GaitGPT — Bidirectional Translation Bridge for Clinical Gait Research

Lingnan University · 2026

Architecture Lead · SVIIF 2026 Gold Medal · IFIA Best Invention · Thailand Special Award · LUX incubation showcase · U.S. provisional filed

85/152 quality-gated sagittal rows
14.69 cadence MAE vs Vicon
0.155s stride-time MAE

Demo Video

Paper Manuscript in preparation
Awards SVIIF 2026 Gold + two specials
Patent U.S. provisional No. 64/092,416

Situation

Monocular RGB lowers the hardware bar, but fluent language can hide whether a metric is measurable.

Task

Build an evidence-bounded bridge from clinical language to gait indicators — not a diagnosis.

Action

RGB pipeline plus a three-gate contract before any EvidenceBoundFinding is emitted.

Result

GPJATK vs Vicon on the accepted subset; then SVIIF Gold, two specials, LUX booth, and provisional 64/092,416. Technical agreement, not diagnosis.

News Lingnan official press SVIIF 2026 coverage Media WeChat recap School official account Media Bastille Post External coverage Tech Lingnan ORKT GaitGPT page Technology transfer brief
GaitGPT IFIA Best Invention Award, Thailand NRCT special award, and trophy
SVIIF 2026 special-award proof: IFIA Best Invention and Thailand NRCT award, with Gold Medal materials.
SVIIF 2026 Gold Medal diploma naming GaitGPT
Gold Medal diploma naming the GaitGPT invention at SVIIF 2026, Santa Clara.
USPTO electronic acknowledgement receipt for GaitGPT U.S. provisional application 64/092,416
USPTO acknowledgement receipt, filed 17 Jun 2026, Application No. 64/092,416.
GaitGPT LUX booth with red cloth, awards, and depth camera
GaitGPT booth at the 21 Aug 2026 LU Xcelerator opening, with awards and on-site capture hardware.
GaitGPT LUX booth with three-pillars poster and live gait demo
On-site demo connecting clinical language, metrics, and evidence-threshold gates.
GaitGPT LUX purple backdrop listing bidirectional translation and three-gate validation
Exhibition backdrop listing bidirectional translation, 3-gate validation, low hardware, and self-hosted privacy.
GaitGPT team at the LU Xcelerator opening ceremony backdrop
LU Xcelerator (LUX) opening ceremony, 21 Aug 2026.

Python, FastAPI, Next.js/React, SurrealDB, LangGraph, PubMed, Semantic Scholar, local/open AI providers

Digital Health Clinical AI Literature Retrieval Benchmarking Paper in Preparation SVIIF 2026 LUX

Enterprise Data Backbone

Multinational Retail B2B Data Platform

Multinational retail enterprise · 2023–2025

Data Engineer · B2B finance and operations reporting · Cloud warehouse modernization · SOX-aware delivery

Business data scope

  1. 01 B2B finance domain foundation PNL, B2B, HR, Leasing, orders, contracts, customers, fulfillment, inventory, payment, margin, and approval fields
  2. 02 Reporting and governance B2B refined management datasets, asset map, lineage, dashboard-ready ADS tables, SOX-aware release evidence, and production job monitoring
  3. 03 Cloud warehouse performance Five-layer ODS / DIM / DWD / DWS / ADS architecture with StarRocks materialized-view and model optimization

Enterprise value came from making finance and operations data explainable, reusable, and fast enough for daily decisions.

10TB+ warehouse workload migrated and restructured
3-10 min → 0.8s core analytical queries accelerated with StarRocks
-87.5% ETL runtime reduction after warehouse optimization

Situation

B2B finance and operations reporting depended on fragmented PNL, B2B, HR, Leasing, order, contract, billing, inventory, gift-card, fulfillment, and enterprise-account sources.

Task

Make daily decision data reusable and explainable across finance, operations, and dashboard teams through B2B refined management, data-asset mapping, lineage, and T+0 data quality response.

Action

Migrated 10TB+ workloads, rebuilt ODS / DIM / DWD / DWS / ADS layers, connected CRM / OMS / B2B / gift-card / warehouse / finance sources, and tuned Hive, SparkSQL, StarRocks materialized views, Seatunnel, and scheduling paths.

Result

Improved the finance data foundation by 50%+, cut ETL runtime by 87.5%, reduced disk usage by 38%, improved query speed by 55%, and moved core StarRocks analytical queries from 3-10 minutes to an average 0.8s.

Redacted appreciation note for enterprise retail B2B delivery
Cross-border retail B2B delivery evidence: appreciation material kept as business-context proof.
Retail B2B dataflow diagram across source systems and reporting layers
Dataflow evidence across source systems, data processing, and reporting outputs.
Retail B2B technical architecture diagram
Technical architecture for B2B reporting and financial data operations.
Anonymized retail big data overview diagram with sensitive brand text masked
Enterprise big-data capability overview with sensitive brand text masked by mosaic.

SQL, SparkSQL, Hive, StarRocks, Seatunnel, DolphinScheduler, Tencent Cloud, data lake, ADS reporting tables

Retail B2B Financial Data SOX-aware Workflows Cloud Warehouse StarRocks

Commercial Banking Data

Commercial Banking Data Warehouse

Commercial bank data middle-platform · 2019–2023

Data Engineer · Model-layer maintenance · SQL delivery · Banking stakeholder communication

Banking data discipline

  1. 01 Credit-domain leadership Credit-domain maintenance, limit system upgrade, core lending migration, loan accounts, loan receipts, repayment, and settlement accounts
  2. 02 Model delivery and testing SIT/UAT reports, 30+ issue optimizations, 15 key limit models, physical model landing, and stakeholder confirmation
  3. 03 Warehouse flow and tuning Source systems, data bus, SDATA / SHDATA, domain layers, marts, Impala skew tuning, and UDF repricing-date calculation

Banking value means definitions are stable, lineage is traceable, and downstream reporting can be trusted.

100+ transaction systems integrated in enterprise data work
5 layers warehouse modeling discipline carried into later delivery
50% cross-team model reuse improvement in warehouse architecture work

Situation

Commercial-bank reporting depends on strict definitions for credit, limits, contracts, core lending, loan accounts, loan receipts, disbursement, repayment, settlement accounts, and downstream product indicators.

Task

Support financial, regulatory, and management reporting while leading credit-domain model maintenance, limit-system upgrade work, and core lending migration impact analysis.

Action

Maintained model-layer SQL, delivered SIT/UAT reports, optimized 30+ issue points, implemented 15 key limit models, mapped source systems through data-bus / SDATA / SHDATA / domain / mart layers, and tuned Impala skew plus UDF repricing-date logic.

Result

Built bank-grade delivery habits: clear semantics first, controlled change second, traceable issue handling, stable reporting outputs, and reusable credit / limit / lending model knowledge before presentation polish.

Commercial banking loan lifecycle business object map
Loan lifecycle business-object map: from application and approval to disbursement, repayment, loan receipt tracking, post-loan management, and banking data foundation.
Commercial banking channel and system architecture diagram
Banking channel and system architecture: channel portal, front-office integration, product service layer, data integration, and decision layers.
Commercial banking warehouse data flow from source systems to marts and applications
Banking warehouse flow: source systems, data bus, SDATA / SHDATA, business domains, marts, and downstream applications.

SQL, Impala SQL, Hive warehouse layers, Informatica PowerCenter, banking model maintenance, downstream reporting support

Commercial Banking Data Warehouse Model Layers Lineage Reporting

Capabilities

The work I do best sits where data foundations and AI behavior need to cooperate.

I am most useful when the problem needs both infrastructure rigor and application-layer intelligence: reliable ingestion, clean modeling, retrieval quality, evaluation, and deployment that can survive real-world use.

01

Data foundations

  • SQL, dimensional modeling, and enterprise warehouse design
  • Python pipelines for ingestion, transformation, and validation
  • GraphDB modeling for claims fraud paths, entity links, and adjudication evidence
  • PostgreSQL, MySQL, SQL Server, StarRocks, Hive, Kafka
  • Cross-source reconciliation and downstream reporting reliability

02

LLM and retrieval systems

  • Agentic workflow design with hybrid retrieval and reranking
  • LangChain, LangGraph, OpenAI API, Gemini, and pgvector-based workflows
  • Prompt and evaluation design, including LLM-as-Judge and ablation patterns
  • Graph-based explainable claims review: evidence paths, entity linking, and amount-anomaly queries
  • Document parsing, literature retrieval, semantic search, and response generation pipelines

03

Production delivery

  • FastAPI services, Docker packaging, Linux deployment, and CI/CD
  • Async batch workflows, result tracking, and review-facing API design
  • Google Cloud Run and Cloud SQL for managed deployment paths
  • Monitoring, alerting, and failure-aware workflow design
  • Cross-functional execution with technical and business stakeholders
Engineering

Python, SQL, FastAPI, Docker, Linux, GitHub, Airflow, DolphinScheduler

AI & Retrieval

LangChain, LangGraph, OpenAI API, Gemini, pgvector, Neo4j, PubMed, Semantic Scholar, LLM-as-Judge

Analytics & Cloud

Power BI, Tableau, GCP, StarRocks, SQL Server, PostgreSQL, Google Spanner Graph-ready design

About

I build systems that stay useful after the demo.

My background is anchored in data engineering, but the through-line has always been operational reliability. I started with enterprise data warehouse design and large-scale analytics, then moved into real-time monitoring, AI-assisted workflows, and cloud-native service delivery.

That combination matters because many AI projects break at the seams: weak ingestion, brittle retrieval, unclear evaluation, or deployment paths that are hard to maintain. I enjoy building across those seams so the system behaves as one coherent product rather than a chain of disconnected tools.

I hold an MSc in Artificial Intelligence and Business Analytics from Lingnan University and bring hands-on delivery experience from Hong Kong government innovation work, clinical gait AI, insurance fraud detection, multinational retail enterprise data platforms, and commercial bank data middle-platform programs.

Education

MSc in Artificial Intelligence and Business Analytics (Distinction)

Lingnan University, Hong Kong · 2025–2026

AIBA coursework: Foundation of AI, Business Data Management, Data Analytics & Programming, Healthcare Analytics, Data Visualization, Programming with Generative AI, AI-Based Optimization.

Bachelor of Management · Shenzhen University · 2013–2017

Domain Context

Government services, banking, and global retail

Environments where data quality, business rules, and stakeholder trust are not optional.

Working Style

Systems thinking with delivery discipline

I like architectures that are measurable, explainable, and production-ready from day one.

Resume

The full experience, condensed into one document.

If you want the complete timeline, project detail, and technical background, the resume includes the full version. It is designed to point back to this portfolio, where SRR, MCC FWA, and GaitGPT show the system proof, architecture decisions, and project narrative.

Resume shared separately Full resume is provided separately with the application package.

Snapshot

2019–2025 Enterprise data engineering across banking, retail, and cloud data platforms.

2025–2026 SRR, MCC FWA, and GaitGPT: applied AI systems with evidence, evaluation, and deployment stories.

Core promise Strong foundations, measurable outcomes, and systems that can be maintained.

Contact

If you need someone who can move between pipelines, platforms, and AI behavior, let's talk.

I am especially interested in roles where data reliability and intelligent application design need to work together, not compete with each other.

Best fit

Data Engineer, AI Engineer, Platform Engineer, or hybrid data + AI product roles.