Anuj G.

Data Analyst

415 dollar
21 years

My experience


AIG Europe (Services) LimitedSeptember 2017 - Present

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. 

Spence JohnsonJuly 2017 - July 2017

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

PrudentialMarch 2017 - July 2017

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

Depository Trust & Clearing CorporationJune 2014 - March 2017

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

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.

OAC Actuaries and ConsultantsJanuary 2005 - January 2008

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

Financial CompaniesJanuary 1998 - January 2003

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

My stack




Microsoft SQL Server

Business Intelligence


Computer Tools

MS Project, Microsoft Word, Microsoft Excel


Data analysis, Quality Assurance, Alteryx, Analysis


Python, C++, VBA, SQL, Visual Basic



Application servers

Microsoft SharePoint

My education and trainings

Bachelor of Science, Actuarial Science, insurance, finance - University of Kent1995 - 1998