We provide IT Staff Augmentation Services!

Oracle Techno-functional Consultant Resume

Keene, NH

SUMMARY:

  • 18 years of experience in areas of Development, Design, Analysis and Testing Implementation of business applications with special emphasis on Oracle Applications E - Business suite of products.
  • Worked in implementation, Upgrade and Support of Oracle ERP Applications/EBS (12i/11i /11.0.3) across various modules which includes Order Management, Inventory, Purchasing, Quoting, Advanced Pricing, BOM (Bill of Material), Oracle Configurator, Oracle Service Contracts, Oracle iStore, Receivables, General Ledger, Payables, AOL and System Administrator modules.
  • Working as Oracle EBS Techno-Functional Consultant and performed on various roles involving solution architecture, design & development and well-versed in all areas of the implementation life-cycle including Planning, Requirements Gathering, Gap Analysis, Configuration, RICEW Development, Testing, User and Production Support.
  • Hands-on involvement in business requirement, GAP analysis, POC (Proof of Concepts), process mapping, solution design, configuration, setups, work arounds, interfaces, user .
  • Having experience on Quote to Cash and Service contracts integration with Oracle CPQ cloud base system to Oracle R12 Applications.
  • Hands-on involvement in Oracle iStore, iReceivables and iSuppliers integration with Oracle Portal. And worked on Oracle iStore new user registration process and integrating the custom applications for E-Contact, e-Licensing and eSoftware applications in order to perform quote to Order cycle.
  • Depth experience on converting a Quote (Oracle iStore and Oracle Quote) to an Order, integrate advanced pricing and configuration solution, re-designing the order entry and upfront validation process for fulfilling their order life cycles using Oracle R12. And also having good experience in day to day operation/application site support experience in B2B Transactions process like, Deliveries(Oracle ASN -Advance Shipment Notice and Ship Stage), RMAs - Return Material Authorizations, Purchase Orders and Receipts and Inventory Sync between Warehouse Management (3PL/ RedPrairie and Oracle WMS) and Oracle R12 Application systems.
  • Having the experience on integration between Oracle ERP and Supplier Collaboration Tool (E2OPEN) to communicate the Net Demand, Booked Sales Orders (BOC), Purchase Orders, PO Receipts, On-hand balances from the ERP system to the Suppliers in Forecast to procure process.
  • Extensive experience with Quote to Order to Cash, Warehouse Management and Procure-to-Pay modules.
  • Extensively worked in RICEW components (Reports, Interfaces, Conversions, Extensions and Workflow) using Oracle Forms, Oracle Reports, XML-Publisher, Confidential ustom PLL's, Form Personalization, OAF Page Personalization, PL/SQL, SQL, SQL* LOADER and Workflow builder.
  • Developed functional and technical specifications as well as test plans and test scenarios using AIM Methodology.
  • Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, EXPLAIN PLAN and etc.
  • Good at sysadmin and AOL activities including creation of KFFs, DFFs, Lookups, users, responsibilities, menus, concurrent programs, request sets, request groups, value sets.Experience in various development tools like SQL Developer, Toad, SQL*Loader,10g/9i, Forms 10g/6i, Reports 10g/6i.
  • Expertise in various Import and Export utilities like SQL LOADER and UTL FILE.
  • Substantial development experience in creating Oracle stored procedures, PL/SQL Packages, Triggers, Functions, Indexes and Views.

SKILL:

Exposure: SQL/PLSQL, RDF Reports, XML, Customization of Forms, Interfaces, Conversions using Standard Oracle APIs, XML/Java based Interface Programs, Order Management, Advanced Pricing, Inventory, OAF

Domains: Oracle Applications (R12/11i /11.0.3) Modules like OM, Inventory, PO, BOM, Pricing, Shipping, Oracle WMS, Quoting, contracts, Configurator, iStore, GL, Payables, AR AOL, Sys Admin.

Programming Languages: Oracle SQL, PL/SQL

Tools: Oracle Developer 2000(Forms 6i /10g, Reports 6i/10g), Oracle Workflow builder, SQL*Loader, SQL*Plus, SQL Developer, Toad, XML Publisher, Confidential Rational Doors, HP Quality Center 11, HP Portfolio and Project Management and Clear Case

