Summary
Overview
Work History
Education
Skills
Certification
Timeline
BusinessAnalyst

Pallavi Bhan

New Delhi

Summary

Dynamic and results-driven Business Analyst with 8 months of experience in analyzing business processes, identifying opportunities for improvement, and implementing strategic solutions to drive efficiency and profitability. Proficient in gathering and interpreting complex data sets, conducting comprehensive market research, and collaborating with cross-functional teams to achieve organizational goals. Adept at utilizing analytical tools and methodologies to provide valuable insights and recommendations. Demonstrated ability to communicate effectively with stakeholders at all levels to facilitate decision-making processes and drive business success.

Overview

1
1
year of professional experience
6
6
years of post-secondary education
3
3
Certifications

Work History

Business Analyst

GirnarSoft
New Delhi
03.2024 - Current
  • Conducted analysis on marketing spends to drive insights and reduce costs, focusing on retail and booking counts.
  • Managed NCD (New Car Dealer) Memberships by collecting and analyzing retail and booking data such as Chassis numbers, VINs, retail dates, and booking details, while also monitoring dealership visit frequency.
    Conducted regular audits on Lead health, retail status by model, city, and dealership.
  • Performed bi-weekly API health checks.
  • Administered NAD (New Auto Dealers) health checks, updating, creating, or deactivating active dealer packs nationwide as per client requirements.
  • Executed ad-hoc analyses including PAN India Dealer health monitoring and Lost-Case analysis.
  • Developed Power BI dashboards to track lead-related metrics such as monthly lead count, yesterday's lead count, retail count, test drive count, and retail to booking conversion rates.

Data Analyst Intern

Girnarsoft
10.2023 - 02.2024
  • Developed and implemented data-driven approach to marketing strategy, resulting in 20% increase in customer engagement
  • Analyzed data and identified trends to inform strategic decision-making and facilitate informed discussions with senior stakeholders
  • Performed data mining and analysis on large data sets using SQL, Excel and Power Bi to support business objectives
  • Provided data-driven insights to drive decisions that improve customer experience
  • Developed and maintained data models and reports to provide actionable insights for business operations
  • Implemented data validation processes to ensure accuracy of data used for decision-making
  • Utilized data visualization tools to present insights and analyses in visually appealing manner.

Education

Btech - Computer Science

Dronacharya College Of Engineering
Gurugaon, Haryana
08.2014 - 07.2018

Some College (No Degree) -

Rao Man Singh Senior Secondary Public School
New Delhi, India
04.2012 - 04.2014

Skills

Sqlundefined

Certification

Alteryx(ANALYTICSWITHANAND)

Timeline

Business Analyst

GirnarSoft
03.2024 - Current

Data Analyst Intern

Girnarsoft
10.2023 - 02.2024

Btech - Computer Science

Dronacharya College Of Engineering
08.2014 - 07.2018

Some College (No Degree) -

Rao Man Singh Senior Secondary Public School
04.2012 - 04.2014
Pallavi Bhan