Resume

Sign in

Oracle developer with 3 years of experience using SQL , PL/SQL

Location:
Chennai, Tamil Nadu, 600016, India
Salary:
4.00 lacs
Posted:
August 26, 2011
Email:
cew6d9@r.postjobfree.com
Contact Info:
***********@*****.***


K.KOTTAIYARAJ

Mobile: +** 956*******
cew6d9@r.postjobfree.com

Objective: Looking forward for a career in Database Development where I can exercise my expertise and knowledge that fosters quality, creativity and continuous learning.

SUMMARY

• Having 3 years of experience in the areas of Oracle and PL/SQL based applications using Oracle PL/SQL and SQL Technologies under Windows WP/NT/2k, Linux Environments.
• Having database experience using Oracle 10g/9i/8i, SQL, PL/SQL, Stored Procedures, Functions, Exception Handling, Constraints, Triggers, Index, Views and Inline views.
• Involved in Development of the applications through Oracle using Pl/SQL created Tables, cursors and SQL Queries.
• Well acquainted with Oracle base technologies like SQL, PL/SQL.
• Having good knowledge of Software Development Life Cycle (SDLC).
• Good in Understanding of Business logic and ability to work well as a part of a team and as an individual.
• Ability to work in 24x7 environments, preparing root cause analysis and ensuring the action points.

Job Experience:

Company and Profile
Work Experience

Mani India Technologies Pvt Ltd, India
August 2008 to July 2009

Black Pearl Info Tech , India
August 2009 to till date

Skill Set:

Programming: Oracle SQL, Pl/SQL.
Oracle Tools & Utilities: OEM, DBCA, Putty, Export/Import, Data pump.
Operating system: Linux.


EDUCATION

B.Tech (IT) from P.S.R Engineering College.

PROJECT DETAILS:


Process Tracking System – Liberty Mutual Insurance, US

The objective of this project is to provide the client with robust software that generates around 80 customized reports, which will either be used by the insurance company for their internal purposes, or be sent to their headquarters in Seattle. These reports will be generated based on the data available in their five Departments.
As an Oracle Programmer was involved in the following
• Involved in the whole life cycle of the project.
• Interacted with clients to understand their requirements.
• Involved in Table design.
• Programmed Packages, stored procedures, queries, and triggers on Oracle 10g.
• Unit and System Testing.
• Plan and supervise the daily activities of the application support
• Database Query tuning and Implementation.
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
• Prepared root cause analysis for problems occurred.

Duration : December 2010 – Till date.
Title : Process Tracking System.
Client : Liberty Mutual Insurance, US.
Environment: Oracle 10g, SQL PLUS, PL/SQL 2.3.4, TOAD.

Operational Support System - HSBC Bank, UK

The system has centralized database to maintain all relevant information regarding Credit Information. The transaction data will be ported to this centralized database from the branches either through data import or through manual entry. The system allows the user to generate various kinds of reports and queries.

As a Programmer was involved in the following

• Involved in the whole life cycle of the project.
• Interacted with clients to understand their requirements.
• Involved in database design.
• Web page development in ASP which servers as a presentation layer.
• Programmed Packages, stored procedures, queries, and triggers on Oracle 9i.
• Unit and System Testing.

Duration : September 2009 – October 2010.
Title : Operational Support System.
Client : HSBC BANK, UK.
Environment: Oracle 9i, SQL PLUS, PL/SQL 2.3.4, ASP, Javascript, VBscript, XML,
OOAD.

Title: Mondo Electronics - WA, Australia
Description : Mondo Electronics is a leading international business-to-business distributor of electrical materials and safety and other Maintenance, Repair and Operations (MRO) products to electrical contractors in the construction and installation business and industrial users in Europe, North America and the Asia-Pacific region (primarily Australia). We provide these materials and products through our core Professional Products and Services (PPS) activities under manufacturer brand names and also as private brand

Roles & Responsibilities:

Preparation of LLD
Created Procedures, Triggers, Functions and Packages.
Database Query tuning and Implementation.
Unit and System testing.
Understanding the requirements and carrying out impact analysis.
Implementation of the application on Production Server.
Prepared root cause analysis for problems occurred
Involved in resolving production problems for the applications and Ensure all support service level agreements are met

Duration : August 2008 – July 2009
Title : Mondo Electronics
Client : WA, Australia.
Environment: Oracle 9i, PL/SQL, SQL Developer.

Personal Details

Date of Birth: 13/07/1987
Gender: Male
Marital Status: Single
Languages Known: English, Tamil and Telugu (Speak)

Declaration: I hereby declare that all the details furnished above are true to the best

Of my knowledge.



Place: Chennai
Kottaiyaraj Kandhasamy