PROFESSIONAL SUMMARY:

• Ten years of experience with multiple projects in Oracle Implementation, Upgradation and Post Production support in both 11i and R12 versions.
• Worked extensively on General Ledger (GL) including AGIS and SLA, Accounts Payable (AP) including Payments (IBY), iProcurement, iSupplier, Purchasing (PO), Approval Management Engine (AME), Accounts Receivables (AR) Including Advanced Collections, E - B.Tax, Cash Management (CE), Fixed Assets (FA) and Costing.
• Good understanding of USGAAP accounting and SOX.
• Experience in writing complex queries, troubleshooting SQL packages and developing PL SQL packages.
• Experience with Data Warehouse and Data Science concepts.
• Experience with Confidential custom applications like PLX and BQ
• Experience in gathering business requirements, gap analysis, future business process study and providing functional design for RICE components with documentation documentation using Oracle Tutor, Oracle UPKs and AIMs BP040, BP070, BP080, RD010, RD020,, RD050, BR010, BR030, BR100, BR110, TE040, MD050 etc.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical or functional issues.
• Experience in developing, modifyind and customizing FSG reports using FSG generator.
• Experience in Multi - Org Application architecture, AME Approvals Management, Oracle Tutor, Oracle User Productivity Kit (UPK), Built-in Workflow and Web ADI.
• Experience in workflow approval process and integration experience in modules like GL, AP, Purchasing, Inventory, Order Management and iExpenses.
• Experience in Data Conversions/Migration and design of function specific document of data (Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and open receipts) from Legacy to Oracle.
• Knowledge of financial accounting and financial business processes, not limited to, but including: financial accounting process through financial closing; revenue and expense, cash/accrual concepts; adjustments and financial statements.
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual. Sound understanding of the business processes as well as a strong working rapport with business users.
• Demonstrated good leadership skills with inspirational attitude with result oriented approach.

TECHNICAL SKILLS:

Oracle Application: 11i &R12, GL (Incl AGIS and SLA), AP (Incl IBY and AME), AR, FA, iProc, PO, CE, E-B Tax., Costing.

Languages and Tools: PL/SQL, SQL, Web ADI, Data Loader, Confidential PLX, Confidential BQ.

Knowledge on other Modules: iExpenses, iSupplier, INV,WIP, BOM.

Applications: MS office, MS Visio, Confidential Sheets, Oracle Tutor, UPK.

Miscellaneous: CAD, CAM, PRO-E, ANSYS, CATIA.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Oracle Financials Functional Consultant

Responsibilities:

• Worked on Confidential Cloud Technologies to retrofit Confidential ’s financial data warehouse (FDW) in accordance with Oracle R12 upgrade.
• Provided functional design and developed Revenue data mart, sourced from Oracle OM, AR, Advanced Collections, Confidential custom billing tool using Confidential BQ and PLX.
• Developed data dictionary dashboard, a dashboard for Python developers to understand Oracle schema for financial data using PLX.
• Designed and developed Oracle KPI dashboard, a unified Tableau dashboard sourced from Oracle GL, Hyperion and multi entity uploads, which gives GL journal segregation for higher management
• Worked on retrofitting up to 25 GL, AP, PO and AR CEMLIs as a part of Oracle upgrade.
• Designed and developed SLA drilldown dashboard, a PLX dashboard for business users to drill down from GL to all sub ledgers, using SLA.
• Designed and developed PO Spend dashboard, a dashboard for higher management to track spend details by department, cost centre and product, sourced from Oracle PO and AP, using PLX
• Designed and developed Test Automation framework for Oracle CEMLIs and Financial data warehouse, a framework which builds and executes test SQLs automatically based on table schema and gives user readable output and graphs using Confidential cloud applications.
• Designed data security layer, which restricts user access to curated financial data sourced from Oracle, using Oracle Employee Hierarchy with additional security layer of chart of account segments.
• Created end user training material, presentation and videos for changes in Oracle R12 and financial data warehouse.
• Trained over 1300 users on Oracle GL, AP, PO, AR and to retrofit scripts, reports and dashboards developed by users.

Confidential, Grafton, WI

Oracle Financials Functional Consultant

Responsibilities:

