Oracle Manager

PRAKASH SRINIVASULU

SUMMARY

> Over eight years of IT experience.

> Over six years of Oracle CRM experience(Configurator, iStore, Quoting,

Install base, Order Management and Advance Pricing).

> Three years of experience in development and support of web-based

applications using different technologies.

> Experience in business requirements gathering, GAP analysis, Test Plan

Preparation, Unit testing, Functional Architecture, System Integration

testing, UAT.

> Customization, implementation and support experience in multiple

project cycles.

> Extensively worked in setting up and integrating different oracle

modules.

> Worked closely with Inventory, BOM (Bills of Material), Order

Management, Advance product catalog, General Ledger and other related

oracle modules.

> Extensive experience in customizing JSPs, PL/SQL APIs and designing new

JSPs, PL/SQL APIs. Also customization experience with workflow messages

using oracle workflow builder.

> Used OA framework to customize User interfaces and change some standard

process in OA framework based applications.

> Extensive experience in customizing Oracle order submission process in

iStore according to the business requirements.

> Experience in creating pricing attributes in oracle configurator and

sent it to oracle's pricing APIs.

> Worked on Oracle Configurator developer (OCD) to design and customize

user interface by writing functional companions and extensions.

> Have solid experience in designing, developing, testing and supporting

RDBMS based applications, which involve programming with Oracle PL/SQL.

> Designed functional and technical documents using oracle AIM (MD 50, MD

70) and also implemented new processes based on those documents.

> Strong experience in gathering requirements from users and designing

applications based on those requirements.

> Expert-level skills on technical and functional areas of Oracle Sales

(Oracle Sales Online, Oracle Quoting) and Oracle Service Modules (CRM

Foundation), Trading Community Architecture and iStore.

> Strong experience in J2EE including JSP, Servlets, JDBC, XML, struts,

Oracle 9iAS, Oracle OC4J and Apache Tomcat.

> Worked closely with oracle e-business suite Database schemas (APPS,

IBE, ASO, ONT, INV, AR, GL etc.)

> Strong Technical skills in working with Performance issues in different

application processes.

> Experience in solving problems with 9iAS. Strong skills in solving

oracle session errors.

> Excellent Understanding of oracle's new technologies (10g AS, SOA,

etc.) and changes in them.

> Used Jdeveloper extensively for customization and development purposes.

> Excellent troubleshooting, de-bugging and problem-solving skills.

> Excellent Communication skills with consistent record of delivering in

time and comfortable in leading/working with a team.

SKILLSET

Oracle 11i Oracle Application Modules(Configurator, iStore, BOM,

Applications Inventory, OM, GL, AR)

Languages Java, SQL, PL/SQL, C/C++, Visual Basic

Java Related Oracle ADF, OA Framework, Oracle ADF Business Components,

Technologies JDBC, Java Beans

Internet & Advance JSP, Servlets, J2EE, Java Script, HTML, CSS, SOAP, XML,

Technologies Java/PLSQL Web Services.

Web/Application Oracle 9iAS, Oracle 10gAS, Oracle Components for Java

Servers (OC4J), Java Web Server, Apache Tomcat.

RDBMS Oracle 10g for windows 2000, Oracle 9.x/8i for windows &

Solaris 2.8, SQL Server 2000, MS Access, MySQL.

Tools & IDE's JDeveloper 9i/10g, JDK 1.3/1.4/1.5, JBuilder, Kawa

Enterprise Edition 5.0, ER-WIN 4, PVCS,Microsoft Visio

2002 Professional, Toad

Operating System's Linux (AS 3.0), Solaris 9, Windows XP, 2000, NT

PROFESSIONAL EXPERIENCE

Client Name Motorola, Schaumburg, IL

Oracle Configurator Techno/Functional Consultant

Role Aug 10 to Till Date

Duration Oracle Applications 12.1.2 (Oracle Configurator, Quoting, Order

Modules Management, Advance pricing, Inventory)

Worked extensively on Integration part to import Quote/Orders from

different Externel source systems with oracle apps.

Worked on BOM splitting functionality to enable user to break down a

PTO model at option level to make necessary changes while placing

quote.

Worked on Model publication usage report to be used by external

systems.

Worked on extensions to Quoting APIs to copy over price context

values and parametric data with a new version of quote.

Worked with Web methods team to integrate oracle configurator with

external applications.

Worked on OAF personalization for oracle quoting module.

Responsible for unit testing all product modules and fixing issues

after user acceptance testing.

Responsible for training testers and developers in different areas

of oracle modules.

Client Name ATI Metals (ATI Allvac). Monroe, NC

Oracle Configurator Techno/Functional Consultant

Role May 08 to July 10

Duration Oracle Applications 12.1.1 (Oracle Configurator, Order Management,

Modules Quoting, Advance Product Catalog, Advance pricing, Inventory)

