ROHIT BHAPKAR
Data AnalystAI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with 2+ years in SQL, Power BI & Data Modeling
Data Analyst and Business Analyst with hands-on experience in operational reporting, claims process analysis, KPI development, dashboard design, data cleaning, data transformation, data validation, root cause analysis, trend analysis, and performance monitoring. Skilled in SQL Server, T-SQL, Advanced Excel, Power Query, Power Pivot, Power BI, DAX, ETL processes, data modeling, business intelligence, reporting automation, data interpretation, statistical analysis, and data quality assurance. Builds analytical reports and BI dashboards that improve reporting efficiency, target tracking, productivity visibility, variance analysis, and data-driven business decision-making.
SPPU
Bachelor of Pharmacy · Pharmacy
August 1, 2018 – June 30, 2022
SPPU
HSC
June 1, 2016 – May 31, 2018
Wellcove-CHCS
Claim Specialist / Analyst
May 1, 2024 – April 1, 2026
India
End-to-End Audit and Production Analytics Solution
June 1, 2026 – Present
Developed an operations analytics solution to track production, quality, targets, audit findings, work allocation, and performance trends for management reporting. Transformed and modeled production and audit datasets using Power Query and Power Pivot; created KPI dashboards for TAT, quality errors, top error analysis, productivity, and target variance. Identified performance gaps, workload imbalance, missed targets, quality errors, and training opportunities to support data-driven process improvement.
SQL Data Warehouse and Analytics Project
June 1, 2026 – Present
Built an end-to-end SQL Server data warehouse and analytics layer to support structured data storage, querying, reporting, and business intelligence use cases. Created schemas, views, and analytical SQL queries using joins, CTEs, subqueries, aggregations, date logic, and window functions to analyze customer behavior, product performance, and sales trends. Implemented data quality checks for duplicate keys, referential integrity, invalid financial values, date sequencing, inventory balance mismatches, and target coverage gaps.
View ProjectOmniRetail 360: Sales, Customer, and Inventory Analytics
June 1, 2026 – Present
Built an end-to-end business analytics project across 2,810 orders, 5,668 order lines, 850 customers, products, monthly targets, returns, and inventory data. Defined KPIs for revenue, adjusted profit, profit margin, repeat customer rate, return rate, target variance, stockout days, lost sales units, and month-over-month performance. Designed Power BI DAX measures, SQL validation checks, and dashboard-ready Excel outputs to support business analysis, performance monitoring, and stakeholder reporting.
Funnel Analysis Dashboard
June 1, 2026 – Present
Designed an interactive Power BI dashboard to analyze customer conversion funnels, track drop-off rates, and measure performance across sales and marketing stages. Built KPI visuals for conversion performance and stage-level trends to support root cause analysis of funnel leakage and reporting automation.
Business & Data Analytics Program
CoachX
June 1, 2026 – Present
Microsoft Power BI Data Analyst Associate (PL-300)
Microsoft
June 1, 2026 – Present
Data Analytics Essentials
Cisco Networking Academy
June 1, 2026 – Present
Data Analytics Job Simulation
Deloitte / Forage
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's project diversity, ranging from audit analytics to retail sales and customer behavior, indicates adaptability and a broad interest in applying data analysis across different business domains. The focus on improving efficiency and supporting data-driven decision-making aligns well with a results-oriented culture. The pursuit of certifications like Microsoft Power BI Data Analyst Associate (PL-300) demonstrates a proactive learning attitude. The education in Pharmacy, while not directly related to data analysis, suggests a structured and analytical approach to learning, which can be beneficial.
Soft Skills & Operational Fit
The candidate's experience in processing claims with high accuracy and performing root cause analysis suggests strong attention to detail and problem-solving skills. Their work on automating reporting workflows indicates an operational mindset focused on efficiency. The psychometric test score (294/500) suggests potential areas for development in logical reasoning, work attitude, stress handling, or team collaboration, which would require further investigation during an interview.