Krunal Patel

Krunal Patel

Software Engineer | Business Intelligence and Datawarehousing

Followers of Krunal Patel1000 followers
location of Krunal PatelBengaluru, Karnataka, India

Connect with Krunal Patel to Send Message

Connect

Connect with Krunal Patel to Send Message

Connect
  • Timeline

  • About me

    .

  • Education

    • Dr. B R Ambedkar National Institute of Technology, Jalandhar ( PUNJAB)

      2006 - 2010
      B.Tech
    • Indian Institute of Management, Ranchi

      2013 - 2015
      PGDM
  • Experience

    • Fiserv

      Jun 2010 - Jun 2013
      Software Engineer | Business Intelligence and Datawarehousing
    • BD

      Jul 2015 - Dec 2016
      ASM | Management Trainee Program
    • Mu Sigma Inc.

      Jan 2017 - Feb 2018
      Apprentice Leader | Retail Analytics
    • Infosys

      Mar 2018 - Oct 2019
      Lead Analyst | Supply Chain Analytics
    • Titan Company Limited

      Oct 2019 - Oct 2021
      Analytics Lead | Retail Analytics
    • Amazon Web Services (AWS)

      Nov 2021 - now
      Data Engineer | Supply Chain Analytics

      • Developed replenishment-planner tool - using AWS Lambda for processing, Step-Function for orchestration and Event-Bridge for scheduling - catering to a new complex supply chain process for the US region which allocates requirement across data-centers from inventory present at multiple hub types and provides-output to multiple systems automatically for order generation.• Automated and integrated refurbished-spares planning process in regular replenishment cycle along with providing visibility for fulfillment via dashboard. Includes complex processes like:- Disaggregating demand based on part-hierarchy and vendors- Translating it to orderable parts based on available inventory - Preparing multiple order files based on sourcing hubs• Developed a full-stack web-application using AWS using Lambda, API Gateway, S3 and React to enable, extraction and display of information from hundreds of ETL jobs at the click of a button• Automated complex MRP process to provide the expected units that the vendors need to keep to satisfy spares demand for next 6 months• Developing and maintaining Python scripts and ETL pipelines to automate spare supply-chain processes like planning, ordering and product-life-cycle management for 1000s of parts for data-centres across the globe• Initiated, developed and evangelized self-serve Python utility to check file-format before its ingestion in automated processes which is used across teams and converted it to Lambda which is triggered at S3 events• Implementing secure cloud-infra for small web-apps and developed and maintained CI/CD pipelines.• Trained team to use Airflow for orchestrationTech: Python, Redshift, SQL, React, AWS services (Lambda, Step-function, Api-gateway, S3, SNS, Event-Bridge, Step-Function), Tableau, ETL tools, Airflow Show less

  • Licenses & Certifications

    • AWS Certified Cloud Practitioner

      Amazon Web Services Training and Certification
      Nov 2022
      View certificate certificate
    • Oracle Database SQL Certified Expert

      Oracle
      Jan 2012