SUMMARY:

• Over 7+ years of experience as Oracle EBS Techno - Functional Consultant in multiple Implementations, R12 Upgrades and Support projects in Oracle E-Business Suite 11i (11.5.10) & R12 (12.1.3, 12.2.5), Oracle Fusion Cloud ERP Saas/PaaS.
• Experienced in implementing ERP Cloud, EBS R12 and 11i applications.
• Experience in various modules such as Financial 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.
• Efficient programming skills in PL/SQL, Stored Procedures, Functions, Database Triggers, Packages with Oracle Database 9i/10g/11g/12c on Implementation/Upgrade/Support projects of Oracle 11i/R12 E-Business Suite.
• Experienced in design and developing integration between 3rd party systems like Concur and Workday with Oracle EBS.
• 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.
• Sound functional knowledge of Order to Cash (O2C),Procure to Pay (P2P) life cycles
• Experienced in RICEW (Reports, Interfaces, Conversions, Extensions, Workflow) and performance tuning of SQL, PL/SQL and Views.
• Good experience in Data Conversions and design/development of Interfaces using Oracle open interfaces and Oracle Public API s for various Financial and Manufacturing modules.
• Experience in creating and customizing existing and new reports using reporting tools like Oracle Reports 10g/6i and BI Publisher (XML Publisher).
• Experience in creating, customizing and administrating Discoverer reports/workbooks using Oracle Discoverer 10g/4i reports and Oracle Discoverer Administrator 10g/4i.
• Good exposer to Label printing solutions using Loftware and Bartender.
• Good experience in study of existing business process and preparation issue logs, collection of functional requirements, client/user interaction, Confidential Analysis, technical data mapping analysis and design of technical/functional data process flow charts.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, reports using Report builder 6i, XML Publisher & BIRT, Form 6i/9i and exposure to Work Flow, Form personalization.
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and OAF Customization.
• Experience in developing new custom pages using OAF in 11i and R12 versions of Oracle EBS.
• 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.
• Extensive experience on AOL/System Administration tasks like Concurrent Programs, Registration & setup of Forms/OAF pages, Flex fields, Value Sets, Lookups, Menu and Responsibility.
• In-Depth knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import, data fixes.
• Experience in working with the utilities like TOAD, SQL* Loader, Version Control System like Microsoft Visual Source Safe 6.0 and Serena PVCS VM 8.0.
• Good interpersonal skills, the ability to interact with people at all levels, and excellent communication skills.
• Ability to gather and understand user requirements and translate into technical/Funcational specifications. Ability to learn quickly new technologies and solve problems in a team environment and multitasking.
• Experience in performing code reviews and ensure that all over programming quality as per standards. Experience in troubleshooting and resolving issues with technical, functional and DBA teams.
• Experienced working with Offshore-Onsite model with US clients.
• Developed Inbound and Outbound interfaces using SQL*Loader, UTL FILE, PL/SQL Packages and SOA/BPEL. Sound knowledge of Oracle Application tables, Schema, Interfaces, Application Program Interface (APIs) and MOAC. Documentation experience, keeping in line with the AIM Methodology (MD70, MD50, CV040, CV060 MD120).
• 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
• Capable of working independently and as well as a part of a team and working under pressure and deadlines.
• Excellent skills resolving issues in supply chain and finance modules of techno-functional nature Experienced in opening/following-up service requests (TAR or SR) with Oracle Support.

TECHNICAL SKILLS:

ERP APPLICATIONS: Oracle Applications R12 (12.1.3/12.1.1 ) and 11i (11.5.10/11.0.3 ), AR, AP, GL, CE, FA, OM, HRMS, PO, INV, WIP, BOM, ASCP, AOL

RDBMS: Oracle 11g, 10g, 9i/ 8i / 7.x, SQL Server

LANGUAGES/ FRAMEWORKS: C, C++, PL/SQL, Java, HTML, XML, XSLT, UNIX Shell Script, BPEL Bourne Shell Script, OAF, SOA

