Oracle Software Engineer
Resume:
RESUMERECORD:
NAME: SEKHAR BIJJALA
CITY: MALDEN
STATE: MA
ZIPCODE: 02148
EDUCATION:
EMAILADDRESS: ********@*******.***
PHONEAREACODE: 781
PHONENUMBER: 388-1026
LASTUPDATED: 6/28/2001
RESUME: Sekhar Rao Bijjala
email : ********@*******.***
781-***-**** (home) before 9AM or after 8 PM only.
EXPERIENCE SUMMARY
* Over Six years of experience in Software Installation and Software Development in the
area of Design, development and implementation of software packages.
* Expert level skills in Oracle 8.0/7.x/6.0 Database Administration activities such as:
* Database creation .
* Database Security Administration.
* Database performance tuning.
* Configuring the database.
Database Space Management
* Database design and development.
* Database Backup and Recovery Methods
* Installed Oracle Financials, Manufacturing and Human Resources on HP-UX 10.20 and
Solaris 2.5.
* Worked as Oracle Financials DBA and also as Oracle Financials System Administrator for
one year.
* Specialized in Oracle 8.0, Oracle 7.3 and Oracle 7.0, Forms 4.5, PL/SQL, Reports 2.5.
* Good knowledge of Shell Scripts, Power Builder 4.0, Solaris 2.5, HP-UX.
* Installed Oracle 8.0 on HP-UX 10.20.
* Migrated the data from Oracle 7.3 to Oracle 8.0.
4GL/RDBMS
SQL*Plus, PL/SQL, SQL*Menus, Watcom SQL., Oracle 6.0/7.x, Foxpro
DATABASE FRONT ENDS
Oracle Reports 2.5, Oracle Graphics 2.5, Oracle Forms 3.0/4.0/4.5. Visual Basic 5.0
OPERATING SYSTEMS AND LANGUAGES
HP-UX, Solaris 7, Sun O/S
MS-DOS, UNIX, Windows NT 4.0, MS-Windows 3.x, Windows 95, C, C++, Pascal, Basic, FORTRAN,
Assembly language, PRO*C.
HARDWARE
HP9000, Sun Solaris 2.x, Unisys 6000, Pentium, IBM PCs, HCL-MAGNUMPROFESSIONAL EXPERIENCE
03-98To Electronic Press Services Group (subsidiary of DIGEX INC)
till date Cambridge Boston MA 02142
Oracle web DBA and Installation Maintenance
Hardware: SUN
Software:Solaris 2.5,Oracle 8, Oracle 7.3.2, Oracle 7.3.4
Installing Oracle software on remote machines and tuning them, and administering
the applications that run by Oracle Web Server and also Installed Oraperl which interacts
Oracle database server with the applications. In this project I installed Oracle software
and created Databases of size min 5 GB on 15 solaris machines.
Maintaining the datacenter with more than 120 databases with 24x7 support.
01-97 To HCL Consulting Ltd.
02-98 Oracle Applications System Administration
Hardware: HP-9000
Software: HP-UX, Oracle 7.1.6, Oracle Applications 10.6.1 and 10SC
Maintaining the Oracle Applications modules, creating users, the responsibilities, work
shifts, assigning user profiles and responsibilities to users, monitoring the users,
registering the printers, printer styles, managing the concurrent managers and Application
DBA duties like creating Oracle user IDs and maintaining Oracle database objects.
Responsibilities:
* Administering, securing and tuning the Oracle Applications.
* Helping the developers in registering new application modules and new user defined
database objects to Oracle Application Library.
* Solving the problems and errors that occur during the development time.
* Making aware of architecture of Oracle Applications to new developers, taking separate
logical backup of crucial database objects during their development.
Involved in the installation of Oracle Applications in DEMO, CRP, PRODUCTION databases.
Utilized the tools adaimgr, adrelink, adctrl, adpatch which are supplied by Oracle
Corporation. Update the Release 10.6 to Release 10.6.1. Configuring the parameter file and
tuning the database as per the requirements.
Responsibilities:
* Gone through the architectural differences between Oracle Applications Version 10.5 and
10.6.1.
* Planning the size of the database, tablespace, datafiles and setting default storage
parameters for tablespaces and rollback segments.
* Setting the instance parameters (majority on SGA size) and testing them.
* Contacted 2 times Oracle World Wide support when I faced difficulties and took the
advice. I have been working as Oracle DBA since from April 96 till now.
12-94To Kernex Micro Systems (I) Pvt. Ltd., STP, Hyderabad
12-96Senior Software Engineer
Hardware: Pentium, Sun
Software: Oracle 7.0/7.1 (Forms 4.5), Solaris 2.5, SQR 3.0
DBA Tool for Oracle 7.0
This is a GUI based Database Administrator tool for Oracle 7.0 being developed to surpass
the in-built character based SQL * DBA Tool. Aimed at simplifying all DBA activities and
improving the speed.
Responsibilities:
* Designing the product in similar lines to SQL * DBA.
* Creating and configuring the database.
* Session related activities like connecting to and disconnecting from the database.
* Instance related activities like startup, shutdown, mounting and opening the database.
* Performance monitoring activities using Data Dictionary Tables and Views.
Stock Invest Scheme in Banks
This package takes care of the enrolling the stock investors and automatic calculation of
interest amount depending on the number of shares allotted to the investor.
Responsibilities:
* Design and development of the project.
* Implementation of the project.
Materials Management
This project uses bill of materials, automatic generation of material requisition slips
whenever the material level falls below Re order Level (ROL). The gross material needs are
determined by referring to the bill of materials and multiplying the components quantity
per by the planned production quantity. This quantity is then compared to the
expected availability of the component items on the date of need. When shortages are
detected requisition is raised.
Responsibilities:
* Design and development of the system.
* Implementation of the project.
Pro-Intercept Reports (Client : Mediagenic Software inc. Chicago, USA.)
This is a MIS package consisting of 100 reports. SQR 3.0 is a front end tool like Oracle
Reports and is the fastest report generator, any database can be used its backend. In this
package we used SQR 3.0 for generating some pharmaceutical reports which are having
thousands of records and Oracle 7.0 as its backend.
Responsibilities:
* Generation of reports.
* Creation and configuration.
11-92 To Protech Software Development (I) Ltd., Hyderabad
12-94Senior Software Engineer
Hardware: PC-486
Software: Oracle 7.0/6.0 ( Forms 4.0/3.0, Reports 2.0 ), Windows NT, Fox Pro
Stores Accounting System
Stores Accounting System provides on-line stock status. It covers stores requisition
entry and posting, stores return entry and maintenance, stock adjustment voucher entry and
maintenance, bincode CR entry and maintenance, perpetual inventory schedule/calendar,
perpetual inventory entry and maintenance and MIS on stock status.
Responsibilities:
* Design and development of the system.
* Implementation of the system.
Hospital Information System (HIS)
HIS is designed to take care of all activities of an hospital administration & patient
information like patient sensitivity to various drugs, infections, investigations carried,
diagnosis etc. HIS also maintains surveillance of infections in various wards to help
microbiology department to control them.
Responsibilities:
* Coding and testing the system.
Payroll System
This package generates payslips employee wise, department wise, total organization wise.
Responsibilities:
* Design and development of the system.
* Implementation of the system.
Library Information System
The library system is designed to take care of all activities of the library like book
issues, returns, overdues etc. Also maintains bibliography of articles. All these
activities are on-line.
Responsibilities:
* Coding and testing the system.
Financial Accounting System
The system helps in the maintenance of the general ledger. The entries from cash book,
purchase register, sales register and journal based on the information from this ledger.
Responsibilities:
* Design and development of the system.
* Implementation of the system.
EDUCATION
B.S ( Electronics and Communication), 1992.
Email : ********@*******.***
Contact this candidate