Proven expertise in insurance, banking, finance products, and customer services. Familiar with analyzing documentation, liaising between parties and handling both routine and complex issues each day. Identifies and resolves concerns while promoting new products and meeting sales objectives.
• Responsible for the timely and accurate completion of numerous complex and unique ASO/MRP/ERS/AWS/AS/HSA/C+/GSI/Compasses monthly billings and reports for high profile clients.
• Developing and maintaining excel spreadsheets for complex, policy level and multi-divisional billings
• Creating, updating and maintaining complex formulas in Excel, including interest calculations, used in client billings
• Following tax legislation guidelines to calculate taxes on billing and ensuring accurate disbursement to the appropriate government region
• Allocating expenses to the General Ledger for manually billed cases.
• Setting up new HSA policies on system
• Manually setting up new divisional HSA policies, including the creation of new Excel spreadsheets, corresponding and confirming with the Group Sales Office on rates & mailing info and setting up new folders and info cards based on the GIPA notice
• Manually creating new ERS, AWS and AS manual billings in Excel
• Adding HCSA (Division 98) to an existing ASO bill on the ASO system
• Creating MRP bills for Plan Sponsored Directed payment
• Balancing HCSA billing spreadsheet to the HCSA claims download. Responsible for handling Non-Insured commissions accurately and in a timely manner, which results in directly affecting and impacting the advisors' pay cheques.
• Balancing of MRP claims, expenses, taxes on manual billing to automated billing
• Merging GroupNet with Electronic BEN report listing for billing purposes
• Matching of BEN Reports to manual billing spreadsheet
• Mapping and using ASO, MRP and HSA archives
• Balancing of special spreadsheets to manual billings
• Creating and maintaining ASO Information cards and noting any special instructions
• Creating file folders for new groups
• Sorting, packaging, mailing and/or emailing of billings and claims information to clients, consultants and other GWL departments by specific deadlines
• Investigating and resolving billing inquiries from Group Sales Office and Underwriting that need immediate attention.
• Calculating and estimating the amount for annual ASO commissions, setting up new commissions on HSA policies, monitoring the special handling for HSA policies to determine whether commissions are applicable, paying the consultant on KOC1 for annual and HSA commissions, billing the client on the ASO billing system, proofing monthly commissions on KOC1