Projects
Work experience, self-built case studies and course projects, by task and industry.
Select a number, a task or an industry in the table to see the projects.
| Task / Industry | All | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| – | – | – | – | – | – | – | – | 4 | |||
| – | – | – | – | – | – | 6 | |||||
| – | – | – | – | – | – | – | – | 3 | |||
| – | – | – | – | – | – | – | – | 2 | |||
| – | – | – | – | – | – | – | 5 | ||||
| – | – | – | – | – | 5 | ||||||
| – | – | – | – | – | – | – | – | 4 | |||
| – | – | – | – | – | 6 | ||||||
| – | – | – | – | – | 6 | ||||||
| – | – | – | – | – | – | – | – | 2 | |||
| All | 3 | 1 | 2 | 2 | 10 | 5 | 2 | 3 | 3 | 1 | 32 |
3 work experience 1 self-built case study or course project
Work experience
Results from paid roles at Embedded Capital, UrBox, Grant Thornton and KPMG.
One renewal workflow across 25K insurance policies
Standardized renewal workflows and documented 90/60/30-day outreach, task routing and response tracking. Churn fell from about 25% to about 20%.
Self-service KPI dashboards for 3 portfolio firms
Launched self-service Applied Epic dashboards on churn, producer revenue and KPIs for 15+ users. Weekly report preparation fell from about 10 hours to about 7 hours.
Diagnosis of a gross-margin drop from 19% to 15%
Tested 3 demand hypotheses in SQL against a control and traced the drop to zero-margin gold vouchers. A pilot fee lifted the margin to 18%.
SQLPricing model for the Vietnam Airlines loyalty redesign
Modeled point-balance segments and pricing. The projected redemption uplift of about 30% won partner approval for the Cash & Miles launch.
Customer discount tiers across 15 categories and 50K SKUs
Rebuilt the tiers against supplier rebate economics. Gross spread widened by about 1 point on 10+ major renewals.
Reusable gift-allocation engine
Persuaded the CEO, the CFO and business teams with Excel demos to adopt the engine, and translated client KPIs into logic later used by 90% of loyalty clients.
ExcelMarket sizing for a voucher-based salary advance
Sized the market by industrial zone, worker eligibility and usage frequency. The new business line launched and signed its first 2 employer clients.
Request intake and prioritization across 4 teams
Ran a 2-week Jira cycle for 10 to 20 requests, balanced developer capacity and reported weekly to the CEO and CFO. On-time delivery rose from about 50% to about 70%.
Finance transformation across 10+ clients and 4 departments
Led a 2-year program with Product and Engineering that automated transaction verification and saved an estimated 10,000 hours each year.
In-web wallet and expiry alerts for multi-card users
Segmented web users by gift-card holdings and expiry data, and pitched the two features to the CEO. Mobile-app users grew 50% in 12 months.
Annual budget for a $60M+ operating plan
Owned the budget across revenue, operating expense, headcount and margin, and set KPIs for monthly CFO reviews. The cash conversion cycle fell 15% in 12 months.
Monthly P&L reporting for a $60M segment
Standardized the Tableau reporting. Executives got sales, cost and margin variance by business line and channel 5 business days faster.
TableauRevenue and margin bridge for a steel-pipe business
Directed a bridge across price, volume, mix, cost, rebate and timing. It traced Q4 export rebates and supported a revenue adjustment of about $430K.
Cost-monitoring framework for a manufacturing client
Analyzed COGS drivers with client management and identified $300K of annual savings opportunities.
Budget dashboards for a client CFO
Developed Excel and VBA dashboards across 5 branches and 4 functions that track monthly expense against budget. Package preparation went from 2 days to the same day.
ExcelVBARevenue recognition timing on an EPC contract
Challenged the timing against the contract terms. The treatment moved to percentage-of-completion, with a downward adjustment of about $500K that the client adopted.
Self-built case studies
Cases that I built on my own with public data. They are not client or employer work.
Course projects, Michigan Ross MBA
Analytics coursework from the MBA program, rebuilt in my own format. They are not client or employer work.
Where to build fire stations so every region is within 12 minutes
Two of six candidate sites are enough, for $700,000. One minute faster costs 64% more.
ExcelPythonWhich supplier bids to accept in a packaging auction
Four of 12 bids buy every item for $4,470. A strategic-partner policy adds 27%; a local-supplier policy adds nothing.
ExcelPythonHow many rooms to hold back for late guests who pay more
Hold 4 of 10 cabins for a full rate of $260. Revenue per night rises 39% against one low rate for all cabins.
ExcelPythonHow many workers to hire and when, for a factory with seasonal demand
A mixed plan of hires, overtime and inventory costs $6.22M for the year, 8% less than a level workforce.
ExcelPythonHow much to bid in a sealed auction when a win needs a later approval
Bid $4.11M, not the planned $5M. The expected value rises 35%, but the bid wins only 12% of the time.
ExcelWhich customers to call in a bank telemarketing campaign
Call the 16% of customers with a sale probability of 17% or more. Profit is twice the profit at the usual 50% cutoff, and a plain logistic regression beats six other models.
RWhich employees to approach with a retention offer
Approach the 15% of employees with a leave risk above 67%. The offers reach 92% of the leavers and save $2.6M for 3,598 employees.
RHow many rooms a hotel can overbook, given the cancellation risk of each booking
A model of cancellation risk recovers 12,093 cancelled bookings in the test period and turns away 95 guests. A flat-rate rule turns away 868.
RWhich new tracks a music label must promote first
A model picks a top 10% of new tracks in which 77% are hits, against 26% for all tracks. Genre and the record of the artist decide; the sound adds little.
RHow to reprice 15 products when price sensitivity differs by product
Raise 12 prices and cut 3. Expected profit per customer rises 31%, with each price inside a ±20% limit.
RWhether more listings help or hurt hosts in a vacation rental market
They hurt. 10% more listings cut the booking confirmation rate by 1.7 points. A plain regression shows no effect.
RWhere the growth and the credit losses of a marketplace lender come from
Loans grew 224 times from 2007 to 2013. The charge-off rate rises from 6% for grade A loans to 37% for grade G.
TableauWhich classroom projects get funded on a school crowdfunding site
70% of projects reach their goal. Price matters most: 90% of projects below $200 are funded, and 45% of projects above $1,500.
Tableau
Practice and personal projects
LeetCode SQL 50
All 50 problems solved, in 7 topic groups
SQLLeetCode pandas problems
14 problems solved, in 3 topic groups
PythonStoryLilt.app
Shipped the app and built a multi-agent translator with quality checks. About 30 books translated.
No project matches these filters.