Summary
Overview
Work History
Education
Skills
Additional Information
Certification
Software
Accomplishments
Websites
Interests
Hobbies
Timeline
Generic

MOHD RIZVAN

Senior Analyst | Benefits Administrator & Data Management
Mumbai

Summary

Results-driven Benefits Analyst with 6+ years of experience in U.S. Health & Welfare and Retirement domains. I specialize in annual enrollment, vendor file management, LOA, COBRA, payroll, and EDI processes. Skilled in SQL, Advanced Excel, IBM Mainframe, Power BI, and client communications.

Overview

7
7
years of professional experience
5
5
Certifications
2
2
Languages

Work History

Global Benefits Analyst

Accenture India Pvt. Ltd.
Mumbai
05.2025 - Current
  • Managed end-to-end process transitions and documentation.
  • Manage LOA processes (FMLA, STD, LTD, ADA); ensure timely documentation, payroll alignment, and compliance.
  • Led UAT testing for 2 major client transitions, identifying and resolving system issues before go-live, reducing post-launch errors by 85%.
  • Managed and resolved 30–40 client and employee queries daily via email and phone, maintaining a high client satisfaction rating.
  • Prepared and validated accurate census reports for vendors.
  • Performed UAT testing for system changes and enhancements.
  • Worked with stakeholders to address benefit inquiries and train new hires.
  • Utilize SQL, Power BI, and Excel (PivotTables, XLOOKUP) for reporting and dashboards.
  • Identify and report premium overpayments, and initiate refunds.
  • Conduct daily huddles with stakeholders, and resolve escalations.
  • Process payroll adjustments, overpayments, refunds, and ACH transactions for terminated employees.
  • Lead client discussions, support issue resolution, and maintain SOP compliance.
  • Collect and validate documentation for QLEs and DVS processes.
  • Provide employee education on enrollment systems, and resolve benefit-related queries.
  • Stakeholder Collaboration: Worked with stakeholders to address benefit inquiries and train new hires.
  • Escalation Resolution: Resolved complex issues, including eligibility discrepancies.
  • Payroll and Payments: Processed payroll adjustments, refunds, and ACH payments.
  • Data Security: Maintained HIPAA-compliant data handling.
  • Data Accuracy: Verified HRI data via mainframe systems.

Benefits Analyst

Conduent Business Services
Noida
12.2023 - 05.2025
  • Oversee EDI file transmissions with vendors for medical, dental, vision, disability, and life insurance.
  • Reconciled and processed premium billing worth over $200,000 monthly, identifying variances and ensuring accurate invoicing.
  • Coordinated 25+ weekly EDI/vendor file transmissions, proactively resolving discrepancies and avoiding payroll or benefit errors.
  • Reduced processing time by 30% by optimizing Excel-based reports and implementing automation via advanced formulas and SQL queries.
  • Maintained SOPs and process guides for audit readiness.
  • Support COBRA administration by sending timely notices, tracking eligibility, and ensuring audit readiness.
  • Improve process efficiency through automation, issue tracking, and continuous improvement initiatives.
  • Ensure HIPAA, ERISA, ACA, and IRS compliance in all benefit communications and data handling.
  • Manage LOA processes (FMLA, STD, LTD, ADA) with timely documentation and coordination.
  • Manage HSA/FSA enrollments, discrepancies, and payroll alignment.
  • Use Advanced Excel, SQL, for benefit reporting, and data analysis.
  • Administer EOI tracking, and coordinate decisions with insurance carriers.
  • Maintain and update SOPs; onboard and train new team members on benefits systems and processes.

Benefits Operations Administrator

Wipro HR Services Pvt. Ltd.
Gurugram
02.2022 - 12.2023
  • Managed U.S. Benefits operations, including LOA, COBRA, Medicare, Medicaid, and HIPAA compliance.
  • Processed 100+ benefit enrollment and change requests weekly during annual enrollment and qualified life event (QLE) periods, ensuring 99% accuracy and compliance with client policies.
  • Track and resolve evidence of insurability (EOI) and dependent verification cases.
  • Led the Annual and Open Enrollment with minimum error reduction.
  • Handled COBRA notices, eligibility, and participant queries.
  • Processed LOA cases, DBP billing, and payroll adjustments.
  • Managed ACH payments, premium refunds, and reconciliations.
  • Resolved vendor issues, and coordinated EOI approvals.
  • Created SOPs and trained new team members.
  • Used Excel, SQL, and Mainframe for audits and reporting.
  • Led client calls and daily huddles for escalations and updates.
  • Process Qualified Life Events (QLEs), and validate supporting documentation as per IRS policy.
  • Administer and reconcile HSA, FSA contributions, and payroll deductions.

