Sql Developer Oracle Pl

SAKTHI VISWA NANTHINI.B

***,*************

*nd Street,S.kolathur, Phone Number: 915*******

Chennai-600117 Email ID: adnjgd@r.postjobfree.com

PROFESSIONAL SUMMARY

Having Knowledge on Complex SQL Queries Such as Joins (Inner, Outer and Full Join), Sub Queries, Analytical Function, Aggregate Functions, Set Operators (Union, Union All, Intersect, Minus).

Having Knowledge on Tables, Views, Mviews, Sequence, Synonyms, Indexes such as Function Based B- Tree, Bitmap, Unique and Composite Index.

Good knowledge in Software Development and Implementation of Oracle 10G/11G as Developer.

Practiced Development in Database programming using Oracle PL/SQL,SQL*PLUS, SQL*LOADER.

Having knowledge and practiced writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Packages

Good Knowledge in oracle Supplied Packages (DBMS_SQL, DBMS_JOB, UTL_FILE), Dynamic SQL, Records, PL/SQL Tables.

Having Knowledge in loading data from existing database schema to new schema using Oracle Packages.

Practiced to Load the Data into Oracle Tables using SQL Loader.

Having good Knowledge in complex SQL (Sub queries and Join conditions), in PL/SQL

Troubleshoot and debug system and/or data errors.

Good Knowledge in SQL queries to improve performance.

Good knowledge and well-practiced in creation, modification and effectively use of database objects like Tables, Constraint, Sequences, Indexes, Group Functions, and Views.

Having Knowledge on Materialized Views for managing data Replication.

EDUCATIONAL QUALIFICATION

EXAMINATION

INSTITUTION

BOARD /

UNIVERSITY

YEAR OF COMPLETION

PERCENTAGE

Bachelor of Computer Application

MADURAI SIVAKASI NADARS PIONEER MEENAKSHI WOMENS COLLEGE

Allagappa University

2016-2019

CGPA 3.64

HIGHER SECONDARY

St, JUSTIN’S HIGHER SECONDARY SCHOOL,SIVAGANGAI

State Board

2014-2016

66%

SECONDARY

ALICE MILLAR HIGHER SECONDARY SCHOOL,SIVAGANGAI

State Board

2013-2014

63%

Technical Skills

Languages : Oracle SQL, PLSQL.

Database : Oracle 10G, 11G.

Tools : SQL Developer, SQL*Plus.

Operating System : Windows, Linux.

Project

Project Title :Online Learning System

Platform :J2ee

Environment

Oracle 10g/11g,SQL Developer, SQL*Plus

Personal Details

Father’s Name : R.BASKARAN

Mother’s Name :M.SUMATHI

Date of Birth : 12-01-1999

Nationality : Indian

Languages Known : English, Tamil.

Declaration

I SAKTHI VISWA NANTHINI hereby declare that above furnished details are true to my knowledge.

B. SAKTHI VISWA NANTHINI

Contact this candidate