Operations · Pricing · Reporting · Business systems

Hugo Maciel Fraga

Business operations, data, and systems

I look for the places where the numbers or the process do not hold up, then fix them with the people involved.

Three examples

  1. Pricing

    Problem

    Estimated job profits did not match the accounting results, and reps needed a manager before they could move on price.

    What I did

    With management, traced the gap to outdated pricing assumptions. Built an Excel calculator that gave reps a safe price range.

    Read the case study: Pricing
  2. Reporting

    Problem

    Management needed a regular view of which products, customer segments, and lead sources were working.

    What I did

    Built a monthly KPI report from Pipedrive CRM and QuickBooks and presented it to the General Manager and department teams.

    Read the case study: Reporting
  3. RemnantFlow

    Problem

    Stone remnants were stored outside, so checking what was available meant walking the yard.

    What I did

    Designed a PostgreSQL inventory system, moved entry to phones after yard feedback, and launched it as a SaaS product. Two fabrication businesses pay for it.

    See the project: RemnantFlow

Four years in sales and operations at Quick Countertop & Cabinets, a countertop and cabinet business with about $2 million in annual revenue, nearly three of them as sales manager. Founder of RemnantFlow, a subscription inventory product for countertop fabricators. B.S. in Information Science from the University of Maryland, December 2026.

Selected work

More work

RemnantFlow

Live

Founder, June 2026 to present

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.

PostgreSQL (Supabase), React and Next.js, React Native (Expo), Stripe, Vercel, Google Ads. Built with AI-assisted development.

Commission structure

Sales Manager, Quick Countertop & Cabinets

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.

Excel, for the historical calculations and validation. Historical sales and profit data by rep.

Organizational network analysis

In progress, Fall 2026

Project 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.

Client: Southern Poverty Law Center. University of Maryland, Fall 2026.

How I work

  1. Check the assumptions under the numbers.

    At Quick, estimated job profits stopped matching the accounting results. Rather than trust the estimates, I raised it with management and we reviewed labor, utility, and overhead costs. Some of the pricing assumptions were out of date.

  2. Remove the step that holds people up.

    Reps could not negotiate without a manager, so I built a calculator that gave them a safe range. When the fabrication manager was working remotely and production staff needed answers before they could go on, I helped get their questions answered so work could continue. When yard staff could not use desktop inventory entry, RemnantFlow moved it to phones.

  3. Make the information usable by the people who need it.

    At Fox Auto Center, inconsistent part numbers made it hard to tell which parts were in stock, so I built a cross-reference that identified usable inventory. At Quick, I documented the commission structure in English and Portuguese so the whole team read the same rules.

Tools

Business
  • Business operations
  • Process improvement
  • KPI reporting
  • Pricing and cost analysis
  • CRM analytics
  • Requirements gathering
  • Commission modeling
  • Supplier negotiation
  • Inventory management
Data and systems
  • Excel (PivotTables, XLOOKUP, SUMIFS)
  • SQL (PostgreSQL, MySQL)
  • Pipedrive CRM
  • QuickBooks
  • Google Ads
  • Tableau (basic)
  • Power BI (PL-300 in progress)
  • Python (coursework)
Product
  • Supabase (PostgreSQL)
  • React and JavaScript
  • Stripe billing
Languages
  • English (fluent)
  • Portuguese (fluent)

Background

Experience

  1. Jun 2026 to Present

    Founder, RemnantFlow

    Started from a problem at Quick Countertop & Cabinets: remnants stored outside could only be checked by walking the yard. Launched as a multi-tenant subscription inventory platform with two paying fabrication businesses. Requirements, data model, testing, pricing tiers, Stripe billing, an iPhone and iPad app on the App Store, and FindRemnants.com with Google Ads.

  2. Aug 2023 to Jun 2026

    Sales Manager, Quick Countertop & Cabinets

    Monthly KPI reports from Pipedrive CRM and QuickBooks for the General Manager and department teams. Raised a gap between estimated and actual job profitability, reviewed production costs with management, and built the Excel pricing calculator reps quoted with. Designed the commission structure, negotiated supplier terms, supervised two employees, and helped production staff get answers while the fabrication manager worked remotely. Gaithersburg, MD.

  3. Feb 2022 to Aug 2023

    Sales Representative, Quick Countertop & Cabinets

    Customer discovery, material selection, quoting, and order coordination for cabinetry and countertop projects. Promoted after 18 months.

  4. May 2021 to Feb 2022

    Office Manager, Fox Auto Center

    Office administration and parts identification. Inconsistent part numbers made usable stock hard to recognize, so I built a parts cross-reference that identified it.

Education

  1. Expected December 2026

    B.S. Information Science, University of Maryland

    GPA 3.68

  2. May 2021

    A.A.S. Cybersecurity, Montgomery College

    GPA 3.83. Graduated with honors.

Selected coursework, University of Maryland

  1. Databases and SQL

    • Database Design and ModelingINST327
    • Advanced SQL Topics in Information and Data ScienceINST427In Progress, Fall 2026
  2. Analytics

    • Data Sources and ManipulationINST447
    • Introduction to Data VisualizationINST462
    • Statistics for Information ScienceINST314
    • Data Science TechniquesINST414
  3. Business Decision-Making

    • Foundations of AccountingBMIN210
    • Managing with Data and SimulationsINST410In Progress, Fall 2026

Contact

hmacielf@outlook.com

Available for full-time roles beginning January 2027. Seeking opportunities in the Washington, DC metropolitan area or remote within the U.S.