SUMMARY:

• Over 8 years of experience as oracle EBS Consultant where I was involved with End to End Implementation, Customization, Conversion, Interface, Extension, Development, Production support and Testing in Oracle E - Business Suite (EBS) 11i and R12.
• Experience in Functional/Technical Knowledge in Oracle Applications with Distribution and Supply Chain Modules like (OM-Order Management, PO-Purchasing, INV-Inventory, WSH-Shipping) and Financial modules like (AP-Oracle Payables, AR-Oracle Receivables, GL-General Ledger).
• Provided full system application development life cycle (SDLC) experience ranging from analysis & design, development, testing, implementation, documentation and production support.
• Ability to build and maintain strong working relationships with cross functional business groups, as well as technical specialists.
• Extensive experience in Procure to Pay Business flows and Assisted users on iSupplier and iProcurement issues.
• Functional knowledge in Account Receivables (AR), Fixed Assets (FA), and Cash Management (CM).
• Experiencing in configurations and setups of all procure to pay modules. Proficient in creating User Requirement Specification, Functional Specification and Business Process Flow.
• Extensive exposure in preparation of AIM methodology documents such as BR100, MD50 MD70, MD120 and end user manuals.
• Gathering, analyzing business requirements and Convert Business requirement into Development and technical requirements.
• Strong experience in various rounds of System Testing, Functional Testing, Integration Testing and User Acceptance Testing.
• Served as a liaison between the business and IT to provide Oracle functional and technicalbusiness solutions that meets needs of client managers and other stake holders.
• Defining Supply chain business process (Order to Cash, procure to pay Manufacturing, Logistics, supply and demand planning).
• Strong skills are in PL/SQL, Oracle8i, 9i, 10g, Forms4.5, 6i, Workflow2.6, VB, Excel Macro, ASP, SQL Server, Manual testing, preparing test plan and test cases using QC.
• A highly motivated, energetic individual and a team player with excellent analytical & problem solving, communication and interpersonal skills.
• Large number of successful implementation, global rollout, upgrade and improvement projects with detailed oracle expertise.
• Experience in System Administration tasks related to Menus/Functions, Responsibilities, Users.
• Highly motivated team player with positive attitude, goal oriented and excellent business and interpersonal skills.
• The SCM (Supply Chain Management) certification obtained from APICS (BSCM) and Completed Certification on Oracle Fusion Financials General Ledger and e-Business essential, Purchasing and OM.

TECHNICAL SKILLS:

Primary Skills: Oracle EBS Technical Development (RICEW Components), Supply chain, Interface (Inbound and Outbound), Conversions, OA Framework, BI Publisher, Workflow builder

Packages (Incl ver): Oracle EBS 12.2.2, 12.1.1, 12.0

Modules: Purchasing (PO), Account Payables (AP), Inventory (INV), Sub-Ledger Accounting (SLA), General Ledger (GL), HRMS and Absence Management Modules

Operating Systems: Win 8, Win 7, UNIX

Languages: Oracle SQL, PL/SQL, Java, UNIX Shell Scripting

Development Tools: Toad, SQL * Plus, SQL Developer, JDeveloper, BI Publisher, Putty, Win-SCP

Database: Oracle 11g, 10g

Version Tools: PVCS, Kintana

Documentation: MD050, MD070, CV040, CV060, TE020, BR100

WORK EXPERIENCE:

Confidential, Dallas, TX

Lead Oracle EBS Consultant

