Gokul K

PL/SQL developer with hands on experience of 3.6 Years

Rudimax Solutions., Chennai, India | Oracle PL/SQL developer JULY 2019 - Present

Responsibilities

 Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.

 Developed data model, PL/SQL Queries, SQL Query tuning process.

 Created and maintained tables, procedures, functions, and packages, and update, delete, and

 insert statements and compile them.

 Experience working with Oracle CLOB, BLOB, Materialized Views, Ref Cursors, Index

 Tables, Partitions, Objects/Collections, Execute Immediate etc.

 Formulated SQL queries, functions and processes as per requirement.

 Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding

 involved in writing database procedures, functions and packages.

 Worked with developers to repair and enhance current base of PL/SQL packages to testing issues.

 Performed SQL and PL/SQL tuning and Application tuning using various tools like

EXPLAIN PLAN.

 Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

 Used Bulk Collections for better performance and easy retrieval of data, by reducing context

 switching between SQL and PL/SQL engines.

 Data Load into Oracle tables using SQL*Loader, and PL/SQL procedures

 Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database

Triggers.

 Defect tracking through JIRA and defect summary reporting.

 Worked on agile and test-driven environment, participated on daily scrum meeting, and discussions.

Solubils corporate services, Chennai, India | process Executive Oct 2015 – Dec 2017

Responsibilities

 Understand the requirement and nature of the client’s business and will suggest incorporation plan

 Documentation works.

 Regular follow up with the clients

 Coordinating with other teams regarding the pending process.

 Reporting daily status and weekly review

P

Bachelor of Engineering (Mechanical Engineering), from Vels University, Chennai, India - 2015