Sagar Kathe
Pune
Summary
Experienced IT Professional with over 5.5 years of expertise in Excel, Power BI Desktop, SQL and Tableau, specializing in data cleaning, validation, reporting, and dashboard development to drive strategic decision-making and process improvements. Honing strong analytical skills, problem solving abilities with learning mindset and proactive approach.
Overview
7
7
years of professional experience
Work History
ScatterPie Analytics
Data Analyst
Pune
09.2025 - Current
- Migrated dashboards and reports from Tableau to Power BI, achieving functional and visual parity.
- Rebuilt Tableau visualizations with Power BI visuals, DAX measures, and Power Query transformations to maintain data integrity.
- Designed optimized Power BI data models with star schema principles to enhance performance.
- Optimized DAX calculations and implemented aggregation strategies to improve report performance.
- Converted Tableau calculations and LOD expressions into DAX measures for consistency.
- Analyzed existing Tableau workbooks and data sources to map logic equivalency in Power BI.
- Performed data cleansing and validation using Power Query (M language) to ensure accuracy.
- Collaborated with stakeholders to validate migrated dashboards and document best practices.
Tata Consultancy Services
Data Analyst
Pune
04.2022 - 11.2024
- Power BI - Specialized in data modeling, data cleaning, data processing, Power Query Editor, DAX, and complex calculations in Power BI.
- Designed and developed Power BI reports and dashboards for large datasets and Excel reports to facilitate daily business analysis.
- Developed and managed KPIs, filters, slicers, charts, and geocoding for reporting in Power BI.
- Implementing Row-Level Security (RLS) and performing advanced data transformations to deliver optimized, high-performance analytics.
- Executed data extraction, cleaning, filtering, manipulation, reformatting, and application of business logic from multiple source systems to load transformed data into target data warehouse or database.
- Utilized Excel functions, including Pivot Tables, Aggregate Functions, and VLOOKUP, to improve data analysis efficiency in MS Excel.
- Wrote complex SQL queries for data extraction, transformation, and analysis in SQL.
Mphasis LTD
Tech Support & Data Analyst
Pune
08.2018 - 10.2021
- Designed and developed interactive dashboards in Power BI to visualize key metrics.
- Conducted data cleaning, validation, and reporting using Power BI and Excel for finance.
- Analyzed data to generate actionable insights aligned with client requirements.
- Utilized Excel for extracting, manipulating, and analyzing large datasets to ensure accuracy.
- Streamlined database development operations and supported technical teams in service upgrades.
Education
Master of Business Administration - Operations Management
Savitribai Phule Pune University
Pune07.2018
Bachelor of Engineering - Mechanical Engineering
Savitribai Phule Pune University
Pune07.2016
Skills
- Power BI Desktop
- Advanced Excel
- Tableau
- SQL (MySQL, SQL Server)
- Data analysis and visualization
- Data cleaning
- Data transformation
- Data modeling
- Data validation
- Dashboard creation
- Performance optimization
- Data visualization
- Power BI development
Languages
- Hindi
- English
- Marathi
Timeline
ScatterPie Analytics
Data Analyst
09.2025 - Current
Tata Consultancy Services
Data Analyst
04.2022 - 11.2024
Mphasis LTD
Tech Support & Data Analyst
08.2018 - 10.2021
Master of Business Administration - Operations Management
Savitribai Phule Pune University
Bachelor of Engineering - Mechanical Engineering
Savitribai Phule Pune University