EXPERIENCE:

Confidential, Keene, NH

Oracle Techno-Functional Consultant

Responsibilities:

  • Responsible for requirement gathering, Business Process Analysis, Mapping the Business Requirements to the Oracle Applications, doing the POC (Proof of Concepts), writing the development requirements, designing the technical documentations.
  • Did Oracle R12.2.3 Application Implementation
  • Implement the complete solution for OM, PO, WMS and Pricing modules for the factory warehouses of CSWG and integrating EBS with the SOA.
  • Defining the WMS Rules for Picking, Put away and Label Printing.
  • Customization of the WMS Label Printing as per the client business.
  • Developed the program for WMS LPN Reusability using the purging logic.
  • Creating Inbound and Outbound Interface for Items to have sync with EBS and Legacy systems.
  • Automated the complete Pick release to Shipping process using standard APIs in a OTM environment.
  • Worked on PO Receipts creation and correction process for Random Weight and Non-Random weight Products.
  • Integrate the legacy system to Oracle EBS by acting as Oracle SME to complete the field mapping between the two systems
  • Participate in CRP meetings.
  • Coordinate with Oracle support for issues, monitor oracle SRs for any oracle related issues.

Environment: Oracle Applications R12, ORACLE 10g, TOAD 9.0.1, forms, Reports, workflow and SOA 11g.

Confidential, Schaumburg, IL

Techno-Functional Consultant

Responsibilities:

  • Responsible for requirement gathering, Business Process Analysis, Mapping the Business Requirements to the Oracle Applications, doing the POC (Proof of Concepts), writing the development requirements, designing the technical documentations by using the DOORS tool (Telelogic DOORS 8.3 version), preparing the test scripts and co-coordinating the onsite and offshore team members for developing and testing the objects.
  • Worked on Setup Configurations in OM and Advance Pricing(QP) modules, including Flex Field Values & Value Sets, OM Order Types, defaulting rules & Workflows, Applying & Releasing Holds, Credit Checking Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes Defining Modifiers, Qualifiers, Pricing Formula Defining Standard, Internal, RMA and Drop shipment Orders Define Pick Release, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
  • Involved in designing and developing of Conversions, Interfaces, Forms, Alerts, Reports and extensions for Order Management, Configurator, Advanced Pricing and Quoting/iStore modules.
  • Providing the time estimates and efforts required to design and deliver the objects.
  • Involved in designing and developing of Oracle iStore integration with Oracle Portal process.
  • Worked as a coordinator between onsite and offshore team members in the respective objects for designing, developing and testing.
  • Worked on POC (Proof of Concepts) for business requirements to integrate the legacy systems (MOL and REC) with Oracle Applications.
  • Worked on Sales Order Interface with batch valid configuration process and attaching the short text type notes for header and lines.
  • Worked on Oracle Pricing Engine interface for providing the customer price, discounts, promotion items and pricing agreements from Oracle Application to the MOL legacy system.
  • Worked on E-contract, e-licensing and eSoftware custom applications in order to perform quote to Order cycle.
  • Worked on iPortal Integration for providing the iStore, iReceivables and iSuppliers application access to the external users.
  • Support during various testing phases of the project as System Integration Testing, CAT and regression testing.
  • Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).
  • Involved in coordinating and assisting the users in User Acceptance Testing.

Environment: Oracle Applications 12i, ORACLE 10i, TOAD 9.0.1, forms, Reports, workflow and SOA 11g.

Techno-Functional Consultant

Confidential Inc

McAllen, TX, USA

Description: Confidential is known around the world for innovation and leadership in wireless and broadband communications. It is a Fortune 100 company with global presence and impact. Confidential is in the process of implementing the Oracle Order Management and Supply Chain Transformation project for centralizing all its operations. It involves integrating various applications and third party tools to create a global Order Management solution using Release 12 of Oracle Applications.

The scope of the work is to support the B2B transaction fulfillment process in Trilogy Project at McAllen, TX Site.

Responsibilities:

