Mayank Borasi

Data Analyst

Indore, M.P. 11+ yrs exp 90 · Outstanding

About

Data Analyst with 5.11 years building SQL and Power BI reporting systems that give leadership teams real-time decision visibility across 1M+ record datasets. Delivered measurable business outcomes — 6% SLA compliance improvement at state-government scale, 19% reduction in operational effort, 12% cut in reporting errors — by owning the full pipeline from raw data to executive dashboard. Working knowledge of Microsoft Fabric and Azure data services, with deep DAX/Power Query expertise.

Skills & Expertise (80)

SQL Expert

9.2/10

Years Exp

Power BI Expert

9.0/10

Years Exp

Python Advanced

8.8/10

Years Exp

DAX Advanced

8.5/10

Years Exp

Business Intelligence Advanced

8.5/10

Years Exp

Azure Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Data Transformation Advanced

8.0/10

Years Exp

Statistical Analysis Intermediate

7.5/10

Years Exp

Machine Learning Intermediate

7.5/10

Years Exp

Azure Data Factory Azure SQL Database Ifs Index-match XLOOKUP Pivot Charts Pivot Tables agentic AI Excel Pandas Numerical Analysis duplicate detection OneLake merging GROUPBY Data Manipulation NumPy Data Preprocessing AI-assisted Analytics LLMs Prompt Engineering KPI Reporting Interactive visualization Plotly Seaborn Matplotlib SUMIFS TEXT scikit-learn NLTK Sentiment Analysis NLP Conditional Formatting Countifs Aggregations Trend Analysis Profiling Transformation EDA Data Extraction Query Optimization Reconciliation Data Validation Pattern Identification Views Stored Procedures Window Functions Subqueries CTEs Joins Complex queries Microsoft Fabric Relationships Reports Dashboards Drill-through Drill-down KPI development Time intelligence Measures Calculated Columns data refresh Star Schema Data Modeling Power Query (M Power BI Service Power BI Desktop Operational Analytics Business Insights Root Cause Analysis

Work Experience

Data Analyst

CSM Technologies Ltd.

Nov 2025 - Sep 2026

Owns end-to-end SQL/Power BI reporting for a state-wide grievance system spanning 1M+ grievance records across 35 Departments, 180 Sub-Departments, 5 Divisions, 34 Districts, 193 ULBs and 7+ complaint channels reporting insights that contributed to a 6% improvement in SLA compliance across the reporting period. Redesigned unbiased business logic for officer performance ranking, incorporating grievance outcomes, SLA performance, workload and applicable operational conditions to support more meaningful performance comparison across officers. Develop SQL-based extraction, transformation, validation and reconciliation workflows to create reliable reporting datasets and investigate discrepancies across source data, application outputs and analytical reports. Design Power BI dashboards and DAX-based KPIs for state-wide grievance performance monitoring, covering complaint volumes, pending/resolved cases, SLA compliance, SLA breaches, complaint aging, feedback and reopened complaints. Analyze grievance performance across Department, Sub-department, Division, District, ULB, ULB Type and Officer hierarchy, enabling stakeholders to drill down from state-level KPIs to operational performance areas. Implement a Sentiment Analysis solution using Python, NLP, NLTK and Machine Learning techniques to convert unstructured citizen feedback into sentiment patterns for grievance-service analysis. Designed and implemented a Knowledge Base solution for Landmark Tracking, streamlining the operational workflow and achieving a 19% reduction in operational effort.

BI Developer

PerfElite Solutions Pvt. Ltd.

Jan 2023 - Sep 2025

Built Power BI/DAX KPI system for insurance claim-settlement performance, replacing ad hoc reporting with a live dashboard stakeholders used for settlement decisions. Used Python/Pandas-based anomaly detection to catch data-quality issues before they reached leadership reporting, cutting the reporting error rate by 12%. Performed data extraction, transformation, cleansing, validation, and integration across multiple data sources to prepare reliable and analysis-ready datasets. Worked with business stakeholders to understand reporting requirements, define KPIs, translate business logic into analytical measures, and deliver dashboards aligned with business objectives. Performed data validation and reconciliation between source systems and reporting outputs to identify discrepancies and ensure dashboard accuracy and reliability.

Operations Data Analytical Manager

Zupaso E-Learning Pvt. Ltd.

Jan 2022 - Jan 2023

Analyzed Campaigns, Products, Sales, Revenue management, Customer-funnel, Conversion, and Operational data to identify performance gaps and support business decisions. Contributed to a 32% increase in revenue through data-driven operational improvements and improved forecasting accuracy. Analyzed business KPIs and operational trends to provide actionable insights to management and support data-driven sales and operational decisions.

Operations Data Analyst

TaskUs

Jan 2021 - Jan 2022

Monitored CSAT, SLA, AHT, and FCR using Advanced MS Excel to identify service-performance gaps and operational bottlenecks. Developed KPI reporting and dashboards that supported operational improvements, contributing to a 15% reduction in response time.

Quality Optimization Analyst

CRM Services Pvt. Ltd. (Teleperformance)

Mar 2015 - Nov 2019

Monitored Yahoo Ad Services KPIs using Advanced Microsoft Excel-based reporting and dashboards, performing trend analysis and root-cause analysis to identify quality gaps. Supported process improvements that contributed to an 8% reduction in quality defects.