Oracle Cloud Business Intelligence

PRIYANKA YADAV

Oracle ERP Cloud Techno-Functional Consultant

Email: *******.*****@*****.***

Phone: 440-***-****

PROFESSIONAL SUMMARY

•Having 6 Years of Experience in Oracle Finance Technical Consultant in Oracle Cloud Fusion Application (R13-23A) & Oracle Integration Cloud (OIC-R13-23A) Premier Pass Integration Product (PaaS)

•Exposure in the areas of Oracle Applications Modules in General Ledger (GL), Account Payables (AP), Accounts Receivable (AR), Cash Management (CM), Fixed Assets (FA), Purchasing (PO), Inventory (INV).

•Exposure in Oracle SaaS Cloud implementation experience with Oracle Fusion Modules of Financial implementation/Support Project(R13)

•Expertise in building complex integration processes, integrating cloud-based and On-Premises Enterprise Applications.

•Hands-on design, development, deployment, and maintenance of integration processes between on premise\cloud systems and other 3rd party applications

•Experience Oracle Integration Cloud (OIC) adapters, usage of REST Adapter, SOAP Adapter, ERP Adapter, Salesforce Adapter, FTP Adapter, usage of App Driven Orchestration, App Driven Orchestration integration patters.

• Experience in REST APIs/End Point, SOAP Web Services and FBDI Templates in Oracle Cloud Application.

•Experience in Oracle Transactional Business Intelligence (OTBI), and Business Intelligence Publisher (BIP)) to develop new reports and enhance standard ERP Cloud reports in Oracle Cloud Financial Module.

•Experience in Oracle Application Implementation, Enhancement, Upgrade, Customization, Production Support in Oracle Application (11i & R12)

•Experience in Procure to pay life cycle (P2P) & Ordered to Cash (O2C).

•Expertise in requirement analysis, System design, Data Flow Designs, supports, development, testing,

Documentation and design reviews

•Experience in Business process study during discovery and scoping phase, requirement gathering set up configuration and documentation.

•Experience in using Oracle AIM of project implementation methodology and preparation of CV060, MD070, TE020, MD120 and User Manuals, Training Material Preparation

•Technically proficient in RICEW components (Report, Interface, Conversion, Extension and Workflow)

•Having Good Exposure in Data Migration and worked as a Technical Team Lead with data transformation, data cleansing & data validation team.

•Having Good Experience to Manage the Oracle critical SR’s and Spin SR

•Having Good Team Handling and Client Management skills.

•Expertise in On-shore and Off-shore delivery Model Team Handling.

•Strong perseverance and diligence towards attaining challenging goals and effective time management.

•Good communication and presentation skills

•Good Analytical skills and Planning and Co-ordination skills

CERTTIFICATIONS

Oracle Cloud Infrastructure 2023 Certified Application Integration Professional

Oracle Cloud Infrastructure 2023 Certified Foundations Associate

Oracle Financial Cloud Payables 2018 Certified Implementation Specialist

IT SKILL SET

ERP Modules: Expertise: Oracle Cloud SaaS/PaaS Application (R13.23A)/Oracle E-biz Suite Financials (GL, AP, AR, FA &CM), SCM (INV, PO), Manufacturing (OM, INV, WIP, BOM) in 11i, R12.1.2 – R12.2.9.

Tools & Utilities: SQL Connect by Splash BI, SQL Developer 19.2.1.247, Oracle Data Base 9i, 11g, 12C, 19C, Data loader, MS Visio, MS Office 2003, 07, 08, PUTTY, WinSCP, STAT, SQL*Loader, XML 12.0.0, Oracle Report/Form 6i, 10g, Oracle Workflow Builder 2.5, SoapUI 5.6.0, Postman v7.32.0, Oracle ADF 11g Desktop Integration.

Operating Systems: Windows 2007 NT/XP, UNIX, MS-DOS.

PROFESSIONAL EXPERIENCE

1) Project Title : American Axle & Mfg Inc

Project/Client : American Axle & Mfg Inc, Detroit, United States

Duration : Dec-16 to Jul-21

Role : Oracle EBS Application Technical Consultant

Description:

This is a Support Project in Oracle ERP Application R12 and enhancement in Oracle Cloud Application R13(21,22,23A). The job involves development and Production support for Oracle Inventory, Oracle Purchasing, Oracle Payables, and Oracle General Ledger, Fixed Asset, Work In Process, cash management, Bills of Material, etc.

Job Responsibilities

•Working as a Finance Technical Lead and Developer for this Oracle ERP Support Project

Involved in understanding the business process Requirement, provided solution & development for Data Migration, BIP/OTBI Report & Service Integration in OIC Jobs.

•Interacting with Business/Users for required information about issue in the Finance Track module arises in ServiceNow.

•Handling issues and bugs related Tickets in the Service Now, resolving the issues on day-to-day basis on priority.

•Worked on the Sandbox, Application Composer, Subscription Service mappings and Groovy Script.

•Worked on the Configuration of DFF value from OSS to AR.

•Modified the Standard “Print Receivables Transactions” report to Custom as per German Localization.

•Develop the OIC job to Update Historical Data for AR Invoices and Credit Memo DFF in a Bulk.

