01 / Commission reporting automation
Automating commission reporting for a 300+ rep sales org.
Each payout cycle meant pulling sales data, matching it to reps, applying multi-tier plan rules and building reports by hand. I built a SQL and Python reporting process that applies the plan rules and produces the reports, validation checks that flag payout exceptions before release, and Power BI dashboards for quota attainment and payout forecasts.
Outcome: 20+ hours of manual work removed every month; exceptions reviewed before payment instead of corrected after; leadership sees attainment and expected payouts during the period.
