Anuj G.

Data Analyst

415 dollar
Freelancer
21 years
London, UNITED KINGDOM

My experience

More

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. 
More

Spence JohnsonJuly 2017 - July 2017

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

PrudentialMarch 2017 - July 2017

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

Depository Trust & Clearing CorporationJune 2014 - March 2017

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

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.
More

OAC Actuaries and ConsultantsJanuary 2005 - January 2008

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

Financial CompaniesJanuary 1998 - January 2003

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

My stack

ERP&CRM

Salesforce

Databases

Microsoft SQL Server

Business Intelligence

SSRS

Computer Tools

MS Project, Microsoft Word, Microsoft Excel

Others

Data analysis, Quality Assurance, Alteryx, Analysis

Languages

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

Technologies

SharePoint

Application servers

Microsoft SharePoint

My education and trainings

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