•Worked on OIC Inbound/Outbound OIC Jobs for Downstream and Upstream System

•Worked on to developed various Report using BIP/OTBI in Oracle Cloud.

•Worked on Month End Activities with Business/IT Team.

•Responsible for document review and Unit Test case Preparation.

•Worked to migrate objects from one instance to another instance.

•Managed Oracle Critical SR and Spinning SR with Oracle during Oracle Development/Support Time

•Developed Audit XML extract file for Luxembourg Tax Authority.

•Developed an alert for checking the missing Bank statement on daily basis and uploading the same to avoid month end issue.

•Developed an alert for checking the Workday issue.

•Modified the AP interface Error alert for checking the stuck invoice in interface and keep monitoring on daily basis.

•Modified the Uninvoiced PO Receipts alert for checking the issue for Uninvoiced Receipts.

•Developed the report for reallocating the FA Book from an old location to another location using Oracle standard API.

•Developed the HSBC payment file format for India.

•Worked for PPI Interface - clean-up for DICAP.

•Worked for AAM Supply Chain Indented Bills of Material Cost Report.

•Worked for SPDB payment file format for China.

•Development of packages & procedures as per client coding standards.

•Worked in OBIEE Report.

•Worked on APEX Form.

•Provided End to End Technical support to the financial track.

•Developed ‘AAM Journal Detail Extract for EMO’ and ‘AAM Mexico Commitment Details Extract’.

•Worked with STAT tool to migrate objects from one instance to another instance.

•Handling the Daily Status Call with customer and Team.

•Assigning the issue ticket to the team member from Service Now.

•Registrations of AOL objects

•Preparation of MD070 and the required documents as per the client standards.

•Giving production support for the Finance module.

•Prepared the RCA, Job Aids and SIP documents which help which is very much essential for the Business.

•Worked on the lockbox related issues.

•Worked on the OBIEE report.

•Working on the SIP, RCA’s, Value Aids, and enhancements.

•Responsible for document review and Unit Test case Preparation.

2) Project Title : Automated Process - Attends

Project/Client : Attends Healthcare, Sweden, Australia

Duration : Oct-16 to Nov-16

Role : Oracle EBS Application Technical Consultant

Description:

This is an automation Project in Oracle EBS Application R12. This job involves the interface in order to cash in Order Management.

Job Responsibilities

•Working as a Finance Technical Consultant and Developer for this Oracle ERP Automated Project

•Involved in understanding the business process Requirement and provided the solution.

•Interacting with Business/Users for required information about issue in the Finance Track module.

•Developed Outbound Interface.

•Developed Inbound Interface.

•Development of packages & procedures as per client coding standards.

•Worked with FNDLOAD utility to migrate objects from one instance to another instance.

•Registrations of AOL objects

•Preparation of MD070 and TE020 Documents.

3) Project Title : Attends Healthcare AB (Upgradation)

Project/Client : Attends Healthcare, Sweden, Australia

Duration : Dec-15 – Sep-16

Role : Oracle EBS Application Technical Consultant

Description:

Oracle Application upgrade project to move 11i to R12. To take advantage of the technological improvements in the product to ensure compatibility and at the same time to leverage additional features and functionalities provided by Oracle in its latest releases to achieve technology led business growth.

The primary role in this Project is developing Configuring and Implementation new changed Objects Retrofitting in R12 and provides the solution to customer. This job involves development and Customizations of Reports and Concurrent Program for Oracle Inventory, Oracle Purchasing, Oracle Payables, and Oracle General Ledger, Fixed Asset, Work in Process.

Job Responsibilities

•Working as a Technical Consultant and Developer for this Oracle Apps R12.2.1 Upgrade Project

•Involved in understanding the business process requirement& upgrade changed Cemli Objects from 11i to R12

•Working as a Finance Technical Consultant and Developer for this Oracle ERP Upgrade Project.

•Involved in understanding the business process Requirement and provided the solution.

•Interacting with Business/Users for required information about issue in the Finance Track module.

•Responsible to identify all the impacted Object after Upgrade the system and provide the solution to customer.

•Responsible for code review, document review, Document/Code versioning and file management control in Common Share point.

•Worked with FNDLOAD utility to migrate objects from one instance to another instance till Production.

•Run the GSS Program to Improve the performance after upgrade the system performance issue

•Worked on Oracle Business Event/Alert/Form Personalization/Custom Hook &Custom Pll, XML Reports

•Developed AP Extract for Asset Load Report Through Web Adi.

•Developed the Project Plan Report in WIP.

•Worked on PL/SQL procedures, packages, Data base triggers and Functions, tables, sequence synonyms, views and indexes for modification and retro fitment in upgraded 19C Oracle Data base.

•Developed BR100, TE040, MD070, TE020 and MD120 Documents

•Technical Support, Guidance and Planning for Code migration from Development through Production

•Managed Oracle Critical SR and Spinning SR with Oracle during Oracle Upgrade Time

•Managing the Tickets, resolving the issues on day-to-day basis on priority after Go-Live.

•Responsible for post go live support resolution delivery.

EDUCATION

•B. Tech in Computer Science Engineering from the College of Science and Engineering, Jhansi (GBTU University)

Contact this candidate