Turning Raw Data into Operational Clarity at Scale.
SQL • Python • Automation • Dashboards • Multi-city Operations
Building efficient, scalable, data-driven systems that improve business productivity.
The Growth Mindset
A fixed mindset sits on a single truth; a growth mindset climbs a mountain of curiosity.
The Query Guy
A structured, free platform to learn data analytics using real-world projects and curated open resources.
About me
I'm a data analyst with hands-on experience in SQL, Python (Pandas, NumPy), and advanced Excel, working extensively on data analysis, workflow automation, and performance reporting. I build automated data pipelines using Google Apps Script, Power Automate, and Power Query, and develop unified dashboards in Looker Studio to support cross-functional teams. My work focuses on transforming raw data into reliable insights and scalable, data-driven systems that improve business productivity and decision-making.
Outcome Focused
Delivering measurable business value through deep exploratory data analysis and real-time availability.
Automation First
Eliminating manual reporting tasks by building robust ETL pipelines using Python and Google Apps Script.
Professional Experience
A track record of driving operational efficiency and business growth through data-driven decision making.
Operations Data Analyst
- Automated SQL + Python reporting pipelines for near real-time data availability.
- Deep EDA on agent performance, lead funnels, and QA trends.
- Developed KPI dashboards for contractability, schedule rate, and SV timelines.
- Unified CRM + dialer datasets for cross-functional visibility.
- Designed frameworks for conversion %, repeat leads, and engagement metrics.
Account Manager
- Managed client relationships and conducted funnel drop-off analysis.
- Received Over-Achiever recognition for consistent target delivery.
- Maintained SV target consistency across multi-city operations.
Unit Head
- Led sales team achieving 15% MoM growth through data-driven mentoring.
- Performed call analysis to improve agent conversion rates.
- Aligned team strategy with leadership goals using performance reporting.
Business Development Executive
- Managed NRI real estate services with 170%–230% performance months.
- Recognized as Top Performer for 6 consecutive months.
Professional Endorsement
A verified professional endorsement from a direct manager.
Amit Sarwade
Operations Manager, Magicbricks
Direct Manager
I’ve had the privilege of working with Pranab at Magicbricks, and he has consistently proven himself to be an exceptional Data Analyst with rare versatility and drive.
Pranab is outstanding in data analysis, automation, and advanced Google Sheets/MS Excel work. His deep expertise in Google Apps Script enabled him to automate highly complex reports that previously required hours of manual effort. These automations not only saved significant time but also brought structure, accuracy, and scalability to our operations.
He is also very comfortable working with AI tools, often integrating them creatively into his workflow to enhance productivity and bring innovative solutions to the team.
One of Pranab’s strongest qualities is his solution-oriented mindset. He learns incredibly fast, approaches every task with discipline, and carries a solid bias for action—always stepping up, always delivering. His work ethic is remarkable, and he reliably takes ownership of challenges without hesitation.
Pranab will be a true asset to any team or organisation. I strongly recommend him for any role that demands analytical thinking, automation expertise, and a proactive, high-performance work style.
Technical Portfolio
Classified repository of 24 technical projects across multiple domains.
The Query Guy
Designed and built a separate, live learning platform focused on data analytics, using real-world projects and curated open resources. The platform provides a structured learning path for beginners by organizing concepts, tools, and projects in a practical, noise-free manner.
Problem
Traditional analytics learning is often fragmented or pay-walled. This platform addresses the need for a noise-free, project-driven environment where genuine interest — not payment — drives meaningful learning outcomes.
Technique
Engineered a product-level system using Next.js and GitHub API for automated ingestion of real-world projects. The infrastructure relies on Markdown/MDX for content delivery, ensuring a maintainable and scalable learning environment.
Outcome
Successfully launched a scalable learning ecosystem that democratizes access to high-quality data analytics education through open-source contribution and automated content delivery.
Core Infrastructure Features
Google Apps Script & JavaScript Automation
7Technical implementation and specialized solutions
Problem
This script automates two tasks inside Google Sheets: Importing data from an external source sheet. Creating an hourly snapshot that summarises city-wise counts and threshold-based counts. It helps maintain an updated view of data while also generating hourly summaries without manual work.
Technique
Built with JavaScript.
Outcome
Functional solution delivering practical results.
Problem
This project automates the extraction, filtering and transformation of lead records received through email over the past week. The script reads daily CSV attachments from emails matching a specific subject line, identifies valid leads based on predefined rules, and aggregates all unique leads into a single structured output sheet.
Technique
Built with JavaScript.
Outcome
Functional solution delivering practical results.
Problem
This script automates the process of reading an email with a CSV attachment, extracting the relevant data based on city and condition rules, formatting key date fields, and updating two separate sheets inside a spreadsheet.
Technique
Built with JavaScript.
Outcome
Functional solution delivering practical results.
Problem
This script automates the process of extracting a CSV file from an email, unzipping it, filtering rows based on required conditions, removing duplicates, and updating a Google Sheet with only the latest valid records. Includes flexible date parsing and daily refresh logic.
Technique
Built with JavaScript.
Outcome
Functional solution delivering practical results.
Machine Learning (Structured Data)
1Technical implementation and specialized solutions
Problem
End-to-end Titanic Survival Prediction project using Python (Machine Learning) and Excel (Business Analytics Dashboard). Includes EDA, data cleaning, Random Forest model, and interactive Excel visualizations.
Technique
Built with Jupyter Notebook.
Outcome
Functional solution delivering practical results.
SQL & Data Analysis
4Technical implementation and specialized solutions
Problem
This repository contains all my solved LeetCode problems. Each solution is automatically synced from LeetCode using LeetHub, and stored with clean, readable code.
Technique
Built with algorithms, datastructures, dsa.
Outcome
Functional solution delivering practical results.
ETL & Data Engineering
2Technical implementation and specialized solutions
Problem
This is a demo ETL project that takes data directly from a SQL database, processes it using Python, and pushes it into a visualization dashboard.
Technique
Built with Jupyter Notebook, automation, email.
Outcome
Functional solution delivering practical results.
Case Studies & Business Analytics
7Technical implementation and specialized solutions
Problem
The objective is to identify the constraint in the system and optimize advertising strategy to improve throughput.
Technique
Built with Jupyter Notebook, python, theory-of-constraints.
Outcome
Functional solution delivering practical results.
Problem
This project focuses on learning web scraping using Python by exploring different tools and when to use them, with simple examples that can be run step by step.
Technique
Built with Jupyter Notebook, playwright, requests-library-python.
Outcome
Functional solution delivering practical results.
Problem
This dataset contains restaurant information from Zomato, representing both online and offline food markets. It is used for learning data analysis by exploring details like locations, cuisines, ratings, and pricing in real-world restaurant businesses.
Technique
Built with Jupyter Notebook, analysis, data.
Outcome
Functional solution delivering practical results.
Problem
This project scrapes job listings from Naukri.com using Python to learn how web scraping can be applied to real job portals. It focuses on extracting basic details like job title, company name, location, and experience for learning purposes.
Technique
Built with Jupyter Notebook, job-search, naukri-com.
Outcome
Functional solution delivering practical results.
Problem
This project scrapes movie details from IMDb using Python to understand how web scraping works in real-world scenarios. It is built for learning and focuses on collecting basic information like movie titles, ratings, and release details.
Technique
Built with Jupyter Notebook, imdb, imdb-webscrapping.
Outcome
Functional solution delivering practical results.
Problem
The project analyzes Uber’s trip data, focusing on ride duration, distance, fare, and time of day to uncover patterns that optimize service. Using Numpy, Pandas, Matplotlib, and Seaborn, it visualizes key trends like peak hours, seasonal variations, and city ride distribution.
Technique
Built with Jupyter Notebook.
Outcome
Functional solution delivering practical results.
Software / System Development
3Technical implementation and specialized solutions
Technical Proficiency
Data-driven architect specialized in transforming complex information into actionable insights through advanced analytics, automation, and scalable machine learning solutions.
Data & Analytics
Automation & ETL
Machine Learning
Natural Language Processing
Computer Vision
Deep Learning
CRM & Visualization
Software Development
Education
B.Sc Nursing
RGUHS
Secondary Education
TBSE
Primary Education
TBSE
Professional Certifications
A collection of certifications validating my expertise in data analysis, software development, and business strategy across various platforms.
SQL (Intermediate)
HackerRank • Dec 17, 2025
Professional Certificate in SQL and SQL for Data Analysis
Udemy • Nov 04, 2025
SQL (Basic)
HackerRank • Dec 04, 2025
Python for Data analysis
Udemy • Nov 04, 2025
Python (Basic)
HackerRank • Oct 10, 2025
Python For Data Science A-Z: EDA With Real Exercises
Udemy • Nov 18, 2024
Business Strategies Blueprint: Analyzing for Success
Udemy • Aug 27, 2024
Fundamental Course in Web Frameworks
Udemy • Nov 02, 2023
Practical HTML, CSS, JS: 10 Real-World Projects for Practice
Udemy • Nov 02, 2023
Let's Connect
Ready to discuss how data can drive your next operational breakthrough? Reach out via WhatsApp or social media.
Direct Call
Drop a mail to get the calling number
Privacy Protection: Phone number is obfuscated to prevent automated scraping. Verification required for professional inquiries.
Verify Identity
Enter the access code to reveal contact details. If you don't have one, please reach out via email first.