PRABHAT KUMAR SRIVASTAVA

Detail-oriented and results-driven SQL Database Engineer with over 3 years of experience at Wipro, specializing in database design, optimization, and automation for large-scale transactional systems. Skilled in SQL, database management, performance tuning, and batch scripting, with a proven track record of successfully building and automating systems from the ground up for financial institutions. Adept at working in cross-functional teams and driving innovative solutions to streamline data processes. Seeking a challenging Database Engineer role to further leverage my technical expertise. Proven use of AI and effective use of generative intelligence.

1. Bank Transactional System & Loan Calculations Automation
Duration: [10/2022 –01/2024 ]

 Overview: Led the development of a comprehensive transactional system for a banking client from scratch, utilizing SQL for database design, data processing, and implementing automated loan calculations. The system was designed to handle high-volume transactions, ensuring data accuracy and operational efficiency.
 Responsibilities:Developed the complete transactional system using SQL, creating robust database schemas, tables, stored procedures, triggers, and functions to manage banking transactions and automate loan calculations.
Designed and optimized SQL queries to handle complex transactional data, ensuring system performance and reducing processing time.
Integrated business logic into the database to automate loan interest and repayment calculations, improving the accuracy and speed of financial operations.
Applied best practices for data integrity, ensuring that all transactions, balances, and loan details were correctly recorded and updated.
Utilized batch scripting to automate regular database operations, such as data migrations, backup processes, and transaction updates, minimizing the need for manual intervention and enhancing system reliability.
Conducted performance tuning on SQL queries, reducing query execution times which resulted in improved user experience and faster data processing.
Worked closely with business analysts and stakeholders to gather requirements and ensure the system met all functional specifications.
Provided ongoing maintenance and troubleshooting to ensure seamless operations after deployment.

 Technologies Used: ORACLE SQL,PL/SQL , Batch Scripting, ORACLE SQL DEVELOPER

2.Enhancements to an Existing SQL-Based System
Duration: [09/2021 – 09/2022]

 Overview: Contributed to a project involving the enhancement of an existing SQL-based system for a client, where I worked on making minor but critical adjustments to the existing code base, optimizing its performance, and ensuring the system was aligned with updated business requirements.
 Responsibilities:Analyzed the existing database schema and SQL code to identify areas for improvement and ensure compatibility with new business requirements.
Implemented modifications to stored procedures, triggers, and SQL queries, improving the efficiency and accuracy of business processes without major system overhauls.
Optimized SQL queries for faster execution times, improving performance in key business areas such as reporting and data retrieval.
Collaborated with the development team to ensure smooth integration of changes with minimal system downtime.
Conducted thorough testing on the modified system to ensure that all enhancements worked as expected and met the client’s requirements.

 Technologies Used: ORACLE SQL,PL/SQL , Batch Scripting, ORACLE SQL DEVELOPER