Rohan Kumar Email & Phone Number

Toronto, On, Ca

Toronto, On, Ca

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.

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

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.

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

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

• 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.

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

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%.

Masters Of Management Analytics

• Entrance Scholarship

Bachelor, Economics And Mathematics

Peer Advisor Leader (June 2021 - May 2022) • Advising 20 Freshman and Sophomore students regarding University Policies, academic.