SUMMARY

• 10 years of experience in the Oracle EBS implementing ERP systems primarily using PL/SQL, Workflow Builder, Developer 2000/6i/9i/10g, SQL* Loader, Discoverer, XML publisher and Oracle Applications.
• Good understanding of data flow in the different modules of Oracle Applications.
• Good understanding and knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import etc.
• Successfully completed 4 Full life cycles projects with Oracle Applications 11i (11.5.10, 11.5.8, 11.5.6 and 11.5.4) and recent experience in R12.
• Strong experience in system study, business requirement analysis and business process analysis.
• Extensive Experience in Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), E Business Tax (eBTax), Project Accounting (PA), Advanced Global Intercompany System (AGIS), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Purchasing (PO), Order Management (OM), Advanced Pricing, Service Contract, Record to Report and AOL modules.
• Proficient in Procure to Pay (P2P), Order to Cash (O2C) cycles.
• Involve in Implementation, customization of several Oracle Financial Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
• Expertise in preparing AIM (Application Implementation Methodology) Documents and User Manuals Functional Specification Document (MD050), Technical Design Document (MD070/CV060) and Conversion Mapping Document (CV040)
• Integration of Modules and Business rules along with Setups, Standard and Custom Interfaces, custom reports and other customizations in Oracle Applications have been successfully implemented using strong technical and functional understanding of modules.
• Technically proficient in RICEF (Reports, Interfaces, Conversions, Extensions and Forms) methodologies including Implementation, Interfacing, Conversion and Data Migration, experience in up gradation to Oracle Apps 11i.
• Hand on experience in P2P Cycle in end to end as per technical.
• Production Support on Oracle modules covering: Procure to Pay (P2P), Oracle General Ledger (GL), Oracle Advanced Collections, and System Administrator.
• Assist in implementation of Oracle Financials (P2P, GL and Advanced Collections) across the organization.
• Experience in generating Standard, Discoverer6i/9i and XML publisher reports.
• Expert in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
• Expert in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
• Responsible for Managing and coordinating test sessions like Conference Room Pilots (CRP) and User Acceptance Testing (UAT).
• Work on helping teams adopt Acceptance Test Driven Development (Requirements By Example or Behavior Driven Development).
• Experience with test automation tools like QTP, JIRA, Load Runner and Quality Center.
• Work on coaching others including task based mentoring and one on one Coaching, especially entry level employees.
• Involve in Unit Testing and System Testing.
• Interaction with functional team for effort estimates on CR and feasibility study.
• Work closely with Developers team for different issues and Test new enhancements for a Business Process.
• Involve End - to-End testing for business process using all application tiers.
• Involve in troubleshooting issues on Auto Import Program for all the import process including Invoice, Requisition, Receipts, Asset, Inventory, etc.
• Experience in Forms9i/6i/4.5i creation, customization and personalization and registering them as concurrent programs in oracle applications by using Application Object Library (AOL).
• Well versed with client server environment & tools like SQL*LOADER, TOAD and WORKFLOW BUILDER.
• Identify product gaps, coordinated with Development Team by creating Service Requests (SR) and obtained one-off fixes. Managed and monitored SRs for several P1 Issues. Provided on site solutions and resolved showstopper issues.
• Experience with ticketing systems (Jira) and agile development board.
• Experienced in Waterfall and Agile Release methodologies, effort estimation, scoping, team mentoring & project delivery management using both Waterfall and Agile Release methodologies.
• Strong communication skills with ability to manage expectations of Business and IT users. Possess good organizational, analytical and problem solving skill.

TECHNICAL SKILLS

• Oracle Applications R12.2.5, 11.5.10,11.5.9,11.0.5
• Order Management, Purchasing, Inventory, Bill of materials, Work in Process, Advanced Pricing, Shipping, Purchasing, Cash Management, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, General Ledger, HRMS, Payroll, INFOR.
• GL, AP, AR, AGIS, EBTax, SCM, PO WSH, INV, OM, Record to Report HRMS, SYSADMIN
• Oracle 11g/10g/9i/8i, SQL Server, MS Access 2003.
• C/C++, Java, PL/SQL, SQL / Unix Shell Scripting
• XML/BI Publisher, Oracle Forms / Reports 6i/10g, SQL Loader, SQL Plus, SQL Developer, Toad, Oracle Workflow Builder, Noetix views, APEX, JDeveloper, Cloud IO.

PROFESSIONAL EXPERIENCE

Oracle EBS Techno Functional Consultant

Confidential

Responsibilities:

