SUMMARY

• A result driven professional with 8+ years of experience in IT, of which mostly is in Oracle Applications (ERP) Design, Documentation and Implementation.
• Good understanding of the Oracle application structure and proficient in versions R12, 11i.
• Expertise in the entire System Development Life Cycle and experienced in Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitating Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go - live and Post-Implementation Support.
• Expertise performing Analysis, Design, implementation and support in Oracle R12 Financials and Projects.
• Extensive knowledge in implementing Oracle suit like Project costing, Project Billing, Project Management and Integration of other modules to Project Accounting.
• Implemented significant features of Project Accounting such as rate schedule, transaction control and auto-accounting rules and implementation of labor cost rate schedules, setup of Project templates, creating agreements and Project Funding.
• Proficient in Oracle Financials Modules General Ledger (GL), Financial Accounting Hub (FAH), Project Accounting (PA), Fixed Assets (FA), Oracle Payables, Purchasing, Inventory, Oracle Receivables and Cash Management (CM).
• Extensive understanding and implementation of the Oracle Financials Accounting Hub (FAH) and Oracle Financial Services Accounting Hub (FSAH).
• Proficient in designing custom accounting extensions in Sub-ledger Accounting Module(SLA).
• Expert in Multi-Org, MRC (Multi Reporting Currency), Consolidation, Translation, Revaluation and Intercompany accounting. Proficient with AGIS and Legal Entity configuration and integration with other modules while Project Accounting.
• Well versed and extensive working knowledge in designing and developing Trading Community Architecture (TCA), for various entities including Supplier, Customer, Banks and Employees.
• Implemented various Self-Serv modules iExpense, iProcurement, iSupplier & iStore.
• Experienced in customization by extension and modification of the standard application suite using Application Object Library (AOL).
• Experienced in SYSADMIN and AOL activities including creation of KFFs, DFFs, users, responsibilities, menus, concurrent programs, request sets, request groups, value sets and Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.
• Good understanding of various Oracle developer tools including Oracle Forms, Reports, SQL, PLSQL, TOAD, UNIX, Oracle RDBMS Concepts, etc.,.
• Experience using workflow components like Workflow Builder and Workflow administrator.
• Performed numerous designs for Conversions and interfaces from legacy systems/third party systems into Oracle Applications.
• Proficient in authoring various documentation (BP 80,RD20, BR30, BR 100, BR 150, MD 50, MD 70, CV 40, TE 50 &TE 40) using the Application Implementations methodology (AIM), which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE processes, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration, Project Accounting and testing.
• Strong problem solving, Analytical skills & ability to work in a time-constrained and team-oriented environment.

TECHNICAL SKILLS

• Oracle Applications: Oracle Applications R12 (12.0.4/12.0.6/12.1.1/12 13 )/11i (11.0.3 11.5.3 11.5.8 11.5.9 11.5.10.2 )
• General Ledger
• Financial Accounting Hub (FAH)
• Project Accounting
• Accounts Payables
• SLA iExpense
• Payments
• Purchasing
• Sourcing iProcurement iSupplier
• Contracts
• Cash Management
• Accounts Receivables
• Fixed Assets
• Order Management and others.
• Oracle Administration: AOL
• SYSADMIN
• Oracle Workflow Administrator
• OA Frame Work Developer
• Fusion Applications
• Fusion Release R10.
• PeopleSoft Version 9.2.
• Web ADI Integrations
• SQL and PLSQL using TOAD
• Business Processes: Record to Report (R2R)
• Procure to Pay (P2P)
• Order to Cash (O2C)
• GL General Ledger.
• FAH Oracle Financial Accounting Hub/SLA Subledger Accounting
• AP Accounts Payables
• AR Accounts Receivables
• CM Cash Management
• FA Fixed Assets
• PO Purchasing
• INV Inventory

PROFESSIONAL EXPERIENCE

Confidential, East Greenville, PA

Senior Oracle Functional Consultant

Environment: Oracle EBS R12.1.3 (FAH/XLA, EBTAX, SYSADMIN, AP, GL, AR, CM, PO, INV)

Responsibilities:

