MANDEEP

 

SENIOR BUSINESS ANALYST

 

 

LOCATION         Bengaluru, INDIA

EXPERIENCE    6 Years 0 Month

 

 

 

 

 

 

Profile Summary

 

 

 

 

 

Key Skills

 

Big Query SQL

Python Advanced Excel Google Sheets VBA

Tableau

Google Apps Script Google Analytics Automation

Ab Testing

 

 

Languages

English Punjabi Hindi

 

Social links

https://www.linkedin.com/in/m andeep-singh-8a55422a3

 

Dedicated and results-driven Business Analyst with over 6 years of experience leveraging data-driven insights to drive business solutions. Proven track record of successfully leading and contributing to high-impact projects, improving data-driven decision-making processes, and automating the manual processes to bring efficiency in work.

 

 

Work Experience

Senior Business Analyst

*****

08/2022 - 01/2024

 

Customer Segmentation and Targeted Marketing: Implemented customer segmentation strategies, leading to targeted marketing campaigns and a 7% increase in customer retention on a targeted audience.

Customer Feedback Analysis:Analyzed customer feedbacks and reviews to gain insights into product satisfaction and areas for improvement. With the help of NLP, sentiment analysis and topic modeling.

Dynamic Product Bundling: Developed and deployed a recommendation system that increased user engagement by 30%. Resulting in increase in click ratio.

Collaborated with BUs to define key performance indicators (KPIs) of Top eBay sellers. Targeting increase in the GMV. Using Correlation analysis. Global level single dashboard created for all the categories existing in eBay for all the countries across all the metrics (Main part is handling huge data in dashboard).

Creating Data sanity QC process. TO validate data before publishing any information.

 

Sr. Business Analyst

******

05/2020 - 08/2022

 

Taking care of major automations, working with multiple development teams to deliver the tasks. Worked in a cross functional roll, delivering impactful projects.

Evaluating the processes for efficiency, cost, and results and streamlining accordingly (Process:- WhatsApp, Catalog, Operations, Finance, Sales & Delivery)

Reporting, Dashboarding & data insights to help make decisions.

Querying and handling huge data and Consolidating information from multiple data sources.

Used multiple statistical tools for getting the trends & patterns that could be valuable for diagnostic and predictive analytics.

Analyzing, evaluating & benchmarking the vendor performances and managing the onboarding of vendor resources.

Gap analysis to identify the potential gap in the process & system and communicating with respective stakeholders to resolve the same.

 

Business Analyst

*********************11/2017 - 05/2020

 

Working on process automations, working with multiple development teams to deliver the tasks. Delivered macros for auto PO creation which reduced manpower from 10 to 2.

Delivered Merge-unmerge macros which saved operation efforts to work on less products per templates.

Incorporated VBA code in templates which highlight banned products.

Introduced Google studio for publishing reports. Automated daily, weekly and monthly report for catalog, retail and Pvt labels.

Automated catalog ingestion process which reduced manpower efforts.

Delivered key business metrics reports to managements that includes GMV trend. Delivered stock/inventory replenishment report. Requirement gathering and meeting with relevant stakeholders to understand the requirement.

Staying up to date on product standards and constantly sharing ideas within the team.

 

Working closely with the Tech team throughout the software development cycle.

 

Education

 

B.Com - Commerce

2017

Delhi University

Grade - Pass

 

12th

2014

 

CBSE , English

Grade - 70-74.9%

 

10th

2011

 

CBSE , English

Grade - 80-84.9%