Back to Developers
Rohan Nikalje

Rohan Nikalje

Business Intelligence Analyst

Pune 3+ yrs exp 93 ยท Outstanding

About

Business Intelligence Analyst with 2+ years of experience building Power BI dashboards, DAX data models, and SQL Server reporting for large operational datasets (100,000+ tickets/month), and nearly 4 years of total experience in IT services. Skilled in gathering reporting requirements, validating data quality, and turning findings into clear recommendations for technical and non-technical stakeholders. Experienced in automating reporting workflows and using AI tools (Microsoft Copilot, ChatGPT) to improve process efficiency.

Skills & Expertise (25)

Power BI Advanced
8.3/10
2
Years Exp
DAX Advanced
7.5/10
2
Years Exp
Power Query Advanced
7.5/10
2
Years Exp
Data Transformation Intermediate
7.0/10
2
Years Exp
ETL Intermediate
7.0/10
2
Years Exp
Advanced Excel Intermediate
7.0/10
4
Years Exp
SQL Intermediate
7.0/10
4
Years Exp
SQL Server Intermediate
7.0/10
4
Years Exp
Data Quality Assurance Intermediate
6.5/10
4
Years Exp
Microsoft Copilot Intermediate
6.0/10
1
Years Exp
Stakeholder Management Intermediate
6.0/10
4
Years Exp
Requirements Gathering Intermediate
6.0/10
4
Years Exp
Audit Readiness Intermediate
6.0/10
4
Years Exp
Documentation Intermediate
6.0/10
4
Years Exp
ChatGPT Intermediate
5.0/10
1
Years Exp
Claude Beginner
4.0/10
Data Validation Power BI Service Data Modeling Sla Root Cause Analysis MIS Reporting Power Pivot KPI Reporting Dashboard Development

Work Experience

Data Analyst / Power BI Analyst

LTIMindtree

Apr 2024 - Jul 2026

Designed and led an end-to-end ETL pipeline that integrated ServiceNow data into Power BI, applying data cleansing and transformation methods that reduced data preparation, storage, and visualization time by 30%. Developed 3+ interactive Power BI dashboards with data models, DAX measures, and business KPIs to monitor operational performance and support data-driven decisions for management and delivery teams. Published dashboards on Power BI Service with automated data refresh, increasing dashboard engagement by 55% and giving stakeholders reliable, up-to-date reporting. Optimized slow-performing Power BI reports by simplifying DAX measures and streamlining Power Query/ETL steps, cutting data refresh time by 20% (from 10 to 8 minutes). Consolidated data from SQL Server, Excel, and SharePoint to analyze 100,000+ IT tickets monthly, using Advanced Excel, Pivot Tables, and Power Pivot to identify trends, discrepancies, and performance patterns. Gathered reporting requirements from stakeholders and translated them into dashboards and recurring reports aligned with business needs. Wrote SQL Server queries to extract, validate, and analyze operational data, ensuring accuracy and consistency across reports and dashboards. Led process improvement initiatives by analyzing SLA and CSAT trends, partnering with stakeholders to identify root causes, and implementing corrective actions that improved operational performance. Maintained RCA, corrective action (CA), and preventive action (PA) documentation from stakeholders after SLA failures, supporting audit readiness and data governance standards. Built Microsoft Copilot AI agents with custom parameters to automate ticket audits and streamline ticket workflows, improving audit consistency and reducing manual effort.

Software Engineer

LTIMindtree

Aug 2022 - Mar 2024

Automated recurring reporting and MIS workflows, reducing manual effort and improving the accuracy and consistency of reports. This work earned the Hi-Five Award (2024). Cleaned and transformed operational data in Excel using advanced formulas and Pivot Tables to produce accurate ticket and performance reports. Analyzed tickets and supported process management using ServiceNow and internal client tools to deliver operational reporting. Presented daily, weekly, and monthly reports to stakeholders, gathering their requirements and resolving issues to ensure client satisfaction. This work was recognized with the iWin Super Crew award (2023 & 2024). Led a team of 7 junior engineers, managing task distribution and keeping delivery on schedule for almost all assigned tasks. Prepared and maintained known-error documentation, building a knowledge base for future reference. Performed manual product testing to identify bugs, usability issues, and performance gaps before release.

Education

Bachelor of Computer Science - Indira College of Commerce and Science

2019 - 2022 ยท Afghanistan

Certifications

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Codebasics ยท 2026

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 13/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 5/5
โœ… Verified 5/5
Total Score 93/100

Profile Overview

Member sinceOct 2026