Healthcare Process Automation for DPJP Recording and BPJS Claim Support
Internship Project • Data Operations • Python • Workflow Automation
Built a Python and Streamlit-based automation system to support DPJP determination, healthcare administrative data validation, and structured operational reporting at RSUD Dr. (H.C.) Ir. Soekarno Bangka Belitung.
Impact: Reduced the data retrieval workflow from around three months of manual checking to one day of automated extraction with validation support.
Status: Still used by RSUD since August 2024 – Present.
Problem
Staff previously had to manually access SIMRS, enter patient MRNs, and check admission dates, emergency visits, surgery records, and other administrative data one record at a time, creating a slow and error-prone workflow.
Solution
Developed an automation workflow that retrieves, validates, and structures data from PDF, Excel, and SIMRS sources into standardized Excel outputs for verification and operational use.
Data Sources
PDF files, Excel files, and SIMRS data retrieved through SOAP-based requests and prepared for downstream validation and reporting.
Methodology
Data ingestion -> validation and cleaning -> fallback handling -> structured export for verification, reporting, and operational review.
Tech Stack
What I Delivered
- Built a Python-based automation workflow and Streamlit interface for operational use.
- Integrated PDF, Excel, and SIMRS sources into a single structured processing pipeline.
- Implemented fallback handling and validation checks for missing, incomplete, or unavailable data.
- Generated structured Excel outputs used by stakeholders for verification, reporting, and administrative decision-making.
