Gavin Cao

Built an AI use case intelligence platform that scrapes leading enterprise sources, classifies them with LLMs, and extracts CEO-level insights (ROI, revenue impact, partners, adoption stage). Delivered executive-ready dashboards (Excel/Markdown) that highlight where AI creates measurable business value and competitive whitespace. I developed an end-to-end system that continuously ingests AI case studies and news from hyperscalers, consultancies, SaaS vendors, and industry hubs. The pipeline automatically classifies use cases with LLMs (Tier A/B/C, industry, B2 type, language) and extracts rich business signals: ROI %, revenue impact, customer segments, partners, decision makers, adoption stage, compliance, challenges, and competitor mentions. The platform transforms unstructured articles into structured insights stored in a database, then generates executive-ready outputs: • CEO one-pager (Markdown/PDF) with ROI, adoption trends, and competitive highlights • Excel dashboards with KPIs, coverage stats, stage mix, Tier-A detail sheets, data quality checks, and provider × industry pivots • Automated Slack/email reports that surface daily intelligence directly to stakeholders This enables leadership and go-to-market teams to instantly see where AI is delivering measurable business value.

Atlas Cloud Quotation Portal Built a Python/JavaScript web application to unify fragmented sales quote forms into a single deal record. The system enforces consistent sales-rep attribution, provides a live dashboard separating incomplete vs. completed deals, and generates consolidated CSV/XLSX exports with client and rep details. Leveraging a lightweight Python HTTP server, SQLite, and custom export logic, I delivered reliable end-to-end workflows, role-specific visibility, and streamlined reporting. This project demonstrates strengths in full-stack development, database design, reliable Excel/CSV generation, and turning messy business processes into clear, auditable workflows. ⸻ Atlas Cloud Inventory Parser Developed a deterministic text-parsing engine in Python to convert unstructured vendor GPU/CPU cluster specifications into structured systems / storage / NICs tables. The parser normalizes irregular formats, extracts hardware attributes, and outputs validated CSV/XLSX files. The design uses regex classifiers, normalization rules, and optional toggles (e.g., strict vs. inferred fabric type) to balance accuracy and flexibility. A golden-set diff harness ensures correctness and consistency across runs.

QEP Payroll Automation Built a Python tool to automate reconciliation of monthly QEP payroll workbooks and CSVs. The system normalizes inconsistent accounting structures, applies JSON-based Schedule-A rules to re-calculate fee blocks, and consolidates expense and revenue data by merchant. Leveraging pandas, I merged multiple metrics across disjointed sources and produced detailed per-merchant reports, including residuals and grand totals for Finance. This project demonstrates strengths in data wrangling, robust CSV/Excel parsing, JSON-driven business-rule logic, and full-cycle financial data reconciliation. ⸻ TSYS Interchange Fee Pipeline Built a fully automated ETL pipeline in Python to transform raw TSYS interchange data into merchant-level summaries. The system resolves five layers of fee keys using chained JSON maps and excludes test merchants to ensure accurate reporting. Using pandas, I executed multi-stage transformations—merging fee metadata, enforcing taxonomy rules, and aggregating seven financial metrics. The final output is a pivot table with clean categories, subtotals, and grand totals—ready for Excel delivery. Showcases skills in ETL design, Python/pandas automation, JSON-based rule engines, multi-index pivoting, and reproducible financial reporting.

• Fostered relationships with community leaders and stakeholders to enhance support for local assistance initiatives. • Built strategic partnerships with businesses and government agencies, increasing resource availability for community services. • Collaborated with organizational leadership to align outreach initiatives with the overall mission and strategic goals. • Trained staff and volunteers in effective communication and community engagement practices, improving program effectiveness.

Solo Research Projects: -The Anticancer Effects of Halofuginone in Human Lung and Colorectal Cancer Cells via Apoptosis -Epigallocatechin gallate (EGCG) and Epicatechin (ECC) exhibits anti-Neuroblastoma and anti-SARS-CoV-2 effects

High Honor Roll | Cumulative weighted GPA : 3.99 | SAT: 1510 | 13 AP Courses

CSCI S-38 | CSCI S-7