Venkata Ramana

Sr. Oracle Apps Techno-functional Consultant Fin & SCM & Oracle Cloud

Ph: 972-***-****

Email: adjo81@r.postjobfree.com

Having 12+ years of strong experience, includes Development, implementation, Support, customization of Oracle Application 11i & R12.2.6 using FIN & SCM P2P Modules (AP, AR, GL, CM, PO, INV, and OM, HRMS (Core- HR Payroll) in System Administrator, Application Developer).And Oracle Technologies (Reports 6i, Forms 6i, Forms Personalization, Oracle Discoverer 4/9.0/10g, Oracle Workflow2.6, Oracle Alerts, Oracle 11.2/10g/8.0/8i/9i and PL/SQL under Windows/UNIX environment.

Result focused & effectual point contact with strong communicational skills, over 9+ years of experience in IT Industry. Proactively identifying & resolving problems. Possess motivational management style with a record of building effective teamwork. Possess expertise in multicultural environments with the distinction of understanding, setup/streamline operations, skilled communicator with exceptional presentation skills and abilities to lead cross-functional teams.

Professional Summary:

Played a single point contact role for one of the critical implementations, support and enhancement in Oracle FIN & SCM modules (AP, AR, GL, CM, PO, INV, and OM. Oracle could FIN HCM. Involved in oracle cloud implementation project R13 on FIN and SCM Modules.

Ensured implementation Supports a member owning Finance & Distribution Modules like GL, AP, AR, FA, GL, PO, INV, HRMS (Core- HR Payroll). (EBS R12, and HCM, FIN Cloud). Enhanced EBS Techno-Functional support of the current EBS environment

Working production support team by assisting in application of patches, change control and coordination of system availability. Conduct research and testing of patches necessary to correct bugs and enhance system functionality.

Provided customized support of the current payment system in AP invoices, attachments, expense, pre invoice workflow payment issues, Process Flow Reconciliation issues. Maintain the vendor master list customer master list purchase orders, item master, item details (on hand, cost etc.), and attachments Price lists. Involved in AR transactions, adjustments, receipts, customer calls.

Involved Chart of accounts (COA) Transformation, values set and security rules. Extensive on-site exposure during Oracle Financials Migration in Saudi Arabia, NGHA (National Guard Health Affair Riyadh in Saudi).

Worked in Financial implementations and production support. Provided innovative solutions to unique customer requirements. Major Involvement/Key member in end to end Oracle Financials implementation.Expertise in providing custom solutions with Oracle Public API’s. Conducting business meetings and brainstorming sessions with the end-users to perform fit gap analysis and improve business solutions efficiency.

Experience is customizing the standard workflows in Oracle to suite business needs. Creating User training manuals, videos and conducting online training sessions. Performing manual testing, actively participating with User Acceptance Testing teams and proficiency in performing pre-production validation.

EBS-APEX integration & Solutions expertise. Implemented the Oracle EBS Application extensions, provided solutions beyond RICEW, and added another element A (APEX) to the listing at various clients.

Experience in Application System Administration activities like application user setup, defining responsibilities, value sets, registering menus, forms, reports and concurrent programs and assigning them to request groups and responsibilities.

Extensive experience on manual and automated testing to maintain documentation on different types of Testing viz., GUI, Regression, Integration, System, Performance and Acceptance testing. Experience in SDLC/Agile/Scrum development process.

Good team player in dynamic work group environments. Self-motivated to work independently.

Technical Skills

TECHNICAL SKILLS ERP

Oracle eBusiness and Cloud R13 Financial &SCM Modules (AP, AR, GL, CM, FA, INV, PO,OM )

Admin Tools &utilities

Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer 10g, Publisher, XML Publisher, Oracle Workflow, SQL * plus, Toad, FTP, putty, Rational Clear Case, Clear Quest, SVN, RADAR, CA Service Desk, SQL Loader.

Operating Systems

Windows XP&UNIX

Database

Oracle 9i, 10g& 11,12c

Languages

SQL/PL/SQL

Domain Expertise

Utilities/Banking/Manufacturing/Retail/BFS/Entertainment

Professional Experience:

Southern company, Atlanta, GA Mar’20 – Till Date

Role: Sr. Oracle ERP Cloud Techno Functional Consultant.

Module: Oracle Cloud (AP, AR, GL, FA, CM, PO, INV)

Description:Southern Company is an American gas and electric utility holding company based in the southern United States. It is headquartered in Atlanta, Georgia, The Company is currently the second largest utility company in the U.S. in terms of customer base. Through its subsidiaries it serves 9 million gas and electric utility customers in 6 states. Southern Company provide clean, safe, reliable and affordable energy through electric operating companies in three states, natural gas distribution companies in four states, company serving wholesale customers across America, a leading distributed energy infrastructure company, a fiber optics network and telecommunications services.

Responsibilities:

Developed supplier conversion program to load the suppliers from Oracle EBS into Oracle cloud by following oracle standard FBDI Format. Developed the conversion program to upload the Supplier Bank Branches, Accounts, payees from Oracle EBS into Oracle cloud.

Developed the GL conversion program to load the YTD, PTD, Transaction into Oracle cloud by Following by following oracle standard FBDI Format. Upload the Un cashed checks detail from Oracle EBS into Oracle cloud cash management.

Upload the Active Engineering Inventory items and categories detail to oracle cloud Product management system from Oracle ebs. Upload the active customer details into oracle cloud for invoice billing in cloud.Developed invoice conversion to upload the Payable open invoices, closed invoices from Oracle EBS into Oracle cloud. Upload the AR open transactions details from Oracle EBS into Oracle cloud.

Developed the BI bursting Report for supplier invoice details to provide the third-party system for reconciliation. Developed the Bi Bursting report for AR Transaction details to provide the business users about Invoice tax details.

Configured the po approval work flow. I expense approval hierarchy in cloud as per business requirement for smooth invoices approvals process and employee expenses process.

Prepared functional specification design documents (MD50) for Oracle interfaces like Purchasing/ Requisitions interface, Purchasing and Fixed asset, Payables, Supplier bank interface, Uncashed checks, Supplier Interface load data.

Prepared the Technical Specification document (MD70) For various modules to implement oracle cloud modules as per the business requirements. Expert in PAAS/ SAAS environments.Work with Oracle Support by raising SR to resolve Oracle Cloud issues with Oracle seeded functionality.

Used Agile Sprints project methodology to implement Oracle Fusion Cloud Financials/ P2P. JIRA is used to handle issues and user stories to track project work.

Worked on integration with Legacy System and Reporting.Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds. Works on the incidents/tickets (as part of the support) via ServiceNow and ensures SLA requirements are met.

Involved in requirements gathering, design, configuration, conducting various test events, issue resolutions and offshore - onsite coordination.Developed OTBI for real time reporting, BI Publisher reports (PO Printing, Check Printing,Invoice,suppliers.payments etc.). to support business needs.

Loaded trail balances and asset balances through WEB ADI, Prepare and Executing the Oracle ERP Test Plan from Functional aspects.Prepare the Test Data with the Setup changes in the Test instance.Prepared the Testing document for Oracle ERP cloud implement on for post load transactions with the business scenarios.

Works with Integration team to ensure the data is moved into cloud as expected- customers, invoices, credit memos, receipts and Journals. Custom process at ClubCorp which generates monthly statements for its half million customers.

Actively involved in EBS Retirement Project, where in some of transactions are being generated in the PAAS environment. Rolled out 9/200 clubs and progressing. PAAS server allows us to write custom code as Oracle Cloud does not allow any customizations.

Environment: Oracle EBS Application R12.2.6, AP, AR, FA, SLA, GL,PO, INV, SQL, PL/SQL, OATS (Oracle Applications Testing Suite), Toad, ServiceNow,Oracle Forms, Oracle Reports, OAF, Workflow and BI Publisher reports.

AMC, Kansas City,Missouri Jul’19-Jan’20

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM, PO

Description: AMC Theatres is a U.S.-based movie theater chain headquartered in Lea wood, Kansas, and is the largest movie theater chain in the world. AMC has the largest share of the American theater market ahead of Cine world and Cinemark and Odeon Theatres.

Responsibilities:

Developed payment unaccounted invoice details BI Report. Developed oracle form which is showing the invoice approval master details. Developed the oracle alert which is showing invoices exceeds 10k and send it to business stake holders on daily basis.

Involving Support business for period closing activity on account payables (AP) and account Receivables (AR), GL, FA, CM. Proactively working on productive 24X7 supports to end users for Oracle ERP application by Work on the production issues, defects and fix them on time.

Involved on COA (Chart of accounts) Transformation. Working with oracle support team on critical production issue to get the permanent solution on 24/7 support manner. Developed AP Invoice Details Report - By Payment Date reports.

Developed sales invoices credits report which is displayed customer invoices and credit memos and payment details. Developed the cash receipt creation interface. Developed the GL Interface Processor Developed AR - miscellaneous receipt interface, Developed Supplier Bank Account Create Interface Program.

Developed the Payables Aging Report, Developed the Invoice approver report. Cash Requirement Report to forecast cash needs for invoice payments. Hands-on experience in debugging problems through logs, backend programs. Developed Rent Variance Report Generator, OCR Invoice workflow status report.

Responsible for integrations, data conversion for customers, suppliers, AR transactions, GL budgets balances and fixed assets mass additions using Oracle File Based Data Imports FBDI and Rapid Implementation templates.

Developed and customized BI Reports/OTBI in Oracle Fusion Cloud using BI templates and scheduled the reports with to be delivered to Email and FTP sites. Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.

Configured and created Request sets, Request groups, Concurrent Programs, Executables, Key, Descriptive Flex fields, Lookups, Value sets, Menus & Menu Exclusions, Forms/Functions to support new Business requirements.

Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN and TK Prof for faster and better performance of the SQL queries. Developed the python scripts to generate the JSON/CSV feeds as per business requirements.

Worked on UNIX shell scripting for scheduling the corn jobs. Involved and resolved the month end and year end closing issues. Responsible to execute the test scripts and analyzed the results along with conduct functionality, Back-end and Regression testing during the various phases of the application.

Environment: Oracle EBS Applications R12.1.3 and OIC, AP, AR, FA, GL, SLA, CM, INV, PO, OM, SQL, PL/SQL,JSON, OATS (Oracle Applications Testing Suite), Toad, BI Publisher, SQL Developer, Oracle Forms, IT Remedy,Oracle Reports and Workflow.

C2FO, Kansas City, Missouri Dec19-Jun’19

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM, PO.

Description: C2FO is a financial Technology company and the creator of the first market for working capital. C2FO operates the working capital market. They do invoice discounting by providing early payment on invoices across various customers.

Responsibilities:

Developed Invoice interface program to fetch third party invoices into Oracle Payable system.Developed the outbound interface in payable to send the supplier remittance details into csv file.Developed Misc. Receipt report.

Customized the asset retirement report. Resolved Production Support tickets with a quick turnover time.Documented the development process as per AIM standards and for each object along with the test cases.

Designed and developed the AR Conversions during obsolescing the Operating Units.Customized the standard oracle reports such as AR Aging Report, AR Invoice Print Report, Inventory Cycle Count Report, Transaction Register Report,Payment Receipt Report etc. and converted them to XML Publisher format

Created triggers on order lines to perform custom validations.Provided Level 2 support to the business users to identify the problem and give a quick solution.Actively interacted with users in gathering requirements for development.Prepared standard AIM documentation for each object undertaken.

Involved in creation of PLSQL Web Services to access data from third party. Configured and created Key, Descriptive Flex fields, Menus & Menu Exclusions, Forms/Functions, Lookups, Value sets to support new Business requirements.

Developed and customization of reports using Oracle forms, Oracle reports, Workflow and BI/XML publisher. Developed test scripts for unit testing, system testing, and system integration testing. Estimate work effort and plan technical aspects of the project.

Developed technical design documents for the given functional requirements. Worked on Hudson tool for migration purpose from one instance to another instance. Involving in cut over and Go-LIVE activities.

Environment: Oracle EBS Applications R12, Sys Admin AOL, GL, AR, AP, PO, OM, INV, CM, SLA, FA, HRMS, Oracle 10g PL/SQL, SQL*Plus, FND, OAF, Toad, Reports 10g, Forms 10g, Workflow and BI Publisher.

Dish Echo star,Englewood, CO Feb’18-Nov’18

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM, PO.

Description: Dish Network is an American direct-broadcast satellite service provider. This company provides satellite television, audio programming, and interactive television services to commercial and residential customers in United States

Responsibilities:

Developed GL Account Wise Outstanding Balance As on Date.Developed Invoice interface program to fetch third party invoices into Oracle Payable system.Designed the Payment Reverse program to send the payment information to Expense system.

Developed Employee Interface Program to fetch employee details into oracle system.Design the outbound interface program to fetch invoice Payment Reverse from OGL to third system.Design the AME approval Setup for Oracle payable invoice approvals based on approval limit Invoice will trigger for next approval managers.

Customized the Fixed Asset Register Report to add some values added IT/Non-IT, Supplier Number, Invoice Date, Cost Retired, Proceeds of Sale, Gain/Loss, Indent Detail Report to display the requisition details and payments information against the PO. Enhancement’s Details Report.

Based on user ad-hoc request we have providing some report across FIN & SCM environment.Involved in supplier customer creations in production support based on help desk request. And involved in local tax issues.Involved in AP, AR, period closer issues to do the smooth month end closures.

Involved invoice payment process issues.Closely with Oracle support team for Monitoring the Oracle SR’s which we raised for user facing issues on priority basis.

Environment: Oracle EBS Applications R12, Sys Admin AOL, FND, GL, AR, SLA,,OM, AP, INV, PO, HRMS, XML Publisher, Oracle 10g PL/SQL, SQL*Plus, Toad, Reports, Forms, SQL*Loader, UTL_FILE, Discoverer, workflow Builder.

Western Union, Meridian, TX Apr’14-Feb’18

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM, AGIS

Description: Western Union Company is an American financial services and communications company. Western Union has several divisions, with products such as person-to-person money transfer, money orders, business payments and commercial services.

Responsibilities:

One-point contact to Contract profitability for any development/ Technical clarifications, involved in support issue which we received through it support tool and provide the solution on priority basis by 24/7 support in AP, AR, GL, CM,FA& AGIS Modules.

Handled application setups and Application configurations for Oracle Projects, Major contribution on inbound interface like Payable interface and Auto invoice interface where populate the legacy data in to oracle system.

Involving the Month end activity in AP Closure, AR Closer in finance modules.Involved in AGIS Batches clearance activity in daily basis as per the user requests.Majorly involved in Supporting Financial & SCM technical modules.

Developed database objects like tables, views, materialized views, triggers, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus. Worked on Standard Business Events with custom PL/SQL subscriptions and developed custom PL/SQL subscriptions in tractions, receipts, Credit Memos and Debit Memos etc. Developed conversion for legacy AP Invoices and Payments into Oracle Applications.

Involved in creation of PLSQL Web Services to access data from third party. Configured and created Key, Descriptive Flex fields, Menus & Menu Exclusions, Forms/Functions, Lookups, Value sets to support new Business requirements.

Developed and customization of reports using Oracle forms, Oracle reports, Workflow and BI/XML publisher. Developed test scripts for unit testing, system testing, and system integration testing. Estimate work effort and plan technical aspects of the project.

Developed technical design documents for the given functional requirements. Worked on Hudson tool for migration purpose from one instance to another instance. Involving in cut over and Go-LIVE activities.

Environment: Oracle EBS Applications R12, Sys Admin AOL, GL, AR, AP, PO, OM, INV, CM, SLA, FA, HRMS, Oracle 10g PL/SQL, SQL*Plus, FND, OAF, Toad, Reports 10g, Forms 10g, Workflow and BI Publisher.

CTS, Meridian, TX Jul’13-Mar’14

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM.

Responsibilities

Reviewing Business objectives, Understanding the Business processes and the feasibility study for the change.

Worked on the retro fitment and development of new reports (CFD’s) .

Part of Defects team along with development, handled defects after mock activities.

Creation of project installation guide and release notes for the installation.

Other Activities:

Prepared Technical specification for the functional specifications received.

Provide Development Approach for the Client requirements.

Design and documentation.

Performed Unit testing.

Performed estimation and planning.

Handled defects post mock activities.

VMware (CTS), India Jul’12-Jun’13

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM, Discoverer reports.

Description: VM ware (NYSE: VMW), the global leader in cloud infrastructure, delivers customer-proven virtualization solutions that significantly reduce IT complexity. VMware accelerates an organization’s transition to cloud computing, while preserving existing IT investments and enabling more efficient, agile service delivery without compromising control.

Responsibilities:

Developed the discoverer report SDP-Total Commit values by contract-summery.

Developed the discoverer report SDP-Total Commit values by contract-Detail report

Developed Aria Closed Transaction Report which is displayed RMA information.

Involved daily Sync UP call to get requirements from onsite team to implement the client requirements.

Involved code drop activities from Dev instance to UAT, CRP Instances and get the deployments as per schedule time.

Worked on the sales force bugs which is raised by user during testing period before migrating the code to prod.

TESCO, UK Aug’11’Jul’12

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM

Description: Tesco is a Fortune 500 Company, UK's leading and the world’s third largest retailer. Tesco operates over 2300 stores across 13 countries. Tesco HSC is the Global Services Arm, building competitive advantage for Tesco. The shared service center provides IT and Business services to make the Tesco experience better, simpler and cheaper for over 300,000 Tesco employees and 15 million Tesco customers worldwide.

Responsibilities:

Developed the Invoice interface to upload the legacy campus produce campus meat invoices in oracle base tables for the supplier payments. And reporting for the end of the month.Developed the AR Interface to upload the RetekReSAinvoicesinto base table Using AUTO INVOICE INTERFACE standard programmer.

Developed invoice hold alert which is sent to hold invoices to supplier so that supplier will interact the organization to release those invoices.Involved in I expense reports issues resolved in the sense whenever report stopped for managers approval and workflow related issues.

Responsible for fixing production issues, addressing user queries, ad-hoc requests within SLA to ensure all business functionalities and applications are maintained.Managing and delivering the Change Requests (CR), Problem Records (PR) and Incident Records (IR) within the time of SLA.

Batch scheduling and monitoring the oracle jobs in production instance.Preparing Test scripts and co-ordinate and assist testing team to complete the testing on time.Prepared MD50,MD70 and MD120 installation documents

Developed Discoverer reports and documentation.Designed and Customized the Workflows.Developed / Customized the following reports using BI publisher,

Customized / Tuned the following reports

Invoice Aging Report

Accrual Reconciliation Report

Aging By Account Report

ECE payables VAT register Report

BILT, GURGAON, India Feb’09-Jul’11

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM

Description: Ballarpur Industries Limited (BILT) is India's largest manufacturer of writing and printing (W&P) paper. BILT's subsidiaries include Sabah Forest Industries (SFI), Malaysia's largest pulp and paper company, and BILT Tree Tech Limited (BTTL), which runs BILT's farm forestry program in several states in India. BILT has six manufacturing units across India, having dominant share of the high-end coated paper segment in India.

Responsibilities:

Developed Retail Invoice Report which are displayed to customer, invoice and item Information based on the sales order.Developed TDS reports in AP which are displayed supplier tax deduction details for issuing the Form-16 for the specific Fin-Year.

Developed the Creditor accounting ledger report which are displayed the customer outstanding for The Specific period in AR.Developed Misc. Receipt report. Customized the asset retirement report.

Monthly uploading of legacy data as and when received from 6 locations into AR, AP and GL.Involved in the Month Closing Activities.Developed the Purchase order register report in PO, which is displayed PO Number, item, quantity, Tax information.

Discoverer Reports:

Retail Inventory Detail: This report displays the Finish Quantity, Receiving Quantity, and Staging Quantity of all Retail Items according to sub inventory Code.

Retail Sales Report: -This report displays the Sales Details like Sale Order no, Date, Transaction no, Delivery No, Additional Information, Customer number, Name etc.

Internal Sales Order Pendency: -This Report shows the internal sales from one Location to another Location. i.e. Product Type, Product Name, From Location, To Location, Order No, Item code, Units Of Measure etc.

Oracle Alerts.

Developed a Retail alert which is showing customer outstanding balance.

Entitlement alerts which are showing employee aliveness for monthly wise.

AT&T, India Sept’08-Jan’09

Role: Oracle Application Techno- Functional Consultant

Module: AP, AR, GL, FA, CM, PO, INV

Responsibilities:

Developed credit limit alert using oracle alerts for control the customer limit.

Developed on event alert to know message whenever supplier creation in account payable module.

Worked on data loader program to upload the data from excel sheet to oracle apps base table on Sourcing rules, assign sourcing rules, approved supplier list, par level quantity and unit of measure conversion data by using data loader program.

Registered PL/SQL packages, Forms, Menus and reports as concurrent programs.

Contact this candidate