Oracle Cloud Functional Consultant

502-***-**** pa

*********@*****.***

Oracle Cloud Techno Functional Consultant

Name: Naga Pavani Polapalle Mob: 502-***-****

email:***************@*****.***

• Having 10+years of good experience in Oracle Applications and 1+ years of experience in Cloud and have been extensively worked in Development, Support and Testing projects

• Good experience in Oracle Application Finance (P2P/R2R) and SCM Modules, which includes AP, GL, I Expenses, Cash Management, FA,OM and PO

• Excellent development experience in coding Functions, Procedures, Packages and Triggers in PL SQL

• Excellent development/Support experience in P2P (Procure to Pay) & Order to Cash.

• Having 1+ years of experience in Manul Testing.

• Good development Experience in Interfaces, Workflow, Alerts and Forms Personalization.

• Customization on Approval Management Engine (AME) for GL, AP approval Workflow.

• Worked in OIC using REST/SOAP APIs

• Download and upload the objects from one instance to another instance through LDT's.

• Extensive experience and strong knowledge of Quality Assurance in Retail, ERP

• Expertise and proficient in Software Testing Life Cycle (STLC) – Requirement Analysis, Test planning, Test design, Test data identification and Defect management.

• Strong proficiency in using Q Test for test case management, defect tracking

• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing.

• Developed Custom BI Publisher Reports as per Business need.

• Experience in creating SQL*Loader control programs and PL/SQL validation scripts.

• Involved in gathering requirements from the customers and create a user story for the same.

• Created setup documents and defined setups in AP, PO modules

• Very proficient in using Oracle Application Implementation Methodology (AIM) for documentation (MD050, MD070, TE020)

• Developed and customized Reports using Discoverer Desktop according to the client's specifications and requirements.

• Good Knowledge on UNIX & Shell Scripting.

• Good working experience in JIRA/GitHub/PVCS and Kintana

• Knowledge in Salesforce.

Oracle Cloud Techno Functional Consultant

Name: Naga Pavani Polapalle Mob: 502-***-****

email:***************@*****.***

Technical Skills

Oracle Cloud AP, GL and HCM

ERP Oracle Applications R12.1.3, R12.2.6 and R12.211 (AP, OM, GL, I Expenses, PO) Development Methodology Agile, Waterfall

Languages PL/SQL (Oracle 11/12C and 19 C)

Database Oracle SQL

Project Management Tools SQL Developer, TOAD, JIRA, Q test Reporting Tools XML Publisher, BI Publisher

Cloud Applications Salesforce, Oracle Cloud

Version Control tools GitHub, SVN, JIRA

Work History:

Role: Oracle Lead Technical Consultant

Duration: Nov’2024 to Present

Project Location: Louisville, KY

US Radiology is a leader in connecting the top radiology providers across the country. Investing in infrastructure, integrating technology, and executing local and regional growth strategies across all partners. Our mission is to make the best of radiology to improve lives.

Environment: Oracle Cloud Fusion

• As an Oracle lead Technical consultant, involved in Data Migration project and leading the migration of radiology from legacy systems to Oracle cloud, ensuring seamless Data conversion and working with business to understand the legacy systems.

• Working on Conversion & Data migrations from different legacy systems which include HCM, Finance, SCM modules

• Build strong relationships with business users and co-ordinate with multiple teams.

• Enhanced validation and reconciliation by incorporating detailed comments on analysis reports, targeting inconsistencies in the data along with Unit Testing.

• Defining COA segments to align with business requirements ensuring scalability and as per business need. Oracle Cloud Techno Functional Consultant

Name: Naga Pavani Polapalle Mob: 502-***-****

email:***************@*****.***

Role: Oracle Techno Functional Consultant

Duration: Jul’2022 to Oct’2024

Project Location: Louisville, KY

Lattice Semiconductor is an American fabless semiconductor company based in Hillsboro, Oregon, and founded in 1983. The company designed circuits for mobile phones, consumer electronics and personal computers. Environment: Oracle EBS (OM/WSH) and PO, Inventory

• As an Oracle Techno Functional consultant, involving in Supply Chain modules such as Order Management, shipping, Purchasing and Inventory modules. Working on GAP analysis, discussing in design solutions and closely working with business to understand the requirements. • Developed a custom program to download the orders to WMS systems

• Customization/Enhanced a Ship confirmation program in Oracle.

• Orders being created from Custom Applications and book the orders in Oracle through OIC by using REST/SOAP API’s

• Ensured that all orders have a positive lead-time and appropriate order processing procedures are followed for rush orders.

• Build strong relationships with business users and co-ordinate with multiple teams (SOA/DBA/Oracle Support and etc.)

