๐Ÿ“„ My Resume

Summary

Operations and supply chain analyst with an MBA in Business Analytics and an engineering background in production systems. Built supplier sourcing, demand forecasting, and decision-support models for an early-stage grocery delivery venture, and currently runs billing, claims, and reimbursement audit analytics for a retail pharmacy. Works in SQL, advanced Excel and Power Query, Power BI, Tableau, and Python, with a consistent focus on finding where operational processes leak money.

Education

Masters of Business Administration (MBA)

Pace University, Lubin School of Business | December 2024

Concentration: Business Analytics (STEM) | GPA: 3.75

Bachelor of Engineering (B.E.)

Dwarkadas J Sanghvi College of Engineering, Mumbai | July 2022

Concentration: Production Engineering | GPA: 3.2

Technical Skills

  • Analytics and Reporting: Advanced Excel (Power Query, pivot models, lookups), SQL, Power BI, Tableau
  • Operations and Supply Chain: Demand forecasting, inventory and purchasing planning, supplier sourcing and evaluation, variance analysis, process documentation, audit and compliance reporting
  • Programming and Data: Python (pandas, NumPy, scikit-learn), R, MySQL, MongoDB

Professional Experience

Audit and Data Analyst

Novecks Pharmacy, North Bergen, NJ | January 2026 โ€“ Present

  • Audit prescription transactions, billing records, and insurance reimbursement reports, identifying discrepancies and documentation gaps for resolution
  • Build recurring Excel reports on prescription volume, billing activity, and reimbursement amounts used by management for operational review
  • Reconcile claim records against payer documentation requirements to support compliance with insurance and pharmacy regulations
  • Analyze operational data to flag workflow bottlenecks and reporting gaps, and document findings for management

Business Analyst

HL Gada LLC, New York, NY | February 2025 โ€“ January 2026

  • Researched 3 established grocery-delivery competitors to design the demand-forecasting and sourcing model for the launch
  • Built and maintained the supplier and vendor database across 20 vendor relationships, sourcing and comparing wholesalers to support assortment, cost, and lead-time decisions
  • Analyzed competitor order and pricing data to model buying patterns and forecast order volume by category
  • Produced market and competitive research on the NY/NJ Indian grocery delivery segment to size the opportunity before committing capital
  • Tracked post-launch performance against forecast; the venture did not reach viable unit economics and was wound down after eleven months

Operations Management Intern

Echaar Equipments Pvt. Ltd., Thane City, India | January 2022 โ€“ June 2022

  • Tracked raw material inventory, machine maintenance logs, and project timelines to identify the recurring causes of production schedule slippage
  • Recommended sequencing and resource-allocation changes to reduce factory downtime, validating feasibility directly with shop-floor staff
  • Built Excel dashboards that made production bottlenecks visible to the planning team
  • Authored an internal research paper on shop floor fume extraction and workplace safety conditions

Supply Chain and Operations Intern

Asian Synthetics Pvt Ltd, Mumbai, India | January 2019 - June 2019

  • Supported dispatch and finished-goods logistics at a textile manufacturing unit
  • Sourced alternative wholesalers for embroidery machine parts, reducing single-supplier dependency and shortening repair lead times
  • Implemented a digital record system replacing manual dispatch tracking

Projects

Customer Churn Prediction - Data Science

  • Built and compared logistic regression, random forest, and XGBoost classifiers on a customer dataset
  • Handled missing values, normalization, and feature engineering with pandas and NumPy
  • Selected the final model using cross-validated ROC-AUC

Car Company Database Project

  • Designed and normalized a relational schema consolidating vehicle data from over 10 sources, with defined table relationships and constraints
  • Wrote analytical SQL queries using joins, aggregations, and window functions to answer inventory and sales questions

Real-Time Data Pipeline and Analytics for E-commerce Platform

  • Built a real-time ingestion pipeline with Apache Kafka, streaming the UCI Online Retail dataset through a Kafka topic via a stream simulator
  • Aggregated the stream in Spark Structured Streaming, computing per-minute metrics by country
  • Landed results in Postgres and Parquet, with the full stack orchestrated locally via Docker Compose

Jainam Gala

Supply Chain & Operations Analyst | Forecasting, Vendor Analytics & Demand Planning | SQL ยท Power BI ยท Tableau | MBA Business Analytics + Production Engineering

Get In Touch

About Me

I find where operational processes leak money and build the reporting that makes the leak visible to the people who can fix it.

I've built demand forecasts and vendor analytics for an early-stage grocery-delivery venture, and I now run billing, claims, and reimbursement audit analytics for a pharmacy. My background is production engineering plus an MBA in Business Analytics.

I work in SQL, advanced Excel, Power BI, Tableau, and Python. Based in Jersey City, open to Supply Chain, Demand Planning, and Operations Analyst roles across the NY/NJ metro.

JG

Skills

๐Ÿ’ป

Programming Languages

Python, R, C++, SQL

๐Ÿ—„๏ธ

Databases

MySQL, MongoDB

๐Ÿ“Š

Data Analytics

Pandas, NumPy, Apache Spark, Apache Kafka

๐Ÿค–

Machine Learning

XGBoost, TensorFlow, PyTorch, Scikit-learn

๐Ÿ“ˆ

Visualization

Tableau, Power BI, Excel Dashboards

๐Ÿ› ๏ธ

Tools & Platforms

Excel (Advanced), Power Query, ETL Workflows

๐Ÿ’ฐ

Financial Analysis

Financial Modeling, Forecasting, Variance Analysis

๐Ÿ“‰

Business Intelligence

KPI Dashboards, Reporting, Data-Driven Insights

Projects

๐Ÿ”ง

Customer Churn Prediction for Credit Card Company

Predicting customer attrition using machine learning.

View Project โ†’
๐Ÿš—

Vehicle Data Warehouse

Advanced SQL analytics on integrated vehicle data with complex queries, window functions, and star schema design.

View Project โ†’
๐ŸŒ

Real-Time E-Commerce Analytics Pipeline

Real-Time Retail Data Pipeline with Kafka & Spark

View Project โ†’

Get In Touch

I'm always open to new opportunities and collaborations. Feel free to reach out!