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
→
Bachelor of Science
Information Technology
Grade: 73.2%
Maharashtra State Board
→
HSC (12th)
General Studies
Grade: 76.31%
Maharashtra State Board
→
SSC (10th)
General Studies
Grade: 63.60%
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.