BUSINESS INTELLIGENCE: XML/BI Publisher, Discoverer Reports, Developer 10g, 6i Reports

TOOLS: TOAD, SQL Navigator, SQL Developer, SQL* Plus, Visual Source Safe 6.0, SQL*Loader, JDeveloper, Forms Builder, Reports Developer, Workflow Builder 2.6.3, Discoverer.

HARDWARE: AIX, Sun Solaris (SPARC 32-bit), Pentium M

OPERATING SYSTEM: UNIX, LINUX, Windows 95/98/2000/ XP/ NT/Windows 10, Windows 7 and SunOS

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Oracle Techno Functional Consultant

Responsibilities:

• Understanding the existing functionality and business requirements.
• Working as a developer in OBIEE/OTBI Reports. Retrofitting the SQL queries in RPD and doing the unit testing in OBI reports.
• Developed OTBI Reports/ BI Reports.
• Worked on conversions and interfaces.
• Oracle ERP Financials cloud involved in defining configurations for modules AP/AR/GL.
• Worked on IRS Database application integration to oracle cloud.
• Work on Account Payables (AP) Roles, create Business Unit Location, Business Unit, Reference Data, Legislative Data Group and assign to LE, Suppliers, Bank, Bank Branch, Bank Account, Submitting LDAP job, Open Invoices Conversion Process i.e. File Based Data Import (FBDI) process, Supplier Conversion Process through FBDI, creating BI Report, OTBI Reports etc. Prepare the meeting minutes, process mapping validation, and Functional Assessment documentations on the basis of requirement gathering session, Oracle Unified Methodologies (OUM) and business interaction.
• Create new Payment Process Request (PPR) template for Check Printing, ACH, and ACH credit card process, configured Schedule Payment Selection Criteria, Payment Attributes, Process Automation, and Validation Failure Result.
• Work on Account Receivables (AR) Roles, define Transaction Types, Transaction Sources, Auto Accounting Configuration, Payment term, Collector creation, Customer, site, Profile Class, Memo Lines Creation, Submitting LDAP job, create Invoice Transaction, Automatic Receipt, Auto Invoice Conversion Process through File Based Data Import (FBDI) process, Customer Conversion Process, Standard Receipt Conversion Process etc.
• Work on preparing Scope documents, Gather Business Requirements (RD.050), Define Application Set up (BR.100), Map Business Data (BR.040), Create Application Extension Functional Design (MD.050), Develop System Test Script (TE.040), Develop System Integration Test Script (TE.050) and Perform Acceptance Test (TE.130).

Environment: Oracle Application 11i/R12 12.1X and 12.2X, Oracle Fusion Cloud ERP Saas/PaaS AP, GL, AR, CE, FA, Accounting Generator (AG), SLA, PO, Approval Management (AME), Workflow Administrator Web Application, 1099 Tax, IRS database, SQL, PL/SQL, XML and TOAD.

Confidential, Tampa, FL

Oracle Techno Functional Consultant

Responsibilities:

