KR PRADEEP
PL/SQL Developer
Chennai, IN.About
Highly accomplished PL/SQL Developer with 6+ years of experience in Oracle and Unix environments, specializing in robust database solutions for the Banking, Insurance, and Retail sectors. Proven expertise in developing and optimizing complex SQL/PLSQL objects, including Stored Procedures, Packages, Functions, and Triggers, to enhance data integrity, system performance, and operational efficiency. Adept at performance tuning with Explain Plan and skilled in advanced exception handling, consistently delivering high-quality, scalable database solutions.
Work
Infosys (Subcon iSANS Consulting Services)
|Senior Software Engineer
Chennai, Tamil Nadu, India
→
Summary
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.
Highlights
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.
Estonix Technology LLP
|Software Engineer
Chennai, Tamil Nadu, India
→
Summary
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.
Highlights
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.
Ramone IT Pvt Ltd
|Software Engineer
Chennai, Tamil Nadu, India
→
Summary
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.
Highlights
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.
Sureworks Infotech Pvt Ltd - India
|Software Engineer
Chennai, Tamil Nadu, India
→
Summary
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.
Highlights
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.
Skills
Programming Languages
SQL, PL/SQL, UNIX.
Database Management
RDBMS, Stored Procedures, Packages, Functions, Triggers, Views, Materialized Views, Indexing, Sequencing, Cursors, DML, DDL, DCL.
Query Optimization
SQL Queries, Performance Tuning, Explain Plan, SQL Tuning.
Data Handling
SQL*Loader, PL/SQL Collections, Bulk Collect, Pragma Autonomous Transaction, Data Modeling, Data Integrity, Exception Handling.
Education
SKP Engineering College
→
Bachelor of Engineering
Computer Science and Engineering