Sql Oracle

Sai Tejaswini Kasturi

Cell: +** – 738**-***** ****************@*****.***

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.

ACILITIES MANAGEMENT

F

• Having 1+ year 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.

• Having good analytical and programming capabilities.

PROFESSIONAL EXPERIENCE

15) Currently working as a Software Analyst in Zen3 Info Solutions India Limited at Begum pet in

Hyderabad from Feb2013.

16)

17)

Technical Skills:

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

• Databases : Oracle 10g/9i.

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

• Operating Systems : Windows (XP/NT/Server)

18)

PROJECT EXPERIENCE

Client : Beat The Broucher, UK

Database : Oracle 10g/11g

Role : PL/SQL Developer

Description:

Beat the broucher offers the customers the very best priced travel services available on the internet for many

destinations worldwide. Beat The Brochure is part of Truly Travel Ltd with offices based in London boasting

a team which has grown to close to 200 experienced staff since our formation in 2004.

Beat the broucher exclusive relationships and bulk buying power with the leading tour operators such as

Thomson, Thomas Cook, JMC and First Choice etc as well as leading accommodation suppliers, airlines and

car hire companies, means that it can pass the most competitive prices available in the UK travel market to

the valued customer.

Key Contributions:

19) Analysis of the specifications/requirements provided by the client..

20) Collect, compile and analyze data from various databases and perform statistical analyses

21) Entering data into analytical software programs and scrutinizing the information for patterns.

22) Provide consultation, recommendations and technical assistance to clients.

23) Creating E R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using

Oracle Designer.

24) Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures,

function, packages, Cursor, Ref Cursor and Triggers.

25) Involved in analysis, design, coding and Testing.

26) Involved in modifying various existing packages, procedures, functions and triggers according to the

new business needs.

27) Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from

the database.

28) Used SQL LOADER to upload the information into the database.

29) Used Explain Plan for query optimization.

30) Created Database design and converting them into database objects.

31)

32)

33)

Educational Background:

• Degree : Bachelor of Engineering

• Branch : Computer Science Engineering

• Institute : Akula Sree Ramulu Institute of Engineering and Technology

• University : JNTU Kakinada University,AP

• Year of passing: 2012

• Percentage : 66.7

34)

OTHER DETAILS

PERSONAL DETAILS

Father’s Name : Mr. Siva Ram Kasturi

Gender : Female

Marital Status : Single

Date of Birth : 26 Aug 1991

Language Proficiency : English, Telugu

Declaration:

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

Date:

Place: Hyderabad (Tejaswini Kasturi)

Contact this candidate