• Worked on day to day production support on various modules Oracle Projects (PA), Accounts Payables (AP), Purchasing (PO), Accounts Receivables (AR), General Ledger (GL) and Fixed Assets (FA).
• Worked of Oracle Project Proposal Templates, removal and addition of tasks on proposal templates.
• Implemented full Contract Billing and Reporting / Team Invoicing Assistant procedures and Views that flow back to CBR and bridges back to Oracle.
• Customized the GL Reconciliation Report to view all converted companies previously had a limitation when converted from 11i to R12.
• Customized the transaction program which transfers the Invoices to Projects from converted OU.
• Implemented the PLSQL to allow the creation of PO and REQUISITIONS in the converted OU which is restricted by a validation Program previously.
• Modified the custom WEX Entries Package to spawn the child Jobs on Load Transfer Price WEX entries.
• Worked to revoke users and their responsibilities for the Converted Employee.
• Worked with DELL STAT Application Management Tool to deployed Objects from Development to UAT and UAT to Production Instances and Database.
• Conversion
• Worked on Contract Rules and Templates, Clauses conversion.
• Worked on PO Attachments Conversion.
• Performed Projects conversion country by country.
• Performed Internal and External Vendors, Banks, Bank Branches Conversion.
• Performed part of AR, FA, and GL Conversion.
• Reports / XML Publisher
• Developed ARM Manual Reporting includes ARM AR Report, ARM AP Report, ARM Unapplied Receipts Report.
• Customized the Printed PO for English and Spanish using XSL Format.
• Worked to Setup the GRC Form rules personalizing for AP Form to prevent Payments, Cancellations, Adjustments to the converted Invoices using DFF at header level and form library modification to force read only.
• Worked to Setup the GRC Form rules personalizing for AR Form to prevent Payments, Cancellations, Adjustments to the converted Invoices additionally locked down the cash receipts, Misc., and GL Distributions.
• Implemented Custom WEBADI supporting reports/processes for Manual Logs.
• Created a PLSQL for WEBADI functionality and has setup the Integrator and ADI Templates.
• Implemented Custom AP Invoice Upload WEBADI which helps to upload invoices
• Customized iExpense Page to view only employee expense information to inquiry by project and inquiry be employee.
• Customized iExpense Report to generate from the non - converted OUs.

Environment: Oracle Applications R 12.2.4/12.1.3 , PA, PO, iProcurement, iExpense, AR, GL, and AP, INV, Oracle 11g, PL/SQL, UNIX, SQL*Plus, SQL*Loader, Oracle SQL Developer 4.2, Oracle Reports 6i, Oracle Workflow Builder 2.6.3

Confidential, Englewood, Colorado

Oracle Techno Functional Consultant

Responsibilities:

• Designed customizations, interface/conversion mapping, pre - production testing, and related documentation.
• Developed and customized Financial Modules (AP, PO, AR, GL, FA, CE, iProcurement, SLA and PA), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Wrote Technical MD70 design documents and Conversion Mapping Documents for various interfaces.
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• Designed, developed and documented the Custom Interfaces for AP modifications based on Business requirements when Project Accounting is installed
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production
• Designed, developed and documented an inbound interface for AP Invoices from windows-based applications.
• Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
• Responsible for running the Open Interface to import data from PO interface tables into the base tables.
• 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
• Forms / Reports / XML Publisher/ Discoverer
• Developed various Custom reports including preliminary & post payment register reports.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR)
• 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)
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer
• Created MD070 and MD120 for the Custom Form.
• Customized forms using CUSTOM.PLL file to meet the specific requirements

Environment: Oracle Applications R12.1.3, AP, PA, AR, GL, FA, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, reports builder 9i, forms builder 9i, Vertex Integration, Solaris, PVCS, Rational Clear Quest.

Confidential, Newark, CA

Oracle Techno Functional Consultant

Responsibilities:

