Jay Mahajan

Data Analyst

Nagpur, IN.

About

Results-driven Data Analyst with hands-on experience leveraging SQL, Python, Excel, Power BI, and Tableau to transform complex data into actionable insights. Proven ability to automate reporting processes, enhance data accuracy by 30%, and design impactful dashboards that drive strategic decision-making. Eager to apply strong analytical and problem-solving skills to optimize data-driven strategies in a dynamic environment.

Work

Unisoft Technology

|

Data Analyst Intern

Nagpur, Maharashtra, India

→

Summary

As a Data Analyst Intern at Unisoft Technology, Jay Mahajan cleaned, transformed, and analyzed large datasets to generate critical business insights and automate reporting workflows.

Highlights

Cleaned and transformed over 100K rows of data using SQL and Excel, boosting data accuracy by 30% for improved analytical reliability.

Automated critical data processing tasks with Python (Pandas, NumPy), reducing manual work by 40% and enhancing operational efficiency.

Developed and deployed 10+ Power BI/Tableau dashboards to visualize key revenue and retention KPIs, facilitating data-driven decision-making.

Wrote and optimized over 50 complex SQL queries (joins, aggregations, subqueries) to extract and analyze multi-source data.

Integrated data from 5+ disparate sources, streamlining reporting processes and enhancing comprehensive business insights.

Education

RTM Nagpur University

Nagpur, Maharashtra, India
→
Bachelor of Science Information Technology Grade: 73.2%

Maharashtra State Board

Maharashtra, Maharashtra, India
→
HSC (12th) General Studies Grade: 76.31%

Maharashtra State Board

Maharashtra, Maharashtra, India
→
SSC (10th) General Studies Grade: 63.60%

Certificates

Microsoft Power BI Certificate

Microsoft

Gen AI Certificate

Google Cloud

Data Science Training

Internshala

Prompt Engineering

DeepLearning.AI

Introduction to SQL

Simplilearn

Deloitte Data Analytics Virtual Experience

Forage

Skills

Programming

Python, SQL, DAX.

Visualization

Power BI, Tableau, Excel Charts.

Databases

MySQL, Oracle SQL Developer.

Excel

VLOOKUP, PivotTables, Power Query.

Analytics

Regression, Classification, EDA.

Tools

Jupyter, Git, VS Code.

Projects

Sales Customer Insights Dashboard (SQL, Power BI)

→

Summary

Developed a comprehensive Sales Customer Insights Dashboard using SQL and Power BI to analyze sales, profit, and order data, providing actionable insights for strategic business decisions.

Student Enquiry Tracking System (SQL)

→

Summary

Designed and implemented a robust Student Enquiry Tracking System using SQL, focusing on data integrity and improving lead-to-admission conversion rates.

Student Score Prediction Model (Python, ML)

→

Summary

Developed a Student Score Prediction Model using Python and machine learning techniques to forecast student performance with high accuracy.