• Lead a team through the software development life cycle for successful implementation of supply chain applications.
• As a Senior Oracle EBS Technical Consultant, contributed in design and development of the Implementation of Oracle R12 Procure to Pay, from end to end.
• Participated and actively led in thorough and requirement gathering sessions and detailed business mapping workshops running over multiple months in initial phase of the project.
• Designed and developed multiple Interfaces to and from third party systems (e.g. Warehouse management systems, Demand Planning systems, etc.) by integrating with following Oracle modules: Inventory (INV), Purchasing (PO) and Pricing (QP).
• Gathering and reviewing of requirements specific to the International OTC & Supply Chain, review and testing of global CEMLI elements.
• Developed multiple OAF pages to address specific requirements including Advanced Tables, Table-in-tables, Parent Child relationships, Search, Partial Page Rendering, File Uploads.
• Integrated OAF with BI Publisher using XDO TemplateHelper Utility to seamlessly download Search results in form of a BI Publisher Report. Used Microsoft Excel Templates as report layout.
• Worked on extension of seeded OAF pages in HRMS module by implementing new logic in Controllers.
• Used CAVAJ to decompile seeded Class files to read and analyze existing OAF controller Java codes.
• Monitored OC4J and Apache server bounces after incremental changes in OAF pages.
• Developed various Inbound Interfaces to include Item Master, Material Transactions, Purchase Orders, Requisitions and PO Receipts.
• Developed various Outbound Interfaces to include Item Master, Purchase Orders and Price List.
• Designed and developed Supplier, Supplier Site and Supplier Contact Conversions to migrate legacy Supplier data to Oracle R12 EBS system.
• Worked extensively in Interface tables and Import programs (e.g. Import standard PO, PO Req Import, Receiving Transaction Processor, etc.) to meet the requirements of Inbound interfaces.
• Worked in Payables Interface tables and Supplier Open Interface Import programs to meet the Conversion requirements of Supplier records from legacy to Oracle.
• Worked on standard HR APIs to meet Conversion requirement of HR data from legacy system to Oracle.
• Involved in development of multiple complex reports using BI Publisher tools.
• Involved in developing PL/SQL stored procedures to meet the Interface and Conversion requirements.
• Experienced in EDI mapping for PO Outbound Interface to EDI 850 and EDI 860 standard formats.
• Configured Data upload tools (More4apps) to seamlessly upload data into Oracle application. Coordinated with onshore/offshore team during design, development and support phase of the project.
• Involved in fixing code issues raised during SIT (System Integration Testing) and UAT (User Acceptance Testing) and worked with oracle support team through Service Requests (SR's) on seeded performance Issues.
• Identified areas of Improvements and changes wherever applicable to custom codes and development standards, in-order to mitigate gaps and thereby improving overall quality of deliverables.
• Actively Involved in Pre and Post go-live activities, including deployment.

Oracle EBS Consultant

Confidential, Erie, PA

• Worked as a Lead for Oracle 11i to R12.2.2 upgrade for various Oracle modules including Purchasing (PO), Payables (AP), Sub-Ledger Accounting (SLA), General Ledger (GL) and Receivables (AR).
• Involved in analysis of the Oracle 11i custom Code remediation suggestions generated by Panaya tool on upgraded Oracle R12 system.
• Developed and executed SQL queries to investigate and analyze supply chain opportunities.
• Involved in creating Project tracker to track and monitor the Oracle 11i custom code changes compatible with Oracle R12 standards.
• Redesigned and modified Oracle 11i custom codes and tested for Oracle R12 compatibility for various new Oracle features including XLA tables in Sub-Ledger Accounting, HZ tables in TCA architecture, IBY tables in Payments, ZX tables in Oracle Tax and XLE tables in Oracle Finance Architecture (Legal Entities).
• Worked on configuration and implementation of Multiple Organization Access Control (MOAC) by introducing MO Global Security profiles and handling that in custom codes using MO Global Set Policy Context feature of Oracle R12 (MO GLOBAL.SET POLICY CONTEXT).
• Actively implemented Oracle provided standard views (e.g. PO HEADERS ALL#) to replace ALL tables to meet Oracle R12.2.2 standards of online patching.
• Involved in customization of Oracle workflows wherever a change in Oracle 11i codes is necessary to meet Oracle R12 standards.
• Worked on fixing multiple Performance issues due to existing Oracle 11i codes by introducing new Indexes and modifying PL/SQL join conditions.
• Involved in end-to-end Code reviews by coordinating with development team and resolving defects and performance issues.
• Coordinated with onshore/offshore team for open clarifications/issues raised by development team and resolving them in short turnaround time to close gaps.
• Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project.
• Actively resolved post Go-live code bugs and performance issues and also led development team through the resolution process.
• Implementing Bursting Control files in BI Publisher reports to meet various emailing and distribution requirements.
• Implemented various OAF functionalities including Advance Tables for search, Table Parent Child relationships, Page Partial Renderings, File Attachment and Page refresh wait.
• Integrated OAF with BI Publisher reports, enabling download of search results from Advanced Tables by implementing XDO Utilities.
• Worked on Oracle standard workflows (PO Approval) and customize it to meet specific requirements of Approval channelizing based on Approval amounts.
• Implemented Decryption utilities in UNIX shell scripts to decrypt the secured legacy HR data during HR conversion to Oracle.
• Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project.

Sr. Oracle EBS Business Analyst

Confidential, Houston, TX

• Worked extensively in Production support, Upgrade & Testing on Financials modules, AP, AR, GL, CM, FA, SLA, EB Tax, iExpenses, iPayments and also knowledge on O2C, P2P & Inventory on Oracle Applications ver. R.12.2.3.
• As a Business Analyst I am responsible for the smooth operation of the Oracle ERP in the production environment. Day to day activities include: Monitoring Receivables, Payables and Cost Management modules accounting processes and Interfaces from OM to AR and fix the issues and cleared the transactions.
• Integrated information technology into supply chain operations to improve efficiency and data capture and analytics.
• Monitor AR & GL Interfaces, Fix it and clear transactions and Jes. Fixed the issues in GL, AP, AR, CM, EB Tax, SLA, O2C to help in month end closing.
• Identify and fixed the issues related to Fixed Asset Classes, Master data, Additions, Retirement issues, Asset transfers, Corp Book and Tax Book depreciation issues and other business transactions etc. and helped in month end closing.
• Set up of Secondary Ledger and Mass Allocations. Fixed the WEB/ADI configuration issues, various issues that arise regarding CVR, Security rules, Journal Import and Organization assignments, Code combination issues, Interfaces and so on.
• Worked as Liaison between the Offshore & onshore teams with complete interaction and used tools like BMS Remedy for Help Desk tickets, HP Test directory to log Defects and Oracle Meta link for SR logging in the process of resolving the issues.
• Updated Suppliers' & Customer Master Data in Production including Banks, Suppliers, Suppliers Sites, Customers & Customer Sites information etc. Fixed OM to AR Interface issues.
• Worked on MDM items & Integrated Receiving (Brazil specific Module) and resolved IR issues.

Oracle EBS Business Analyst

Confidential, San Jose, CA

• Successfully converted 5 legacy systems to Oracle EBS suite. Act as a primary go to person for all the Purchasing and Payables requirements.
• Configured the application modules based on the business requirements and performed Purchasing and Payables setups like Payment Terms, PO Lookups, Purchasing Options, Payables Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees.
• Analyzed and verified existing Setup and Configurations are working as intended and assisted Finance team in setting up Fiscal Calendar, Functional Currencies, Chart of Accounts and Accounting Conventions.
• Helped create General Ledger (GL) and Operating Unit (OU) and captured the business processes in form of scenario matrix for testing various process alternatives.
• Tested the new developed components and custom objects as per the business needs. Successfully completed Purchasing, Payables and Inventory conversion data from legacy system.
• Good understanding on Approval hierarchy and Approval Management Engine (AME). Ability to interact directly with client and/or end users / Super users to solicit information and define solution requirements.
• Set up Assignment Set, Sourcing Rules and the Approved Supplier List. Set up vendors and vendor sites on multiple Operating Units (OU).
• Customized forms with descriptive flex fields (DFF) to capture additional information. Assist users in creating Standard Purchase order and Blanket agreement.
• Provided post Production Support and assisted user community with all the issues. Established and drove Conference Room Pilots (CRP) from start to finish.
• Conducted User Acceptance Testing (UAT - End to End Integration testing and d eveloped and maintained supply chain management saving dashboard.
• Conducted meetings with Super Users/SME's to gather requirements for Procure To Pay and documented in BR 30.
• Worked closely with finance user team and oracle finance consultant on issues like Intercompany invoicing, auto invoicing, tax codes and inventory valuation and resolved them by explaining the standard Oracle functionality.