Oracle Fresher SQL PLSQL Resumes

PAUNRAJ.A,
270/4, Manakaadu,yathavar street,
Kattanachampatty(PO),
Rasipuram(TK)-637408,
Namakkal(DT)
Mobile No : 8072845759
E-Mail Id : paunraj1310@gmail.com

Professional Summary

Strong working experience includes Software Development and Implementation of Oracle 10G/11G/12c as Developer.
Hands on Development Experienced in Database programming using Oracle PL/SQL.
Involved in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Packages
Strong Knowledge in Development and Implementation phases of complete Software Development Life Cycle.
Loading data from Existing database schema to new schema using Oracle Packages.
Verify, validate data using SQL queries
Written complex SQL (Sub queries and Join conditions), in PL/SQL
Modified existing Code according to the requirements.
Troubleshoot and debug system and/or data errors.
Tuned SQL queries improve performance.
Vast Experience in Oracle advance SQL Programming Using Analytical functions, Sub Queries, indexes and so on.
Proficient in creation, modification and effectively use of database objects like Tables, Constraint, Sequences, Indexes, Group Functions, and Views.
Experience and Excellent Exposure in Query tuning using Materialized Views & Indexes.

Education Details

Courses	Institution	Board / University	Year of Completion	Marks %
MCA	Paavai College of Engineering	Anna University	2018	83%
BCA	Muthayammal College of Arts and Science	Periyar University	2015	69%
XII	Govt.Hr.Sec.School	State Board	2012	63%
X	R.C.Sacred Heart High School,	State Board	2010	83%

Technical Skills

Languages : Oracle SQL , PLSQL and Oracle.
Database : Oracle 10G,11G,12C.
Tools : SQL Developer,Toad,SQL*Plus.
Operating System : Windows , Linux.

Project Details

Project Name : Banking In Trading
Role : Oracle PL/SQL Developer
Duration : May 2018 to August 2018.
Description : On the trading side of the business, Financial Services Trading

Application, delivers trade by trade visibility into interactions, involving users to communicate with the share market trading, to buy and sell shares, transfer cash from bank to our financial services trading application. We can check the trading limit, we can track the orders and the trades that has been done so far, the amount that is available in our De-mat wallet, viewing the day’s trade history in the view digital transactions and withdrawing the cash from De-mat account to our bank account. It monitors mutual funds trading, employee trading, and investment advisor compliance. The product includes extensive spanning Equity, Commodity, Currency, IPO, Mutual fund, Insurance and derivatives trading.

Professional Certifications