Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Mahesh Kumar Rajput

Delhi

Summary

Results-driven Senior MIS Reporting Analyst with Pacific BPO, adept at transforming healthcare data into actionable insights using SQL and Power BI. Proven expertise in developing HIPAA-compliant data models and interactive dashboards, while ensuring data integrity and compliance. Strong collaborator with a keen attention to detail, enhancing decision-making processes across clinical and operational teams.

Overview

5
5
years of professional experience

Work History

Senior MIS Reporting Analyst

Pacific BPO - Shared Service (US Healthcare Operations)
Noida
01.2023 - Current
  • Skilled in collecting, cleaning, and transforming healthcare data from EHR/EMR systems and claims databases using SQL and Power BI.
  • Proficient in developing HIPAA-compliant data models, writing DAX formulas, and building interactive dashboards for clinical and operational insights.
  • Experienced in implementing row-level security (RLS), optimizing the performance of large healthcare datasets, and automating report refreshes in Power BI Service.
  • Adept at translating healthcare business requirements into actionable analytics solutions, collaborating with clinical, operational, and executive stakeholders.
  • Strong focus on data governance, regulatory compliance, data quality assurance, and troubleshooting healthcare data issues.
  • Continuously expanding knowledge of SQL, Power BI, healthcare analytics trends, and evolving regulations to drive informed decision-making.
  • USA Healthcare Operations

MIS Executive

TransUnion - Analytics Depart. (Financial Operations)
New Delhi
01.2020 - 12.2022
  • Skilled in collecting, compiling, and managing large volumes of financial and operational data to generate accurate MIS reports.
  • Proficient in analyzing key financial KPIs (collections, aging, billing), and maintaining real-time dashboards for performance tracking.
  • Experienced in automating financial reports using Excel, SQL, and Power BI, while supporting audits, reconciliations, and compliance requirements.
  • Collaborates with finance, accounting, and operations teams to ensure data integrity, confidentiality, and support for month-end and year-end closures.

Education

Bachelor of Commerce -

Chaudhary Charan Singh University
Meerut, India
01.2006

Skills

  • SQL and SQL Server
  • Python programming
  • Data manipulation with Pandas
  • Data analysis with NumPy
  • Statistical analysis
  • ETL processes
  • Data visualization techniques
  • Power BI expertise
  • Excel proficiency
  • Data modeling
  • Healthcare analytics
  • Financial analysis
  • Dashboard development
  • Stakeholder collaboration
  • Attention to detail
  • Forecasting

Projects

Analysis on Insurance & Patient Payment, 11/01/24, 12/31/24, Analyzed Claim behavior and revenue trends using complex SQL queries to optimize Denials and Payment., Used tools as Excel, SQL and Power BI., Provided actionable insights on claim performance to drive business decisions to stockholder. Financial Database Analysis, 04/01/22, 05/31/22, Analyzed customer behavior and revenue trends using complex SQL queries to optimize sales and marketing., Used tools as Excel and SQL., Provided actionable insights on product performance to drive business decisions.

Timeline

Senior MIS Reporting Analyst

Pacific BPO - Shared Service (US Healthcare Operations)
01.2023 - Current

MIS Executive

TransUnion - Analytics Depart. (Financial Operations)
01.2020 - 12.2022

Bachelor of Commerce -

Chaudhary Charan Singh University

Similar Profiles

CREATE PROFILE
Mahesh Kumar Rajput