Narendra Kumar Shukla
Sql Server Developer
Indore,MP
Summary
Highly skilled SQL SERVER Developer with 6 years of experience in designing, developing, and optimizing database applications. Proficient in SQL SERVER and experienced in working with large-scale databases. Strong problem-solving abilities and a passion for delivering efficient and reliable solutions. Detail-oriented with a focus on data integrity and performance optimization.
Overview
11
11
years of professional experience
2
2
Languages
Work History
Application Development
Capgemini Technology Services India Limited
09.2022 - Current
- The project is being Support for the organization named Vodafone Spacetel Limited. This project is used for all the Retailers and Distributor of the company
- Handled a Team of 10 members.
- Response quickly to customer request for escalation and Solve the issue.
- Calculate prepaid and postpaid Pay-outs of Retailers and Dealers and automate it.
- Calculate Daily Achievement of Retailers.
- Calculate payout of all MP/CG Zone Vodafone Store's Employee as an achievement and of DSE (Direct sales Executive).
- To show all Retailer and Distributor of every month of Vodafone management. Also display active and inactive dealers till date.
- Managed weekly and monthly incident and problem management review meetings and provided metrics to executives.
- This helpful to maintain the good relations between organization and Retailers/Dealer i.e. which maintains the details information about particular customers, which makes the organization to grow faster. This automation contains Details of product online.
- Conducted training and provided technical assistance for qualified vendors/service providers and division staff.
- Technology used in project: Database - MS SQL SERVER 2019
- Code Base: Telecom
- Domain: Telecom
- Tools: SSMS, T-SQL
Build Mapper
Capgemini Technology Services India Limited
05.2021 - 08.2022
- This is US Based Project, This project is basically for gives up to data information on current local construction projects.
- Find the exact location, estimated stage of construction, contact information and more.
- Map allows locate every project and target specific area. Plan routes much more efficiently when making sales or giving quotes. Each new project includes status on the estimated stage of construction.
- Identifying and resolving technical issues of teams within the organization, and to external clients when required and assisting with systems integrations.
- Solve the issues as per requirements.
- Handling different Types of issues.
- Incident and Problem Management.
- Managing coordination at a local and international level where required.
- Technology used in project: Operating System - Windows
- Tools: MS SQL Server, T-SQL
- Code Base: Real State
- Domain: Real State
- Database: MS SQL Server 2019
GL-attestation Application
Sysfo Software Solutions Pvt. Ltd.
05.2015 - 08.2019
- Working on Application Development in SQL SERVER and DB2.
- Creating/Altering Stored Procedure for Application in SQL and DB2.
- Develop and maintain database structures, tables, views, and indexes to ensure data integrity and optimal performance.
- Write and optimize complex SQL queries to retrieve and analyze large datasets for reporting and business intelligence purposes.
- Design, implement, and troubleshoot stored procedures, triggers, and functions to support various application functionalities.
- Perform database tuning and optimization to enhance system performance and reduce query execution time.
- Conduct data analysis and data modeling to support database design decisions and business initiatives.
- Create and maintain technical documentation, including data dictionaries, schema diagrams, and standard operating procedures.
- Identifying and resolving technical issues of teams within the organization, and to external clients when required and assisting with systems integrations.
- Solve the issues as per requirements.
- Handling different Types of issues.
- Incident and Problem Management.
- Finding and resolving the issue in SQL server and DB2.
- Technology used in project: Operating System - Windows
- Tools: SSMS
- Domain: Banking
- Database: MS SQL Server 2019
Education
M.C.A. - Masters of Computer Applications
Laxmi Narayan College of Technology & Science
Bhopal, M.P.01.2012
BCA - Bachelor of Computer Application
Jawaharlal Nehru College of Technology
Rewa, M.P.01.2008
Higher Secondary - undefined
Board of Secondary Education M.P.
Bhopal, M.P.01.2005
High School - undefined
Board of Secondary Education M.P.
Bhopal, M.P.01.2002
Skills
- Experienced in T-SQL programming
- Microsoft SQL Server 2019
- Database query optimization
- Performance tuning
- Stored procedures
- Database design
- Advanced T-SQL
- Proficient in Microsoft SQL Server Management Studio
Major Achievement
Awarded as Two times Rising Star for outstanding Performer and Star Performer for the Month of July’16 and May’17 in Sysfo Circle office, Bhopal.
Domain Experience
- Have a Strong working Experience in Telecom Domain.
- Have a Strong working Experience in Banking Domain.
Timeline
Application Development
Capgemini Technology Services India Limited
09.2022 - Current
Build Mapper
Capgemini Technology Services India Limited
05.2021 - 08.2022
GL-attestation Application
Sysfo Software Solutions Pvt. Ltd.
05.2015 - 08.2019
BCA - Bachelor of Computer Application
Jawaharlal Nehru College of Technology
Higher Secondary - undefined
Board of Secondary Education M.P.
High School - undefined
Board of Secondary Education M.P.
M.C.A. - Masters of Computer Applications
Laxmi Narayan College of Technology & Science