Anurag Mahadik

Anurag Mahadik

+•• ••••• •••••••••••@•••••.com

Inventory Systems & Analytics Manager · Pattern · 5.9 yrs

As a highly determined and logical professional, I am driven by a desire for mastery and independent problem-solving. With 7 years of experience in inventory systems and analytics, I thrive on autonomously optimizing complex processes and delivering pragmatic, data-driven solutions that enhance efficiency and performance.

  • Remote

Ask about Anurag

Skills

Claimed

InfluencingStrategic PlanningDecision MakingBusiness AcumenMarket ResearchProduct Development StrategyInformation ResearchData Unification and NormalizationAlgorithm Design & OptimisationData TransformationTask SchedulingWorkflow Design (Process Mapping)

Proof of Experience

Inventory Systems & Analytics Manager

Pattern · Apr 2026 – Present

  • Own and maintain a consolidated Inventory Management WBR reporting suite in Tableau spanning 7 report modules (DIO, OOS, Forecast Attainment, Sent to Stow Units, Excess, Low Inventory Fees, Ordering Method), covering 9+ regions and multiple marketplaces helping to make inventory management easy for global inventory and supply chain stakeholders.
  • Migrated legacy/manual data pipelines onto Apache Airflow, replacing [cron jobs/manual scripts/ad-hoc processes/DBT/Snowflake] with scheduled, monitored DAGS improving reliability and reducing manual intervention for daily inventory data refreshes across various source systems.
  • Maintaining and enhancing an automated purchase-order tool that determines optimal ordering method (item vs. listing level).
  • Resolved SQL join-fanout and aggregation errors in a ~19.8M-row dataset, preventing distorted KPIs across Excess Inventory ($700K+/vendor) and Low Inventory Fees ($10K+/vendor).
  • Support AWS infrastructure (CloudWatch, ECS, Glue, Lambda, S3) behind these pipelines, resolving large-scale Tableau Cloud extract failures to keep reporting reliable for teams.
Amazon

Business Intelligence Engineer

Amazon · Dec 2022 – Apr 2026

  • Spearheaded the configuration of a 256TB Amazon Redshift cluster and designed scalable ETL pipelines using AWS Redshift, Spectrum, Kinesis, Lambda, S3, Glue to provide seamless access to supply-chain data for automation & analytics, reports purpose.
  • Reducing the data access time by 90%.
  • Collaborated with 5 cross-functional teams to ensure accurate, real-time data pipelines for analytics, automation and business intelligence reports, improved automation performance by 70% and scaled analytics for the PAN India Business Team.
  • Automated 15 critical business reports, saved 120 man-hours per week.
  • Launched a Supply Chain Network Health Validation Tool, eliminates junk data and saves 250+ man-hours annually through process automation.
  • Optimized nationwide inventory forecasting, boosting sales 40%.
  • Designed and implemented a robust ETL pipeline leveraging AWS services (S3, Lambda, Redshift) to transform and migrate critical supply-chain data from JSON to Redshift tables.
  • This daily process optimized warehouse deployment strategies and enhanced supply-chain network efficiency, providing accurate, actionable insights to key stakeholders.
Arcon Techsolutions

Software Developer

Arcon Techsolutions · Aug 2021 – Nov 2022

  • Led the end-to-end development of two flagship products: Drut (data automation tool) Robotic Process Automation (RPA) tool using .NET Core (C#) and Python to automate manual, repetitive tasks across web and Windows platforms.

Software Developer

Atriina Technologies · Nov 2020 – Jul 2021

  • Engineered complex SQL queries delivered critical business insights for data-informed decisions for key stakeholders.
Atrina Technologies Pvt Ltd

SDE

Atrina Technologies Pvt Ltd · Nov 2020 – Jul 2021

Proof-of-Work

No completed sessions yet. Anything Anurag finishes shows up here with the evidence behind it.

Proof of Education

Bachelors, Information Technology

Mumbai University · 2016 — 2020

A Proof CV — one profile, kept current, with the proof attached. Back to the portal