Remnants were stored outside, so knowing what was in stock meant walking the yard. I designed a web inventory system to fix that, moved inventory entry to phones when yard staff found the desktop impractical, and launched it as a subscription product with two paying fabrication businesses.
Result
Live, with two paying fabrication businesses as subscribers.
Problem and what I did: RemnantFlow
- Problem
- At Quick Countertop & Cabinets, stone remnants (the usable pieces left over from jobs) were stored outside. To check what was available or answer a customer, someone had to go out and look, which made inventory tracking and customer communication slow.
- What I did
- Defined the requirements and designed the PostgreSQL data model from how remnants are actually stored, priced, and sold.
- Built a web inventory system with AI-assisted development, so stock could be checked from a desk and shown online. I defined the features and handled testing and release decisions.
- When the people working in the yard found desktop-only entry impractical, reworked inventory entry for phones. That work became the RemnantFlow iPhone and iPad app, now on the App Store.
- Launched it in June 2026 as a multi-tenant subscription product for countertop fabricators, set the pricing tiers, and integrated Stripe billing.
- Built FindRemnants.com, a marketplace where homeowners find available remnants, and ran Google Ads search campaigns, using site analytics and lead tracking to follow inquiries.
A tiered commission structure I designed and tested in Excel against historical sales and profit data, and documented in two languages. The company adopted it.
Result
I designed and tested the structure, and the company adopted it. Accounting handled the payouts.
Problem and what I did: Commission structure
- Problem
- The sales team, two reps besides me, needed a tiered commission plan grounded in what each rep actually sold and earned for the business.
- What I did
- Analyzed historical sales and profit data by rep in Excel.
- Designed the tiers and performance thresholds from that data.
- Tested each tier in Excel against real past months to validate the thresholds.
- Documented the structure in English and Portuguese, the two languages the team works in.
Organizational network analysis
In progress, Fall 2026Project Manager, University of Maryland Information Science capstone
A five-person capstone team doing an organizational-network analysis and web-presence assessment for the Southern Poverty Law Center, an external nonprofit client. I am the project manager.
Result
In progress through December 2026.
Problem and what I did: Organizational network analysis
- Problem
- The Southern Poverty Law Center is the team's external client. The project covers an organizational-network analysis and an assessment of web presence.
- What I did
- Coordinate the project scope and deliverables.
- Set and track task assignments across the five-person team.
- Coordinate team communication.