Uma Maheswari Srinivasan

Total 11.7 years of experience as a Production Support Engineer with Oracle PL/SQL Development and enhancement. Having experience in Supply Chain Management & Banking Industry experience in commodities trading and risk management technologies.

• Received Spot award and client appreciation award in 2023 for proactiveness and swift response towards production issues.
• Received an award for Inspiring the people in 2022 (mentoring junior resources, coming up with innovation ideas which was presented to the client university).
• Internal Scrum certified – 2021.
• Oracle Database SQL Certified Associate - 2016
• ITIL (Information Technology Infrastructure Library) Foundation certified – 2020

• MindSprint Project Experience, Chain Management & Banking, Chennai, India, Troubleshooted and resolved production issues related to SQL queries PL/SQL procedures, triggers and functions, Performed performance tuning on SQL queries and optimized DB performance and improved application efficiency., Documented troubleshooting procedures and best practices to maintain the knowledge base for future reference., Provided L2 & L3 support for resolving issues and provide quick turn around to the clients. Mentored junior team members and provided training on Agile methodologies., Worked closely with product owners and stakeholders to align project goals and deliverables with business objectives, Managed multiple software development projects and ensured on-time delivery of high-quality software. Worked closely with cross-functional teams to define project scope, schedule, and budget., Collaborated with developers to resolve software defects and issues., Design and execute test cases to ensure the functionality of SQL-based applications. Validated the data in the database using SQL queries., CxC – Commodity Trading Risk Management System is an integrated commodity management system designed to meet the diverse needs of palm oil and other grain and oilseed industries, so that traders can make smarter business decisions. It ensures ease trade entry, mitigate risk and improves settlement accuracy. Seamlessly it also manage physical, paper, futures, and options trades in a single platform. Identify circle, washout, bypass, and string opportunities. Improve decision making with pre-deal analysis functionality to simulate profit and loss., OPS – Order Processing System is an software that is used to capture the deals, logistics information,invoices,cost and payment. This system shows the position (Long/Short) based on the contracts entered. It is also integrated with the risk system which gives the position of all the products, unit and grade wise. This system provides complete information regarding deal starting from the contract shipment, invoicing and payment. Able to generate the summary reports of the pending purchase/sales, shipments,invoices and Debit/Credit notes.
• Scope International Pvt.Ltd (Subsidiary of Standard Chartered Bank), Banking, Chennai, India, Involved in creating and modifying Advance PL/SQL packages, procedures, triggers, functions, Indexes, cursors, collections, Ref cursor, cursor variables, System reference cursor and Dynamic SQL to implement business logic., Able to resolve L2 & L3 issues quickly within the stipulated time. Responsible for interface aborts fixing, ticket solving within SLA. Experience in Query Optimization, Performance Tuning., Proficient in SQL server performance tuning, troubleshooting and resolving complex production issues. Troubleshoot and resolve complex production issues in a timely manner., Have been giving quick turnaround to the user in case of production issue., Workbench product is designed for the Relationship manager (RM) of Standard Chartered Bank. RMs spent a lot of time to mine the right data for the right customer to start the right actions. The workbench would save them this time and instead spend it directly with the customer. The workbench architecture consists of a presentation framework able to consume business services. The RM workbench merges the following views and activities: Service requests (initiate on-boarding, open accounts, etc.); portfolio views, social knowledge management, transaction views (complaint history, etc.), market data, financial metrics and process performance metrics (process costs, cycle times, etc.). The RM can start processes (for instance, opening an account) directly from the workbench. Then the RM can track the status of the process at any time.
• Vinkarr Technologies Pvt.Ltd, Banking, Chennai, India, Involved in creating and modifying Advance PL/SQL packages, procedures, triggers, functions, Indexes, cursors, collections, Ref cursor, cursor variables, System reference cursor and Dynamic SQL to implement business logic., Able to resolve L2 issues quickly within the stipulated time. Responsible for interface aborts fixing, ticket solving within SLA. Experience in Query Optimization, Performance Tuning., Workbench product is designed for the Relationship manager (RM) of Standard Chartered Bank. RMs spent a lot of time to mine the right data for the right customer to start the right actions. The workbench would save them this time and instead spend it directly with the customer. The workbench architecture consists of a presentation framework able to consume business services. The RM workbench merges the following views and activities: Service requests (initiate on-boarding, open accounts, etc.); portfolio views, social knowledge management, transaction views (complaint history, etc.), market data, financial metrics and process performance metrics (process costs, cycle times, etc.). The RM can start processes (for instance, opening an account) directly from the workbench. Then the RM can track the status of the process at any time.

ITIL