KR PRADEEP

Led PL/SQL development and database management for Infosys' Bupa client, enhancing data security, optimizing performance, and delivering critical business solutions within the health insurance domain.

• Developed and implemented robust data obfuscation techniques, bolstering security and preventing unauthorized access to sensitive health insurance data.
• Engineered efficient data loading processes using SQL*Loader, successfully integrating daily flat files into the database.
• Designed and optimized complex SQL/PLSQL packages, procedures, functions, and triggers, aligning database functionalities with evolving business requirements.
• Created and optimized procedures for archiving historical and unused data, significantly improving database performance and resource utilization.
• Implemented advanced exception handling mechanisms, enhancing debugging efficiency and ensuring clear error message display for critical applications.

Contributed as a Software Engineer at Estonix Technology, developing and optimizing SQL/PLSQL solutions for Deutsche Bank AG, focusing on data modeling, query tuning, and performance enhancement in a critical banking environment.

• Designed and implemented comprehensive data models, SQL queries, and schemas, ensuring robust data architecture for banking operations.
• Automated data ingestion processes by creating SQL*Loader control files, streamlining the movement of data from flat files and Excel into staging tables.
• Developed and optimized SQL and PL/SQL scripts for efficient data transfer across various schemas and databases, enhancing data integration capabilities.
• Engineered and fine-tuned Stored Procedures, Functions, and Packages, significantly improving the performance of critical banking applications.
• Resolved complex performance bottlenecks using EXPLAIN PLAN, leading to optimized query execution and reduced processing times.

Served as a Software Engineer at Ramone IT Pvt Ltd, delivering robust SQL and PL/SQL solutions for IPB Insurance, with a focus on reporting, data integrity, and performance optimization.

• Developed and scheduled critical SQL reports using UNIX scripts, providing timely business insights for insurance operations.
• Authored complex SQL queries utilizing Joins, Sub Queries, and correlated sub-Queries to efficiently retrieve and analyze large datasets.
• Designed and implemented user-defined functions with integrated error handling, enhancing application stability and data processing reliability.
• Ensured data integrity and consistency by implementing comprehensive validation checks through database constraints and triggers.
• Analyzed and optimized database performance using EXPLAIN PLAN, identifying and resolving query bottlenecks to improve system responsiveness.

As a Software Engineer at Sureworks Infotech, developed and deployed database solutions for Matas, focusing on creating and optimizing database objects, queries, and reports to meet diverse business needs.

• Developed and maintained a wide array of Oracle database objects, including Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, and Cursors, to support business operations.
• Authored and optimized complex SQL queries, utilizing Joins and Sub Queries, to facilitate efficient data retrieval for reporting and analytical purposes.
• Created and integrated user-defined functions with robust error handling, improving data processing reliability and system stability.
• Enhanced and deployed critical business reports, aligning database solutions with new functional requirements for a separate module.
• Authored Detailed Design Documents (DDL) and Impact Analysis documents, ensuring clear technical specifications and facilitating seamless project execution.