Roshan Deolasi
Data Analyst | BI Developer
About Me
I am a Power BI Analyst with 3 years of hands-on BI experience and over a decade of professional experience across process management and client-facing roles.I specialize in converting manual Excel reports into automated Power BI dashboards, defining KPIs, and delivering insights through QBR and MBR reports. My background in operations and project management helps me design dashboards that are practical, clear, and decision-focused.
Skills
Excel | Power BI | SQL
Data Visualization
Business Analytics
Project Management
Team Management
Stakeholder Collaboration
UI Design
Featured Projects
Global Logistics Control Tower
A strategic dashboard designed to optimize delivery performance and logistics visibility.
Workforce Command Center
A BPO Command Center dashboard balancing Client SLAs and Employee Health using a Risk Matrix to detect burnout and reduce attrition
Claims Fraud Risk Monitor
A Power BI executive dashboard designed to detect insurance fraud and reduce financial risk.
Certifications & Recognition
Global Logistics Control Tower
STRATEGIC DASHBOARD | SUPPLY CHAIN OPTIMIZATION
The Challenge:
To provide real-time visibility into global shipping operations and identify root causes behind delivery delays and falling OTIF (On-Time In-Full) scores.The Solution:
A dynamic Power BI "Control Tower" that tracks shipment volumes and carrier performance. It enables stakeholders to drill down from high-level KPIs to specific granular bottlenecks in seconds.
Key Features:
Root Cause AI: Uses Decomposition Trees to automatically detect which carriers, routes, or regions are driving delays.
Performance Tracking: Monitors OTIF % and Average Delay days to benchmark carrier reliability.
Smart Alerts: Conditional formatting highlights "At Risk" shipments for immediate action.
POWER BI • DAX • AI VISUALS
TaskHub Workforce Command Center
STRATEGIC DASHBOARD | SUPPLY CHAIN OPTIMIZATION
The Business Problem:
BPO managers constantly struggle to balance aggressive Client SLAs with employee well-being. Overworking agents drives attrition, while underworking them causes missed targets. The goal was to build a visual tool that helps managers align performance goals with retention needs to prevent burnout.The Solution:
Developed the "Workforce Command Center," a dashboard that correlates operational KPIs with agent sentiment. Instead of just tracking past performance, the tool provides proactive insights, specifically identifying agents at high risk of burnout to support retention strategies.
Key Features:
Agent Risk Matrix (Scatter Plot): A custom quadrant analysis plotting Occupancy % against Sentiment Score. This instantly flags "At-Risk" agents who are overworked (>85% Occupancy) and unhappy, allowing managers to intervene before attrition occurs.
Volume vs. SLA Trend: A chart visualizing the direct correlation between daily call spikes and Service Level drops, proving the need for better workforce planning during peaks.
Dynamic Alert System: Implemented DAX with conditional formatting to trigger Neon Pink alerts when KPIs (like Abandon Rate or SLA) breach critical thresholds.
"Dark Mode" UI: Designed a modern, high-contrast aesthetic inspired by TaskUs branding, optimized for large "Command Center" screens used on operations floors.
The Impact: This dashboard empowers Operations Managers to shift from reactive "fire-fighting" to proactive "people management," potentially reducing agent attrition by identifying burnout signals early.
Claims Fraud Risk Monitor
RISK ANALYTICS | FRAUD DETECTION SYSTEM
The Challenge:
To reduce financial losses caused by insurance fraud. The goal was to help analysts move away from manual checks and quickly spot suspicious claims based on patterns that lead to incorrect payouts.The Solution:
A risk monitoring dashboard that segments claims into "High Risk" vs "Normal." It visualizes historical fraud patterns (like specific age groups or incident types) so the team can prioritize which claims to investigate first.
Key Features:
AI Root Cause Analysis: Uses the "Key Influencers" AI to statistically determine which factors (e.g., Age < 25) drive fraud probability.
Risk Segmentation: Dynamically categorizes claims into "High Risk" vs "Normal" status using DAX logic.
Financial Impact: Tracks critical KPIs like Loss Ratio and Total Risk Exposure in real-time.
POWER BI • DAX • AI VISUALS