Rajeswari
[Send email using form at bottom]
Mobile No: 9490647679
Summary
3+ years of strong experience in analysis, design, development and deploying
Business solutions using Oracle Technologies
Extensive experience in developing applications using tools like oracle Forms
10g/9i/6i, Oracle Reports 10g/9i/6i and Oracle database 10g/9i/8i, on
Windows/Unix Environment.
An Oracle developer with extensive experience in data transformations,
conversion and interface, data loading, database modeling and performance
tuning.
Strong Coding and Designing Experience in Oracle PL/SQL & SQL.
Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e.
Packages, Stored Procedures, Functions & Triggers using SQL Developer as
development tool.
Extensive experience in Performance Tuning of SQL queries & Views using
Explain Plan
Extensive experience in Creating and maintained Database Objects like Tables,
Views, Materialized views, Indexes, Constraints, Sequence, Synonyms.
Strong technical hands on experience in Oracle 10g/9i/8i databases.
Expert in using Oracle Export, Import.
Extensively involved in all the phases of SDLC (Software Development Life
Cycle).
Ability to meet deadlines and handle pressure in coordinating multiple tasks
in a work/project environment. Strong communication, organizational and
interpersonal competencies along with detail-oriented and problem solving skills
in the technology arena.
Ability to work individually as well as in a team with excellent problem
solving and trouble-shooting capabilities.
Self-motivated and committed person with excellent interpersonal communication
skills and willingness to learn new tools, concepts and environments
Experience
Worked as Oracle Reports Developer with
CibersitesIndia Pvt Ltd, May2006 to May2007 Bangalore.
Worked as Software Programmer with Jute Mills (S/W Division),Nov2004 to
May2006
W.G.Dt, and AP.
Worked as Trainee Programmer with NIC, W.G.Dt, and AP.
Education
MCA (Master of Computer Application) from Andhra University.
BSC (Bachelor of Science in Mathematics, Physics, Chemistry) from Andhra
University.
Professional Training / Courses
PGDPC Certificate from ICSS,AP
Technical Expertise
Operating Systems DOS, Windows 9x/NT, Unix
RDBMS Oracle 7.3/8I/10G R2
GUI Development Oracle Forms 6I, Reports 1***-1.2. [Send email to request phone number] , Visual Basic 6.0
Languages SQL, PL/SQL, Java, C++, C, TOAD, Unix
Web Technologies HTML
Projects Executed
Project One: Polk (www.polk.com)
Duration:12 Months
Project Description:
The latest, most reliable fact-based information on whats selling and whos
buying
Is accessible via a secure website 24/7 from any location. Polk Insight lets
users at
All levels of your organization analyze and interpret a wide variety of Polk
Intelligence
Including new, used and VIO registration statistics, and sales combined with
demographic information.
Role in the Project:
Developing the reports, and uploading them to the Share Point, entering into
PMRx if there any issues.
Meeting with end user, collecting requirements and converting into technical
specification.
Developed Server side PL/SQL (Stored Procedures, Functions & Packages) for
implementing complex business logic.
Created and customized analytical reports for existing system using Reports
10g.
Converted data from legacy system to Oracle 10g using and PL/SQL programs.
Responsible for tuning of SQL queries written in procedures/functions at the
back end which are called from the front end forms.
Created scripts to load data from external system to oracle & created
discoverer report based on this.
Responsible for developing new reports using Oracle Discoverer Desktop/Plus
10g.
Involved in Technical Documentation, Unit test, Integration Test and writing
Test plan.
Technology Used:
Front End: Oracle Report Builder
Back End: Oracle 10g R2
________________________________________
Project Two: Inventory and purchase System
Duration: Jan2005 to May2007
Project Description:
Its a combination of Purchase and Stores Departments.
Overall it contains
o Purchase orders maintenance system
o Stock maintenance
o Ledger Processing
Purchase order maintenance system is maintaining Purchase Orders. This system is
the automation of stores activities. User department raises requisition for
items. If the item is available in stores, a stores issue voucher is raised and
an item is sent to user department otherwise a purchase requisition is sent to
purchase department. Purchases department send enquiries to the vendor and
receive quotations. Based on quotations, an order is raised and sent to the
vendor. Vendor sends the material with invoice to the stores. A good(s) receipts
is raised and material is sent for inspection. Rejected material is sent back to
the vendor.
Stock maintenance is maintaining stock, which is necessary for organization.
Ledger processing is maintaining monthly accounts.
Role in the Project:
Writing SQL queries
Creating Forms
Creating Reports
Writing cursors, triggers, functions, procedures
Creating Packages
Technology Used:
Oracle 8i, D2K & Windows NT
Project Three: Dispensary and Outpatient Monitoring System.
Project Description:
The aim of this project is to maintain the outpatient registration and
Dispensary Transaction.
It also deals with the attendance of staff.
The Out Patient Registration deals with the registration of patients
who need the services it includes
New registration, revisit, modification and old revisit of
patients.
Dispensary deals with the medicine transactions. Patients either
inpatients or outpatients will take
Medicines from here. It includes Master stock and Drug
issues.
Role in the Project:
Writing SQL queries
Creating Forms
Creating Reports
Writing cursors, triggers, functions, procedures
Technology Used:
Oracle 8i, D2K, Windows NT
|