Retour à la liste
Anuj G.

DATA ANALYST

440 dollar
Freelancer
21 ans
London, UNITED KINGDOM
VBA MS Project Microsoft SQL Server Data analysis

Mon expérience

Voir plus

AIG Europe (Services) LimitedSeptember 2017 - Présent

Providing IT support to the actuarial teams which are European Capital Model (ECM) and Global Modelling.


Process Automation


• 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.
Voir plus

Spence JohnsonJuly 2017 - July 2017

Provided support in the management of databases tracking the stock flow of assets into specific types of investment strategy.
Voir plus

PrudentialMarch 2017 - July 2017

Worked in the longevity team on a project to reinsure a large block of annuity business.
Voir plus

Depository Trust & Clearing CorporationJune 2014 - March 2017

Developed VBA applications in Excel and Access to automate the production of metrics for the Operations Team.
Voir plus

Life BranchSeptember 2008 - January 2014

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.
Voir plus

OAC Actuaries and ConsultantsJanuary 2005 - January 2008

Provided support on company's own financial modelling software, Mo.net which was written in Visual Basic.
Voir plus

Financial CompaniesJanuary 1998 - January 2003

Includes working for Canada Life as a Pensions Data Gatherer and Alexander Forbes as a Pensions Technician

Mes compétences

Visual Basic, VBA, SSRS, SQL, SharePoint, Salesforce, Quality Assurance, Python, MS Project, Microsoft Word, Microsoft SQL Server, Microsoft SharePoint, Microsoft Excel, Data analysis, C++, Analysis, Alteryx