• Designed customizations, interface/conversion mapping, pre - production testing, and related documentation.
• Developed and customized Financial Modules (GL, AP, PO, AR, FA, CE, iSupplier, iProcurement, SLA and PA), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Wrote Technical MD70 design documents and Conversion Mapping Documents for various interfaces.
• Involved in Designing and Implementing an effective Chart of Accounts Structure Using Oracle Applications
• Developed conversions and custom PL/SQL API s for converting GL and PO from a legacy system into Oracle Applications.
• Written an API for Converting the Invoice Payments (AP) and could convert all the Historical Invoice Payment History into Production.
• Designed, developed, and documented the Custom Interfaces for AP modifications based on Business requirements when Project Accounting is installed
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables as per Client Requirements.
• Designed, documented, and developed staging tables, conversion routings, custom PL/SQL API S for converting project, tasks, and expenditure in Project Accounting (PA).
• Project/Program/Sub-Program and Task Conversion
• Transaction Import
• Revenue and Invoice Conversion
• Funding/Agreement Conversion
• Budget Conversion.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import Standard Purchase Orders into Production
• Designed and developed a custom PL/SQL code to call the standard API's in the Installed Base and Service Contracts module to update install base instances and contract records to reflect correct ownership information for drop-ship orders
• Developed PL/SQL Procedures for using multi-Currency processing, revaluations, and consolidations
• Designed, developed, and documented an inbound interface for AP Invoices from windows based applications.
• Responsible for providing production support for Account Receivables (AR), Purchasing (PO), Sub Ledger Accounting (SLA) and Account payables (AP).
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management (CE) Interface.
• Responsible for running the Open Interface to import data from PO interface tables into the base tables.
• 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
• Performed user requirements gathering to design and develop an interface between a legacy system and Oracle Service Contracts module. Developed, tested and debugged the interface using standard and custom API s.
• Developed a PL/SQL program, which reconciles the Reply Bank file data (Auto Lockbox) and calls Receipt API to reverse the receipts for which credit card status is declined.
• Developed various Custom reports including preliminary & post payment register reports in SRS, RDF, OBIEE, and XML BI Publisher.
• Designed and developed Custom Reports in PO and Accounts Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance 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 Purchase Order (PO).
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR)
• 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)
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer
• Built custom Invoice Work Bench enquiry Form.
• Performed Form Customizations on Invoice Workbench Form and Pcard Form.
• Developed and customized
• Designed and developed following custom form using Forms 10g AR Eligible Invoices for CC Payment - A Query find form is provided for the users to find the eligible invoices for credit card payment by a customer. It has the capability of querying on customer name, number and Invoice range. It has the capability of sending and resending a notification to customer s email address.
• Personalized standard Purchase Order, Blanket Release Forms to make the DFF for CC email address mandatory when payment method is credit card. Also, email address format and domain are validated when a value is entered
• Created MD070 and MD120 for the Custom Form.
• Customized forms using CUSTOM.PLL file to meet the specific requirements
• Developed billing nightly batch script to submit and validate various billing related requests including submit payment batch set, AR refund invoice approval, submit invoice supply costs, submit post payment process, update payroll request & FC billing notification.
• Developed a host script for general FTP/SFTP related file transfers in & out of Oracle system. This script reads the config file parameters and does the appropriate transfer.

Environment: Oracle Applications R12.1.3, AP, PA, AR, GL, FA, CE, iProcurement, iSupplier, SLA, PO, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, reports builder 9i, forms builder 9i, Vertex Integration, Solaris, PVCS, Rational Clear Quest.

Confidential, Salt Lake City, UT

Oracle Techno Functional Consultant

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.

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.

Confidential

Oracle Financials Analyst

Responsibilities:

• Developing Procedures, Function, Packages for Custom applications
• Created backend table for java relevant services.
• Created SQL, PL/SQL scripts for Custom Applications
• Preparing Technical Documentation.
• Resolved issues of invalid objects in schema and compiled it using Compile Utilities (DBMS DDL, DBMS UTILITY, UTL RECOMP, and UTLRP.sql).
• Data setup in Oracle General Ledger, Oracle Receivables and Oracle Payables.
• Involved in various activities like preparation of technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing.
• Setup and customization of ORACLE Payables and data conversion from legacy system into ORACLE Payables
• Importing Vendor and Invoice information into ORACLE Payables using stored procedures and SQL*Loader.
• Designed, developed, registered customized forms, tables and reports using AOL.
• Developed customized Reports like aging analysis, Outstanding Invoices, and Customer wise report for amount that is considered bad debt.
• Create Users and assigning Responsibilities for Security.
• Defining New Descriptive flex fields.
• Created Value sets and value set values.
• Manage Concurrent Processing and Concurrent Manager.

Environment: SQL, PL/SQL, Java, Oracle 9i, Windows NT.