• Primary functional project lead for financial modules.
• Detailed scoping sessions with users for requirement gathering and ASIS analysis.
• Designed charts of accounts and organization structure.
• Provided TO BE solutions and GAP analysis
• Primary production support for Costing, Inventory, AR and Advanced Collections modules.
• Configuration of Costing, AR, GL, CE and Advanced Collection modules for CRPs.
• Implemented on AGIS for Intercompany transfers.
• Provided functional design for AR, AP, GL and CST conversions from legacy system.
• Provided custom solution for costing variance in a flow manufacturing environment.
• Provided SLA customization to recognize revenue based on primary plant.
• Provided solution for recognizing P&L based on brands.
• Worked on Dunning letter formats and transmission through EDI
• Provided sales channel customization for common customer accounts between different organizations.
• Provided cash management customization for auto reconciliation
• Provided solution for customer master harmonization across organizations
• Provided custom solution for mark up on intra company transactions.
• Provided custom solution for inter company AP AR netting process
• Provided functional design for custom claim database interface.
• Provided solution for inventory adjustment approval before generating variance in GL.
• Provided custom solution for segregation of GL balances from one ledger and post them in another ledger.
• Project lead for converting EAM from one operating unit to another operating unit.

Confidential, Keene - NH

Oracle Financials Functional Consultant

Responsibilities:

• Involved in requirement gathering for the roll out to newly acquired business units.
• Provided functional design MD50 for conversions of customer master, AR open invoices, Suppliers and AP invoices from legacy systems like Mainframe and LAWSON.
• Provided functional design MD50 for inbound and outbound interfaces of customers, transactions to third party systems like Terradata, Hyperion.
• Provided functional design MD50 for various custom UIs for GL, AP and AR modules.
• Provided functional design MD50 for SLA customization to delinquent fees accounts and cost variance accounts.
• Provided functional design for customization of receipt applications using Lockbox.
• Implemented receipt reversal API for mass reversal of receipts.
• Provided functional design MD50 for development of custom reports.
• Provided functional design for customization of dunning letters before transmission.
• Configured Advanced collections with scores and strategies.
• Provided functional design for form customization in Advanced Collections.
• Provided custom solution using AP/AR netting for inventory transfers.
• Implemented iSupplier, to replace existing custom supplier portal.
• Implemented custom approval workflow for supplier and requisition approvals using Approval Management Engine.
• Worked on performance enhancements for Cash Sheet 1.2, for cash applications.
• Implemented MORE4APPS for AR Customer, Receipts and Invoice uploads.
• Provided functional design to customize Customer statements.
• Worked on inbound and outbound Credit interfaces to third party systems.
• Worked on performance tuning and redesign of Billing Interface
• Worked on Advanced Collections to standardize the custom delinquent invoice process.
• Assisted development team in code reviews and testing of codes developed for new RICE components.
• Functional testing of developed RICE components.
• Assisted in UAT and SIT for new components and processes.
• Worked with technical team for performance enhancements of existing custom processes for AR and AP
• Providing production support for AR, AP and GL modules.

Confidential, Atlanta, GA

Oracle Financials Functional Consultant

Responsibilities:

• Analysed gaps and provided solution as per new business requirements and existing solution print.
• Worked extensively on COA design initial solution print.
• Configured application and updated BR100 for GL, AP, AR, SLA, E.B Tax, FA, CE and Projects
• Implemented iSupplier and iProcurement as per new solution design including punchouts and configured AME for requisition approvals.
• Provided functional design for customization of Revenue recognition for progress and non-progress billing, as per SOP 81-1 and SAB 104 standards.
• Provided functional design for customization of SLA for miscellaneous charge accounts.
• Provided functional design for customization of credit memo approval process in Project billing.
• Provided functional design for customized integration of Order Management with Project Billing for delay time and shipping information to recognize revenue.
• Provided functional design for customized report of Project Billing draft invoices with tax details.
• Provided functional design for customizing collection process using Advanced Collections.
• Provided functional design to limit who can update PA billing events based on key members functionality.

Confidential, Omaha, NE

Oracle Financials Functional Consultant

Responsibilities:

