Daniel Goggin Email & Phone Number

Wallingford, Connecticut, United States

Farmington, Connecticut, United States

Leads the enterprise Commercial Informatics team which drives customer retention and new sales through reporting that demonstrates value proposition and identifies opportunities for cost containment.Business Development: Integral role in the development and implementation of a new product/funding line (Level Funding) which now accounts for approximately 20% of group commercial enrollment. Development of all financial tracking and reporting mechanisms. Creation of “single source of truth” financial reporting used in policy settlements. Designed and developed segment level claim duration analysis used by senior leadership to gauge performance relative to other business segments. Critical report cited by KPMG as a necessary business performance audit tool. Developed small and large group prospecting reports used in risk-based pricing. Data Quality: Lead transition effort for reporting and analytics related to new administrative platform. Enterprise data steward for Employer Group aspect of data migration. Significant enterprise level contributions to data quality improvements related to claims/enrollment/provider/broker data.Analytics / Reporting: Produces customer-specific ad hoc analytics and reporting for Sales and Underwriting. Cost and Utilization, Disease Prevalence, Provider Disruption, and Preventive Screening reporting. Custom data extracts used to support statutory audits and third-party surveys.Financial Models: Maintenance/enhancements of underwriting rating model.

Hartford, Connecticut Area

Financial models, data integrity, business process and tools leader for the International Actuarial team. Additionally assumed many traditional actuarial responsibilities such as pricing, medical cost analytics and forecasting.Led the design and implementation of an enterprise solution to automate the pre-authorization of claims in Dubai – reducing backlogs and claim counts while improving the member experience. o Coordinated with operations, IT, care management, product and actuarial teams to ensure all stakeholders needs considered.o Built fully-functional prototype model that served as specifications for IT development. o Implemented Agile development process with IT to create enterprise solution.o Logic served as paradigm for full auto-adjudication of claims.Created process using SAS to scrub data warehouse data to solve for disconnects between premium/membership and corresponding claim data and standardized data from multiple platforms.o Resulted in the “single source of truth” datasets used for all non-US Aetna International analytics, underwriting, forecasting, and customer reporting.Produced an Actuarial Data Tool using Excel and ADO to allow GM’s, actuaries, underwriters and others to pull from standardized datasets directly into Excel reporting.o Made customized “self-service” data possible for the first time – standardized across functional areas.o Datasets became the foundation for all experience rating for underwriters.Built prototype forecasting model in VB.NET.o Allowed policy level forecasting while maintaining the flexibility to implement factors at various cohorts. o Demonstrated the efficiency of a customized solution vs. the complexity of existing process.

Hartford, Connecticut Area

Led the Trend Unit which researched and reported on all aspects of drivers of trend – including breakdown to components of trend at various cohorts including business segment, medical cost category and market. Maintained the enterprise model used to track and measure provider contacting changes and derive unit price trend, allowing actuaries to evaluate unit cost changes independently from changes in utilization.

Hartford, Connecticut Area

Developed and maintained all technical processes and contributed to analytics for Actuarial Core Valuation team which establishes IBNR reserves for enterprise.

Hartford, Connecticut Area

Developed enterprise level National Experience Rating Tool (NERT) used by large and middle market business segments to experience rate approximately $7 billion of premium. Recognized with inaugural “Aetna Actuarial Innovation Award”.