Shubham Gupta
Noida
Summary
Forward-thinking Manager with comprehensive experience implementing new processes and managing and planning innovations. Bringing outstanding problem-solving and abilities paired with in-depth knowledge of policies and procedures. Polished in evaluating employee performance and overseeing key projects with 12+ years of experience into Development, Project Management, Product Support, Implementation & Database management. Extensive work knowledge in development, improvement, and delivery. Handled large/multiple teams for production support and implementation under pressure.
Overview
13
13
years of professional experience
Work History
Manager
Gebbs Healthcare Services Pvt Ltd
Mumbai
2021.09 - Current
- To handle complete development, new implementations and live production issues for Gebbs owned audit applications used by Healthcare clients as per ITIL guidelines
- Managing multiple teams for support/development, testing and MSBI/Power BI reporting.
- Maintaining an efficient, streamlined support and development environment for the clients
- Resource management to ensure all the deliverables are completed within the given timeline and in the defined budget while maintaining the quality standards
- Taking requirements from Client/Onshore team, analyze them internally for technical feasibility and efforts estimation making sure it is delivered within specified time
- Handling critical/shows stoppers defects/CRs on priority and delivering them within specified time with minimum/no effect on business
- Tracking the progress of ongoing tasks/deliverables, ensuring no roadblocks
- Working on the cost/budgeting of deliverables, keeping track and share the report with the finance team and senior management
- Working on RCAs for critical defects, documenting everything systematically sharing it with all stake owners and team for further action plan
- Managing DB Servers, App servers and different client databases for performance, optimization and reports
- Handling application deployment and new releases
- Taking part in weekly/daily team meeting to discuss on going issues as well as to discuss upcoming releases/changes
- Involving in one-to-one discussion with each team member to identify any gaps/challenges and making sure team works smoothly and stress free
- Monitoring various application/C#/SQL Jobs, web services, SOAP
- Preparing weekly productivity and workload report and sharing with management to make it more and more efficient and to assist on further decisions
- Analyze the data based on requirements and prepare it for next level reporting
- Post integration, uploading the filtered/polished data into Power BI for visualization
- Preparing/deploying builds as per the new release, running sequential database queries
- Checking for errors on running jobs, look for root cause and solution within the given timeframe while keeping all the stake owners in loop
- Creating new SSRS packages to fetch huge data and managing/supporting ongoing too as per the requirement.
Module Lead
Clifford Chance Pvt Ltd
- Managing product support/dev team for all in house .net based applications for the users
- Monitoring the system 24
- 5, checking for any defect, and getting it solved it within the specified time
- Taking requirements from the stake owners/team, analyze them internally for technical feasibility and efforts estimation making sure it is delivered within specified time
- Managing multiple server instances for multiple applications and database for performance, execution, and other functionality issues
- Taking requirements from stake owners for any enhancements or defects, defining the scope and making sure the development is completed within the specified time
- Debugging the application, find bugs, and plan the resolution with the new release
- Extracting reports from multiple resources/platforms, integrate them into SQL Server
- Monitoring application jobs, performance, web services, SSIS and SSRS packages
- Analyzing the data based on requirements and prepare it for next level reporting
- Creating automation jobs in SQL Server for data extraction and reporting
- Post integration, uploading the filtered/polished data into Power BI for visualization
- Handling application deployment and new releases
- Preparing/deploying builds as per the new release, running sequential database queries
- Checking for errors on running jobs, look for root cause and solution within the given timeframe while keeping all the stake owners in loop
- Creating new SSRS packages to fetch huge data and managing/supporting ongoing too as per the requirement.
Consultant
Infogain India Pvt Ltd
- Managing Ops team for all in house .net based applications for the users and for ongoing development/integration/implementation activities
- Managing Server instances for multiple applications for performance, execution and other functionality issues
- Providing production support to various users using application based on Java, .net an Unix
- Creating new integration and transformation of data from various resources and deploying it on dev and Production environment post testing it thoroughly
- Creating new pipeline as per the requirement like for deployment and other automation tasks
- Monitoring pipelines running on daily/hourly basis, fixing issues if any pipeline encounters any
- Monitoring automation/schedulers/ jobs/services/ for multiple packages and responding to raised alerts/errors
- Providing correct and quick response to automated alerts and to clients, troubleshooting the problem and fixing it by making required changes
- Providing support to .net applications, SQL jobs, and other server-side operations
- Configuring alert for failed jobs/transactions and errors to investigate them, find root cause and fix them
- Monitoring backup failure and other database related alerts automated as well as user escalated, troubleshooting them and resolving within the given SLA
- Taking database backups and restore them as per the requirement or user instructions
- Managing the complete cycle from Bug reporting to release and deploy the solution while troubleshooting/discussing the issue/bug and find the root cause as well as the solution to the problem
- Analyzing the Bug, finding and developing the solution team to implement it and then deploy the same
- Taking and Understanding client requirement for enhancements, analyze them with the team while keeping all stakeholders, third parties informed
- Researching, discussing and implementing new technologies as per client requirements and to achieve solution more efficiently
- Prepare monthly and weekly status reports for the internal audits and to monitor the team performance and discuss the same with the top management
- Taking part in weekly sync up calls with clients along with BAs and all stake holders to discuss ongoing tasks/issues and support performance
- Creating and maintaining new environments as per different configuration to deploy and test the application.
Technical Consultant
IRIS Software, Noida
2017.08 - 2019.03
- Managing application support team for IRIS owned product for multiple clients as per the ITIL Guidelines
- Managing Server instances for multiple applications for performance, execution, and other functionality issues
- Providing configuration management expertise to all software development projects
- Managing the complete cycle from Bug reporting to troubleshooting/resolving the issue/bug and release and deploy the solution
- Creating new SSIS builds with various transformations and deploying it further on various server instances
- Working closely with the client on data Integration, Analysis and Reporting requirements, discussing them with the team and delivering the solutions to client
- Working on ad hoc requests from client for urgent requirement of data and reports and delivering them within specified time
- Creating new SSRS packages to fetch huge data and managing/supporting ongoing too as per customer requirement
- To ensure smooth functioning of the application while providing complete product related assistance and support to different clients for an IRIS owned product used in finance domain
- Understand and capture customer queries/requirements regarding the product, along with BA and Dev team and make sure successful implementation of the same
- Creating and maintaining new environments as per different configuration to deploy and test the application
- Work with the Dev team to implement the solution and then deploy the same in customer environment
- Restructuring the stored procedures, designing, coding and developing the same using the T_SQL Programming
- Understand client requirement for required enhancements, analyze them with the Dev team and while keeping all stakeholders, third parties informed
- Configuring and deploying the application in SharePoint
- Creating and maintaining new environments as per different configuration to deploy and test the application
- To set up SQL Server configuration settings for better server management
- Organize sync up call on daily basis with BAs and other teams to meet the SLAs and customer requirements
- Providing proper presentation to train users or operations staff on new implementations, producing additional documentation
- Ensure all the work is carried out and documented in accordance with required standards, methods and procedures
- Prepare monthly and weekly status reports for the internal audits and monitor the team performance and discuss the same with the upper management.
Senior Operations Engineer
RateGain Technologies, Noida
2015.09 - 2017.08
- Leading the Operations team for various RateGain owned products for multiple clients
- Monitoring, administrating, and troubleshooting live server instances, applications, Tasks, Jobs, web services and communication to ensure smooth functioning of the applications and database
- Providing 24
- 5 production support for all applications, webservices, jobs running on live server
- Administration and Maintenance of automation tasks
- Coordinating with the development, database administration, QA, and IT operations teams to ensure there are no resource conflicts
- Monitoring application jobs, SQL Jobs, web services
- Primary duties include building and deployment of the java applications onto different environments like dev, QA, UAT, and production
- Maintaining servers and management application that can use ServiceNow data to bring computers into a desired state by managing files, services or packages installed on physical or virtual machines
- Tuning databases, rebuilding the indexes at regular intervals for better performance
- Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs
- Building and maintaining servers/new environments as per different configuration to deploy run and test the applications
- Creating new SSRS packages as well as managing ongoing ones
- Preparing DR app servers as well as DB DR servers and make them online in case of disaster and make sure the smooth run
- Taking, transferring, and restoring backups of Databases whenever required
- Creating Jobs, checking the failed job alerts by SQL notification email, finding root cause and resolve it
- Monitoring the backup failure alerts, correcting the errors and rerun the backups
- Maintained high availability of database using Database Mirroring and Log Shipping
- Creating linked servers whenever required, migrate/import data from different data sources using import/export through DTS/SSIS and making sure smooth connectivity
- Performing root cause analysis once the problem is resolved and documenting it for further use
- Monitoring of databases performance associated with the applications in order to make smooth running
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
- Providing proper presentation to train users or operations staff on new implementations, producing additional documentation
- Ensure all the work is carried out and documented in accordance with required standards, methods and procedures
- Creating index maintenance/rebuild jobs to improve the performance of the database system and monitor them closely
- Understand client requirement for required enhancements, analyze them with the Dev team and while keeping all stakeholders, third parties informed
- Expertise in T-SQL writing stored procedures, triggers and functions
- Creating linked servers, making jobs and scheduled tasks as part of operations
- Document all work, producing reports on monthly basis, taking part in user meetings and assist them in current issues.
Senior Analyst
HCL Technologies Ltd, Noida
2012.05 - 2015.06
- Delivering production support to existing business users of the bank on various business applications mainly trading applications, investigating, and resolving application errors, data discrepancies and queries
- Daily monitor performance of the application hosted on IIS and different web hosts and servers and provide report to management
- Providing correct and quick response to automated alerts and to clients, troubleshooting the problem and fixing it by making required changes
- Provide correct responses to request for support by means of, for example making modifications to system parameters, developing workarounds or site-specific enhancements, reconfiguring systems, and changing operating procedures
- Escalating to level2/Developers when required and working closely with them in order to make the minor/major change in the code or configuration of the console application/UI as per the requirement of the user(s) while keeping them informed and updated
- Design, create, test and document new and amended patches, programs and solutions from supplied specifications in accordance with agreed standards
- Giving proper presentation to train users or operations staff, producing additional documentation
- Ensure all the work is carried out and documented in accordance with required standards, methods and procedures
- Preparing monthly report for the Share Data services group
- For the higher management
- Document all work, producing reports on daily basis, taking part in user meetings and assist them in current issues
- As DBA 1st Level: Monitoring of database performance, using DMVs, index creation, removal and modification
- Automation of daily tasks, create maintenance plans, jobs for automating daily tasks
- Troubleshooting performance and other memory issues using SQL Profiler, SQL Server Agent, Database Engine Tuning Advisor
- Monitoring backup failure and other database related alerts automated as well as user escalated, troubleshooting them and resolving within the given SLA
- Handling user creation and permission assignations based on level of database access and other database related queries through end user portal
- Rebuilding/Monitoring the indexes at regular intervals for better performance
- Making sure high availability of database using Replication and Database mirroring
- Creating SPs, jobs to monitor any sort of blocking on all production servers and monitor them on daily basis and update them whenever required
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
- Recovering database form backups in disasters
- Implementing Point-In-Time recovery if required
- Performing and monitoring replication, mirroring and other back up jobs on daily basis
- Handling user queries and requests performing copy only back up if required
- Database designing, creating databases, users and giving appropriate permissions.
Technical Specialist
iYOGI Technical Services, Gurgaon
2011.03 - 2012.03
- Providing application configuration and maintenance on IYOGI’s business facing system ‘imantra’
- Customizations to IYOGI’s in-house web sites, sharepoint and other applications/tools
- Receive and log requests/incidents for support from IT Team, other service delivery staff and/or users; investigate problems and other requests for support and determine appropriate actions to take
- Priorities requests in accordance with agreed criteria and with reference to the Business System Support Analyst
- Monitor apps performance, alerts, and bugs, troubleshoot them and resolve them within given SLA
- Monitor progress of requests for support and ensure users and other interested parties are kept informed
- Providing correct and quick response to automated alerts and to clients, troubleshooting the problem and fixing it by making required changes
- Maintaining systems by monitoring and correcting software defects
- Document all work, producing reports on daily basis, taking part in user meetings and assist them in current issues.
Education
BCA -
Jamia Hamdard University
01.2009
Intermediate -
01.2006
High school -
01.2004
Skills
- Project Management
- Team Leadership
- Customer Relationship Management (CRM)
- Workforce Management
- SQL Server Reporting Services
- Power BI
- SQL
- JavaScript
- C#
- MSSQL
- SharePoint
Accomplishments
- Successfully handled database and application server migration from SQL Server 2008R2/windows server 2008 to SQL Server 2014/windows server 2012 respectively.
- Have been a part of various significant KTs & Have imparted various trainings to the new joiners/current employees after successfully completing KTs related to different infrastructures in different GEOs, was also awarded for the same.
- Have received two monthly good performance awards in the Project in HCL.
Personal Information
- Father's Name: Mr. Suneel Kumar Gupta
- Date of Birth: 07/01/1988
- Marital Status: Single
Disclaimer
I hereby declare that the above mentioned information is correct and true to the best of my knowledge.
Languages
- Hindi
- English
Timeline
Manager
Gebbs Healthcare Services Pvt Ltd
2021.09 - Current
Technical Consultant
IRIS Software, Noida
2017.08 - 2019.03
Senior Operations Engineer
RateGain Technologies, Noida
2015.09 - 2017.08
Senior Analyst
HCL Technologies Ltd, Noida
2012.05 - 2015.06
Technical Specialist
iYOGI Technical Services, Gurgaon
2011.03 - 2012.03
Module Lead
Clifford Chance Pvt Ltd
Consultant
Infogain India Pvt Ltd
BCA -
Jamia Hamdard University
Intermediate -
High school -
Similar Profiles
Vamshi Krishna ThangalapallyVamshi Krishna Thangalapally
Accounts Receivable at Gebbs Healthcare Pvt LmtdAccounts Receivable at Gebbs Healthcare Pvt Lmtd
Renuka RavvaRenuka Ravva
Sr. Software Engineer at GeBBS Healthcare Solutions Pvt. LtdSr. Software Engineer at GeBBS Healthcare Solutions Pvt. Ltd
Prathamesh BhosalePrathamesh Bhosale
Assistant Manager at Gebbs Healthcare Solutions Pvt. Ltd.Assistant Manager at Gebbs Healthcare Solutions Pvt. Ltd.