Mahendran s
ORACLE - PL/SQL Developer
**************@*****.***
**/** ******* ***** **, M.G.R
Nagar, Chitlapakkam
,
To succeed in an environment of growth and excellence and earn a job which provides me job satisfaction, self- development and help me to achieve personal as well as organization goals.
CAREER OBJECTIVE
LANGUAGES: SQL, PL/SQL
DATABASES: Oracle 11g.
TOOLS/ UTILITIES: SQL Developer,
SQL*PLUS, SQL*Loader.
OPERATING SYSTEMS: Windows.
Having 3+ years of experience in information technology industry for database development and implementation covering the technical design documentation.
Proficient in PL/SQL and creation/modification of schema objects like Tables, Views, Indexes, Sequences and Synonyms.
Hands on experience in writing PL/SQL Packages, Procedures, Functions, Cursors, Collections, Bulk Collect, Constraints, Joins, Sub query and Analytical functions.
Migrated data from flat files to Oracle using SQL* Loader or import and export utilities.
Ability to be an effective team player and work under time constraints.
Expertise in using tools such as SQL Developer and SQL*Plus.
Has ability to take up new technologies within a short time span.
Experience includes in Anonymous blocks, Cursors, Exception handling, Parameterized cursor.
TECHNICAL SKILLS
ORGANIZATION: Oramate Technology Client : Monarch insurance, Kenya
#1. Travel Insurance, Nov 2016 - Nov 2017 ORACLE - PL/SQL DEVELOPER Travel insurance is an insurance that is intended to cover medical expenses, financial default of travel suppliers, and other losses incurred while travelling, either within one’s own country, or internationally.
Involved in Table creation, Constraint maintenance.
Understanding the requirements and writing SQL queries using Sub query, Joins, Functions.
Transformed data from external files to tables using SQL loader.
Monitoring day-to-day Process for different data loads and resolving Issues.
Responsible for sending daily and weekly status reports.
#2. Motor Insurance, Nov 2017 – present ORACLE - PL/SQL DEVELOPER Motor insurance is an insurance policy that protects the owner of the vehicle against any financial loss arising out of damage or theft of vehicle.
Proficient in PL/SQL and creation/modification of database objects like Tables, Views, Indexes, Sequences and Synonyms.
Hands on experience in writing PL/SQL Packages, Procedures, Functions, Cursors,
Exceptions, Joins, Sub query, Constraints and analytical functions.
Exposure in PL/SQL collections, Bulk collect and Dynamic SQL.
Having knowledge in PL/SQL Triggers, GTT, Materialized View and Ref cursor.
Migrated data from flat files to table using SQL Loader.
Good analytical skills in 11g SQL and PL/SQL.
Ability to be an effective team player and work under time constraints
Resolving issues on priority basis.
Madras University,
Prince Shri Venkateswara Arts and
science college, Gowrivakkam,
Chennai
Bachelor of Computer Application (BCA),
(2013 – 2016) – 85%
State board,
Jai Gopal Garodia National
HR.SEC.School, East Tambaram,
Chennai
SSLC, (2010 – 2011) – 88%
HSC, (2012 – 2013) – 66%
PROFESSIONAL SUMMARY
EDUCATION
PROJECT EXPERIENCE
PERSONAL INFORMATION
Father’s Name : Shankara nainar M
Gender : Male
Date of Birth : 12-03-1996
Language known : English, Tamil
Blood Group : B+
Relationship : Single
EXPERIENCE
COMPANY : ORAMATE TECHNOLOGY
DURATION : NOV 2016 - PRESENT
DESIGNATION : SOFTWARE ENGINEER