Subodh Pandey

Working on development and maintenance of predictive analytics models specifically in Insurance domain. Tech Stack of ML development is Jupyter Notebook & Rstudio. Published a White Paper for "Role of Big data analytics in Insurance ". Delivered various POCs for automation of ML programs like Integrating Rstudio with Jenkins etc. Awarded with "exceptional Changemakers at GlobalLogic".

Worked as R&D engineer for World's prominent INSURETECH leaders. Won the 14th edition of 30HACKS, leader of team Mavericks. Working on Insurance projects on various technologies like Artificial intelligence & Machine learning.

Apart from daily DBA activities, worked on Azure PaAS. Engaged in implementation of continuous integration to achieve automated deployments of database changes in application releases through Jenkins, REDGATE dlm automation and octopus deploy. Worked on different version controls like svn, mercurial etc. Implementing knowledge of query optimization and suggesting developers to write optimized T SQL code and procedures. Working on migration of on premise databases to Azure PaAS.

Apart from daily DBA activities, worked on Azure PaAS. Engaged in implementation of continuous integration to achieve automated deployments of database changes in application releases through Jenkins, REDGATE dlm automation and octopus deploy. Worked on different version controls like svn, mercurial etc. Implementing knowledge of query optimization and suggesting developers to write optimized T SQL code and procedures. Working on migration of on premise databases to Azure PaAS.

Worked on ISM (Ticketing Tool) performing ITIL operations including Incidents, Service requests, Change operations, Data fix requests. Performed Database Refrshes, Table refreshes, with a strong knowledge of retaining permissions of logins and users at database & server level. Handled Major incidents & resolving them in defined SLA, also sometimes involved Client calls. Involved in Monitoring and Configuring DB maintenance Jobs on Autosys and SQL Agent. Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention. Worked on backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication. Worked on troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Took Experience in Performance Tuning, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Worked on ISM (Ticketing Tool) performing ITIL operations including Incidents, Service requests, Change operations, Data fix requests. Performed Database Refrshes, Table refreshes, with a strong knowledge of retaining permissions of logins and users at database & server level. Handled Major incidents & resolving them in defined SLA, also sometimes involved Client calls. Involved in Monitoring and Configuring DB maintenance Jobs on Autosys and SQL Agent. Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention. Worked on backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication. Worked on troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Took Experience in Performance Tuning, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Developed Stored Procedures, Triggers, views etc in MS SQL for MIS reports in SAP B1 like Inventory Management, Order Processing System (Quotation to Dispatch), and Costing & Product price management, Accounts Receivables, General Ledgers, Fixed Asset & other modules using Crystal Reports for SAP B1. Gained Experience in Performance Tuning, Query Optimization, Worked on Optimizing stored Procedures to make them run efficiently. Worked on Database backups, Restoration & backup startegy. Worked on recovery models, database shrink operations, DBCC commands. Strong experience in Database Development and Administration in SQL Server (2005, 2008R2).