Summary
Teamed up with an independent programmer to develop the Dependent Eligibility Verification Audit department's inaugural automated error report. This innovative solution meticulously examined every audit, significantly enhancing the efficiency and accuracy of error checking, ultimately leading to higher quality audits.
Utilized advanced Excel techniques, including V-lookup formulas and Pivot Tables, to perform data manipulation. This involved creating and validating census files and establishing an import process for a proprietary audit system. By leveraging these techniques, I ensured the accuracy and integrity of data, streamlining the audit process and facilitating seamless data integration.
Aon
A multinational corporation specializing in administrating insurance, pension, and health insurance plans
From 2012 to 2013, I served as a Benefits Operations Administrator (Pension) within the Pension team. In this role, I managed the setup of pension benefit payments for a Fortune 500 corporate client with multiple intricate pension plans.
One of my key responsibilities was to calculate and initiate refunds for changes in premium amounts for health benefits. I meticulously identified instances where retirees' pension benefits were incorrectly deducted, ensuring the timely and accurate reimbursement of these premiums.
Through my work as a Benefits Operations Administrator, I played a crucial role in ensuring the smooth administration of pension benefits and resolving any discrepancies related to health benefit deductions.
2008-2013
Winston-Salem, NC
From 2008 to 2012, I worked as a Benefits Specialist and Operations Administrator (DEVA) within the Dependent Eligibility Verification Audit department. In this role, our primary objective was to conduct audits for clients, ensuring that their employees were providing health insurance benefits exclusively to eligible dependents as per the client's plan requirements.
I collaborated closely with an independent programmer to develop the DEVA department's inaugural automated error report. This groundbreaking solution thoroughly examined each audit, significantly streamlining the error checking process, and leading to improved audit quality and efficiency.
As part of my responsibilities, I extensively utilized advanced Excel techniques, including V-lookup formulas, Pivot Tables, and more. This allowed me to perform precise data manipulation, particularly in creating and validating census files. Additionally, I successfully devised an import process for a proprietary audit system, facilitating seamless data integration and enhancing overall audit effectiveness.
Through my contributions as a Benefits Specialist and Operations Administrator, I played a pivotal role in driving accuracy and efficiency in the DEVA department. By leveraging advanced Excel methods and collaborating on the creation of automated error reports, I significantly enhanced the quality of audits and streamlined critical processes.