Kishore Suresh Kumar

• Conducted detailed analysis and requirement gathering, creating complex DB objects such as Tables, Views, Constraints, Synonyms, Sequences, Packages, Procedures, Functions, Bulk Collect, and Directories, along with UTIL_FILE functions for efficient data processing • Configured and managed Oracle DBMS Scheduler to automate key database operations such as data backups, maintenance, and report generation, ensuring smooth and error-free workflows • Collaborated with cross-functional teams including Developers, DBAs, DevOps, QAs, and BAs to design and implement performance monitoring solutions using PL/SQL and Oracle Enterprise Manager, resulting in enhanced system efficiency • Led data extraction through ETL processes utilizing PL/SQL, Linux commands, and Unix shell scripts for seamless data transfer to the One Identity system, significantly reducing wait times for UAM requests • Automated the process of loading data from CSV files into Oracle APEX applications, with successful data transfer to the OLAP Hyperion Essbase system, utilizing multidimensional data cube storage for faster analytics • Designed and implemented complex page rendering, page processing, shared component attributes, dynamic SQL reports, wizards, lists, and navigation features within Oracle APEX applications to enhance user interaction and functionality • Developed and maintained custom authentication mechanisms, including SSO and database account authentication, ensuring secure access and streamlined user experience across applications • Implemented and maintained ITRMP and SOX compliance frameworks for banking and financial applications, ensuring data security, operational reliability, and adherence to financial reporting standards

• Formulated SQL queries, functions, and processes to meet customization requirements for Oracle APEX applications, ensuring efficient and tailored solutions • Successfully migrated the EHS application from a mobile theme to the universal theme, enhancing the user experience and interface consistency • Designed and developed screens and pages for various modules, including EHS Timecard, Requisition Reassignment, Credit Card Profiles, and Credit Card Audit applications, utilizing Oracle APEX 21.1 based on business needs • Developed various custom packages, triggers, and forms to enhance application functionality and meet business requirements • Utilized Python libraries like NumPy and Pandas to clean and analyze data, preparing it for in-depth analysis and reporting • Designed data visualizations using Matplotlib, Seaborn, and Plotly Express to identify trends and patterns, facilitating insightful data interpretation

• Developed, supported, and maintained Bombardier Learjet Oracle APEX applications, ensuring seamless operation and optimal performance • Handled change requests, projects, incidents, RFCs, and code reviews, efficiently fixing bugs and delivering high-quality solutions within tight deadlines • Analyzed Business Requirement Documents (BRDs) and provided comprehensive Impact Assessment Reports to outline implementation requirements and potential risks, ensuring well-informed project decisions • Managed data loading processes, including importing Excel data into Oracle APEX and processing it into the respective tables, improving data accuracy and accessibility • Collaborated closely with customers to gather requirements, designing bug-free, robust applications tailored to client needs, and ensuring customer satisfaction

• Developed and maintained web applications using SQL, PL/SQL, and Oracle APEX, ensuring functionality and performance met client requirements • Assisted in the design, coding, and implementation of user-friendly interfaces and application pages for various modules, including forms, reports, and dashboards, using Oracle APEX • Collaborated with cross-functional teams to gather and analyze requirements, translating them into technical specifications and application features • Implemented data-loading solutions, including importing data from Excel and other file formats into Oracle APEX applications for processing and storage • Worked on performance tuning and debugging to ensure smooth, efficient, and error-free application functionality • Utilized dynamic actions and JavaScript in Oracle APEX to enhance interactive features and improve the responsiveness of the application • Participated in code reviews, testing, and deployment processes to ensure high-quality deliverables and meet project deadlines

• Accessed and efficiently downloaded XML and CSV files from SFTP servers, ensuring smooth data retrieval for further processing and integration • Generated .dat and .csv files from the retrieved data and securely placed them into the designated SFTP directory, automating data delivery processes and improving workflow efficiency • Leveraged Oracle packages to extract XML and JSON data, populating Mutual Fund transaction tables with high accuracy, improving data processing and integrity • Processed extracted data through Oracle APEX screens, ensuring accurate data handling, transformation, and validation in line with business requirements • Consolidated and transferred processed data to the OFCS system, facilitating seamless integration and ensuring end-to-end data accuracy across financial systems • Designed and generated reports in prescribed formats using Jasper Reports, providing stakeholders with critical insights and accurate reporting

• Created and executed basic SQL queries to retrieve and manipulate data from Oracle databases, improving data accessibility and accuracy • Participated in testing and debugging efforts, identifying and resolving issues to ensure the smooth functionality of applications • Contributed to the design and development of user interfaces using HTML, CSS, and JavaScript, enhancing application interactivity and user experience • Gained experience with version control tools like Git, actively participating in code reviews and collaborating with the team to manage project changes