SUMMARY

• 8+ years of extensive experience in Oracle Cloud R13 SAAS/PAAS, Oracle ERP R12, REST/SOAP Web Services with expertise in Design, Development, Testing, Technical Support.
• Executed several Oracle ERP/Cloud Financials implementations and upgrades, including Fusion/Cloud ERP (SaaS) as well as E - Business Suite.
• Having experience in implementing and extending Oracle Fusion Cloud (Fusion Financials, PPM, Fusion Procurement, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, Order Orchestration).
• Experience in business intelligence reporting tool like Oracle Cloud OTBI, OBIEE and Financial Reporting Center Tool (Smart view).
• Good Experience in Oracle Cloud standard tools for integrations within ERP with ICS (integration Cloud Service) and Web Services.
• Executing data conversion for customers, suppliers, open AR transactions, GL balances, budgets and fixed assets using Oracle Cloud FBDI and ADFDI templates.
• Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System.
• Good exposure on Oracle EBS Order to Cash (O2C), Procure to Pay (P2P) business flows.
• Expertise in implementing RICEW (Reports, Interfaces, Conversions, Extensions, Workflow) components in technical design, development, Integration testing and deployment.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Worked with Arrays, Records, Dynamic SQL and Exception Handling.
• Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQL trace and TKPROF.
• Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.
• Automating data loading, extraction, reports generation using UNIX Shell scripting.
• Experience in handling very large data files using Export-Import Utilities and SQL*Loader.
• Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i/6i, Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.

TECHNICAL SKILLS

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

Oracle Procurement Cloud: Purchasing, Supplier Qualification, Supplier Portal

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

PROFESSIONAL EXPERIENCE

Confidential, Kalamazoo, MI

Senior Oracle Cloud Consultant

Responsibilities:

• Configuration of multiple ERP Cloud prototypes (Financials and Procurement Cloud).
• Hands on configuration of all the Financials modules on multiple ERP Cloud instances.
• Developed outbound interfaces using BI publisher approach.
• Worked on Inbound and Outbound Integrations in Cloud Financials Modules.
• Worked on Oracle Cloud Financials, P2P, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, Accounts Receivables, Accounts Payables.
• Created outlines, calculation scripts, member formula and business rules, Data forms, reporting with Smart View.
• Development of new custom reports with OTBI and BI Publisher for Financials and Procurement modules.
• Configure the Fusion Cloud Applications to meet client requirements and document application setups.
• Developed OTBI reports for to view and validate employee data using existing subject areas.
• Created reports using Financial Reporting Studio (FRS), Smart View, and Oracle Transactional Business Intelligence (OTBI).
• Conducting iterative CRP, System Integration and UAT sessions and issue resolution
• Customization of BI Publisher templates for checks, positive pay and Confidential payment files
• Design, configuration, testing and implementation of Oracle Subledger Accounting journal line descriptions and Account Rules.
• Implementation of integration of Oracle Receivables Cloud with legacy billing system
• Worked on google cloud platform (GCP) services like compute engine, cloud load balancing, cloud storage, cloud SQL, stack driver monitoring and cloud deployment manager.
• Designing and developing various OMS inbound/outbound interfaces using OSB and BPEL.
• Implemented REST API Web Services to Interact with Third Party API’s.
• Integrated with Business Applications like Oracle EBS and Oracle Seibel UCM with Third party Systems.
• Worked on SVN Repository tool to maintain the code for Versioning.

Confidential, Chicago, IL

Oracle Cloud Consultant

Responsibilities:

• Developed a Conversion program for creating Customer Accounts, Customer Sites, Site Uses, Profiles and Profile amount based on Oracle Cloud architecture.
• Worked on Fusion Reporting technologies BI Publisher, OTBI & FRS for Fusion Financials.
• Developed new Rules as per business requirements in the Custom Rules library.
• Involved in Auto generating the code like interface package, using Dynamic SQL.
• Understanding nonstandard requirement and in preparing Documents.
• Code reviews, document reviews of peers
• Developed OBI Reports/OTBI Analytics for Fusion Cloud Payables, AR and GL Cloud modules.
• Conduct Conference Room Pilot (CRP), SIT and UAT Trainings, and end user trainings.
• Built Custom Security to Fusion Modules which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles using APM, OIM and Security console.
• Worked on FBDI, Smart View for inbound integrations in financial system.
• Worked with Oracle Cloud SCM/Financials Modules.
• Worked with Cloud integration technologies with Web Services and OIC (Oracle Integration Cloud).
• Participated in the ongoing process enhancements and modification requests.
• Developed scripts in UNIX for daily backup using Cron tab.
• Tested, installed, documented and provided on call support for the applications.

Confidential, Dallas, TX

Oracle EBS Consultant

Responsibilities:

• Developed PL/SQL packages, functions and procedures and Oracle reports and adhoc reports.
• Consume Web Services as Data control and populate data on pages.
• Done the setups for Document number sequencing for AP.
• Done setups for Auto Accounting rules, and Auto Accounting.
• Worked on all type of AR transaction like Standard Invoice, Debit Memo, Credit Memo, Charge Back Invoice, and Deposit Invoice.
• Worked on Sales Orders Open Interface in Oracle Order management module to import Sales Orders.
• Developed reports using XML/BI Publisher in AP, AR, PO and GL Modules.
• Worked on Invoice Approval Workflow customization.
• Developed new Oracle Form (Sellers Workbench) as per client requirements.
• Worked on VO and CO extensions in iProcurement.
• Worked on OAF page Personalization in Supplier Page.
• Created Database objects such as Tables, Views, Procedures, Functions, Triggers and Packages.
• Worked on XML Publisher reports like Order Determination, AR Credit Memo Report, Charges Reports.
• Developed MD70 Technical Design Documents based on business requirements to include technical details for each deliverable such as input data format, table mapping, flow chart, concurrent program names and order of execution.
• Created various custom reports like Transaction Aging Report, Credit Card Transaction Report, Active Invoice Register Report, Account Balance Consolidation reports and others using Reports Builder 6i.
• Coordinated with DBA in improving database performance.
• Written Test Plans and Involved in Unit testing.
• Used the FTP commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process.