• Reviewing and analyzing business processes and activities, evaluating end user requirements and custom designing solutions.
• Define Accounting Rules and Invoicing Rules in Oracle AR module to drive deferred revenues as well as accrued revenue.
• Performing Mock Closures as a part of month end activities by clearing all stuck interfaces in Receivables.
• Worked with Finance Team to create new sub accounts to handle Trade Promotional Discounts
• Worked with technical team for creation of custom tables and custom views.
• Worked with oracle support to resolve the issues in implementation process.
• Worked on data fix scripts and backup scripts for data anomalies in AP Invoices.
• Define Accounting Rules and Invoicing Rules in Oracle AR module to drive deferred revenues as well as accrued revenue.
• Worked on Integration issues during month-end and Interface issues with external systems and oracle modules.
• Created post production cutover document identifying issues and step fixes to follow for instance migration from development to production go live.
• Conducted Product Demos Accounts payable and T&E systems, SLA, Global Intercompany System. Performed the Gap Analysis and to be Process and Solution Design
• Provide Functional support to Multiple Clients on any issues reported in Oracle ERP - AR, FA and GL Modules
• Set-up of cross validation rules for various GL codes. Configuring Sub-leger accounting process to GL. Defining security rules at segment level.
• Designed, Developed and Documented Custom Interface for GL Journal Import by getting the file from FTP to import the data into Staging and Interface Tables and calling Oracle standard program Journal Import.
• Involved in Custom SLA rules in AP to standardize their accounting process as per the business requirement and Documented Functional design for technical team.
• Worked on the issue where the drill-down from the GL to the FA Sub-Ledger was not available. (Found bug in the Oracle Standard system).
• Responsible for Co-ordination with Super Users, Execution of Test Cases and providing Functional support.
• Involved in Oracle ERP Upgrade Projects Reporting & Documentation Process Setups Training & Development Resource Management.
• Recommends approaches/technical changes for process improvement and or addressing technical issues.
• Modified Oracle Discoverer reports SQL to accommodate the new users and scheduling them and also sharing for required users on request.
• Does oversight of functional setups for user functional issues that leads to bugs and service request with Oracle Support.
• Fixed Financial issues; EFT Payment check numbering system that's duplicating for bank accounts, missing Employee vendors from Vendors creation form, Expenditure Item date not matching to GL Date for match invoices and incorrect charge account to match invoices for non-ship to accrued purchases.
• Support Lockbox integrations.
• Worked on integrations between Oracle HR and Workday. Employee sync and Employee changes
• Worked in a SOX compliance environment.
• Hands on experience on ServiceNow change management system which consists of tickets and project status
• Experiencing as change lead for change control to raise Normal and Emergency Changes according to SOX and Gxp Impact.

Oracle EBS Techno Functional Consultant

Confidential

Responsibilities:

