Economics at Binghamton University
Business & marketing analytics.
I use SQL, Python, and customer research to answer business questions. My recent work includes advertising reports for 99 products and an outreach recommendation based on 2,857 stakeholder records.
BA Economics · Accounting minor · Class of 2028
Selected work
Six projects across internships, externships, and independent analysis. Start with a finding, then follow the work behind it.
UCI wholesale customers / Annual spending
42.9%of recorded spending came from
the highest spending 20% of customers.
88 of 440 records · Historical public data
Customer Segmentation & BI · Public data
I compared purchasing patterns across 440 wholesale customers and used SQLite to reconcile the totals. The interactive report lets you inspect spending by customer type and region.
View the analysisBreaking Games
SQL reporting for 99 products, checks on joins, and a five KPI dashboard. The missing results covered 34.7% of analyzed ad spend.
SQL reporting · Campaign measurementNew Yorkers United for Child Care
Excel analysis of 2,857 stakeholder records, regional research, and an audit of 74 Instagram posts and 48 email sends.
Market research · Audience planningRomin
Competitor research, weekly tests across 50+ ad variations, and customer feedback discussions with developers.
Product marketing · ExperimentationAlso: competitor research automation and restaurant sales analysis.
View all six projectsWork samples
These exercises use invented data. Each includes source tables and calculations you can inspect or download.
Joining orders directly to advertising records repeats some sales. Aggregating each source by product first brings the report back to the original total.
Revenue · Same scale from $0 to $500
Version B has a higher signup rate, but this sample is not enough to declare a winner.
Signup rate · Scale from 0% to 10%
| Version | Visitors | Signups | Signup rate |
|---|---|---|---|
| A | 1,200 | 60 | 5.0% |
| B | 1,200 | 72 | 6.0% |
The difference is 1 percentage point. Its approximate 95% uncertainty range runs from negative 0.82 to positive 2.82 percentage points.
Focus areas
Business analysis and marketing are my main interests. Browse a field for the relevant projects and worked examples.
SQL reporting · Data quality · Recommendations
Campaign measurement · Experiments · KPIs
Audience workflows · Onboarding · Reporting
Operating decisions · Process improvement · Analysis
Regional research · Segmentation · Customer insights
Positioning · Customer benefits · Creative testing
Related interests include data, strategy, product, and AI workflows.
Browse all focus areasExperience
Internships, an externship, and a part time product marketing role.
Digital Organizing Intern
SQL & Database Architecture Extern · Extern Program
Product Marketing & Strategy Lead (Part time)
Business Operations Intern
About me
I study Economics at Binghamton University and minor in Accounting. I’m interested in customer research and the analysis behind marketing and operating decisions.
At NYUC, I revised regional recommendations after staff feedback. At Romin, I worked with developers on customer feedback and product updates. Through Binghamton’s Marketing Association, I explain marketing concepts and support fellow members.
A/B testing · Market research · Positioning · n8n · Gemini
Competitor research workflowContact
Email me about a project or an opportunity to work together.
richielin02@gmail.com Contact details