Sabari Sellappan

Background

About Sabari Sellappan

Eighteen+ years of hands-on IT experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modelling (Logical and Physical), Implementation of Business Applications using the Oracle Relational Database Management System. • Oracle Certified Professional - Oracle 9i PL/SQL and Forms Developer. • Experience in Oracle 19c/12c/11g/10g/9i/8i, Oracle Forms, Oracle Reports. • Strong skills in Oracle including SQL, SQL*PLUS, PL/SQL (Packages, Functions, Stored Procedures and Database Triggers). • Experience in creating Oracle database objects using: i. PL/SQL Collection Types - Arrays, Nested Tables to enhance process performance and reduce storage. ii. RESULT_CACHE functions for application performance. DBMS_PARALLEL_EXECUTE for multithreading. iv. DBMS_WORKLOAD_REPOSITORY for generating AWR reports. v. DBMS_DATAPUMP for generating schema DDL backup scripts. vi. DBMS_HS_PASSTHROUGH to execute Transact-SQL programs. vii. UTL_HTTP for processing Rest API calls to interface with non-oracle applications. Aggregate/Analytical functions and PIPELINED table functions. ix. REGEXP functions for pattern matching. x. Virtual Private Database (VPD) using DBMS_RLS utility for data security. xi. Materialized views and Partitioned tables. • Experience with SQL*Loader Utilities. • Experience in tuning SQL/applications using AWR Reports, EXPLAIN PLAN, TKPROF reports. • Experience in supporting custom applications built using Oracle APEX 23.1. • Experience with version control systems such as TortoiseSVN, Visual SourceSafe, and Rational ClearCase. • Experience in creating/scheduling jobs in Windows Task Scheduler and Tidal Enterprise Scheduler Tool. • Knowledge in Python 3.9/3.6 and UNIX Shell Scripting. • Possess strong problem-solving and analytical skills. Strong commitment to team environment dynamics with the ability to contribute expertise and follow leadership directives at appropriate times.