Problem Solving Lab

Operations · Data · Automation

Real operational problems, made measurable.

I am Luis Marrero. This lab documents how I turn ambiguous reporting problems into clear business rules, tested transformations, and useful decision tools.

View case studies Review the code
Current experiment One shift. Two reporting stories.
10 PM
Midnight
6 AM
Split into 2 partial records

Hours and calls move across dates, making the real shift look incomplete.

Synthetic onlyNo proprietary data
Business firstPlain-language decisions
ReproducibleCode, data, and tests
Built for actionOutputs managers can use

Case study 01

Fixing Overnight Shift Metrics

A contact center operations reporting scenario where calendar dates split overnight work and distort performance metrics.

Dashboard comparing calendar dates with operational workdays
Problem
A 10 PM–6 AM shift appeared on two dates.
Decision
Assign every event to the shift start date.
Impact
Complete shifts, fairer metrics, cleaner staffing insight.

Python · CSV · Business rules · Automated HTML reporting

Read the case study

How I work

From unclear symptom to reliable decision.

  1. Frame

    Define the operational question and who needs the answer.

  2. Model

    Turn the business rule into explicit, testable logic.

  3. Prove

    Compare the current method with the corrected result.

  4. Deliver

    Present the outcome in a format people can act on.