Open to opportunities

Shubhanshu awasthi

@shubhanshuawasthi1

Message

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

India

Message

What I'm looking for

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

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

Work history, roles, and key accomplishments

Deputy Manager

Kotak Mahindra Life Insurance

Jul 2021 - Sep 2025 (4 years 2 months)

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.

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 (6 months)

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.

Excel Dashboard Development KPI Tracking Data Cleaning Tableau Power BI Stakeholder Management

Phone Banker

HDB Financial Services

Oct 2017 - Nov 2020 (3 years 1 month)

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.

Excel Pivot Tables Sales Analytics performance reporting Data Cleaning Customer Insights Trend Analysis

Education

Degrees, certifications, and relevant coursework

Meritshot

Post Graduate Program, Data Science & A.I.

2024 -

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.

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