Promit Bhattacharya Email & Phone Number

San Leandro, Ca, Us

San Francisco Bay Area

- deployment orchestration for Snowflake monolith using custom orchestration tools 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

Redwood City, California, United States

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

San Jose, California, United States

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.

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

Pune, Maharashtra, India

Team member working in a development team for a web application for Electronic Health Records for client AthenahealthProjects: 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)

Bachelor Of Engineering, Information Technology

Higher Secondary Certificate (10+2), Science, Distinction

Secondary School Certificate (10Th Std.), Ssc, Distinction