Shikha Bansal
As a data analyst, I am driven by a deep curiosity and an ambitious pursuit of mastery, constantly seeking to uncover meaningful insights. I thrive on the autonomy to explore complex data challenges, taking full accountability for delivering clear, impactful solutions that align with my idealistic vision for positive change. My empathetic approach ensures that data is always leveraged to serve genuine needs.
Experience
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.
Skills 0 proven through work
Also works with
Proof of Work
Proof of Work
Shikha shares this with people who ask. You'll hear back either way.
Education
Bachelor of Arts (Honours), English
Delhi University · 2018 — 2021
Contact details
Contact details
Shikha shares this with people who ask. You'll hear back either way.
Ask about this candidate
AI responses may contain errors. Proof status and source information are provided by Proof of Skill.
A Proof CV — one profile, kept current, with the proof attached. Back to the portal