RESUME
Karthik S
Karthiks05697@gmail.com
No.7,East Kamakoti Nagar,3rd Street, Valasaravakkam,Chennai-600087
Phone: 7358207888
Objective:
Aspirant for a position in an organization where I can contribute my skills for organization’s success
and synchronize with new technologies while being resourceful, innovative and flexible.
PROFESSIONAL SUMMARY:
• Around 2+ Years of experience in the Oracle PL/SQL Developer/Production Support experience in
software analysis, design, development, testing and implementation of full life cycle web based
software applications.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Work experience in writing SQL queries, Views, Materialized views, PL/SQL procedures,
functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference
cursor, Dynamic SQL.
• Exposure writing complex SQL Queries.
• Bulk data Collecting, Performance tuning of huge data with use of PLSQL collections and records.
• Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained
performance.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical
functions, Materialized Views.
• Expert in query optimization and exposure using Hints, GTT.
• Tuning of SQL Queries, Explain plan, DBMS_Profiler.
• Expertise in loading data using SQL*Loader.
• Export and Import Database level or Schema level by using SQL Loader.
• Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS,
TOAD and SQL DEVELOPER.
PROFESSIONAL EXPERIENCE:
• Working as an Oracle SQL Developer For “HCL TECHNOLOGIES” from Apr’ 19 to till date.
Professional Certification:
• Oracle Certified Associate (OCA).
EDUCATIONAL QUALIFICATION:
• Completed B.Sc (Computer Science) From Vivekananda College.
Project Details:
Project #1:
Client Name : FNB Corporation
Project Name : Local Trader
Role : SQL Developer.
Responsibilities :
• Involved in Analysis, Design, Data Modeling ( Logical and Physical), and
Implementation of Business Applications using the Oracle Relation Database Management
System(RDBMS).
• Responsible for the designing the advance SQL queries, procedure, function, package,
cursor, triggers, scripts.
• Created scripts to create new tables, views, queries, materialized views for new enhancement
in the application using SQL* plus
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Developed SQL*loader scripts to load data in the custom tables
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query
performance by reducing context switching.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Handled errors using Exception Handling extensively for the ease of debugging and
displaying the error messages in the application.
TECHNICAL SKILLS:
• Languages : Oracle SQL , PLSQL
• Database : Oracle 10G,11G,12C
• Tools : SQL Developer, Toad, SQL*Plus
• Operating System : Windows , Linux
PERSONAL PROFILE:
• Father’s name : Sainath D
• Gender : Male
• Marital Status : Single
• Date of Birth : 05/06/1997.
• Languages Known : English, Tamil , Telugu.
DECLARATION:
I hereby declare that all the details furnished above are true to the best of my knowledge.
DATE :
PLACE :
(Karthik S)
