Sagar Agarwal Email & Phone Number

Bengaluru, Ka, In

Bangalore

• Handling of Incidents, Service Requests and change requests created by the users.• Troubleshooting on application issues reported by the end users by replicating it and verifying logs.• Initiate the WAR room with all stakeholders to expedite the resolution on the issue.• Attend and organizing face to face meetings/conference calls with clients and other business stake holders.• Served as a technical liaison, resource and primary point of contact between application end-users and IT.• Perform thorough analysis of any existing problem on the production system, identify the root cause and design and lead the implementation of the proposed resolution

Bangalore

• Responsible for overall project schedule & planning which includes developing and coordinating realistic project plan, including key milestones, success metrics, and drive progress to achieve project plan within time and budget constraints from concept to launch.• Skilled at interacting with all levels of internal and external customers for meeting organizational needs, facilitating and implementing solutions for continuous improvement and measuring those improvements to ensure success.• An effective contributor with distinguished abilities in end-to-end process management, motivating team members to maintain deliverables as per SLA; effectively resolve escalated issues, communicate the status and resolution options to the management.• Worked as a primary contact for Application/Production support issues related to Supply Chain based applications (Demand and Fulfillment).• Providing technical/functional assistance and support for incoming service requests, Incidents, E-Mail & phone on issues related to JDA products and solutions• Handling issues related to Application or any Custom job/JDA process or data issues for clients across the globe• Provide guidance to L2 team for any batch failure and take corrective action to finish the jobs within SLA• Troubleshooting on data and application issues reported by the clients and end users using SQL queries and internal tools• Prioritizing support issues and responding appropriately to multiple critical situations• Maintaining log of problems by creating a ticket in the JDA CRM application. Following inquiry through to resolution and closing the ticket when completed• Escalating engineering issues to appropriate development teams and technology partners in a timely manner. Assisting with data search and identifying any data errors

Bangalore

Roles and Responsibilities Involved in writing SQL queries using joins, sub queries and correlated sub queries to retrieve data from the various tables from MDS Test database Review on SLA achievements and Continuous follow-up with global support teams for quicker incident resolution Perform thorough problem analysis resulting in resolution of product related problems Tariffs creation. Testing the implemented tariffs using pre-defined test scenarios and productive roaming data (TAP-files) in the UNIX environment Interacting with the clients to resolve application issues in the stipulated SLAs. Generating Test and Log Reports and documenting of the test results. File handling and Investigation of error reports and reprocessing of the files. Working knowledge of Ticketing Tools such as BMC Remedy, One support etc. Monitoring errors in CDR loading, bill generation, reconciliation etc. Investigating the root cause and reporting. Setting up of reference data if necessary Maintaining reference data on server without impacting the operations of the application and meeting the set SLAsSkills: SQL and UNIX ScriptsSpecialties: Oracle Toad, SQL Developer, UNIX Putty Application

Bangalore

Roles and ResponsibilitiesWorking in Telecommunication OSS/BSS platforms and prior experience in Roaming clearing domain Involved in writing SQL queries using joins, sub queries and correlated sub queries to retrieve data from the various tables from MDS Test database Creating new database objects like Sequences, Procedures, Functions, Indexes and Views Creating alerts using shell scripting and SQL Queries to monitor the daily activities Good understanding of SDLC and STLC concepts Review on SLA achievements and Continuous follow-up with global support teams for quicker incident resolution Perform thorough problem analysis resulting in resolution of product related problems Generating reports using SQL Developer, UNIX Putty and Excel VBA Tariffs creation by inserting RAs into the database using MDS tools and SQL, Citrix Server, UNIX and Shell Scripts (Ssh & ksh). Testing the implemented tariffs using pre-defined test scenarios and productive roaming data (TAP-files) in the UNIX environment with CH internal SW modules Interacting with the clients to resolve application issues in the stipulated SLAs. Generating Test and Log Reports and documenting of the test results. File handling and Investigation of error reports and reprocessing of the files. Working knowledge of Ticketing Tools such as BMC Remedy, One support etc. Load CDR, network data, circuit information and monitor their progress Monitoring errors in CDR loading, bill generation, reconciliation etc. Investigating the root cause and reporting. Setting up of reference data if necessary Maintaining reference data on server without impacting the operations of the application and meeting the set SLAsSkills: SQL and UNIX ScriptsSpecialties: Oracle Toad, SQL Developer and Citrix Web server, UNIX Putty Application, Test Management Tool

B.Tech, Computer Science

Intermediate, Pcm With Computers, 74.6