Vikrant Singh

Associate at Swiss Re

Bengaluru Area, India

Summary
Excel VBA Macros SAS Enterprise Guide Big Data Analytics Pensions Health Insurance Life Insurance
About 6 years of professional experience in Life Insurance and Pension Valuations with focus on Products in Life & Health Domain.

Specialties:
Life Insurance - Products
Big Data Handling and Analytics
SAS Modelling
Automation with VBA
Experience

Associate at Swiss Re

Jul 2015 - Present

Experience Studies

Deputy Manager at DHFL Pramerica Life Insurance

Sep 2013 - Jun 2015

Product Development: • Liasioning with Actuarial Department for facilitating Product design with Actuarial Pricing • Developed a SAS based Free Look Cancellation Regression Model to track policies regularly and reducing them subsequently. • Currently working on end to end Product Design of Life Insurance Products as per the New IRDA Guidelines. • Worked on an online term plan wherein i handled all stages including the bench-marking to determine the appropriate pricing. • Developed an End-User(Sales-Team) Tool to improve customer retention by providing real-time suggestions based on surrender values of policies • Automating various processes and streamlining processes along with development of Tools, Premium Calculators and Reverse Calculators.

Senior Programmer Analyst (Actuarial) at Inductis

Jul 2011 - Aug 2013

Worked on Solvency II – Data Quality Assessment Tool for EU Insurance major-Phase2 (Milan, Italy) • Analyzing individual risk areas and Identifying their Key attributes of life insurance data required for the STEC calculations. • Devising a tool based on SAS platform to perform profiling and business rule checks on Data going into MOSES (actuarial software). Worked on Data Mining – US Insurance Major • Formulated a tool based on SAS and VBA platform to perform text mining on auto insurance policies data of policyholders. • Analyzed the results obtained from text mining and formulated observations pertaining to major issues faced by the policyholders. • Formulated recommendation by doing further analysis on the observations that should be undertaken by the client to reduce the number of issues faced by the client. • Compared the results obtained from VBA tool with results from SAS E Miner. Worked on SAS(Time Series) Modelling – US Insurance Major • Analyzing Data for performing the Trending and Profiling. • Developing Models based on techniques like Proc Arima and Holtz-Winter using SAS. • Formulated a tool on VBA platform to update data so as to get updated forecasts from the Models. Worked on Solvency II – Data Quality Assessment Tool for EU Insurance major-Phase1 (Milan, Italy) • Analyzing individual risk areas and Identifying their Key attributes required for the STEC calculations. • Devising a end to end tool on SAS and VBA platform for data quality check, exceptional rule and reconciliation rule for each risk area, and further customize it for each process for easy to use by the end user. • Formulate the reconciliation rules for different datasets to remove inconsistency between them. • Understanding of the actuarial process and data manipulation activity done by the actuarial department. • Finding the gap between desired and actual result and investigate the reason for the same and initiate corrective measure to bridge the gap.

Actuarial Analyst,Pensions & Employee Benefits at Aon Hewitt

Apr 2009 - Jun 2011

• Valuation of pension plans on Solvency, Funding and Accounting Basis • Gain and loss analysis • Performing Projections to determine level of contributions. • Comparative analysis, quartile analysis, ad-hoc analysis and style analysis of Investment monitoring reports.

Education

Actuarial Science at Institute of Actuaries of India

Mar 2009 - Apr 2013

image/svg+xml
Push pixels...
Shovel coal into server...
Create mockups...
Defend the wall...
Draft storyboard...
Disrupt an industry...
Achieve profitability...
Become a unicorn...
Become Batman...