• Worked extensively in Upgradation of Oracle applications (GL, AP, AR, PO, iProc, FA, CE) from 11. .2.3.
• Performed interview sessions with end users for ASIS process analysis and documented ASIS processes BP040.
• Provided solution design for existing and changed business processes according to SOP and USGAAP standards with documentation of BP080.
• Provided solution design to use SLA for accommodating IPV accounts.
• Configured modules as per business processes and user requirements.
• Worked exclusively in configuring funds disbursement setup like, formats, templates and payment process profiles.
• Assisted technical team in configuring third party printer software by providing xml data extract as per changed output format of format payment instructions program.
• Worked on E.B-Tax in modifying migrated tax codes as per new business requirements.
• Worked on OAF personalization for personalizing iProcurement checkout and supplier creation pages.
• Worked in collaboration with technical team to resolve issues with iProcurement punchout stores.
• Modified Sql queries in AME rules as per the new AME package.
• Implemented iSupplier including product and services classification, migrating bank account assignments.
• Configured Buyers Work Centre, for Auto create Orders, receipts etc.
• Worked on work flow administration in collaboration with technical team to modify inbound and outbound setups as per business requirement.
• Worked with technical team in modifying customized package to load data into expense report tables for expense reports.
• Implemented SLA and modified report templates as per user requirements.
• Worked on report manager and FSG generator to fill gap generated by the removal of client ADI.
• Conducted user training sessions and trained users for new functionalities.
• Configured pilots and conducted CRP sessions (CRP1,2&3).
• Prepared test scripts TE40 and conducted UAT sessions.
• Prepared configuration documents BR100 for all modules with respect to R12 setup.
• Prepared training materials and user guides for end users.
• Working with technical team in modifying middleware for Order entry systems and Customer APIs.
• Providing support after GO Live.

Confidential, Tampa, FL

Oracle Financials Functional Consultant

Responsibilities:

• Worked exclusively on Oracle E Business Suite (GL, AP, AR, PO, iProc, FA, CE, iExpense, E.B-TAX) implementation of R12.1.3.
• Worked on business requirement gathering with documentation of BR100 and BR150.
• Detail business process analysis and research to enhance the business process with documentation of BP40 and BP80.
• Worked in co-ordination with off shore team for identification of gaps.
• Designed the chart of accounts to meet the client’s business requirements
• Configured the MOAC, Ledger Setup, and Legal Entities
• Handled Cash/Revenue Management as per SOP81-1 and SAB 104 standards for reconciliations purpose.
• Configured AGIS for Inter-company Transactions
• Involved in customization of Journal batch summary report, Trial balance report in GL.
• Configured iProcurement along with setting up of items and catalogues.
• Configured Buyers Work Centre in Purchasing for creation of orders, receipts etc.
• Responsible in creating, supplier groups, Pay groups, and Payment terms as per payable options in Accounts Payables (AP).
• Performed funds disbursement setups including formats, templates and payment process profiles for use of Payment Manager.
• Worked on Cash Management for setting up of banks, and interbank transfers between LEs
• Worked on iExpense in setting expense templates and audit workflows.
• Worked on E.B Tax in setting up regime to rate flow for Non-recoverable and recoverable taxes.
• Handled Fixed Assets and leased assets with Fixed Assets Module and OLM (Oracle Lease Management) including Period-End Processes for further legalization processes.
• Conducted CRPs, Training Sessions to super users, and UAT sessions.
• Prepared test scripts, training material and end user guides.
• Provided post production support for bug fixing and enhancement of reports.

Confidential, Harrisburg, PA

Oracle Financials Functional Consultant

Responsibilities:

• Implemented R12 Financial Modules (GL, AP, AR, FA & CE), Acquire to Retire (A2R), Procure to Pay (P2P), E-Business Tax (EBT), iExpenses, Property Manager and integration of Account Receivable module with legacy billing system.
• AS-IS business process study of the client organization by means of observation, interviews, end to end walkthrough tests, obtaining samples business cases and documentations etc.
• Identified tasks and interrelationships to evaluate functional and cross-functional requirements.
• Identified gaps and addressed them actively in collaboration with the project team through documentation (BR010), Oracle Tutor and MS Office.
• Provided Support the ERP initiatives in design, development and implementation of plans to translate enterprise information system objectives into functional business systems.
• Prepared solution design/To-Be document as per client requirement and best practices embedded in the application using Oracle Tutor tool and AIMs Methodology.
• Conducted User Acceptance training (UAT) sessions, prepared UAT scripts (TE040) and obtained user acceptance after providing feasible solutions to issues raised within UAT sessions.
• Configured of Oracle application setup of respective modules and prepared BR-100 setup document.
• Conducted training sessions for users and prepared guides on User Productivity Kit.
• Reviewed the existing reports and collected requirements to develop additional custom reports.
• Executed SQL queries on PL/SQL server tables to view successful transactions of data and for validating data.
• Responsible for Data gathering on given templates and upload activity on systems.
• Providing post implementation support to users.
• Documents all business processes, needs, flows and diagrams.

