Data Analyst Power Bi

Anshika Gupta

•New Delhi • **************@*****.*** • https://www.linkedin.com/in/anshika-gupta05 • 890******* Data Analyst 3+ Years

Summary

Analytical professional with 3+ years of experience transforming complex datasets into actionable insights to drive strategic decisions in AdTech, marketing analytics, and product optimization. Skilled in SQL, Python, Tableau, and Power BI, with expertise in KPI tracking, A/B testing, event analytics, and business storytelling. Strong track record of enabling data-driven decisions and revenue growth through impactful insights Skills

• Analytics & BI: Tableau, Power BI, A/B Testing, PowerPoint, KPI tracking, Data Modelling, Excel (Pivot Tables, VLOOKUP)

• Languages: SQL (Advanced), Python (Pandas, NumPy, Matplotlib), Java

• Big Data and Cloud: GCP, AWS, Hive, Presto, Airflow, Big Query, Spark

• Agile Methodology and Scrum: Git, Jira, CRM, Documentation

• Soft Skills: Stakeholder Management, Analytical Thinking, Business Problem solving, Root Cause Analysis Work Experience

SDE 1 – Data Analyst 01/2024 - Present

Uber Technologies (via Nineleaps Technologies) Bangalore

• Delivered SQL-based A/B test impact analyses, improving KPI tracking by 15% and supporting key rollout decisions for high-impact product features.

• Improved attribution accuracy by 6%, reducing misallocation of $2M annually and strengthening revenue insights.

• Conducted root cause analysis on anomalies across 10M+ daily events, improving upstream data reliability.

• Collaborated closely with product, and data science teams to standardize event definitions and KPI metric enabling better decision making to onboard priority events.

• Built and maintained 10+ interactive dashboards (Tableau) to track ride/event KPIs for $50M+ transactions, empowering stakeholders with real-time insights.

• Spearheaded on-call noise reduction plan (40% fewer alerts), improving data trust & operational efficiency.

• Analysed and debugged ETL logic in Python and Java to align event ingest with business definitions.

• Led the migration of 28 data pipelines from Hive to Spark SQL with full validation, saving $500K/year in cloud costs. Data Engineer - BI and Analytics 07/2022 – 12/2023 Sistic.com Singapore (Remote)

• Automated ETL workflows, improving data processing efficiency by 40% and reducing manual effort.

• Integrated CRM(Braze) via Api enabling 90% automation of customer data updates and a 20% uplift in campaign engagement.

• Delivered deep-dive and root cause analysis on customer/sales data, optimizing complex SQL queries to ensure 99.9% reporting accuracy across business dashboards (Power BI, Qlik Sense) and guide business strategy.

• Designed and maintained a scalable data warehouse architecture, developing pipelines with Spark and Hive to ingest 10TB+ of data daily from sources like Big Query, Oracle, and MySQL into GCS Buckets and HDFS

• Conducted RCA on customer and sales data, optimized SQL queries, and ensured 99.9% reporting accuracy

• Partnered with stakeholders to translate business needs into analytics solutions, delivering insights within SLA. Education

Master of Science - Data Science and Management 09/2024 – 08/2026 IIM Indore, IIT Indore 3.49/4.33 CGPA

B.E - Computer Science 08/2018 – 07/2022

Chitkara University, Punjab 9.68/10 CGPA

12th Grade – CBSE 04/2017 – 03/2018

The Century School, Karnal 90.4%

Contact this candidate