We provide IT Staff Augmentation Services!

Oracle Resume

Schaumburg, IL

SUMMARY

  • Over Nine 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 Applications:

Oracle Application Modules(Configurator, iStore, BOM, Inventory, OM, GL, AR)

Languages:

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

Java Related Technologies:

Oracle ADF, OA Framework, Oracle ADF Business Components, JDBC, Java Beans

Internet & Advance Technologies:

JSP, Servlets, J2EE, Java Script, HTML, CSS, SOAP, XML, Java/PLSQL Web Services.

Web/Application Servers:

Oracle 9iAS, Oracle 10gAS, Oracle Components for Java (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

Confidential,Schaumburg, IL
Oracle Configurator Techno/Functional Consultant
Aug 10 to Till Date
Oracle Applications 12.1.2 (Oracle Configurator, Quoting, Order 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.

Confidential,Monroe, NC
Oracle Configurator Techno/Functional Consultant
May 08 to July 10
Oracle Applications 12.1.1 (Oracle Configurator, Order Management, 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.

Confidential,Williamsport, PA
Oracle iStore Techno/Functional Consultant
Sept 07 to April 08
Oracle Applications 11.5.9 (iStore, Order Management, Advance 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.

Confidential,PA
Oracle Configurator/iStore Techno/Functional Consultant
Jun 06 to Aug 07
Oracle Applications 11.5.10 (iStore, Configurator, Order 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.

Confidential,Santa Cruz, CA
Oracle Configurator Techno/Functional Consultant
Jan 06 to May 06
Oracle Applications 11.5.10 ( configurator, OM, BOM, Inventory)

  • 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.

Confidential,St. Louis, MO
Oracle Configurator/iStore Technical Consultant
Jan 05 to Dec 05
Oracle Applications 11i -Oracle Application Framework, iStore, 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.

Confidential,
Java Developer
March 2003 - Dec 2004
Java, JSP, Servlets, JDBC, oracle 8i, Apache tomcat, JavaScript, 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

Confidential,
Java Programmer
Sep 2002 – Feb 2003
JSP, Servlets, JDBC, JDK 1.4,,XML,Oracle 8i, Tomcat 4.x, Flash, 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.

Hire Now