Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

POOJA ROY

Bangalore

Summary

Experienced data analyst with a strong background in data extraction,cleaning,and manipulation,alongside data visualization and analysis. Proficient in extracting insights from complex datasets to drive strategic decision-making and optimize business processes. Skilled in Python and it's libraries( NumPy, Pandas, Matplotlib, Seaborn),SQL, Excel/Google Sheets,Tableau,and Statistical analysis with good communication skills, problem solving, and critical thinking abilities.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

Zen Data Shastra
08.2024 - 09.2025
  • Data Extraction,cleaning and preprocessing.Utilized SQL queries to extract large datasets for analysis. Ensured data quality by cleaning and preprocessing datasets using python libraries such as NumPy and Pandas. This involves identifying and addressing missing values, outliers, and inconsistencies to maintain data integrity.
  • Exploratory Data Analysis (EDA). Conducting EDA to understand the underlying patterns and relationships within the data. This involves using statistical methods, data visualization techniques.
  • Reporting and Visualization. Creating reports, dashboards, and visualizations to communicate key findings and insights to stakeholders. Utilizing tools such as Tableau and python libraries (Matplotlib and Seaborn )to present data in a clear and actionable format.

Bangalore

Simplilearn Solutions Pvt. Ltd.
07.2021 - 09.2022
  • Analyzing historical sales data to identify trends and patterns, this involved using statistical techniques and data visualization tools.
  • Segmenting customer base based on factors such as industry, job role, and level of experience to identify high-value customer segments for targeted upselling and cross-selling opportunities.
  • Collaborated with cross-functional teams to design and implement data-driven solutions based on customer feedback, enhancing the company’s educational products.
  • Designed and developed interactive reports and dashboards using Tableau, enabling stakeholders to explore and visualize data in real time, identify trends, and make informed business decisions.

Bangalore

Think And Learn Pvt. Ltd.
01.2021 - 07.2021
  • Leveraged advanced Excel functions and formulas to conduct in-depth data analysis, create interactive dashboards, and visualize key metrics for monitoring student performance, engagement, and retention.
  • Identified patterns in user engagement and drop-off points to improve retention.

Education

Data Science And Machine Learning

Scaler Academy

B.Tech - Electronics And Communication Engineering

R. V. College of Engineering
2020

Skills

  • Python and it's libraries(NumPy, Pandas, Matplotlib, Seaborn): Data cleaning, manipulation, visualization and analysis
  • SQL: Data extraction and querying
  • Microsoft Excel/Google sheets: PivotTables, VLOOKUP, HLOOKUP, Macros,charts
  • Tableau: Data visualization, Dashboard creation, Data connection
  • Strong understanding of statistical analysis (probability, descriptive statistics,inferential statistics,hypothesis testing,A/B testing)
  • Exploratory Data Analysis(EDA),data mining, business intelligence,ad-hoc reporting
  • Critical thinking and problem-solving
  • Excellent interpersonal and communication skills

Certification

  • Python Libraries - Scaler Academy
  • SQL - Scaler Academy
  • EDA- Scaler Academy

Projects

 Understanding E-Commerce Trend | Business Case Study 


  • Analyzed a 100k e-commerce order dataset (2016-2018) for a major Brazilian retail company using SQL and Tableau to uncover trends, customer behavior, pricing variations, and shipping preferences.
  • Delivered actionable insights, informing business decisions, optimizing strategies, and enhancing customer satisfaction.
  • Tech Stack: SQL, Tableau.



 Netflix Data Analysis for Content Strategy | Business Case Study


  • Pre-processed & analyzed the data using Pandas, NumPy, Matplotlib & Seaborn libraries.
  • Identified and analyzed trends resulting from data correlation and gave insights/recommendations for a profitable business.
  • Tech Stack: Python Libraries(NumPy,Pandas,Matplotlib,Seaborn).


 Customer Profiling of Aerofit Treadmills |Business Case Study 


  • Build a customer profile for a leading fitness equipment-producing company to optimize marketing strategies using Python.
  • Applied descriptive statistics and probability concepts like Bayes theorem, Marginal & conditional probability to understand the purchasing patterns of different customers.
  • Tech Stack: Python, Applied Statistics, Bayes theorem, Marginal & Conditional probability.


 Walmart - Spending Analysis | Business Case Study 


  • Analyzed Walmart’s Black Friday transactional data to understand the purchase behavior of consumers.
  • Employed the Central Limit Theorem to evaluate and conclude that gender, marital, financial & demographic factors are strongly related with a 95% confidence interval.
  • Tech Stack: Central Limit Theorem, Statistical Analysis, Data Exploration, Data Visualization.


 Yulu-Revenue Dip Analysis| Business Case Study


  • Analyzed the factors on which the demand for these shared electric cycles depends using Hypothesis Testing.
  • Delivered actionable insights, informing business decisions, optimizing strategies, and enhancing customer satisfaction.
  • Tech Stack: Hypothesis Testing(Bi-Variate Analysis,2-sample t-test, Annova ,Chi-square).





Timeline

Data Analyst

Zen Data Shastra
08.2024 - 09.2025

Bangalore

Simplilearn Solutions Pvt. Ltd.
07.2021 - 09.2022

Bangalore

Think And Learn Pvt. Ltd.
01.2021 - 07.2021

B.Tech - Electronics And Communication Engineering

R. V. College of Engineering

Data Science And Machine Learning

Scaler Academy
POOJA ROY