Sas Data

Keshav Bhargav

Email: ***************@*****.***

Mobile: +91-999*******

New Delhi

Professional Summary

1.Total work experience of 5 + years in SAS Programming and Data Visualization (SAS Certified), Data Modelling, SQL, Actuarial Pricing, Teradata and Data Analysis

2.Experience of working in domains like Insurance Banking and Healthcare.

3.Experience of working in Actuarial Domain, with good knowledge of Actuarial pricing and reserving techniques like Generalized linear modelling and price optimization, Paid and incurred Chain ladder reserving techniques.

4.Worked on different analytics and statistical modelling (predictive modeling, linear and logistic regression factor analysis, Clustering, GLM and Neural Networks).

5.Experience in Automation of existing SAS codes/SAS Scripts using SAS Macros

6.Experience in creating business reports/ Data Marts in SAS by extracting and exploring data from another database.

7.Proficient in Base SAS/Advanced SAS, SAS Macros, SAS SQL, SAS Annotate, SAS Graphs, SAS Data manipulation, SAS procedures, SAS merge and SAS data Preparations.

8.Expertise in Data Visualization using Tableau and SAS Annotate, Preparing dashboards, reports and presentations for key decision makers of an organization .

9.Involved in Design and Requirement calls with clients.

10.Experience in R and Python

Experience Summary

Organization

Designation

Period

NMG consulting (Working as a contract employee)

Programmer Analyst

October 2019 – June 2020

EXL Services

Sr. Business Analyst

September 2018 – October 2019

AXA Business Services

Sr. Actuarial Analyst

Feb 2017 – September 2018

AON Hewitt

Software Engineer

November 2014 – Feb 2017

Technical Profile

Languages: Base SAS, Advanced SAS, SAS Macros, SAS SQL, SQL, SAS Graphs, SAS Annotate, Tableau

Tools: SAS EG, Excel, Base SAS, Advance EXCEL, PowerPoint, Tableau

Database: MySQL, Teradata, SAS server

Educational Qualifications

Degree

University

Passing Year

Marks Obtained

Bachelors in Technology (Electronics and Communications)

Lingaya’s University

2014

6.09 (CGPA)

12th

Central Board of Secondary Education

2010

71.00 %

10th

Central Board of Secondary Education

2008

75.00 %

Projects Worked

NMG Consulting (October 2019 till Present)

1.Market Research on Insurance industry

•Working for NMG insights program which provides their market research to insurance/reinsurance companies based on key factors like. Customer satisfaction, relationship management, Underwriting and Claims experience, Technology and Products.

•Gathering data from online Confirmit platform, Importing, understanding and manipulating the data in SAS or SQL.

•Performing different calculations like BCI (Business Capability index), CAS (Client Advocacy score), Market Penetration, Head to Head analysis, Price Vs Value, Cohort analysis for creating graphical insights and storytelling using Tableau.

•Creating different SAS graphs like Bar charts, Box plots, Quadrant plots for different clients and across different parameters using SAS/SQL and Tableau.

•Extensively using SAS macros for automation of whole process.

•Creating clients dashboard and presentations

•Presenting our results to Key decision makers of a company, explaining in which areas they have improved, deteriorated or still the same from last year. What are the focus points and what trend insurance industry is following.

EXL Services (September 2018 - October 2019)

2.Credit Risk Model Validation:

•Validated multiple Non-Scoring models for major US banks by evaluating multiple business and statistical metrics across various out of time vintages using SAS model Validation techniques.

•Automation of Existing SAS codes using SAS Macros for better efficiency timely results.

•Score cut-off analysis project was focused on increasing the approval rate with stable performance for underwriting models.

•Performing PAD analysis for authorization models under Existing Customer Management segment to achieve the objective of having stringent strategies in place.

•Optimizing existing SAS/SQL scripts to improve efficiency while maintaining core structures.

•Single point of contact for underwriting policy team.

•Preparing the deliverables which includes models validated/monitored, AMR’s, Model documentation etc.

Characteristic Analysis:

•Made recommendations to MRM (Global Model Risk Management) on model stability by analyzing decile wise movements in population across various vintages by showing them graphical representation of data using SAS Graphs and SAS Annotate.

AXA Business Services (February 2017 - September 2018)

3.Actuarial Pricing for AXA SIGORTA

•Prepare data to clean out anomalies and create initial summaries and reconciliation using Base SAS Data preparations and manipulations technique (Eg ;- SAS First dot and last dot, SAS sorting, SAS Formats).

•Setting large loss thresholds for different insurance benefits using actuarial techniques like Extreme value and Hill plot theorems

•Exposure data preparation and combine claims data for post merging analysis using SAS merging or SAS SQL

•Perform analysis on business KPIs for different business segments based on various parameters.

•Understanding the different KPIs, and preparing Actuarial pricing structure for insurance products using modelling techniques such as Generalized linear modelling using advance SAS procedures like PROC Genmod.

•Creating propensity models for identification of large loss customers using Advance SAS technique like SAS Proc logistics.

•Automating Impact analysis on Actual vs Predicted structure using SAS Macros.

•Preparing the final commercial premium of insurance products using Multiple commercial adjustment.

•Finding insights from the portfolio and using different SAS PROC procedures to produce better insights

•Presenting Graphical Analysis for complete insurance portfolio using SAS Graphs and SAS Annotate techniques.

Onsite (AXA SIGORTA - Turkey)

•Determining and understanding scope of the project, starting with initial phase of the project

•Providing preliminary reports on experience analysis for various products using different rating factors.

•Impact Analysis and implementation of pricing structure for client.

4.CMA (Competitor Marketing Analysis)

•Analyzing pricing strategy of different competitor across various KPI’s for different insurance products

•Identification of different KPI’s/Rating factor used in competitor pricing models using SAS Proc factor procedure.

•Pulling out price quotes for main competitor using Web Crawling (Using Python)

•Creating dashboard using SAS visualization for ranking of our product vs different competitor products on aggregator sites and tracking price change/updates of competitors.

•Analyzing the ranking on aggregator sites and tracking price change/update of market competitors, furthermore creating weekly dashboard based on the results using SAS Visualization

AON Hewitt ( November 2014 – February 2017)

5.Total Benefit Solution

•Business Analyst for US, GBS and APAC healthcare domain. Responsible for data extraction, exploration and reporting using SAS Data manipulation and preparation (SAS merging, sorting Data step)

•Creating centralized data mart by extracting Benefits information, Claim Spending information from different data sources using SAS.

•Validate data created for exceptions like negative rate values, missing values etc. Using SAS functions (For E.g. Intck, intnx missing and others different SAS functions )

•Analyze employee-dependent election data for ambiguities found in allocation of benefit plans using SAS.

•Export data into Excel and create MIS reports for vendors.

•Predictive analysis of Benefits and Claims for our clients using various statistical and data modelling techniques like linear and logistic regression

•Getting into client engagement, helping clients to identify the suitable benefits for different age bands, gender across different job levels and help them to increase consumption of specific benefits.

.

Certifications:

SAS Certified Specialist: Base Programming Using SAS 9.4

Achievements:

Awarded AE Achievers award for delivering multiple clients and outstanding business results.

Awarded Best Enabler award for delivering and presenting results at global level.

Extra-Curricular achievements:

Table tennis champion at National level (third seed)

Contact this candidate