• Implemented Oracle financial accounting hub (FAH) (R12.1.2) to integrate various legacy source systems into oracle EBS, including and not limited to People soft Treasury, HRMS, JD Edwards, Oracle Revenue Reconciliations Systems, etc.,
• BASEL II requirements are collected and prepared FAS 60 and FAS 97.
• Gathered and created business requirements from finance users for the mapping of legacy chart of accounts (COA) to the enterprise COA.
• As an Oracle EBS Functional Analyst, worked on modules like FA, GL, AP, AR, CM, E-Business Tax, P2P and O2C in R12 environment.
• Involved in activities for Oracle System Administration module such as Registering the Users and assigning responsibilities, printers in Oracle Apps.
• Setting up the General Ledger, Multi-Org, Account Payables, Oracle Purchasing, System Administrator and Inventory module.
• Setup Tax Authority in E-Business Tax module while defining Withholding Tax structure.
• Testing the Document Management, Integration and Conversion of data from other (Siebel) legacy systems into Oracle EBS and vice-versa.
• Defined The Following: KFF- Accounting, Category, and Location Flex-fields, Fiscal Years, Asset Categories, Calendar Periods, System Controls, Asset Security by Books, Prorate convention, Corporate Book Controls, Salvage limits and locations, ADI (excel) template to create Mass Additions in FA.
• Setting up of customized Account derivation rules (ADR) for legacy source system requirements into Oracle Receivables.
• Involved in some activities for Oracle System Administration module such as Registering the Users and assigning responsibilities, printers in Oracle Apps.
• Integrated with Oracle Purchasing and Oracle Payables and entered project-related requisitions, purchase orders, and supplier invoices.
• Managed Project-Related Supplier Costs in Oracle Purchasing and Payables
• Designed and configured Setup of Flex fields and conducted Demo of Contracts for Project Documentation, Deliverables, Billing Initiation and validated Project Information.
• Designed and Developed customized solution for Oracle Fixed Assets to resolve depreciation issues.
• Drafted the testing document (TE-050) for the project accounting (PA) module and participated in SIT and UAT testing.
• Conducted CRP testing, developed test scripts carried out integration testing.

Confidential, Hoboken, NJ

Senior Oracle Functional Consultant

Environment: Oracle Applications R12.1.3 GL, SYSADMIN, Financial Accounting Hub (FAH)/XLA, AGIS, AP, AR, PO, AOL

Responsibilities:

• Implemented financial Modules: GL, AP, AR, PO, AGIS and Shared HR of Release 12.1.3 of Oracle EBS.
• Worked on Functional Design Documents (FDD’s) for designing various RICE Objects.
• Successfully implemented Oracle Financial Accounting Hub (FAH) in North A,merican Countries for the Financial Module (GL), for maintaining thin GL after external integrations. Even the manual Journal Entries are processed through FAH module.
• Implemented Advanced Global Intercompany System (AGIS) for all the 46 countries to have Intercompany Transactions with any of the Entities.
• Worked on setting up the Oracle Human Resource Module for the Employees for all Countries and setting up Employee-Supervisor Hierarchy.
• Designed the Functional Document for GL Balances Conversion from Legacy to Oracle.
• Involved in some activities for Oracle System Administration module such as Registering the Users and assigning responsibilities, printers in Oracle Apps.
• Helped creating reports using FSG and identifying the requirements for the Columns and Rows.
• Closely worked with Client for Training and providing Guidance. Prepared the Test Cases and BR100.
• Worked with TGCS through all the phases of Testing including CRP, SIT, UAT and Post Production Support including Month End Activities.
• Responsible for end-to-end Oracle applications implementation project from assessment to production support as a Senior Functional Analyst.
• Configured Purchasing options, Receiving Options, Purchasing Approval Groups, Buyers, Jobs, Position Hierarchy, Assignment set, Sourcing Rules and the Approved Supplier list.
• Configuration of Approvals Management Engine (AME) for standard Invoice Approval Workflow.
• Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Creating cross validation and security rules.
• Defined DFF, Payment Terms, Signing Limits, Special Calendars and Expense Report Templates.
• Define AP and AR Payment Methods/Terms, Lookup/Quick Codes, Payable System Options and Financials Options.
• Presentation of Financial Consolidation system to the Management.
• Involved in Month-end support for close and reconciliation for AP and AR modules.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period.
• Provide functional review & impact analysis on proposed changes with the existing functionality

Confidential, RTP, NC

Senior Application Financial Functional Consultant

Environment: Oracle Applications R12.1.3 GL, SYSADMIN, Financial Accounting Hub (FAH), AGIS, AP, AR, PO, OM, AOL

Responsibilities:

