Lakshay MunjalData engineering · Analytics · BI
View Resume
Menu
View Resume

Data systems · finance · operations

Lakshay Munjal

Data Engineer | Data Analyst | Business Intelligence

I build reliable data workflows and turn complex financial and operational data into practical insight.

Explore projects View Resume GitHub
Portrait of Lakshay Munjal wearing a navy sweater over a light blue shirt

Current work

Practical analytics for complex operations.

My work spans data engineering, financial and operational analytics, and business intelligence, connecting reliable data workflows to useful decisions.

Explore my experience

Selected work

Projects

Financial data engineering alongside real-world transit and mobility analytics.

01Financial data engineeringIn progress

Financial Market Data Engineering Platform

A market-data platform in progress, designed around repeatable ingestion and analytics from financial APIs.

Planned architecture

Market APIs → Raw data → Python ingestion → Airflow → PostgreSQL → Analytics

Planned stack direction

  • Python
  • SQL
  • PostgreSQL
  • Pandas / Polars
  • Airflow
  • Docker
  • GitHub Actions
02Financial analyticsIn progress

Banking Transactions & Revenue Analytics

Transaction performance analysis across approximately 6.36 million synthetic PaySim records, including approval and decline rates, simulated fee revenue, and reconciliation controls.

Planned architecture

Raw transactions → Bronze → Silver / PySpark → Quality & reconciliation → Gold → Databricks SQL / Power BI

Project focus

  • PaySim · ~6.36M records
  • Financial KPIs
  • Data quality
  • Reconciliation
03Transit operationsCompleted

Green Line Operations Intelligence

Operational analysis of the MBTA Green Line using official GTFS data, Python, SQL, and Tableau.

The project focuses on service performance measures such as headways, schedule adherence, and operational KPIs.

Tools & focus

  • Official MBTA GTFS
  • Python
  • SQL
  • Tableau
View repository View Tableau dashboard
04Mobility analyticsCompleted

NYC Taxi Trip Analytics

Demand and revenue analysis across more than two million NYC Yellow Taxi records using SQL and Power BI.

Analysis covers high-traffic zones, hourly trip patterns, payment types, trip distance, and revenue.

Tools & focus

  • 2M+ taxi records
  • SQL
  • Power BI
  • Demand & revenue
View repository

Experience

Data work with real operational context.

Financial reporting, operational data, and software engineering experience.

  1. January 2026 – Present

    MTA Capital Programs

    Technical Analyst

    Current

    Modernizing financial and capital-program reporting across Capital Revolving Funds (CRF), funding, expenses, balances, divisions, and projects.

    • Consolidated and standardized historical CRF tracking data across funding, expenses, balances, divisions, and projects.
    • Built Power BI reporting and Power Apps / Power Automate workflows, reducing manual reporting effort by approximately 10 hours per week.
    • Connected Oracle ERP data through Azure Data Lake to Power BI, using SQL, Excel / Power Query, Tableau, and DAX for variance analysis, validation, and reconciled reporting.
  2. September 2025 – January 2026

    EV Buddy

    Software Engineer

    Built iOS application and backend capabilities for EV charger discovery, booking, and payments.

    • Developed SwiftUI experiences, REST API integrations, backend APIs, and data models on Azure.
    • Worked on application logging, analytics tracking, caching, and recommendation / anomaly-related functionality.
  3. January 2025 – September 2025

    MTA

    Data Engineer

    Built Python and SQL ETL workflows for operational datasets and reporting across 300+ subway stations.

    • Worked with Azure Data Lake, Salesforce, and Hexagon EAM data, adding validation and quality checks.
    • Used Airflow, DBeaver, GitHub, Azure DevOps, and Tableau; reduced manual reporting effort by approximately 15 hours per week.
  4. January 2023 – August 2023

    Qdexi Global Solutions

    Junior Developer

    Prepared Salesforce, marketing, and operational data and built Power BI reporting for 10+ clients.

    • Used Python and Alteryx for data preparation and ETL.
  5. May 2022 – November 2022

    SRTMS

    Software Developer – FTI

    Analyzed GPS and telemetry datasets across 120+ vehicles to monitor fleet activity, route efficiency, logistics KPIs, and operational exceptions.

    • Supported data validation, requirements discussions, and QA activities to improve reporting accuracy and operational decision-making.
  6. July 2021 – October 2021

    SRTMS

    Software Engineer – FTI

    Developed SQL-based data processing solutions to transform operational and financial records for business reporting.

    • Built reporting tools and performed financial data validation and reconciliation to improve revenue and operational reporting accuracy.

Technical toolkit

Skills built around useful data.

Tools used across data engineering, BI, enterprise platforms, and automation.

01

Data Engineering

Python · SQL · ETL · Apache Airflow · Databricks · PySpark · Delta Lake · PostgreSQL

02

Analytics & BI

Power BI · Tableau · DAX · Excel · Power Query

03

Cloud & Data Platforms

Azure · Azure Data Lake · Oracle Cloud Infrastructure · Snowflake

04

Databases & Enterprise Systems

Oracle ERP · Oracle Hyperion · Salesforce · SQL databases

05

Development & DevOps

Git · GitHub · Azure DevOps · Docker · REST APIs

06

Automation

Power Apps · Power Automate

Education

Foundations in computing.

May 2025

MS in Computer Science

New Jersey Institute of Technology

July 2023

BTech in Information Technology

Guru Gobind Singh Indraprastha University

Contact

Let’s make the data more useful.

For data engineering, analytics, BI, or reporting modernization opportunities, get in touch.

lakshaymunjaldev@gmail.com
LinkedIn GitHub

Send a message

The form sends directly to my portfolio contact endpoint. Email is also available above.

Your message will be sent to my portfolio inbox.