• Key Accomplishments: Assist with successful launch and year-over-year operations of new program providing more than 500 studies to customers interested in EV charging stations, requiring almost 3,000 points of contact per year. Lead training efforts of specialists who provide reports. Guided numerous process improvements to cut down inefficiencies and create a lean, effective team.• Create decision empowering dashboards through Power BI and Excel to display key metrics and garner insight into cross functional programs. Combined numerous groups’ databases to develop an internal CRM across systems where none existed, including numerous documentation guides, and reports out to state and other regulators.• Assist with heavy data analysis for strategy guidance, pinpointing areas to invest more heavily or minimize funding to meet goals and keep various programs and services’ pipelines flowing.• Oversee administration of third-party partners assisting in SCE program including regular trainings, enrollment, back-office system processing, customer service, and analytics, helping strengthen these relationships for cross department success.• Manage and coordinate hundreds of external speaking requests across various organizational units to highlight company thought leadership, programs, increase marketing efforts, and better serve our local communities. Built process to speed up efficiency and reporting.

• Assisted with successful completion of two quality assurance test cycles for the multiyear Customer Service Re-Platform project, representing 1,046 unique checked test scenarios, 517 documented errors, 532 confirmed tests, and 179 system defect fixes.• Developed, maintained, and improved daily/ad hoc analysis tools that massively increased reporting/status transparency, aided team coordination, and drastically heightened data driven recommendations for leadership.• Coordinated and compiled cross department efforts and data to create combined status/aging reports, improving combined initial quality assurance pass rates from 50% to 70%, representing 2,566 unique test scenarios.• Proactively created and maintained weekly brightspot analysis to highlight high and lower performing testers, helping improve our testers’ initial quality assurance pass rate from 26% to 62%.• Led daily sync up team meetings, coordinating updates, schedules and reporting, and introduced engaging safety moments.

• Key Accomplishments: Oversaw production of 56 life-affirming videos by researching relevant topics, coordinating 17 animators, writing scripts, and launching new channel that has generated ~800,000 total views.• Developed project management system to ensure on-time animation completion, in addition to creating accounting system to reconcile financial payments and invoices to keep projects within scope and within budget. • Managed content creation for company dedicated to community building and self-improvement, including marketing research, ROI analysis, database set up.• Spearheaded and wrote 20,000-word transformational book to improve individual’s lives, combining research from diverging fields into a simplistic, instructional book.• Wrote multiple articles and marketing materials to attract new members to self-improvement seminars.

• Designed rate filing process flow for multiple states and business segments (Small and Large Group filings), under shifting deadlines, new state and federal regulations interpretations, and new reporting tools. Coordinated with regulatory, finance, and product teams to ensure accurate and on-time submissions.• Created award winning Excel analysis tool that compares competitor plans across differing benefit levels for upper management to make decisions on internal product offerings.• Redesigned product plans to account for fluctuating legislative decisions in order to comply with new state mandates.• Co-created organizational documentation system to record current projects and process flows, reducing time spent researching prior practices by 30%.

• Created award winning competitive analysis graphical tool for product comparison across region, competitor, and product type. Prepared presentation which won accolades from local and regional management that resulted in the tool being rolled out across the nation.• Assisted with rate development, data pulls across multiple data warehouses and databases, marketing implementation, and regulatory responses.• Earned STAR awards from sales department for providing cross-department Excel training, mentorship, and creating new Excel/VBA tools which saved 100+ manual hours.• Drastically reduced time spent updating reiterating reports including membership and budget variances, high dollar claims, Medical Loss Ratio experience by county, risk score analysis, etc. by designing more efficient Excel files and by creating highly efficient automated data scrubbing SQL code.

• Won award for redesigning quarterly NY Managed Medicaid Operations Report, reducing time spent generating report from a two-person, two-week process to a one-person, one-week process by updating SQL and Excel programs to automate analyses, auto-correct, scrub, and process millions of records.• Worked with team of 7 actuaries to oversee pricing and evaluation of WellPoint’s Medicaid lines of business, covering 1.5 million individuals. • Developed, estimated, and forecasted utilization, cost and seasonality trends, and the impact of changes in membership and premium rates to accurately price products.• Self-taught VBA to create more efficient files, including analysis of cost of care initiatives by product, month, and benefits. Reduced time spent updating other reports by up to 90%.