Nand Kumar Singh Email and Phone Number

Technical Lead

Created new procedures, functions, triggers, packages,and modified existing codes, tables, views to implementBusiness Logic.Analyzing, Slowness issue reported by End user basedon various DB reports (AWR) and Explain Plan.Provide L3 support for reported issue.Attending Scrum Master Calls to understand businessrequirement and team meetings with Architect, andtesting teams to decide on Implementation of therequirement.Used Oracle XML DB features for generating(constructing) XML data from relational data in thedatabase.Working on daily-logged issues by the users/supportteam and proving solution.Providing on call support to the Business in case of anycritical issue.

Created new procedures, functions, triggers, packages,and modified existing codes, tables, views to implementBusiness Logic. Analyzing, Slowness issue reported byEnd user based on various DB reports and Explain Plan.Provide L3 support for reported issue.Attending Scrum Master Calls to understand businessrequirement and team meetings with Architect, andtesting teams to decide on Implementation of therequirement.Used Oracle XML DB features for generating(constructing) XML data from relational data in thedatabase.Working on daily-logged issues by the users/supportteam needs bug fix/Enhancements and providingsolutions by analyzing and troubleshooting Applicationlogs as per AOTS tickets.Fine-tuned long running Business reports.Functional Requirement Specification Preparation.Performance tuning of SQL queries using AWR andExplain Plan.Involved in Problem Investigation and businessdevelopment for different patch/release.Worked under tight schedules for successfuldevelopment and implementation.

Working on daily-logged issues by the users/supportteam needs bug fix/Enhancements and providingsolutions by analyzing and troubleshooting Applicationlogs as per AOTS tickets.Fine-tuned long running Business reports.Functional Requirement Specification Preparation.Attending VT (volume test) calls with VT team.Involved in Problem Investigation and businessdevelopment for different patch/release.Worked under tight schedules for successfuldevelopment and implementation.

Working as L2 ResourceCreated and modified SQL queries to fetch the data asper client requirement.Analyzing show stoper issueCoordinating with L3 Team and Customer to resolve theissue over callManaging OTM tool for shipmentTracking of the GOODS flow is managed or tracked byTransfer Management system.Multiple status such as In-Transit, Missing andMisdirected are provided in onlineWith an automated process called AUTO LITIGATIONwhich will also trigger the alert EMAIL to specific storeusers and escalation levels