Objective

Highly qualified and skilled software professional willing to work on the position of PL SQL programmer in a reputed organization where my skills and knowledge of the field will be utilized

More than 3 years ofexperience of programming field with extensive knowledge of programming languages and database management, self-motivated and enjoy working in a team environment, other Competencies are:

• Strong Written and Oral Communication Skills
• Excellent Presentation Skills
• Strong Leadership Skills
• Excellent Interpersonal Skill
• Expertise in Client/Server technology using Developer/2000 Forms 10g & Reports 10g as front-ends with ORACLE 10g as back-end.
• In-depth experience in SQL, PL/SQL, Unix Shell scripts, SQL*Loader, TOAD.

Professional Experience

Confidential, Visakhapatnam.
2010 Feb - Present
PL SQL Programmer

Project 1:

Product : WEB ERP.
Client : Confidential

Duration : Mar 2010-- Till date
Team : 3
Environment: H/W - Sun Server S/W - ORACLE 10g, Developer/2000 for WindowsNT FORMS 10g, REPORTS 10g, PL/SQL Developer 10.1.

Role: Developer

Description
Web Enterprise-wide resource planning (ERP) system is software that attempts to integrate all the business processes of different departments and functions across a company onto a single computer system that can serve particular needs of the different departments. With Web Based ERP Solution, you can accelerate business cycles, improve productivity and reliability, and provide higher levels of service to customers, suppliers and partners.
The purchase order management module in ERP includes material indent, purchase enquiry, supplier quotation, supplier offer analysis, purchase order and order tracking. This module also offers access to approved supplier, purchase order management, purchase enquiry to be floated to multiple vendors on just a click of a button. Purchasing is a very important component of material management module. This module is fully integrated with other module in ERP. The purchase module communicates with other modules to ensure a constant flow of information

Responsibilities:

• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Collecting user requirements by participating in meetings and studying existing system.
• Created database objects like tables, views, Synonyms, stored Procedures and Ref Cursor and packages.
• Monitoring the query performance using explain plans.
• Developed Forms using Forms 10g and custom reports were generated using Reports 10g.
• Code walks through with team lead/end users on regular basis.
• Providing hands-on training for the End users on appropriate screens

Confidential, Hyderabad.
2007 Dec - 2010 Jan.
PL SQL Programmer

Project 2:

Product : RAS (REVENUE ASSURENCE SYSTEM)
Client : Confidential
Environments: H/W - Sun Server S/W - ORACLE 10g, PL/SQL Developer 10.1.
Role : Developer
Duration : December 2007 - Jan 2010.
Team : 5

Description: RAS is essentially a software package for the effective maintenance of the complete revenue for the Electricity Dept., support different local Clients and also from remote nodes on APCPDCL Intranet - with Centralized Server located in the Corporate Headquarters at Hyderabad. Provision for automatic data pickup from the Circle (district headquarter) and for inclusion on Intranet Web-site is also provided. Report Generation module of the package resides on the Central Server for Reports generation as per the requirement of the Corporate Headquarters. The system is integrated with Financial, Personnel, Inventory and other application packages to achieve efficient resource planning for APCPDCL.RAS system is to automate all the transactions at Circle (district headquarter).

Responsibilities:
Database development

• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations
• Loaded Oracle tables from flat files using SQL *Loader.
• Created Cursor, Ref Cursor and user defined data type.
• Creation of Database Triggers for Data Validations.
• Maintained a good rapport with senior programmers
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Preparing test plans and test cases.

Database Administration

• Installed and configured oracle 10g.
• Configured tnsnames and Sqlnet files
• Created schemas, users, profiles and roles.
• Managed users, privileges and roles
• Handling other database servers like Oracle, MS Access.
• Scheduling maintenance jobs and monitoring

Technical Knowledge

• Internet Technologies: HTML.
• Databases: Oracle 8,8i, Oracle 9i, PL/SQL 10.1, MS-Access v7.0, Oracle 10g.
• Programming Languages: C, C++.
• GUI Tools : Visual Basic v6.0, Developer 2000, Designer 2000,Forms 10g, Reports 10g.
• Operating Systems: Windows 98/95, Windows NT/XP, UNIX, Linux.
• Applications : MS Office 2000 ,MS Word , MS Excel, MS Access, MS PowerPoint, MS Project , Toad, SQL *Loader.

Education

• Master's Degree of Computer Science