Data Analyst & Python Developer

Transforming Raw Data into Actionable Insights

Analytical and detail-oriented Data Analyst with 1 year of hands-on experience in transforming raw data into actionable insights using Python, Power BI, SQL, and Excel. Experienced in building automated dashboards, conducting root-cause analysis, and collaborating with cross-functional teams.

About Me

IMG20220714172943 Krushnakant Kulkarni

Data-Driven Professional with Engineering Background

I'm a passionate Data Analyst with a unique combination of mechanical engineering background and advanced data analytics skills. Currently working at Maestro Intellect, I specialize in transforming complex datasets into strategic insights that drive business decisions.

My expertise spans across Python programming, SQL database management, Power BI dashboard creation, and advanced Excel analytics. I have successfully automated KPI reporting systems, conducted comprehensive EDA, and mentored junior team members.

9579324004
kkulkarni4004@gmail.com
Pune, Maharashtra

Career Journey

2016 - 2017
Secondary School Certificate
Shri Mahatma Basveshwar Vidyalaya, Omerga
Omerga, Dharashiv, Maharashtra, India
Completed SSC with an impressive score of 80%, demonstrating dedication and academic excellence during foundational years.
🏆 80% Score
2018 - 2019
Higher Secondary School Certificate
Shri Chhatrapati Shivaji College, Omerga
Omerga, Dharashiv, Maharashtra, India
Completed HSC in Science stream with a commendable score of 61.40%, building strong analytical and scientific thinking foundation.
🔬 Science Stream
2019 - 2023
Bachelor of Mechanical Engineering
Indira College of Engineering and Management, Pune
Pune, Maharashtra, India
Graduated with 64.40% in Mechanical Engineering, developing strong problem-solving skills and technical foundation that supports data analysis work.
⚙️ Engineering Degree
2024 - Present
Data Analyst
Data Council, Pune
Pune, Maharashtra, India
Currently working as a Data Analyst, specializing in data cleaning, transformation, and analysis using Python, SQL, Excel, and Power BI. Developing dashboards and automating reporting for real-time business decisions.
💼 Current Position

Professional Experience Details

Data Analyst
Maestro Intellect, Pune
June 2024 – Present
Leading data-driven decision making through advanced analytics, automated reporting, and cross-functional collaboration. Developed comprehensive KPI systems and mentored junior team members to enhance overall productivity.
  • Developed and automated KPIs using advanced SQL queries to support data-driven decisions across teams
  • Performed Exploratory Data Analysis using Python (Pandas, NumPy, Matplotlib) to uncover trends, outliers, and actionable insights
  • Collaborated with the Power BI team to transform KPIs into interactive dashboards for multiple departments
  • Interpreted business requirements and translated them into analytical reporting solutions
  • Trained and mentored 5 interns on SQL, data cleaning, and EDA, enhancing team productivity

Selected Project Experience

Performance Metrics Automation – Streamlined manual reporting by integrating SQL-based KPIs with dashboards, reducing reporting time by 40%.
Customer Insights Analysis – Conducted EDA on customer data to support retention strategies, contributing to a 10% increase in engagement.
Intern Development Program – Designed and led a structured intern training plan, accelerating onboarding and improving output quality.

Technical Skills

Programming & Analytics

Python
90%
SQL
95%
Power BI
85%
Excel
88%

Web Development

HTML5
90%
CSS3
85%
JavaScript
75%
Django
80%

Data Science Libraries

Pandas
92%
NumPy
88%
Matplotlib
85%
AWS Cloud
78%

Featured Projects

📊 Data Analysis & EDA Projects

Netflix Data Analysis

Python • Pandas • Matplotlib • Seaborn

Comprehensive exploratory data analysis on Netflix dataset showcasing 1-year experience in data cleaning, visualization, and business insights generation.

  • Advanced data cleaning and preprocessing techniques
  • Trend analysis in content release patterns over years
  • Country-wise content distribution and genre analysis
  • Interactive visualizations with heatmaps and countplots
  • Business insights on viewer preferences and platform trends
View on GitHub