Worked on full life cycle of e-business suite project including

proof of concept, gathering requirements, GAP analysis, setting up

CRM modules (Oracle Configurator, Order Management, Quoting, Advance

Product Catalog, Advance Pricing, TCA structure, GL etc.),

integrating them, Designing and developing customizations of

processes and User Interfaces and support after Go Live.

Worked on complete Order to Cash process for business to business

environment.

Lead and worked with developers and consultants team to implement

the product.

Designed MD 50(Functional design document) and MD 70(Technical

Design document) for oracle's login process customization according

to business requirements.

Worked closely with engineering team on validation process to

determine manufacturing tolerances.

Experience in writing CDL rules and setting up PBC Rules for

different metallurgical items.

Created design charts to determine allowable attributes and

validated with compatibility rules.

Created JSP files to enable user to view and update user selections

for items defined in advanced product catalog and specifications

from external database.

Computed order weight from user input and places it on the sale

order form automatically.

Calculated prices based on product attributes and stored for

advanced pricing.

Responsible for training testers and developers in different areas

of oracle modules.

Client Name Brodart Inc. Williamsport, PA

Oracle iStore Techno/Functional Consultant

Role Sept 07 to April 08

Duration Oracle Applications 11.5.9 (iStore, Order Management, Advance

Modules pricing, Inventory)

Worked on complete Order to Cash process for business to business

environment.

Lead and worked with developers and consultants team to implement

the product.

Designed MD 50(Functional design document) and MD 70(Technical

Design document) for oracle's login process customization according

to business requirements.

Extended oracle's standard shopping cart functionality to save extra

information in order capture schema in the same request.

Designed and developed custom order submission process for grid

level ordering using order management interface structure.

Responsible for creating different sales orders from one shopping

cart depending on profile ids and branch ids at line level.

Responsible for designing a new functionality in oracle pricing for

customers to have freeze price option in shopping cart actions.

Customized Order Manager in iStore using AK developer regions to

display orders based on party ids instead of standard account ids.

Created a new process in shopping cart to price big carts in

background while allowing users to continue working on the store.

Designed and developed duplicate process to show all duplicate items

in a shopping cart and let users take actions to remove them in

bulk.

Customized oracle Session handling technique to remove, merge a

cart, functionality during login process.

Worked on workflow builder to customize seeded workflow messages for

iStore.

Created users and mapped accounts with their user names. Designed

user management page to let user administrators control their

company users at grid level.

Integrated legacy product with oracle iStore to allow users to see

old orders, copy them and compare them with new ones.

Configured 9iAS to enable multiple JVMs to use load balancing for

customers to have a better performance of the designed web store.

Responsible for unit testing all product modules and fixing issues

after user acceptance testing.

Supported CRM modules to make the product stable and to enhance its

functionality with improved performance.

Responsible for training testers and developers in different areas

of oracle modules.

Client Name DentalEZ Malvern, PA

Oracle Configurator/iStore Techno/Functional Consultant

Role Jun 06 to Aug 07

Duration Oracle Applications 11.5.10 (iStore, Configurator, Order

Modules Management)

Gathered requirements from users to design BOM Models for

configurator.

Worked with consultants to setup BOM structure for all PTO BOM

Models.

Responsible for setup and configuration of Oracle Configurator with

different modules.

Responsible for populating BOM models in CZ Schema by running proper

concurrent program provided by oracle.

Designed and developed complicated pricing rules and configured

configurator with those rules to calculate prices depending on some

information gathered from user at runtime. Used oracle standard to

store values in CZ_CONFIG_ATTRIBUTES and pass them to oracle pricing

engine.

Involved in Functional design document(MD 50) and Technical design

document (MD 70) of Configurator Extensions.

Customized Configurator launch JSP in iStore to pass additional

parameters in initialize message and were used in UI Manager.

Used compatibility rules to design some complex business rules also

designed configurator extensions to link those rules with Non BOM

models.

Responsible for displaying prices on Oracle Configurator User

Interface (UI) at runtime by setting up flags in init file and also

using the supported User Interface.

Worked on Some backend validations after user configures a model and

tries to submit an order with invalid configuration.

Tested configurations in the process of Order Management before

booking Orders

Added different types of Configuration rules (logical, numeric,

comparison and, compatibility rules).

Customized iStore Order Submission page to batch validate

Configuration of a model before submitting an order.

Added some functionality in shopping cart page to display Configured

BOM models in a different sequence.

Client Name Plantronics Inc Santa Cruz, CA

Oracle Configurator Techno/Functional Consultant

Role Jan 06 to May 06

Duration Oracle Applications 11.5.10 ( configurator, OM, BOM, Inventory)

Modules

Involved in requirement gathering and Designing of Configurator

models.

Designed best practice BOM models to fit business requirement.

Designed User Interfaces according to the customer needs.

