Data Analytics

[Ashay Kosare]

Nagpur, Maharashtra +91-860******* ***********.***@*****.***

LinkedIn: linkedin.com/in/ashay-kosare-879831206

EDUCATION

L.K.I.M.S.R Institute of Management Studies, Chandrapur – M.B.A, Finance Oct 2022 – May 2024 CGPA: 8.1 Affiliated to Gondwana University Premier College, Nagpur – B.Com

June 2017 – April 2021 CGPA: 8.2 Affiliated to Nagpur University Professional Summary

Detail-oriented Data Analytics Intern with hands-on experience in data collection, cleaning, transformation, and visualization using Python (Pandas, NumPy), SQL, and Power BI. Skilled in building automated reports, performing exploratory data analysis (EDA), and developing interactive dashboards to drive data-driven business decisions. Strong communicator with proven ability to collaborate across teams and deliver actionable insights. Seeking to leverage analytical expertise and MBA background in Finance to support business growth.

SKILLS SUMMARY

Languages:

Python, SQL, Java

Frameworks:

Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn

Tools:

Excel (Pivot Tables, Power Query), Power BI, Tableau, MySQL Platforms:

Jupyter Notebook, Visual Studio Code, Google Collab Soft Skills:

Problem Solving, Data Storytelling, Communication, Team Collaboration, Critical Thinking Analytics & ML:

Data Cleaning, Data Visualization, Basic Machine Learning (Linear Regression, Logistic Regression, Decision Trees), Statistics, Business Intelligence WORK EXPERIENCE

Data Analytics Intern

Unified Mentors March 15, 2025 – April 15, 2025

• Assisted in the end-to-end data lifecycle by collecting, cleaning, transforming, and validating large volumes of raw data from multiple sources using Python (Pandas, NumPy) and SQL, ensuring accuracy and consistency for analysis.

• Developed, maintained, and automated comprehensive reports in Microsoft Excel, leveraging advanced formulas and pivot tables to track monthly sales performance, key business metrics, and KPIs, reducing manual effort and reporting errors by

~20%.

• Designed and implemented dynamic, interactive dashboards and visual reports using Power BI and Tableau, enabling management and stakeholders to visualize critical business insights and monitor trends for informed decision-making.

• Conducted in-depth exploratory data analysis (EDA) using Python (Matplotlib, Seaborn) and Excel to identify significant trends, patterns, and anomalies, providing actionable insights to support marketing and sales initiatives.

• Collaborated with cross-functional teams (marketing, sales, product management) to understand data needs and translate business requirements into effective analytics solutions.

• Streamlined data processing workflows by creating standardized data cleaning protocols in Python and SQL, improving overall data quality and reporting efficiency.

• Presented analytical findings and reports to senior team members and stakeholders through clear visual storytelling using Power BI, Tableau, and Excel dashboards.

• Gained hands-on experience in database management and querying by writing advanced SQL queries involving joins, aggregations, and data extraction for business analysis.

• Demonstrated strong problem-solving skills by identifying data discrepancies, troubleshooting issues, and suggesting process improvements to enhance data reliability.

• Utilized Google Sheets for collaborative data tracking and real-time reporting, enabling efficient team coordination.

• Developed a solid understanding of how data analytics drives business growth and optimizes operational performance in a fast-paced environment. PROJECTS

Sales Dashboard Project – Power BI

Jan 2025 – Feb 2025

• Designed and developed an interactive Power BI dashboard to monitor and analyze sales performance, customer segmentation, and product trends, enabling clearer visualization of key business metrics (Power BI, DAX, Power Query).

• Applied DAX formulas and slicers to create dynamic, user-driven filtering options that improved data exploration and report customization (DAX).

• Integrated and transformed multiple data sources using Power Query, ensuring data accuracy and consistency across reports (Power Query).

• Delivered actionable insights by visualizing sales trends and customer behaviour, supporting data-driven decision-making for business stakeholders (Data Visualization).

• Enhanced reporting efficiency by building an intuitive dashboard layout that simplified complex data for non-technical users.

Customer Churn Prediction Project – Python

Feb 2025 – Mar 2025

• Processed and cleaned raw customer data using Pandas and NumPy, performing feature engineering to improve model quality (Python, Pandas, NumPy, Feature Engineering).

• Built, trained, and validated a logistic regression model achieving 85% accuracy in predicting customer churn, providing valuable insights into retention strategies

(Python, Logistic Regression, Machine Learning).

• Conducted exploratory data analysis (EDA) using Matplotlib and Seaborn to identify key factors influencing churn and visualize model outcomes (Matplotlib, Seaborn, EDA, Data Visualization).

• Documented model methodology and presented findings clearly to support understanding by both technical and non-technical stakeholders (Technical Documentation, Communication).

SQL Retail Data Exploration Project

Mar 2025 – Apr 2025

• Developed advanced SQL queries including joins, groupings, window functions, and subqueries to analyze retail sales data comprehensively (SQL, Joins, Window Functions, Query Optimization).

• Extracted and interpreted sales trends and customer purchase behavior to inform inventory and marketing decisions (Data Analysis, Retail Analytics).

• Automated routine data extraction and reporting tasks, improving process efficiency and reducing manual effort (SQL Automation, Reporting).

• Collaborated with peers to validate data quality and refine analysis approaches

(Teamwork, Data Validation).

CERTIFICATIONS

Google Data Analytics Professional Certificate – Coursera Data Analytics & Machine Learning – CloudyML

SQL for Data Analytics – CloudyML

Power BI for Data Visualization – CloudyML

Excel for Data Analysis – CloudyML

Contact this candidate