SUMMARY

• Oracle E - Business Suit Sr. Professional with 10+ years of experience in Requirement gathering, Design, Development, Implementation, Enhancement, Integration and Support of Oracle ebs R12x/11i. Specialized in the oracle ebs Supply Chain module (INV, PO, OM, Shipping and WIP) and Finance (AP, AR and GL) module as an techno functional consultant.
• Strong experience working in R12 upgrade, enhancement, data migration and support projects. Expert in designing functional, technical and conversion document using AIM methodology and developed RICEW,XML Publisher, Oracle Forms, Oracle Report, Web ADI, SQL, PLSQL, SQL* Loader, UTL FILE, OAF, BPEL Service and AOL Objects. In-depth knowledge of business process Order-to-Cash (O2C) and Procure-to-Pay, API, setups and underlying tables.
• Well experienced with client-facing roles with knowledge of complete software development life cycle, estimation, solutions, review gate process and coding standards. Excellent communicator, with strong interpersonal skills and the ability work independently or lead a multidiscipline group. Competent under pressure with advanced process management, acuity, active listening, leadership and analytical skills.

PROFESSIONAL EXPERIENCE

Oracle Apps Techno Functional Consultant

Confidential

Responsibilities:

• Gather requirement to group multiple sales order under single delivery for shipping sales order and multi thread pick release process to priorities premium order and continues pick release of order.
• Designed material transaction replication mechanism to post 11i transaction to R12 instance..
• Develop Web ADI to load allocation orders, miscellaneous transaction and sub inventory transfer.
• Customized Sales order header and line workflow to quota hold and add post reservation logic.
• Retrofit RICE object as per R12 compatibility.
• Design test case for end to end business process and perform BAT for planning and shipping business processes.
• Present planning and order management track status in scrum call. Participate in defect triage meeting.

Oracle Apps Techno Functional Consultant

Confidential

Responsibilities:

• Maintain SCM system covering Inventory (INV), Purchase Order (PO), Order Management (OM) and Planning (Custom) modules.
• Resolve incident with in the service level agreement of production.
• Mange P1/P2 incident meeting bridge, prepare and publish P1/P2 communication notes to business, IT and other stake owners.
• Create Problem incident (PBI) for unresolved ticket, perform RCA and provide short term and long term fix.
• Identify opportunity of performance tuning in inbound, outbound interface and reports
• Identify opportunities for minor, major enhancement and present to IT service manager for approval.
• Support major process like Internal Requisition and Internal Sales order, order to cash, procure to pay, return order, cycle count
• Maintain custom module inbound and outbound interface integrating 3rd party application
• Participate in SCM 11i to R12 upgrade and identified objects required changes as per R12 compatibility
• Participate in monthly and quarterly release for code migration and deployment to production
• Present SCM support biweekly status report in stand-up calls and lead SCM support onshore team

Oracle Apps Techno Functional Consultant

Confidential

Responsibilities:

• Requirement gathering for item serialization, and gap analysis.
• Design and develop outbound interface to AXWAY for posting shipped sales order details.
• Design and develop outbound interface to AXWAY for posting serial number lifecycle status.
• Create technical design document for Interface and xml publisher reports using AIM methodology.
• Develop of xml publisher report for packing slip and in-transit orders
• Setup serialization mechanism at item, lot, transaction and responsibility level for testing items shipping to South Korea.
• Perform Misc Receipt transaction, release lot quantity, change serialization profile values and change FND Diagnostics profile values for testing.
• Code migration from development to stage, UAT and production instance.
• Run O2C cycle in non-prod with incorporated enhancement to ensure designed solution work as per business.
• Create Sales order, IR/ISO and supplier for testing.
• Manage and Coordinate with offshore team.

Oracle Apps Techno Functional Consultant

Confidential

Responsibilities:

