Chaitanya Nandanwar

Data Analyst

Bengaluru, Karnataka 5+ yrs exp 90 · Outstanding

About

Data Analyst and Business Intelligence Analyst with 4+ years of experience in data analysis, business reporting and SQL development. Specialises in turning complex data into dashboards, KPI reports and business insights that leaders use to make decisions. Proven results include preventing $69,000 in annual losses, reducing refund tickets by 70%, reaching 95% accuracy in monthly revenue forecasts and saving 18 hours of manual reporting every week. Strong in requirements gathering, stakeholder management, ETL, data modelling and data visualisation using SQL, Python, Power BI, Tableau and ThoughtSpot.

Skills & Expertise (38)

Power BI Advanced

8.5/10

Years Exp

SQL Advanced

8.2/10

Years Exp

Python Intermediate

7.5/10

Years Exp

ETL Pipelines Intermediate

7.0/10

Years Exp

Tableau Intermediate

7.0/10

Years Exp

Data Storytelling Intermediate

7.0/10

Years Exp

Dashboard Development Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

Forecasting Intermediate

6.5/10

Years Exp

Advanced Excel Intermediate

6.5/10

Years Exp

Data Validation Data Modelling Azure Data Factory Apache Superset Matplotlib NumPy Pandas Excel Automation Azure Cosmos DB MongoDb MySql Draw.io SQL Server Google Data Studio KPI Analysis ThoughtSpot Cross-Functional Collaboration Business Insights Root Cause Analysis Process Mapping Process Optimisation Stakeholder Management Requirements Gathering Churn Analysis Cohort Analysis Trend Analysis Ad-hoc Analysis Business Reporting

Work Experience

Business Intelligence Analyst

ExamRoom.Ai

Oct 2023 - Present

Designed and automated Power BI and ThoughtSpot dashboards to monitor KPIs, enabling leaders to make faster business decisions. Identified and resolved financial discrepancies through SQL analysis, preventing $69,000 in annual losses. Analysed refund drivers and improved workflows, reducing refund tickets by 70% and improving customer satisfaction. Automated post-completion tasks with Excel automation and SQL, saving 2 man-hours per day. Conducted ad-hoc analysis to identify trends, anomalies and growth opportunities, and presented recommendations to stakeholders. Gathered requirements from cross-functional teams and translated them into technical specifications and reports. Built ETL pipelines in Azure Data Factory to load structured and semi-structured data from SQL and NoSQL databases. Optimised business processes using SQL and BI dashboards, reducing bottlenecks and improving workflow efficiency.

Business Intelligence Specialist

OnTop

Mar 2022 - Jul 2023

Built forecasting and trend analysis models in Python and SQL with 95% accuracy for monthly revenue predictions. Developed cohort and churn analyses to understand customer behaviour and support retention strategy. Automated recurring reports and data pipelines, reducing manual reporting time by 18 hours per week. Reduced report turnaround time by 40%, enabling faster decision-making across teams. Partnered with finance and operations teams to improve data quality and streamline analytics workflows. Improved revenue visibility and performance tracking through automated reporting.

Financial Analyst

Valenta

Feb 2021 - May 2022

Created financial plans and suitability reports that supported data-driven investment recommendations. Built forecasting models and conducted market research to guide fund selection based on client risk profiles. Automated financial data validation, improving accuracy and compliance. Increased advisor productivity by delivering detailed, data-backed portfolio insights. Maintained data accuracy in Intelliflo CRM and improved process efficiency through automation.