Bill Yang

Business Analyst — Testing Strategy

Ran a 3-week rapid deep dive into the testing strategy for a $3.5bn migration program, designing and delivering 10 stakeholder workshops with the Deloitte UK team, culminating in a current-state assessment and implementation roadmap.

Technical BA / PM — Business Rules Engine

Led 3–4 workstreams delivering a Databricks + Prophecy business rules engine, facilitating technical forums of 50+ attendees across engineering and business teams and driving the platform to an on-time, in-scope go-live.

Data Analyst / Engineer — Data & Insights

Built a GenAI workflow using Claude 3.7 to convert legacy SAS scripts to Snowflake SQL, engineered PII masking across hundreds of files, and wrote ETL stored procedures — cutting delivery time and resourcing cost by 50%.

Data Strategy Consultant — Business Data Platforms

Co-authored a data governance framework and ownership model as part of an IPO-readiness data strategy, engaging 20+ stakeholders across 21 workshops to shape a prioritised initiatives roadmap.

Business Analyst — Data Management Tooling

Ran the RFP process to select an Enterprise Data Management tool vendor, designing the scoring model and leading consensus and shortlist presentation sessions with 10 business owners.

Business Analyst — Generative AI Risk & Compliance MVP

Delivered a GenAI copilot to streamline compliance-assessment workflows handling 16,000+ incidents a year — the first of 5 pioneer GenAI use cases piloted into production.

Gen AI Engineer — Policy Simplification POC

Deployed LLM API endpoints in Azure ML Studio to summarise lengthy policy documents, designing evaluation metrics to benchmark GPT-4o, GPT-4, GPT-3.5 and Llama 3 on compression quality.

Data Engineer — Databricks Data Platform MVP

Built an ETL pipeline consolidating 6 data sources into a Databricks Unity Catalog Lakehouse (Bronze/Silver medallion layers) with Terraform-managed CI/CD — eliminating the client's prior data loss entirely.

Data Strategy — Business Recommendations

Advised on maturing the client's predictive ML modelling and MLOps processes, delivering a roadmap for more efficient stakeholder communication and legacy-system migration.

Financial Crime Data Analyst Intern

Automated a Python archiving system that eliminated a backlog of tens of thousands of output files and cut one job's runtime from 20 minutes to 50 seconds — a 24x speedup. Migrated legacy SAS code to Python, cutting runtime by 54% and turning a 3-step process into one, while using Power BI, SAS and SQL to extract data from Oracle databases and handling ad-hoc analysis requests for stakeholders in a highly confidential environment.