Oracle Management

Chandra Poruri

Oracle Techno Functional Consultant

Summary:

Over 10 years of experience in Information Technology as Oracle Techno Functional Consultant in successfully implementing enterprise applications with global clients.

Understood and Studied the current business processes/requirements and future business flow in order to provide an integrated information system solution to meet the business needs of the company.

Multiple Implementations of full system development life cycle(SDLC) across financials include - iexpenses, iprocurement, Inventory, Purchasing, Payables, Receivables, Fixed Assets, Cash Management, Subledger Accounting, E-Business Tax and General Ledger modules.

Possess working knowledge and also have Solid experience in defining processes relative to Procure to Pay, Order to Cash, Record to Report and Close Processing.

Experienced in iProcurement/PO approval routing through AME Rules and workflow

Expertise in wide range of Oracle Applications modules which includes Oracle Purchasing, Oracle Inventory, Order Management, Iprocurement and Isupplier Applications.

Conducted the Gap Analysis in order to understand the 'as-is' and the 'to-be' scenarios

Designed new Budget Structure in GL based on State allocated Appropriations and Segregations.

Modified Entire Rollup Structure for Chart of Accounts and definition of new Summary Templates.

POC and Implemented Encumbrance Accounting for the New Budget setup.

Defined Budget Organization, Budget, Budget Journals, Uploaded Budgets, Budget Formulas, Mass Budget. Enabled Budgetary Control, Encumbrance Types, Enter & Post Encumbrances Carry forward Encumbrances. Revaluation, Translation, Consolidate set of Books and worked on Year End Process

Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations.

Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.

Well-versed with E-Biz Tax configurations, setup configuration owner tax options, created Party Tax Profiles, Tax Regimes, First Party Legal Entity Party Tax Profile, Tax, Tax Status, Tax Jurisdictions, Recovery Rates, Tax Rates and Tax Rules

Configured Banks, Bank Branches, Bank Accounts and Bank Transaction codes

Worked on integration of Cash Management with Payables, Receivables and General Ledger.

Worked on reconciliation process – Manul clearing process, manual reconciliation, automatic reconciliation

Entered Bank statements manually and imported bank statements for file formats BAI2 and Swift 940 by running Bank Statement Import program

Reconciled Bank statement lines by running AutoReconciliation Program, highlighted un reconciled lines

Worked on transferring balances from one bank account to another bank account by configuring Intra / Inter company setups in GL

Conducted Oracle CRP sessions to demo the out of box functionality on the Financial modules

Conducted Functional Testing, Systems Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Smoke Testing by preparing test plans, test cases and test data to be used further by collaborating with QA team

Expertise in the AIM Methodology, Documentation (RD020, BP040, BP080, BR100, MD050, TE040, etc.), Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials Fusion Cloud, R12, &11i in iexpenses, iprocurement, Inventory, Purchasing, AP, AR, FA, CM, E-Business Tax and GL modules.

Mapped the Legacy system functionality to what was available in the Oracle applications for Requisition, PO, AP modules, identified gaps and offered solutions.

Designed and executed several Customizations and Setups in ERP as part of Revenue Recognition solutions

Supported the production environments and users on a daily basis by resolving user issues.

Analyzed user needs, conferred with users to improve procedures and implemented optimized solutions.

Logged, viewed, accessed, monitored, followed up and closed the Service Request (SR) with Oracle Support.

Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, Accounts Payable, Fixed Assets, General Ledger and Cash Management modules

Manage on-site and off-shore development and support teams

Skill Summary:

Oracle Financial Applications

Receivables, Payables, General Ledger, Fixed Assets, Cash Management, SLA and E-Biz Tax

Oracle Supply Chain Applications

Purchasing, Inventory, Order Entry, Advanced Pricing, Shipping Execution, Demand Planning, Material Planning, ASCP

Oracle iModules

iProcurement, iSupplier, iExpense

Other Tools

AIM, Web ADI, Dataloader, TOAD, HP ALM

Programming Languages/Databases

SQL, PL/SQL, SQL*Plus

Operating Systems

Windows 95/ 98/ NT/ XP/ 2003/2010/2013/2016

Project Management tools

MS Word, Visio, Power Point, Excel, Project, Remedy,JIRA

Life Cycle Experience

Requirement Analysis, Functional Modeling, Legacy Systems Integration, Business Process workflow modeling

Education: Bachelor’s Degree in Commerce

EXPERIENCE:

XL SOFTEK INC Mar 2017 - Till date

