Jainam Gala

Open to roles in NY/NJ

Jainam Gala

Supply chain and operations analyst

I show an operations team where the money is going, then hand them a report they can use. Forecasts, vendor comparisons, and pharmacy audit analytics.

Email the role See the work
Now
Supply Chain & Audit Analyst, Novecks Pharmacy
Before
Supply Chain Analyst, grocery launch
Training
MBA, Business Analytics, Pace · 3.75
Tools
Excel, Power BI, SQL, PrimeRx, Python

01 — Experience

The reporting had a decision attached

Pharmacy procurement, reimbursement, and claims now. Supplier sourcing and a grocery launch before that.

North Bergen, NJ

Supply Chain & Audit Analyst

Novecks Pharmacy

  • Switched the return-credit vendor for expired and short-dated drugs and recovered $5K over 4 months, versus about $2K from the default vendor.
  • Built a Power BI report on 37,000+ PrimeRx prescriptions and found 29% sold below cost, then used that to target supplier renegotiation.
  • Cut procurement costs by $5K+ per month, recovered $45K in disputed claims across 5 payers, and replaced manual pulls with 8 recurring Excel dashboards.

New York, NY

Supply Chain Analyst

HL Gada LLC

  • Set procurement volumes by category from grocer, delivery, and community-survey data, and benchmarked supplier offers in Excel.
  • Managed a 20+ supplier database and sourced alternative wholesalers, cutting lead times by 3 weeks.
  • Showed that about $12K in annual profit worked out to about $4 an hour, and recommended winding the launch down.

02 — Selected work

The result is in the first line

A hiring manager should be able to see the number before opening the write-up.

01

Chip Warehousing and Shipping Optimization

$141,692 lower modeled warehouse cost. Built a seven-day plan for 9,215 orders within daily warehouse capacity, using Excel checks, Python automation and optimization.

  • 9,215 orders
  • Excel · Python
  • MILP · HiGHS
Read the case

02

Inventory and Sales Analytics

A relational schema for inventory data from more than 10 sources. Joins, aggregations, and window functions answer inventory and sales-volume questions.

  • MySQL
  • Star schema
  • Window functions
Read the case

03

Customer Churn Prediction for a Credit Card Company

87% ROC-AUC. Gradient boosting beat logistic regression and random forest on 10,000 credit-card customers, after cleaning and feature engineering in pandas and NumPy.

  • 87% ROC-AUC
  • 10,000 customers
  • Python · scikit-learn
Read the case

04

Real-Time E-Commerce Analytics Pipeline

Per-minute sales by country. Kafka took the UCI Online Retail stream, Spark aggregated it, and Postgres and Parquet stored it. The stack ran locally in Docker Compose.

  • Kafka · Spark
  • Postgres · Parquet
  • Docker Compose
Read the case

03 — Skills

What belongs on the requisition

Analytics

  • Advanced Excel
  • Power Query, pivots, lookups
  • Power BI
  • SQL
  • MySQL
  • Python (pandas)

Systems and tools

  • PrimeRx
  • Excel
  • PowerPoint

Operations

  • Demand forecasting
  • Supplier sourcing
  • Drug cost and reimbursement
  • Variance analysis
  • Audit and compliance reporting

04 — About

Shop floor first. Then the number that runs the operation.

I work on procurement cost, supplier sourcing, demand forecasting, and claims auditing. The current seat is a retail pharmacy. Before that, a grocery launch.

The through-line is production systems. The engineering degree was on the shop floor. The MBA was business analytics. The work since then is finding the number that changes a purchasing, scheduling, or reimbursement decision.

Based in Jersey City. Open to supply chain, demand planning, and operations analyst roles across the NY/NJ metro.

MBA, Business Analytics

Pace University, Lubin School of Business

GPA 3.75 · January 2023 – December 2024

B.E., Production Engineering

Dwarkadas J. Sanghvi College of Engineering, Mumbai

GPA 3.2 · August 2018 – July 2022

05 — Contact

If the seat is supply chain, demand planning, or operations, send it.

Email me
LinkedIn GitHub

Resume

Download PDF

Summary

Supply chain and operations analyst with an MBA in Business Analytics and a Production Engineering background. Experienced in procurement cost analysis, supplier sourcing, demand forecasting, and claims auditing across retail pharmacy and grocery operations. Builds Excel and Power BI reporting that helps owners and managers make cost and sourcing decisions. Skilled in advanced Excel, Power BI, SQL, and PrimeRx.

Jersey City, NJ · +1 551-343-0198 · galajainam21@gmail.com · linkedin.com/in/jainamgala21

Work experience

Supply Chain & Audit Analyst

Novecks Pharmacy | January 2026 – Present

  • Compared return-credit offers for expired and short-dated drugs and switched from the default vendor, recovering $5K over 4 months versus about $2K (2.5x)
  • Built a Power BI report comparing drug acquisition cost to reimbursement across 37,000+ PrimeRx prescriptions (about $10.6M revenue, 8 months); found 29% sold below cost ($133K lost), led by GLP-1 drugs (38% of losses), and used the findings to target supplier renegotiation on the highest-loss drugs
  • Cut procurement costs by $5K+ per month by negotiating supplier pricing and using wholesaler promotional offers
  • Recovered $45K in disputed claims across 5 payers by reconciling PrimeRx submissions with payer records
  • Built 8 recurring Excel dashboards (Power Query) on prescription volume and reimbursement, replacing manual data pulls for weekly management reviews
  • Audit claims across about 1,000 prescriptions per week; fixed documentation gaps that cut rework by 12%

Supply Chain Analyst

HL Gada LLC | February 2025 – January 2026

  • Gathered pricing and demand data from local grocers, delivery operators, and social media community surveys for a grocery launch
  • Used that data in Excel models to set procurement volumes by category and benchmark supplier offers
  • Managed a 20+ supplier database; sourced alternative wholesalers, cutting lead times by 3 weeks
  • Planned delivery routes by grouping orders by area and scheduling around peak traffic, saving about 2 hours per delivery day
  • Presented a PowerPoint analysis showing about $12K in annual profit worked out to about $4/hour across about 3,100 labor hours; recommended a wind-down

Skills

  • Analytics: Advanced Excel (Power Query, pivot models, lookups), Power BI, SQL, MySQL, Python (pandas, basic)
  • Systems and tools: PrimeRx, MS Office (Excel, PowerPoint)
  • Operations: Demand forecasting, supplier sourcing, drug cost and reimbursement analysis, variance analysis, audit and compliance reporting

Projects

Chip Warehousing & Shipping Optimization

Excel, Power Query, Python, HiGHS/MILP

  • Analyzed 9,215 orders across 19 warehouses (Brunel University dataset); identified a 1,450-order capacity shortfall at the main warehouse over seven days, with 82% of orders having no alternative eligible warehouse
  • Automated eligibility checks and built a MILP optimization model that assigned all 9,215 orders within daily capacity, reassigning 1,611 orders and cutting modeled warehouse costs by $141,692 (0.9%)
  • Validated the plan within 0.03% of the model’s minimum cost (solver runtime: 3.66 seconds); found only 48 spare order slots at the main warehouse across the week

Inventory & Sales Analytics — SQL Database Project

SQL

  • Designed a relational schema consolidating inventory data from 10+ sources; wrote analytical SQL (joins, aggregations, window functions) to answer inventory and sales-volume questions

Education

Master of Business Administration (MBA), Business Analytics

Pace University | January 2023 – December 2024 | GPA 3.75

Bachelor of Engineering (B.E.), Production Engineering

Dwarkadas J. Sanghvi College of Engineering | August 2018 – July 2022 | GPA 3.2