• Implemented financial Modules: GL, AGIS and Shared HR of Release 12.1.3 of Oracle EBS.
• Worked on Functional Design Documents (FDD’s) for designing various RICE Objects.
• Implemented Advanced Global Intercompany System (AGIS) for all the 46 countries to have Intercompany Transactions with any of the Entities.
• Worked on setting up the Oracle Human Resource Module for the Employees for all Countries and setting up Employee-Supervisor Hierarchy.
• Designed the Functional Document for GL Balances Conversion from Legacy to Oracle.
• Functionally designed the Chart of Accounts Report.
• Helped creating reports using FSG and identifying the requirements for the Columns and Rows.
• Closely worked with Client for Training and providing Guidance. Prepared the Test Cases and BR100.
• Involved in some activities for Oracle System Administration module such as Registering the Users and assigning responsibilities, printers in Oracle Apps.
• Responsible for end-to-end Oracle applications implementation project from assessment to production support as a Functional Analyst.
• Integrated Order Management with Depot Repair to create RMA and Sales Orders, validate customer accounts and invoice customer repairs.
• Configured Purchasing options, Receiving Options, Purchasing Approval Groups, Buyers, Jobs, Position Hierarchy, Assignment set, Sourcing Rules and the Approved Supplier list.
• Configuration of Approvals Management Engine (AME) for standard Invoice Approval Workflow.
• Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Creating cross validation and security rules.
• Implemented and supported AME for Payables Hold Resolution Workflow and Requisition Approval Workflow.
• Defined DFF, Payment Terms, Signing Limits, Special Calendars and Expense Report Templates.
• Defined AP and AR Payment Methods/Terms, Lookup/Quick Codes, Payable System Options and Financials Options.
• Presentation of Financial Consolidation system to the Management.
• Involved in Month-end support for close and reconciliation for AP and AR modules.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period.
• Setup Auto Accounting to recognize revenue based on Sales Order line.
• Provide functional review & impact analysis on proposed changes with the existing functionality.
• Preparation of Functional Test Scenarios & Test cases for Fixed Assets.
• Worked along with DBA to update/assign User responsibilities in EBS and updating Responsibility definitions, functions and menus. Worked on several SR’s for Payables and Receivables.

Confidential, Menlo Park, CO

Oracle Applications Functional Lead

Environment: Oracle Applications R12 12.0.6 (AR, AP, GL, OM, PO, iProcurement, Payments, EB Tax, SLA, FA, AME, AOL)

Responsibilities:

• Involved in Enhancing and supporting Oracle implementation as an EBS Finance R12 Business Analyst for AP, AR and GL modules, played a key role in IT Support Team for the client.
• Worked on setting up Third party Payments in Oracle Payables R12 for Suppliers in EBS.
• Implemented and supported AME for Payables Hold Resolution Workflow and Requisition Approval Workflow.
• Defined Request Sets with several reports and concurrent programs for GL manager such as Intercompany, Auto invoice, Costing and Accounting details for review and analysis.
• Supported Payables & Receivables users on a day to day basis on Payment and Billing related issues in Oracle R12.
• Defined and thoroughly tested Accounting setups in Receivables and Cost management to ensure COGS matching revenue.
• Extensively worked on Oracle Receivable setups including Auto Lockbox, Auto invoicing & Auto accounting and resolved Auto invoice interface issues.
• Setup and documented Payables Invoice Sweep Program for unaccounted transactions from one accounting period to another.
• Implemented Separate Remittance Advice (SRA) feature for Suppliers as per business requirement to support switch from Check to ACH payment method for all Suppliers.
• Worked on several reporting requirements for the client like IPV, PPV and Matching Hold Reports. Also supported users to build their own Discoverer reports.
• Resolved issues related to credit card refund, return, bills only, freight charge return, credit card authorization, consolidated invoicing and receivables.
• Extensively tested Order Management related enhancements like credit holds, new order types, sample order type, restocking fee item and automatic freight calculation.
• Involved in GL Ledger setups using ASM, LE configuration, Cross validation rules, security rules, COA segments, Currencies, Accounting Calendar and Operating Units.
• Implementation of Fixed Assets, involved in requirements gathering sessions with the client.
• Convert the requirements in to AIM Documents: BR100, BR110 and BR30.
• Led the Conference Room Pilots for the site implementation.
• Used OUM methodology for documenting business requirements and design documents as per business needs.

Confidential

Oracle Financials Functional R12 Upgrade Analyst

Environment: Oracle Applications 12.0.6 GL, AR, CM, OM, INV, PO, Sub Ledger Accounting (XLA) Customizations.

Responsibilities:

• Completed Multi-Org configuration by creating a new Organization Structure for WYSE by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Defined Corporate books, fixed assets categories, assets keys etc.
• Worked on the Configurations of AP, GL, AR, Cash Management, I-Expense, I-Receivables.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and BS Analysts.
• Reconciled major accounts in Advanced Collections and Billing. Setting up system profile options at the site level in Advanced Collections.
• AP- Defined invoicing information including payment terms, invoicing and accounting rules, territories and invoice sources. Defined accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set.
• Setup Oracle Payables includes Payment Terms, Banks and Bank Accounts, Define Quick codes, Define Financial Options and Payable Options etc.
• AR - Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets. Worked on receipt class, specifying creation method, payment method, defining collectors and aging buckets. Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.
• Set up transaction types, invoices, guarantee, deposit, and credit memos, debit memos.
• Customized collector’s portal to add additional transactions and customer information in Advanced Collections.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Documented Functional Design, Applications Setups & User Manuals Provided with useful training to the users in GL, AR, OM, INV and PO Modules.

