Summary

Overview

Work History

Education

Skills

Projects

Certification

Timeline

Navjot Batish

Data Analyst

Bangalore

Summary

Experienced Data Analyst with a strong background in data extraction, cleaning, and manipulation, as well as data visualization and analysis. Proficient in leveraging Python and its libraries (NumPy, Pandas, Matplotlib, Seaborn), SQL, Excel/Google Sheets, Tableau, and statistical analysis to extract insights from complex datasets. Skilled in business analysis, including requirement gathering, stakeholder management, and process optimization, to drive strategic decision-making and enhance business processes. Possesses excellent communication skills, problem-solving abilities, and critical thinking, ensuring effective collaboration and impactful decision-making.

Overview

4

4

years of professional experience

3

3

Certifications

Work History

Data Analyst

Coditro Technology LLP

10.2023 - Current

Data Extraction,cleaning and preprocessing : Utilized SQL queries to extract large datasets for analysis. Ensuring 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.
Requirements and Documentation : Proficient in creating business requirements, functional requirements, user stories, and traceability matrices.

Scaler Academy

Bangalore

05.2022 - 09.2023

Utilized SQL to extract, clean, and transform large datasets from various sources, including student information systems and learning management systems.
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 develop and implement data-driven solutions to improve the company's educational products.
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.
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.

Think And Learn Pvt. Ltd.

Bangalore

01.2021 - 07.2021

Conducting product demonstrations and presentations to prospective clients.
Building and maintaining strong relationships with clients to ensure customer satisfaction and retention.
Identifying opportunities and executing strategies to expand the company's client base and revenue streams.

Education

Data Science And Machine Learning

Scaler Academy

B.Tech - Bioinformatics And Biotechnology

School of Bioinformatics And Biotechnology (P.A.U)

Ludhiana, India

06-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

Business Analysis, requirement gathering, stakeholder management, process optimization, gap analysis

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

Certification

Python Libraries - Scaler Academy

Timeline

Data Analyst

Coditro Technology LLP

10.2023 - Current

Scaler Academy

Bangalore

05.2022 - 09.2023

Think And Learn Pvt. Ltd.

Bangalore

01.2021 - 07.2021

Data Science And Machine Learning

Scaler Academy

B.Tech - Bioinformatics And Biotechnology

School of Bioinformatics And Biotechnology (P.A.U)