Oracle_SQL_Plsql__Dev_5yr_Exp
Resume:
DINAKARAN SUBRAMANIYAN
Mobile No: +91-999******* Email: ****.********@*****.***
OBJECTIVE:
To succeed in an environment of growth and excellence and earn a job which provides me job satisfaction, self-development and help me achieve personal as well as organization goals.
PROFESSIONAL SUMMARY:
4.8+ years of experience in information technology industry for Oracle database development.
Analytical and debugging skills in Oracle 10g/19c SQL and PL/SQL.
Created Tables, Constraints, views, Indexes, Triggers, sequences and synonyms.
Experience in SQL & PL/SQL Packages, Triggers, Procedures and functions.
Experience in Bulk Collect Materialized views, Dynamic SQL.
Experience includes in anonymous blocks, Cursors, Exception handling.
Experience in creating Global Temporary Table and Multi-table insert.
Expertise in using tools such as SQL Developer and SQL*Plus.
Handled the performance and tuning by using indexes and explain plan.
Have good knowledge in granting privileges and roles to users. TECHNICAL SKILLS:
Languages : SQL, PL/SQL.
Databases : Oracle 10g/19c.
Tools/ Utilities : SQL Developer, SQL*PLUS, WINSCP, JIRA, PUTTY.
Operating Systems : Windows.
EMPLOYER DETAILS:
Organization Start Date End Date Position
KG Information System Pvt.
Ltd., Coimbatore.
27-NOV-2019
31-May-2020
Senior Associate
Tata Consultancy Service
(TCS), Chennai.
(Forte Solution Pvt. Ltd)
22-OCT-2018
22-NOV-2019
SW Developer
Oramate Technology, Chennai.
06-JULY-2015
20-OCT-2018
SW Developer
M.S Tools and Manufacturing
Company Pvt Ltd, Chennai.
02-JULY 2012
29-JULY-2013
Application
Engineer
PROJECT EXPERIENCE:
P.No Client Duration Role
4.
Collinson, Singapore
Nov 2019 – May 2020 PL/SQL
Developer
3.
Nielsen Holdings Inc., USA.
Oct 2018 – Nov 2019 PL/SQL
Developer
2.
Decimus Financial Ltd, Pune, India.
Mar 2017 – Nov 2018 PL/SQL
Developer
1.
Monarch Insurance Company, Kenya
Nov 2015 – Feb 2017 PL/SQL
Developer
RESPONSIBILITIES:
Created Oracle TABLES, VIEWS, SYNONYMS, SEQUENCES, OBJECTS.
Created and debugged various PL/SQL packages, procedures and functions to support various areas of development.
Constructed standard and materialized views for viewing and extracting usable data from various sources to get a clear real-time view of business-critical information.
Handled the performance and tuning by using creating indexes.
Records are loaded into the tables by the methods of script.
Expertise in creating Global Temp Table and Multi-table insert.
Experience in Performance Tuning across many critical functions, and included appropriate use of: explain plan, Auto trace, establishing and restructuring of indexes.
Understood process requirements and provided use cases for business, functional & technical requirements.
EDUCATIONAL QUALIFICATION:
Master of Engineering with 84%. Sri Krishna College of Engineering and Technology, Coimbatore. (ANNA UNIVERSITY, Aug 2013 to May 2015) Tamilnadu.
Bachelor of Engineering with 78%. P.S.N.A College of Engineering and Technology, Dindigul. (ANNA UNIVERSITY, June 2009 to May 2012) Tamilnadu. DECLARATION:
I hereby declare that above information is correct to the best of my knowledge and belief. Signature
Date : (DINAKARAN S)
Contact this candidate