Experience

• 

  Icici lombard

  Jun 2014 - Dec 2016

  Customer service manager(csm)

  * Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concern Department * Managing the Monthly, Weekly & Daily Report Creating in MS-Excel through in depth analysis and producing the actionable information* Gather information from various sources on a daily basis and create dynamic excel dashboards* Roll out different reports i.e. Efficiency, Collated Trackers, OPS Report, Work Flow Report,* Generating & maintaining day to day MIS Data and updating the management* Conduct quality assurance activities regarding data migration and folder permissions * Extensive usage of MS Excel (Aggregate function, Vlookup, Pivot table, UDF Macros)* Analyzed and tested systems. Provided on-site support and training for new users Show less

• 

  Primera medical technologies

  Dec 2016 - Aug 2017

  Mis exective

  • Handling SQL queries for data manipulation and retrieve on SQL server• Handling and accountable for maintaining database by entering, verifying and backup data• Provide timely and accurate financial inputs for new business clients• Ensure deliverables (WBR, MBR, QBR, MIS reports and Dashboard) are prepared to satisfy the project requirements cost and schedule• Handling Attrition, Head Count, Hiring, vintage reports and Staffing Reports for Global location• Outstanding presentation, reporting and communication skills• Using VBA Macros automate tasks and perform several reports• Knowledge transfer to the team for post-production support Show less

• 

  Cognizant

  Aug 2017 - now

  Senior associate

  Managing around 1500 servers and 5000 databases with highest size up to 10.0 TB. Providing day-to-day Support and Maintenance for SQL Server databases. Involved in Installation and configuration of MS SQL Server 2008, 2008 R2, 2012, 2014, 2016,2017 and 2019 in Windows environment. Involved in Database and Server Migration from SQL Server 2008R2 to 2016. Experience in Migration from On-Premises server to cloud (Azure and AWS) Hands-on experience on high availability solutions like Log Shipping, Database Mirroring,Replication and Always ON. Configuring and maintaining all types of Database Backups and Recovery operations. Configuring and monitoring SQL Jobs and Trouble shooting the Job Failures. Performing Database Maintenance Activities like rebuilding/reorganizing indexes and updatestatistics, checking database integrity and clean up history on regular intervals. Resolving Disk Space Management issues like TempDB contention, Data and log file space issues. Identifying and Resolving Blocking and Deadlock issues by using System Stored Procedures,DBCC, DMV’s, Activity Monitor and Profiler. Experience in usage of DBCC commands and DMV’s for troubleshooting. Identifying and Resolving fragmentation and performance issues. Daily Refreshing Database from Production to Dev/Test Environment. Enrolling users, controlling and monitoring User Access to the database, and maintaining systemsecurity. Experience in Cluster activities like failover and failback and basic troubleshooting activities inSQL 2012 and 2014 cluster environment. Involved in Patch upgradation in cluster environment Show less