• Preparing mapping document (CV040) and Design document (CV060) for install base and service contract using AIM methodology
• Develop of inbound interface to create item instance and warranty contracts from legacy system to oracle application.
• Validating item instance and warranty contract created in oracle application
• Develop XML Publisher report for customer, contract and product details
• Enable DFF fields of service contract to capture additional information
• Created concurrent program, request set, value sets, lookup, alert, profile and other AOL object
• Creating LDT files, code migration script for Test, SIT and Production instance
• Review design document, technical document, test case and present project status report

Oracle Apps Technical Consultant

Confidential

Responsibilities:

• Identifying and Documenting Objects need customization in AP, PO, AR, OM, HRMS and PA modules of 11i
• Customization of interface, report, forms and workflow as per R12 and new business flow.
• Created concurrent program, request set, value sets, lookup, alert, profile and other AOL Object
• Creating LDT files, TAR file and code migration to Test, SIT and Production instance
• Review design document, technical document, test case and present project status report

Oracle Apps Technical Consultant

Confidential

Responsibilities:

• Identifying and Documenting Objects need customization in AP, PO, GL and AR modules for R12.
• Customization/Recreation of interfaces and conversion program with new tables and API of R12.
• Customization of oracle standard reports, oracle forms and workflow.
• Development of custom oracle reports, interfaces and performance tuning.
• Creating LDT files, TAR file and code migration to Test, SIT and Production instance.

Oracle Apps Technical Consultant

Confidential

Responsibilities:

• Setup meeting with application architect and business leads to understand the legacy system and prepare requirement document.
• Prepare delivery plan and resource estimation and resource mapping to execute the project successfully.
• Design and developed inbound interface using SQL*loader to import AP invoice and Journals from legacy system.
• Kept track for delivery from multiple team and anchored project status meeting.
• Coordinated in integration and user acceptance test involving multiple dev team and key business users.

Oracle Apps Technical Consultant

Confidential

Responsibilities:

• Prepare conversion document(CV40,CV60) and technical design document using AIM Methodology.
• Customize order header and line workflow to incorporate new business logic.
• Customized oracle standard report, PLSQL report, oracle forms, interface, views as per R12 compatibility.
• Personalized oracle form and OAF pages to include new business rules for supplier.
• Customised custom PLL to incorporate new business logic for PO requisition.
• Develop custom interface to integrate order management system to third party using PLSQL, SQL loader and BPEL services.
• Develop conversion program for - supplier, supplier sites, hr locations, hr organizations, hr positions, employees, requisition, purchase order, items and on hand quantities.
• Create oracle SR for technical/functional issue in application, track code migration.
• Prepare project status report, anchor project release and lead offshore development team.

Oracle Apps Technical Consultant

Confidential

Responsibilities:

• Gather requirement from business user to under need of setup audit system
• Identify key setup for OM, AP, GL and AOL module and design the audit tracking mechanism
• Develop xml publisher report to present set up changes, PLSQL report and custom interface to store set up changes.
• Develop custom forms to present high level summary for setup changes
• Prepare project status report, tack and update SVN code repository, code migration and unit testing
• Coach peers and juniors as and when required on specific technical competencies required to deliver on the assigned task.

Oracle Apps Technical Consultant

Confidential

Responsibilities:

• Provide ongoing day-to-day support to PO, INV and AP modules and resolve incident, prepare ad-hoc report on invoice, purchase order, reported incident.
• Develop xml publisher report for un-invoiced PO’s, cancelled PO’s and supplier detail.
• Develop custom form to present purchasing details and personalized PO form to launch report.
• Design and develop interface to load PO using SQL*loader from third party system to PO module.
• Perform successful code migration, release management and integration testing.

TECHNICAL SKILLS

SKILLS: Inventory, Purchasing, Order Management, Shipping, Account Payables, Account Receivables, General ledger, System Administrator, Interface, Conversion, Oracle Report, Oracle Forms, XML Publisher, Web ADI, Workflow, OAF, BPEL Service, SQL, PLSQL, SQL* Loader.

TOOLS: Toad, FileZilla, Putty, Rally, HPQC, SVN, JDev, Form builder 6i/10g, Report Builder 6i/10g