Summary
Overview
Work History
Education
Skills
Websites
POWER BI PROJECTS
TABLEAU PROJECTS
DATA CLEANING IN SQL
DATA EXPLORATION IN SQL
python and power bi integration for efficient campaign management
Languages
Timeline
Generic

Harsh Munjal

Toronto,ON

Summary

Experienced Account Manager in Restaurant, Food and Beverage and Hospitality Industry with 3+ years of expertise. Skilled in client oversight, issue resolution, and relationship-building. Proficient in SQL for data exploration and improved reporting and adept at creating intuitive Tableau and Power BI dashboards. Leaning enthusiastic with the ability to change and work with fast paced work environment.

Overview

3
3
years of professional experience

Work History

PRODUCT EXPERT

TIMES INTERNET LIMITED(DINEOUT)
09.2019 - 07.2022
  • Applied in-depth product and market expertise to analyze data, providing accurate and current information to sales team to make informed decisions and increase sales
  • Utilized Excel, Pivot Tables, and SQL to extract, clean, and analyze data, leveraging prevailing market trends and opportunities
  • Maintained high levels of customer satisfaction by actively gathering feedback and addressing data concerns
  • Engaged in demand planning to ensure data availability and reliability for clients
  • Effectively executed comprehensive onsite and remote training programs for diverse client base, ensuring successful knowledge transfer of the product
  • Formulated proactive strategies to optimize data management, anticipating and mitigating potential analytical challenges
  • Utilized Excel and SQL to streamline account management processes
  • Successfully oversaw a portfolio of 150+ accounts, conducting proactive reviews and resolving data discrepancies through Excel and SQL proficiency
  • Fulfilled customer expectations by regularly collecting feedback, participating in demand planning, and addressing data-related concerns promptly using Excel and SQL expertise.
  • Enhanced product usability by identifying and addressing customer needs through extensive research and analysis.
  • Streamlined the product development process for faster market entry, collaborating with cross-functional teams.

Education

POST DEGREE CERTIFICATE DIPLOMA - DATA ANALYTICS IN BUSINESS DECISION MAKING

DURHAM COLLEGE
OSHAWA, ON
12.2023

POST DEGREE CERTIFICATE DIPLOMA - PROJECT MANAGEMENT

DURHAM COLLEGE
OSHAWA, ON
04.2023

B. TECH ELECTRONICS AND COMMUNICATION ENGINEERING -

GGSIPU UNIVERSITY
DELHI, India
06.2019

Skills

  • SQL (SQL Server, MySQL)
  • Python (Jupyter, Pandas, NumPy, Seaborn, MatPlotLib)
  • Tableau
  • Strong Analytical Skills
  • Strong Organizational skills
  • Basics of SAS Software
  • Excel (VLOOKUP, Conditional Formatting, Pivot Tables)
  • Microsoft Power BI
  • Team Player
  • Exceptional Customer Service

POWER BI PROJECTS

● Conducted data extraction and transformation on survey data from working professionals, enhancing its usability for visualization and optimizing representation of satisfaction, happiness, and sentiments related to co-workers, management, and salary.

● Leveraged Power BI to create visually compelling representations of satisfaction rates and sentiments across diverse aspects, including co-workers, management, and salary. Categorized findings by job titles and countries for comprehensive insights.

TABLEAU PROJECTS

● Analyzed Airbnb data to gain in-depth insights into real estate investment potential, examining property trends, pricing dynamics, and key factors influencing opportunities.

Developed a visually intuitive Tableau dashboard to highlight lucrative investment prospects by assessing property types, locations, and market trends.

DATA CLEANING IN SQL

● Performed EDA and text analysis to successfully identified the major issues in the data.

● Implemented data cleansing procedures to enhance the quality and structure of the housing dataset.

Executed SQL operations, including updating, modifying, and altering tables, to ensure the integrity and efficiency of the MySQL database.

DATA EXPLORATION IN SQL

● Utilized SQL to extract data from 3 different related tables from COVID-19 databases using JOIN and VIEW.

● Transformed and filtered data by using aggregating and filtering function to improve reporting process.

python and power bi integration for efficient campaign management

● Employed Python and SQLfor end-to-end marketing project, including data cleaning, perform screening, transformation, and integration with MySQL.

● Created visually compelling dashboards using Power BI, leveraging Python for data import and implementing necessary groupings and views within MySQL.

Established seamless connections between data realms, databases, and dynamic visualization in Power BI, revealing actionable marketing insights throughout the comprehensive campaign project.

Languages

English
Full Professional

Timeline

PRODUCT EXPERT

TIMES INTERNET LIMITED(DINEOUT)
09.2019 - 07.2022

POST DEGREE CERTIFICATE DIPLOMA - DATA ANALYTICS IN BUSINESS DECISION MAKING

DURHAM COLLEGE

POST DEGREE CERTIFICATE DIPLOMA - PROJECT MANAGEMENT

DURHAM COLLEGE

B. TECH ELECTRONICS AND COMMUNICATION ENGINEERING -

GGSIPU UNIVERSITY
Harsh Munjal