Daily base identify the following pending issues related to the McAllen site Confidential B2B transactions and finding the root cause of those issues in their Oder fulfillment process and addressing them to corresponding team to get resolved those issues between RedPrairie/3PL and Oracle R12 Application systems:

  • Confidential B2B Transactions at McAllen site:
  • Deliveries - Oracle ASN (Advance Shipment Notice)
  • Deliveries - Ship Stage.
  • RMAs - Return Material Authorizations
  • PO - Purchase Orders and Receipts
  • Inventory Sync between Warehouse Management 3PL/RedPrairie and Oracle R12 Application systems.

Assist in creation of processes and procedures for accurate and timely reporting.

Actively participate in Daily Cadences to concentrate on the McAllen Delivery B2B Issues.

Interface daily with key stakeholders.

Working closely with Supply Chain End users and Warehouse Management (3PL/ RedPrairie and Oracle WMS) teams to support in day to day B2B operations.

Sync between 3PL/ RedPrairie and Oracle R12 Application systems

Assist users with issue resolutions and actively resolves issues independently during the Order fulfillment process (in Oracle Application R12 end).

Performs Operations analysis (like Fit/GAP Analysis) on various Business Requirements by using the Oracle AIM Methodology and identifying the gaps and provides the corresponding solutions to develop.

Involves in upfront validation process for fulfilling their order life cycle processes to execute the project effectively. And also involves in designing and developing solutions in the enhancements of the current phase of the project.

Assist users in closing moth end and Quarter End activities as part of Post Go-Live support.

Involves in various Functional, System Integration, Regression and Customer Acceptance testing phases.

Environment: Oracle Applications 12i, ORACLE 10i, TOAD 9.0.1, forms, Reports, workflow and SOA 11g.

Zebra Technologies Corporation

Lincolnshire, IL

Oracle Techno-Functional Consultant

Zebra Technologies is primarily engaged in the business of marketing and distribution of barcode printing solutions. Headquartered in IL but they have a global presence, their distribution centers are located in North America (NA), Europe (EMEA) and Asia Pacific (APAC).

Zebra Technologies has recently acquired a division of Confidential solutions (EVM) called Symbol technologies Inc. With this acquisition both companies are getting integrated in to one.

Zebra Technologies needs to exit the EVM system and this IT project is called the Trilogy Exit Project. The first phase of Trilogy Exit Project is enabling APAC region and the second phase covers the NALA & EMEA regions.

Responsibilities:

Responsible for requirement gathering, Business Process Analysis, Mapping the Business Requirements to the Oracle Applications, doing the POC (Proof of Concepts), writing the development requirements, designing the technical documentations.

Did Oracle R12.2.3 Application Implementation

Implement the complete solution for OM, PO, Inventory, and Pricing on Oracle ERP modules for handling the Net Requirements (Which includes Sales Orders, Purchase Orders, PO Receipts, On Hand Balances, Safety Stock and ASN) and Commit Write back requirements in Forecast to Procure process to integrate the Supplier Collaboration Tool (E2OPEN) with Oracle ERP.

Working on Supplier Sourcing Rules, Approved Supplier list setup configuration in PO.

Working on Inbound and Outbound Interfaces for Net Requirements and Commit Writeback for Items, POs, ASN, PO Receipts and Booked Sales Orders to have sync with Oracle EBS and Supplier Collaboration Tool called Trading Partner Collaboration systems.

Working on GBPA (Global Blanket Price Agreement) Price Update extension.

Integrate the legacy system to Oracle EBS by acting as Oracle SME to complete the field mapping between the two systems

Participate in workshop meetings for gathering requirements and etc.

Environment: Oracle Applications R12, ORACLE 10g, TOAD 9.0.1, forms, Reports and workflow .

Oracle EBS Techno-Functional Consultant

Confidential Solutions Inc

Chicago, IL

Confidential is known around the world for innovation and leadership in wireless and broadband communications. It is a Fortune 100 company with global presence and impact. Confidential is in the process of implementing the Quote to Cash integration with Oracle CPQ cloud base system to Oracle R12 Applications(existing Greenfield project) for enable a single digital quote to sales order and contract creation for APX models, service and warranty items. This project is executing under the agile methodology.

Responsibilities:

