SUMMARY

• Around 9 years of IT experience as Oracle Applications e - Business Suite Consultant in financials and SCM. Experience in design, development, customizing and implementation of Oracle Applications R12 and 11i versions and Fusion/Cloud ERP R12/R13.
• Excellent Technical and Functional knowledge in Account Payables (AP), General Ledger (GL), Subledger Accounting (XLA), Account Receivables (AR), Cash Management (CE), Fixed Assets (FA), E-Business Tax (eBTax), Order Management (OM), AME, Purchasing (PO), Inventory Management, Application Object Library (AOL) in R12 and 11i.
• Proficient working on Oracle Cloud Integrations using FBDI, ADFDI, and Oracle SOA/BPEL Gateway.
• Experience in Oracle Integration Cloud Classic for Integrating third party applications into Oracle Fusion Cloud ERP applications including Journals, Transactions and Invoices.
• Strong knowledge of business flows including Procure-to-Pay (P2P), Record to Report (R2R), Customer to Cash (C2C), Order to Cash (O2C) life cycles along with the integration between various Oracle Applications modules.
• Proficient in designing, developing, customizing and extending various RICEW (Reports, Interfaces, Conversions, Extensions, Workflows) components.
• Expertise in developing inbound and outbound interfaces and creation of automated processes using Application Program Interfaces (API), SQL LOADER, EDI Gateway, XML Gateway, UTL FILE, PLSQL and other utilities
• Proficient on customizing and personalizing approvals using Oracle Approval Management (AME) and Fusion BPM.
• Experience in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), Future Business Mapping Document (BP 80) and Business Requirements Mapping Documents (BR-100) user training manuals, test procedures document preparation.
• Extensive experience in developing various Oracle EBS reports using Oracle Reports Builder, XML/BI Publisher, Discoverer, EIS Reporting, FSG Reports, OBIEE and others. Good Hands on experience working or Fusion reporting tools including OTBI, OBIP, FR Studio and Smart view Reporting.
• Experienced in creating Custom Web ADI Templates and Integrators using Oracle Publicly available APIs for loading data from spreadsheets into various Financial applications.
• Extensive Expertise in Oracle SQL and PL/SQL development creating various database objects including Views, Triggers, Functions, Packages, Stored Procedures and Indexes. Proficient on Performance tuning using EXPLAIN PLAN, OPTIMIZER HINTS and Learning Trace files using TKPROF.
• Good Working knowledge on preparing various unit and functional test scripts, test scenarios for Quality assurance and User acceptance testing.
• Worked on System Administration and AOL modules for creating Concurrent Programs, Value sets, custom Menus and Responsibilities, Defining Descriptive Flex fields, Lookups and Custom Profile Options as per the requirements.
• Proficient in Oracle Cloud Security designing and defining various Custom Roles based on Jobs and Positions.
• Excellent knowledge of Multi-Org and Multi-Currency implementation solutions.
• Proficient on FND LOAD utility to migrate foundation/AOL objects like Concurrent Programs, Value sets, profiles, DFF, menus, responsibilities and others.
• Proficient on creating Service Requests (SRs) and working in collaboration with Oracle Support to resolve various product issues on a timely basis.
• Collaborated with Users to analyze current processes and partnered with developers to design and implement new features that increased efficiency.
• Proficient on developing new and customizing existing workflows using Workflow builder and registered/uploaded them using WFLOAD.
• Excellent Team player with good communication skills & highly effective in end user requirement analysis

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, LINUX, AIX, SUN SOLARIS

Programming Languages: SQL, PL/SQL, C, C++, Java, Unix Shell Scripting

Oracle Fusion/Cloud tools: SmartView, Financial Reporting Studio (FRS), OTBI, BI Publisher, ADFDI and FBDI-based data conversion and integration, OIC - Oracle Integration Cloud

Oracle Tools: Forms 6i/10g/11g, Reports 6i/10g/11g, Workflow Builder 2.6.5, Discover 4i/10g, XML Publisher.

