Post Job Free

Resume

Sign in

C# .Net Product Development

Location:
Phillipsburg, NJ
Posted:
February 25, 2024

Contact this candidate

Resume:

DELROY FOSTER A.S.A, M.A.A.A.

ACTUARY/PROGRAMMER with 30+ years expertise in product development and pricing, actuarial modeling and object oriented computer programming. SUMMARY OF QUALIFICATIONS/EXPERIENCE

Associate of the Society of Actuaries (1990)

Member of the American Academy of Actuaries (2003) Created LTC Pre/Post Actuarial Valuation system in C#.Net and MsSQL Created full Administration system in C#.Net for Private Placement/COLI products Pioneered 2 Actuarial departments and developed Pricing and Valuation systems Priced Long Term Care Guaranteed Purchase Option Rider for VUL, Term, WL and VA products Modeled Insurance Business using 1st generation GGY’s AXIS system Priced Guaranteed Insurability Rider for VUL products Created Stories in JIRA Analytics Agile Board

Created FosWins system (in FoxPro/Excel VBA) to support Inforce and New Business Illustrations SUMMARY OF EDUCATION

Associate of the Society of Actuaries

TECHNICAL SKILLS

SOFTWARE: Proficient in Visual FoxPro, C++, C#.Net, MS Office, JavaScript, VB Script, Macros, PDF Editing, Big Data Manipulation, ASP.Net, VB.Net, C++.Net, Mathematica, FORTRAN, COBOL. Programming Knowledge of R, SAS, JQuery, APL, AutoIT and Alteryx DATABASE: Proficient in MsSQL, MySQL, Access, Oracle, RedShift Intermediate Knowledge of CASSANDRA NoSQL, SSIS

WEB DEVELOPMENT: Proficient in HTML, ASP, XML JSP, PERL and PHP MODELING SOFTWARE: MOSES/USLMS (MIAME), 1st Gen. AXIS (GGY), Polysystems Health Master CONTACT INFO

ADDRESS: 424 Hamilton Drive, Stewartsville, NJ 08886 PHONE: 908-***-****

PERSONAL EMAIL: ad3wpe@r.postjobfree.com

BUSINESS EMAIL: ad3wpe@r.postjobfree.com BUSINESS WEBSITE: http://fostact.org/sp/ DELROY FOSTER Page 2

PROFESSIONAL EXPERIENCE

