Sql Developer Oracle

P.Aravind

E-mail id: *******@*****.***

Mobile : +91-938*******

PROFESSIONAL SUMMARY :

A competent and result oriented IT professional with 4.3 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Involved in Creation of tables, Partitioning tables, Join conditions, views for the business application development.

Expertise in Indexing, Materialized View, Analytical functions, Table Partitioning.

Experience in creating Stored Procedures, Functions, Packages, Triggers.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Expertise in Dynamic SQL, Collections and Exception handling.

Handled projects individually from front-end user interface design to back-end relational database design and development.

Used pragma autonomous Transaction to avoid mutating problem in database triggers.

Used Explain plan for Tuning the SQL statements by creating indexes.

Experience in building Indexes.

Use of Optimizer Hints to tune the Sql Queries.

Involved in various stages of SDLC like low-level design, Coding, Testing.

Extensively involved in writing SQL queries Sub queries and Join conditions, PL/SQL programming.

Good experience in UNIX shells scripting.

Prepare scripts for manipulating different files and creating the summary reports using UNIX environment.

Applying UNIX skills to monitor user related logins and issues.

EDUCATIONAL QUALIFICATION :

B.E.[Computer Science And Engineering] Mepco Schlenk Engineering College,Sivakasi,VirdhuNagar.

B.Sc[Information Technology] S.Vellaichamy Nadar Arts And Science College,Nagamalai,Madurai.

CAREER PROFILE :

Designation : Senior Software Engineer

Duration : July 2021 to Dec 2022

Company : HCL Technologies Ltd

Designation : PLSQL Developer

Duration : Oct 2018 to June 2021

Company : Tata Consultancy Services, Chennai (Contract Payroll)

Payroll : ILabz Technology, Chennai

SKILL SET:

Data Bases : Oracle 10g/11g.

Oracle Developer : SQL plus, SQL Developer.

Languages/Utilities : SQL, PL/SQL.

Other Tools : TOAD,SQL Loader, SQL Plus, Autosys

PROJECTS EXPERTISE:

Project#1

Project Name : Enhanced Securities Master

Client Name : State Street Corporation, United States

Technologies : Oracle 11g, SQL Developer, SQL Plus.

Duration : July 2021 to Dec 2022

Business Description

State Street Corp (State Street) is a financial holding company that offers a wide range of investment servicing, and investment research, investment management, and trading services through its principal subsidiary, State Street Bank. Its portfolio of products and services comprises securities lending, foreign exchange solutions, trust and custody, performance measurement, portfolio analysis, accounting, cash management, fund administration, private equity, hedge fund, advisory, depotbank, outsourcing, and real estate services. State Street also offers asset management strategies across equities, fixed income, multi-asset, alternatives, and cash asset classes. It serves institutions, investment managers, insurance companies, mutual funds, collective investment funds, corporate and public retirement plans, foundations and endowments in North America, Latin America, Europe, the Middle East, and Asia. State Street is headquartered in Boston, Massachusetts, the US..

Roles & Responsibilities :

Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic.

Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience (SDLC).

Performed modifications on existing form as per change request and maintained it.

Created multiple customized PL/SQL Procedures & Packages for various businesses needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.

Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Project#2

Project Name : Wallstreet Decommission Application

Client Name : Royal bank of Scotland, London

Technologies : Oracle 11g, SQL Developer, SQL Plus.

Duration : Oct 2018 to June 2021

Description:

The wallstreet application is used for FX, Money Market, and cashflows across RBS. Currently there are 5 versions which provides services to clients.wss provides downstream/upstream systems from which is receives trade details. It supports around 200+ FX and Money Market provides across all global currencies.

The version of wallstreet will not be in working condition by June.WSS 3.4 is migrated to WSS Global.

In my carrier i developed a clear understanding of the credit risks involved in more complex credit-granting activities. The activity such as loans to certain industry sectors, asset securization, customer written options, credit derivatives, credit-linked notes. I prompted a code for fully capable of conducting the activity to the highest standards and in compliance with the bank policies and procedures.

Roles & Responsibilities:

The Managed performance tuning of sql queries and fixed the slow running queries in production with utilities like Explain, store an outlines.

Conducted oracle database and sql code tuning to improve the performance of the application used Bulk binds, in-line queries, Dynamic Sql and analytics and sub-queries etc.

Extensive application in writing in tuning complex sub queries SQL, PL/SQL, Stored Procedures, functions and triggers.

Extensive experience in writing store procedures, functions and views.

Created the indexes and analyzed the table for better performance.

Wrote queries/procedures to retrieve and store data in the Oracle database.

Coded and maintained PL/SQL Packages, Stored Procedures and Database Triggers.

Tuned SQL queries and performed code debugging using TOAD.

Developed complex queries including Sub queries, Unions, Intersect and Aliases.

Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.

Prepared test cases and conducted Unit Testing for this module.

Prepared estimates for Change Requests raised by the client.

Provided new reports development and enhancements to existing reports.

Worked on enhancements and bug fixes.

DECLARATION:

I hereby declare that the information furnished above is true to the best of my knowledge and belief.

PLACE:

DATE: Aravind. P

Contact this candidate