← Back to list
Registration: 25.01.2025

Tejvansh Randhawa

Specialization: Data Analyst
— I am a Data Analyst with a proven ability to extract actionable insights and drive business performance. — With experience as an intern in data analytics and data science, I have honed my skills in analyzing complex datasets and solving real-world problems. — I have also completed several certifications in data analytics and data science.
— I am a Data Analyst with a proven ability to extract actionable insights and drive business performance. — With experience as an intern in data analytics and data science, I have honed my skills in analyzing complex datasets and solving real-world problems. — I have also completed several certifications in data analytics and data science.

Portfolio

Retail Sales Trial Analysis

● Led a comprehensive analysis to evaluate the impact of targeted interventions in trial stores, comparing their performance to matched control stores. ● Generated insights from 246,742 transactions and customer segmentation data of 72,637 loyalty customers, focusing on lifestyle stage and spending behavior. Designed and executed a control store matching process using similarity metrics, ensuring accurate comparisons and minimizing external influences. Achieved a 7.47% increase in sales in trial stores, primarily driven by premium customers, and delivered actionable recommendations for scaling the strategy. Utilized Python (Pandas, NumPy, Matplotlib, Seaborn) for data analytics and visualization, supporting evidence-based decision- making.

HR Analytics Dashboard

● Created visually compelling Power Bi dashboard for the HR department to optimize operations with data-informed decision- making. ● Successfully calculated and analyzed the company's overall attrition rate, which stood at 16.12%. ● Discovered a significant correlation between educational backgrounds and attrition, with employees holding degrees in life sciences experiencing the highest attrition rate at 37.55%.

Shipping Data Analysis

● Unveiled pivotal insights using python driving operational optimization and informed decision-making in the shipping industry. ● Led to conclusion that the Port of Tianjin as the highest-value shipping destination, with a total value of $241.7 million, and pinpointed the Port of Shanghai as the lowest-value destination, with $203.4 million in shipping value. ● Delivered critical insights into global shipping industry, showcasing China as the highest-value shipping nation at $445.1 million. ● Utilized Python (Pandas, NumPy, Matplotlib, Seaborn) for analysis and visualization.

Skills

Python
SQL
MS Excel
Power BI
Tableau
Data Analysis
Grafana

Work experience

Data Analyst
02.2024 - 08.2024 |Vimaan
Data analysis, SQL, Grafana, Python, RCA, MS Excel
● Led root cause analysis to enhance product performance and client data accuracy. ● Developing and implementing SQL queries to monitor KPIs, track accuracy, and identify error rates, contributing to optimal product performance. ● Authoring and maintaining detailed documentation to support related procedures.
Data Science
09.2022 - 12.2022 |DevTown
Data Science, Python, Numpy, Matplotlib, Pandas, Scikit-learn
● Utilized python to analyze and develop a Machine Learning model which takes necessary inputs from the user and gives price per sq ft as the output. ● Achieved 84% accuracy rate using linear regression model. ● Analyzed the data on 13,320 real locations around Bengaluru city.

Educational background

Computer Science with Specialization in Gaming Technology (Bachelor’s Degree)
2020 - 2024
VIT Bhopal University

Languages

EnglishUpper IntermediateHindiUpper IntermediateFrenchElementaryPunjabiIntermediate