• 9+ year experience in Application Support with expertise in developing, monitoring, maintaining, improving, and upgrading systems and applications.
• Development and Deployment: Design database using RDBMS data model by creating and altering database objects in MSSSQL and Oracle. Created ETL solution using SQL Server Integration Services (SSIS). Create reports using SQL Server Reporting Services (SSRS) and Crystal reports. Design database using data modeling concepts. Deploy SSIS, and SSRS applications in production using a file system, Visual Studio, and SQL Server on Cloud (AWS & AZURE) and On-Premises environment (Windows Server). Deploy and configure ASP.Net project on Windows server using IIS and configure Database on Windows server.
• Monitor and Maintain: Monitored in-house developed dashboards and reports to check all tasks and processes are running properly. Monitored various reports to check application performance and data integrity. Checked application logs, SSIS catalog report, and SQL Agent job history to troubleshoot/debug the ASP.net application, Database, and ETL application to understand the issue. Perform analysis to find the root cause for the issue and raise a Jira ticket to report bugs and change requests. Report incidents and problems in service now and work for resolution.
• Improve and Upgrade: Worked as L3 support on raised Jira and Service Now tickets to provide resolution to improve and upgrade the application. Created and modified the existing stored procedure, views, function, T-SQL/PLSQL script, triggers, javascript, HTML, and CSS as per business logic and client requirement. Worked as a business analyst to understand the new requirement to gather the information and draft. Participated to improve the existing documents on SharePoint and confluence for system upgrades and work around for issues. Performed the GAP analysis to improve the application quality. Actively participated in software testing.
• Support and Implementation: Provide L2-L3 support as per SLA, and make inbound and outbound calls to fix tickets. Perform incident management, Problem management, change management, Bug fixing, troubleshooting, and code debugging. Perform UATs as required and ensure complete documentation as defined. practicing ITIL concepts. Configure XML files *.config, *.dtsConfig. Restart Windows services if required. Data migration using import and Export tools. Provide ASP.net support, SQL support, and ETL support using MSBI (SSIS, SSRS, SSAS). Discuss the problem with the customer via mail or on call. Provide training to the team and customer regards changes in the application. Gather requirements for the change request. Organize daily standup meets, Weekly meets, and review meets.