Senior BI Analyst & Data Modelling Specialist

ROHIT KUMAR

Senior BI Analyst & Data Modelling Specialist

Delhi +91-850******* ****************@*****.*** LinkedIn PROFESSIONAL SUMMARY

BI Analyst with 7+ years of experience across finance, healthcare and IT analytics, specialising in semantic layer design, enterprise data modelling, and data governance. Experienced in translating complex business rules including lending metrics, risk weightings, AI-ready data products using Power BI, SQL, Python and Advanced Excel. Proven track record of unpicking legacy data complexity, standardising metric definitions across global platforms, and enabling business-led data discovery with full lineage traceability. Adept at partnering with Finance, Risk, Treasury and Technology teams as a translator, not a handoff point. CORE SKILLS

Business Intelligence & Reporting: Power BI, Tableau, Metrics Layer, KPI dashboards, Data storytelling Data Analytics & Engineering: SQL (query optimisation), ETL, SAS, Python, Data Lineage, Rule-building, Data governance frameworks

AI-Assisted SDLC: Cursor, GitHub Copilot, AI-accelerated data solution delivery. Domain Expertise: Lending Metrics, Healthcare Claims, Fraud Detection, Legacy Data Migration, Data Management.

Stakeholder & Delivery: Requirement gathering, Agile/Scrum, cross-functional collaboration, Finance/Risk/ Technology partnering

WORK EXPERIENCE

Assistant Manager (Data Analyst) Fresenius Medical Care Pvt. Ltd. 05/2025 – Present

• Oversaw team workload and balanced assignments, ensuring timely delivery of projects and optimal resource utilisation across BI initiatives.

• Designed and maintained data dictionaries aligned to Unity Catalogue standards, ensuring consistent measure definitions across bronze, silver and gold data layers for executive reporting.

• Prepared comprehensive monthly reports and led dashboard enhancement initiatives, improving data visibility and decision-making efficiency for C-level management.

• Managed Aravo and OnBoard (Jira) platforms to resolve internal team queries, streamline workflows and maintain operational efficiency.

• Leveraged AI coding tools (Cursor / GitHub Copilot) to accelerate development of SQL pipelines and DAX measures, reducing solution delivery time by approximately 25%.

• Designed and delivered executive dashboards tailored for C-suite, providing actionable insights and supporting strategic decision-making.

Project / Contractual Based

Senior Data Analyst Infoneo Technology Pvt. Ltd. 11/2024 – 04/2025

• Led a government BI project developing a financial reporting dashboard for the Ministry of Finance, translating complex finance business rules into a structured Power BI data model with fully documented measure definitions.

• Collaborated with Finance stakeholders to trace KPIs back to source systems, identify data lineage gaps and resolve reconciliation discrepancies between legacy reporting outputs and the new BI layer.

• Designed a semantic layer encoding business logic, measure definitions and hierarchies so downstream consumers and AI agents could query data without interpreting raw schema or guessing metric calculations.

• Enabled NLQ / Conversational BI capability, reducing daily reporting effort by 50% and empowering non- technical stakeholders to extract insights without SQL dependency. Project / Contractual Based

Senior Associate (Data Analyst) Neotas Development Pvt. Ltd. 02/2024 – 08/2024

• Delivered interactive Power BI dashboards with a governed semantic layer, standardising KPI and measure definitions to eliminate inconsistent metric calculations — improving client satisfaction by 30%.

• Optimised SQL queries and ETL processes, reducing data processing time by 25% through query restructuring and pipeline automation.

• Defined and standardised KPI definitions and dimensional structures, establishing a single source of truth that enabled leadership to monitor performance in real time with full metric traceability.

• Partnered with HR and Finance teams to analyse expenditure and hiring trends, reducing workforce costs by 10% through data-driven recommendations.

Data Analyst Surgical Notes (Zulu Health SN IT Services Pvt. Ltd.) 09/2022 – 02/2024

• Unpicked legacy fraud rule complexity, rationalising overlapping and conflicting detection logic to produce cleaner, business-aligned deterministic and probabilistic models — reducing false positives by 20%.

• Validated silver-layer data models against source systems, investigating bronze-layer anomalies and ensuring data was correct and usable before downstream BI consumption.

• Built clinical rule validation dashboards in Power BI, increasing optimisation efficiency by 30% through structured measure validation and real-time rule monitoring.

• Improved true positive rate (TPR) of fraud detection models by 15% through iterative rule refinement and statistical overpayment analysis.

• Collaborated with U.S. healthcare clients to deliver BI solutions tailored to claims adjudication, tracing metrics back to source systems and resolving data trust issues. Project / Contractual Based

Research Associate Netrika Consulting India Pvt. Ltd. 11/2021 – 07/2022

• Developed statistical models and key driver analyses to derive actionable business insights, supporting strategic decision-making and budgeting processes.

• Delivered MIS dashboards for performance metrics with standardised measure definitions, improving forecasting accuracy and reducing reporting ambiguity.

• Managed organisational data governance processes and maintained data integrity for executive reporting. Lead Analyst (DMA) Indian Academy of Law and Management 02/2020 – 10/2021

• Managed client data using Salesforce, optimising engagement through targeted campaigns and data-driven segmentation.

• Produced Excel-based dashboards and performance reports to support executive decision-making. MIS Executive VidyaPro Services 11/2018 – 02/2020

• Organised and maintained student and staff data, streamlining operations and improving data accessibility.

• Conducted research to address educational challenges, producing MIS reports that enhanced institutional decision-making.

EDUCATION

MBA (Finance) — Chandigarh University 01/2023 – 12/2024 B.Sc. (Computer Science) — Rajdhani College, University of Delhi 06/2015 – 12/2018 KEY PROJECTS

Finance Dashboard — NCGTC, Ministry of Finance

• Translated complex finance business rules including lending metrics, risk weightings and transaction flows into a structured Power BI data model with fully documented measure definitions.

• Designed and built a semantic layer encoding calculation logic so non-technical users and AI agents could query data accurately without interpreting raw schema.

• Developed a data dictionary aligned to governance standards, standardising metric definitions across reporting teams and eliminating historically inconsistent calculations.

• Enabled NLQ / Conversational BI capability — reducing daily reporting effort by 50% and empowering stakeholders to extract insights without SQL or analyst dependency. Healthcare Claims BI Dashboard — Surgical Notes

• Built a real-time Power BI dashboard integrating SQL-based rule validation data with a governed semantic layer for U.S. healthcare claims adjudication.

• Validated silver-layer models against legacy source data, resolving data trust issues and ensuring downstream reporting accuracy.

CERTIFICATIONS

• Fundamentals of Data Science — Coursera

• Power BI — Internshala

• SQL, Tableau — 365 Data Science

• Investment Banking & Corporate Finance — 365 Data Science

• Databricks Fundamentals (in progress)

ADDITIONAL INFORMATION

Languages: English, Hindi

Domains: Finance, Healthcare, IT, Education, Fraud Detection, Risk Management, Legacy Data Migration.

Contact this candidate