Business Intelligence and Insurance data analyst with 6+ years of professional career in successful domestic and international companies with experience in implementation and management of IT projects directed to provide solutions and satisfaction to needs and requirements of external and internal customers of their organization

HIGHLIGHTS

6+ years of experience in Data Analysis, Reporting and testing.

Insurance Data Analyst

SAS + SAP Business Objects + SQL Server 2008 + MS Access + MS Excel

MBA ( Banking and Insurance) with specialization in Insurance domain from IP University

TECHNICAL SKILLS

# Languages

VBA

# SAP Platform

SAP Business Objects

# Databases

SQL Server 2008,MS Excel(Advance), MS ACCESS

# Business Discovery Tool

Tableau, Power Pivot

# Statistical Tool

SAS (Base and Advance)

# Statistical Techniques

Descriptive Stat and Inferential Stat

# Certifications

Property and Casualty Insurance (320 Exam) and AINS 21 examination, Cleared Licentiate (Non- Life) examination conducted by Insurance Institute Of India.ISTQB Foundation Level certified.

EXPERIENCE SUMMARY

Genpact India

Genpact is a global leader in transforming and running business processes and operations including those that are complex and industry-specific.

Tactical Reporting Designation- Consultant Jul’2012- Till Date

Responsibilities:

Preparing reports using SAS report generating procedures like PROC PRINT,PROC FREQ, PROC MEANS

and PROC SQL. Well versed with using and designing SAS formats, informats, functions and data manipulation.

Data Merging, Data Subsetting with the use of MERGE and SET statements.

SAS Procedures like Proc Means, Proc Freq, Proc Tabulate, Proc Report, Proc Univariate.

Performing data analysis and reporting tasks by interfacing with different data sources (SQL Server and MS Access)

Worked on Automation of manual reports using VBA and Advance Excel tools.

MGA-TPA Project

Ironshore currently receives information for MGA/TPA’s manually. Genpact is developing a Program Data Store (PDS) that will specifically cater to Ironshore requirements. Data store includes all the data fields required for the policy and claim data feed integration and accommodate other business requirements to be defined in the business and functional specification.

Responsibilities:

Tools Used : SAS Base, SQL Server, Excel, MS Excel and VBA

Perform User Acceptance Testing of the Functional Requirements of the Viewpoint system and business processes.

Use of SAS Base Platform for daily Adhoc queries related to project

Implemented Data Profiling Process.

Data Analysis, Data Validation and Identifying Data Mismatch for maintaining Data Quality.

Assist in the parallel running of the current system to ensure the new system results are validated against the existing system

Documentation of UAT Test Scenarios and Test Cases.

Identification and analysis of software defects, providing resolution.

Sunlife Financial India Service Center Apr’10-Jul’2012

Sun Life Financial product strategy involves the development of various Linked Benefits – riders that can be added using shared process and system components to each of our lines of business – Life, Annuity and Group. Suncare product represents the first combination – Life with a Long Term Care (LTC) rider. Product projects typically involve major changes to the calculation/administration system processing and relatively minor changes to workflow and other auxiliary systems.

Project - Life care product claims Designation: Software Test Engineer

This project aims to implement the Claims functionality of the Suncare product.

Responsibilities:

Tools Used : Insurance Web and Mainframe Applications, SQL Server, MS Excel, Bugzero.

SME for the Lunar and Solar application from offshore team.

Providing KT and mentoring new Joiner’s

Testing SOLAR a mainframe based Policy administration system used for policy maintenance activities like claims, anniversary, surrender, loan and dividend processing.

Performing System, Regression and Smoke testing of Suncare product.

Responsible for status reporting, creating and maintaining the Matrices sheets.

Creating Test Plan and traceability matrix.

Scheduling QA tasks and tracking the team activities along with effort estimation

Preparation of reports on defects and problems that arise during software tests until they are closed

Actively participating in the status calls and bug review meetings with the US counter parts

Project - Life care Product

This project aims to implement Suncare product on the Policy administration system (Solar).

Responsibilities:

Writing test cases and Execution of Test cases

Prepared traceability matrix.

Participate in Status call, bug reviews, ongoing project requirements discussion with US counter parts.

Recording and closing of bugs through the entire testing life cycle using Bugzero.

Testing SOLAR a mainframe based Policy administration system used for policy maintenance activities like claims, anniversary, surrender, loan and dividend processing.

Performing Integration, System, Regression and Smoke testing of various products.

Project – Life Care Process Designation: Associate Test Engineer

This project aims to implement the Suncare product on a new business application processing System (Lunar).

Responsibilities:

Testing LUNAR a web based application used for New Business Underwriting System. It enables New Business Case Managersand underwriters to seamlessly manage cases and network with each other to accomplish the goal of quality.

Performing System, Database, Regression and Smoke testing of various products.

Writing test cases and Execution of Test cases.

Hewitt Associates (India) Pvt. Ltd Sep’08-Apr’10

Hewitt Associates (India) Pvt. Ltd. is a subsidiary of Hewitt Associates Lincolnshire (IL) USA. And is the largest HR Outsourcing firm in

the world. Hewitt provides a variety of Automated HR Solutions to the employees of more than 300 Companies out of Fortune Five Hundred Companies.

Designation: Setup Configuration Specialist (Defined Benefits Domain)

Responsibilities:

Testing case/scenarios for annuities and retirement on a web based application Your Benefit Resources.

Testing using mainframes for running batch jobs, Creating test data and generating letters.

Owning modules and responsible for completing projects on time and within given resources.

Breakpoint Analysis of System Requirement specifications.

Test planning, Preparation of high level and detailed test plan to test all the conditions based on both business and technical requirements for the specific event of Benefit Administration System.

Debugging Calc Code.

Defect tracking through Maestro.

Unit, Integration, Acceptance and Regression Testing.

Coaching and mentoring new associates about configuration and testing of benefits Administration System.

Preparing process documents.

EDUCATIONAL QUALIFICATIONS

IP University, Delhi.

2010

MBA (Banking and Insurance)

67.8% (Top 25% of batch)

Delhi University

2008

B.Sc

75.5% (Top 20% of batch)

D.L.D.A.V. Model School, Pitam Pura

2005

XII, CBSE (PCM)

76% (Top 15% of batch)

D.L.D.A.V. Model School, Pitam Pura

2003

X, CBSE

77% (Top 15% of batch)

ACHIEVEMENTS

Received Silver Award for outstanding performance in Genpact.

Received US IMPACT award from client

2011 GEM award from Sun Life US Service center for outstanding performance.

Received appreciation notes from the customers for my work in each organization.

AKHIL BHAMBRI

Contact this candidate