# Business operations · experience and example brief

Richie Lin · Experience and work samples

I’ve used sales patterns to redesign product bundles, built reporting for inventory decisions, and connected recurring research to a reporting workflow.

## Relevant experience

### Operational improvement

Analyzed sales in Excel and redesigned product bundles, with a reported 30% improvement in featured combo selection.

Working principle: Evaluate a bundle change with a defined customer choice metric.

Case: https://richielin.com/pages/poke-inn

### Planning & reporting

Built SQL reporting for 99 products and a Holiday Game Plan with inventory and marketing recommendations.

Working principle: Product performance can inform inventory priorities when the reporting is consistent.

Case: https://richielin.com/pages/breaking-games

### Repeatable workflows

Automated competitor monitoring and Sheets updates, then organized the research in reports and a presentation.

Working principle: Recurring research is easier to review when its inputs share a common structure.

Case: https://richielin.com/pages/wayfair

## Illustrative brief · proposed approach

A recurring weekly report requires repeated manual work. Where should we start?

Inputs: The current process, source files, report definitions, handoffs, and examples of rework.

1. Map each step and confirm who uses the output and what decision it supports.
2. Check repeated transformations and error points. Define a small, reversible improvement.
3. Pilot with a review checkpoint and document ownership, exceptions, and the manual fallback.

Proposed deliverable: A process map, pilot checklist, and operating scorecard.

Evaluation: Compare reporting accuracy, time spent, and rework against an agreed baseline.

## Related methods and exercises

- SQL report reconciliation (Illustrative sample · Synthetic data): https://richielin.com/pages/samples/sql-quality-check
- Research workflow pilot (Illustrative sample · Planning estimates): https://richielin.com/pages/samples/operations-pilot

## Context

The work covers product bundles, inventory recommendations, reporting, and recurring research workflows.

The proposed brief is a planning exercise. Each linked method includes its data or assumptions.

Role titles: Business Operations Intern · Operations Analyst Intern · Business Operations Analyst Intern

Contact: richielin02@gmail.com
Online: https://richielin.com/pages/roles/business-operations