Prashant Tiwari

Project: Rabobank BR – Oracle Banking Corporate Lending (OBCL)

• Customized and developed FCUBS/OBCL screens utilizing Oracle RAD Tool.
• Built complex PL/SQL packages, triggers, views, functions, and interfaces for loan operations.
• Developed AI-assisted PL/SQL logic to automate regulatory reporting and month-end processing.
• Designed and optimized data workflows for multi-limit loan processing and guarantees.
• Collaborated with stakeholders to gather accurate requirements for database solutions.
• Conducted code reviews to maintain compliance with best practices and standards.
• Documented technical specifications and user guides for database processes.

Tech Stack: PLSQL, Oracle, FLEXCUBE OBCL, SQL, RAD Tool.

Project: State Bank of India (SBI) – Core Banking System.

• Managed a team of 10 members.
• Customized and developed various core banking-related screens using Java.
• Developed AI-assisted PL/SQL logic to automate regulatory reporting and month-end processing.
• Analyzed project requirements to deliver effective solutions and support.
• Optimized database performance through regular monitoring and proactive troubleshooting.
• Created stored procedures, triggers, tables, views, and functions using PL/SQL for enhanced functionality.

Tech Stack: PLSQL, Oracle, Java, JSP.

Project:Kotak Mahindra Bank – CORENX Loan Application.

• Designed and developed CoreNX loan modules and DB objects.
• Leveraged AI-assisted methods for faster PL/SQL development and impact analysis.
• Implemented triggers, workflows, business rules, and multilevel authorization logic.
• Coordinated with BSG team to translate business needs into scalable technical solutions
• Optimized SQL performance through query tuning and indexing strategies.
• Designed and implemented complex PL/SQL queries for data extraction using AI.
• Implemented exception handling mechanism using error logging package in PLSQL.
• Created scripts to automate daily tasks such as backup jobs and scheduled jobs.
• Involved in Performance Tuning activities like creating Indexes, Partitioning Tables.

Tech Stack: SQL, PL/SQL, ORACLE RDBMS

Project1: SBI Life Insurance – Workflow Automation System | June 2019 – May 2021

• Developed and implemented Core Java applications utilizing frameworks such as Spring and Hibernate.
• Developed JSP-based workflow screens, integrated with PL/SQL backend logic.
• Debugged existing code to identify and resolve system issues efficiently.
• Built AI-augmented scripts for handling large-scale database operations.
• Designed database schemas and executed SQL queries for back-end interactions.
• Optimized SQL performance through effective query tuning and indexing strategies.
• Created stored procedures, functions, and packages using PLSQL to support application development.

Tech Stack: PL/SQL, Java, JSP, JavaScript, Oracle RDBMS, MySQL

Project2: - Corporate Net Banking (Yes Bank):Jan 2017 – May 2019

• Developed backend jobs to implement RTGS, NEFT, and IMPS processes.
• Implemented daily automated jobs/triggers for daily processing.
• Optimized SQL performance through effective query tuning and indexing strategies.
• Created batches for data exchange using Oracle DB.
• Created stored procedures, functions, and packages using PLSQL to support application development.

Tech Stack: SQL, PL/SQL, Oracle RDBMS

Project: Electronic Billing (Reliance Communications)

• Developed complex SQL queries for efficient data extraction and analysis.
• Created and optimized database objects, including tables, views, indexes, and synonyms in Oracle 11g and 12c.
• Integrated diverse data sources into a unified view using SQL joins and views.
• Resolved customer service requests related to database performance and errors promptly.

Tech Stack: Oracle RDBMS , SQL