Involves on process mapping, configuring applications, technical design, development and customizations of RICEW Components.

Did Oracle R12.2.6 Application Implementation

Working on RICEW components (Reports, Interfaces, Conversions, Extensions and Workflows).

As part of integration between Oracle CPQ Cloud based system and Oracle R12 Applications worked on Sales Order interface, Oracle Service Contracts and master d Confidential interfaces.

Authoring various documentations - Mapping sheets and Migration documents.

Involves in various unit, functional, system integration and customer acceptance testing phases.

And responsible for cutover activities for Go-Live and post production support.

Environment: Oracle Applications R12, Oracle CPQ, Mule Soft, Oracle APEX, forms, Reports and workflow.

)

Oracle Techno-Functional Consultant

Midmark Corporation

Ohio, USA

Midmark Corporation is a global manufacturer and supplier of healthcare products, equipment and diagnostic software for medical, veterinary, and dental markets. Headquartered in Dayton, Ohio, Midmark maintains production and administrative offices in Versailles, Ohio, as well as seven other locations in the United States and international subsidiaries in India, Italy and the United Kingdom.

Responsibilities:

Involves on process mapping, configuring applications, technical design, development and customizations of RICEW Components.

Did Oracle R12.2.6 Application Implementation

Authoring various documentations - MD70 and MD120 using Oracle AIM Methodology.

On time delivery of RICEW Components using oracle development tools and utilities such as Oracle Forms, Reports, Workflow, SQL, PL/SQL, D Confidential Loader, XML, BI Publisher and UNIX.

Verify assigned 11i extensions are R12 compliant and remediate where required.

Working on RICEW components (Reports, Interfaces, Conversions, Extensions and Workflows).

Involves in various unit, functional, system integration and customer acceptance testing phases.

And responsible for cutover activities for Go-Live and post production support.

Environment: Oracle Applications R12, OAF, forms, Reports and workflow.

Oracle Techno Functional Consultant

US Concrete, USA.

Hyderabad, India

Role: Working as a Technical Consultant in US Concrete Project Impact Project, involved in designing and developing of Interfaces, Forms, Alerts and Reports for Financial modules.

Responsibilities:

Worked on PO Documents Interface.

Worked on Item Creation Notification Alert.

Worked on AR Receipt Form Customization.

Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Environment: Oracle Applications 12i, ORACLE 10i, TOAD 7.6

Techno-Functional Consultant

Confidential Inc,

Schaumburg, IL,

Responsibilities:

Requirement gathering, Business Process Analysis, Mapping the Business Requirements to the Oracle Applications, doing the POC (Proof of Concepts), writing the development requirements, designing the technical documentations by using the DOORS tool (Telelogic DOORS 8.3 version), preparing the test scripts and co-coordinating the onsite and offshore team members for developing and testing the objects.

Involved in designing and developing of Conversions, Interfaces, Forms, Alerts and Reports for Order Management, Inventory, Configurator, Advanced Pricing and Quoting modules

Worked on Development Requirements for Oracle Quoting and Order management module at client place.

Worked on POC (Proof of Concepts) for business requirements to integrate the legacy systems (MOL and REC) with Oracle Applications.

Co-coordinating the onsite and offshore team members for developing and testing the objects.

Worked on Sales Order Interface with batch valid configuration process and attaching the short text type notes for header and lines.

Worked on Oracle Quoting interface and BOM splitting in quote new version creation process with batch valid configuration and copy configuration.

Worked on Oracle Pricing Engine interface for providing the customer price, discounts, promotion items and pricing agreements from Oracle Application to the MOL legacy system.

Worked as a backup resource for the Order Acknowledgement Interface.

Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Environment: Oracle Applications 12i, ORACLE 10i, TOAD 9.0.1

Confidential Consulting, India, Hyderabad

First American Title Insurance Company

Oracle Techno Functional Consultant

Description: First American Title Insurance Company is maintaining different legacy systems (D Confidential Faction, Concur, Ultipro and FAST) for different Financial Modules. They are facing difficulties in Financial reporting because of this. The client is going for Oracle implementation in order to have integrated d Confidential being stored at one place and to have better reporting.

Scope: Offshore development of RICE component for First American Project.

