Oracle Sql
Resume:
Kameshwari
OracleApplication Consultant
Professional Summary
> Having 9+ years of experience in Information Technology primarily in
Oracle. Diverse experience in areas of Software Design, Requirement
Analysis, Estimation Scope, Application Development, Testing,
Implementation, User Training and support of Client/Server,3-Tier
and ERP based applications using Oracle eBusiness suite 11i.
> Extensive experience with CRM Modules and extensively worked/working
on Install Base, Service Contracts,Order Management
> Tremendous technical expertise and strong background in developing new
customization, interfaces, table design and development of Custom
modules, Oracle Core Contracts, AP, AR,OM,GL and INV. All aspects of
Application Object Library and Sysadmin.
> Extensive domain expertise in General Insurance and General Ledger and
extensively worked on the Insurance domain and General Ledger module.
> Responsibilities handled include business requirement analysis, onsite
co-ordination, system design, support, development, end-to-end
testing, Very strong hands-on exposure to SQL, PL/SQL, SQL*Plus,
Workflow, and Developer 2000 (Forms 6i and Reports 6i) .Oracle 9i on
Windows and UNIX platforms, shell scripting SQL* Loader
> Proficient knowledge and a good experience on Oracle Database
Performance Tuning. Tuned complicated Queries using hints, analyzing
and optimizing the queries .Generating trace files and understanding
explain plans and implementing the best optimized plans for tuning the
queries to execute in less time .
> Good experience of analyzing the business requirements, developing
technical design documents and coordinating with developers and
offshore the work.
> Expertise in developing interfaces, customizations, extensions,
conversions and reports using Oracle Standards, Tools and APIs.
> Extensively worked using Workflow & PL/SQL in Oracle Applications
modules
> Extensively worked on interfaces, conversions using PL/SQL Oracle
Application modules.
> Extensively worked on PL/SQL Procedures, Packages, Functions, Triggers
and other database objects using SQL and PL/SQL. Involved in Pre/Post
Production Support work.
> Given hands on session on Performance Tuning .
> A highly motivated, energetic, and professional team player with
excellent analytical, problem solving, communication and interpersonal
skills.which helped consistently in achieving excellent results and
meet client expectations at all times.
Technical Expertise: ERP (Oracle)
Packages : Oracle e Business Suite R11i
Modules: OM, INV, Insurance, Finance (GL), CRM
(Service Contracts /Install Base)
Database: Oracle 8i/9i/10g
GUI: Web PLSQL, OA Framework & JSP
Programming Language: C, C++, SQL, PL/SQL, JAVA, Shell
Scripting
Web Technologies JSP, VBScript, Java Script
Tools: SQL Loader, TOAD, JDeveloper, 9iAS,
Workflow and Discoverer
Operating System: Windows, UNIX, Linux.
Data Modelling MS Visio
1
Education Qualifications
> M.C.A from Osmania University, Hyderabad (Year 1999) with 1st Class
> B.Sc (Elec) from Andhra University, Visakhapatnam (Year 1996) with 1st
Class.
Projects Profile
1
Cisco Systems,California,USA
April 2006 -till date
CIBER- PMC (Contracts Install Base and Entitlement Repository -Performance
Metrics Central )
Module Lead
Project Description : CIBER (Contracts, Installed Base and Entitlement
Repository) is a complex, Oracle 11i-based, infrastructure environment
housing all Service Contracts and installed base equipment. CIBER supports
all sales related Service Contract activities including creating,
modifying, renewing and terminating Service Contracts. It contains business
rules for interfacing between Service Agreements and the Installed Base.
Performance Metrics Central (PMC) is an "one-stop-shop" location for Cisco
and Partners to review and manage partner's support operation performance
on key Cisco Channel and CA partner programs (e.g. Channel Certification,
CA Shared Support and Operational Excellence) for a maximum profitability.
Performance Metrics Central provides on-line comparative
(competitive) operational support data, performance metrics and metrics
detail to encourage support partners to achieve best in class support
performance as well as allowing monitoring of performance requirements.
Responsibilities:
. Co-ordination with client for the requirement and reviews and gathered
the requirement from the client and translated the business details into
Technical design.
. Generated PL/SQL Packages, Functions and Procedures to implement the
Business Logic.
. Used Bulk collect,bind variables,Ref cursors
. Created database triggers for data security.
. Had thorough understand of highly normalized/back-end intensive data
model.
. Loaded Historical data from Legacy System into PAC(Performance
Attribution, Contribution and Measurement Application).
. Wrote Integrity Checks, Data Cleansing scripts, SQL Queries to fetch
data from multiple tables using Joins that produced Reports & Logs.
. Proficiently developed Functional Requirement Documents, Design
documents, Test Cases and Project documentation (user guides, standard
report instructions, demos).
. Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the
Data repository using cursors, UTL File I/O and Exception handling.
. Use SQL*Loader to load data from various sources into an Oracle database.
. Developed shell scripts for batch processing and database transactions.
. Developing and Customizing PL/SQL Programs for Oracle Integration.
. Created database objects like Tables, Synonyms, Views, Indexes, and
Sequences.
. Tuning SQL Statements and PL/SQL Packages, Triggers, Functions and
Procedures.
. Involved in Designing and developing Oracle Reports for various modules.
. Application Testing and Documentation of up-gradation Oracle 9i to 10 g.
. Analyzing and Tuning Database 10 g.
. Release Co-ordination; co-ordinating with Biz,QA and Release Management
team.
. Emergency Bug Fixes (EBF),For biz showstopper critical bugs that
requires an immediate resolution in production
. Analysis of the specifications provided by the clients
. Handling Major /Minor Enhancements.
. Maintenance and Production Support to the application in resolving the
bugs.
. Mentoring and supporting the team in resolving the issues.
. Tuned complicated queries using hints,generating trace files and
analyzing the issues .
. As a lead responsible to collect the statistics and communicate to the
client.
. Involved in preparing the daily status reports on the work allocation
. Responsible to help the team in technical aspects to meet the dead lines
. Responsible for end-to-end testing of various components which involve
the complete cycle
Environment: Shell scripting,Oracle 9i PL/SQL,Oracle Applications
11.5.10 Financials, Inventory, OM, CRM, Workflow, OA Framework, Java,
Linux, PL/SQL, Oracle Reports.
Premia (GL) Product : (Orion (GL) (ERP) Nov'04 -
April'06
Description : Orion is an Integrated Enterprise Information system
designed and developed by 3i INFOTECH Ltd to meet the requirements of
ministries, government organizations and large multi-company organizations.
Orion has been designed & developed in Oracle 8 RDBMS environment with
backend procedures and packages developed using SQL, PL/SQL, Forms
6i/Reports 6i as front end and later converted to Oracle 9i RDBMS with
front end Forms 9i /Reports 9i. The salient features of Orion are
1. Completely Menu-Driven.
2. Comprehensive user definable menu features.
3. Exhaustive parameterization of default values to minimize data entry.
4. Facility as batch posting of transactions.
One of the systems of Orion Product is
General Ledger is the major module of any ERP Product. Integration
of entire accounts of an organization will be made in GL module. GL
module includes Cash module, Bank module, and Journal module.
Responsibilities: As a Team Lead and as a team member, was responsible for
. Enhancement, design and development
. Enhancement in some of the modules like Bank Reconciliation Master forms
like employee master, Let-out property master, Deposit master,
Transaction forms like Cheque Printing, Bulk Processing (Pay Batch), TDS
Certificate Generation & Printing, Cheque Dishonor, TA, LTA, Claim
Payments/Receipts, Pay slip Generation Process, Monthly Process
. Developed Back end procedures, functions and packages, triggers using
SQL, PL/SQL
. Used Bulk Collect,Ref cursors
. Support to the team members in resolving the issues .
. Support to the client
. Generating various GL Oracle Reports in 9i and XML publisher.Developing
reports using backend packages.
Environment : Oracle 9i,PL/SQL, TOAD,Forms 9i /Reports 9i,Oracle 9i AS,Windows 2000
Premia 10i (Reports)
Mar '04 - Oct'06
Description: PREMIA 10i is a product for Insurance. Insurance domain
mainly focused on Underwriting & Claims. Underwriting is a module
for creating Policies. A claim is a module to process claim against
a Loss/Damage/Risk. Hence all major reports developed based on these
modules. Considering U/W, Policy Schedules & Premium related reports
are the major classifications. Claims module categorized into claims
reported, claims paid, outstanding claims & age wise analysis..
Contribution: As a Team lead/ Team member responsible for
. Development of policy schedule reports for various products
. Standard reports like premium register for Underwriting Module,
. Standard reports for the Claims Module in processing claims against a
risk/loss/damage for the various class of business.
. Handled complex reports
. Support to the team in resolving the issues.
Environment : TOAD,Oracle 9i,PL/SQL, Reports 9i, Oracle 9i AS, Windows
2000
Premia 10i(Re-Insurance) Jan '04 - Feb'04
Description : PREMIA 10i is a global solution for General Insurance. It's
basically a product developed for Oriental Insurance Comp. Ltd .
This product can be applicable to any of the General INSURANCE
domains. Well integrated with all the modules like Underwriting,
Claims, and Accounts & Re-Insurance.
4
Responsibilities : As a team member responsible for
6 Development of various master forms, transaction forms Procedures,
packages for the module.
7
Environment : Oracle 9i,PL/SQ,TOAD,Forms 9i /Reports 9i,Oracle 9i AS,Windows 2000
Defence Research and Development Organization
IMIS (Code Generation)
Oct'02 - Dec'03
Description : This system involves generating a code for an item after
inspecting, verifying and posting the code in the ledger according to
the classification of the item. There are different cases of ledger
postings like Expense,Rate Contract, Credit Purchase etc .for various
items which are categorized into consumables and non consumables .The
consumables are charged and expensed .
Responsibilities : As a team member responsible in
. Conversion of forms 4.5 to forms 6i
. Analysis, Design, coding and unit testing of the application .
. Created various forms for the various types of vouchers like expense
vouchers, transfer vouchers, external issue vouchers etc.
. Developed reports for Inventory, consumable and non-consumable, etc.
using Reports 6i.
Environment : Oracle 8i, PL/SQL, Forms 6i/Reports 6i, Windows 2000
Defence Research and Development Organization
IMIS (Mail Information System )
Aug '02 - Sep'02
Description : The system is meant for the maintenance of the incoming
and outgoing of all kinds of mails received and sent for all types of
modes for the project. The application is designed basically for their
internal project maintenance.
Responsibilities: As a team member responsible in Design, development and
unit testing of software and developed various reports
Environment : Oracle 8i, PL/SQL, Forms 6i/Reports 6i, Windows 2000
Defense Research and Development Organization
IMIS (Inspection Report)
April'02 - July'02
Description : The application is developed for the maintenance of the
items procured after the procurement process and before the payment is made
.The application is designed by maintaining a code for the item procured
after the item is inspected
Responsibilities: As a team member responsible in Design, development and
unit testing of software and developed various reports.
Environment : Oracle 8i, PL/SQL, Forms 6i/Reports 6i, Windows 2000
Defence Research and Development Organization
IMIS (Library Information System )
Jan'02 - Mar'02
Description : The application is developed for the maintenance of the
library. The books are classified into reports, journals, and
specifications, documents etc .They are categorized into secret,
unclassified, restricted & confidential. A particular code is assigned for
each book which are divided into respective subjects like reference books,
technical books, non-technical books etc.
Responsibilities: As a team member responsible in
. Design, Development and testing of software.
. Developed various forms, reports in 6i.
. Converted forms 4.5 to 6i and reports 2.5 to 6i.
Environment : Oracle 8i, PL/SQL, Forms 6i/Reports 6i, Windows 2000
Defence Research and Development Organization
IMIS (Resource Management System)
Nov '00 - Dec '01
Description : This module was designed and developed in Oracle 7.3 RDBMS
environment with forms 4.5 /reports 2.5 as front end and later converted to
Oracle 9i database and front end with forms 6i and reports 6i. The system
is divided into three modules.
1. Resource Plan Identification of components, components reflecting
directorate, work centre, the milestone, system, subsystem for which they
have produced.
2. Procurement.
3. (a) Proposals - Fresh proposals, agreed in principle proposals,
deferred proposals, Cancellation of proposals, Recommended to higher
board.
(b) Sanctions - Generating Sanction code,
Cancellation of sanctions, Enquiries on sanctions.
(c) Demands - Raising Demands, Enquiry letters to vendors,
receiving
Quotations, generating comparative statements.
(d) Supply Order- Generating supply order, IRIV, Inventory work
center wise and holder wise.
(e) Payments - Partial/Final payments to the received
goods.
3. Budget Management Allocation of budget, Expenditure in the Present
year, Estimation for the next year.
Responsibilities : As a team member responsible in
. Design, Development and unit testing, bug fixing.
. Developed reports for the various stages in the procurement process
and for the
. Budget management for the financial year expenses, allocation, sub
allocation of budget for the project.
Environment : Oracle 7.3, PL/SQL, Forms 6i/Reports 6i, Windows 2000
Defence Research and Development Organization
Simulation of Tracking Instruments
Oct '00 -Nov '00
Description : The aim of the project is to provide a comprehensive
platform to simulate various tracking instruments, given a target
trajectory. The user can specify position in latitude, longitude and
altitude, noise characteristics, tracking time, track loss information of
the tracking instrument and flight azimuth of the target. This software
generates track data as seen by the tracking instrument. This involves
interpolation, co-ordinate transformation, frame conversion, noise
generation and injection and format conversion. This software is also
developed as a set of classes using inheritance, operator overloading,
polymorphism and templates.
Responsibilities : Design and development of the simulation of the tracking
instruments.
Environment : Sun Solaris 7.0, C++, Motif, Visual Workshop 5.0
Defence Research and Development Organization
Naval Defence System
Aug'00 -Sep '00
Description : This system is developed to defend against naval
attacks. This project involves data acquisition from tracking instruments,
threat computation and display in real-time. This software is developed as
a class library, inheritance and operator loading is used. This software
takes some control points of path of the ship and interpolates to generate
data with 1 sec interval.
Responsibilities: Development of software, which would simulate the motion
of a target ship and generate data.
Environment : Red Hat Linux 6.2, C++
Defence Research and Development Organization
Range Safety System
June '00 - Jul '00
Description : This system is meant for protecting the people and
property that come under the flight range against damage, when a missile
is under test flight. This software is executed off-line to compute the
destruct contours in tangential plane taking worst turn rates of the
missile. This software is developed in C++ as a class library and can be
used for any such application.
Responsibility: Developed software for computation of tangential destruct
contours..
Environment : HP UX 9.0, C++
Contact this candidate