Philips

An analytics and IT internship building the data layer behind Philips' internal sales reporting end to end: Python, pandas and SQL pipelines, classification models on top, and the Power BI dashboards the business reported from. I then automated the recurring reports people had been assembling by hand, cutting that manual work by about 40%.

Highlights

• Built Python, pandas and SQL pipelines that cleaned, joined and aggregated customer sales data for internal analytics
• Trained and validated classification models on that data, and surfaced their predictions in the Power BI dashboards used for business reporting
• Automated recurring reports that had been assembled by hand, cutting manual effort by ~40%
• Made reporting consistent run to run — one pipeline and one set of definitions instead of figures rebuilt by hand each cycle
• Owned the path from raw data to the dashboard a business reader sees, across both the data and IT sides of the role