• Conversions/interfaces:
• Design, documented (MD050, MD070, CV040) and developed Staging tables, Conversion routines, Custom PL/SQL API's for converting
• Suppliers, Supplier Sites, Supplier Contacts
• Requisitions
• Purchase Orders
• AP Invoices
• Customers using TCA
• Responsible for implementing new companies in GL and configuring related setups i.e. fiscal years, accounting period types, chart of accounts for transactions, handling Multi-Currency and Languages, accounting calendars, Consolidation Mappings, Rates and its types, Sources, Categories, Revaluation, Set of Books and Code combinations etc.
• Working on multiple out bound data feeds (i.e. Invoice, balance, transaction, rates feeds etc.) to support system migration and to feed different application systems (Mainframe, SAP, Ariba, Jira etc.) as required.
• Developing unique process for system integrations i.e. in and out bound data feeds which traces/keeps detailed log information.
• Creating custom PL/SQL Package to handle intercompany transactions and for Consolidating Journal's (Custom GCS) between books which eliminates few journal sources and categories, according to Users requirement.
• Working on Custom GL interface, which imports and posts only certain kind of journals from GL interface by using defined the parameters like Set of Books, Journal source, category and Period Name etc.
• Involved in various conversion's like AP Invoices Conversion, Customer Conversion, Vendor Conversion, AR Invoice Conversion and Employee Conversion programs to populate the legacy employee data into Oracle HRMS tables using API's in HR module.
• Working on various interface's and API's like AR receipts and invoice API's, Payables Invoice Interface in AP, Purchase Documents open Interface and Purchasing receiving in PO and develop scripts for GL Daily rates Interface.
• Worked on analyzing and resolving the issues related to Order to cash and P2P cycle.
• Migrated employees, contacts, dependents from ADP into Oracle HRMS through Oracle standard API.
• Developed custom process to create element entries and values to employees for deduction element in the Payroll calculation process through element entry API
• Developed inbound interface program for time clock entries into Oracle payroll as pay batch element entries using API.
• Worked on various custom forms and reports using Forms/reports 6i/9i.
• Involved in retrofitting the OAF (Java EE Framework) components (Page, Controllers, AM's, VO's) which are modified as part of patch application.
• Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module.
• Work on Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions etc.
• Have hands on experience in Data migration, Analysis, Validations and Reconciliation.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Developed unique shell script which will handle multiple transfer modes i.e. FTP, SFTP, and NDM.
• Developed and implemented set of automated AUTOSYS jobs (i.e. Box and Command Jobs), running in numerous development, test and production environments.
• Extensive use of WEB ADI's to load Journals and rates in test and dev environments and created Multiple WEB ADI Layout's according to Users requirement to Load Data manually at TEST/PROD environments.
• Coordination with offshore technical Team to develop all technical components.
• Arranging and participating meetings with Business on a regular basis to discuss Project requirements and issues.
• Extensive use of Oracle Metalink while solving issues and for better ideas.
• Developed AR invoices batch report using XML/BI Publisher. Created Data Definition Templates, rtf templates and split the xml file using bursting feature in XML Publisher reports.
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL)
• Developed Custom Reports for Billing History by Client, Invoices by Client Report and Projects NDR Report using Discoverer 4i.
• Designed and developed new Form using TEMPLATE.fmb for Purchase Returns irrespective of Purchase Order Number.
• Did forms personalization to make view only forms.
• Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.
• I have been the SME for supporting the Oracle EBS suite modules: GL, AR, AGIS, CM, eBTax, AP support for month-end close and on-going support lead
• Module focus: GL, AP, AR, CM, TCA, Inventory, EBtax/Vertex integration, iExpense, SLA, FAH, and AGIS.
• Was working for Receivables, iReceivable, Cash Management, eBtax, Subledger Accounting, Advance Collections and Bill Presentment Architecture as part of product support team.
• Created new users, new menus, new responsibilities, registered concurrent programs and request sets.
• Did daily support to financial department to fix everyday tickets, month end and quarter end closing. Created service requests (SR/TAR) with metalink.
• Oracle EBS suite support, OTC, AGIS, EBTax, P2P, RtoR Lead SME for system and end-user errors and issue that arise from day to day activities.
• GL financial model support lead, support and month-end close SME.
• Used FNDLOAD to download and upload AOL data (request groups, menus, forms, functions; responsibilities; flex field value sets; users) from one instance to another instance.

Oracle EBS Techno Functional Consultant

Confidential, CA

Responsibilities:

• Designed customizations, interface/conversion mapping, pre-production testing, Effort estimation for the enhancement requests and related documentation.
• Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash (O2C) and Procure to Pay (P2P) cycles
• Implementing, Customization of Oracle E Business Suit ( EBS). Strong in SCM (INV, PO, OM) and Financials (AP, AR, GL), Procure to Pay (P2P), Order to Cash (O2C), internal sales order, drop shipment, back to back cycle.
• Designed service contract API's program and data mapping from Siebel to Oracle.
• Designed the Install Base, service contract Concurrent Program, Executable, Request set, Values Sets and Report (RDF) file, shell script and PLSQL programs for applications.
• EBTax: We performed system configuration for multiple tax regimes
• Involved EBTax performed Self-Assessment setup for different countries - process included requirement analysis, design and implementation.
• Extension of Sub-Inventory transfer OAF screen to issue Billet Items (Finished goods) in BOM (Bill of Materials).
• Performed upgrade activities related to EB-Tax and Vertex integration.
• Have extensively worked on implementations of EB-Tax with Vertex/Sabrix Integrations.
• Responsible for running Receivables open interface, imported data into RA interface tables and used the Auto Invoice to import the customer invoices.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Invoked standard API's within custom packages for creating and updating Customer, Sites and Contacts.
• Strong Oracle RICE development experience in all AP, AR, GL, PO and OM Modules.
• Implementation of oracle Applications (PO, AP, INV, iProcurement, iExpenses and AR)
• Oracle On-Demand; Modules: PO, IProcurement, OM, INV, Discrete Manufacturing and Quality and numerous 3rd Parties' Software.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import Standard Purchase Orders into Production.
• Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Designed, developed and documented an inbound interface for AP Invoices from windows-based applications.
• Did Consolidation setups for Consolidation set, Consolidation, segment rules in General Ledger Module throughout global companies.
• Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Responsible for running the Open Interface to import data from OM interface tables into the base tables.
• Involved in Implementation of iProcurement module and Customization of interfaces in this Module.

Oracle Techno Functional Consultant

Confidential, CA

Responsibilities:

• Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR, which is not provided by standard API's.
• Communication from legacy to Oracle applications were established through IBM MQ series using data contracts, which were signed off for both parties integrating the applications.
• Designed and developed the Reconciliation process for GL module.
• Performed Standard Functionality testing in AR, AP, GL, FA, Cash Management, iExpense, E-Business Tax and Sub Ledger Accounting
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Tested Multi-Org Setups as a result of the new Parts Operating Unit that is being introduced as part of the upgrade to Release 12.
• Involved in Unit Testing and System Testing.
• Documented and communicated test results to the Test Management and Business Management Team
• Provided hands on training to business user community for Post- Production support issues & daily and month-end closing of accounting periods for GL.
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
• Strong Oracle RICE development experience in all AP, AR, GL, PO, INV and OM Modules.
• Did Consolidations setups for mapping set, mapping, segment rules in General Ledger throughout global companies.
• Setting up system for foreign currency translation and re-evaluation performing financial consolidation of multiple currency set of books.
• Invoked standard API's within custom packages for creating and updating Customer, Sites and Contacts.
• Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
• Analyzed, developed, configured and tested the UHG customer model into the Oracle 11i TCA (Trading Community Architecture) framework.
• Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
• Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
• Prepared Technical Specification (MD70) documents.
• Responsible for running Receivables open interface, imported data into RA interface tables and used the standard API Auto Invoice to import the customer invoices.
• Analysed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
• Prepared high-level and low-level designs for bridging and migrating data to AP, AR and PA modules.
• Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path.
• Worked on Inbound and Outbound programs for passing the Picked lines to the 3rd party system and shipping the records sent from 3rd party system back to Oracle.
• Created test scripts for every level of testing from unit testing stage to integration testing.
• Oracle EBS suite SME for support for system, end-user issues and month-end system support
• Was actively involved in designing and developing new Project Costing Report in PA reports using Reports 6i to suit business requirement.
• Customized Account Payables (AP) Accounting and Reconciliation reports like Payables Accounting Entries Report, Accounts Payable Trial Balance Report, Payables Account Analysis Report, Payables Accounting Entries Report, Payables Accounting Process Report, Period Close Exceptions Report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions Report.
• Did Generation of Consolidation, Translation and Revaluation reports for multi-set of books and multi-currency sites.
• Developed parameterized reports using Discoverer Plus in Order Management.
• Used XML publisher to print, email and fax the reports.
• Designed XML Templates, XML publisher reports. These are configured to generate output in PDF formats.
• Responsible for customizing Workflow for orders by adding custom Holds for certain customers and added payment terms for the customers.
• Customized AP Invoice, Approval workflow and added new workflow function to validate 2/3way match and to get requester information from requisition into Invoice. very knowledgeable in the following areas: Order-to-cash & Supply chain, Oracle Order Management including pricing, Oracle Inventory, Purchasing, and Oracle Costing Modules. Extremely familiar with all aspects related to the functional aspects and data structures of these applications
• Performed system administration functions such as creation of users, Responsibilities and Menus and Functions.
• Involved in Unit testing and wrote test cases for QA, also involved in UAT (User Acceptance Test).
• Involved in bug fixing reported from QA and End users.
• Involved in Postproduction Support, work involved supporting Apps, support in Training.

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, Service Contracts, Work Flow, Oracle 10g, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD, Java.

Oracle Techno Functional Consultant

Confidential - Houston, TX

Responsibilities:

• Implemented Oracle Financials 11i Account Payables and Project accounting for a large distribution network of a major apparel company.
• Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
• Worked on Oracle API bug in Supplier Sites Open Interface Import, causing all the legacy data to be rejected because of duplicate Vendor Site Code.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import Standard Purchase Orders into Production.
• Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Responsible for converting all the Historical Invoices using Payables Open Interface Import into Production.
• Written an API for Converting the Invoice Payments and was able to convert all the Historical Invoice Payment History into Production.
• Wrote PL/SQL packages/procedures to retrieve order-booking data, based on the search criteria entered in the OA Framework based search screen.
• Handled the implementation stages for EDI, Financials, Purchasing and setting up the interface for Order Management system.
• Worked with interfaces from AP to PA (Project Accounting).
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Customized various reports by adding new fields as per the business requirements.
• Created reports from the scratch as per users requirements in PA, AP and AR
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 6i and registered as XML reports in applications.
• Developed several reports in General Ledger (GL) such as Balance-Trial Balance Reports, to keep track of inter company revenues.
• Customized revaluation status report and responsibility report in General Ledger (GL).
• Customized the Oracle Seeded Order Management Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.

Environment: Oracle Applications 11.5.9 (11i) - PA, AP, AR, GL, OM, PO, TCA, iProcurement, OA Framework, Work Flow, Oracle 9i, Forms 6i, Reports 6i, XML publisher, SQL*Loader, PL/SQL developer, TOAD, Java.