Introduction
This portfolio website serves as a dynamic and interactive platform to highlight my capabilities.
The portfolio website I've created is written using HTML, JAVA, and CSS written in Google App Script Editor for the frontend design. It is stored and hosted on Google Cloud Console, ensuring security. The primary purpose of this website is to showcase my sales compensation and commissions analysis skills and knowledge. Please ask the chatbot (lower right corner) questions about my sales compensation experience.
Interactive Demonstrations
The following interactive tools demonstrate my ability to translate plan documentation and logic into user-friendly calculators and dashboards. This showcases the full cycle from plan design to data visualization. The What-If calculator script was easily written by simply uploading the documentation to Gemini 2.5 Pro then copying the resulting JAVA script to the webpage HTML. Given my documentation method, any sales plan could be transformed into a what-if calculator in a matter of minutes. I focus on documentation that is both human-readable and machine-readable for this reason.
What-If Commission Calculator
Model a deal based on the Sample Account Executive commission plan. It includes interactive editable fields to allow the user to rapidly and easily test scenerios.
Earnings Breakdown
Base Commission (0.00%)
$0.00
Accelerator Commission
$0.00
Multi-Year Kicker
$0.00
New Logo Kicker
$0.00
Total Earnings This Month
$0.00
BDR Commission Dashboard
Visualize performance and earnings based on the BDR commission plan. This is built using Google Looker and fed by the example calculator below. In a live environment, the dashboards data would be filtered based on user email accessing it resulting in personalized reporting for individual BDRs and managers. I included dynamic alegbraic experssions in my visualization to both provide sales plan documentation and earnings reporting in-one which enhances understanding of earnings calculations. Try selecting other employees in the employee name drop down to see how this dashboard would be individualized for each employee's compensation.
Methodology
My approach to sales compensation is built on a foundation of clear documentation, logical calculation architecture, and transparent process mapping. This ensures plans are not only accurate but also easy to understand and manage.
Plan Documentation
Plan documentation must be specific yet easy to understand. To achieve this, I use visual cues, simple algebraic expressions, and multiple layers of detail to serve as a self-learning tool for any reader. This approach to documenation of sales plans is not only human-readable but also highly machine-readable. Being machine-readable allows me to upload documentation to queries to return custom code for visualizations and calculators.
Sales Commission Logic
A robust commission system requires data retrieval, a spreadsheet or datahub, and a BI tool. My models mirror the structure of an ICM system, using structured tables, effective date logic for accuracy, and feeding results to a individualized dashboard. All spreadsheet solutions I break down into imported data, rules, engines, calculators, and reports.
Process Mapping
Process mapping visually represents the steps in a business process, helping to identify inefficiencies and bottlenecks. This enhances communication, collaboration, and continuous improvement. This process map I built using Lucid Chart.
Commission Calculation Practice
The following examples demonstrate my ability to translate complex commission plan requirements into functional calculation models. Each sheet represents a different scenario, showcasing a variety of mechanics from tiered accelerators and clawbacks to overlays and usage-based billing. These practices were completed within an hour time limit after receiving a practice prompt generated by Gemini 2.5 Pro.