Benefits Administrator

Teleperformance Global Services Pvt. Ltd.
Gurugram
06.2018 - 02.2021
  • Managed QLE cases for events such as marriage, birth, divorce, and loss of coverage.
  • Collected and verified supporting documents (certificates, court orders, etc.).
  • Ensured updates aligned with IRS rules and employer policies.
  • Maintained HRIS and benefits systems with accurate dependent data.
  • Conducted audits to identify and remove ineligible dependents.
  • Supported employees with QLE education and document guidance.
  • Assisted in exception reviews and appeals processing.
  • Improved employee experience through timely communication and resolution.
  • I sent reminders and handled escalations for pending documentation.

Education

Bachelor of Arts -

Dr. Ram Manohar Lohia Awadh University
Utter Pradesh, India
07-2018

Skills

HRIS knowledge

Microsoft Excel

Verbal and written communication

Interpersonal skills

Attention to detail

Decision-making

Multitasking Abilities

Leadership skills

Additional Information

Excel – Creating Pivot Tables, Power Query, Power Pivot, and advanced charts.

Formulas & Functions: ▪ LOOKUP: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH

Logical: IF, IFS, AND, OR IFERROR

Text: CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, TRIM

Date & Time: TODAY, NOW, DATEDIF, EOMONTH,

Statistical & Math: COUNTIF, SUMIF, AVERAGEIF, ROUND, RANK

Data Cleaning & Transformation – Using Power Query, removing duplicates, and handling large datasets efficiently.

Conditional Formatting & Data Visualization – Creating dashboards with charts, graphs, and heatmaps.

Excel for Financial & Benefits Analysis – Using Excel for payroll, benefits cost analysis, and reconciliation reports.


SQL Skills: Data Retrieval & Querying – SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOINs, WINDOW FUNCTIONS

Data Filtering & Aggregation – COUNT, SUM, AVG, MIN, MAX, DISTINCT

Joins & Subqueries – INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, subqueries

Data Manipulation – INSERT, UPDATE, DELETE

Data Validation & Integrity – Constraints, primary keys, foreign keys, normalization

SQL for Reporting & Analytics – Extracting data for BI and business reports

Tools: PostgreSQL, MS Access, PG Admin

Certification

HIPAA Compliance Training

Software

PostgreSQL, MS Access, PG Admin, Workday, IBM Mainframe, Excel, Outlook, Ms Access, Power Point, Basic Power BI, SuccessFactors, Salesforce, Popsconnect, Service Now, Darwin, NGDDarwin, Google Sheet

Accomplishments

• Open Enrollment, Benefits Administration, Vendor File Management

• SQL, Advanced Excel, Power BI, Mainframe, SharePoint, Jira • HRIS, PCS

• COBRA, HIPAA, ERISA, Compliance Audits

• FSA/HSA, Medicare, Medicaid, ACH, Lockbox Processing

• Premium Reconciliation, Payroll Adjustments

• Client & Stakeholder Communication, Analytical Thinking

• Issue Resolution, Report Generation, EOI, Life Events

Interests

Employee Benefits & HR Compliance Trends – Interested in following US HR trends, especially around FMLA, COBRA, and healthcare reform

Process Optimization & Automation – Passionate about finding smarter ways to streamline workflows using tech solutions and scripting tools

Hobbies

1.Exploring Data Tools – Enjoy learning and experimenting with new tools like Power BI, Excel add-ins, and SQL techniques in free time.

2.Watching Educational Videos – Regularly watch tutorials on platforms like YouTube to stay updated on Excel tricks, benefits compliance, and analytics.

Timeline

Global Benefits Analyst

Accenture India Pvt. Ltd.
05.2025 - Current

Benefits Analyst

Conduent Business Services
12.2023 - 05.2025

Benefits Operations Administrator

Wipro HR Services Pvt. Ltd.
02.2022 - 12.2023

Benefits Administrator

Teleperformance Global Services Pvt. Ltd.
06.2018 - 02.2021

Bachelor of Arts -

Dr. Ram Manohar Lohia Awadh University

Similar Profiles

CREATE PROFILE
MOHD RIZVANSenior Analyst | Benefits Administrator & Data Management