CURRICULAM VITAE

Srikanth Varala

Email Id: acescm@r.postjobfree.com

Mobile:+919*********

Professional Knowledge:

Over 4.3 Years of experience in analysis, design and development of commercial applications using

Oracle10g/11g SQL, PL/SQL .

Good Experience in writing SQL Queries (SQL Functions, Conversion Functions, Group Functions,

Miscellaneous Functions, Data Integrity (constraints), Joints, Sub Queries, Indexes, Sequences, Views).

Exposure to OLAP Features (ROLLUP Option, CUBE Option, GROUPING Function, DECODE Function,

CASE Expression, Materialized Views, Analytical Functions).

Managing Tables, Views, Sequences.

Exposure to Object Oriented Concepts (Object Types, Object Tables, User defined Data types, REF DEREF Function, Object Views).

Good programming knowledge on PL/SQL.

Extensive experience in developing Stored Procedures, Functions, Views, Cursors and triggers.

Technical Skills:

Operating Systems : UNIX, Windows

Languages : SQL, PL/SQL(9i&10g)

Database : Oracle 10g/11g, MS Access

Database Client : SQL Developer, SQL*Plus, Toad

Developer 2000 kit : Forms and Reports(10g)

Scripting Languages : Unix Shell Scripting

Professional Experience :

Working in Va Cdat IT Systems Pvt Limited as a software engineer from August 2013 to till date.

Worked in SQL Star International Limited as Oracle consultant from Sep- 2011 to July-2013.

Worked as a programmer in Infocomm Techonologies from apr-2010 to Aug-2011.

Academics:

Completed M.C.A from Sri Kottam Tulasi Reddy Memorial College Of Engineering affliated to JNTU-

Hyderabad in 2008 with an aggregate of 73%.

Work Experience:

Working in Va Cdat IT Systems Pvt Limited as plSQL Developer from August 2013 to till date.

Project Name : Pulp and Paper Industry Pension Plan(PPIP)

Client : Multi Employer Benefits Services Inc.

Role : Team member

Technologies : ORACLE 10g PLSQL,FORMS and REPORTS(10g&11g)

Description:

The primary objective of the Pulp and Paper Industry Pension Plan (the Plan) is to provide retirement

income to employees in the pulp and paper industry covered by a collective agreement between their employer and the

Pulp Paper and Woodworkers of Canada (PPWC) or the Communications Energy and Paper workers Union of Canada

(CEP). The Plan also provides benefits in the event of death or termination of Plan participation.

Roles and Responsibilities:

Involved in migration of this project from Oracle 6i to Oracle 11g.

Worked on moving the plSQL code from form level to database level.

Involved in D2K development.

Involved in creation of database packages.

Involved in moving the procedures and functions from 6i to 11g.

Created procedures to generate the Reports in text files using SQL queries.

Worked on calling the procedures, functions and packages in form level using Forms 11g.

Added new columns to the database Tables and renamed the columns

Project Name: Northern Employee Benefit System

Role : team member

Description:

Northern Employee Benefits Services (NEBS) is a member owned, not-for-profit Corporation that sponsors an insurance

and health care benefits plan and a pension plan for public sector employees in the north.

Roles and Responsibilities:

Involved in Migrating the project from Oracle Forms 6i to 11g

Working with Oracle 11g Reports (Migrating from 6i to 11g)

Creating text file for Reports using using UTL_FILE package

Creating procedures and functions in the form level

Working for production support.

writing SQL queries as per the requirement

Worked as consultant as a Oracle consultant from sep- 2010 to July-2012.

Project Name : Payrole system

Role : PLSQL Developer

Technologies : ORACLE 10g PLSQL,FORMS and REPORTS(10g)

Description:

Payrole System is designed for employees who is working in organization i.e monthly drawing amount .

Roles and Responsibilities:

Involved in designing the layout of Forms

Involved in creation of stored procedures, functions, views and cursors.

Managing Tables, Views, Sequences.

Generation of Daily basis, Weekly basis, Fortnightly Report, Monthly Report, Quarterly Report, Yearly Report

using Report Developer .

Creation and storing The Files using Utl_file Operations.

Worked as a Programmer in InfocommTechnologes from apr-2010 to aug-2011.

Project Name : Order Booking systems

Role : Team Member.

Technologies : ORACLE 10g PLSQL

Description:

The main objective of the project is to develop an Internet based Order Booking

System where the Salesmen would connect to a Central System for Online Order Booking.

Roles and Responsibilities:

Facilitate design and development of a web application for an online order booking Service such that

it aims at speeding up the order booking process

Provides instant order booking such that delays and inaccuracies are avoided.Up-to- Date information about

orders placed and delivered online can also be maintained through this system

Designing Form Layouts

Involved in creation procedures and functions and packages.

Ceritifications:

Oracle Certified associate 10g(SQL&plSQL).

Personal Details:

Name : Srikanth Varala

Gender : Male

Languages Known : Telugu and English

Nationality : Indian

Declaration:

I hereby declare that above mentioned information is correct to my Knowledge.

Date:

Place: Hyderabad Srikanth Varala

Contact this candidate