AZHAGAR PERUMAL K
SOFTWARE ENGINEER
Chennai,TN
Summary
Seeking an Oracle PL SQL Developer position that offers an immediate challenge, career opportunity and advancement. Having 6+ years of programming experience as an Oracle SQL & PL/SQL Developer in the Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Experience in creating database schema objects such as Tables, Views, Sequences, Synonyms, and indexes. Expertise in using DDL (Data Define Language), DML (Data Manipulation Language), DCL (Data Control Language), and TCL (Transaction Control Language) commands. Strong knowledge in writing complex queries including Joins, Subquery, Group Functions, Set Operators, Pseudo Columns, and Analytical Functions. Knowing of creating Simple Views, Complex Views, and Materialized Views. Involved in loading data flat files into Oracle tables using SQL Loader and knowing table level export/import using Oracle Data Pump. Developed complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Have good knowledge in Cursor implementation and Exception Handling to handle errors in PL/SQL subprograms. Involved in advance PL/SQL constructs like Collections (Index by Table, Nested table, and Varray). Basic knowledge in Bulk Collect (FORALL, LIMIT, BULK EXCEPTION HANDLING) to improve the performance of multi-row queries by reducing the context switching. Having basic knowledge in Performance Tuning by analyzing Explain Plan. Oracle PL SQL Oracle SQL Excel Basic Unix Commands Unit Testing
Overview
7
7
years of professional experience
2
2
Languages
Work History
Senior Software Engineer
Vanguard Logistics private limited
08.2022 - Current
- Analyzed the business requirements of the project by studying the business requirement specification documents and try to convert that requirement to SQL queries or PL/SQL Worked as per the Work Request and Change Request raised from the end-user. Modifying various existing Packages, Procedures, Triggers, and Functions according to the new business requirement and carrying out the impact analysis. Involved in the creation of Sequences for automatic generation of Product ID, Customer ID Created Indexes on the tables for faster retrieval of the data to enhance database performance. Used Pragma Autonomous Transaction to commit the child transactions without affecting the parent transaction commit status. Used Bulk Collection for better Performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Involved in tuning the SQL queries when it takes a long time to process the request, using Explain Plan, and Hints to improve the query optimization. Code validation as per client requirement. Shrink the tables and improve the database performance.
Software Engineer
ThincleSoft Technologies
02.2019 - 08.2022
- Analyzed the business requirements of the project by studying the business requirement specification documents and try to convert that requirement to SQL queries or PL/SQL Worked as per the Work Request and Change Request raised from the end-user. Modifying various existing Packages, Procedures, Triggers, and Functions according to the new business requirement and carrying out the impact analysis. Involved in the creation of Sequences for automatic generation of Product ID, Customer ID Created Indexes on the tables for faster retrieval of the data to enhance database performance. Used Pragma Autonomous Transaction to commit the child transactions without affecting the parent transaction commit status. Used Bulk Collection for better Performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Involved in tuning the SQL queries when it takes a long time to process the request, using Explain Plan, and Hints to improve the query optimization. Code validation as per client requirement.
Education
BE - Mechanical Engineering
University College of Engineering
04.2018
Skills
TOOLS USED
Database
Oracle 11g ,12c,18c,19c(SQL and PL/SQL)
Client-side tool
SQL Developer and PL/SQL Developer/Toad
Ticket Tracking
JIRA
Version Control
SVN
Other Tools
Win merge, WinSCP
Scripting
Basic Unix Commands
Visual source
Oracle TOAD
Timeline
Senior Software Engineer
Vanguard Logistics private limited
08.2022 - Current
Software Engineer
ThincleSoft Technologies
02.2019 - 08.2022
BE - Mechanical Engineering
University College of Engineering