About
Healthcare Reporting Automation Analyst specializing in SQL, Python, and Excel-based workflow automation for clinical and operational reporting.
Experienced in rebuilding broken reporting pipelines, reducing manual reporting effort by up to 85%, and improving healthcare data integrity across multi-site organizations.
Proven track record of automating ETL workflows and delivering scalable reporting solutions supporting finance, operations, and clinical leadership.
What I'm looking for
I'm seeking a remote Data Analyst, Reporting Automation Analyst, or Healthcare Data Analyst role where I can use SQL, Python, and Excel to automate reporting, improve data quality, and deliver actionable insights. I enjoy solving complex data challenges, streamlining manual processes, and partnering with cross-functional teams to build scalable reporting solutions that support better business decisions.
Experience
Healthcare Data Consultant
Jess Hayden Consulting
May 2025 – Present
Developed healthcare-focused service offerings in reporting automation and data quality service for operational and clinical workflows at jesshaydenconsulting.com.
• Built a HIPAA Safe Harbor de-identification pipeline using PostgreSQL, Python, and Streamlit for healthcare data masking, redaction, and compliance scoring.
• Expanded technical expertise through hands-on analytics projects, healthcare data engineering initiatives, and professional networking within the regional data community.
PostgreSQLPythonStreamlit
Reporting Analyst
Persante Health Care
Dec 2021 – May 2025
Automated 30+ recurring and ad hoc reporting workflows using SQL, Python, and Excel, reducing manual processing time by up to 85% across 7 departments.
• Automated sleep study delivery workflows with SQL and Python, reducing processing from 2 hours to 5 minutes while eliminating document misfiling.
• Served as sole technical SME for physician interpretation templates, independently resolving 50+ production support tickets involving C# logic, SQL queries, and variable mapping.
• Led a data deduplication initiative resolving 1,500+ duplicate physician IDs and restoring accurate patient-provider matching across the network.
• Delivered payer classification and CMS-related reporting supporting finance and billing operations.
• Built automated Excel dashboard solutions with Python and openpyxl, reducing reliance on Power BI licensing for operational reporting.
• Analyzed patient cancellation trends across 30 hospital clients, identifying insurance denial patterns that informed referral and scheduling strategy adjustments.
• Developed a data dictionary documenting table relationships, primary/foreign keys, and field definitions that accelerated SQL development and supported the physician ID deduplication initiative.
SQLPythonExcel
Order Specialist
Burlington Stores
Mar 2020 – Dec 2021
Processed and validated merchandise purchase orders using advanced Excel functions including VLOOKUPs and pivot tables to ensure data accuracy.
ExcelVLOOKUPPivot tables
Operations Analyst
InsPro Technologies
May 2014 – May 2019
Coordinated migration validation testing across multiple insurance software implementations, ensuring system functionality and data integrity.
• Analyzed GL and claims extract discrepancies in Excel and delivered reconciliation findings for client resolution.
• Executed recurring SQL scripts supporting annuity data integrity and operational maintenance processes.
• Partnered with development teams using Agile workflows and JIRA to track validation defects, root causes, and deployment readiness.
• Maintained SOPs and validation documentation supporting operational consistency and onboarding efficiency.
SQLExcelJIRA
Education
Camden County College
Associates of Science · Business Administration
Certifications
Microsoft Professional Program for Data Science
Microsoft
Jan 2020 – No expiry
Skills
Data AnalysisAzure Data StudioHIPAAclinical reportingJIRAData quality assuranceRevenue cycle analyticsHealthcare reportingGitHub CoPilotChatGPTClaudeTableauPower BIExcelMySQLPostgreSQLGitETL automationSQLPython
Languages
English (Native or bilingual proficiency)