Used OCD to write complex rules using CDL.

Worked with Configurator team to integrate Configurator with a

custom application.

Customized User Interface to get extra inputs from users at runtime

and mapped that information to base modules for calculations

reasons.

Worked with DBAs to make the performance better for complicated and

bigger models.

Responsible for unit testing BOM Models and then worked with users

for UAT.

Helped users to understand different behavior of different models

depending on their selections.

Designed and maintained Referenced models.

Involved in solving post production problems with configurator.

Responsible for training client Employees so that they can support

the product.

Worked on solving decimal quantities problem in configurator.

Worked with Oracle to solve Memory issues when large Models were

loaded in OCServlet.

Designed a user Interface to handle Multiple instantiations of

referenced Models.

Used User properties to select proper inventory items when user

makes a selection.

Used Populators to create child structure for that node.

Client Name Emerson Motors St. Louis, MO

Oracle Configurator/iStore Technical Consultant

Role Jan 05 to Dec 05

Duration Oracle Applications 11i -Oracle Application Framework, iStore,

Modules Advanced Pricing.

Implemented and verified products setup, pricing setup, online

catalog setup, payment types and shipping methods setup, and user

setups for Oracle iStore module.

Involved in configuring the Mandatory Dependencies and Optional

Dependencies for iStore.

Understand and analyze business rules from legacy application

(Configurator) and translate those rules into Oracle Configurator.

Responsible for creating a specialty store for B2B customers in

oracle iStore.

Involved in customization of 11.5.9 oracle iStore application as per

the requirements Created new JSPs and mapped those JSPs to proper

templates to add additional functionality which is not provided by

the 11.5.9 oracle iStore.

Associated Functional companions to the components and products

tested and debugged Functional companions.

Implemented Extensions to incorporate business logic in addition to

the existing rules.

Used Configuration Interface Object (CIO) API to develop custom

objects to interact with Oracle Configurator.

Used IRuntimeNode, IFunctionCompanion and IUserInterface classes to

manipulate active model in UI Manager.

Modified shared cart functionality to handle party relationship

while sharing a cart with another user.

Designed and developed functional companions to implement complex

rules and also to display extra information about the configuration

model on user interface.

Used OA framework development environment in Jdeveloper 9i to

customize standard oracle process.

Developed Java Classes to serve the JSP requests that encapsulate

business logic.

Developed SQL queries and PL/SQL procedures to fetch/Update the data

from the database.

Customized oracle order capture process to handle zero quantities in

a shopping cart.

Customized shipping page to get extra information from users when

they are submitting an order.

Prepared the test scripts for Item attributes, Profile Options and

test cases.

Involved in the testing, debugging and documentation for the entire

application.

Client Name ICICI Infotech

Java Developer

Role March 2003 - Dec 2004

Duration Java, JSP, Servlets, JDBC, oracle 8i, Apache tomcat, JavaScript,

Modules HTML, J2EE

Gathered requirements from users and analyzed them and designed a

web based application using Java, J2EE and xml.

Designed and developed a standalone data access web tier using DAO

factory pattern.

Used web bean controller classes to design business process

according to the requirements.

Developed user interface using HTML and applets.

Developed Java Servlets at server side for handling requests and

responses from the web page, which were developed in JSP.

Involved in coding for developing Java Bean classes, PL/SQL queries,

design of tables for business applications.

Was responsible for writing the Java classes and JSPs for the

application.

Developed code with Java, Servlets, JSP and JavaScript

Involved in coding for JavaScript for client side validations.

Used JDBC and Multithreading for database connectivity with Oracle.

Involved in the documentation and testing of the entire application.

Used HTML, JavaScript interfaces to access data from an Oracle

database.

Involved in the integration of XML with JSPs.

Created User Interactive forms using JSP.

Testing and Debugging and preparing documentation for the new and

existing system

Client Name ICICI Infotech

Java Programmer

Role Sep 2002 - Feb 2003

Duration JSP, Servlets, JDBC, JDK 1.4,,XML,Oracle 8i, Tomcat 4.x, Flash,

Modules HTML, JavaScript

Developed E-Commerce application including shopping cart and remote

maintenance facilities.

Interacted with end users to gather requirements and analyzed them

into technical specifications.

Involved in analysis, design, coding, unit and system testing and

implementation.

Developed the category product template for the display of the

products.

Developed and maintained the shopping flow from the home page to all

the pages, which has products to be purchased as per business

merchant requirement, such as checking the inventory before adding

an item to the cart.

Was involved in front-end design and develop using Flash, HTML, and

JavaScript.

Interacted with users to ascertain program specifications of changes

and/or upgrades.

Developed dynamic web pages using JSP.

Designed and developed server side applications using Servlets,

JDBC.

Used Oracle 8i as the backend database and involved in monitoring

and optimizing the database performance.

Contact this candidate