Developer Data

P.Aravind

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

Mobile : +91-962*******

PROFESSIONAL SUMMARY :

A competent and result oriented IT professional with 5.6 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.

Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.

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

Good experience in UNIX shells scripting.

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.

Loaded the data using the SQL loader, Imports & UTL files based on file formats.

Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query etc.

Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.

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.

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 : plsql Developer

Duration : Oct 2018 to till Date

Company : Tata Consultancy Services, Chennai (Contract Payroll)

Payroll : ILabz Technology, Chennai

Duration : Nov 2014 to Sep 2018.

Company : Ramco Systems Limited, Chennai.

SKILL SET:

Data Bases : Oracle 10g/11g.

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

Languages/Utilities : SQL, PL/SQL, Unix Shells Scripting

PROJECTS EXPERTISE:

Project#1

Project Name : Wallstreet Decommission Application

Client Name : Royal bank of Scotland, London

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

Duration : Oct 2018 to till date

Description:

The wall street application is used for FX,Money Market,cashflows across RBS.Currently there are 5 versions which provides services to clients.wss provides downstream/upstream systems from which is receives trade deails.It supports around 200+ FX an MoneyMarket 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 securisation,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,StoredProcedures,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.

Project#2

Project Name : Win Trade Newzealand

Client Name : new Zealand Bank International ltd

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

Duration : July 2015 to Sep 2018

Description:

Bank of new Zealand is the leading financial institution in new Zealand. Customer information systems hold customer, account, address, offer, service, statement related details in IMS and DB2 databases. CIS systems passes customer information to ATM, call centers, online banking, mobile banking systems in online and batch mode.

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.

Project#3

Project Name : System Integeral Robustory

Client Name : Canadian Imperial Banking Corporation, Canada

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

Duration : Nov 14 – 2015

Description:

The individual elements within systems of systems have different purposes and control structures. Systems of systems may be broadly categorized as virtual, collaborative, acknowledged or directed. The architect must determine, early on in the design process.

Roles & Responsibilities :

The front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

The Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Write Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

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.

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