SUMMARY:

• Oracle Application Techno Functional Consultant with 7.6 years of work experience in different oracle EBS modules including Order Management, Inventory, Purchasing, Service Contracts. Involved in business requirement gathering, solution design, development, testing and burn - in support. Seeking to use proven Oracle application skills to help my company's growth efficiently and productivity.
• Involved in creation of setup documents and gap analysis in Order Management and Inventory.
• Involved in setup and implementation of Service Contracts Oracle Approvals Management(AME) functional setup changes/enhancements.
• Experience in writing PL/SQL packages, procedures, functions, views and triggers in Oracle 10g/9i.
• Experience in Oracle Developer tools which includes Oracle forms 6i/10g, Oracle Report 6i/10g.
• Experience in Customizing existing RDF reports/ Oracle forms and creating new RDF reports/ Oracle forms using Oracle report builder/ Oracle form builder 6i and 10g tool, BI publisher report, XML bursting.
• Experience in Oracle forms personalization.
• Experience in writing shell script.
• Experience in developing AOL objects, Concurrent Programs, Request sets, value sets and lookups.
• Experience in WEBADI desktop integrator.
• Knowledge of Procure to Pay Cycle and Order to Cash Cycle.

TECHNICAL SKILLS:

Software: SQL, PL/SQL, Oracle EBS suite 11i and R12. E2PR, Shipconsole.

Tools: PLSQL Developer 11.0, Kintana Migration Tool, MKS Prod Tool Quality Control Tool, RCS Menu Migration -UNIX Server, TOAD 9.5.0, Oracle Developer Suite (Forms & Reports) Builder, MS Excel 2010, MS Visio 2010, MS Word and PowerPoint 2010.

Platform: Oracle 11i, Oracle R12.1.3, Oracle suite Forms Reports (rdf)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Service Contracts Consultant

Responsibilities:

• Involves changes on service contract header and line attributes, WEBADI creation for serial number upload on contracts on Global ERP R12 system called as Greenfield system.
• Developed code using service contracts API’s to update header and line attributes.
• Developed BI publisher report which shows service contracts for specific operating units.
• Created XML bursting file to send the output created by report in email.
• Created values sets flexi fields. Changed QA check rules package.
• Worked on WEBADI to create serial number upload on service contracts.
• Created Approval groups and rules in Oracle Approvals Management AME for service contract approval workflow.

Confidential, Webster, NY

Oracle SCM Consultant, Onsite Coordinator

Responsibilities:

• Involves moving of Order to Collection and Finance(OCF) system which gets order from other systems to Global Supply Chain Backbone(GSCB) Instance.
• Performance tuning on order inbound and outbound package, customer, organization details, Calendar details packages which send data to E2OPEN planning system.
• Accounts Payables (AP): Payables invoice, purchase order, packing slip matching related customizations, involving forms personalization to facilitate Procure to Pay (P2P) cycle.
• Used AP AI PKG TABLE HANDLER.INSERT ROW to create invoices, AP AIL TABLE HANDLER PKG. INSERT ROW to create invoice lines and AP AID TABLE HANDLER PKG.INSERT ROW to create invoice distributions.

Confidential, Webster NY

Oracle apps Consultant, Onsite Coordinator

Responsibilities:

• Worked on Customized pick/Pack slip reports, Delivery number Barcode generation on the report.
• Developed/customized Oracle Forms (10g), Developed UNIX Shell Scripts to add Barcode fonts in RDF reports.
• Developed PL/SQL procedures/functions to validate OHB, apply hold, release hold.
• Functional setup in Order management to define new hold type.
• Customized the ShipConsole package to get the custom address for Xerox.
• Prepared Unit Test Cases and perform Unit Testing.
• Provided Support to BSA/Business users during testing.
• Provided burn-in support.
• Conducted knowledge transfer for production support team to explain the developed components.

Confidential, Webster NY

Oracle apps Consultant, Onsite Coordinator

Responsibilities:

• Developed/customized Oracle Forms (10g). Involved in creation of form folder functionality on the custom oracle forms(10g).
• Developed PL/SQL procedures/functions to enable the part to be shipped from the nearest budget center.
• Setup fnd lookups for Carrier.
• Define hold in Order Management.
• Involved in 940 EDI Mappings-Order shipment extractor.
• Prepared Unit Test Cases and perform Unit Testing.
• Provided Support to BSA/Business users during testing.
• Provided burn-in support.
• Conducted knowledge transfer for production support team to explain the developed components.

Confidential, Webster NY

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked on Accrual Write Off Report to setup this report in correct responsibility.
• Custom components has been remediated to make them work in R12.
• Functional setup for Inventory Differed COGS Account.
• Created unit test cases/ solution design documents, burn in support.
• Provided Support to BSA/Business users during testing.
• Provided burn-in support.
• Conducted knowledge transfer for production support team to explain the developed components.

Confidential

Oracle apps Consultant, Onsite Coordinator

Responsibilities:

• Gathering development and enhancement requirements from client's functional team and from functional design specification documents.
• Worked on mappings to send orders to 3rd party WMS (3PLSystem), getting back ship confirmation, close orders and trips.
• Developed new concurrent programs, scheduling of concurrent programs.
• Worked on SFTP file transfer to 3rd party system.
• Created UNIX script to load the ship confirmation file from 3rd party to interface table, perform validation and ship confirm.
• Created unit test cases/ solution design documents, burn in support.
• Provided Support to BSA/Business users during testing.
• Provided burn-in support.
• Conducted knowledge transfer for production support team to explain the developed components.

Confidential

Oracle Apps Consultant, Onsite Coordinator

Responsibilities:

• Developed Codes/Interfaces across Environment that will transition A4 equipment supply chain fulfillment from Wilsonville platform (Oracle ERP application) to Webster platform (Oracle ERP application).
• Worked on Oracle forms 6i to add a new functionality on an existing form.
• Worked on Oracle reports 6i to develop a new customized Bill of ladings report (RDF) and print the barcode on the report.
• Developed customized text report, created concurrent programs to enable business to submit report on demand.
• Worked on customized Oracle WMS pick/pack screen.
• Attended daily status meeting to provide the project progress updates and gather clarifications (if any) on the technical requirements.
• Responsible for review and sign-off on all technical deliverables from the development team.
• Created unit test cases/ solution design documents, burn in support.
• Provide burn-in support.
• Conduct knowledge transfer for production support team to explain the developed components.

Confidential

Oracle Apps Consultant

Responsibilities:

• Gathering development and enhancement requirements from client's functional team and from functional design specification documents.
• Provide high level estimate for implementation of Change Requests (CCRs)
• Developed Codes, functions, customized forms, XML Publisher report, triggers and concurrent programs to the XML publisher report.
• Worked as lead for 3 member CCR team.
• Developed form personalization to submit the concurrent program from Oracle customized form.
• Prepared Unit Test Cases and perform Unit Testing
• Provided support to SCM team during migration of code changes to test and production environment
• Submitted Weekly and Monthly status reports
• Attended Weekly status meetings and Conduct Knowledge sharing sessions for TCS DMO production support team on completed CCRs.

Confidential

Oracle Apps Consultant

Responsibilities:

• Identify the components which needed a change due to upgrade from 11i to R12.
• Modified the components to enable it to work on R12 instance.
• Worked with Oracle support to engage them on service request(SR).
• Attended daily status meeting to provide the project progress updates and gather clarifications (if any) on the technical requirements.
• Update solution design document/ technical design document.
• Create unit test cases, perform unit testing.
• Provide support to SCM team during code migration to production.
• Give burn-in support after project go-live.
• Give knowledge transfer after burn in support.