Manager State University

Komi A. Amefia

***** ***** ****, ********** ** **874

(517) 980 - 5665 ********@*****.***

Summary of Qualifications

Benefits administrator with strong technical skills

Excellent analytical, problem solving skills

Good knowledge of PeopleSoft pension module and North America payroll

Implementation of large size client: spreadsheet design and calculation validation

Well-versed in C++, PL-SQL, Microsoft Access and PeopleSoft query manager

Professional Experience

PeopleSoft Pension Benefit Calculator Consultant October 2015- December 2016

State of Connecticut PeopleSoft Pension Project (Accenture) Hartford, CT

Participated in the implementation of PeopleSoft 9.2 pension module

Configured and/or reviewed configuration for the following PeopleSoft 9.2 pension module components: Eligibility, benefit formula, final average salary, vesting and credited services

Create the design document and lead the implementation of a Disability calculation system that takes in outside earnings to offset Minimum, maximum and statutory benefit based on a set of rules

Create the design document and lead the build of a customized retirement application page that store protected calculations initiated from the page using an assigned retirement application number

Create a design that modify a batch finalization process to add the ability to calculate and review overpayment/underpayment amounts for service and disability calculations and generate a report

Reviewed all test scripts to insurance all functionalities are tested and performed unit and system testing as needed.

Senior Consultant February 2015- July 2015

City of Nashville PeopleSoft Pension Project (Deloitte) Nashville, TN

Helped in the initial phase of the implementation of PeopleSoft 9.2 pension module

Participated in the design of the As-is process to capture retirement processes

Retirement plans gathering and calculations process mapping

Trained technical team on retirement processes

Created a VBA tool to loop through hundreds of Excel workbooks to print specifics worksheets

Senior Pension Specialist March 2013-October 2014

Freeport McMoRan Phoenix, AZ

Processed and reviewed manual calculations and ensured accuracy of system generated calculations

Prepared written communications for participant inquiries

Produced 2012 annual employees’ pension statements

Managed 2008 termination calculations cleanup projects

Analyzed and manipulated participant data in various formats including Microsoft Excel

Reviewed Northern Trust entries and reconciled retirement payments

Responsible for the daily administration of company life insurance claim and retiree medical enrollment processes

Pension Specialist December 2010-November 2012

Navistar Downers Grove, IL

Calculated pension benefits for salaried and UAW union employees

Responsible for executives benefit calculations, QDRO’s, subpoenas and researches

Prepared and analyzed 2010 and 2011census data for valuation

Maintained PeopleSoft data integrity and completed reports using query manager

Working with developers to configure pension estimate self service module in PeopleSoft 9

Explained pension information to all level of employees

Benefits Operations Administrator October 2007- September 2010

AonHewitt Lincolnshire, IL

Contributed to the smooth implementation of a large client on the Hewitt Associates retirement platform (Calc. engine, total benefit system (TBA) and Others)

Calculated pension benefits for 21 qualified and nonqualified plans

Developed spreadsheets to calculate cash balance, final average and contributory benefits

Provided training to newly hired benefits administrator on complex calculations

Performed system testing and calculation validations.

Education

Bachelor of Science Mathematics, 2006

Michigan State University, East Lansing, MI

Professional development and Training

Defined Benefits Types and Formulas, October 2007

The fundamentals of Health benefits Management, January, 2008

Queries in DB2 Environment, March 2011

Customer Experience Ownership Certification, May 2012

Skills

Software: Matlab, Minitab, Microsoft Excel, Word, PowerPoint

Programming: C, C++, HTML, VBA, PS-SQL

Language: English, French

Contact this candidate