My contributions to Health Net:- Managed and mentored a team that studies Health Net's Medi-Cal revenue and costs for 14 counties- Developed projected health care cost trends- Reviewed and analyzed the Medi-Cal Rate Development Template (RDT); responded to RDT Discussion Guide questions- Invented ad hoc queries to investigate data abnormalities- Created more efficient SQL programs, during a Health Net data system transition- Communicated results to upper management- Researched professional journals, codes, regulations, and technical manuals as appropriate- Continually sought ways to improve processes

My contributions to Aetna:- Analyze trends in medical claims in order to calculate required premium increases- Prepare rate filing exhibits; respond to questions/objections from regulators- Perform custom pricing of non-standard medical benefits for large self-funded clients

My contributions to FCE:- Educated clients and account reps about the details of clients’ employer-sponsored benefit plans- Tracked trends in claims and evaluated the sustainability of clients’ self-funded insurance benefits- Contributed to sales and marketing efforts by drafting benefit plan proposals- Responded to relevant changes in insurance laws/regulations

My contributions to Applied Underwriters:- Created algorithms for extracting and validating financial data to be used in tax reporting- Designed original user forms for other departments to insert/update information in SQL databases- Maintained database of disability insurance claims

My contributions to Benetech:- Calculated contribution amounts for clients’ defined benefit pension plans - Tested clients’ plans for compliance with the Internal Revenue Code and ERISA- Responded to plan administrators’ questions regarding calculation/testing methods - Analyzed the effect of new laws and regulations on methodologies - Contributed to sales and marketing efforts by designing pension plan proposals - Created original Excel spreadsheets and VBA macros to automate routine tasks

My contributions to Pacific Guardian Life:- Prepared, reviewed, and analyzed components of the company’s financial statement - Calculated reserves for various insurance products (life, TDI, AD&D, and annuities)- Identified and investigated fluctuations in income statement and balance sheet amounts- Developed procedures and trained staff on actuarial tasks