Janhavi Pawar

Built Power BI and Excel dashboards consolidating multi-source KPI data, cutting manual reporting time by ~30% and providing real-time visibility for senior leadership. Implemented data validation for 1,000+ weekly records, reduced reportable errors by 22%, automated workflows to reclaim 6–8 analyst hours per week, and partnered with stakeholders to reduce rework cycles by 27%.

Engineered reusable Python pipelines to clean and standardise 50k–100k records, reducing downstream reporting errors by 34%. Authored modular SQL for KPI extraction, conducted EDA using hypothesis testing (t-tests, Chi-square), and automated recurring preprocessing and Excel reporting workflows to reduce data preparation time by 25%.

Built Python automation scripts for end-to-end data extraction, transformation, and formatting, reducing manual preprocessing effort by ~30%. Optimized SQL queries for structured data retrieval and performed exploratory data analysis to produce cleaned, analysis-ready datasets for senior analysts.

Grade: Merit

Activities and societies: Dissertation: Sentiment Analysis using Transformer-Based Models (BERT, RoBERTa).

Completed an MSc in Data Science at Manchester Metropolitan University (Merit), with a dissertation on sentiment analysis using transformer-based models (BERT/RoBERTa).

Grade: CGPA: 8.57 / 10

Earned a B.Tech in Information Technology from Dr. Babasaheb Ambedkar Technological University, completing the program with a CGPA of 8.57/10.