Anurag Mahadik

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.

Experience

P

Inventory Systems & Analytics Manager

Pattern · Apr 2026 – Present

Not yet confirmed

• 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.

Business Intelligence Engineer

Amazon · Dec 2022 – Present

Not yet confirmed

Business Intelligence Engineer

Amazon · Dec 2022 – Apr 2026

Not yet confirmed

• 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.

SDE

ARCON · Aug 2021 – Nov 2022

Not yet confirmed

A

Software Developer

Arcon Techsolutions · Aug 2021 – Nov 2022

Not yet confirmed

• 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.

A

Software Developer

Atriina Technologies · Nov 2020 – Jul 2021

Not yet confirmed

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

SDE

Atrina Technologies Pvt Ltd · Nov 2020 – Jul 2021

Not yet confirmed