Karan Upneja

Toronto,ON

Summary

Highly motivated and detailed-oriented candidate passionate about using data to improve business performance and customer experience. Skilled at leveraging data to develop actionable solutions to business challenges and utilizing data mining and data visualization to create meaningful insights. Excellent technical aptitude and knowledge of programming languages, data analytics and data visualization.

Overview

years of professional experience

Work History

Associate Consultant

Capgemini - Client, IKEA

06.2018 - 04.2022

Managed to solve around 10-15 tickets raised by customers or employees of IKEA to maintain support promise.
Communicate with customers and provide them with quick solutions to their problems.
Worked on almost 50 PBIs and successfully converted them to PKEs. Identified the root cause of the issue and provide the fix.
Carried out the data cleanup activity twice a year where data has to be cleaned out from the test environments and then pushed the original data from production to test environment.
Created weekly and monthly reports using the user purchase data with the help of excel - Pivot tables and charts.
Carried out daily duties accurately and efficiently.
Collaborated in team based, Agile environment to accomplish objectives by deadlines.
Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.

Education

PG Diploma - Big Data Analytics

Georgian College of Applied Arts And Technology

Barrie, ON

12.2022

Bachelor of Technology - Information Technology

Poornima College of Engineering

Jaipur, Rajasthan

04.2018

Skills

Programming Languages: Python, Java
Databases: Oracle, MSSQL, MySQL, SQL Server
Microsoft Power BI
Tableau
Hadoop
Apache Spark
MS Excel [Advanced Excel Spreadsheet Functions(vlookup, hlookup Index etc), Pivot table, Charts]
MS Powerpoint
MS Word

Jupyter Notebook
Google Suite
Git
Data Cleaning
Data and Analytics
Organization and Time Management
Decision Making Skills
Eagerness to Learn New Technologies
Client Meetings

Projects

COVID19 Analysis | Excel, Python, PowerBI

Sourced the data from Canada's official website and cleaned the data using Excel and Python
Build the relation between different data sources to thoroughly analyze the impact of COVID19 based on various factors.
Created the major KPIs in PowerBI using DAX and power query.
Analyzed the data trends and created an interactive dashboard in PowerBI.
Done the predictive analysis to predict the COVID19 cases for upcoming months using ARIMA model using python.

CRYPTOCURRENCY TREND ANALYSIS | Python, MongoDB, Flask Framework

Sourced API data and stored in NoSQL Database "MongoDB"
Prepared the data for visualization using python in jupytor notebook.
Made interactive charts in goggle charts using JavaScript.
Build a website using Flask framework and created a dashboard to display major KPIs

Accomplishments

Awarded with the "Star Performer Award" for excellence in my work for quarter 2 in 2021.
Supervised team of 4 staff members.

Timeline