Experienced as Production Support Analyst with 6 years of expertise in managing and supporting production environments.
Proficient in SQL, PL/SQL, and Unix, with a solid understanding of using tools like Toad, SQL Developer, Super Putty, Putty, Jenkins, Dynatrace, Splunk, Remedy, and ServiceNow to optimize system performance and troubleshoot issues efficiently.
Skilled in automating processes, monitoring production systems, and ensuring timely resolution of incidents.
Adept at collaborating with cross-functional teams to deliver reliable, high-quality support.
Highly committed to continuous learning and improving operational efficiency
Overview
6
6
years of professional experience
Work History
Lead Production Support Analyst
MasterCard
Chennai
09.2023 - Current
Delivered round-the-clock support to resolve transaction decline issues, maintaining smooth application functionality in the banking sector.
Had been a secondary/back up for the Federative Problem Manager dealing with the problem investigation raised for the code/defect related issues and to provide feasible solution with the required time.
Worked with development and testing team for defect analysis.
Alerts and Events to be monitored and to clear the issue on the same day.
Worked on the packages via sql developer to find the cause of the failure of the transactions.
Have worked with all type of transactions, queries with respect to the portals, wallets, cards.
Have checked with the reports like Transaction Detail report, Authorization Report, QMR report.
Worked on related to the batches like daily batches, ageing batch, pre clear batch, matching batch.
Worked on the limit mismatch in the balance, negative balance and provided all the results for which the bank raises query.
Have used the TWS command to rectify the changes in the reports.
Have used Tivoli to check the failure in the job abend.
Using Splunk, Dynatrace – have checked the logs and details of every transaction.
Have used Jenkins to restart the components when required.
Worked on the Customer Service Portal (frontend) and helped the clients to meet their requirements.
Performed the card renewal activity via scripts.
Worked on the Outbound Migration activities – lead and given continuous support to the banks migrated from MI platform to their respective platform with the help of dumps as per the requirement.
Worked on incident resolution - to review and resolve the incidents arising from.
Participated/Initiated in War Room calls that impacts application availability or has a customer impact.
Resolved the work orders/tickets in for of business/functional queries, adhoc requrest, verification and validating from customer support teams.
Performed root cause analysis in details for incident and took action on fixing the cause of high severity issue.
Senior Project Engineer
British Petroleum Business Unit
Hyderabad
03.2019 - 02.2022
Handled application issues from start to finish to guarantee smooth business service continuity and executed necessary enhancements.
Coordinated with clients to deliver necessary Oracle objects, supporting business requirements and providing continuous enhancement and production problem resolution.
Giving support to six countries for order to invoicing process. Involved in the continuous enhancement requests and fixing of production problems.
Handled the change request and provided the scripts on time.
Developed PLSQL programs using cursors, functions, handing exceptions using packages as per the customer requirement.
Developed Business Reports using Oracle SQL,PL-SQL.
Created Multiple master data setups like TAX, SIP PRICES, CUSTOMER ACCOUNTS, CUSTOMER ADDRESS,PRICING AND EXCHANGE RATES.
Checking the daily business data related to fuels using SQL queries at the backend.
Checking complete order to invoicing process for the fuel product orders.
Creating Unix Shell scripts as a part of automation scripts for repeated issues.
Performed batch logging and exception logging on Oracle Packages for monitoring job and exceptional handling.
Involved in client discussions in understanding the customer requirements. Provided the document of understanding (DOU) and cost estimates for implementing the requirement as per the customer requirement.
Senior Project Engineer - Team Lead
AIRFIELD AUTOMATION
Hyderabad
03.2019 - 02.2022
Implemented Safe2Go mobile app for airfield fueling, streamlining the process and ensuring secure delivery note handovers to pilots.
Led the automation project for the server across 10+ countries, enhancing the order-to-invoice process and achieving a significant milestone in misfuel prevention.
As worked on the test databases, all the requirements have been completed with manual intervention and completed successfully as like in production databases.
Good communications and interpersonal skills and involved in client interactions for scoping, effort estimates and status reporting.
Performing end to end testing from order to invoicing. Producing invoices and providing the invoice copy to the business.
Planning, delivering and implementation of quality solutions as per scheduled milestones.
Developed Business Reports and created the scripts using shell script, Linux, SQL and PL-SQL.
Education
Master of Technology - Software Engineering
BITS Pilani
01-2022
Skills
SQL Developer, TOAD,Putty, Super Putty
Ticketing Tools : Remedy, Service Now, Xmatters
Monitoring Tools : Tivoli, Dynatrace, Jenkins SQL Super Putty, XMatters, OMNIBus