Skip to content
View gautamgpt311's full-sized avatar

Block or report gautamgpt311

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
gautamgpt311/README.md

Hi, I'm Gautam Gupta

Aeronautical Engineer | Data Analyst | SQL • Power BI • Excel

Aeronautical Engineering graduate from Hindustan Institute of Technology and Science (HITS), Chennai. I spent the last year building hands-on skills in data analytics — designing SQL databases, writing business-driven queries, and creating Power BI dashboards focused on airline operations and MRO.

Currently seeking entry-level Data Analyst roles in aviation, aerospace, and IT sectors.

🛠️ Skills

Tool Skills
MySQL Joins, CTEs, Window Functions(RANK, ROW_NUMBER, LAG, LEAD), Subqueries, NULL Handling, CASE WHEN, LOAD DATA INFILE
Power BI DAX, CALCULATE, RANKX, Drill-through, Data Modelling, SUMX, VAR…RETURN, Power Query, What-if Parameters, Power BI Service
Excel Pivot Tables, VLOOKUP / XLOOKUP, Data Cleaning, Charts
Domain MRO Operations, Airline Performance Analysis, Fleet Management, Flight Delay Analysis, Aerodynamics

📂 Projects

Project Tools Description
AeroMRO SQL Analysis MySQL SQL analysis of MRO operations — fleet health, maintenance TAT, technician performance, inventory risk across a custom 9-table database
AeroMRO Power BI Dashboard Power BI Interactive dashboard built on the AeroMRO MySQL database with advanced DAX and drill-through
US Flight Delays SQL Analysis MySQL Analyzing 5.8M US domestic flights to uncover delay patterns, cancellation causes and airline performance
US Flight Delays Power BI Dashboard Power BI Interactive dashboard analyzing 5.8M flight records — airline performance, route analysis, cancellation patterns
Indian Airlines Price Analysis MySQL Analyzing 300K Indian airline ticket records to uncover pricing patterns, booking trends and route economics
Supply Chain SQL Analysis MySQL Analyzing 180K global supply chain orders to identify delivery failures, profit leakage and suspected fraud patterns using MySQL

📄 Research & Publication

Numerical Analysis of Aerodynamic Performance of Winglets with Different Cant Angles

  • Published on Springer (2025)
  • Presented at 2nd International Conference on Smart Sustainable Materials and Technologies (ICSSMT 2024)
  • Designed multiple winglet models in SolidWorks, performed CFD simulations in ANSYS Fluent, analyzed Lift/Drag coefficients across cant angle variations

📬 Connect

Pinned Loading

  1. aeromro-sql-analysis aeromro-sql-analysis Public

    Analyzing aircraft MRO operations across 9 tables — fleet health, maintenance TAT, technician compliance, and inventory risk using MySQL

  2. flight-delays-sql-analysis flight-delays-sql-analysis Public

    Analyzing 5.8M US domestic flights to uncover delay patterns, cancellation causes and airline performance using MySQL

  3. aeromro-analytics-powerbi-dashboard aeromro-analytics-powerbi-dashboard Public

    Interactive Power BI dashboard analyzing MRO operations — fleet health, maintenance TAT, technician performance, inventory risk and vendor procurement built on a 9-table MySQL database.

  4. flight-delays-powerbi-dashboard flight-delays-powerbi-dashboard Public

    Interactive Power BI dashboard analyzing 5.8M US flight delays — airline performance, route analysis and cancellation patterns.