Sumit Kumar Mishra Email & Phone Number

West Bengal, India

Kolkata, West Bengal, India

● Working as a Cloud Migration Engineer collect existing on-prem environment, analyze and design To-Be design with corresponding Cloud Native solution with efficient cost to service justification.● Worked on various Lambda function to perform 3rd party file transfer, custom script execution..● Worked on Setting up cloud watch alarms for lambda trigger.● Worked on Infrastructure as a code using Terraform for quick creation of lower environments whenever required, this save a cost of running 3 environments 24*7● Worked on Auto scaling group for Java based application hosting in AWS. ● Worked on various Azure Automation Account(Runbook) to run daily file transfer and execute a set of custom script on target VM.● Worked on Setting up environment with appropriate throughput configuration, disk alignment, memory allocation for SQL Server 2017 Always-on HA. Also migrated data from On-prem to cloud including DB jobs configurations.● Worked on Setting up environment with appropriate throughput configuration, disk alignment, memory allocation for SQL Server 2012 Stand Alone. Also migrated data from On-prem to cloud including DB jobs configurations. ● Worked on Setting up environment for SQL Server 2008 R2. Also migrated data from On-prem to cloud including DB jobs configurations. ● Working as Cloud Migration Engineer to design and develop azure based environment and optimize cost of Licenses – SQL License, Windows License on cores and also worked on Active directory to create updated users and monitor their access status.● Worked on VM Scale Set to migrate a critical legacy application also worked on MS deploy to control code version deployment for the same.Environment: - AWS, Lambda, Cloud Watch, Bitbucket, JIRA, Confluence, Microsoft .Net, Azure components, C#, JSON, IIS, Visual Studio 2017, MSSQL 2008 R2/2012, SQL Server 2017 Always-on HA, Active Directory, Bitbucket, JIRA, Confluence

Bangaon Area, India

Project – RioTinto, Seabury, Towergate, Post Office Ltd., Whirlpool, British Petroleum● Creating and Managing set of Lambda functions (using Python and Boto3) to collect details from EC2, Cloud Watch, Snapshot details of volumes.● Creating and Managing set of Lambda functions (using Python and Boto3) to use Run Command feature from System Manager.● Performance Monitoring of all the Instance’s using Cloud Watch.● Used System Manager to manage the Instances and export the health details.● Used lambda function to transfer the files from S3 to SFTP using paramiko.● Import the details collected (using Lambda function) csv to SQL DB using SSIS package and run a SQL job to update the corresponding tables.● Create a batch using C# to consume the RESTful Web service to create/resolve Incident in ServiceNow and schedule it by task scheduler.● Create SSRS parameterized report to show the Incident and their corresponding feature (viz. Server name, failure region etc.).● Created an exception portal for VM to excluded from server health check report.Environment: - Python, AWS EC2, Cloud Watch, SNS, System Manager, Lambda functions, Could Watch, Asp.Net, RESTful API MS SQL 2014, SSIS, SSRS.Project – AoWarwick (Accenture Internal)● Involved in analysis requirement, designing of architecture and coding of the functional modules● Design and implementation of the database (SQL and SharePoint)● Involved in coding and writing SQL queries ● Used Java Script validation for client-side validations.● Created variety of reports using SSRS using stored procedures including matrix report, parameter report, dashboard, charts, drill-down, drill- through, cascade parameterized report and deployed reports on the web server with SharePoint● Created variety of batch files to automate the different type of manual process.Environment: - Asp.Net, MS SQL 2014, SSRS, SharePoint, JavaScript.