Open to opportunities

Kartik Jajoria

@kartikjajoria

Message

I turn hospital and operational data into SQL reports and Power BI dashboards.

India

Message

What I'm looking for

I'm looking to use SQL, Python, and Power BI to turn operational data into validated reports, KPI dashboards, and insights that support business decisions.

At CRonus MultiSpeciality Hospital, I turn patient, billing, admission, and discharge data into clean, analysis-ready reporting for operational teams.

I build daily, weekly, and monthly MIS reports covering patient volume, departmental performance, and revenue trends. I also create interactive Power BI dashboards that help stakeholders identify hospital KPI trends quickly.

I validate imperfect operational data using SQL, Python, Excel, and cross-checks such as VLOOKUP, pivot tables, and conditional formatting before it reaches reports.

My projects include bank loan KPI dashboards, Diwali sales analysis, medical sales analysis, finance reporting, hotel booking cancellation dashboards, and spam-versus-ham text classification using Python and Word2Vec.

Experience

Work history, roles, and key accomplishments

Data Analyst

CRonus MultiSpeciality Hospital

Mar 2025 - Apr 2026 (1 year 1 month)

Queried and maintained patient, billing, admission, and discharge data across hospital systems and Excel, applying data cleaning and validation checks. Built daily, weekly, and monthly MIS reports and designed interactive Power BI dashboards to visualize key hospital KPIs.