# Shubhanshu awasthi

Shubhanshu awasthi is a remote worker on Himalayas, Deputy Manager at Kotak Mahindra Life Insurance, based in India.

Source: https://himalayas.app/@shubhanshuawasthi1

```text
Data-driven business analyst leveraging SQL, Python and BI to drive sales and operational improvements.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 750k-800k USD |
| Job categories | Business Analyst, Data Analyst, Business Intelligence Analyst, Product Analyst, Financial Analyst, Insurance Agent |
| Skills | SQL, Python, Pandas, NumPy, Matplotlib, Power BI, Tableau, Excel, Power Query, Pivot Tables, Dashboard Development, Report Automation, KPI Tracking, Data Cleaning, Forecasting, Financial Modeling, Stakeholder Management, GitHub, MySQL |

## What I'm looking for

```text
I am looking for Analyst role where I can apply my analytical skills to make a real business impact, continue learning and growth in a collaborative environment
```

## About

```text
I am a data-driven business analyst with 8 years of experience in Banking and Life Insurance, combining domain expertise with technical skills in SQL, Python, Power BI, Tableau and advanced Excel to deliver actionable insights that improve sales conversion and reporting efficiency.

I have led analysis of 10,000+ policy records, automated reporting workflows to increase reporting speed by 40% and optimized sales efficiency by 20%. I collaborate across teams to translate business needs into analytical solutions and build dashboards and data processes that support strategic decision-making.
```

## Experience

### Deputy Manager

Kotak Mahindra Life Insurance. Jul 2021 - Sep 2025

```text
Analyzed 10,000+ policy records to identify performance trends and regional opportunities, driving a 20% improvement in sales conversion and automating reporting workflows to boost reporting speed and data accuracy.
```

Skills: Dashboard-Automation, KPI-Tracking, Data-Cleaning, Sales-Analytics, SQL, Excel-Pivot-Tables, Power-Query, Power-BI, Tableau

### Assistant Manager

Bandhan Bank. Dec 2020 - Jun 2021

```text
Analyzed monthly customer interaction datasets to identify issues and improve query resolution efficiency, and developed interactive dashboards for KPI tracking that improved branch visibility into customer satisfaction and service performance.
```

Skills: Excel, Dashboard-Development, KPI-Tracking, Data-Cleaning, Tableau, Power-BI, Stakeholder-Management

### Phone Banker

HDB Financial Services. Oct 2017 - Nov 2020

```text
Maintained customer interaction records and performance reports, using Excel to identify sales trends and optimize client engagement, contributing to high conversion rates and improved sales productivity.
```

Skills: Excel-Pivot-Tables, Sales-Analytics, performance-reporting, Data-Cleaning, Customer-Insights, Trend-Analysis

## Education

### Meritshot

Post Graduate Program, Data Science & A.I.. 2024 - Present

Activities and societies: Completed 15+ end-to-end analytics projects across finance, insurance, and retail domains; hands-on work with SQL, Python, Power BI, and Tableau.

```text
Post Graduate program in Data Science & A.I. focusing on SQL, Python, Excel, Tableau, and Power BI with hands-on projects and dashboard development.
```

### Punjab Technical University

Bachelor of Computer Applications, Computer Applications. 2009 - 2012. Grade: First Division

```text
Bachelor of Computer Applications degree completed with First Division, covering core computing and application development subjects.
```

## Tech stack

- GitHub
- NumPy
- Pandas
- MySQL
- Gmail
- SQL
- Transform

To contact Shubhanshu, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Ayush Singh Verma](https://himalayas.app/@ayushsinghverma): Deputy Manager II, ICICI BANK
- [divyanjay singh](https://himalayas.app/@divyanjaysingh): Manager Data Analytics, PayU Finance India Private Limited
- [devendra singh Rajawat](https://himalayas.app/@devendrasinghrajawat): Risk Analyst, Northern Arc Capital Limited
- [manaswi singh](https://himalayas.app/@manaswisingh): Business Analyst, Movate
- [Saranya Thiagarajan](https://himalayas.app/@saranyathiyagarajan): Deputy Manager Data Analyst, Bandhan Bank
- [Vinay User](https://himalayas.app/@vinayuser4): Wealth and Trade Deputy Manager, ICICI Bank
- [SHIVANI DHINGRA](https://himalayas.app/@shivanidhingra): Business Analyst, Axis Max Life Insurance
- [Komal Garg](https://himalayas.app/@komalgarg): Manager, SBI General Insurance Co Ltd
- [vineet rai](https://himalayas.app/@vineetrai2): Business/Operations Assistant Manager, Utkarsh Small Finance Bank Pvt. Ltd.
- [Srikant Senapati](https://himalayas.app/@srikantsenapati): Assistant Manager, HDFC Bank Ltd
