Skip navigation
Philips Lighting logo

Philips Lighting

Product & Business Data Analyst

2002–2006 · Markham, ON, Canada

World leader in lighting solutions.

Highlights

  • Transitioned from Consumer Goods to Lighting division; served as Walmart Category Captain for automotive lighting.
  • Automated internal reporting processes through custom-built software, reducing manual workload by 18–22 hours per week.
  • Developed an automated pricing catalogue generator producing branded, customer-specific Excel and PDF workbooks with up-to-date product pricing — transforming a multi-week process into a task completed in minutes.
  • System automatically compiled data, generated distribution emails, and eliminated pricing errors — redefining the department's workflow.
  • Created analytical tools to evaluate planogram profitability and optimize retail shelf layouts.
  • Designed a loyalty reward system that contributed to the team winning an international Quality Improvement award.
  • Mapped and streamlined all SAP product maintenance workflows using UML diagrams to reduce human error and inefficiency; documentation later adopted for training and process standardization.
  • Represented Philips on the Market Intelligence Think Tank Committee, maintaining national market-share data and contributing insights to strategic planning.
  • Authored detailed operational manuals to reduce administrative errors and improve cross-departmental consistency.
  • Early demonstration of systemic problem-solving — using data, automation, and process modelling to streamline real-world operations before formal transition into software engineering.
Business Objects · Microsoft Access · Microsoft Excel · Microsoft SQL Server .NET · SAP · VB.NET · VBA · UML diagrams