Michael Stefanelli Email & Phone Number

Springfield, Massachusetts, Us

Prepare existing actuarial models in Moody's Axis to support U.S. GAAP Long-Duration Targeted Improvements (LDTI). Collaborate with stakeholders in Actuarial, Data Engineering, Finance, and several consulting firms in building effective end-to-end processes incorporating these models.Perform user acceptance testing for the company's ledger transformation project from the Actuarial perspective, which will allow use of newer SAP software available for financial reporting.Co-lead enhancements planning and implementation to Axis models for Whole Life, Term, Universal Life, and Variable Universal Life products.

Springfield, Massachusetts, Us

Perform Illustrations Regulatory Testing (IRT) on non-traditional Executive Benefits products that include COLI, BOLI, and Group UL/VUL. Provide IRT assistance for other products supported by the team, including UL and Term. Assess impacts to current inforce business and projected new business from annual assumption updates.Assess and implement a detailed model conversion strategy surrounding the IRT models for the Executive Benefits suite of products, providing clear rationale for the new modeling platform to use in place of the legacy software TAS. Oversee and execute the full conversion to Moody's Axis in order to reduce departmental variation in modeling platforms, and provide an improved, more automated and more controlled user experience.

Newark, New Jersey, Us

Actuary role within the Actuarial department's Projections Center of Excellence, supporting several business units with a primary focus in the Individual Life Insurance business. As a member of the Capabilities team, our purpose is to connect Actuaries in valuation and forecasting roles with capabilities to assist in solving their problems.Establish and compile business requirements for GGY Axis model redesign for Individual Life Insurance business, receiving feedback from Actuaries in valuation and modeling roles along the way. Provide testing strategy details for this project, seeking out experts as needed. Serve as tester in user acceptance testing phases of the project's workstreams, including for assumptions and for the calculation engine.Design and implement solutions for model users in valuation and forecasting roles, using a variety of tools for development, including Excel, MS Access, VBA, and SQL, among others. Contribute to the creation of a user-friendly enterprise AAT forecasting model.Facilitate and engage in regular discussion between the Individual Life Insurance Closed Block stakeholders from Actuarial and Finance to achieve overall enterprise goals for forecasting. Ask meaningful questions to map out and understand the Closed Block process to build our team's knowledge base.Leverage best practices across the enterprise in regards to the tools and processes used by Actuarial's teams. Consult with various stakeholders in Actuarial, and contribute important ideas to those discussions about best practices.

Newark, New Jersey, Us

Role within Enterprise Systems and Services (ESS) group in system design and programming (.NET environment languages) to provide fast, innovative solutions to business partners in Actuarial, including Annuities, Individual Life Insurance, International Insurance, and Retirement.Support the adoption of the actuarial platform GGY Axis by the Actuarial businesses. Serve as a resident technical expert for the GGY suite of applications, which includes the modeling software Axis, the control environment EnterpriseLink, and the propietary grid software GridLink. Troubleshoot application issues, and design automated solutions for the GGY applications. Automation examples in GGY include Retirement's iterative AAT process and Individual Life's Forecasting run process.Lead in R&D efforts for Prophet software proof-of-concept. Focus in building an internal knowledge base of Prophet Professional and Prophet Enterprise. Notable topics of focus include run automation, grid optimization, model versioning, and proper security and controls.Maintain an in-house actuarial projection system along with auxiliary utilities. Perform miscellaneous design and implementation tasks to ensure a smooth and efficient monthly business process used for reporting purposes.

Newark, New Jersey, Us

Member of Modeling Infrastructure Team for the Annuities Actuarial department. Responsible for maintenance and control of many utilities and other programs used by business partners. Involved with computer programming in Visual Basic and C++ especially, and providing documentation to keep record of the team's work for future reference.

Raleigh, North Carolina, Us

Worked on a team at the NCSU Research Experience for Undergraduates. Analyzed an algorithm for computing dot products of large vectors efficiently; results are published in SIAM Journal of Scientific Computing.

Bachelor Of Arts (B.A.), Mathematics

Education record