Anuj Gupta

Business Development Executive

United Kingdom22 yrs 6 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 25 years of experience in data automation.
Expert in VBA and Power Query M for Excel.
Strong actuarial background in pensions and life insurance.

Stackforce AI infers this person is a Data Automation Specialist in the Fintech and Insurance sectors.

Contact

Skills

Core Skills

VbaPower Query MData AnalysisActuarial ScienceLife Insurance

Other Skills

Pandas (Software)Microsoft Power QueryVisual Basic for Applications (VBA)SQLMicrosoft ExcelMicrosoft WordMicrosoft AccessDataProcess MigrationData VisualizationHealth InsurancePensionsInsuranceCorporate FinanceTech Career Skills

About

I am a Senior Data & Automation Analyst with over 25 years’ experience in automation, data transformation, and actuarial work. Currently at AIG, I am developing user friendly excel tools with VBA that runs the Power Query M code to automate complex processes. I am highly skilled in VBA and Power Query M code. Some experience in using Python which includes Pandas. I also have experience with SQL and SSRS, which I used in earlier AIG projects alongside VBA to automate manual reporting tasks. Also, I created a one-off Power BI dashboard to visualise a Risk Register. Earlier in my career, I worked extensively in pensions and life insurance as an actuarial professional, gaining 16+ years of experience before transitioning fully into data automation. 🔑 Key strengths: • Integrating VBA and Power Query M code in excel automations. • Python skills which includes Pandas. • SQL and SSRS (earlier AIG projects) for automating manual reporting tasks • Collaboration with actuaries and business stakeholders

Experience

22 yrs 6 mos

Total Experience

5 yrs 7 mos

Average Tenure

8 yrs 9 mos

Current Experience

Aig

Senior Data & Automation Analyst

Sep 2017 – Present · 8 yrs 9 mos · Hybrid

Streamlined data transformation processes for the Capital Modelling and Actuarial Teams using Power Query, Python, SQL VBA in Excel.
Provided IT Automation Support to enhance efficiency and accuracy in data transformation.
Implemented automation solutions to reduce manual workload and increase productivity.

Pandas (Software)Microsoft Power QueryData AnalysisVisual Basic for Applications (VBA)SQLMicrosoft Excel+6

Spence johnson

Data Analyst

Jul 2017 – Jul 2017 · 0 mo · London Area, United Kingdom · On-site

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

Data AnalysisMicrosoft ExcelSQL

Prudential plc

Data Specialist

Mar 2017 – Jul 2017 · 4 mos · London Area, United Kingdom · On-site

Developed MS Access Tools with a number of queries to produce the longevity experience data for the annuity tranches.

Data AnalysisDataMicrosoft ExcelMicrosoft AccessSQL

The depository trust & clearing corporation (dtcc)

Senior VBA & MI Specialist

Jun 2014 – Mar 2017 · 2 yrs 9 mos · London Area, United Kingdom · On-site

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

Visual Basic for Applications (VBA)Microsoft ExcelDataData AnalysisData VisualizationVBA

Hannover re

Senior Actuarial Analyst

Sep 2008 – Feb 2014 · 5 yrs 5 mos · Virginia Water, England, United Kingdom · On-site

September 2011 - February 2014
Worked in Solvency II Pillar 1 to improve the working production of the annualised cashflows based on the 1000 Cash Flow Modelled Scenarios (CFM) and the 45 Stress Scenario.
September 2008 - September 2011
Produced the quarterly valuation results for the annuity business.

Actuarial ScienceLife InsuranceHealth InsuranceVisual Basic for Applications (VBA)Microsoft AccessSQL

Oac oxford actuaries consultants

Actuarial Trainee

Sep 2005 – Sep 2008 · 3 yrs · London Area, United Kingdom · Remote

Supported the development of Mo.net, a financial modeling software for Life Insurance.
Migrated Year-End Reserving calculations from MS Excel to enhance accuracy and efficiency.
Collaborated with senior actuaries to ensure seamless integration of new processes.
Gained proficiency in Visual Basic and financial modeling techniques.

Life InsuranceVisual Basic for Applications (VBA)Microsoft Excel