Armaan Singh Ahluwalia

Supply Chain & Data Analyst | SAP ECC · S/4 HANA · IBP · SQL · Power BI | MBA Business Analytics, Illinois Tech | Healthcare & Finance

Bridgewater, New Jersey, United States

About

I’m a Business Analytics MBA who grew up in India, studied in Toronto, and now calls New Jersey home. It’s a path that taught me to adapt fast and think across contexts. I currently work with Biocon in Bridgewater, NJ on supply chain systems and data workflows, specifically SAP ECC, S/4 HANA, and IBP, and have previously worked across healthcare analytics and investment evaluation. My sweet spot is translating messy operational data into decisions that actually make sense to the people who have to act on them. I care about problems where data meets strategy: demand forecasting, process optimization, and pricing analysis. The kind of work where getting it right has real consequences.

Experience

  • Supply Chain & IT Analyst at Biocon
    Feb 2026 - Present · 5 mos

    • Generics Plant Workflow Creation: Created a 19-step end-to-end supply chain workflow for Biocon’s Cranbury, NJ generics facility by conducting an on-site tour and building a horizontal swimlane diagram in draw.io across 6 lanes that included the SCM team, the Warehouse Lead, Warehouse Operations, QA & QC, Production, and the SAP team, documenting inbound and outbound flows, and delivering the diagram to the CEO, CFO, and Global SAP Head for executive review. • Demand & Supply Planning (SAP IBP and ECC): Improved forecasting through SAP IBP and ECC by configuring forecasting using moving averages in SAP IBP, and helping set up ECC batch jobs to deliver forecast inputs to planning personnel, designing As-Is and future-state swim lane workflows in draw.io, and adding closed/open order visibility and 3-, 6-, and 12-month lookback options. • GtN & SG&A Reporting: Analyzed backend inputs and data logic of an existing Power BI finance dashboard displaying net figures and actuals vs. budget to enable GtN and SG&A reporting. • Pricing Conditions Reporting (SAP ECC): Developed SAP ECC sales order reports covering 4 pricing condition types: chargebacks, rebates, direct price, and WACC, to support commercial and finance teams. • Canada 3PL SAP Integration: Supported onboarding of a new Canadian 3PL partner by expediting GxP approvals and assisting with SAP ECC configuration to enable compliant logistics operations. • DSCSA Compliance (SAP ATTP): Supported implementation of dual-query functionality in SAP ATTP, enabling Biocon to validate serial number–GTIN combinations and retrieve full track-and-trace data to meet DSCSA customer and regulatory requirements. • Budget Management Enablement: Developed As-Is and To-Be swim lane diagrams and presentation decks to enable SAP budget management across North America and Europe, scheduling and facilitating alignment meetings with Finance, IT, and operations stakeholders.

  • Illinois Institute of Technology (6 mos)
    • Graduate Teaching Assistant
      Aug 2025 - Dec 2025 · 5 mos

      Teaching Assistant for the Course on Digital Transformation titled MBA 590-B88, taught by Professor Marian Cook

    • Peer Career Analyst
      Jul 2025 - Dec 2025 · 6 mos

      • Collected and analyzed post-graduation employment outcomes data for graduating classes to support institutional reporting and career planning insights. • Maintained and improved knowledge rate of graduates’ post-graduation plans by leveraging multiple data collection channels (surveys, direct outreach, university databases). • Ensured data integrity, accuracy, and confidentiality in reporting key employment statistics to stakeholders. • Collaborated with Career Services staff on data-driven projects to enhance student services and inform strategic initiatives. • Contributed to ongoing research and analysis to identify employment trends, gaps, and opportunities for program improvement.

  • Research Analyst at British Council
    Jul 2024 - Mar 2025 · 9 mos

    • Database Consolidation: Achieved $150K in annual savings by consolidating manual and fragmented digital databases into a centralized DB across 5 hospital branches using SQL. • Predictive Analytics & Healthcare: Led a 10-member team in predictive healthcare analytics, analyzing post-operative cardiovascular complications by using AI/ML Models such as ANNs, SVMs, and Decision Trees. • Process Improvement: Increased Patient Satisfaction Scores by 18% across 3 hospitals through better post-operative recording practices and improved standard of care by contributing to complication reduction. • Operational Efficiency: Improved operational efficiency by 30% by developing dynamic Tableau dashboards.

  • Consultant at 180 Degrees Consulting
    Sep 2022 - Apr 2023 · 8 mos

    • Market Research & Social Analytics: Increased website traffic by 42% for the North American Native Plant Society (NANPS) by identifying audience trends and conducting social media engagement analysis using Meta Business Suite. • Strategy & Implementation: Increased daily active users by over 50% and follower base by 3K by developing and implementing a go-to-market data-driven social media strategy, integrating Facebook, Instagram, and the society website. • Client Reporting: Delivered weekly strategic insights to client leadership, connecting engagement metrics to marketing ROI and donor outreach outcomes while enhancing expertise through industry workshops.

  • Private Equity Associate at Sierra Succession LLC
    Nov 2021 - Feb 2022 · 4 mos

    • Valuation & Modeling: Allocated $10M in SBA loans across HVAC and service businesses, deal size: $1.5–2M EBITDA, 8–12% CAGR, $250–400K CAPEX, 3.5–5.0× EV/EBITDA by supporting LBO modeling and forecasting for 160+ SMB portfolio evaluations. • Research & Acquisition Support: Contributed to the successful acquisition of an HVAC company by conducting due diligence. • Customer Outreach & Lead Generation: Generated 7 customer conversations through the outreach funnel, which led to 1 LBO, by qualifying over 150 leads from Salesforce CRM and Hunter.io. • Financial Analysis & Due Diligence: Worked on SBA loans, investment potential analysis, and advanced Excel and Bloomberg Terminal usage, directly working with the MD.