Shikha Bansal

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.

Work style

Remote

Contact details — on requestProof of Work — on request

Experience

A

Data Analyst

Arbre Creations Pvt Ltd · Jul 2023 – Present

Not yet confirmed
  • 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

Taking OwnershipSelf-Directed LearningExplaining Technical ConceptsBusiness AcumenDashboard UI DesignReport CustomizationQuery WritingModel Metric Selection & InterpretationData ExaminationETL Pipeline DevelopmentReal-Time Dashboard DevelopmentAdaptabilityWork Planning and PrioritizationMentoring and Peer CoachingTeam LeadershipProduct Development StrategyProcess ImprovementProduct Improvement ResearchProduct Decision MakingStrategic PlanningData ScienceMachine Learning ApplicationHypothesis-Driven ExperimentationAudience Engagement AnalysisProduct Data AnalysisTask AutomationStakeholder ManagementTechnical DocumentationAnalytical Report CreationData VisualizationRegression AnalysisCustomer Behavior AnalysisStatistical InferenceExploratory Data Analysis (EDA)Data ValidationData ExtractionBusiness AnalysisAutomated Report GenerationRetrieval-Augmented GenerationLLM Application IntegrationAI Tool EnablementAnalytical ScopingGoal setting (defining key results)Microsoft ExcelAI Platform DevelopmentClaude OptimizationAI Tools UsageDatabricks UsagePower BIPython DevelopmentSQL Validation Template CreationData-Driven RecommendationsResearch MethodologyData CollectionCustomer Retention and Churn PreventionContent Optimization Using Performance DataKPI Analysis

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