Owner, President, Consulting Actuary, Actuarial Programmer August 2017 – Present Foster’s Actuarial Systems / Foster Colley Inc – Stewartsville, NJ Built SSIS package to execute Stored Procedures and load IBNR .csv files into SQL database (incorporating C# Scripts) for New York Life while consulting for Oliver James. Built C#/SQL Access Role solution for New York Life while consulting for Oliver James. Created Duration, Economic Data and Fund Results SQL views by pivoting selected rows into columns, from existing view with over 200 million rows, creating improved processing time for New York Life actuaries while consulting for Oliver James.

Automated Settlement Statement Analyses Review for 2 Fortitude Re products using SQL Queries and Views in Redshift Work Bench and VBA, improving processing time from 7 days to under 20 minutes while consulting for Oliver James.

Automated Cost Of Funds Reports using VBA, improving processing time to 30 minutes for Fortitude Re while consulting for Oliver James.

Programmed ALM System using HJM Model in C#.Net / Mathematica for Consulting firm’s clients. Programmed Reinsurance Pricing in C#.Net / Mathematica for Consulting firm’s Reinsurance client. Programmed LDTI Annuity Calculations System in C#.Net for Consulting firm’s Life Insurance client. Working on Model for LDTI implementation of Annuity block of business for insurance company client. Created EC2 Virtual Machine environment in AWS for insurance company client. Convert CSV data into SQL and run Roll Forward and CFT testing for insurance company client . Developing Realty Survival Statistics software in C#.Net using WPF and MSSQL for 777 Partners. Perform on- request Formula testing for Foster Colley Inc. Developing WPF Data Mining/Life Contingencies software for Joint Venture with Foster Colley Inc. in C#.Net Consulting Actuary on Actuarial Systems Modernization Project for Penn Mutual, in Horsham, PA Convert Valuation/Financial systems from MS Access to Cassandra NoSQL database for Penn Mutual Create Specifications/Documentation to Solution Delivery Framework Wiki for Penn Mutual Create Stories for each Sprint in JIRA Analytics Agile Board for Penn Mutual DELROY FOSTER Page 3

SENIOR ASSOCIATE ACTUARY October 2014 – August 2017 MetLife US Insurance Company - Bridgewater, NJ

Re-programmed “Div Solver” logic in MOSES (USLMS/MIAME) to correct Dividend Scale selections for MLFS, METMASS and IND Participating products using C++ Created Data Compression software for MOSES modeling using C#.Net, MsSQL and MsAccess Created XML Parser for UAT Testing of LPAS Block of Business Prepared Compression documentation for LPAS, MLFS, UML and IND for CFT and EV Re-formatted MLIC and MLIUSA data files for USLMS model Performed UAT testing of MLFS/LPAS Policy Fact Retrieval for RADAR repository Supported Admin systems conversion using Oracle Database repository (DataMart) Automated Closed and Open Block processes using VBScript DIRECTOR ACTUARY November 2011- August 2013

Prudential Financial - Roseland, NJ

Created LTC Pre/Post Actuarial Valuation system in C#.Net and MsSQL Converted Upgrades, Transfers and Takeovers Census systems from MS Access to MsSQL Converted Post Valuation Database Reporting systems from MS Access to C# and MsSQL Provided Actuarial supervision on Census File Conversion project Assisted in Monthly ILTC and GLTC valuation using POLYSYSTEMS Health Master SENIOR ACTUARIAL CONSULTANT April 2000 - November 2011 MetLife US Insurance Company - Somerset, NJ

Developed Illustrations software (FOSWINS) that grew into the new Manual Inforce Illustrations Unit Created Database system from IB Data Warehouse to support Illustrations in C#.Net/MsSQL Created Full Administration system for Private Placement/COLI products in C#.Net/MsSQL Created and maintained FOSWINS Illustration system to support New and Inforce Illustrations in FoxPro Created Excel Workbooks, VB Macros and FoxPro programs to support Inforce Illustrations Reverse engineered DOS based Legacy systems to produce Windows based systems in C# and VBA Provided programming support for Variable Universal Life and Variable Annuities Fund Performance in VBA Reprogrammed/Updated Valuation programs for Variable and Fixed Annuities in C++ and MsAccess Priced the Long Term Care Purchase Option (LTC-GPO) Rider for VUL, Term, WL and VA products Drafted Actuarial Memorandum and Records of Decisions for LTC-GPO product Priced the Guaranteed Purchase Option Rider for VUL, UL, Term and WL products Trained Actuarial students on the UNIX based URGS Module Infrastructure and Projection system DELROY FOSTER Page 4

ACTUARY July 1993 – December 1999

Dyoll Life Insurance Company - Kingston, Jamaica

Pioneered Actuarial Department, reporting directly to the President and CEO Automated Actuarial functions by writing programs in Microsoft FORTRAN Designed Whole Life, Deferred Annuities, Group Creditor and Investment Life products Repriced Universal Life and Comprehensive Major Medical Products Introduced Basic Benefits with Supplemental Major Medical product Wrote Statutory Valuation systems in Microsoft FORTRAN Wrote Group Life, Health and Pensions Quotation systems Wrote Group Pension Valuation systems

Provided all Statutory Reports for Superintendent of Insurance Office ASSOCIATE ACTUARY July 1991 – June 1993

Crown Eagle Life Insurance Company - Kingston, Jamaica Pioneered Actuarial Department, reporting directly to the President and CEO Automated Actuarial functions by writing programs in Microsoft FORTRAN Wrote Statutory Valuation systems in Microsoft Fortran Designed Equity Linked Universal Life Insurance product Designed Rate Manuals

Provided all Statutory Reports for Superintendent of Insurance Office Modeled Insurance Business using GGY’s AXIS system ACTUARIAL STUDENT /ASSOCIATE ACTUARY May 1985 – June 1991 Mutual Life Insurance Company - Kingston, Jamaica

Automated Actuarial functions by writing programs in Microsoft FORTRAN and ICL’s FTL6 Rewrote Statutory Valuation systems in Microsoft FORTRAN for PC integration Represented Actuarial on Marketing Strategy and Product Development committees Assisted in Product design and Pricing of the Universal and Equity Liked products COMPUTER OPERATOR /PROGRAMMER October 1979 – April 1985 University of the West Indies Computing Center - Kingston, Jamaica Programmed and operated IBM 370-138

Programmed FORTRAN, COBOL, PLI and RPGII



Contact this candidate