SUMMARY

• Around 8 years of IT experience as Oracle EBS/Cloud ERP Techno Functional Consultant working implementations, upgrades, extensions and Support projects primarily on Financials and Supply Chain (SCM) modules.
• Experienced working with various RICEW design, development and customizations in Procure to Pay (P2P), record to Report (R2R), Customer to Cash (C2C), Order to Cash (O2C), Available to Pick (ATP) business processes.
• Proficient in Reports development and customization using Reports Builder 11g/10g/6i, XML/BI Publisher, OBIEE 11g/10g, Discoverer, EIS Reporting as part of Oracle EBS Development.
• Well versed with various Oracle Cloud Development tools including FBDI for interfacing, ADFDI for spreadsheet loading, OTBI/ OBIP for Transactional reports development, SmartView and FRS for Balance level data reporting, BPM for Business Process Flow Management, OIC for Integrations, Sandbox personalizations and Customization, Security Console for User Role Management.
• Extensively worked on Conversions from Various legacy applications into Oracle Cloud using Rapid Implementation templates and FBDI for Supplier Master Data, Customer Data, Open Transactions, Open POs, Journal Imports, Historical Exchange Rates, Balances, Assets, Banks and Bank Accounts etc.,
• Expertise in Oracle core application development such as registration of Custom applications, creating database objects like Tables, views, packages, procedures, functions, registration of Forms and Reports, Registration of Custom Menus and Responsibilities following application hierarchy.
• Worked on creating custom XML templates for ISO200022 Payment files for checks, ACHs and Wires across the globe.
• Worked on Oracle Cloud Imaging OCR Implementation, customization and Testing.
• Experience with internet modules including iSupplier, iProcurement, iExpense and iReceivables.
• Good knowledge in AIM (Application Implementation Methodology). Expert in documenting Specification documents like MD70, MD50, MD120.
• Proficient in designing and building process for data flow of interfaces and conversions utilizing: SQL Loader, UTL FILE utilities, staging data, and interfacing using APIs and Oracle standard interface process.
• Worked with UNIX shell scripting to automate the execution of the batch processes.
• Substantial development experience in creating stored procedures, APIs, Packages, Triggers, Functions, Indexes and Views.
• Expertise in Client - Server application development using Oracle Database 19c/12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Experienced with Version Control and code Migration software.
• Well versed with oracle support, opening of SRs, maintaining SRs and bug fixing, Conducting OWC sessions and working 24/7 to resolve high priority issues.
• Excellent communication skills self-motivated and adapt to new technologies in a short period of time. Strong problem-solving skills and analytical skills.
• Worked in Onsite and Offshore model projects, coordinating and leading offshore team
• Trained the client’s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.
• Experience interacting and driving internal product teams, the user community, IT Operations and Executives; Experience with Functional Teams with a Strong focus on Group dynamics.
• Experienced working on PERL, Linux shell scripting and Batch programming.Developed XML files using PL/SQL packages as per the user requirement.
• Experience in Data warehousing concepts and Decision Support Systems using ETL Tools.
• Experience performing Unit and Integration Testing, System Testing and User Acceptance Testing (UAT).
• Major strengths are familiarity with multiple software systems, tools and the ability to learn new technologies and adapt to new environments.

TECHNICAL SKILLS

ERP Solutions: Oracle ERP Cloud R12/R13 General Ledger, Accounting Hub Cloud Services AHCS, Payables Cloud, Procurement Cloud, Receivables Cloud, Revenue Management Cloud, Expenses Cloud,Oracle EBS 11i/R12(12.0.6, 12.1.3, 12.2.5) (General Ledger (GL), Purchasing (PO), Accounts Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), Order Management (OM), Inventory (INV), General Ledger, Accounting Hub/SLA, EBTAX, iExpenses, Sourcing, iSupplier, iProcurement, Shipping (WSH), Advanced Pricing (QP), Application Object Library (AOL), Bill of Materials (BOM), iStore, Approval Management (AME)

Languages: SQL, PL/SQL, Java, C/C++, UNIX Shell Scripting, XML, HTML

Oracle Cloud Tools: ADFDI, FBDI, SOA, BPEL, BPM, OTBI, BI Publisher, Financial reporting Studio, Smart View Reports