Responsibilities:

Worked on Conversions.

  • Fixed Assets Conversion.
  • Vendors Conversion.
  • AR Invoice Conversion.

Worked on Interfaces.

  • Payables Expense Report Invoice Interface.
  • AR Lockbox Receipts Interface.

Worked in integration support while go lives the project.

Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Involved in peer review, testing and quality delivery.

Environment: Oracle Applications 11.5.10, ORACLE 9i, TOAD 7.6

Oracle Techno Functional Consultant

Confidential Consulting,

NETSCOUT

Role: Worked as a Technical Consultant in Netscout Project, involved in designing and developing of Conversions and Reports for Financial modules.

Responsibilities:

Worked on Item Conversion.

Worked on AR Customer Maintenance Report.

Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Environment: Oracle Applications 11.5.10, ORACLE 9i, TOAD 7.6

Rapidigm India Ltd

GE Consumer Products, USA / GE Consumer & Industrial Systems, USA

Description: GE Consumer Product (GECP) Appliances business based in Louisville, US, is using Oracle Applications. This Project involves up-gradating GECP Oracle Applications environment from 11.5.8to 11.5.10. During the upgrade accommodate all GECP customizations and custom developments in the new 11.5.10 instance, this requires modifying the existing objects as well as developing the new objects. This project uses inventory and purchasing modules to maintain Inventory and PO information. It is interacting with 13 other legacy systems for interfacing items, POs and Supplier information. GECP Appliances has inbound and outbound interaction with so many other systems with Non APPS technologies like Java, XML, Shell scripts etc. makes it unique.

GECP Appliances business is having different processes like Item Conversion, Blanket PO Conversion, COPS, SLIC, HUB, OP Minerva, and different customizations like predefined Derivations, Validations, and Access Control & Functionality Customization by using GECP Custom.pll.

Role: Technical Consultant

Responsibilities:

Design and develop Inbound / out bound Interfaces.

  • Worked on Item Conversion and Blanket PO Conversion.
  • GEPO CHSMSACCESS Out bound Interface.

Developed new forms and Customize forms.

  • Supplier Selection Form
  • Customized the PO Form by using GECP Custom pll.

Developed new Reports, Customize Reports, Mailing Reports, XML Publisher Report and shell scripts for ftp.

Upgradation from 11.5.8 to 11.5.10

Worked in Enhancements (Based on requirement changes).

Preparing Technical Specifications, Unit Test Plans, Unit Test Output d Confidential and Migration documents.

Involved in peer review, testing and quality delivery.

After successful go live, giving the Post Production support.

Environment: Oracle Applications 11.5.8 / 11.5.10 , ORACLE 9i, TOAD 7.6

Oracle Techno Functional Consultant

Confidential Consulting, India, Hyderabad

Univision, USA

Description: Offshore development of RICE component for UNIVISION Project.

Role: Technical Consultant

Responsibilities:

Design and develop Inbound Interfaces.

  • Worked on GL Conversion and AR Customer Conversion.

Developed custom form in CRM Foundation Module.

  • The custom form “Sales Team Form” will allow for the assignment of teams and stations to sales manager only when a manager is created as a sales person in the Resource form of CRM Administrator.

Developed new Report.

  • Worked on AR Miscellaneous Invoice Report.

Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Environment: Oracle Applications 11.5.10, ORACLE 9i, TOAD 7.6

Infinite Computer Solutions (I) Pvt. Ltd

Description:

Project involved supporting of Oracle Applications 11.O.3 Modules (GL, PO, AP, AR, and HRMS) for GEAE Asia countries (Singapore, Japan, China and Malaysia).

GE Transportation Aircraft Engines (GEAE) is the world's leading producer of large and small jet engines for commercial and military aircraft. Also supplying aircraft-derived engines for marine applications and provide aviation services. GEAE's technological excellence, supported by continuing substantial investments in research and development, has been the foundation of growth and helps to ensure quality products for customers.

Role: Techno Functional Consultant

Responsibilities:

Closed the tickets while supporting to Asia countries (Singapore, Japan, Malaysia and Chinea).

Solving day-to-day user issues.

Did Production Support 11.0.3