Systems Analyst – Team Lead

Project: Ohio National – Oracle Finance Transformation Program

Client: Ohio National, Cincinnati - OH Jul 2017 – Till date

Role: Support Analyst Oracle Fusion Cloud

Project: Oracle Finance Transformation Program Fusion Cloud Post Production Support

Ohio National Financial Services is into offering of Life Insurance Policies with coverage’s into Fixed, Fixed Indexed and variable annuities, Retirement Plan Products, Variable, Universal, Whole, Term Life Insurance and Disability Income Insurance.

Ohio National went live on Oracle Fusion Financials cloud Implementation during Jul 2017

Responsibilities:

As part of the Finance Transformation Program

Analyzed the current system by interacting with business and cross functional teams.

Conducted Key User Training to Business users

Worked on configuration changes.

Analyzed the issues on Production System and resolved them.

Worked on Production support related incidents and resolved incidents meeting SLA

Project: IDP, LLC Oracle Financials Implementation

Client: IDP, LLC, Alpharetta - GA Mar 2017 - Jul 2017

Role: Business Analyst Oracle EBS

Project: Oracle Financials EBS Implementation

IDP Electronic Medical Records (EMR) & Medical Practice Management System

A web based Electronic Medical Records (EMR) & Medical practice Management system.

The software intended to be develop is an online web based Medical Practice Management system intended to computerize Infectious Diseases Professionals (IDP) clinic and provide a seam less integration of its various processes.

Key responsibilities:

As part of the assignment worked on this in house project by coordinating with client on the requirements gathering phase As-Is and design of To-Be process

Project: IDP, LLC Oracle Financials Implementation

Accenture July2010 - Mar 2017

Team Lead

Client: QBE Insurance, New York - NY. July 2016 – Mar 2017

Role: Business Analyst Oracle EBS/Team Lead

Project: Oracle Financials Fusion Cloud Implementation

QBE Insurance has its vision to be the most successful global insurer and reinsurer in the eyes of its customers, people, shareholders and the community.

Responsibilities:

Contributed as Team Lead at QBE Insurance in the Finance Transformation Programme (FTP), which involves Business and Technology change programme to drive QBE Finance towards their vision.

Responsible for Implementing Oracle Financials Fusion Cloud for all of the QBE’s divisions in European Operations (EO); North American Operations (NAO), Australia & New Zealand (ANZ); and Emerging Markets (both Asia Pacific and Latin America)

Led successful Oracle EBS upgrade project (from 11i to R12.2.3 to Fusion CLoud); completing it within the budget and timeline along with smooth first month closing.

Implemented iexpenses, iprocurement, inventory, purchasing, Payables, Receivables, Fixed Assets, General Ledger, SLA, E-Biz Tax and Cash Management modules in Oracle Financials and Fusion Cloud

Key responsibilities:

Managed a team of 20 members during Implementation Life Cycle

Worked on implementing internal requisition and internal sales orders as a solution for intercompany transactions.

Worked on solution design and setup of Inventory, Purchasing & Order Management as per the client requirements and suggested business process changes.

Requirement gathering, Configured Inventory, Purchasing and Order Management during the implementation life cycle.

Provided solution to better manage recalls in all the locations around the globe.

Setup and maintenance of all the alerts and notifications.

Worked towards the proof of concept and involved in defining the organization structure.

Worked on item conversions and prepared conversion documents (CV10, CV040)

Handled conversion stages for Inventory and Purchasing modules. Designed dataload scripts for manual conversions

iProcurement & Centralized Purchasing - Implementation of centralized purchasing process to ensure a specific group within ORG manages corporate purchasing and implement iProcurement self-service requisitioning application

Master Data Cleanup – Suppliers, Customers, Trading Community, Supplier Merge etc.

Worked on various interfaces, conversions where QBE integrates its Financial data to and from various third party source systems

Designed workflows as per the business need in iExpense, Purchasing, Payables and General Ledger

Prepared Functional Design Documents FDD’s based on the requirements gathered

Fixed Assets –

oCreation of new Books, Review current Asset Books and reclass Assets, Depreciation Methods, Define Asset Categories, troubleshoot Accounting & Configuration issues

oUser training of Web ADI templates and troubleshoot issues relating to missing asset life, categories, location, Excel errors etc.

Receivables –

oCustomized Receipt application to provide user ability to match multiple entity Receipts-Invoices that have a combination of both positive & negative amounts using a single application HTML form to avoid cumbersome processes used earlier

