Turning Data into Meaningful Decisions.
Vaibhav
Porwal
Computer Science graduate passionate about transforming complex datasets into actionable business insights through Data Analytics, Business Intelligence and Artificial Intelligence. Experienced across DRDO, CRIS, GAIL India and enterprise-scale analytics projects with expertise in Python, SQL, Power BI and Machine Learning.
9.66
Final CGPA
5+
Professional Internships
3
IEEE Publications
15+
Analytics & Software Projects
Building solutions that transform data into business value.
I enjoy solving real-world business problems through analytics, visualization, machine learning and research. My experience spans government organizations, enterprise analytics and academic research with a focus on creating meaningful impact.
Computer Science Engineer with a passion for Data Analytics, Business Intelligence and Artificial Intelligence.
I am a B.Tech. graduate in Computer Science and Engineering from Gautam Buddha University with a final CGPA of 9.66/10. My interests lie in solving real-world business problems using data analytics, visualization, machine learning and automation.
Through internships at DRDO, CRIS, GAIL (India) Ltd., GAO Tek Inc. and Renoviselmech Infratech, I have worked on Python, SQL, Power BI, Excel and analytical dashboard development for large-scale datasets and enterprise reporting.
My research interests include Artificial Intelligence, Natural Language Processing, Business Intelligence and Data Engineering, with multiple publications in IEEE Xplore.
9.66
Final CGPA5
Internships3
IEEE Publications4
Major ProjectsAcademic Journey
Gautam Buddha University
B.Tech. Computer Science & Engineering
2022 – 2026
CGPA : 9.66 / 10
Semester I
9.04
Semester II
9.36
Semester III
9.48
Semester IV
10.00
Semester V
9.60
Semester VI
9.92
Semester VII
9.88
Semester VIII
10.00
My Professional Journey
Defence Research & Development Organisation (DRDO)
Paid Intern – Scientific Analysis Group (SAG)
Engineered Python and SQL data pipelines for preprocessing research datasets and structuring complex technical information for cross-functional decision-making.
Developed Power BI and Excel analytical dashboards to replace manual tracking, providing real-time visibility and automated workflows for performance metrics.
Centre for Railway Information Systems (CRIS)
Project Intern
Built Python preprocessing pipelines for 750,000+ records (82%+ integrity) and analyzed 66+ million km of data to reduce crew workload imbalance by 44%.
Designed a Star Schema model with 8 Power BI dashboards (30+ KPIs) and implemented clustering models to identify a 13.75% network capacity expansion.
GAIL (India) Ltd.
Vocational Trainee
Designed internal order and complaint systems for 10,000+ users and automated SQL ingestion of 393,000+ records, reducing manual reconciliation by 40%.
Built role-based financial dashboards and automated reporting via Excel Macros, defining key KPIs to enhance audit readiness and reduce turnaround time.
GAO Tek Inc.
Remote Intern
Automated SQL and Excel reporting pipelines to convert raw operational logs into structured datasets for global performance tracking.
Performed trend and variance analysis on global operations data to identify and resolve critical performance bottlenecks.
Renoviselmech Infratech
Student Intern
Developed responsive dashboards and data handling solutions using Excel and Power BI to improve workflow usability.
Implemented structured data ingestion methods and reporting tools to streamline internal operational workflows.
Featured Projects
A curated selection of analytics, business intelligence and software engineering projects demonstrating expertise in data engineering, dashboard development, automation and intelligent decision-making.
Weather-Driven Electricity Demand Analytics
Developed an end-to-end analytics platform integrating Python ETL pipelines, SQL and Power BI to process over 31,000 records, identify seasonal electricity demand patterns and deploy an interactive live dashboard for data-driven decision making.
Railway Crew Utilization Framework
Designed a comprehensive operational analytics framework using Python, SQL and Power BI to evaluate crew utilization, workload distribution and scheduling efficiency through KPI-driven dashboards and automated reporting.
Stakeholder Insights Dashboard
Developed a Tableau-based executive dashboard by integrating SQL and Excel datasets to deliver centralized KPI monitoring, automated reporting and strategic business performance insights.
Student Attendance Portal
Developed a centralized attendance management system featuring secure authentication, AJAX-powered CRUD operations and automated reporting for over 5,000 users, significantly reducing administrative effort.
Dietary Allowance Automation
Built an advanced Excel VBA automation solution to generate RDA reports, standardize food exchange lists and eliminate repetitive manual calculations through macros and data validation.
IEEE Xplore Publications
Peer-reviewed research contributions available on IEEE Xplore and indexed in Scopus, covering Data Analytics, Artificial Intelligence, Natural Language Processing and Power Systems Engineering.
3
Research Publications
IEEE
Xplore Digital Library
100%
Scopus Indexed
4
Research Domains
Indexed in Scopus
Granular Analysis of Weather-Influenced Electricity Demand in Indian States
Developed a machine learning-driven analytical framework for examining electricity demand across Indian states using large-scale weather variables and power datasets. The research identifies regional demand behaviour, seasonal trends and weather-driven consumption patterns to support data-informed energy planning and operational decision-making.
Indexed in Scopus
Automated Profile Parsing and Skill Matching Using Named Entity Recognition and Natural Language Processing Techniques
Developed an AI-driven recruitment framework that leverages Named Entity Recognition (NER) and Natural Language Processing (NLP) to automate profile parsing, identify candidate skills and improve intelligent resume matching for recruitment systems.
Indexed in Scopus
Analysis of Detailed-Phasor and Phasor-Phasor Model of Phase Shifting Transformer Using On-load Tap Changer
Investigated detailed-phasor and phasor-phasor modelling techniques for phase shifting transformers with on-load tap changers to analyse system behaviour, improve modelling accuracy and support reliable power system operation.
Technologies I Work With
Languages
Libraries
Computer Science
Data Analytics & Business Intelligence
Generative AI
Tools & Platforms
Let's Connect
I am always open to discussing Data Analytics, Business Intelligence, Artificial Intelligence, research collaborations, internships and full-time opportunities.
Get In Touch
Whether you have an opportunity, collaboration, research idea, or simply want to connect, feel free to reach out. I usually respond within 24 hours.
GitHub
Location
Greater Noida, Uttar Pradesh, India