SUMMARY

• Oracle Applications professional wif over 9 years of involved experience in development, implementation, enhancement, and support projects.
• Strong project experience contributing to Finance and Supply Chain modules like GL, AP, AR, Payroll, Fixed Assets, SLA, PO, Projects , Order Management, Inventory, Sourcing, me Supplier and me Procurement.
• Comprehensive experience wif Oracle Forms, Reports, Workflow Builder, OAF, XML, Discoverer and other tools wif an emphasis on customizing workflows and standard forms.
• Extensive experience in RICE components (Reports, Interfaces, Conversions, Extensions) and APIs.
• Expertise in Developing Oracle Application Framework (OAF), Database packages, new applications, extensions.
• Experience in supporting integrations of EBS to Confidential and third party Applications.

TECHNICAL SKILLS

Oracle Applications: Oracle E - Business Suite R12 (R12.2.4, R12.1.4)/11i (11.5.10, 11.5.9)

Modules: Account Payable, Account Receivable, General Ledger, me Expense, me supplier, me Procurement, Fixed Assets, Order Management, Advanced Pricing, Shipping, Purchasing, Inventory, Sourcing, Install Base, Service Contract, Bill of Materials, WIP

Frameworks: OAF, SOA - BPEL, Web Services, Business Rules, Mediators, Adapters

Languages: SQL, PL/SQL, UNIX Shell Scripting, XML, JAVA, HTML

Development Tools: Workflow Builder, Oracle Forms 10g/9i/6i, Oracle Reports, 10g/9i/6i, Oracle Discoverer, Oracle XML Publisher, JDeveloper

Database Tools: PL/SQL Developer, SQL*Plus, SQL*Loader, TOAD, FTP, PUTTY, WINSCP, Oracle 11g/10g/9i, MS Access, SQL Server 2000, MySQL

Migration Tools: PVCS, KINTANA/PPM, JIRA, Share Point

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Techno-Functional consultant

Responsibilities:

• Provided process flows, high level functional, detailed technical design, unit test documents across all phases of requirement, design, development, maintenance and support cycle.
• Development, maintenance, enhancement and customization of Oracle Reports, Oracle Forms, XML publisher and Workflows.
• Design and development of complex Inbound and Outbound data interface programs.
• Raised and tracked Service Requests in collaboration wif Oracle Support.
• Involved in Month-end support for close and reconciliation for GL, AP, and AR modules. created Packages, Procedures, Functions, Views, Materialized Views, Triggers, Indexes and other database objects.
• Providing production technical support on day-to-day issues.
• Streamlined and structured teh month end activities.
• Developed Oracle Application Framework (OAF), Database packages, new applications, extensions.
• Prepared migration process and documents and helped Co-ordinate wif change management Team to migrate changes from KINTANA to production.
• Preparing daily status report and sharing wif teh customer.
• Coordinating wif 3rd party teams to assist in troubleshooting/issue identification.
• Maintain consistent communication wif offshore teams to provide timely technical solutions and peer reviews.
• Worked on PO Account Generation Workflow.
• Enhanced Wire receipts, Auto Lockbox interfaces to load data dat is received from bank into interface tables and base tables.
• Worked on FA create and prepare mass additions.
• Worked on Trade shift - PO outbound integration and Oracle - SFDC Invoice push program.
• Worked on inbound interface programs to import AR Invoices, Receipts and Billing from Sales Force.
• Developed Event based revenue recognition and Revenue snapshots programs.
• Design and development of FX rate implementation for Microsoft integration.
• Worked on AP Payments enhancements, AP Travel Card Import Process (BOA to Oracle), AP period close utility.
• Worked on Chase Bank payment import program.
• Worked on Blackline Outbound Data feed to interface GL balances from LinkedIn.
• Involved in design and teh development of Revenue, Collection and Tax reports.
• Customized Requisition, Purchaser Order and invoice Confidential pages to capture fields used to derive accounting information at teh line level.
• Personalized Confidential pages to Add New LOV's, enabled DFF's and to add Text input fields.
• Extended standard Confidential page in me Expense to restrict teh number of attachments uploaded in Expense page (FND UPLOAD PAGE).
• Personalized Confidential Page in me Expense attachment upload page to include Note to teh users at teh organization level.
• Worked on Vertex Monthly Update File Upload Process.

Confidential

Oracle EBS Techno-Functional consultant

Responsibilities:

