Skip to content
View Mohan-Lingamaneni's full-sized avatar
  • Dallas–Fort Worth, Texas

Block or report Mohan-Lingamaneni

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
Mohan-Lingamaneni/README.md

Hi, I'm Mohana Sai

I'm an Information Systems student at The University of Texas at Arlington, with a minor in Business Analytics. I started working on analytics projects because I wanted to understand what happens between receiving a raw dataset and presenting something a business team can actually use.

Most of the work here is built around practical questions: Which carrier is creating extra shipping costs? What causes flight delays? Which skills are showing up most often in analyst job postings? I use SQL, Python, Excel, Power BI, and Tableau to work through those questions.

I'm currently looking for data analyst, business analyst, and technology analyst internship and full-time opportunities.

Projects

This project uses U.S. Bureau of Transportation Statistics flight data to study airline, airport, route, and delay performance. I built a repeatable workflow for cleaning the flight records, checking data quality, creating a SQLite database, and answering operational questions with SQL.

What I worked on: operational KPIs, data validation, route analysis, delay causes, and SQL queries
Tools: Python, pandas, SQL, SQLite

Airline delay cause contribution chart Arrival delay rate by airline chart


I analyzed more than 24,000 analyst job postings to see which skills employers request, where analyst roles are concentrated, and how salaries differ across skills and locations. Python and pandas handle the data preparation, and the final results are presented in Tableau.

What I worked on: data cleaning, skill extraction, salary comparisons, location analysis, and dashboard design
Tools: Python, pandas, Tableau, Git

Analytics job market Tableau dashboard


A smaller project focused on a common shipping problem: the amount quoted by a carrier does not always match the final invoice. The analysis compares UPS and FedEx shipments, calculates invoice variance, flags possible overcharges, and summarizes delivery performance by carrier.

What I worked on: invoice matching, variance calculations, exception flags, and carrier comparisons
Tools: Python, pandas, CSV

Tools I Use

Analysis: Python, SQL, pandas, Excel
Visualization: Power BI, Tableau
Data and development: SQLite, Jupyter, Git, GitHub

Python SQL pandas Excel Power BI Tableau SQLite Git

What I'm Learning Next

My next project will move beyond a local CSV-to-dashboard workflow. I'm planning to use Azure for storage and orchestration, Snowflake for analytics, and an API as one of the data sources. The goal is to understand the full path from incoming data to a dashboard rather than adding cloud tools to a project just for the name.

Contact

I'm open to internship opportunities, project feedback, and conversations about analytics work.

mohanasai.lingamaneni@gmail.com

Pinned Loading

  1. airline-operations-intelligence airline-operations-intelligence Public

    U.S. airline operations analysis using Python and SQL to study delays, routes, airports, and carrier performance.

    Python

  2. analytics-internship-radar analytics-internship-radar Public

    Analysis of 24,000+ analyst job postings using Python and Tableau to compare skills, salaries, employers, and locations.

    Python

  3. Shipping-Intelligence-mini-project Shipping-Intelligence-mini-project Public

    Carrier invoice reconciliation in Python: compare quoted and billed costs, flag overcharges, and review delivery performance.

    Python