Jan 2020 – Present · 6 yrs 5 mos · Kolkata, West Bengal, India · Hybrid

• Excellent knowledge and experience in monitoring Data flow from OLTP to OLAP. Proficient in writing SQL queries. Worked on SQL Development with SQL Server 2008, 2012, develop and maintain existing Production TSQL code and Windows batch
• Hands-on experience in writing SQL scripts using (Microsoft SQL Server) Involving Tables, views, joins, Subqueries, temporary tables, CTE and related objects.
• Directed client engagement through participation in requirements gathering, live events for software upgrades, engaging in resolution of data integration processes, and intervention on critical issues where needed.
• Worked on both Feature and Defect Jira, Delivered the model in sprint cycle, Reviewed the change
• through Grok. Worked on Remedy Tickets, Tasks and TAT of client remedy tasks have been reduced to 28 days with an average of 3 tasks per month.
• Developed Internal Tool for Client Dayend Monitoring using .NET and SQL Server.
• Worked on SAP Crystal Reports/custom reports and OLAP cubes using SQL Server Analysis Services (SSAS), SSIS packages for different Clients globally.
• Working on Data Warehousing tools. Need to fix any issue regarding this replication process like job failure, long running jobs and many more.
• To act as a center focal point for all departments during Severity 1 incident and coordinate between them to get the speedy result.