Muhammad Rayyan · Data Reporting Analyst
Faster reports.Reliable numbers.For healthcare finance.
I build automated reporting workflows, accounts-receivable analysis, decision-ready dashboards, and dependable data-processing tools using Python, SQL, Microsoft Excel, and Power BI.
2+ years in healthcare RCMIBM Data Science Certified2 published case studies
- Excel
- Power BI
- Python
- Playwright
- pandas
- PostgreSQL
Selected work
Case studies
Healthcare reporting automation and data-quality work, with outcomes and their basis kept inside each case study.
Accounts Receivable · Automation
Payer-Claim Aging Report Automation
A desktop-controlled workflow that downloads provider aging exports from an enterprise reporting portal and builds a multi-sheet Excel workbook with bucket-level accounts-receivable analysis.
Reporting · Automation
eReports Healthcare Reporting Toolkit
A Python desktop toolkit that consolidates recurring spreadsheet, text, CSV, and PDF reporting workflows into one interface with shared data-processing modules.
Expertise
Four areas of practice
Accounts receivable and aging
Bucket analysis, payer-claim aging, days in AR, and AR review workflows.
Reporting automation
Browser and desktop workflows that reduce manual report pulls and spreadsheet preparation.
Data quality and normalisation
Fixed-width exports, encoding detection, and schema alignment across source systems.
Operational analytics
Decision-ready dashboards and analytical reports built with Power BI, Microsoft Excel, SQL, and Python.
Toolkit
Tools by function
Analysis and reporting
- Microsoft Excel
- Power BI
- Python
- SQL
- pandas
- NumPy
Databases and data tools
- PostgreSQL
- MySQL
- DuckDB
- DBeaver
Automation and output
- Playwright
- openpyxl
- XlsxWriter
- CustomTkinter
- pdfplumber
- PyInstaller
Healthcare reporting context
- 837/835
- CARC/RARC
- CPT/ICD-10
- days in AR
- clean claim rate
Profile
Healthcare reporting, made dependable
I combine revenue-cycle context with practical automation so recurring reports are easier to run, review, and trust.
My work spans accounts-receivable analysis, portal automation, reusable Python tools, and decision-ready Microsoft Excel and Power BI reporting. The About page covers the professional context; the case studies show how the workflows are structured.
Contact
Discuss an analytics role
Hiring, reporting work, or a question about a case study — email is the fastest path.