Product And Financial Analsyt
• Model Allstate Financial asset inforce quarterly by using TAS/MOSES and Access databases to model actual payout, cashflow, and yield characteristics of the assets; including the modeling of swaps, caps/floors, private placement floating rate bonds/mortgages, CMO’s, commercial mortgages, ABS/CMBS securities, etc.• Complete special ad-hoc projects involving investment analysis; including projects like analyzing prepayment assumptions for CMO inforce and analyzing commercial mortgage restructure/re-finance spreads.• Compute and Analyze durations for Allstate Financial liabilities and assets by building and running ALM duration models in TAS (Tillinghast Actuarial Software)/MOSES and summarizing/analyzing the results; balancing the impact of interest rate movements and adjustments made to lapse and crediting rate assumptions in the TAS/MOSES models.• Build quarterly TAS/Moses scenario files, investment data files, and asset category files for TAS/Moses ALM models.• Support external/internal ALM (Asset Liability Management) clients by being the primary “point man” for any technical problems involving asset inforce files during TAS/MOSES runs or any suspect asset yield results from TAS/MOSES model.• Improve existing ALM processes by using Access and Microstrategy to automate querying of data, upgrading codes and files for TAS/MOSES and software version upgrades (Ex. - changing Visual Basic code from Access 97 to Access 2000), and updating HTML code to document the newest ALM processes on internal intranet.• Manage/train any actuarial summer interns or external client as needed. (Responsible for major workload and training of 2 different summer interns in Summer 2001/2002)