Oracle Fusion/Cloud Financials releases: R12/R13: General Ledger, Subledger Accounting, Payables, Receivables, Assets, Cash Management

Oracle Applications (11i/R12): AOL, General Ledger, Accounts Payables, Payments, Cash Management, Fixed Assets, EB-Tax, Purchasing, Accounts Receivables, Inventory, Order Management, User Management, Service Contracts, Shipping, Advanced Pricing, iExpense, iProcurement, iSupplier, Sourcing, AOL, Sub-ledger Accounting, etc.

ERP: Oracle Applications EBS R12, 11i; Peoplesoft, JDE

Utilities: SQL*LOADER, FND LOAD, UTL FILE, EXPORT/IMPORT

PROFESSIONAL EXPERIENCE

Confidential, North Carolina

Oracle ERP Cloud Consultant

Responsibilities:

• Created various Concurrent Programs, Executables, Request sets, Users, and Responsibilities as required for new custom application development.
• Configuration of multiple ERP Cloud prototypes (Financials and Procurement Cloud)
• Integration between Oracle ERP Cloud and Workday HCM, ADP, Encore and SailPoint
• Designed and developed several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Interacted with end users to gather requirements and Draft specifications during development Phase.
• 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.
• Involved in customization of several standard reports to serve important business processes very specific to the client.
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
• Involved in Customization of various Financials Modules (GL, AP, AR, PO, INV and OM). Successfully Interacted with Functional Consultants, QA team, DBA team and development teams. Developed Technical MD70 specification.
• Customized standard AR Aging Report, Journal Entries Report, Billing History Report and Invoice History Report using XML/BI Publisher.
• Created UNIX shell scripts to automate interface programs on daily basis, encrypting and archiving the interface files containing important financial and personal information.
• Designed and developed code to generate XML files for Out-bound extract and report generation using PLSQL and registered as Concurrent program.
• Developed PL/SQL package to insert customer information using TCA API. Implemented Auto Lock Box process.
• Involved in developing Integration Test Scripts and Documenting End-User Training Materials for project Accounting and Fixed Assets and Performing Integration Test.
• Developed the Items Import program, which does all the necessary validations before populating interface tables of Inventory Module.
• Created requisition to procure goods and service with supplier information, delivery instructions, multiple accounting distributions, and notes to buyers, approvers, and receivers.
• Extensively worked on Bug Fixing And providing Support to various RICEW components.
• Provided Post Implementation Support for various financial modules resolving month end issues efficiently and driving stabilization efforts.
• As per the company requirements, created and implemented XML/BI Publisher reports for different modules like PO, AP and GL.

Environment: Oracle Applications R12.1.3/R12.2.5 (GL, AR, AP, OM, INV, PO, iProcurement), Oracle Database 11g, UNIX, XML Publisher, Workflow Builder, SQL, PL/SQL, SQL* Loader, SQL Developer.

Confidential, Virginia

Oracle ERP Cloud Consultant

Responsibilities:

