Sunil Kumar Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

• Monitored Strategies, Processes and Procedures to ensure Data Integrity, Optimized, and reduced Data Redundancy, High Availability, Security for all production and internal databases.• Conceived and developed indexes to reduce processing time from 60 minutes to 2 minutes in the first month of joining the team.• Utilized data-mapping procedures to gather all the necessary requirements, gaining 90% overall customer satisfaction.• Compiled scripts to automate weekly software updates, which helped to save 10+ programmer hours every month.• Led several successful 24x7 support to Production environment.• Designed and implemented robust database architectures to improve performance & security.• Ensured Data Recovery, Maintenance, and space requirements of physical databases.• Improved query performance by 30% by implementing Indexes, effective changes in Stored Procedures, UDFs, Triggers and Views/Indexed views.• Reorganized database structures as needed, automated procedures at regular intervals.• Created test plans and tested queries effectively to produce expected and bug free outputs.• Performed ETL on external data sources using OPENROWSET and OPENDATASOURCE.• Efficiently used SSMA (SQL Server Management Assistant) to import data from other data systems (e.g. Oracle, Access, MySQL, Excel) to MS SQL Server.• Implemented SSIS successfully to load the data between various sources to SQL Server.• Successfully implemented SQL Server Replication in MS SQL Server to deal with the failures.• Loaded large data sets into SQL Server using BULK INSERT from multiple data sources.• Developed 10+ impactful dashboards using Power Query, DAX, and Functions in Power BI.

Gurgaon, India

• Assessed business requirements and developed ETL solutions to migrate the data from different sources.• Efficiently used SSIS to automate the process and saved 20% efforts.• Implemented secure application models, including SSL and protection against SQL injection.• Achieved 25% improvement in overall system performance by fine-tuning critical parameters using SQL Server Profiler and Query execution plan.• Coordinated end-to-end implementation, monitoring, and refinement of projects. Achievements• Delivered a high-quality bug-free product ahead of project timelines, resulting in significant time and cost savings of up to 20% for the organization.• Received the esteemed Customer's Choice Award from the CEO during the company's annual ceremony, recognizing exceptional achievement and customer satisfaction.

Gurgaon, Haryana, India

• Conducted comprehensive unit testing and integration testing using NUnit for web and windows applications developed. Achievement• Commended with multiple spot awards for exceptional customer support across diverse geographical regions.

South Korea

• Spearheaded the development of a cutting-edge web application for the Korean Military, leveraging the latest .Net Framework.

Gurugram, Haryana, India

• Developed high quality web and windows applications using ASP.Net framework.

Master Of Computer Applications - Mca, Computer Science, A

Bachelor Of Commerce - Bcom, Accounting And Finance, A

Schooling, Accounting And Finance, A