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 Cloud R12/R13 (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, Farmington Hills, 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, Pleasanton, CA

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

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.

Confidential

Oracle EBS Developer

Responsibilities:

• Developed Packages to validate raw data from Flat Files and insert into tables.
• Reports in Cross Tab Layout and Tabular Layout Formats.
• Provided production support on GL, AP, AR, FA, PO, and modules and resolved period end closing and interface issues in production. Trained user on process design and enhancements.
• Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations.
• Worked on Secure Queues and Enqueuing Messages.
• Implemented schema validation at OSB proxy level using Validate action and reported back error.
• Developed services using Conditional Based Routing, Dynamic Routing and Routing tables to route messages to provider services.
• Parsed the JSON Format Data into the XML and vice versa using Web service.
• Used SVN for version controlling and ALM (Application Lifecycle Management) for ticketing system.
• Involved in creating ETL model (snowflake schema), normalizing and documenting
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Worked on customization of generating positive pay file as per client requirements for different banks and different currencies using outbound.
• Development of new OAF Pages, Regions and deployed into ORACLE EBS.
• Used PL/SQL Tables and Records in payroll generation process.
• Developed Forms (like invoicing, Delivery order) and Reports using Oracle Reports and PL/SQL.
• Performed tuning of queries and troubleshooting of database errors related to object size constraints.
• Customized the Reports in Cross Tab Layout and Tabular Layout Formats.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Involved in database development by creating PL/SQL Functions, Procedures, Packages, Cursors, Error Handling and Views.
• 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.