Fortune 100 data expertise — without the Fortune 100 price tag.

I'm Bing Yi. I spent eight years building data systems inside Capital One and IBM — pipelines, dashboards, and CRMs used by thousands of reps and millions of accounts. Now I build them for growing companies.

Where I learned it
Capital One Senior Data Analyst
2020–2024
IBM Consultant, Global
Business Services · 2016–2018

Also: Baker Tilly (M&A strategy) · Texas A&M (M.S.)

2.4M
customer accounts on an activation strategy I led at Capital One
$80M+
incremental purchase volume it has generated
$10B+
purchase volume covered by territory pipelines I built in Snowflake
500+
sales reps on a Salesforce org I ran solo
01 — Selected work

Systems built for real clients.

Scrap-metal recycler Live

Buyer performance dashboard

Monthly buyer and yard reporting: Google Sheets in, executive dashboard out.

View live →
U.S. Census data Live

Territory analytics

County-level choropleth: pick a state, color it by income, population, or growth.

View live →
800-family dance studio

Parent portal + enrollment sync

Rebuilt their portal in Django and traced 900+ enrollments the old sync had dropped.

Dance-studio parent portal dashboard
Sales analytics Live

Looker Studio reporting

A Looker dashboard, embedded live.

View live →
PIM SaaS clients

Product-data migration

Moved 20,000+ product photos and 93 metafield mappings between systems, byte-checked.

20,873
Payments flow

Stripe → CRM automation

New Stripe payments create and update Close CRM records on their own. AWS Lambda.

Stripe → Close
  • US Coast Guard HR — applicant-system data APIs, IBM Cognos + Power BI
  • Columbia School of Engineering — website analytics & reporting
  • $20M+ senior-healthcare marketing group — campaign ROI analysis
02 — What I do

Pipelines & warehouses

Snowflake, BigQuery, dbt, Python, SQL. Data that arrives on time, checked.

Dashboards & reporting

Tableau, Power BI, Looker Studio, or straight to the web.

CRM & automation

Salesforce, HubSpot, REST APIs, Zapier, n8n. Systems that update themselves.

03 — In their words
“I think Bing is a phenomenal at financial modeling and budgeting. We had very specific needs and we got what we needed and also recommendations on how to further improve...”
Budget Template (Nonprofit Financial Modeling Expert)
“Excellent work by Bing. Helped our tech startup SaaS company set up a robust data warehouse infrastructure. Professional, efficient, and delivered exactly what we needed.”
Big Data warehouse consulting services
“Bing is awesome! I was stumped on one calculation for hours, regardless of what I personally tried I could not tie the numbers together. I sincerely appreciate the instant help...”
Financial Analyst - Excel Experience
“Bing was great at communicating what he could do. Was refreshingly honest and straight forward. Worked quickly.”
GA4 expert needed to finish creating a report - quick turnaround
“Bing built a fully automated pipeline that replaced hours of manual reporting every week. Clean code, well-documented, and he walked me through the whole setup. Highly recommend.”
Python Data Pipeline & Reporting Automation
04 — Get in touch

Have a data problem? Tell me what's broken — I'll tell you how I'd fix it.