Oracle Development Tools: SQL Developer, TOAD, PLSQL Developer, SQL Navigator

ETL Tools: ODI, Informatica Power Center, SQL Loader

Oracle Applications Tools: Oracle Reports Builder 11g/10g/9i/6i, Oracle Forms Builder 12c/11g/10g/9i/6i, XML(BI) Publisher, Workflow Builder, Discoverer 10g, Web ADI, Oracle Application Framework, Oracle APEX

Operating Systems: Windows Pack, Unix, Linux, Sun Solaris, AIX

Oracle Database Utilities: UTL FILE, DBMS Utilities, AWR Reports, TKPROF

Export/ImportScheduling Tools: Control M, AUTOSYS, Crontab, DBMS SCHEDULER

Implementation Methodologies: Agile (Scrum/KANBAN), AIM, OUM

Version Control Software: PVCS, Visual Source Safe, Rational Clear Case, GIT HUB

Testing Tools: HP Quality Center, HP ALM

Integration Software: Oracle Integration Cloud, Mule Soft

Databases: Oracle RDBMS 10g/11g/12c/19c, SQL Server, MongoDB, MYSQL

Ticketing Software: Jira, ServiceNow, Confluence

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Senior Oracle Cloud Technical Consultant

Responsibilities:

• Analyzed various technical and functional requirements for enhancements, performed risk analysis for mapping the business processes, designed, and developed solutions. Understanding the gaps, recommended the necessary customizations in external systems integration process.
• Supported distinct Finance subject areas including Account payables, Account receivables, Cash Management, Assets, Expenses, General Ledger, Inventory, Purchasing and Order Management.
• Created and/or raised incidents/tickets on behalf of customers and assign it to the appropriate teams. Coordinated with different teams to analyze and resolve issues and scheduled periodic calls.
• Coordinated with change management team to deploy the new changes.
• Analyzed the RCDs and performed extensive testing in the Oracle Upgraded instance from technical standpoint.
• Authored Technical documents for the proposed custom extension for Third Party Payment Processing. Designed and developed Third Party payments efficiently automating the process of Supplier relationship creation.
• Customized various standard templates in Oracle Cloud payables, purchasing and receivables including AR Aging Report, Purchase Order Print, Expense Report, Invoices On-Hold, Supplier Payment History, Subledger accounting activity, Journal Entries Report, Billing History Report, and Invoice History Report and Others.
• Created various dashboards using the subject areas of Oracle OTBI for outbound data extraction.
• Worked extensively on creating Integrations such as Daily exchange rates, AP Invoices, AR Invoices using FBDI templates. Automated File loading, transformation, parsing and schedule process submission utilizing Oracle Integration Cloud Services (OIC) using rest APIs and Prebuilt Adaptors.
• Resolved month end accounting issues by providing one-off solutions and permanent fixes working in collaboration with Oracle Support team.
• Implemented ISO20022 format across various countries for various Payment Methods in Cloud Payables.
• Proactively worked on Client 1099 issues and resolved year end issues.

Environment: Oracle ERP Cloud Financials R13 (GL, AP, AR, Expenses, PO), OTBI, OBIP, FBDI, ADI, BPM; Oracle EBS (12.2.8) (GL, AP, PO, XLA, EBTAX, iExpenses, iProcurement, AR, Inventory, OM), Reports 12c, Forms 12c, Workflow Builder, SQL, PLSQL, TOAD

Confidential, Bedminster, NJ

Oracle EBS/ERP Cloud Support Specialist

Responsibilities:

