Apr 2022 – Feb 2024 · 1 yr 10 mos

• Developed and automated end-to-end Auto Purchase Order construct, saving 8 man-hrs / day.
• Build a Time series Forecasting Model using Python for placing Purchase orders, Improved PO cov. to 95%
• Enabled leadership and sourcing with PO adherence trends daily, weekly and monthly trends and drive daily RCA increasing adherence metrics to 80% from 60%.
• Automated an Inter-warhouse inventory transfer model(IWIT) model, Saving 3 Man-hrs/day
• Developed dashboards for stakeholders across org, understanding of various Stats from Availability to Ageing Inventory to devised action plan to reduce stock out from 35% to 15%-20%.
• Developed attribution for slow moving inventory, revised recommendation ordering logic, potential saving of 1 cr avoiding additional build-up.
• Analyzed and build the inventory excellence tracker and drive unhealthy inventory reduction worth 5 cr.
• Coordinated with multiple stakeholders for DOD support on sourcing used cases, enabled additional 4% availability

Jun 2018 – Aug 2018 · 2 mos · San Francisco, California, United States

• Setup a log analytics system for a global Data Stream Network (DSN) and real-time
• infrastructure-as-a- service(IaaS) company to generate customer metrics for analytics and billing
• Developed a scalable implementation (non hadoop, Python-based solution) on top of AWS
• enabling dynamic and automatic resource allocation (AWS EC2 machines) resulting in
• lesser processing time
• The ETL pipeline is capable of processing large amount of log data(>100Gb) on per hour
• Used AWS spot instances to process the data which reduced the cost by more than 10 times
• Used AWS S3 bucket for storing source files and metadata files.
• The final processed data was loaded on AWS MySql RDS instance

Jan 2018 – Dec 2020 · 2 yrs 11 mos · Chicago, Illinois, United States

• Design and deploy data table structures, forms, reports, and queries
• Coordinate and work with Faculty/Staff to develop relational databases
• Implementing data dashboards to display data in differing formats
• Development and maintenance of the database stored procedures, views and functions for hosted
• Web applications
• Other duties involved at UIC were managing network infrastructure, IT Security

Jul 2015 – Jul 2017 · 2 yrs · India

• Responsible for development, testing and deployment of automation for various clients based
• out of North America, Asia Pacific and Africa for IBM.
• Developed Custom and Innovative solutions for network devices, UNIX servers and database.
• For a major Telecom company in Asia, implemented automation in 3 processes with which
• the number of required man hours reduced from 11,200 to 934 per process.
• Appreciation from Business Leaders for 'Buddy program' implementation within the team on
• enhancing capabilities of each individual ensuring 'Agile Scrum methodology' is followed
• within team.