Suryaprakash Subramanian

WORK HISTORY

EDUCATION

ABOUT SURYAPRAKASH SUBRAMANIAN

Having 3+ years of programming experience as an Oracle PL/SQL Developer in Analysis and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).• My extensive experience with RDBMS includes Oracle 10g/11g SQL and a proficiency in PL/SQL.• Expertise in using SQL statements like DDL (Data Define Language), DML (Data Manipulation Language), TCL (Transaction Control Language) and DCL (Data Control Language).• Proficient in creation, modification and effectively use of database objects like Tables, Sequences, Indexes (B-Tree, Bitmap and Function Based), Views and Synonyms.• Having expertise in writing Complex Queries by using Sub Query, Joins, Pre-defined Functions and Constraints.• Experience in creating Materialized Views for data replication in distributed environments.• Having knowledge in loading data from flat file to oracle database tables using SQL*Loader and External File.• Having knowledge in Analytical Function and Pseudo columns Set Operators and basic knowledge in Cluster.• Extensively used Cursor to fetch multiple records from table inside PL/SQL Block.• Experience in developing PL/SQL Databases Objects like Stored Procedure, Functions, Packages and Trigger.• Handled errors using Exception Handling extensively to debugging and displaying the error messages in the application.• Having basic knowledge in Ref Cursor and Pragma Autonomous Transaction.• Having knowledge on Advanced PL/SQL concepts Like UTL_FILE For Generating Report.• Having knowledge in Bulk Collections (FORAll, Limit and Bulk Exception) for better Performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.• Having knowledge about Common Table Expression (CTE) and Global Temporary Table.• Having Basic Knowledge on Performance Tuning like Index, Explain Plan, Oracle Hints and Table Partition.• Ability to work individually as well as in a team with Excellent Problem solving and troubleshooting capabilities.