• Worked on Development of Importing invoices from legacy system to Accounts Receivable module.
• Worked on archive and purge process that will save the AR invoices in a file until a given date and then deletes the records from tables.
• Extensively worked on iExpenses AMEX Credit Card Integrations.
• Involved in Loading and importing credit card transactions and exporting the expense report into Oracle Payables in Oracle Financials.
• Creating the incidents/tickets on behalf of customers and assign it to the appropriate teams. Coordinate with different team to and schedule the calls.
• Coordinate with change management team to deploy the new changes.
• Involved in Procure-to-Pay process(P2P) from creating requisition, PO, confirming the Receipt, creating Invoice, Paying the supplier and Transferring to GL.
• Customized Sales Order form to add customer fax, email and phone number contacts.
• Worked on Development of creating receipts from cash management and apply it to invoices loaded in Accounts Receivable Module.
• Customized General Ledger report of general ledger data inclusive of all interfaced sub ledgers and data from source systems using XML Publisher.
• Developed shell scripts for importing AR invoices which calls SQL Loader, Custom validation procedure which runs through AUTOSYS.
• Resolved issues in AR automatic import process and manual upload to load invoices into Accounts Receivable module as part of production support.
• Designed MD70 for AR Interface import from legacy system to Oracle Receivables in Oracle Financials as part of AIM Documentation.
• Extensively tested oracle upgrade instance, identifying issues, supporting business functionality & resolving issues working in proximity with business users and Oracle Support.
• Prepare Test cases and execute test scenarios on all SCM modules at different phases of the project
• Acted as a primary point of contact for conducting all inbound and outbound interface testing during various phases of upgrade testing.
• During the Support phase, Applied various Recommended patch Collections (RPCs), for AP, Suppliers, Workflows and Cash management. Analyzed and applied various GDFs in payables and applied RCA patches to fix the issues permanently.
• Developed, tested and delivered various custom reports using EIS reporting as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Allocation of labor, Timeliness of Payments, Rejected Invoices register, etc.,
• Given 24/7 support to the team during the go live phase for meeting deadlines with complete documentation and testing.
• Worked on development of AR import based on mapping rules and incorporated business validations to the existing.
• Interface developed for other billing system feed to Oracle Receivables (Navision) in Oracle Financials.

Environment: Oracle Applications R12 (12.2.6), (GL, AP, XLA, AR), Oracle Database 12c, SQL, PL/SQL, Reports Builder 11g, Forms Builder 11g, Workflow Builder 2.6.5

Confidential, Palmyra, NJ

Oracle EBS FINANCIALS/SCM Developer

Responsibilities:

• Worked on Customization of PO Account Generator WorkFlow to update the logic for the accrual account for expense items to copy the company segment of the charge account to the company segment of the accrual account.
• Update the Account Generator Process for the Set of Books to use the new workflow process.
• Worked on customization of Quote Approval Process Workflow notification needs to be from the person who created the version, if no versions exist then it would be created by. And we have to remove the margin % information from the notifications, both from the email and work list sections.
• Customization of AR Aging Borrowing Base Report to calculate the age based on either invoice date or due date.
• Customization of Move Transaction Report to add Over completion transaction quantity, Over completion Primary quantity, Source Code, Reason Code, Reference columns. Created package to get the output in PDF/EXCEL format.
• Performed Sales Order Form Personalization to populate the request date same as the promise date and schedule ship date as two days before the promise date.
• Involved in the development of various technical specification documents (MD70), for custom objects developed.
• Worked on the development of Interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such as AR, INV, OM.
• Worked on implementing the data movement strategy using the Oracle 10g to Oracle 11g and Oracle Export/Import process.
• Worked on ETL using Oracle Apps and stored procedures.
• Developed interfaces, conversions and other enhancements which included part of customizations in Receivables (AR).
• Involved in making necessary research and resolving outstanding functionality issues via periodic patch updates from Oracle.
• Developed UNIX shell scripts for Inbound and Outbound programs for incoming and outgoing data files.
• Designed and developed Purchasing, Order Management, Shipping and Inventory reports using Discoverer.
• Performed Configuration of Procurement and iProcurement by setting up Purchasing options, Accounting Options, Jobs, and Approval Groups.
• Wrote complex queries involving multiple-joins to generate user reports.
• Implemented PL/SQL scripts in accordance with the necessary business rules and requirements.
• Worked on PO Vendor Conversion.
• Tested the P2P flow end to end.
• Worked on different Invoice match options in P2P flow.

Environment: Oracle Applications R12.1.3 (GL, AP, AR, PO, OM, INV), Oracle Database 11g, Reports Builder 10g, Forms Builder 10g, SQL, PLSQL, Discoverer Administrator/Plus 10g, Workflow Builder.

