Kumaresan Prakash

Overall 5 years of programming experience in Oracle SQL and PL/SQL Design, Development, Implementation, Developer in Analysis. Installation & Up gradation and configuration of Oracle Database 12c/11g/10g/9i/8i.

Created

Tables, Views, Constraints, Index depends on requirements. Effectively made use of Indexes, Analytical functions, Materialized Views.

Developed

Complex database objects like PL/SQL Stored Procedures, Functions, Packages, Triggers, Collections, Cursors using SQL and PL/SQL. Cursors, Performance tuning of huge data with use of PLSQL collections and records.

Developer 2 - UST HealthProof India Private Limited

(2025-08)

• Developed and maintained Oracle SQL and PL/SQL programs to support healthcare business applications and operational processes.
• Created and modified Stored Procedures, Functions, Packages, Triggers, Cursors, and Collections based on business and operational requirements.
• Developed complex SQL queries using Joins, Subqueries, CTEs, Analytical Functions, Views, and Set Operators.
• Analyzed production incidents and performed Root Cause Analysis (RCA) to identify and resolve recurring issues.
• Investigated job failures, analyzed error logs, and implemented corrective actions using SQL and PL/SQL.
• Supported SIT, UAT, Production Deployment, and Post-Deployment Validation activities.
• Used Jira for incident tracking, service requests, defect management, and change-related activities.
• Used GitHub for source code version control and maintaining SQL/PLSQL scripts.

Developer 2 - US Technologies India Private Limited

(2024-04 - 2025-08)

• Designed, developed, and maintained Oracle SQL and PL/SQL database components to support healthcare data processing and business requirements.
• Developed and enhanced complex Stored Procedures, Functions, Packages, Cursors, and SQL queries for efficient data processing and business logic implementation.
• Created and optimized SQL queries, Joins, Subqueries, CTEs, Views, and Analytical Functions to retrieve and transform healthcare-related data efficiently.
• Performed SQL Query Performance Tuning by analyzing execution plans, optimizing joins, improving query logic, and leveraging appropriate Indexes to reduce query execution time.
• Worked extensively with Oracle database objects, including Tables, Views, Indexes, Stored Procedures, Functions, CTEs, and PL/SQL Collections.
• Developed and scheduled database-driven reports and data processing jobs based on client requirements and business needs.
• Used Jira for task management, defect tracking, issue resolution, and project status tracking.
• Utilized Git for source code version control, code migration, and deployment across development, testing, UAT, and production environments.
• Participated in Agile/Scrum ceremonies, including daily stand-up meetings, sprint planning, and status discussions with the development and project teams.

Software Engineer - B and B Textile

(2023-06 - 2024-03)

• Designed, developed, and maintained Oracle SQL and PL/SQL database components, including Stored Procedures, Functions, Triggers, Views, Cursors, Packages, and SQL Queries, to support core ERP business processes.
• Developed and optimized complex SQL queries and PL/SQL programs for ERP modules, improving data processing efficiency and overall application performance.
• Created Stored Procedures and Functions to implement complex business rules, validations, calculations, and data transformation requirements within the ERP application.
• Developed and maintained database Triggers to automate data validation, enforce business rules, and maintain data integrity across ERP transactional tables.
• Designed and optimized SQL queries using Joins, Subqueries, CTEs, Aggregate Functions, and Analytical Functions to retrieve and process large volumes of ERP transactional data.
• Performed SQL Query Performance Tuning by analyzing execution plans, optimizing queries, and recommending appropriate Indexes to improve database response time.
• Developed and supported Monthly Sales Order Reports, Stock Reports, Inventory Reports, and other operational reports using Crystal Reports and Oracle database queries.

Associate Database Engineer - Just Rise Technologies

(2021-03 - 2023-05)

• Designed, developed, and maintained Oracle SQL and PL/SQL database solutions to support core business processes and customized ERP modules.
• Developed and maintained Stored Procedures, Functions, Triggers, Views, Cursors, and SQL Queries to implement complex business logic and automate ERP transaction processing.
• Implemented robust Transaction Management processes for Purchase Order and Inward Transaction modules, ensuring data consistency, integrity, validation, and adherence to defined business rules.
• Analyzed business requirements and translated functional specifications into efficient SQL queries, PL/SQL procedures, functions, and database objects.
• Performed regular PL/SQL Code Optimization and SQL Query Performance Tuning using the Auvit BPA Framework, improving application responsiveness and database performance.
• Worked with Joins, Subqueries, CTEs, Aggregate Functions, Analytical Functions, Views, and Indexes to develop optimized database solutions for ERP applications.
• Created customized business reports using Oracle SQL, PL/SQL, and Crystal Reports to provide accurate and actionable business insights.
• Developed Sales Reports, Transaction Reports, QR Code Sticker Reports, and other operational reports based on client-specific business requirements.

B.E - Mechanical Engineering - M.P.N.M.J Engineering College Erode