Summary
Overview
Work History
Skills
Timeline
BusinessAnalyst

Sambhav Khatri

Senior Analyst
Bengaluru

Summary

Experienced Senior Analyst with a demonstrated history of working in Analytics (Finance & Insurance). Skilled in Advanced Excel, SQL, Access & Tableau. As a Senior Analyst, demonstrated success working with clients and internal engagement teams for quicker turnaround for the deliverable.

Overview

7
7
years of professional experience

Work History

Senior Analyst

Wells Fargo International Solutions Private Limited
Bangalore
08.2020 - Current
  • Have been working closely with clients to gather and understand requirements to build dashboard using SQL/tableau.
  • Leading BI-Weekly connect with client to provide update on
    progress and also to discuss on enhancement & challenges.
  • Collaborated with different teams to work on data remediation and reconciliation and effectively supervised team performance by implementing measurable metrics.
  • Mentored new joiners ,Introducing to the team members, providing knowledge transfer with business requirements and helping them with setting up their access request.

Senior Analyst

AIG Analytics And Services Pvt. Ltd
Bengaluru
04.2017 - 08.2020
  • Extracting data from sources information provided by the client and transforming them using business logic and loading the data in the business tables.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently while handling huge volume of data.
  • Quality Assurance and establishing processes within the team.
  • I have also performed UAT for the insurance product "Property Underwriting Platform (PUP)", as a final user.
  • Have helped the team define Test case for multiple scenarios, such that an error message is popped up when the criteria does not meet the requirement.

Risk Analyst

AIG Analytics And Services Pvt. Ltd
Bengaluru
03.2016 - 03.2017
  • In Excel have worked on Pivot Table, Vlook up, Hlook up and other functions to analyze the data. Turning the complex data into meaningful insight.
  • Experience in analyzing the data generated by the business process, source to target mapping of the data elements, creating Aggregate tables for the data warehouse design and development.
  • Used to work on SSMS for calculating Impact from Terrorism peril for any account with respect to the accounts in Portfolio.

Intern Risk Engineer

AIG Analytics And Services Pvt. Ltd
Bengaluru
04.2015 - 03.2016
  • Further enhancement of data on the scrubbed locations and incorporating the COPE information(Primary or secondary modifiers), Performing Loss Estimate due to Flood for highest exposed value locations

Associate Software Engineer

Accenture
Bengaluru
11.2014 - 03.2015

Design and develop the UI pages for a customer. This involved creating a UI that will perform the tasks:

  • Open an account with the Bank.
  • Register for online Banking
  • View account details after authentication.
  • Calculate the interest for the amount the customer wants the borrow.

Responsibilities

  • Creating the Database to store the customer details and the same details used by the customer for Login into his account.

Skills

    SQL

undefined

Timeline

Senior Analyst

Wells Fargo International Solutions Private Limited
08.2020 - Current

Senior Analyst

AIG Analytics And Services Pvt. Ltd
04.2017 - 08.2020

Risk Analyst

AIG Analytics And Services Pvt. Ltd
03.2016 - 03.2017

Intern Risk Engineer

AIG Analytics And Services Pvt. Ltd
04.2015 - 03.2016

Associate Software Engineer

Accenture
11.2014 - 03.2015
Sambhav KhatriSenior Analyst