Power Bi Reporting Analyst

KENNETH J. CARR

Bellwood, IL ***** 708-***-****

************.****@*****.***

DATA & REPORTING ANALYST HEALTHCARE &

MEDICAID ANALYTICS

Data and reporting analyst with extensive experience in healthcare and managed care sectors, specializing in Medicaid data reporting, SQL-based analytics, automation, and business intelligence tools. Adept at integrating data from multiple sources, developing automated reports, and supporting clinical operations through insights and compliance reporting.

CORE COMPETENCIES

Medicaid Data Analysis & Reporting

SQL Query Development (SQL Server, Teradata)

Power BI, Tableau, QlikView Dashboarding

Data Integration & Quality Assurance

Automated Reporting (Power Automate, Alteryx)

Healthcare & Claims Data Analytics

Compliance & State Reporting

SharePoint List Management

PROFESSIONAL EXPERIENCE

CENTENE INSURANCE Senior Data Analyst 04/2022 – Present

• Designed and maintained Medicaid provider, credentialing, and claims data reports, ensuring compliance with state and federal reporting requirements.

• Developed SQL queries and Power BI dashboards to track key performance metrics, provider network adequacy, and operational efficiency.

• Automated recurring reports using Power Automate and Alteryx, reducing manual processing time by 30%.

• Led initiatives to improve data quality and integration, reconciling provider records across multiple systems.

• Partnered with Medicaid operations teams to generate ad- hoc and regulatory reports, ensuring timely and accurate submissions.

WOLCOTT WOOD & TAYLOR Medical Revenue Data

Analyst 08/2021 – 03/2022

• Extracted and transformed Medicaid claims data from multiple sources, optimizing data structures for payer analytics.

• Built interactive Power BI reports to visualize revenue cycle trends and payer reimbursement patterns.

• Created standardized reporting templates in EPIC

(Workbench, SlicerDicer) for Medicaid claims analysis.

• Collaborated with IT and business stakeholders to enhance self-service reporting tools, improving data accessibility. CARDINAL HEALTH/BROOK SOURCE EDI Analyst

11/2020 – 06/2021

• Monitored and troubleshot EDI transactions (837, 835, 277CA, 270) for Medicaid claims processing.

• Analyzed provider data discrepancies and developed SQL- based solutions to correct errors.

• Partnered with IT teams to enhance data warehousing and integration processes for payer transactions.

EXPERIAN HEALTHCARE EDI Business Systems

Analyst 07/2012 – 10/2019

• Designed SQL scripts to monitor and validate Medicaid claim submissions, reducing rejection rates by 20%.

• Managed SFTP/FTP connections for automated claims and remittance processing.

• Created process documentation and training materials for EDI troubleshooting and Medicaid reporting workflows. TECHNICAL SKILLS

• Databases & Querying: SQL Server, Teradata, Toad, Alteryx

• BI & Reporting Tools: Power BI, Tableau, QlikView, SharePoint Lists

• Automation & Scripting: Power Automate, Excel VBA, iMacros

• EDI Transactions & Data Exchange: X12 (837, 835, 270/271, 277CA, 999)

• Healthcare Systems: EPIC, Cerner, IDX, Meditech

EDUCATION & CERTIFICATIONS

• Bachelor’s Degree in [Your Field] – [Your University]

• Power BI & SQL Certifications (if applicable)

This version highlights your technical experience, automation expertise, and Medicaid reporting skills, making it a strong match for the position. Let me know if you’d like any refinements!

Contact this candidate