Portfolio Details

PHP (Vanilla) JavaScript MySQL REST APIs Azure DevOps
Development
Jan 2023 - Dec 2025
Spencer Ogden Consulting Sdn Bhd

Solar KPI & Performance Dashboard

An internal KPI and performance dashboard designed to provide real-time visibility into sales and recruitment operations within the energy sector. The system aggregates data from multiple sources and presents actionable insights through dashboards, charts, and performance ratios.

  • Real-time KPI monitoring (contracts, revenue, margins)
  • Sales pipeline and deal-stage tracking
  • Automated ratio and performance calculations
  • Trend analysis across configurable time periods
  • Drill-down reporting with filtering and pagination

  • Designed and implemented backend KPI logic
  • Built RESTful APIs for dashboard data
  • Developed interactive charts and reporting views
  • Optimized MySQL queries for high-volume datasets
  • Worked with existing Azure DevOps CI/CD pipelines for code integration and deployment
Next Project