Rohan Kumar

Rohan Kumar Email and Phone Number

Business Intelligence Developer @ Four Seasons Hotels and Resorts
Toronto, ON, CA
Rohan Kumar's Location
Montreal, Quebec, Canada, Canada
About Rohan Kumar

Passionate about analytics, I am driven by the prospect of translating raw data into actionable insights that fuel data-informed decision-making and cultivate data-driven excellence. I aspire to pursue a career as a Data Analyst in the sectors of Gaming, Entertainment, and Technology.Currently pursuing a Master's in Management in Analytics at McGill University, I am honing a robust skill set encompassing statistics, mathematics, and programming. This program equips me with the ability to collect, analyze, and interpret data. Additionally, I am proficient in SQL, Python, RStudio, PowerQuery, Excel, and data visualization tools like PowerBI.Beyond my technical skills, I am recognized for my ability to communicate with diverse stakeholders, bridging the gap between technical and strategic decision-making to optimize business processes.Feel free to reach out at: rohan.kumar@mail.mcgill.caMicrosoft Office: Pivot Table | XLOOKUP and VLOOKUP | X LOOKUP and V LOOKUP | If statements | SUMIF and COUNTIF | Macros | Chart creation | Data analysis | data validation | goal seek | advanced filtering | conditional formatting | Index and Match | Data modeling | PowerPivot | Power Query | PowerView | Power Bi | PowerPoint | ppt | Pivot Tables | Power Point | Word | ExcelSQL: sequel | JOIN | INNER JOIN | OUTER JOIN | LEFT JOIN | RIGHT JOIN | CROSS JOIN | UNION | INSERT | UPDATE | DELETE | CREATE | ALTER | INDEX | TRIGGER | STORED PROCEDURES | CURSOR | TRANSACTION | TEMPORARY TABLE | INDEX | NORMALIZATION | OPTIMIZATION | DDL | DML | DCL | Data warehousing | ETL | Bi | NoSQL | Big Data | Cloud databases | MongoDB | MySQL | SQL Server | Oracle | PostgreSQL | SQLite | AWS | Azure | Good Coud SQL | Data Governance | Data modeling | Agile | ScrumPython: Object-oriented programming (OOP) | Functions, Classes | Modules | Data structures (lists, dictionaries, sets, tuple) | Control flow (if, else, for loop, while loop) | Exception handling | File I/O | Regular expressions | Numpy | Pandas | Matplotlib | seaborn | Jupyter Notebook | Machine Learning | Natural Language Processing (NLP) | Computer vision | Test-driven development (TDD) | Data analysis | Data visualization | Data science | Automation | Web scraping | API development | Multithreading | MultiprocessingR / RStudio: R Programming | Data Cleaning | Statistical Analysis | Time Series Analysis | Predictive Modeling | Data Wrangling | Tidyverse Packages | ggplot2 | dplyr | Shiny | R Markdown | Cluster Analysis | Text Mining | Statistical Programming | Linear Regression | Spline | Polynomial | Classification

Rohan Kumar's Current Company Details
Four Seasons Hotels and Resorts

Four Seasons Hotels And Resorts

