Pavan Kumar M

Designed and implemented HIPAA-compliant relational database systems using MySQL, PostgreSQL, and MS SQL Server, maintaining high data accuracy and uptime. Optimized complex SQL queries, joins, and stored procedures to reduce average query execution time by 30% and cut infrastructure costs by 15%. Architected and maintained SSIS-based ETL pipelines to process 10M+ records monthly, and built Python (Pandas/NumPy) scripts for cleaning, validation, and transformations to reduce manual prep time by 35%. Developed Power BI and Tableau dashboards for operational KPIs including patient metrics and billing trends, and designed normalized 3NF data models (patient records, appointments, billing, treatment plans). Enforced data integrity using keys and constraints, partnered with stakeholders to translate requirements into schemas and reports, and supported disaster recovery documentation and protocols.

Performed complex extraction, transformation, and analysis on patient care and operations datasets to identify efficiency improvements. Designed and deployed 15+ SSRS dashboards with drill-through and parameterized reporting, reducing turnaround time by 25%. Improved database performance by 20% via indexing, query refactoring, and stored procedure optimization. Reduced data entry errors by 10% by streamlining workflows with clinical and administrative teams, and delivered ad-hoc and scheduled reports to hospital leadership with clear, actionable summaries.