Confidential

Oracle Applications Functional Analyst

Environment: Oracle Applications 12.0.4/11.5.10.2/11.0.3 (GL, AR, PO, INV, OM, AGIS, iStore, AOL), Database, Workflow Administrator, EDI, Clear Case, Kintana

Responsibilities:

• Communicated with business user’s about the implementation and requirement gathering questionnaire, explaining oracle’s functionality extension from R12 vs. 11.0.3 within oracle financials and Manufacturing.
• Analyzed the requirements, performing risk analysis and mapping the business processes. Understanding the gaps, recommended the necessary customizations.
• Authored Functional design documents for customization and development of interfaces, reports and extensions across various financial/manufacturing modules, interacting with business users.
• Designed and implemented various Conversions including Customer accounts, customer sites and profiles, Items, Item costs, on hand quantity and Pricing headers/line, from legacy 11.0.3 into R12.
• Implemented Intercompany transfer rules/relationships, to in corporate direct shipping of mobile parts from China/India Operating Unit, for orders placed in Europe /US. Validated cost, transfer prices, ensuring items ordered in Europe is accounted in US and is shipped from China/India OU.
• Designed and configured Custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once the PO is created for a Back to Back process.
• Worked on various client business process designs like Delivery status notification, EDI configuration for third party Sales Order transitions, Work flow Business events setup for notifying and publishing across inter companies when a new customer account is created etc.,
• Designed and configured iStore Custom Extension for publishing items with iStore categories to the stores/sites automatically upon any updates to the new store items or the inventory items.
• Worked in various phases of project from process design, development to unit testing, performance testing, regression testing, UAT, pre-production and post-go live support.
• Given 24/7 support to the team during the go live phase for meeting deadlines with complete documentation and testing.
• Involved in defect fixing of custom workflows like OM export compliance, OM RMA notification and credit management approval process.
• Worked with Kintana for code/setup migrations between test instances, for concurrent programs, forms personalization, menus, responsibilities, value sets and other AOL objects.

Confidential

EBS Functional Consultant

Environment: Oracle Applications 11.5.10.2 (AP, AR, CM, PA, Purchasing, GL, AOL, Inventory), SQL, TOAD.

Responsibilities:

• Designed various Quarter and Year end reports for Higher Management review in like Top Ten vendor payments, Overall Payments history, Employee and Tax Payments etc.,
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Created users and modified the privileges for users, rollup group and summary accounts.
• Provided production support for day to day business issues and worked on SRs with Oracle.
• Analyzed the support incidents logged in the remedy system and implemented solutions.
• Involved in direct interaction with the business users and collecting information required for resolving support incidents.
• Worked on Production Support Quarter End / Month End AP Close Issues, which included accounting issues, trial balances Issues, data corruption issues.
• Financial reporting: Developed various reports using Financial Statement Generator (FSG), including Account Analysis reports, Trial balance reports, Consolidation reports, Exception reports, Journals Entry reports, Consolidation rules report, Summary Trial balance etc.,

Confidential

Oracle Applications Functional Consultant

Environment: Oracle Applications 11.5.10.2 - (GL, AP, OE, AR, FA) Oracle 10g, (SQL, PL/SQL), TOAD.

Responsibilities:

• Played significant role in the Upgrade Patch set analysis in identifying the impacted components.
• Interacted with Oracle to get the issues addresses by logging SRs.
• Developed Training Material for OM and AR modules and prepared impact analysis for critical issues.
• Tested the revised Customer Interface that takes the new Customer Type into account by enabling to load customer data for both Organizations and Individuals.
• Responsible for preparation of test scripts and monitoring UAT.
• Worked on HP Quality Center to create Test Scripts, Test Cases and testing various Functional activities.
• Raised SR’s with Oracle Support to resolve the issues which were part of Oracle Bug and provided necessary information as required.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications.
• Responsible for Retrofitting and re-building custom components post execution of standard features testing.
• Study of current business processes, future business flows and identification of gaps and workarounds in order to provide an integrated Procure to Pay business flow to meet the business needs of the company.
• Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules and involved in Quality Testing (QT).
• Conducted knowledge sharing sessions for the team members in the functional areas of known modules.