Lucy Coombe

Experience

• 

  Environmental Data Resources

  Aug 1995 - Jul 1997

  Accounts Receivable Associate

  Involved directly with the management of 5000 customer accounts including collection calls, writing final notice correspondence, credit references. Reconciled monthly bank and credit card statements.

• 

  Oxford Health Plans

  Jul 1997 - Jun 2000

  Analyzed complex premium management issues. Developed and maintained department policies and procedures manual. Trained new personnel on policies and procedures. Worked closely with Manager and Senior Manager on various projects. Used Microsoft Access extensively. Built and maintained various MS Access databases for departments within Operations. Researched and reviewed billing and enrollment issues with appropriate internal and external customers. Generated letters regarding status or resolution of account, eligibility or billing issues. Updated system (PULSE) to ensure accurate and current information on groups. Provided education and outreach to internal and external customers. Used Microsoft Excel and Word extensively. Responsible for making collection calls and processing account reconciliation’s to collect past due premium amounts for large commercial accounts. Assisted internal and external customers in resolving billing and enrollment issues. Arranged and monitored payment schedules. Prepared documentation for external collection agencies as well as the internal legal and underwriting departments. Helped to improve the department by participating in special projects.

  • Senior Premium Analyst

    May 1999 - Jun 2000

  • Premium Analyst

    Jan 1999 - May 1999

  • Accounts Receivable Collections Representative

    Jul 1997 - Jan 1999
• 

  UnitedHealthcare

  Jun 2000 - Jul 2019

  Provided daily, weekly and monthly reporting to facilitate effective management of Employer & Individual Medical, Dental & Vision Performance Guarantees helping to manage “at-risk” dollars. -Managed the National Accounts, Key Accounts and Public Sector Operational Scorecards providing insight into our operational performance across our Employer & Individual customers. -Utilized technical expertise, including an understanding of relational databases and the use of a variety of query and data retrieval tools, to extract, combine, manage and present data. -Joined data from different data sets in support of the goal of creating centric reports and analysis that are holistic and span across operational areas (implementation, claims, call, member satisfaction). -Supported data preparation for quarterly and annual external National Account client meetings. Worked collaboratively with departments to collect and validate operational data.-Managed development of functional specifications for new/existing reporting by collaborating with business owners; gathering business requirements identifying, documenting, resolving design issues.-Contributed in testing and quality assurance process for new/existing reporting updates; Problem-solving issues, delivering training to end users, creating instructional documents.-Collaborated with developers and end-users to ensure that report functionality meets client needs. Show less Led a team with Enterprise Client Services Reporting group managing 5 reporting analysts for both production and development.-Created and streamlined Microsoft Access databases for the automation of reporting functions utilizing ODBC connections to multiple data warehouses.-Provided a high level of service that cultivated and maintained strong working relationships.-On-going data management that promoted effective and efficient preparation of monthly, quarterly and annual standard reports.-Managed development of functional specifications for new/existing reporting by collaborating with business owners; gathering business requirements; identifying, documenting, resolving design issues.-Contributed in testing and quality assurance process for new/existing reporting updates; Problem-solving issues, delivering training to end users, creating instructional documents. Show less Monitored, tracked and facilitated most of the projects that impacted department; Provided ongoing MS Access database support; Used Oracle to process monthly manual journal entries for premium revenue, enhanced Medicare revenue and commissions expense; Processed system journal entries to record AR transactions; Completed monthly reconciliations related to premium revenue; Generated checks through Oracle for offcycle commission requests; Gathered data for external auditor and regulatory reporting requests; Facilitated MS Access and Excel training classes for department employees; Maintained internal department website containing department policies and procedures; Gained knowledge of HTML coding; Built and maintained various MS Access databases for departments within Financial Management; Provided support for corporate projects such as Business Continuity. Show less

  • Senior Reporting Analyst-Performance Guarantee and Client Reporting

    Aug 2010 - Jul 2019

  • Senior Manager-Enterprise Client Services Reporting

    Mar 2008 - Aug 2010

  • Broker and Employer Financial Management Project Manager

    Jun 2000 - Feb 2008
• 

  BCD Travel

  Dec 2019 - now

  Program Analyst