• Customized standard GL reports like Journal Entry report, Account Analysis Report, Accounts Hierarchy Report as per business needs.
• Hands-on configuration of all the Financials modules on multiple ERP Cloud instances
• Implementation of integration of Oracle Receivables Cloud with legacy billing system
• Designed and developed Custom Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables and PL/SQL block for complete validation of data.
• Involved in design, development, testing, implementing, various reports using Oracle Discoverer and Oracle Reports.
• Complete technical evaluation and testing the Procure to Pay customizations.
• Generating huge volumes for Purchase Order using tools like data loader and SQL Loader.
• Debugging custom RICE components and troubleshooting the performance issues..
• Worked on Migration of process from servers to different upgraded servers.
• Fixing bugs in previously designed reports.
• Developed custom reports like Non Moving Product Reports, Over Stocked Product Report.
• Used AOL & Sys Admin to register new reports, procedures, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Worked on Order Import APIs to load the orders from legacy system into OM.
• Customized workflow for customer credit check in order entry process of Oracle Order Management.
• Developed PL/SQL procedures for conversion of items using the open items import program.
• Involved in Requirements, Design, Data Mapping, Testing and Client Interaction.
• Writing MD-070 documents for technical developments forOracleImplementation.
• Creating and customizing forms to search property and customer records based on several condition criteria.
• Involved in setups of pricing that included price lists, modifiers, qualifiers, profile options, lookups, attribute mapping, etc.
• Developed custom interface programs to Import Sales Orders for Multi-Org, Inter-Company Data Transaction. This transaction takes Purchase order from one org and imports to another org as Sales Order.
• Designed and implemented EBTAX with business requirement for system to calculate Sales and Use Tax in Procurement & self-assessed tax in Payables to meet business needs.
• Good knowledge of Configuration Owner Tax Options flow in EBTAX for handling deferred tax in Payables and Tax on freight.
• Worked on Regime to Rates flow in EBTAX to setup Sales & Use Tax in Procurement.
• Expert in preparation of Solution design documents (MD050), Test Scenarios for Unit testing and Integration testing of standard oracle functionality and custom RICE objects.
• Worked extensively in enhancing functionality in iProcurement including Personalizations and Customizations to fit business requirements. Good knowledge in Workflow for Requisition & PO Approvals.
• Gathered and Mapped business requirements, Gap analysis, documentation as per AIM methodology (RD 20, RD 50, BR 100, BR 10, MD 50).
• Extensively worked on Approvals requirement gathering sessions and configured AME (Approval Management Engine) for Requisition and Purchase Order Approvals.
• Defined and Customized iProcurement and Purchasing related Responsibilities, Functions, Menus and Sub-Menus as per BRD documents.
• Redesigned and customized Create Document Workflow for Requisition to PO Autocreate process and Account Generator as per business requirements.
• Created and Maintained UAT Test cases for iProcurement, Purchasing and Payables modules in oracle financials as per Business Requirement documents throughout SDLC.
• Responsible for setup, design and testing the purchasing Position Hierarchy for routing PO Approvals as required for the business.

Environment: Oracle Applications R12.0.4 (AR, OM, GL, AP, AOL, and PO), Oracle Database 10g, SUN SOLARIS, SQL, PL/SQL, UNIX, SQL*Loader, SQL Navigator, Developer 10g, Workflow Builder 2.6, Discoverer 10g, XML Publisher