Confidential, Charlotte, NC

Oracle Applications Techno Functional Consultant

Responsibilities:

• Responsible for requirements gathering, analysis, planning, selection, blueprinting, designing, developing, rolling out, and end-user training of BI solutions to the user community.
• Defined new organization structure and COA
• Use of SQL * Loader utility to load data from legacy system to interface.
• Defined various currencies for multi currency operations and currency translation, conversion, revaluation has been done to meet the requirement. Cross validation rules have been setup for various GL codes. Configured Sub-ledger accounting process to GL.
• Performed functional setups like creating lookups, Profile options, DFF’s and value sets based on the technical requirement.
• Worked extensively on Payables and Payments to in corporate changes from 11i like bank accounts, tax and check printing.
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Customized the Invoice Aging and Customer Balance Report in AR.
• Worked in collaboration with technical team, to configure AR for Order entry systems and customer APIs.
• Prepared test scripts (TE40) for all business areas.
• Conducted Conformance Room Pilot (CRP)/Conducting User Acceptance Training (UAT) sessions and obtain user acceptance after providing feasible solution to issues raised within UAT sessions.
• Designed FSG reports (Income statement, Balance sheet statement its notes and other reports).
• Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi OU through security profile in a secured environment.
• Defined Tax Code, Rates, Groups and Withholding Tax.
• Responsible for creating Request sets and Concurrent Programs and scheduling various tasks as per requirements.

Confidential, San Jose, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Played role in upgradation of R12 Financial Modules (GL, AP, AR, FA, INV,BOM,WIP & CE), Acquire to Retire (A to R),
• Supply Chain Management (P to P), Consolidation ledgers, AGIS for intercompany transactions, Multi-Org application architecture.
• Responsible for complete As-Is study and its documentation.
• Prepared functional specifications documents such as BP080, MD50, MD70, BR100 for Financials and Supply Chain Management modules.
• Responsible for Data gathering on given templates and upload activity on systems
• Performed setup activities and prepared deliverable document i.e. BR100 document and taken sign-off.
• Guided developers for developing and modifying customized reports as per request of client
• Defined and performed Revaluation, Translation and Multi-Reporting Currency activities.
• Created Users, Responsibilities, Security profiles and Menus.
• Developed complete setups with Data upload on Production instance for Go-Live.
• Data gathering and upload using data load and Web ADI.
• Supported production environment and users on daily basis.
• Managed Technical Assistance Requests (TAR's) on-line Oracle Support.
• Designed Financial Reports using Financial Statement Generator (FSG) tool.
• Documented custom processes using AIM Methodologies.
• During post production involved in the Manufacturing (INV, PO, BOM, WIP), OM, AP and AR modules application support, bug fixing and enhancements to the applications, enhancements include enhancing the existing functionality of forms, reports, custom forms.
• Worked on Order to Cash (OTC) and Drop Ship Cycles including Quote to Cash (QTC) logistics.
• Developed Purchase Order report, Packing slip report using XML Publisher (BI Publisher).
• Provided Training and conducted practice and additional business requirement sessions.
• Prepared UAT scripts and conducted UAT for with user acceptance sign-off.
• Conducted CRP, UAT and SIT tests to ensure the end product meets the client's requirements.

Confidential

Oracle Programmer

Responsibilities:

• Responsible for creating database tables, indexes in Oracle 11i.
• Responsible for developing and customizing custom reports (6i) as per the client requirements.
• Developed SQL*Loader scripts for loading data.
• Wrote Explicit Cursors and Handling Exceptions.
• Created Views and Other Database Objects.
• Interacted with the Business users and identified the requirements.
• Designed and developed PL/SQL procedures and Functions.
• Trained end users for effective usage of the software package.
• Responsible for table designing.
• Involved in database creation.
• Done preparation of program specifications.
• Wrote Database triggers for integrity checks.
• Wrote complex SQL scripts for reports.