About

Somshubhra Roy is a Systems Engineer at Tata Consultancy Services with over 2 years of experience as an Azure Migration Developer. He has a proven track record of migrating legacy On-Prem applications to Azure cloud. Somshubhra is skilled in Java, SpringBoot framework, HTML Bootstrap, Oracle SQL, MS SQL, REST API, and Unix shell. He has excellent problem-solving skills and troubleshooting capabilities, and he is experienced in cloud server deployments and monitoring of applications. Somshubhra is familiar with cloud-native software development methodology (Agile) and tools for application development/deployment, including CI/CD (GitHub/Bitbucket). He is a Microsoft Azure Fundamental AZ900 Certified professional who is quick and focused on learning and can adapt to any situation as required. Currently, Somshubhra is working at TCS, where he has migrated several Java Web and Batch shell applications to Azure cloud for a leading USA pharmacy retail company. He has upgraded the applications to Java 11 from their lower version and migrated to tomcat 8.5 server from their existing server. He has also converted the existing build tool of the application to Gradle to create a WAR/JAR file of the application. Additionally, he has migrated (converted) all the Oracle SQL queries to T-SQL and changed the existing Oracle SQL Database connection to Microsoft Azure SQL Database through Service Principal. Somshubhra has also modified the batch scripts to load the huge data files into the database through Azure BCP and SQL Server command-line utilities by replacing the Oracle SQL Loader concept. He has deployed web applications in Azure App service and batch Jars, files in Batch VM through CI/CD pipeline in different environments (Dev, QA, and Prod). He has performed many unit and integration testing on the applications. The tools he has used in this project include Eclipse, Oracle Sqldeveloper, Microsoft SQL Server Management Studio, SoapUI, Tomcat Server, Bitbucket, WinSCP, PuTTY, Microsoft Excel, and Notepad++. Before joining TCS, Somshubhra worked as a Project Intern at TCS and developed a Banking Application from scratch with different Admin and Customer UI in the front-end using HTML Bootstrap, jQuery (Ajax). In the backend, he created different microservice APIs (User, Transaction, Passbook, etc.). Each microservice has its independent and different functionalities interacting with UI and DB. MySQL was used as a database platform, and Eureka was used as a load balancer