Summary
Overview
Work History
Skills
Accomplishments
Timeline
Education
ResearchAssistant

Sambhav Khatri

Bengaluru,Karnataka

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

9
9
years of professional experience
4
4
years of post-secondary education

Work History

AVP Ops Specialist

Wells Fargo International Solutions Private Limited
08.2020 - Current
  • Developing intuitive dashboard using Tableau desktop based on business requirements
  • Creating separate datasource, data massaging & data tuning using Tableau Prep, SQL Server, Teradata.
  • Experience with Agile work flow for the projects and GitHub for saving all my works into repository.
  • Leading standup call to keep track of progress and challenges if any.
  • Collaborated with different teams to work on data remediation and reconciliation and effectively supervised team performance by implementing measurable metrics.

Senior Analyst

AIG Analytics And Services Pvt. Ltd
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
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.
  • 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
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
11.2014 - 03.2015

Design and develop the UI pages for a customer.

  • 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, Teradata & Oracle

undefined

Accomplishments

  • I have been awarded "Wells fargo Champion" for proactively taking up Risk Quotient and setting up Data Integrity & Strategy team in India.

Timeline

AVP Ops Specialist

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

Bachelor of Engineering -

Don Bosco Institute of Technology
09.2010 - 06.2014

Education

Bachelor of Engineering -

Don Bosco Institute of Technology
Bangalore
09.2010 - 06.2014
Sambhav Khatri