• Supported operational needs by performing complex analyses on a wide range of organizational data.• Investigated and uncovered root causes, identified trends, and proposed solutions.• Achieved results by effectively leveraging expertise in healthcare/managed care data.• Supported customer needs for what-if scenario analysis by developing analytical tools/models.• Coordinated and trained new hires/team members in supporting operational/clinical/compliance reporting.

• Created functional and decorative ceramic products by hands and pottery wheel.• Communicated and designed custom-made products for my special-order customers independently.• Participated in UC Berkeley Art Studio pop-up sales and promoted products through social media.

Supported fully insured or self-funded employer group/third-party administrator extracts, reporting and monitoring performance guarantee. • Developed employer-specific operations reporting to guide business decision-making for Medical Care Solutions Operations, Sales and Marketing Teams with self-service reporting/visualization tools including Excel, Tableau and AuthAccel.• Identified customer needs for 15+ external third-party administrators and utilized SAS/Netezza with SQL to create and streamline authorization data extract process with a standardized template. • Identified common types of requests and developed self-sufficient tools reducing the number of time-sensitive ad hoc requests from Employer Groups.• Maintained and enhanced authorization based monthly potential high cost claimants report for Blue Shield internal Reserve/Underwriting/Account Management teams.• Supported continuity of care for members with employer groups transitioning to new health plans.

Supported negotiation of Blue Shield contracts ensuring timely quantitative analyses including the high-quality service providers: hospital /free standing surgery center/mental health facility.• Collaborated directly with Blue Shield Provider Network Managers to analyze and formulate proposals with reasonable contract rates using historical utilization and scrubbed claims data throughout negotiating cycle.• Interpreted provider contracts and governmental regulations to perform financial modeling on hospitals and free-standing surgery centers for one/three-year budget planning and forecasting.• Analyzed the impact of chargemaster and unit cost increase and calculated dollar savings/cost over term of contract including Global One bundled payments contract.• Partnered with Blue Shield Provider Network Managers to set budgets, prioritize and meet aggressive deadlines.• Created quarterly internal productivity reports for senior managers to track team performance.

• Performed data update & reconciliation for large & medium sized pension plans• Programmed actuarial liability calculations using FORTAN-based software• Analyzed asset & liability gains & losses• Determined contribution requirements under IRC Section 412 • Determined SFAS No. 158 expense and additional minimum liability• Captured funding, accounting results & demographic trends with graphs & exhibits• Completed & reviewed actuarial valuation reports for qualified & nonqualified pension plans • Completed executive management summary reports with contribution & expense projections for two largest clients• Served as a plan administrator for big & medium sized clients• Performed termination estimates & retirement calculations • Communicated with clients & participants on daily basis explaining benefit packages• Reviewed participants’ signed election forms & issued directives to banks for starting annuity/lump sum payments• Prepared & maintained participant benefit files with accuracy & confidentiality• Prepared & sent out annual benefit statements for plan participants• Updated & reviewed plan documents, Summary Plan Descriptions, benefit calculators & election forms to compile with ERISA & PPA • Prepared government Form 5500 filings, PBGC Forms & annual funding notices • Reminded clients of deadlines & helped clients to submit government filings• Verified assets, data & liabilities & assisted auditors for annual plan audits• Determined testing population & coverage & completed non-discrimination testing for defined benefit plans• Accomplished special projects such as plan termination, plan redesign, termination & retirement studies for clients in the medical, banking & airline industries

• Updated & reconciled data for large pension plans• Prepared actuarial valuation reports for qualified pension plans• Compared & analyzed competitor retirement plans & prepared presentations with PowerPoint for plan redesign studies• Worked with Group & Health Care practice to calculate IAS 19 valuations of Other Post-Retirement Benefit Plans (programmed trend rates, discount rates & liability calculations)• Attended career fairs to recruit new hires• Provided actuarial training for interns & new analysts