Uploading the Monthly currency file and payroll file.

Smoothly handling the month end process.

Worked in Enhancements (Based on requirement changes).

Gathered requirement information from users of Oracle Financials application 11 and developed business requirement document.

Worked in interfaces and reports.

Environment: Oracle Applications 11.0.3, ORACLE 8i, TOAD 7.6

Infinite Computer Solutions (I) Pvt. Ltd GE Consumer Finance & E - Finance

Description: Project involved up-gradating GE Consumer Finance’s Oracle Applications releases from 11.5.8 to 11.5.10. GE Consumer Finance, UK is a leading provider of credit services to consumers, retailers and auto dealers in 35+ countries around the world.

Role: Techno Functional Consultant

Responsibilities:

Worked on Standard mechanism (Global Interface Application - GIA) for import and export of d Confidential files to and from the Oracle GL.

Upgradation from 11.5.8 to 11.5.10

Iden tified base table changes in 11.5.10 compare to 11.5.8 releases of Oracle Applications.

Developed Testing scope documents and Test Plans.

Developed Migration document for SSS (Buy to Pay) to OAP (from 11.5.8 to 11.5.10 releases).

Prepared test scripts for interfaces, extracts, reports and Forms.

Tested the interface extract reports and Forms in both 11.5.8 and 11.5.10 environments and documented the test results.

While testing the Buy to pay interfaces and reports, I have created the Requisitions, Purchase Orders, Invoices and Payment batches.

Developed New and modified the existing reports as per the client’s request.

Environment: Oracle Applications 11.5.8/11.5.10 , ORACLE 9i, TOAD 7.6

Infinite Computer Solutions (I) Pvt. Ltd, Confidential Vtech, USA.

Description: Vtech is one of the world's largest manufacturers of high frequency cordless phones and children's electronic learning products. In the United States, the company is the market leader in the cordless phones market and is aggressively expanding into other segments such as d Confidential networking, using its licensed brand, AT&T.

The full Oracle E-Business Suite implementation includes Oracle Financials, Oracle Order Management, Oracle Procurement, Oracle Discrete Manufacturing, Oracle Advanced Supply Chain Planning, Oracle Warehouse Management, Oracle CRM and Oracle Call Centre. Vetch selected this comprehensive approach to achieve lower total cost of ownership and to reap the benefits of full integration in an open architecture.

Role: Technical Consultant

Responsibilities:

Modified and developed Oracle Reports, PL/SQL packages and Unix shell scripts to perform certain specialized functions / enhancement on Oracle Applications.

Worked in Conversions and Interfaces

Did Financials Implementation and postproduction support

Interaction with onsite Functional and testing teams.

Preparation of Installation scripts and Documentations (Technical specifications, UTP and UTO).

Developed functional specification document from requirement gathered.

Analyzed functional specification, did d Confidential analysis and developed detail design document.

Environment: Oracle Applications 11.5.7, ORACLE 9i, Oracle Forms and Oracle Reports TOAD 7.6

Infinite Computer Solutions (I) Pvt. Ltd Confidential Treasury, Hong Kong

Description: Confidential China/Hong Kong Limited ( Confidential ) shall support Hong Kong Treasury in implementing a new financial management and information system across all their government Bureaux and Departments with over 5,000 users.

The new GFMIS is a key element of a program to strengthen financial management and reporting. It will replace the Government's existing financial management information systems with one based on Oracle, which will support the move to more commercial style accounting and reflect international best practices in public sector accounting.

The new GFMIS system is the first Web-based financial management system within the HKSAR Government. It will support all core processes of financial management, cash accounting and payment processing, with enriched functionalities available such as accrual accounting, costing, management reporting and automated vote control.

Role: Technical Consultant

Responsibilities:

Involved in customization of Forms & Reports.

Developed New custom forms and Reports.

Preparation of Installation scripts and Documentations (Technical specifications, UTP and UTO).

Worked in Enhancements (Based on requirement changes).

Closed the defects while SIT.

Involved in peer review, testing and quality delivery.

Interaction with onsite Functional and testing teams.

Environment: Oracle Applications 11.5.9, ORACLE 9i, TOAD 7.6

Hire Now