# Promit Bhattacharya > Workflow Orchestration/Data Center Automation Location: San Francisco Bay Area, United States Profile: https://flows.cv/promitbhattacharya As a Staff Software Engineer at Snowflake with over four years of experience, I specialize in deployment orchestration and touch-free automation. My expertise includes leveraging custom orchestration tools to streamline the deployment of the Snowflake monolith and developing cmd2-based command-line tools for executing SQL commands across multiple instances. With a background in software design and object-oriented programming, I have consistently contributed to efficient process automation and collaborative problem-solving within cross-functional teams. My work reflects a commitment to creating scalable, innovative solutions to optimize workflows and enhance system reliability. ## Work Experience ### Staff Software Engineer @ Snowflake Jan 2022 – Present | San Francisco Bay Area - deployment orchestration for Snowflake monolith using custom orchestration tools - touch free automation to auto-deploy in release testing farm - developed cmd2 based command line tool to allow execution of SQL commands across multiple snowflake instances ### Consulting Member Of Technical Staff @ Oracle Jan 2021 – Jan 2022 | Redwood City, California, United States ### Principal Member Of Technical Staff @ Oracle Jan 2016 – Jan 2020 | Redwood City, California, United States  Developed a precheck framework using Chef Inspec  Developed an os patching script that does online ksplice based patching on a monthly cadence  Designed and implemented custom classes to provide in Ruby and Python to allow structured access to the db host properties required (code dynamically discovers the attributes it needs and has a caching layer)  Designed and implemented a service to trigger database patching on specific preconditions  Designed and implemented a service to monitor workflow execution and notify appropriate team via PagerDuty alerts when user intervention is required  Designed and implemented module to gracefully drain workload from databases  Worked with application monitoring team to automate silencing monitoring system during maintenance  Designed and developed a command line tool to interact with an orchestration server (java-based application), run specific prechecks to validate user inputs on orchestration server and/or node and trigger endpoints to start and monitor the workflow.  Developed a heartbeat mechanism between the orchestrator and modules executing on remote hosts to detect any unexpected crash or failure allowing quicker mitigation  Led a team of 2 developers in designing and delivering database configuration management tool to allow t-shirt sizing of fusion pods  Worked closely with an offshore team enhancing the inhouse orchestration tool to make it more generic and configuration driven  Worked on provisioning script which are triggered on database side to provision the application  Developed common library class in ruby to allow programs to do check pointing and execution metric collection  Build self-contained python + Openssl to bootstrap python3 on hosts without touching system python (and have low dependency)  PoC to use ansible playbooks to run workflow with resume capability ### Senior Consultant @ Capgemini Jan 2015 – Jan 2016 | San Jose, California, United States ### Senior Consultant - Workflow automation for CI/CD pipeline provisioning @ Capgemini Jan 2012 – Jan 2015 | Bangalore Urban, Karnataka, India  Developed code to integrate with inhouse service catalog (Cisco Estore) to allow users to request code repository, artifact storage or deployment pipeline based on templates from a self-service portal  Developed tool to migrate CVS/PVCS/SVN/MKS code repository into a new standardized SVN repo along with revision history  Developed automation for creating private or public artifact storage repository in JFrog Artifactory  Developed workflow provisioning code to create pipelines in IBM uDeploy/uRelease to allow touch free continuous deployment  Owned administration of CollabNet SVN, JFrog Artficatory (including security audits, upgrades) and worked closely with a peer team on administration IBM uDeploy and IBM uRelease production servers. ### Offshore Tech Lead - Data Feed Processing @ Ibm Pvt India Limited Jan 2010 – Jan 2012 | Kolkata Team lead for a 10+ member team, which was responsible for parsing unstructured data from various data sources into a structured data format to be stored in database for ProQuest LLC client. Projects:  Worked extensively on regex-based parsing for data feeds using Perl  Worked on enhancement of the in-house data parsing pipeline which did end to end processing of data from vendors ### Software Engineer @ Cybage Software Jan 2006 – Jan 2009 | Pune, Maharashtra, India Team member working in a development team for a web application for Electronic Health Records for client Athenahealth Projects:  Regex based parsing of healthcare remittance form (ANSI 837) received from various medical insurance companies  Custom Report generation for medical practices who were our end consumers of the remittances processed.  Claims generation for sending out claims to insurance companies (ANSI 835) ## Education ### Bachelor of Engineering in Information Technology L.D. College of Engineering ### Higher Secondary Certificate (10+2) in Science The New Tulip International School - India ### Secondary School Certificate (10th Std.) in SSC Asia English School ## Contact & Social - LinkedIn: https://linkedin.com/in/promitb --- Source: https://flows.cv/promitbhattacharya JSON Resume: https://flows.cv/promitbhattacharya/resume.json Last updated: 2026-04-12