Mahesh Bollam — Data Analyst

visitor@portfolio:~$> cat README.md

Motivated and detail-oriented Data Analyst fresher with hands-on experience in SQL, Excel, Python, Power BI, and Tableau. Skilled in data cleaning, exploratory analysis, dashboarding, and building data models to turn complex datasets into clear business insights. Developed projects in HR and sales analytics that improved data quality, forecasting, and decision-making.

visitor@portfolio:~$> experience --list

Data Analyst@HR Analytics & Predictive Retention Dashboard Project

- [Hyderabad, India]

Engineered an end-to-end data cleaning and validation pipeline using Python and Pandas to process a 1,470-record corporate dataset,
ensuring 100% data integrity.
Executed SQL Server transformations using CTEs and Views to clean, aggregate, and validate HR data, maintaining consistency across
analytical outputs.
Designed an interactive Power BI dashboard with a Star Schema data model and custom DAX measures to track key performance
indicators (KPIs) and evaluate a 16.1% attrition rate.
Developed an "Attrition Risk Flag" algorithm using satisfaction and workload metrics, providing leadership with automated metrics
to identify high-risk areas.

Data Analyst@Sales Data Analytics & Forecasting Project

- [Hyderabad, India]

Executed a comprehensive sales analytics project by collecting, cleaning, and preprocessing large-scale datasets from multiple sources
to eliminate errors and support reliable analysis.
Conducted Exploratory Data Analysis (EDA) to uncover critical seasonal trends, customer purchasing patterns, and key operational
demand drivers.
Developed predictive machine learning models using Scikit-learn to forecast future sales demand with engineered temporal features.
Translated complex analytical results into regular business reports and strategic visualizations, increasing decision-making accuracy
by 35%.

visitor@portfolio:~$> npm install --save-dev

+Data Cleaning

+Data Preprocessing

+Data Transformation

+Exploratory Data Analysis (EDA)

+Ad-hoc

+Microsoft SQL Server (DDL

+DML

+Joins

+CTEs

+Subqueries

+Stored Procedures

+Views

+Triggers

+DCL

+Python (NumPy

+Pandas

+Scikit-learn)

+Power BI (Data Modeling

+DAX

+Star Schema)

+Tableau

+Excel Dashboards

+Matplotlib

+Seaborn

+Descriptive Statistics

+Inferential Statistics

+Probability Distribution

+Hypothesis Testing

+Microsoft Excel

+MS SQL Server Management Studio

+Jupyter Notebook

+Anaconda

visitor@portfolio:~$> cat /etc/education

Bachelor of Technology, Electronics and Communication Engineering

Sri Indu College of Engineering and Technology

- Jan 2025 | Hyderabad, India

visitor@portfolio:~$> cat .contact

[email protected]

7997709266

github

visitor@portfolio:~$echo "Thanks for visiting!"

visitor@portfolio:~$> cat README.md

visitor@portfolio:~$> experience --list

Data Analyst@HR Analytics & Predictive Retention Dashboard Project

- [Hyderabad, India]

Engineered an end-to-end data cleaning and validation pipeline using Python and Pandas to process a 1,470-record corporate dataset,
ensuring 100% data integrity.
Executed SQL Server transformations using CTEs and Views to clean, aggregate, and validate HR data, maintaining consistency across
analytical outputs.
Designed an interactive Power BI dashboard with a Star Schema data model and custom DAX measures to track key performance
indicators (KPIs) and evaluate a 16.1% attrition rate.
Developed an "Attrition Risk Flag" algorithm using satisfaction and workload metrics, providing leadership with automated metrics
to identify high-risk areas.

Data Analyst@Sales Data Analytics & Forecasting Project

- [Hyderabad, India]

Executed a comprehensive sales analytics project by collecting, cleaning, and preprocessing large-scale datasets from multiple sources
to eliminate errors and support reliable analysis.
Conducted Exploratory Data Analysis (EDA) to uncover critical seasonal trends, customer purchasing patterns, and key operational
demand drivers.
Developed predictive machine learning models using Scikit-learn to forecast future sales demand with engineered temporal features.
Translated complex analytical results into regular business reports and strategic visualizations, increasing decision-making accuracy
by 35%.

visitor@portfolio:~$> npm install --save-dev

+Data Cleaning

+Data Preprocessing

+Data Transformation

+Exploratory Data Analysis (EDA)

+Ad-hoc

+Microsoft SQL Server (DDL

+DML

+Joins

+CTEs

+Subqueries

+Stored Procedures

+Views

+Triggers

+DCL

+Python (NumPy

+Pandas

+Scikit-learn)

+Power BI (Data Modeling

+DAX

+Star Schema)

+Tableau

+Excel Dashboards

+Matplotlib

+Seaborn

+Descriptive Statistics

+Inferential Statistics

+Probability Distribution

+Hypothesis Testing

+Microsoft Excel

+MS SQL Server Management Studio

+Jupyter Notebook

+Anaconda

visitor@portfolio:~$> cat /etc/education

Bachelor of Technology, Electronics and Communication Engineering

Sri Indu College of Engineering and Technology

- Jan 2025 | Hyderabad, India

visitor@portfolio:~$> cat .contact

[email protected]

7997709266

github

visitor@portfolio:~$echo "Thanks for visiting!"