Training
Sungard (FIS)
Total years of experience :9 years, 2 Months
• Use Data conversion system (DCS) to migrate and prepare data for use in Prophet
• Create, modify and model products in Prophet
• Run Prophet and produce reports
• Maintain, develop and improve prophet models (including coding)
• I can develop and implement changes to libraries
• Libraries familiar with: Conventional, Unit Linked, ALS, International
• Develop, maintain and test models
• Review client policies to identify errors
• Consider and apply approach to calculate remdeiation for all clients where required
• Agree assumptions and bespoke methods for calculations with the project actuary
• Products dealt with include - Unit linked and with-profits
• Perform liability updates taking into account inter-valuation experience
• Complete scheme funding valuations and reports
• Produce FRS17 and IAS19 financial reports and disclsoures
• Compare company accounting liabilities against the buyout market
• Analyse competitiveness of standard company buyout basis against the market
• Produce monthly data for the Affordability Index, used by other departments
• Liaise constantly with consultants regarding data, methods and assumptions
• Collect and modify data based on rules and regulation
• Complete s143 valuation of liabilities using software
• S143 Reporting to the Pension Protection Fund
• Liaise with clients to negotiate and prioritise work to ensure all deadlines are met whilst maintaining high levels of professional standards
• Price liabilities for bulk annuity buyout
• Check reasonableness of results and test sensitivity of results to assumptions
• Analyse anomalies and determine reasons
• GMP equalisation
• Maintain complicated check sheets for analytical comparisons
• Develop macros and user-forms to streamline processes and improve efficiency
• Present newly updated add-in functions, macros and spreadsheets
• Mentor junior staff assisting with technical issues including data rectification methods
• Calculate complicated transfer values and produce annual valuation reports
• Perform liability updates taking into account inter-valuation experience
• Produce reports and benefit summaries after thorough analysis of scheme rules
• Modify data for benefit inaccuracies, modelling and pricing liabilities using VIPitech valuation software
• Develop VIPitech valuation model code
• Raise queries with clients and implement responses provided