Data Analyst
Arbre Creations Pvt Ltd · Jul 2023 – Present
- Developed and maintained complex data models and KPI dashboards in Power BI and Tableau tracking demand forecasting, capacity planning, and supply chain operational metrics for senior stakeholders, enabling clear, data-driven decision-making.
- Utilised expert-level SQL to extract, transform, and analyse large datasets from internal databases, external APIs, and cloud-based platforms writing complex queries, macros, and stored procedures to support both recurring and ad-hoc reporting needs.
- Designed and implemented automated ETL/ELT data pipelines using Python and PySpark on Azure Databricks automating data collection, cleaning, and processing workflows and reducing manual data preparation effort by ~40%.
- Conducted in-depth supply chain and product utilisation analysis across ~2.5M records identifying trends, patterns, and anomalies to surface actionable insights for optimising resource allocation and improving operational efficiency.
- Leveraged Advanced Excel (pivot tables, vlookups, sumifs, macros, conditional formatting, Power Query) to build analytical models, automate reporting workflows, and deliver clean, structured outputs to business stakeholders.
- Collaborated with cross-functional teams demand planners, supply planners, and product managers to understand data requirements and deliver tailored, dashboard-driven reports aligned to their operational priorities.
- Proactively identified process improvement and automation opportunities developing innovative SQL- and Python-based solutions that enhanced data analysis capabilities and reduced turnaround time on critical reporting.
- Contributed to data accuracy processes and governance standards implementing reconciliation controls, schema validation, and deduplication logic, and maintaining thorough documentation of all data definitions and pipeline logic.