Confidential, Atlanta, GA

Oracle Application EBS Consultant

Responsibilities:

• Worked closely with Business Users and Product Architects to understand the requirements for performing data extracts for conversion and building new integrations.
• Design and Build various RICEW components in financial modules as per the business needs. Develop various custom extensions to support business use cases.
• Wrote custom programs using API's to load the vendor and customer data into oracle from legacy applications. Built integrations from Supplier Onboarding and Qualification Management system Process unity before creating Suppliers in Oracle EBS.
• Involved in all RICEW validation meetings with various business stakeholders and coordinate on UAT.
• Worked on development of AP and AR open transactions conversion process during the implementation of the new operating Unit, collaborating with Confidential IT team.
• Designed and developed various Oracle RICE enhancements especially around Custom AME rules, Approval workflows, Account Generators, Interfaces and Various Reports.
• Personalized seeded and custom OA Framework pages to hide fields and buttons on the pages.
• Implemented AP Invoice import through Payables Open Interface Import Program
• Designed and developed Technical Designs & unit testing documents for various database components.
• Worked on Journal Interface, Disasters, and budget interface Programs in GL reviewed Journal Import Execution, corrected Journal Import Data and initiated posting.
• Developed fully customized reports in AP (Remittance advice, Check), AR (Invoice, Credit Memo, Aging Buckets reports (collector/account), Statement of Accounts-print Statement etc).
• Worked on various payment integrations with HSBC, JPMC, TDBANCK and CITI for processing wires, checks, ACH and SEPA payments as per client requirements.
• Worked on SFTP to internal IMFT server and configured security rules as per client global policies and implemented PGP encryptions for all payment outbound integrations.
• Worked on ADP GL Interface program to load the data into GL open interface and bank recon load interface programs to load the data into bank statement interface tables (CE).
• Worked on Concur to Oracle EBS integrations to import Expenses for Payment processing.
• Personalized seeded and custom OA Framework pages to hide fields and buttons on the pages.
• Extensively utilized JIRA for program tracking as part of AGILE development team.

Environment: Oracle Applications R12 (AP, PO, GL, INV, AR, iProcurement, FAH/XLA, AGIS, EB Tax, AME), Oracle RDBMS 11g, CONCUR, UNIX, Developer Suite10g, Workflow 2.6, XML Publisher, SQL/ PL/SQL, SQL*Plus, TOAD.

Confidential, Baltimore, MD

ORACLE APPLICATIONS DEVELOPER

Responsibilities:

• Responsible for developing XML Publisher reports for various modules like Purchasing, General Ledger and Payables.
• Developed PL/SQL Programs/ Packages for Customer Conversion.
• Developed Available Inventory reports using Oracle Reports 10g.
• Developed new forms and new reports using Oracle Forms 10g and Reports 6i/10g.
• Extensively used Dynamic SQL in Oracle Forms and Oracle Reports.
• Developed PL/SQL script to Import Customer Invoices into Invoice Interface tables and imported into base tables using Auto Invoice Import Program.
• Created invoices in AR using Auto Invoice Import program.
• Developed Training Material for OM and AR modules and prepared impact analysis for critical issues
• Created technical design for item conversion. Used standard Inventory Application Program Interfaces supplied by Oracle.
• Responsible for developing Oracle Discoverer reports based on the modules like Purchasing, General Ledger and Receivables.
• Involved in requirements gathering and testing (Unit, Mock, Pre-Production).
• Interacted with business users to resolve any issues during the development, mock testing, and Pre-Production testing and production phase.
• Developed the reports in R12 based by validating standard and 11.0.3 custom reports.
• Developed the reports Inventory Transaction Warning Report, Inventory Transaction Warning Report, Vender Change Information Report, MOH Cost Extract Report, STD Update Report for Purchased Item Report, Sales Order Lines with available FG Inventory, Item Validation Detail Report, Item Validation Summary Report, ISO Backlog Report, AP Check Printing Report.

Environment: Oracle Applications 11i/R12 12.0.6, AP, AR, GL, PO, INV, OM, Reports Developer 10g, Forms 10g, SQL, PLSQL, XML Publisher, TOAD.