Sanket Kale

Project 1: Samarth Portal – SCNC (Supply Chain Nerve Center)

• Led a 6-member backend team to build and scale enterprise RESTful APIs using Python and Flask.
• Developed 20+ production APIs supporting supply chain planning and analytics.
• Improved API performance by 50–65% using Redis caching, SQL query optimization, and reduced database round-trips.
• Reduced database load by ~40% by caching high-frequency endpoints using Redis (cache-aside pattern, TTL, cache invalidation).
• Designed modular Flask architecture with reusable service layers, improving maintainability by ~30%.
• Supported thousands of daily API requests with low latency and high availability.
• Worked with MySQL and Azure SQL Server, optimizing complex joins, aggregations, and transactional queries.
• Deployed backend services on Azure App Services, managing secrets via Azure Key Vault.
• Implemented CI/CD pipelines, reducing deployment time by ~60%.
• Built centralized logging, monitoring, and exception handling to reduce production incidents by ~40%.

Project 2: Fin HRM Treasury Automation (Finance Domain)

• Delivered four finance and treasury automation projects, reducing manual effort by approximately 80%.
• Built Python-based automation solutions for Excel-heavy finance workflows.
• Automated reconciliation and reporting using win32com, openpyxl, and pandas, reducing processing time from hours to minutes.
• Integrated automation pipelines with SharePoint for secure file handling.
• Implemented Azure Function Apps for serverless execution and Azure Logic Apps for workflow orchestration and notifications.
• Used Azure Blob Storage for secure document storage.
• Executed COM-based Excel automation on Azure Virtual Machines.
• Implemented robust logging, retries, and exception handling for audit and compliance readiness.

Tech Stack: Python, Flask, REST APIs, Redis, MySQL, Azure SQL Server, Azure App Services, Azure Key Vault, CI/CD, pandas, win32com, openpyxl, Excel Automation, SharePoint, Azure Functions, Azure Logic Apps, Azure Blob Storage, Azure Virtual Machine

Project: EBI Data's Framework

• Developing Python scripts and various APIs to automate the
  Extract, Transform, and Load (ETL) processes. Working with major ETL tools such as Informatica and Streamlets.
• Generated data pipelines for Informatica and DB-only ETL using the CICD automation framework.
• Successfully handled programming tasks and maintained the
  validation modules with a high success rate during product update deployment.
• Implemented RESTful APIs to enable smooth communication between front-end and back-end systems.
• Conducted code reviews, debugging, and troubleshooting to
  ensure software quality.
• Worked in an Agile environment, participating in daily stand-ups
  and sprint planning meetings.