Sql Developer

Kishore Kumar Vakiti

Email:*.**************@*****.***,

Phone: +91-897*******(India)

CAREEER PROFILE

Software professional with 3.5 years of experience as Oracle

(PL/SQL) Developer, possess excellent analytical, organizational, planning

skills. Proven ability of working in highly demanding and challenging work

environment with ever increasing expectation of client and delivering best

of quality software solutions has been the focal point of my professional

career.

. Good Experience in Oracle SQL, PL/SQL.

. Good Knowledge in trapping runtime errors by providing Suitable

Exception Handlers.

. Excellent knowledge in views, materialized views and indexes.

. Extensive experience in developing Stored Procedures, Functions,

Database Triggers and Packages.

. Extensively worked in Oracle SQL, PL/SQL, Created database objects

like Tables, Views, Constraints, Indexes, Synonyms and Sequences.

. Developed complex SQL queries including Sub queries, correlated

queries and set operators.

. Created views and indexes as per the requirement.

. Excellent knowledge in cursors, inner join, outer join, cross join.

. Excellent knowledge in Ref cursors.

. Involving in providing KT to new joining.

. Enthusiastic about learning new concepts in emerging technology.

. Experienced in coding of Core Java.

Professional Experience:

. Working as a Software Engineer for CGI, Bangalore from March 12 to

till date.

. Worked as a Software Engineer for Symmetric Info Systems Pvt Ltd.,

Bangalore from May 10 to Feb 12.

Educational Summary:

. Bachelor Degree in ComputerScience (B.Sc (Comp))-2008 from Acharya

Nagarjuna Univerisity, Andhra Pradesh, India. With 58.5%.

Technical Summary:

Programming Languages Core Java, SQL,

PL/SQL,JDBC,Servlets

Databases Oracle 9i,10g

Tools SQL*Plus,PL/SQL Developer,Toad,SQL

Devloper

Web HTML,Java Script

Operating Systems Windows family.

Work Experience:

Project-3:

Project Name : Credit Suiss Devlopment

Client : CREDIT SUISS

Database : Oracle 10g

Role : PL/SQL Developer

Environment : SQL, Pl/SQL

Duration : Sep 2012 to till date

Scenario:

Credit Suiss Bank will take a new shape and explore like never

before. Using the solution the bankers and account holders can generate

various kinds of reports.For the account holder's convenience and on hand

information, this solution provides certain searching and checking features

for his account. The account holder can any time and any number of times

can log on and search for various details as the account's balance, details

of transactions, interest amounts, debits / credits, etc.

As a Developer responsible for the follows -

> Written sql queries, PL/SQL programs.

> Created Packages/Functions/Procedures/Queries.

> Key responsibilities includes conversion of source data into required

format using a set of Oracle SQL scripts created using SQL, PL/SQL

programming.

> Created PL/SQL functions to facilitate business functions and

calculations.

> Created Tables, Sequences, Views.

> Written stored procedures, functions and triggers using PL/SQL.

> Involved in Design Reviews and Code Reviews, Coding, Unit Testing,

Supporting Testing Personnel, Client, preparing Unit Test Cases for

the Modules.

> Documentation like Technical Design specs, Installation instructions.

Project-2:

Project Name : RHC

Client : Royals Health Club

Database : Oracle 10g

Role : PL/SQL Developer

Environment : SQL, Pl/SQL

Duration : July 2011 - Aug2012

Scenario:

Royals health club offers various packages that can be taken by the members

of the club. The health club owns instruments for exercise. Certain

instruments are allowed in certain packages only.According to their

packages taken by the members of the club were offerd

instruments for exercise.

As a Developer responsible for the follows -

> Responsible for coding in SQL, PL/SQL.

> My role in this project is analysis of existing functionality and

customization of existing functionality to achieve the new

functionality.

> Key responsibilities includes conversion of source data into required

format using a set of Oracle SQL scripts created using SQL, PL/SQL

programming.

> Created Tables, Sequences, Views.

> Created PL/SQL functions to facilitate business functions and

calculations.

> Writing SQL Queries, Procedures, Triggers, and Packages using

PL/SQL.

> Developed SQL Queries to obtain specific information as per client

requirement.

Project-1:

Project Name : MaGnet Development

Client : O2 UK

Database : Oracle 10g.

Role : PL/SQL Developer

Environment : SQL, Pl/SQL.

Duration : May 2010 - June 2011.

Scenario:

O2 UK leading Telecom Service provider with services in GSM, CDMA, Fixed-

line, Broad-band and with strong customer base of over 6.5 million. The

Project implements Billing System for all Lines of Business. These Plans

can generate mobile and landline calls. The call types are mobile call,

direct dial call, SMS, Music or Video download etc. The details of calls

made by customers using these phone numbers are recorded.

As a Developer responsible for the follows -

> Developed sql queries to obtain specific information as per

requirements

> Responsible for providing new

Packages/Functions/Procedures/Queries.

> Scheduling and developing the business validation constraints.

> Developed Packages to extract the data from base tables into flat

files by using UTL_FILE package.

> Analysis of existing functionality and customization of existing

functionality to achieve the new functionality.

> Key responsibilities includes conversion of source data into required

format using a set of Oracle SQL scripts created using SQL, PL/SQL

programming.

> Converting the client requirements into deliverables.

Signature

(Kishore

Kumar)

Contact this candidate