PRANAV Rai

Data Analyst

Bengaluru, India 80 · Excellent

About

Aspiring Data/Business Analyst with hands-on experience in Python, SQL, Power BI, and Excel, backed by data analytics certifications from Microsoft, Deloitte, and Tata. Skilled in exploratory data analysis (EDA), data cleaning, statistical analysis, predictive modeling, and dashboard development, with a history of turning raw data into clear, actionable insights. Built a CNN-based classification model that reached 90% accuracy, delivered a Power BI dashboard that shaped retail sales decisions, and built a SQL-driven relational database system. Comfortable coordinating student, industry, and law-enforcement stakeholders while organizing large-scale technical events.

Skills & Expertise (25)

Python Advanced

8.2/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Pandas Advanced

7.8/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

NumPy Intermediate

7.5/10

Years Exp

Excel Advanced

7.0/10

Years Exp

Statistical Analysis Intermediate

7.0/10

Years Exp

scikit-learn Intermediate

7.0/10

Years Exp

Database Management Systems Intermediate

7.0/10

Years Exp

MySql Intermediate

7.0/10

Years Exp

Predictive Modeling Intermediate

6.5/10

Years Exp

Deep Learning Intermediate

6.5/10

Years Exp

Relational Database Design Intermediate

6.5/10

Years Exp

SQL Server Intermediate

6.5/10

Years Exp

TensorFlow Intermediate

6.5/10

Years Exp

Feature Engineering Intermediate

6.0/10

Years Exp

Git Intermediate

6.0/10

Years Exp

GitHub Intermediate

6.0/10

Years Exp

VS Code Intermediate

6.0/10

Years Exp

Operating systems Intermediate

5.5/10

Years Exp

Object-Oriented Programming Intermediate

5.5/10

Years Exp

Computer Networks Intermediate

5.0/10

Years Exp

CNN EDA HTML

Work Experience

Developer

Traffic Sign Recognition System

Present - Present

Built a Convolutional Neural Network (CNN) model to classify 40+ traffic sign categories, achieving 90% classification accuracy. Implemented real-time sign detection using OpenCV and live camera input, optimizing the inference pipeline to under 100ms latency. Improved model robustness under variable lighting conditions by 15% through a custom data augmentation and preprocessing pipeline. Increased final model accuracy by 8% via iterative hyperparameter tuning and training optimization.

Data Analyst

Blinkit

Present - Present

Performed exploratory data analysis on a 10,000+ row retail transactional dataset to identify customer behavior and product-level sales trends. Cleaned and transformed raw sales data, cutting manual EDA time by 30% and reducing reporting errors. Built and launched an interactive Power BI dashboard with 5+ Key Performance Indicator (KPI) visualizations, enabling stakeholders to track sales performance and support data-driven decision-making.

Database Designer

Bank Management System

Present - Present

Designed a relational database schema supporting customer account management and transaction processing for 500+ simulated records. Developed core banking operations (deposits, withdrawals, transfers) using SQL Create, Read, Update, Delete (CRUD) operations with referential integrity constraints. Reduced query execution time by 25% through index optimization and query restructuring.