Oracle (Oracle PL/SQL Developer)/1Years/Bangalore

CURRICULUM VITAE

LOKESH N.D

Phone: +91-886*******.

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

Objective:

To excel in the industry and to serve the company to my fullest capabilities taking up challenging assignments, enhancing interpersonal skills, sincerity, team spirit and correctness at work place that would lead to the fulfillment of personnel and corporate goals.

Facilities Management

• Having around 1 years of experience in software development using Oracle SQL, PL/ SQL (including Procedures, Functions, Triggers, Packages)

• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.

• Sound knowledge in Oracle 10g/ 9i & PL/SQL programming.

• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.

• Analyzing of SQL statements using EXPLAIN PLAN to improve the performance.

• Comprehensive Application development experience using Oracle Forms and Reports.

• Having good analytical and programming capabilities.

Experience Summary:

Team : Purchase Order System

Designation : PL/SQL Developer

Client : BrainEye InfoTech Pvt Ltd

FirstGlobalSoftware

Jul 2010 – Till Date.

Key Roles & Responsibilities:

• Collected User Requirements by participating in meetings and studying existing System.

• Creating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using Oracle Designer.

• Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures, function, packages, Cursor, Ref Cursor and Triggers.

• Inolved in analysis, design, coding and Testing.

• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.

• Front End Screen was developed using Forms 9i.

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

• Used SQL LOADER to upload the information into the database.

• Used Explain Plan for query optimization.

• Created Database design and converting them into database objects.

• Wrote test cases and performed Unit testing.

• Involved in writing Technical Specification Documentation.

Technical Skills Summary:

• Languages : SQL , PL/SQL , C , HTML.

• Databases : Oracle 10g/9i.

• Tools/ Utilities : Sql*Loader, Forms& Reports.

• Operating Systems : Windows (XP/NT/Server 2008 family), Ubuntu .

Educational Background:

• Degree : Bachelor of Engineering

• Branch : Telecommunication Engineering

• Institute : K.S Institute of Technology, Bangalore

• University : Vishveshwaraya Technological University, Belgaum.

• Year of passing: July 2010

• Percentage : 58%

Personal Details:

Name : Lokesh N.D

DOB : 06-12-1985

Sex : Male

Languages known : English,Hindi,Kannada,Telugu,Tamil

Address : # 968, 9th Cross, 2nd Main, SBM Colony,

Girinagar 4th Phase, Bangalore – 560085.

Contact Number : +91-886*******.

E mail : ***********@*****.***

Declaration:

I hereby declare that the above written particulars are true to the best of my knowledge and belief.

Date:

Place: Bangalore (Lokesh N.D)

Contact this candidate