Confidential, Atlanta, GA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in migration - using FNDLOAD migrated concurrent programs, value set, RTF template and alerts to other environment.
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing functional document MD50, conversion document CV40 and then developing technical specifications MD70, MD120.
• Involved in setting up various financial modules according to business requirement.
• Setting up banks, bank branches and bank accounts.
• Got training from well qualified financial and technicalconsultantto understand the business flows.
• Worked on SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables.
• Developed programs using PL/SQL and many packages to do the validations as per requirements
• Involved in designing and developing of Inbound Sales Order Import process to load the sales order information daily into OM.
• Created all items of supply for Item Master Organization to enable assigning them to different organizations.
• Experience in writing Test Cases, did unit and integration testing and also performed Unit Testing for different PL/SQL packages.
• Developed Item conversion program to load all the items from the legacy system into Oracle along with the Category set assignments and Categories.
• Involved in the analysis and management ofOracleproblems/defects using Oracle Support.
• Worked on XML/BI Publisher reports namely, Withholding Reports, as per the Business requirements.
• Migrated AP Invoice interface to load data from legacy system to AP interface tables.
• Migrated custom interfaces on the Oracle AR and Oracle AP from oracle 11i to R12.
• Worked on SQL*Loader scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• Trouble shoot issues with run time performance of the reports and use lexical parameters and bind variables wherever required to improve the performance.
• Replaced the RA customer view with AR customer when the PO Close Process has been upgraded to R12.
• Migrated exiting pages into Oracle ADF pages.
• Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL FILE package at periodic intervals.
• Performed migration of lookup types, value sets, Descriptive Flex fields, Profiles, XML templates, concurrent programs, request sets, request groups, menus, responsibilities, and alerts between database instances..
• Prepared Functional Mappings for data conversion from 11i to R12 for all Financials modules.
• Customized MODULES AP, AR & GL, FA in Multi - Org environment.
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap Invoices Interface and Ap Invoice Lines Interface tables.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
• Involved in Performance tuning of the discoverer reports.
• Updated MD50, MD70 and MD120 documents according to the R12.
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Developed Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer etc. in co-ordination with the functional consultants.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Performed through testing on the ADF components and involved in deployment of the application on the server.
• Preparing the MD070 Documents based on MD050for each component.
• Developing Custom Interface Programs and XML Publisher reports.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports and XML Publisher.
• Developed Warehouse Rules and Production Batches interfaces in OPM.
• Wrote technical design documents MD-70 for conversions, extensions, interfaces, and reports.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.
• Developed packages and procedures to update the data from production ERP to the data warehouse tables.
• Developed the reports and Forms as per the current requirement by using reports6i and Forms 6i.
• Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
• Involved in design of functional setups in Order Management.
• Created PL/SQL Packages, Functions, Anonymous Scripts, PL/SQL tables with Bulk.
• Modified Invoices form in AP and Transactions form in AR to restrict data access.
• Developed AP Invoice Conversion and vendors conversion programs.
• Worked on the Auto Lockbox in receivables that automatically creates receipts using the electronic information that the bank provides.
• Preparation of Technical Documents for Reports and Interfaces.

Environment: Oracle Applications R12 (12.1.3), Oracle Database 11g, Reports 10g, SQL, PL/SQL, Forms 10g, XML/BI Publisher, SQL*Loader, TOAD.

Confidential 

Oracle EBS Developer

Responsibilities:

• Created and customized reports using XML Publisher/BI Publisher in OM, PO, AP, AR and INV.
• Customizing & enhancements on Forms.
• Imported Bills and Routings through BOM Interfaces.
• Extensively used SRW packages in Oracle Reports.
• Created Discoverer Reports for GL, AP, AR, ASCP and OPM modules using Discoverer Administrator and Desktop Edition. Created Custom Folders, Business Areas, and Workbooks. Assigned Privileges and registered the reports in Oracle Applications. Customized the Workbooks by adding additional functionality (conditions, calculations, parameters, sorting, etc.) and scheduling them for the users.
• Creation of Value sets in various Modules of the application.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Develop Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
• Worked with SQL Loader and PL-SQL Built in packages to convert VAX data into Oracle Applications as necessary.
• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• Created and customized reports using XML Publisher in OM, AR, AP and INV.
• Developed Sales order conversion using standard API.
• Wrote PL/SQL packaged procedure to be scheduled as concurrent program to identify and place payment holds for Contract Retention' invoices.
• Converted Oracle 6i Reports and SCM reports to BI publisher reports.
• Used SQL*Loader to load data from various sources into an Oracle database. Created automated scripts for handling multiple files and emailing the status of individual data loads.
• Created various PLSQL blocks to validate data using functions and procedures and used dynamic SQL to identify client specific requirements and loading into Oracle core tables form staging.
• Wrote PLSQL programs required for retrieving data from the Data repository using Cursors, UTL File I/O.
• Wrote various PL/SQL Packages, Functions and Procedures to implement the Business Logic for the specified client application.
• Created various database triggers for implementing data security across multiple financial sensitive tables.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexes to gain performance.
• Proficiently developed test cases in Quality Center.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Applied Performance Tuning logic to optimize session performance.
• Examined, reviewed, and/or changed code to adapt to changes in requirements.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle Database 9i/10g, SQL, PLSQL, TOAD, Oracle Reports Builder 6i, SQL Loader, UTL FILE.