Amit Kumar Gupta

● Participate in business and system requirements sessions for manual program automation for Sales Compensation ● Prepare Dashboard using calculation, parameter in Tableau ● Key Focus Areas: To implement automation for manual programs wherever by developing a new tool to eliminate redundant work ● Expertise in writing procedures, functions, views, materialized views as required ● Understanding and Collecting requirements from Business user and try to convert that requirement to SQL queries or PL SQL ● Worked for Finance Restatement as Data Analyst for Americas theatre using SAP Business Object ● Designed and developed automated and manual excel report using Oracle DB, and Teradata ● Designed the database using Oracle SQL Developer for the application and wrote several packages and views used for operations on the database and getting information from the database.

● An active member of Scrum Team whose major focus on new feature enhancements, Defect fixing in developing web GUI from Visual Basic GUI probes used in monitoring network activity. ● Performed maintenance and defect fixing of this multi-threaded event-driven applications, which resulted in increased stability and robustness on various probe migration. ● Analyzed system monitoring measures, create reports, and formulate conclusions to manage performance using Nimsoft Unified Management Portal (UMP). ● Designed custom dashboard template using widgets, such as alarm objects, meter objects, charts, tables for dynamic view, and for better monitoring of computer systems.

Project Description- Customer Acquisition System (CAS) is a Web-based system that fulfills the requirements of automating loan origination and application processing operations of a lending institution. As the loan processing workflow varies from one lending institution to another, depending on the products offered, CAS has the provision of defining the workflow as per the requirements of the lending institution. CAS also focuses on the automation of various decision-making functions, such as credit checking and underwriting. This system serves as an open standard, scalable, and maintainable solution designed to handle high-volume transactions for lending institutions. ● Involved in developing JSP, Servlets, Action Classes, DAO based on the Enhancement/CR. ● Involved in Production Support based on the priority of the ticket ● Involved in performing RCA for the core system bugs ● Responsible for performance tuning activities in the project using Automatic Workload Repository (AWR)