Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

SAWPARNIKA CH

Bangalore

Summary

Data Analyst with over 4 years of experience in transforming data into business insights. At redBus, I built automated KPI reporting pipelines and executive dashboards in Power BI, empowering leadership with real-time decision-making. Proven track record of driving process improvements, boosting customer satisfaction, and delivering impactful analytics through SQL, Python, and Power BI.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

redBus
Bangalore
08.2024 - Current
  • Engineered and deployed end-to-end automated reporting solutions for KPIs using Python and Power BI, ensuring seamless data pipeline integrity and timely availability for leadership.
  • Developed and published a suite of interactive Power BI dashboards to the Report Server, consumed daily by senior executives to facilitate strategic business decisions.
  • Led data analysis for the 'Silkboard' voice channel project, driving a significant increase in On-Call Resolution (OCR) from 62.87% to 74.65%, and boosting customer satisfaction rates from 72% to 78%.
  • Conducted in-depth process analysis for new CRM initiatives, comparing pre- and post-implementation metrics to deliver actionable insights on performance improvements to key stakeholders.
  • Managed the complete data pipeline lifecycle, from writing and scheduling Python ETL scripts to establishing robust data models and relationships in Power BI.

Senior Scientific Data Analyst

Molecular Connections, Pvt. Ltd
Bangalore
10.2020 - 08.2024
  • Analyzed collected data to uncover patterns, trends, and insights about different research areas, and grants allocated to the research.
  • Created dashboards using Power BI and Excel to analyze research data, identifying publication trends, popular research topics across geographical regions, and key metrics.
  • Calculated citation counts and developed KPIs to summarize total funding and average grant sizes, delivering actionable insights to stakeholders.

Education

Master of Science -

St. Aloysius College (Autonomous), Mangalore
Mangalore
09-2020

Skills

  • SQL databases: MS SQL and PostgreSQL
  • Data visualization: Power BI
  • Programming languages: Python-NumPy, and Pandas
  • Advanced Microsoft Excel
  • Data warehousing: Amazon Redshift
  • Development tools: Jira, TablePlus, Visual Studio Code, and Jupyter Notebook

Certification

• Master's Program in Data Science & Business Analytics | Simplilearn & IBM

• Data Analysis and Visualization with Power BI | Coursera

Projects

HR data analytics [Python and Power BI]

Built an HR analytics solution using Power Query and Power BI to predict employee

Attrition and identify key drivers, like job satisfaction and income

Comparison of Region-Based Sales [Tableau]

Created interactive Tableau dashboards to analyze regional sales, visualizing KPIs like total

sales, average order value, and customer distribution for better decision-making.

Timeline

Senior Data Analyst

redBus
08.2024 - Current

Senior Scientific Data Analyst

Molecular Connections, Pvt. Ltd
10.2020 - 08.2024

Master of Science -

St. Aloysius College (Autonomous), Mangalore
SAWPARNIKA CH