oResolved errors related to billing import from third party integrations and custom Print templates used for invoice printing

Environment: Oracle Financial Applications R12/Fusion Cloud (iexpenses, iprocurement, inventory, purchasing, Payables, Receivables, Fixed Assets, General Ledger, SLA, E-Biz Tax and Cash Management)

Client: Cisco Systems, San Jose - CA. Mar2011-Jun2016

Role: Oracle Support Analyst/Lead

Project: Oracle Financials R12 Production Support Location:

Team Lead and SME of Oracle Financial modules. Lead support activities of finance modules with Cisco engagement.

Responsible for GLOBAL PRODUCTION SUPPORT (24x7) for CISCO IT Systems on Oracle Financial Applications R12. Managed several modules (iProcurement, iExpenses, PO, AP, AR, FA, GL, CM and Customs) in Oracle financials which include events from Purchase Requisition to Accounting in GL Modules along with interaction with the Boundary system (Upstream / Downstream application).

Receivables –

oExperienced in working on the Revenue Accounting Engine (RAE) which enables those capabilities that would be common to a number of the Revenue Business Architecture systems and centralize them into a single “capabilities engine”. The RAE would be a “behind the scenes”, foundational technology layer supporting a number of Revenue Systems and capability needs.

oIn Cisco, revenue recognized on a sale transaction is determined or recognized based on transaction type. They are standard or Non-Standard deals. For Standard deals, revenue is recognized immediately where as Non-Standard deals, revenue is being deferred, deferral accounting handled through Accounting Engine (AE), CCRM and Manual Adjustments in GL etc., AE is not capable to handle the business requirements in deferral accounting. Hence, Cisco implemented New Deferral Accounting Engine called Revenue Accounting Engine (RAE). RAE is capable to handle the Cisco’s deferral accounting business requirements with additional features.

General Ledger –

Have implemented and resolved issues related to Recurring Journals, Translation and Reporting Currency, Revaluation, Mass Allocation at Cisco Project.

Cisco had the following requirements and same has been achieved by setting up the below processes

oRecurring Journals: At Cisco assisted users in creating Provisional Journal Entries like for Rent, Electricity etc. during month ends. Used the Recurring Journals functionality to create standard, skeleton and formula recurring journals based on the expenditure type during month ends and explained users on how to reverse such journals after booking the actual expense journals.

oTransferring functional currency balances to foreign currency: Configured the Translation process to translate functional currency balances to foreign currency.

oRevaluation: Configured the Revaluation Process to identify the unrealized gain or loss which occurred due to currency fluctuation.

oMass Allocation: Configured Mass Allocation Formula where for few entities at Cisco the Rent Expenditure for the entire building which is paid used to get allocated among various cost centers of that building. Based on the business requirement have created the Mass Allocation Formula (A*B/C=T) by creating the Rent Paid (Cost Pool Entry - A), Allocated the Rent based on the (usage factor - B) which was on percentage basis and C being the total usage factor to arrive at the allocation amount for individual cost centers.

Key responsibilities:

Managed a team of 25 members to support business users by providing solution on the issues raised

Prepared Business and functional requirement document for the RAE project.

Analyzed the current system by interacting with business and cross functional team.

Responsible for all deliverables including Data extract programs, Reports and $U programs.

Mapped the Client requirements with Oracle standard functionality and finding the gaps and delivered the solutions in terms of Customizations, workarounds, reengineering and form personalization.

Worked on configuration changes for new entities.

Analyzed the issues on Production System and resolved them.

Thoroughly Tested the functionality of new enhancements for new entitles.

Coordinated with Cross Functional teams for customizations and calling out key issues.

Gave the overview on functional modules to technical team.

Analyzed the current system by interacting with business and cross functional teams.

Responsible for preparing the Artifacts, Kintana migration - components from one instance to other instance by using the PVCS for version control.

Lead the offshore technical team and worked in multiple time zones for implementing the Functional and technical solutions.

Prepared BR100 Documents for business users and addressing training (KT) sessions to users.

Triage and identify root causes for complex end-user issues and come up with effective solutions by coordinating with client and Oracle

Resolved user’s troubleshooting issues during Create Accounting; workflow - reassign, delegation, process stuck, deferred etc for the PO, iExpense, approval processes.

Worked in Fin Recon Team –work involved preparation of Weekly / Monthly Fin Recon Reports and resolution of reconciliation related issues

Provided extensive user support Analysis: Research solutions to problems, answer client questions and provided consulting and training as required. Track software and documentation issues.

