We provide IT Staff Augmentation Services!

Oracle Applications Techno Functional Consultant Resume

Foster City, CA

PROFESSIONAL SUMMARY:

  • Over 7+ years of IT experience as a Oracle Techno Functional Consultant in Oracle Applications Release 12 E - Business Suite
  • Involved in implementations & Supporting Projects of Oracle Applications R12 &11i.
  • Expertise in various RICE Components (Reports, Interfaces & Conversions).
  • Expertise in Order to Cash(O2C) and Procure to Pay Cycle(P2P).
  • Strong Technical and Functional knowledge of the SCM Modules (Order Management, Shipping, Purchasing, Inventory, Quoting) and Financial Modules (Account Payables, Account Receivables, General Ledger).
  • Excellent skills in SQL, PL/SQL
  • Expertise in Oracle Forms development using Oracle Form Builder 10g
  • Involved in development of BI Publisher reports
  • Involved in Development of OAF (Oracle Application Framework) pages.
  • Extensive experience in customizing the forms functionality using Form Personalization and Custom.pll.
  • Extensive experience in developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs, ADI/Web ADI and EDI Interfaces.
  • Strong knowledge on Trading Community Architecture (TCA).
  • Working knowledge on ADF(Application Development Framework)
  • Extensive experience in PL/SQL coding like Cursors, Ref Cursors, Dynamic SQL, Packages, Collections, file management using UTL FILE packages, Triggers, Stored Procedures and Functions.
  • Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD
  • Expertise in System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.
  • Knowledge on Approvals Management Engine(AME)
  • Design the Technical DOC. (like MD 070 and TE 040 DOCs) of respective Components, familiar with all Functional documents like MD50
  • Worked with Oracle Applications Releases 11.5.10 and R12, and Upgradation from 11.5.10 to R12.
  • Experience in raising Service Requests (SR) and follow up with oracle team to resolve the application issues and bugs.
  • Experience in working with PVCS version manager, Smart SVN, Trac and Serena Products
  • Expertise in Unix Shell Scripting
  • Good knowledge in ADF forms development
  • Good knowledge in customizing Workflows
  • Extensive experience in all phases (SDLC) of Oracle E-Business Suite Implementation, experience in projects using agile methodology.
  • A highly motivated, energetic individual and a team player with excellent analytical & problem solving skills, communication skills and interpersonal skills
  • Collaborate well with project management, business analysts and department management teams.
  • Exposure on Release 12i (R12i).

TECHNICAL SKILLS:

ERP: Oracle Applications E-Business Suite(EBS) 11i and R12 Order Management(OM), Inventory(INV), Quoting(ASO), Purchasing(PO), Shipping(WSH), Accounts Receivable(AR), Accounts Payables (AP), General Ledger (GL), AOL .

Operating Systems: Windows 7, Windows Vista, Windows XP and UNIX.

RDBMS: Oracle 8i/9i/10g/11g

Languages: SQL, PL/SQL, J2SE, JSP.

Utilities/Tools: Toad, SQL*Plus, SQL*Loader, PVCS Version Manager, Smart SVN

Reporting Tools: Report Builder 10g and XML Publisher. GUI: Forms10g,JDeveloper, Workflow Builder

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Interacting directly with Business people and third party vendor to gather requirements.
  • Created MD50, MD70 documents.
  • Collaborated well with other teams
  • Developed EDI 180,812 interfaces
  • Modified functional setups involving SCM modules.

Confidential, Columbus, OH

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Interacting directly with Business Analyst for requirement gathering
  • Involving in Agile methodology by giving daily updates over stand-ups and talking through challenges faced during development
  • Development of Custom Forms, Interfaces and XML Reports.
  • Developing customizations in Quote to Cash Modules.
  • Modified functional setups involving SCM modules.
  • Created new & modified existing Forms Personalization's.
  • Solving SDRs and migrating objects to higher instances.
  • Creating MD70's and updating as per the changes made.
  • Development of custom ADF Form
  • Modified quoting workflow
  • Worked closely with BPEL team for integration & with QA team for testing.

Confidential, Wayne, PA

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Involved in Implementing Inventory, Account Receivables, and Order Management functional setups in 12.1.3 instance.
  • Researching the Service Contracts Module and knowing the functional life cycle of it.
  • Creating Recurring billing for Contracts and invoicing it.
  • Day to day interaction with customers.
  • Performed end to end testing of Oracle Order to Cash, Procure to Pay modules in the newly implemented 12.1.3 instance.
  • Functional Setups in Advanced Pricing
  • Raised a service request with Oracle as the contract terms weren't printing on the contract.
  • Giving frequent demos to the customer in showing the progress of POC.
  • Requirement gathering and customizing as per the customer's needs.
  • Created BR100 for the implemented modules.
  • Data setup for Use Cases.
  • Mapping of current business process with Standard Oracle Process.
  • Developed the Item Interface

Confidential, Indianapolis, IN

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Solving Production Tickets
  • Fixing issues in Forms, Reports, Packages
  • Modifying various functional setups in OM, INV, AR modules
  • Creating and modifying shell scripts.
  • Involved in designing new packages for Interfaces.
  • Fixing issues pertaining to custom sales order process.
  • Quick delivery of production major tickets which doesn’t hinder clients business.
  • Day to day interaction with users for requirement gathering on the raised tickets.
  • Used Smart SVN to get the latest code from the server and ensuring that no one locked a particular object
  • Used Trac to update the status of the tickets and assign back to customer for user testing.
  • Created custom process to send PDF output as an email attachment to the users about the rings processed.
  • Fixed various issues pertaining to custom sales order process.
  • Working closely with DBA to ensure migration to QA and PROD instance happens without any issues.
  • Developed various CSV reports from scratch.

Confidential, NYC, NY

Oracle Applications Techno Functional Consultant

Role & Responsibilities:

  • Responsible for day to day activities which involve client meetings and status reporting of pending tasks.
  • Supporting production system for 24/7.
  • Reviewing the progress of issues with Project Manager.
  • Supporting all the EDI transactions (846,850,856,810,753,754,869 and 870) transactions
  • End to end life cycle implementation of Order to Cash and Procure to Pay Modules
  • Various customizations in O2C & P2P modules.
  • Supporting the custom ship confirm process which is developed using the standard API’s.
  • Developed a new Packing routing using the shipping API’s based on the retail chain packing requirements.
  • Involved in various Cost related setups
  • Worked on Cost Accounting.
  • Developed and EDI 850 pre process screen so the end users can review the 850 data before they are loaded as sales orders.
  • Developed Out bound extraction using UTL File. Involved in customizing Shell Scripts for different EDI processes.
  • Developed pl/sql package to validate order details before processes to sales order.
  • Registration of Concurrent programs, attaching concurrent programs to Request Groups.
  • Creation of Value sets, Flex fields for all modules and done Registrations like Reports, PLSQL Stored Procedures and SQL*Loader files.
  • Developed & customized several reports and interfaces in modules PO, OM, INV, AP and AR.
  • Design the Technical DOC. (like MD 070 and TE 040 DOCs) of respective Components.
  • Good understanding of AIM methodology
  • Developed and Customized Conversions and Interfaces.
  • Involved in the development of Stored Procedures and PL/SQL Packages.
  • Involved in Development of plsql scripts using API’s.
  • Involved in defining of various functional setups.
  • Involved in developing various custom forms (Regal 850 form, Regal Landed Cost, Regal Customer allowance).
  • Involved in developing OAF forms (Service Request).
  • Involved in client discussions and gathered information directly with client.

Hire Now