Benefits Analyst - Compliance & Data Reporting

Venkata Naga Anil Kumar Chowdary Poka

Benefits Analyst

Michigan, USA (269) 291- 3119 ************@*****.*** LinkedIn GitHub SUMMARY

Benefits Analyst with 4+ years of experience supporting benefits administration, eligibility, enrollment, premium analysis, reconciliation, and reporting, helping organizations maintain accurate, cost-effective, and employee-focused benefits operations.

Improved benefits data accuracy and reporting through SQL, Advanced Excel, Power Query, Power BI, and Tableau, giving HR and leadership clearer visibility into costs, enrollment trends, and operational issues.

Supported payroll, carrier, vendor, and benefits invoice reconciliations, resolving discrepancies that helped reduce payment errors, prevent unnecessary costs, and strengthen financial control across benefits programs.

Managed benefits processes in line with ACA, COBRA, ERISA, audit, and documentation requirements, reducing compliance risk while supporting consistent and reliable benefits administration.

Partnered with HR, payroll, vendors, carriers, and business teams to improve workflows, support UAT, resolve and build scalable benefits processes that supported workforce growth and better employee experience. EDUCATION

Anderson University, USA

Master of Science in Computer Science

Dhanekula Institute of Engineering & Technology

Bachelor of Information Technology

EXPERIENCE

Binson’s Home Health Care, USA Benefits Analyst Jan 2025 – Present

Verified health insurance eligibility and Health & Welfare benefits through payer portals for 500+ patient cases each month, helping prevent coverage issues and improving pre-service verification accuracy by 22%.

Reviewed PPO, HMO, and HDHP coverage against Epic patient records, corrected plan and eligibility mismatches before claims were submitted, and kept insurance, clinical, and billing information aligned.

Reviewed planned versus actual benefit costs in Tableau, investigated premium and enrollment variances, and helped the benefits team resolve higher-cost exceptions before monthly reporting was finalized.

Used SQL to validate eligibility, enrollment, premium, and claims data across 100K+ healthcare records, identified mismatches between payer and internal systems, and improved benefits reporting accuracy by 18%.

Worked with benefits and operations teams to understand eligibility, enrollment, and payer requirements, then documented BRDs and FRDs in Confluence for system changes and process improvements.

Supported benefits reporting data hosted on AWS, checked availability and completeness of eligibility and premium information, and helped teams access consolidated data for operational reporting and analysis.

Managed insurance verification requests through ServiceNow, prioritized urgent patient cases, documented follow- ups and resolutions, and helped close open tickets within established SLA timelines.

Handled member and patient information in line with HIPAA and internal privacy procedures, ensuring PHI and PII were shared only with authorized teams and approved business partners.

Reviewed Medicare Advantage coverage requirements using CMS resources, clarified benefit rules for DME and home-based services, and helped reduce escalations caused by incorrect coverage interpretation.

Managed 500+ monthly coverage and billing cases by validating Claims Data and Eligibility Data, reviewing ICD-10, CPT, and HCPCS details, prioritizing urgent requests, and coordinating with stakeholders to resolve discrepancies. Wipro, India Benefits Analyst Sep 2020 – Jun 2023

Analyzed employee benefits costs using Microsoft Excel across 5,000+ employee records, identified premium and deduction variances, and improved monthly benefits reconciliation accuracy by 18%.

Used Python and Pandas to review historical benefits spending and enrollment patterns, identified unusual cost movements, and improved preparation of annual benefit budget assumptions

Built Power BI dashboards covering enrollment, premium costs, employer contributions, and utilization trends, giving HR and Finance teams clearer visibility into monthly benefits spending.

Maintained employee eligibility and benefit enrollment records in Workday for 4,500+ employees, corrected coverage inconsistencies, and reduced enrollment-related support cases.

Validated payroll and benefits deductions through ADP Workforce Now for multiple pay cycles, investigated incorrect deductions, and improved alignment between payroll records and benefit elections.

Standardized carrier billing files through Power Query, combined enrollment and premium information from 10+ source files, and shortened monthly benefits reporting preparation.

Maintained benefit plan configurations within HRIS platforms, updated eligibility rules, coverage tiers, deduction codes, and life-event settings, reducing configuration-related errors by 20%.

Managed benefits requirements, reconciliation issues, and process changes in Jira, maintained clear ownership across HR, Payroll, Finance, and vendors, and improved issue closure visibility.

Produced executive benefits cost summaries in Microsoft Access using enrollment, payroll, and carrier data, identified year-over-year cost trends, and supported annual renewal and budgeting discussions.

Conducted monthly vendor reconciliation meetings with HR, Payroll, Finance, carriers, and TPAs, reviewed outstanding discrepancies, and reduced aged reconciliation items by 25%. SKILLS

Benefits Administration &

Analysis

Benefits Administration, Eligibility Analysis, Enrollment Analysis, Benefit Cost Analysis, Premium Analysis, Variance Analysis, Benefits Reconciliation, Open Enrollment, Life Event Processing

Employee Benefits Medical Benefits, Dental Benefits, Vision Benefits, Life Insurance, Disability Benefits, Retirement Benefits, 401(k), HSA, FSA, Employee Assistance Programs

(EAP)

Data & Reporting SQL, SQL Server, Advanced Excel, Power Query, PivotTables, XLOOKUP, INDEX-MATCH, Power BI, Tableau, Data Validation, Benefits Reporting Benefits Systems & HR

Technology

Workday, ADP, Oracle HCM, SAP SuccessFactors, HRIS, Benefits Administration Systems, Payroll Systems, Employee Self-Service Portals Business Analysis Requirements Gathering, Gap Analysis, Root Cause Analysis, Process Mapping, BRD/FRD, User Stories, Acceptance Criteria, UAT, Defect Tracking Vendor & Carrier Management Vendor Management, Benefits Carrier Coordination, TPA Coordination, Eligibility File Validation, Vendor Performance Tracking, SLA Monitoring Payroll & Reconciliation Payroll-Benefits Reconciliation, Benefits Invoice Reconciliation, Premium Reconciliation, Deduction Validation, Enrollment Reconciliation, Billing Validation, Discrepancy Resolution

Process & Collaboration Tools Jira, Confluence, Microsoft Visio, SharePoint, Microsoft Teams, ServiceNow Other Skills Open Enrollment Support, Employee Benefits Communication, Audit Support, Stakeholder Management, Client Reporting, Benefits Data Analysis, Issue Resolution, Documentation, Cross-Functional Coordination CERTIFICATION

Microsoft Certified: Power BI Data Analyst Associate (PL-300) Google Data Analytics Professional Certificate: Google (Coursera)

Contact this candidate