Summary
Overview
Work History
Education
Skills
Personal Information
Internship
Languages
Other Qualifications
Projects
Disclaimer
Certification
Timeline
Hi, I’m

PRANAY GUPTA

Sales Co-ordinator
PRANAY GUPTA

Summary

An adept data analyst with proficiency in Excel, Power BI, SQL, and Python, capable of transforming complex data sets into actionable insights. Leveraging a diverse professional background, including roles as a Sales Coordinator, Operations Executive, Customer Support, and Academic Counsellor, I bring a unique blend of analytical expertise and comprehensive business acumen. My experience in various industries has honed my ability to identify trends, streamline operations, and enhance customer experiences through data-driven decision-making. Passionate about continuous learning and applying innovative solutions to drive organizational success.

Overview

3
years of professional experience
1
Certification

Work History

CollegeDekho

Academic Counsellor

Job overview

  • Utilized strong organizational skills to maintain accurate records of all student interactions and interventions using Excel Reports .
  • Provided ongoing support for students during their transition from high school to college or post-secondary opportunities.
  • Educated students on college admissions process and scholarship requirements.
  • Advised students on educational, career and social opportunities.

Startek Aegis Pvt Ltd

Operation Executive
06.2022 - 03.2023

Job overview

  • Improved customer satisfaction rates through timely communication and effective issue resolution.
  • Analyzed data and metrics to identify areas of improvement in operational performance and maintain data and reports in Excel and Google Sheets .
  • Optimized supply chain processes for increased efficiency and cost savings using crm tools Microsoft dynamics 365
  • Streamlined operations by implementing efficient processes and systems using Excel dashboard and Power BI.

Concentrix Daksh Pvt Ltd

Representative Operation
02.2020 - 11.2020

Job overview

  • Handled customer complaints quickly and professionally to restore customer confidence and prevent loss of business.
  • Increased customer satisfaction by addressing and resolving complaints in a timely manner.
  • Responded to customer questions via telephone and written correspondence regarding insurance benefits, provider contracts, eligibility, and claims.

Xceptional Health & Wellness Pvt Ltd

Sales Co-ordinator
2 2016 - 11.2019

Job overview

  • Maintained accurate records of all sales activities, including contracts, proposals, quotes, follow-ups, and customer communications and prepare Daily, weekly and monthly reports in Excel and Google Sheets.
  • Reviewed sales performance data regularly to identify areas for improvement and implement corrective actions when needed using

data analysis in Excel (Pivot Table , graphs and charts).

  • Kept detailed records of sales and customer information in CRM software, updating database regularly to maintain top-notch service.

Education

Class X

University Overview

Board: C.B.S.E

Class XII

University Overview

Board: C.B.S.E

Dr. M.G.R University

B. Tech (ECE)

University Overview

GPA: 7.24

Skills

MS Excel

Personal Information

Personal Information
  • Father's Name: Late Surya Deo Gupta
  • Mother's Name: Chitra Gupta
  • Date of Birth: 05/21/90

Internship

Internship
MIS Analyst, Red Cat Hospitality Pvt, SQL, Advance Excel, and Power BI, Used data analysis tools SQL, Advance Excel, and Power BI tools for Data Analysis for the sales Team and gained insights Up to 75% that Helped the company to make sound business decisions.

Languages

English
Hindi
Hindi

Other Qualifications

Other Qualifications
  • MS (Excel and Advanced Excel) From ICA (Institute of Computer Accountant)
  • The Complete SQL Bootcamp Certification from Udemy
  • Microsoft Excel: Advanced Excel Formulas & Functions certification Udemy
  • Microsoft Power BI Desktop for Business Intelligence (2023) certification from Udemy

Projects

Projects
DATA ANALYSIS USING EXCEL PROJECT (VRINDA STORE DATA ANALYSIS) Power bi with mysql sales project.pbix POWER BI WITH MYSQL PROJECT FOR SALES INSIGHTS

Disclaimer

Disclaimer
I am Solemnly declaring that all the above information is correct to the best of my knowledge and belief

Certification

Microsoft Excel: Advanced Excel Formulas & Functions certification Udemy

Timeline

Microsoft Excel: Advanced Excel Formulas & Functions certification Udemy

07-2023
Operation Executive
Startek Aegis Pvt Ltd
06.2022 - 03.2023
Representative Operation
Concentrix Daksh Pvt Ltd
02.2020 - 11.2020
Academic Counsellor
CollegeDekho
Sales Co-ordinator
Xceptional Health & Wellness Pvt Ltd
2 2016 - 11.2019
Class X
04.2006
Class XII
04.2008
Dr. M.G.R University
B. Tech (ECE)
04.2014
PRANAY GUPTASales Co-ordinator