NAMASTE, I'M PRANAV SOHANEY

DATA ANALYST

Transforming Raw Data into Actionable Business Insights

I work with SQL, Python, Excel, and Power BI to clean, analyze, and visualize data for decision-making. I also apply Machine Learning techniques on structured datasets—such as regression, classification, and clustering—to identify patterns, make predictions, and support data-driven business strategies.

Alongside analytics, I'm continuously learning Cloud and AI technologies to build scalable and future-ready data solutions.

View Projects Let's Talk

ABOUT ME

Turning data into decisions, not just dashboards

I'm an Integrated MBA student specializing in Information Technology & Finance at Greater Noida Institute of Technology (2021–2026), focused on building practical, business-driven data solutions.

I've completed 30+ hands-on projects using SQL, Python, Excel, and Power BI, with a strong focus on cleaning raw data, identifying meaningful patterns, and translating insights into decisions that support business growth.

To strengthen my analytical foundation, I'm actively learning through online data analytics courses from PhysicsWallah, where I'm building skills in data visualization, statistical analysis, and applied machine learning. In parallel, I'm developing knowledge in Cloud and AI technologies to help businesses create scalable, intelligent, and data-ready systems rather than isolated reports.

My goal is to bridge business understanding, analytics, and emerging technologies to solve real-world problems with measurable impact.

MY SKILLS

Tools and technologies I actively work with

📊
Data & Analytics
  • SQL – complex queries, joins, subqueries, aggregations
  • Python – data analysis (Pandas, NumPy), EDA, ML pipelines
  • Power BI – interactive dashboards, DAX basics, KPI tracking
  • Data Visualization – business-focused reporting and storytelling
  • Statistics – descriptive statistics, correlation, hypothesis basics
🤖
Machine Learning
  • Supervised Learning – regression, classification
  • Unsupervised Learning – clustering
  • Model Evaluation – accuracy, precision, recall, RMSE
☁️
Databases & Cloud
  • MongoDB – working with NoSQL collections, aggregation basics
  • AWS (Learning & Applied) – EC2 fundamentals, S3 storage, data handling
✨
AI Tools & Productivity
  • AI Tools – using AI assistants for data exploration, code optimization, and analysis support

MY EDUCATION

Academic background and qualifications

2021 – 2026 (Expected)

Integrated MBA

Greater Noida Institute of Technology

Affiliated to Dr. A.P.J. Abdul Kalam Technical University (AKTU), Uttar Pradesh

Specialization: Information Technology & Finance

Pursuing an Integrated MBA under AKTU, combining business management with practical exposure to data analytics, information systems, and financial analysis, with a focus on applying technical skills to real-world business problems.

2019 – 2021

Higher Secondary Education (Class XII – CBSE)

Shri Vinayak Academy International Senior Secondary School

Stream: Physics, Chemistry, Mathematics (PCM)

Location: Orai, Uttar Pradesh

Completed Class XII under the CBSE Board, developing a strong foundation in mathematical reasoning, analytical thinking, and problem-solving through a rigorous science-based curriculum.

MY EXPERIENCE

Practical exposure through projects are attached on My Resume, internships, and freelance work

2024 – Present

Data Analytics Learner (Online Programs)

PhysicsWallah (PW)
  • Completed structured online coursework in SQL, Python, Excel, and Power BI
  • Worked on practice-based and real-world datasets for data cleaning, analysis, and visualization
  • Built interactive dashboards to extract insights and support data-driven decision-making
Apr 2025 – May 2025

Data Science Intern (Remote)

Skillfied Mentor
  • Processed and analyzed 50,000+ records using Python and SQL
  • Performed Exploratory Data Analysis (EDA) to uncover trends and anomalies
  • Designed Power BI dashboards for KPI tracking and performance monitoring
  • Applied Machine Learning models (regression, classification, clustering) for pattern identification
2024 – Present

Freelance Data Analyst

Self-Employed
  • Delivered data cleaning, SQL querying, and reporting for individual clients
  • Created interactive Power BI dashboards tailored to business requirements
  • Translated raw data into actionable insights for operational and performance improvement

GET IN TOUCH

Let's collaborate on your next data project

📧

Email

Pranavsohaney90@gmail.com
📱

Phone

+91 9076936175
💼

LinkedIn

Connect With Me
📄

Resume

Download Resume
🪔
Python EDA

Diwali Sales Analysis

Exploratory data analysis on sales data using Python to improve customer experience and sales strategy.

View Project →