AIG Europe (Services) LimitedSeptember 2017 - Present
Providing IT support to the actuarial teams which are European Capital Model (ECM) and Global Modelling.
Created an Excel VBA Spreadsheet that produces the reporting template in MS Word for each validation test which included pulling up the prior limitations from the two MS Excel Spreadsheets. This reduced the process time from 20 days to 15 minutes on an annual basis.
Developed an Excel VBA Spreadsheet which produces the list of files including those in sub folders that are saved in a particular directory.
Brought improvement to the input file creation process by developing an Excel VBA application which adds a new contract to all the reinsurance tables.
Created an Excel Macro for Cyber Scenario to perform a number of iterations in order to generate a loss distribution curve. This reduced the process time from 20 days to 20 minutes on an annual basis. Developed an Excel VBA Functionality to project the cumulative savings in switching from the existing servers to the
Developed an Excel VBA Functionality to project the cumulative savings in switching from the existing servers to the servers offered by another provider. This included automating the import of the existing server costs from an SQL Server Database.
Improved the working production of the annualised cashflows based on the 1000 Cash Flow Modelled Scenarios (CFM) and the 45 Stress Scenarios. Also produced the quarterly valuation results for the annuity business.
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.