Role: Sr Oracle Technical Consultant

Duration: Jan’2018 to Jun’2022

Project Location: Atlanta, GA

ESS Technology Inc, designs and markets high-performance digital video processor and imaging sensor semiconductors for the consumer digital entertainment, digital home, and camera-enabled cellular phone markets. ESS products include highly integrated chips for DVD recorders, DVD players, VCD players, digital media players, digital audio systems, and camera phones.

Environment: Oracle Apps R12 (P2R/R2R)

• As an Oracle ERP developer, involved in multiple modules in Oracle ERP/EBS including finance modules such as Accounts Payable, General Ledger, Cash Management, I Expenses, iProcurement Fixed Assets and Project Accounting.

• Modified the GL Daily Rates program to improve the performance from 6 hrs. to 10mins

• Created Oracle Alerts to sends notification/mail to business users. Oracle Cloud Techno Functional Consultant

Name: Naga Pavani Polapalle Mob: 502-***-****

email:***************@*****.***

• Created new Separate Remittance Advice Templates, modified Payment Format RTF Templates as per country requirements.

• Customizations on AP Invoice Interface for EDI source of Invoices

• Customization on Approval Management Engine (AME) in I Expenses, AP Invoice, GL Journal Approval Workflows

• Developed a program to identity the Accounting Issues and send a mail to Biz users.

• Pro-active checking for smooth books closure for every Month End or Quarter End or Year End.

• Handling CCB (Change Control Board) Meeting to evaluate all fixes going into Production to make sure existing functionality will not be broke.

• Helped user to reconcile the AP and PO recon process

• Helped user to reconcile the APTB and GLTB issues

• Monitoring and scheduled the jobs through Tidal Schedular tool and taking appropriate action on the same

• Worked on Production incidents raised by business users (called as Remedy Incidents or Cases or Tickets) and provide resolution as per agreed support timelines.

• Handling Month End/Quarter End/Year End close activities and issues.

• Co-ordinating with Oracle and working on getting the bug fixes on the seeded application issues. Role: Oracle Technical Consultant

Duration: Aug’2014 to Dec’2016

Project Location: HYDERABAD INDIA

Environment: Oracle Apps R12 (P2R/R2R)

Cisco Systems, Inc. is an American multinational corporation head quartered in San Jose, California, that designs, manufactures, and sells networking equipment, was founded in 1984.Cisco IT has implemented Oracle applications R12 to track their business for various tracks. Financials related to Cisco are being supported by IT Finance.

• As an Oracle ERP developer, involved in multiple modules in Oracle ERP/EBS including finance modules such as Accounts Payable, General Ledger, Cash Management, I Expenses, iProcurement Fixed Assets and Project Accounting.

• Developed Unix program to compare job statuses before Ramp Down and after Ramp Up

• Customization of Supplier Invoice Account Generation Process

• Regular sync up with Business and leads on weekly basis to discuss on on-going priority issues, status and problems/issues business team is facing with application

• Pro-actively identifying gaps in system or business process (if any) and working towards implementing LTF

(Long Term Fix)

• Pro-active checking for smooth books closure for every Month End or Quarter End or Year End Oracle Cloud Techno Functional Consultant

Name: Naga Pavani Polapalle Mob: 502-***-****

email:***************@*****.***

• Managing offshore team and helped team based on need basis

• Defining Code combinations, security rules, Value Sets, Look Ups

• Working on incidents related to all financial modules

• Working on Enhancement requests

• Monitoring schedule jobs through Dollar Universe tool and taking appropriate action on same.

• Developed a form personalization to restrict user to do not enter any special characters when entering a invoice number

• Developed the BI report to identify the duplicate Invoices and send a mail to specific DL. Role: Oracle QA Analyst

Duration: Apr’2013 to Jul’2014

Project Location: HYDERABAD INDIA

Lexmark International, Inc. is a privately held American company that manufactures laser printers and imaging products. The company is headquartered in Lexington, Kentucky. Since 2016 it has been jointly owned by a consortium of three multinational companies’ apex, PAG Asia and Legend Capital Environment: Oracle Apps R12 (OM)

• Created, Updated and Reviewed of Test cases and Test Scenarios as per the business requirement and executed them Q test tool.

• Maintained and coordinating the offshore and onsite team.

• Experienced at testing flat file data transfers to third party servers.

• Preparation and execution of E2E, Integration Test scenarios.

• Conducting Sanity tests in UAT and Production.

• Maintain/develop the automation scripts as per new stories and changes. Personal Information:

VISA : EAD and Exp: 10/25

Linkdin: www.linkedin.com/in/pavani-polapalle-051900255

Contact this candidate