Diwali Sales Analysis

Python • Pandas • NumPy • Seaborn

Deep-dive analysis into Indian consumer behavior during Diwali festival season, demonstrating end-to-end data analytics skills.

  • Customer demographic and behavioral analysis
  • State-wise sales performance and regional insights
  • Occupation-based purchasing pattern analysis
  • Product category performance evaluation
  • Correlation analysis and outlier detection techniques
View on GitHub

Airbnb Data Analysis

Python • Data Visualization • EDA

Comprehensive analysis of Airbnb rental data focusing on pricing trends, location preferences, and market insights.

  • Market trend analysis and pricing optimization
  • Location-based performance metrics
  • Host behavior and guest preference patterns
  • Seasonal trend analysis and demand forecasting
  • Interactive dashboards for business stakeholders
View on GitHub

🗃️ SQL Data Analysis Projects

Zomato Food Delivery Analysis

SQL • Database Design • Business Intelligence

Comprehensive SQL analysis of food delivery operations focusing on delivery performance, customer behavior, and operational efficiency.

  • Complex SQL queries for business insights extraction
  • Delivery performance and cancellation analysis
  • Customer behavior and satisfaction metrics
  • Revenue analysis and operational KPIs
  • Advanced joins and aggregation techniques
View on GitHub

Coffee Sales Data Analysis

SQL • Multi-table Analysis • Business Intelligence

Multi-table relational database analysis exploring coffee consumption patterns, customer behavior, and city-level demographics.

  • Relational database design with foreign key constraints
  • Customer behavior and sales pattern analysis
  • City-level demographic and consumption insights
  • Quarterly revenue analysis and trend identification
  • Advanced SQL joins and subqueries
View on GitHub

Netflix SQL Analysis

SQL • Content Analysis • Business Intelligence

SQL-based exploratory analysis of Netflix content focusing on viewer preferences, regional distribution, and content trends.

  • Content categorization and genre analysis
  • Regional distribution and availability insights
  • Director and cast performance metrics
  • Content rating and duration analysis
  • Business problem-solving with structured SQL queries
View on GitHub

Spotify Music Analysis

SQL • Advanced Analytics • Window Functions

Advanced SQL analysis on Spotify dataset showcasing window functions, CTEs, and complex aggregations for music trend analysis.

  • Advanced SQL with window functions and CTEs
  • Audio feature analysis and music trend identification
  • Artist performance metrics and ranking systems
  • Cross-platform streaming comparison (Spotify vs YouTube)
  • Complex data cleaning and transformation techniques
View on GitHub

Library Management System

SQL • Database Design • System Architecture

Complete library management system demonstrating database design, normalization, and comprehensive SQL operations.

  • Full database schema design with referential integrity
  • CRUD operations and transaction management
  • Advanced reporting and analytics queries
  • Branch performance analysis and reporting
  • Comprehensive use of SQL constraints and relationships
View on GitHub

Retail Sales Case Study

SQL • Retail Analytics • Business Intelligence

Comprehensive retail sales analysis extracting meaningful business insights from transaction-level data using advanced SQL techniques.

  • Transaction-level analysis and customer behavior insights
  • Sales trend analysis and performance metrics
  • Time-based analysis with shift performance evaluation
  • Category-wise sales performance and customer segmentation
  • Data cleaning and exploratory analysis workflows
View on GitHub

Certifications

SQL Foundations

Professional Certification

SQL Certification

Python Django Framework

Advanced Web Development

Django Certification

Web Design Basics

Frontend Fundamentals

Web Design Certification

AWS Cloud Practitioner

Amazon Web Services

AWS Certification

Profile Building

Professional Development

Profile Building Certificate

Data Analytics

Business Intelligence

Data Analytics Certificate

Get In Touch

Send Me a Message

Contact Information

Krushnakant Kulkarni

Data Analyst & Python Developer

Phone

9579324004

Email

kkulkarni4004@gmail.com

Location

Pune, Maharashtra, India

Let's Connect

I'm always interested in discussing new opportunities, innovative projects, and potential collaborations in data analytics and web development.