Oracle Project
Resume:
Kavitha H Shivaiah
Cell+1-516-***-****
*******.********@*****.***
PROFESSIONAL SUMMARY
. 11 years of total IT experience, currently working as a Technical
Consultant on Oracle Applications design and development, database
programming, Performance Tuning and Optimization using Oracle SQL &
Oracle PL/SQL, Oracle Forms & Reports, web-adi, BI publisher, Tuning
and Optimization.
. Experience on implementation, rollouts, integration, migration
projects.
. Well-versed with all the phases of Software Development Life Cycle
(SDLC). Has worked on various offshore and onsite projects for
manufacturing and distribution industry clients.
. Well experienced in technical and functional systems analysis &
design, systems architectural design, presentation, process interfaces
design, process data flow design, and system impact analysis and
design documentation and presentation.
. Excellent technical skills and very good domain knowledge on Oracle
financials (AR, AP, GL), Supply Chain Management system (OM, BOM,
Purchasing), asset operations (Inventory, Advance pricing).
. Very good communication skills and a good team leader and a team
player.
TECHNICAL SKILLS
Programming SQL, PL/SQL
Languages
ERP Oracle Applications 11i, R12
DBMS Oracle 8i/9i /10g
GUI Oracle Forms 4.5/6i/9i, Oracle Workflows,
Web-adi
Reporting Tools Oracle Reports 6i/9i/10g and XML publisher
Operating Systems UNIX, Win 2003/XP/2000/NT, MS DOS
Miscellaneous VSS, PVCS, Kintana, MKS, Clarity, Quality
Centre
EDUCATION
Bachelors of Engineering in Electronics and Communications from
Visweswaraiah Technological University.
Professional Experience
R12 Implementation for Diebold Inc. Dec 2013 -
Mar 2014
Company: Infosys Ltd.
Diebold is implementing Oracle Applications eBusiness Suite R12 globally to
handle its Finance, Procurement, Sales, Distribution, Logistics, Services
and Planning operations. This implementation will be carried out on a new
instance in phased manner. The first phase of implementation will include
core Finance implementation for US, Canada and Brazil, and it will
subsequently be rolled out to other geographies and business functions in a
phased manner.
The identified master and transactional data needs to be brought into the
new R12 instance from the existing Oracle R11i production instance and
different other data sources (Legacy systems). In order to ensure a smooth
and seamless transition, data from the existing system will be migrated
into the new system at the time of cutover. This document covers the
Migration Strategy for converting the data from the existing system(s) into
new system.
Role: Technical Consultant
Responsibilities:
. Oracle to Siebel integrations analysis
. Interface strategy and integration detailed design
. Technical design for various data element interfaces, code review and
documentation
. Coding and unit testing the external interfaces
. Performance review and tuning of interfaces, conversion components and
reports
. Review implementation and high-level plans defined at each milestone
. User training and user manual/hand over document preparation.
. Integration testing between Siebel and oracle through middleware
. Data load testing and data conversion from the legacy systems
. Coordination with offshore team for build and unit testing cycle
. Coordinating with users and client IT team for design and code review
and acceptance testing.
. Attending solution design meeting and evaluate available tools and
technologies to implement the solution.
. Actively involved in analysis and POC preparation that would
contribute to decision making. Documenting and publishing finalized
tool along with pros and cons and approach of implementation.
Software: Oracle Applications 12i, Oracle 10g, SQL, PL/SQL, TKPROF
EBS R12 Implementation for Arrow Electronics Apr 2008
- Dec 2013
Company: Infosys Ltd.
Arrow Electronics is a global provider of products, services and solutions
to industrial and commercial users of electronic components and enterprise
computing solutions. Headquartered in Melville, New York, Arrow serves as a
supply channel partner for approximately 800 suppliers and 130,000 original
equipment manufacturers, contract manufacturers and commercial customers
through a global network of more than340 locations in 53 countries and
territories.
The projected revenue of the project is over $ 350 million. The team size
is approximately 300 members who are located at various client locations
worldwide and at the India development center. (Hong Kong 25, Germany 25,
UK 30, USA 60, India 160).
Arrow Electronics Project is a business transformation and Enterprise
Resource Planning (ERP) implementation project for the Global Components
Division of Arrow Electronics. The goal of this project is to standardize
the processes followed by different subsidiaries of Arrow Electronics and
to bring them to a common IT platform globally.
Role: Technical Consultant
Responsibilities:
. AS-IS and Requirement gathering
. Technical design and documentations
. Coding and unit testing of RICE components
. Reviewing of designs and testing functionalities
. Performance review and tuning of the interfaces and conversion
components
. Data conversion and data sync interface design
. Price file and parts data load and conversion activity and periodic
data sync
. Coordination with offshore team for build and unit testing cycle
. Ensure adherence of each of her projects and deliverables to the
overall program timelines and maintain quality in reporting from each
of her teams
. Coordinating with users and client IT team for design and code review
and acceptance testing.
. User training and review sessions with client IT team.
Software: Oracle Applications 12i, Oracle 10g, SQL, PL/SQL, WEB-ADI,
TKPROF
HDS EBS 11i to R12 Upgrade Jan 2008 -
Apr 2008
Company: Infosys Ltd.
Hitachi Data Systems (HDS) has engaged Infosys Technologies Ltd (Infosys)
to partner them in Upgrade of its 11i EBS system to 12i. The scope of the
project was to upgrade the 11.5.8 system to 12.04 and bring in all the
customizations to the upgraded system. Rolling up all the second EBS system
of 11.5.7 system used for Europe region to the upgraded solution.
Role: Technical Consultant
Responsibilities:
. Pre upgrade analysis and estimation
. Customization upgrade plan and design
. Upgrading custom components manually and add to higher version of
standard RICE
. Offshore co-ordination
. Reviewing of designs and testing functionalities
. Integration and documentation.
. Post upgrade customization for client specific requirements
. Customization of workflows, reports and interfaces
Software: Oracle Applications 12i, SQL, PL/SQL, BI Publisher, Workflows
HDS Finance and Logistics Rollouts Aug 2006-
Dec 2007
Company: Infosys Ltd.
Hitachi Data Systems (HDS) has engaged Infosys Technologies Ltd (Infosys)
to partner them in the rollout of Oracle Applications, Release 11i for
China, Israel and India Subsidiary. This rollout involves implementing the
Account Receivables, Payables and Logistics modules for a new Subsidiary on
ROW.
Existing HDS operations are setup along with HDS Hong Kong & HDS Taiwan
under HDS HK OU of Oracle Applications. The new HDS Subsidiary is being
setup under New HDS Operating units of Oracle Applications.
Role: Technical Lead
Responsibilities:
. Designing the Technical specs specifications and pseudo code.
. Customization of the existing interface programs according to the
technical document.
. Developing new reports and interfaces to meet the specific
requirements of the operating units.
. Review of RICE components and testing of the custom functionality.
. Integration Testing and documentation.
Software: Oracle Applications 11i, SQL, PL/SQL, Oracle Forms 6i, Oracle
Reports 6i, Workflows 4.5
SOX Compliance for Brocade Oct 2005 -
Jun 2006
Company: Wipro Technologies
SOX i.e. Sarbanes Oxley Compliance is basically for segregation of duties
of the users of the application. This includes the restricting the un-
authorized access to the data to the users by the assigning the proper
responsibility users and menus to the respective responsibilities from the
application end.
Role: Functional Consultant
Responsibilities:
. Conducting Question and answer sessions with the users to understand
the current system, the functionality and the business flow
. Understanding the current system and gather requirements from the IT
users for the user requested customizations
. Preparation of functional and technical specifications
. Detailed design documentation and prototype demo documents
. Review of RICE components and testing of the custom functionality
. User training and assisting in user unit testing
. Integration with the custom components and preparation of test scripts
to test end to end functionality of the system
Software: Oracle Applications 11i, Oracle 9i, UNIX, SQL, PL/SQL
ROI Supply Chain Logistics (H3G) Jun 2005 -
Sep 2005
Company: Wipro Technologies
Sonopress will be managing the Warehousing and Logistic functions
for Hutchison 3G Ireland Ltd. Hutchison 3G ROI requires that the ROI Oracle
Inventory module act as a "mirror" to the Sonopress Warehouse system. ROI
Oracle SOM will be receiving dispatches, inventory movements and return
inspections from Sonopress or UTL as per the requirement. To serve the
above requirement the point to point interfaces are customized.
Role: Developer
Responsibilities: As a team member, I am dealing with
. Designing the Technical specs specifications and pseudo code.
. Understanding the current system and gather requirements from the IT
users for the user requested customizations
. Preparation of functional and technical specifications
. Detailed design documentation and prototype demo documents
. Review of RICE components and testing of the custom functionality
Software: Oracle Applications 11i, Oracle 8i, SQL, PL/SQL
SES Scheduling AMAT Jan 2005 -
May 2005
Company: Satyam Computers
The main objective of this project is to extend the
slotting functionality to the departments and also decommissioning of a
division. Here a partially confirmed order for a future business item is
taken from the user and the item if released to manufacturing. The above
process is called soft slotting. Later the Order is confirmed by the user
the sales order is booked. After the order is booked it is firm slotted by
the Order Management super users. Then the item is billed and shipped. This
slotting functionality which was limited to PBG level was extended to the
departments.
Role: Developer
Responsibilities: As a team member, I am dealing with
. Initial setups for OM and OSM modules.
. Integration testing of scheduling activity.
. Tested Data Validations and Documentation.
. Preparing training documents and User manuals.
. Interacting with onsite co-coordinator for functional queries.
Software: PL/SQL, SQL, FORMS 6i, SQL*Plus, SQL Navigator
Oracle11i Upgrade project for CISCO Systems Oct
2004 - Dec 2004
Company: Satyam Computers
This project involved ASIS migration of 11.0.28 version
of Oracle Apps objects to 11.5.9 version of Oracle Apps. This upgrade
involves conversion of forms, which are in form4.5 version to forms6i
version using a tool flint60, fixing up the errors that were given during
the conversion process. Standard, Custom and cloned Objects of OM, OSM and
Inventory modules where upgraded to 11i. This process included up gradation
of custom forms from 4.5 to 6i by application of flint60 to the lower
version forms whereas the up gradation of the cloned forms included an
extra process of application of changes manually to the higher version of
standard forms. The reports and libraries were compiled in the higher
version and placed in the appropriate 11i top directories.
Role: Programmer
Responsibilities: As a team member, I am dealing with
. Preparation of Technical Document.
. Development work and code migration to integration and user testing
environments
. Preparation of test data and loading of required setups
. Testing - unit testing. And preparation of test scripts and results.
. Defect monitoring and analysis and fix during integration and UAT
Software: Oracle 8i, PL/SQL, Developer 6i, SQL*Plus, SQL, SQL Navigator
Quote-To-Cash Migration project for CISCO Systems Jun
2004 - Sep 2004
Company: Satyam Computers
The Cisco 11i QTC initiative is aimed to integrate and enhance
Cisco's Enterprise Resource Planning (ERP) backbone to create a more agile
business structure decrease total cost of ownership and improve customer
satisfaction using Oracle 11i technology. The QTC business flow will
integrate, enhance and streamline Cisco's Quoting, Ordering, Order
Management, Pricing, Fulfillment and Financial systems, leading to
increased productivity, improved customer experience and seamless, global
business processes. Cisco has its applications currently running on Oracle
Applications Release 10.7.
Role: Programmer
Responsibilities: As a team member, I am dealing with
. Analyzing the existing Objects (Oracle Apps 10.7, forms 2.5).
. Preparation of ASIS Document and Technical Document.
. Development work
. Testing - unit testing & integration testing
. Preparation of UTC
. Responsible for overseeing the Quality procedures related to the
project.
. Interacting with onsite co-coordinator for functional queries.
Software: Oracle 8i, PL/SQL, Developer 6i, SQL*Plus, SQL, SQL Navigator
Division Ticketing System for KSRTC Dec 2003 -
May 2004
Company: India Satcom Ltd.
This module was designed mainly to extend the ticketing feature
of the depots to the divisions. Here the different hierarchies of the
administrating unit and the accounts divisions where finely integrated to
form a system that could manage the division level ticket consumption and
the accounting information related to it.
Role: Programmer
Responsibilities: As a team member, I am dealing with
. Analyzing the existing Objects (Oracle Apps 10.7, forms 2.5).
. Preparation of ASIS Document and Technical Document.
. Development work
. Testing - unit testing & integration testing
. Preparation of UTC
. Responsible for overseeing the Quality procedures related to the
project.
. Interacting with onsite co-coordinator for functional queries.
Software: Oracle 8i, Reports 2.5, PL/SQL, SQL, FORMS 4.5, SQL*Plus, SQL
Navigator
Goods Inwarding Module Sep 2002 - Nov 2003
Company: RMS Technologies.
This module was designed mainly to extend the ticketing feature
of the depots to the divisions. Here the different hierarchies of the
administrating unit and the accounts divisions where finely integrated to
form a system that could manage the division level ticket consumption and
the accounting information related to it.
Role: Trainee
Responsibilities: As a team member, I am dealing with
. Analysis of the specifications provided by the clients
. Design and Development of reports
. Customization of existing forms of depots and making them compatible
to division
. Testing - unit testing & integration testing
. Preparing Technical specifications and unit test plans/results
Software: Oracle 8i, PL/SQL, SQL, Developer 2000, SQL*Plus
Contact this candidate