Worked on Production support related incidents and resolved incidents meeting SLA

Created Oracle Support Requests (SR) using metalink, provided action plan updates, applied data fixes, patches as applicable. Ensured thorough testing (UAT) from IT and business users before moving changes into Production.

Assisted Testing Team in validating UAT Test Scripts

Pro-actively lead initiatives to validate corner case scenarios to reduce potential defects by 25%

Implemented custom solutions to improve user experience by streamlining complex processes, business work-flow and reduce operational cost

Effectively managed patch releases ensuring the quality of the product meeting SLAs

Environment: Oracle Financial Applications R12 (iexpenses, iprocurement, inventory, purchasing, Payables, Receivables, Fixed Assets, General Ledger, SLA, E-Biz Tax and Cash Management)

Client: British Telecom, Pune - India July 2010-Feb 2011

Role: Oracle Support Analyst

Project: Oracle Financials Rollout\Upgrade and Support Period:

As Software Engineer worked on FA module Oracle Financials for entity rollouts.

Key responsibilities:

Configured the system, and provided optimized solutions to meet client’s critical requirements.

Led the peer review and validated all the BR100’s with the user stories gathered from the client.

Configured the system using automation and created fld’s and Ldt’s through Oracle isetup and xml generations.

Raised Service Requests for critical requirements with Oracle, interacted closely with Oracle and provided optimized solutions.

Environment: Oracle Financial Applications R12 (Payables, Fixed Assets and General Ledger)

Satyam Computer Services May 2007-Jun 2010

Software Engineer

Client: ZaiN Telecommunications, MTC Vodafone, Chad - North Central Africa May 2008-Jun 2010

Role: Business Analyst Oracle EBS

Project: Oracle Financials R12 Implementation Period:

Led implementation of Oracle Application Release 12.0.6 Version in GSI (Global Single Instance) across 17 Countries in Africa and Middle-East.

Key responsibilities:

Implemented Oracle Financials along with integration of Legacy Systems (IPOS for creating Purchase Orders, Homisco System for Post Paid revenue recognition and Active Retail System for Prepaid revenue recognition) as per Client’s Business requirements.

Responsible for Requirements gathering, Functional Specification, and Design.

Studied and documented the As-Is and To-Be process.

Performed fit-gap analysis of functional areas between legacy systems and Oracle ERP.

Provided an optimized solution considering post fit-gap analysis findings.

Defined a phased data migration strategy by collaborating with client.

Documented BR100, Functional and Report Extensions documents through MD 050 and MD 070

Implemented data migration - collected data from client systems, cleansed and migrated to newly integrated systems.

Functional spec for Conversion of legacy data into AR and its validation

Developed Test Scripts, Training Material, Knowledge Transfer and User Training.

Supported issues after GO Live in the areas of Auto Invoice, Receipts and month end closing.

Creation of Item Masters; Category Sets and Codes

Supported in the month end close process and resolved issues

Environment: Oracle Financial Applications R12 (Inventory, Purchasing, Payables, Receivables, Fixed Assets, Cash Management and General Ledger)

Client: National Air Services, Riyadh - Saudi Arabia. May 2007-Apr 2008

Role: Business Analyst Oracle EBS

Project: Oracle Financials 11i Implementation Period:

Implemented Oracle Applications Rel. 11i (11.5.10.2), and supported post implementation services

Key responsibilities:

Led feature enhancement of existing modules, which includes Oracle General Ledger, Payables, Receivables, Fixed Assets and Cash Management.

Coordinated with various business teams in arriving at the right solutions.

Documented RD020, BP040, BP080, BR100, MD050, TE040 as per Oracle AIM standards.

Coordinated with Cross Functional teams for customizations and calling out key issues.

Worked on Preparation of Menus and in setting up various roles & responsibilities in AP, AR FA, GL and CM Modules.

Designed and implemented cross validation Rules as per business need.

Designed and implemented customized solutions to integrate client’s 3rd party purchase and revenue systems data into Oracle systems.

Implemented Oracle Purchasing, Inventory to meet late add client requirements, meeting critical deliverables within accepted schedule.

Conducted Functional Testing in CRP3 before its replication to UAT.

Coordinated with various teams of business and trained end users.

Extended Training and Support in month end close process

Environment: Oracle Financial Applications 11i (Inventory, Purchasing, Payables, Receivables, Fixed Assets, Cash Management and General Ledger)

Contact this candidate