Vasanth Selvan Email & Phone Number

· Over 3 years of programming experience as Oracle /PLSQL and SQL developer.· Worked in Development and support applications for Banking and Finance industry· Very good knowledge about oracle tools like SQL *PLUS, SQL loader and SQL Navigator.· Expertise in developing applications using Oracle 12c/11g platforms.· Very well experienced in creation of Tables, Views, Sequences, Indices, Synonyms and other SQL operations which include DML, DDL, DCL, and TCL.· Experience with some of the complex queries like Joins, Subqueries Table Constraints, Set Operators and also some SQL functions such as Aggregate, Analytical etc.· PL/SQL experience includes creating Procedures, Packages, Triggers, PL/SQL functions, Debugging ORA errors and some of the advanced functions such as Cursors, Ref Cursors, Exceptions, Collections, Bulk collect, Bulk blind with save exceptions, Pipelined Table functions, Pragmas.· Having experience on Database Administration on creating roles, users and Grant/ Revoke permissions for databases, tables, functions etc.· Experience in Performance Tuning, Query Optimization, also implementing best practices to avoid high CPU usage causing performance issues within the database.· Experience in implementing Explain plan, DBMS – Profiler, Table Partition, Query rewrite, Table Fragmentation, Direct Path loader and Conventional Path Loader.· Performance monitoring of Database SQL and designs causing abnormal CPU memory consumption using AWR report, XML data and also Gather Table statistics.· Experience in using V$ views namely V$SQLTEXT, V$SQLAREA, V$SQLPLAN.· Expert in Conceptual, logical, Physical Data modelling and normalizing techniques.· Well aware of importing data into Oracle RDBMS, usage of SQL loader and various file types.· Experienced in writing Shell Scripts and good knowledge on UNIX platforms.

• Oracle Developer

  Abax Techno Solutions

• 

  Christ University, Bangalore

  Automotive Engineering Technology/Technician