Skip to content
View luckisalive's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report luckisalive

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.

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

Lalit Negi

BCA student focused on data analysis and machine learning. Currently preparing for data analysis, building toward ML engineering.

I work mostly in Python and SQL — cleaning real-world datasets, framing business questions before touching the data, and trying to make every chart or number answer a "so what."

Project

Data Analyst Job Market — EDA Cleaned and analyzed 58,775 verified U.S. data analyst job postings (Nov 2022–Nov 2025) after removing 3,178 duplicates from a raw set of 61,953.

  • SQL appears in 49.8% of postings — the single most in-demand skill
  • SQL + Python is the most common pairing (24% of postings)
  • Skill priority is role-dependent: DA postings rank SQL over Python; DS postings invert it (Python 70%+ vs. SQL ~53%)

NPCI UPI Analytics Pipeline Built an end-to-end analytics pipeline on India's UPI payment ecosystem using NPCI public data (Jan 2022–May 2026) — from raw Excel ingestion through Python ETL, SQL analysis, and a 4-page Tableau dashboard.

  • P2M overtook P2P in Aug 2022 and now drives 62%+ of transaction volume, though YoY growth between the two has converged from a 3x gap (2023) to near-parity (2026)
  • Market concentration (HHI) traced across 51 months using DOJ/FTC bands, with PhonePe holding #1 app share every single month
  • PSP-level approval rates traced to 3 banks (Yes Bank, Axis Bank, ICICI) responsible for ~84–90% of the reliability decline on both payer and payee sides — logged and cross-verified against live query output in a running DECISIONS.md audit trail

Stack

Python SQL Pandas Jupyter Tableau PowerBI Git

Contact

📧 lnegi0001@gmail.com

Pinned Loading

  1. Job_Market_Analysis Job_Market_Analysis Public

    Jupyter Notebook 1

  2. npci_upi_analytics npci_upi_analytics Public

    Built an end-to-end analytics pipeline on India's UPI payment ecosystem using NPCI public data (Jan 2022–May 2026) — from raw Excel ingestion through Python ETL, SQL analysis, and a 4-page Tableau …

    Python 1

  3. pdf-tool pdf-tool Public

    JavaScript 1