View
Business Intelligence Developer
Toronto, ON, CA
Website:
fourseasons.com
Employees:
39087
Rohan Kumar Work Experience Details
  • Four Seasons Hotels And Resorts
    Business Intelligence Developer
    Four Seasons Hotels And Resorts
    Toronto, On, Ca
    View
  • Mcgill University
    Research Assistant
    Mcgill University Aug 2024 - Present
    Montreal, Quebec, Canada
    • Designed and implemented a web scraping pipeline using Python for extracting tags, restaurant reviews and user-generated content for efficient data collection on large dataset.• Applied Natural Language Processing (NLP) models like VADER and BERT for advanced sentiment analysis and text mining on user generated content, contributing to research on the microeconomic impact of political campaigns on the micro-economy through causal analytics and econometric design.• Built a neural network-based machine learning classifier to predict target variables from textual data, applying advanced text preprocessing techniques (stopword removal & TF-IDF vectorization) transforming unstructured text.
    View
  • Bdc
    Data Science Intern
    Bdc May 2024 - Dec 2024
    Montreal, Quebec, Canada
    •Redesigned and enhanced dashboards with a modern, user-focused layout, setting the standard for future dashboards. Increased user engagement by 20% and reduced data interpretation time by 30%, delivering more accessible and actionable insights•Developed Google Analytics tracking solutions, providing performance reports to internal stakeholders to monitor user behavior effectively on the website•Developed a Python script for seamless revenue calculation on large datasets, enabling the generation of key metrics to quantify marketing efforts.•Built a machine learning model to rank key customer questions, delivering actionable insights into customer preferences when interacting with business.•Conducted an in-depth analysis of internal scoring metrics by region and industry, identifying opportunities for personalized customer acquisition strategies, which led to improved targeting and increased conversion rates•Updated BI homepage for enhanced access control, improving organizational data governance•Refined and retired stored procedures using Git, ensuring efficient data management and streamlined workflows for ongoing data processes
    View
  • Bdc
    Ui/Ux - Academic Analytics Consulting Project
    Bdc Sep 2023 - Apr 2024
    Montreal, Quebec, Canada
    •Designed and developed a dashboard for customer attrition , incorporating key metrics to monitor customer retention and provide actionable insights for the manager to take data driven action. Collaborated with key stakeholders to gather requirements and ensure the dashboard met user needs, providing actionable insights for decision-making. Conducted User Acceptance Testing (UAT), achieving a score of 80%+, validating the dashboard’s functionality and usefulness in improving customer retention strategies.•Built a comprehensive marketing channel attribution dashboard to track the performance of marketing channels, identifying the most effective ones for customer acquisition. Developed a three-tier dashboard for executives, managers, and analysts, and developed metrics to monitor marketing efficiencies for each user to enable tailored analysis at each organizational level. Conducted UAT, receiving a score of over 85%+, ensuring the dashboard's effectiveness in providing data-driven insights for refining marketing strategies and optimizing acquisition efforts.
    View
  • Midas Safety
    Data Analyst
    Midas Safety Aug 2022 - May 2023
    Pakistan
    • Analyzed material importation data to compare competitor pricing allowing to make recommendations for senior management on procuring cheaper raw materials while maintaining material quality; decreasing cost by 10%• Automated market sales data by extracting, cleaning and modelling data using Power Query allowing sales team to analyze and identify leads for new potential customers• Improved product stock-keeping units (SKUs) by analyzing sales data, historical margin, and sales volume, leading to reduction of unprofitable SKUs• Conducted analysis to identify lost customers sales, enabling targeted strategies to strengthen and sustain existing customer relationships
    View
  • Hbl - Habib Bank Limited
    Risk Management Intern
    Hbl - Habib Bank Limited Jun 2021 - Jul 2021
    Karāchi, Sindh, Pakistan
    • Automated Macro Stress Testing (MST) using RStudio to assess capital resilience and regulatory compliance in the face of adverse macroeconomic events, enabled senior management to promptly evaluate the company's trajectory and make well-informed decisions.• Developed behavioural Probability of Default (PD) Model to predict prospective number of customers for different rating categories and utilized PD Model to forecast customers rating for upcoming year allowing to evaluate likelihood of default rate and incorporate risk for each category rating
    View
  • Afiniti
    Project Intern
    Afiniti Jul 2020 - Aug 2020
    • Assisted in designing, implementation and execution of test cases for new and existing features in collaboration with the senior engineering team. • Performed platform testing to uncover flaws within the interface and update the testing procedure to provide better coverage and user experience.• Contributed to the Summer Q/A project, with a focus on feature deployment, and actively participated in meetings with product management team.
    View
  • Times Consultant (Pvt.) Ltd.
    Data Management Intern
    Times Consultant (Pvt.) Ltd. Jul 2020 - Aug 2020
    Karāchi, Sindh, Pakistan
    •Carried out extensive market research on Universities based in North America and created multiple datasets based on their admission criteria •Proactively researched the most workable study options for South Asian candidates •Generated an outcome-oriented database for the prospective applicants entailing funding opportunities and mediating authorities
    View
  • Liberty Books (Pvt.) Ltd
    Sales Recorder & Brand Ambassador
    Liberty Books (Pvt.) Ltd Jun 2018 - Jul 2018
    Karāchi, Sindh, Pakistan
    •Managed sales records and evaluated product categories based on the number of quarterly sales. • Analyzed the database of the products with highest sales in the regional branch. • Initiated and promoted on-going campaign on key product discounts, leading increase in in revenue by 10%.
    View

Rohan Kumar Skills

Proficient In Microsoft Word Power Point And Stata Excel

Rohan Kumar Education Details

Frequently Asked Questions about Rohan Kumar

What company does Rohan Kumar work for?

Rohan Kumar works for Four Seasons Hotels And Resorts

What is Rohan Kumar's role at the current company?

Rohan Kumar's current role is Business Intelligence Developer.

What schools did Rohan Kumar attend?

Rohan Kumar attended Mcgill University - Desautels Faculty Of Management, Lahore University Of Management Sciences.

What skills is Rohan Kumar known for?

Rohan Kumar has skills like Proficient In Microsoft Word, Power Point And Stata, Excel.

Who are Rohan Kumar's colleagues?

Rohan Kumar's colleagues are Maria Leonila Bunuan, Abhi'ss Food And Travel, Branka Murray, Cameron Johnson, Wina Bi, Khalfi Skander, Noe Galdamez.

Not the Rohan Kumar you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.