Built an interactive Power BI scorecard to evaluate sales representative performance across revenue attainment and discount behavior. The dashboard assigns composite scores, classifies representatives into risk tiers, and surfaces coaching priorities for leadership — identifying two at-risk representatives whose pricing behavior was flagging margin risk that would not have been visible through standard reporting.
| Rep | Composite Score | Discount % | Tier |
|---|---|---|---|
| Alice | 7.1% | Green | |
| Bob | 8.4% | Green | |
| Carol | 9.2% | Green | |
| Frank | 10.0% | Green | |
| David | 14.8% | Watch | |
| Eve | 17.3% | High Risk |
Designed and implemented a Power BI dashboard to analyze user feedback collected during a critical enterprise application migration. By visualizing satisfaction across performance and experience dimensions, the dashboard pinpointed a server capacity constraint at the root of 68% of complaints — directly informing the technical team's infrastructure decisions and accelerating resolution before the issue could compound.
Analyzed employee training completion rates and post-training performance scores across eight departments to determine whether the organization's training investment was producing measurable results. Using Excel pivot tables, conditional formatting, and annotated charts, the analysis revealed a clear threshold effect: departments above 80% completion showed an average 15% performance improvement, while those below 60% showed no meaningful change — providing a data-backed case for mandatory completion standards.
| Dept | Completion | Rate | Score Δ |
|---|---|---|---|
| Operations | 92% | +18% | |
| Compliance | 88% | +16% | |
| IT Support | 84% | +14% | |
| Finance | 81% | +12% | |
| Logistics | 67% | +6% | |
| HR | 62% | +4% | |
| Marketing | 48% | +1% | |
| Admin | 41% | 0% |
Process documentation and standard operating procedures developed across federal and corporate environments, demonstrating technical writing, workflow design, and operational standardization.
Led the end-to-end product development of an internal workflow system for a federal agency division with no prior digital infrastructure — moving from problem discovery through requirements definition, phased build, and division-wide adoption. Treating three distinct user groups as the product's customers, I defined success metrics upfront, managed a prioritized feature roadmap across three delivery phases, and drove change management through stakeholder walkthroughs at each stage. The system served over 200 customers in its first year and reduced cross-departmental cycle times by 75%.
Developed a multi-table SQL query set against a simulated HR operations database to answer a precise business question: which training programs deliver the strongest return on investment when measured against post-training performance improvement and 12-month retention rates? The analysis joins four relational tables, applies aggregation and ROI indexing logic, and surfaces a key finding — programs with structured pre and post assessments produced 2.3 times higher ROI scores than those without, regardless of cost or duration, pointing to measurement design as the primary driver of training effectiveness.
-- Training ROI Analysis -- Performance improvement by program SELECT t.program_name, t.department, COUNT(tc.employee_id) AS total_completions, ROUND(AVG(tc.completion_rate),1) AS avg_completion_pct, ROUND(AVG( ps.post_score - ps.pre_score),1) AS avg_score_improvement, ROUND(AVG(r.retained_12mo)*100,1) AS retention_rate_pct, ROUND(AVG(ps.post_score-ps.pre_score) / NULLIF(AVG(t.cost_per_employee),0) * 100, 2) AS roi_index FROM training_programs t JOIN training_completions tc ON t.program_id = tc.program_id JOIN performance_scores ps ON tc.employee_id = ps.employee_id AND ps.review_period = 'post_training' JOIN retention_data r ON tc.employee_id = r.employee_id WHERE tc.completion_date BETWEEN '2023-01-01' AND '2024-12-31' AND tc.completion_rate >= 0.75 GROUP BY t.program_name, t.department HAVING COUNT(tc.employee_id) >= 10 ORDER BY roi_index DESC LIMIT 10;
| # | Program | Dept | Score Δ | ROI Index |
|---|---|---|---|---|
| 1 | Assessed PM Cert | Operations | +19.2 | |
| 2 | Data Analysis w/ Pre/Post | IT Support | +17.8 | |
| 3 | Compliance Fundamentals | Compliance | +15.4 | |
| 4 | Leadership Essentials | Finance | +13.1 | |
| 5 | Onboarding (No Assess.) | HR | +5.2 | |
| 6 | Generic Orientation | Admin | +2.1 | |
| 7 | Video-Only Module | Marketing | +0.8 |