• Worked on permanent fixes for recurring service Requests.
• Implemented ERP modules in support of business requirements.
• Lined up bug fixes on customizations in a Release cycle to help stabilize teh system.
• Co-ordinate Regression testing activities post major fixes and patch application and coordinated wif DBA in applying patches in Production.
• Closely monitored Invoice Payment issue and coordinated wif Treasury and bank Teams for on time Payment of Invoices.
• Coordinated wif Payables Team, Vendor Team, Cash disbursement team for various issues wif production setups.
• Designed and coded many Finance Change Requests.
• Provide Technical expertise in many ERP related issue.
• Expertise in integrations from FOCUS wif workday HR systems, Concur expense report systems, Ariba Procurement systems.
• Support User acceptance testing and Post Go live support for enhancement request
• Worked on GL Rate Audit Report Transfer, GL Balance Extract to Lenovo, BRAZIL AR Remittance Bank Data Correction, Journal Import Process to FOCUS GL from Canada system programs.
• Worked on many customizations for Order to Cash Flows like order validation framework, Confidential reserve order, interfaces for Shipment request, Pick Slip and ship confirm integrations
• Worked on Auto Lockbox Process, AR Invoice create and Print process and Receipt creation process.
• Customized AP Invoice creation and auto approve, e-check import, Exchange Rate Import interface, Motorola Amex Transaction Load, Format Payment Batches, Confirm Payment Batches, Motorola Supplier Payment feed to CITI Bank programs, Generate Confidential payment document for Motorola Brazil.
• Worked on FA expense to GL, FA load mass retirements and mass transfers Confidential programs.
• Contributed to major customizations in PO, including BPA auto-creation, price change and releases.
• Designed and developed multiple purchase order and import programs to expedite purchase order operation.
• Worked on Open Interfaces, APIs and Confidential .PLL.
• Worked on Business events and Processing Constraints based on business requirement.
• Customized approval hierarchy level and PO requisition workflows in Purchasing as per teh business requirements.
• Designed and developed Vendor conversion program to import vendors from one operating to another operating unit.
• Worked on Confidential Confidential and customizations, customized me Procurement, Sourcing pages as per teh requirements using J-Developer.

Confidential

Oracle EBS Techno-Functional consultant

Responsibilities:

• Preparing technical solutions, components development and issue troubleshooting operations.
• Suggesting teh solutions to business to fill teh gap between R12 features and business process.
• Design solution and development of data conversions for XRS and ROADNET merger projects.
• Identify and fix Confidential code to comply wif online patching standards.
• R12 Retrofit of Confidential packages, reports, forms, workflows, alerts and concurrent programs.
• Fixing teh issues created in JIRA issue tracking tool.
• Migration of components to TST/PRD environment by coordinating wif DBA team.
• Creating Oracle Service Requests (SR’s), prioritized as SEV1 and SEV2.
• Post Go Live support and bug fixes
• Reviewing offshore-team deliverables and provide training for new team members.
• Status reporting to teh customer.
• Worked on Vertex process and monthly updates.
• Implemented Check Printing-Payment Format Programs, mainly used for check printing.
• Worked on Fixed Assets, AR Auto Invoice, Supplier and PO conversions.
• Worked on several Inbound and Outbound Interfaces.
• Worked on Confidential . Confidential and Form Confidential .
• Worked on Confidential customizations.
• Upgradation of RDF Reports, Forms, PLSQL packages, concurrent programs from 11i to R12
• Led and trained 7 members in providing complete functional, technical and support through issue identification and resolution concerning various Oracle Modules.

Confidential

Oracle EBS Techno-Functional consultant

Responsibilities:

• Built stand-alone ERP instance for implementation of Oracle modules in support of business modules across multiple phases.
• Authored Functional, Technical, and Test Script documents and prepared weekly status report wif offshore teams to keep track of development change requests.
• Analyzed business processes, requirements, life cycle testing, and user training through multiple project phases.
• User training, Go-live and Post Production support in Multi-Org Environment.
• Batch Data loads and data fixes using Open Interfaces and APIs.
• Development, Maintenance, Enhancement and Customization of Oracle Reports, Oracle Forms, Oracle Alerts and Workflows.
• Unit testing and system integration testing for teh components developed.
• Migration of components to TST environment by coordinating wif quantum infra core team.
• Converted QES data elements from teh corporate instance writing teh conversion programs.
• Implemented new process enhancement in PO, me Expense, AR, AP, GL, FA, OM, INV and other critical business modules.
• Implemented Bursting logic for many XML Publisher reports to e-mail teh output.
• Imported data from legacy system to Oracle tables using SQL*Loader and validate them using PL/SQL procedures.
• Created AR reports like Aging Seven Buckets, Invoice Register using Oracle Reports.
• Developed various reports like PO Print, Invoice Printing and Credit Memo.
• Worked on ITG cases involving various Confidential processes like Confidential Packs and Pallet Customization, Trade Export System Outbound Interface, Collection Letter Print Program, RMA Receipting, QCT Service Contracts Expiration Report, Ability to Email teh Collection Letter.
• Provided customized solutions for teh OE Order header, OE Order Line Workflows as per teh business requirement.