EXPERTISE SUMMARY:

• Over 10 Years of IT experience of which majority is in Oracle Financial Applications, Oracle Financial Functional consultant with expertise in Oracle EBS 11i and R12.
• Involved in multiple implementations, upgrades, Support and Enhancement Projects on Financials Modules.
• Three full life cycle Implementations, Two Upgrades and couple of support/enhancement projects in Oracle EBS R12 and 11i.
• Multiple project life cycles experience with Planning, Business Analysis, Requirements Gathering, Functional Design Development, Integration & User Acceptance Testing, Training, Go - live and Post-Implementation Support.
• Developed Functional specification Documents (MD50), Business Requirement Documents (BRDs), GAP Analysis, Solutions for the GAPs, Dealing with Business Users on Training and Testing of the application.
• Strong experience in financial suite including General Ledger (GL), Receivables (AR), Payables (AP), Cash Management (CM) and Fixed Assets (FA), e -Business Tax, Sub Ledger Accounting, Order Management(OM) and Inventory.
• Good experience in creating AOL objects Executables, Concurrent programs, forms, functions, menus, custom responsibilities, profile options, Request Groups, Maintaining Users and customizing Key & Descriptive Flex fields. 
• Strong understanding and working knowledge on Order to Cash and Procure to Pay Cycles. 
• Designed solutions to enhance standard oracle flows for Order to Cash(O2C), Procure to Pay(P2P), Record to Report (R2R), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Implemented various Self-Serv modules iExpense, iProcurement, iSupplier & iStore.
• Experienced in customization by extension and modification of standard applications using Application Object Library.
• Performed numerous designs for Conversions and interfaces from legacy/third party systems into Oracle Applications.
• Utilized AIM methodology for Business Flows in different phases of the project including Requirement Gathering, As-Is, To-Be, Solution Design, Conference Room Pilot (CRP), Build, Test, User Training, Data Migration, Production and Post-Production Support.
• Coordinated with Oracle Support, creating SRs, attending OWC sessions, providing 24X7 support for quick resolution of high prioritized issues.
• Worked as a Functional Tester and conducted CRP sessions to test complete end to end functionalities of several m odules following the upgrade from Oracle 11i to R12.
• Gained expertise in using the Oracle User Productivity Kit (UPK) to record the test scripts and used these scripts to train the end users on R12 functionality.
• Helped the automation testing team to automate the test scripts in GL, AP, AR, CM, FA using Quick test Professional (QTP) & Unified Functional Testing (UFT) tools.
• Understanding the Oracle Apps base Tables, Views & Workflows for the Troubleshooting and resolution of Production issues. Used SQL Developer and TOAD to extract the data from the backend database tables.
• Expertise in Conceptualizing & Implementation of various quality improvements by conducting  audits for continual improvements in services.
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual.
• A team player with exceptionally good organizational, analytical, training, troubleshooting, functional and interpersonal communication skill, a key team player.

PROFICIENCIES:

• Oracle R12/11i Financials and SCM
• Strong Upgrade and Reimplementation Experience
• Expert in P2P, OTC and R2R processes.
• Implementing FAH and AGIS
• Implementing EB-TAX with SABRIX
• MOA and MRC (Multi Reporting Currency)
• TCA (Trading Community Architecture)
• Support and Upgrade Experience
• Expert in Application Object Library and AME
• User Productivity Kit (UPK)
• Strong SQL skills for debugging and Data Analysis

PROFESSIONAL EXPERIENCE:

Confidential, Marlborough, MA 

Sr. Oracle Financials Functional Consultant

Responsibilities:

• Studying the requirements, performing risk analysis and mapping the business processes. 
• Analyze the gaps and conduct client interviews to complete the business process analysis.
• Prepare the business requirements documents, performed Gap analysis and recommend the necessary customizations. 
• Configuring the modules, designing reports and add-ons and coordinating with the technical team to monitor development and implementation progress. 
• Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 -Application Setup)
• Responsible for solving technical and functional issues related to GL, AP, AR, FA, iExpense modules. Working as single point of contact for Finance module working directly with Application Leads and Super Users. 
• Raise service request with  Oracle  technical support and coordinate in speedy resolution of high prioritize issues.
• Provide  functional  impact analysis based on the nature of the issue and coordinate with Business users for manual work around solutions wherever possible.
• Coordinate onsite and offshore technical support team on proposed new custom objects developments, testing, documentation, and migration to production instance.
• Update expense report templates, and distribution sets.
• Develop approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types, actions and set up the profile option to work for Payables only and the required setup through Payables Options form.
• Created organizations, inventory items, catalog RFQ, got approval from supplier in Procure to Pay (P2P) cycle and customized the Purchase requisition and auto creation of a standard purchase order based on a quote and generated receipt. 
• Designed, tested and delivered custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report. 
• Identify the patches that need to be applied to prepare the Release 12.1.3 environment for implementing Oracle mobile expenses. 
• Prepare Visio Process diagrams for AS IS and To Be Scenarios.
• Involved in Functional, Regression and UAT Testing. 
• Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through HP quality center. 
• Provided Period Close Support for all the financial modules.
• Conduct numerous business meetings to understand and analyze the issues.
• Designing of user-manuals for the modules and training the end users 

Confidential, Raleigh, NC

Oracle Functional Consultant

Responsibilities:

• Providing post production support to the business users.
• Track and update production issues in the issue tracker with proposed solutions. 
• As part of the Quarterly Release Team - Responsible for designing and implementing various AP/iExpense enhancements in each quarterly release covering all stages from Requirement gathering, Business Scenarios and Rules Document (BSR)
• Worked as liaison between technical staff and users. Was also responsible for interdepartmental coordination between the various teams involved.
• Participated in the Conference Room Pilot (CRP) sessions to interact with users to analyze the business process and identify the gaps.
• Gathered business requirements, identified gaps and worked with development team on solutions to bridge gaps.
• Worked with the Business team to baseline the 'AS- IS' Process and derive 'TO- BE' flow.
• Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.
• Responsible for setup, design and testing the purchasing Position Hierarchy for routing PO Approvals as required for the business.
• Provided support on purchasing issues like PO's stuck in workflows & maintenance of purchasing hierarchies.
• PO matching options, invoice tolerances, distribution options, terms, holds, etc. 
• PO setup and matching options with invoices. 
• Actively involved in Mobile expense implementation; Requirement gathering, gap analysis, end to end testing before and after implementation.
• Involved in iExpense customization and custom report development efforts.
• Setup Currencies, Exchange Rates, Organization's Set of Books, Bank Accounts. 
• Setup/Update all the banks, bank branches and bank account for all the countries. 
• Involved in Supplier maintenance: Supplier creation, duplicate supplier clean-up and supplier bank setup/update.
• Helped the business in the month end closing process, closing and opening of new periods.
• Designed, tested and delivered various custom reports as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Rejected Invoices register, etc.
• Developed functional documents for technical customizations in AP, iExpense, Mobile expense, PO, HRMS Modules.
• Worked as member of Support Team for modules iExpense, AP, GL, PO, AR and CM.
• Provided extensive production support of Oracle financials, including following up SR's with Oracle Meta link.
• Analysis and Resolution of issues tagged as Severity3/2/1. Creation and execution of test scripts for the issue ticket.
• Identified SR's as GAP's that needed customization and reviewed with management with GAP analysis document.
• Involved in applying Oracle Critical Patch Update (Oracle CPU) to minimize issues. Conducted patch analysis to estimate the possible impact of Oracle CPU.
• Implemented and delivered new Oracle functionalities with user interaction, performing systems and unit testing. 
• Created test scenarios and developed test scripts for SIT, UAT.
• Performed end to end testing of all the above modules and documented the results in TE040.
• Assisted Business for Business Acceptance Testing and obtain Sign off. 
• Developed material for the workshop sessions and other functional meetings.
• Created test scripts for new functionalities and provided User training on one to one basis and also in group mode.
• Trained finance staff on General Ledger using UPK (User Productivity Kit).
• Conducted knowledge sharing sessions for the team members in the functional areas of known modules.

Environment: Oracle EBS R12.1.3 (AP, iExpense, Mobile Expense, FA, PO, GL, CM, OTL) AIM Documentation, Toad, SQL, Configuration and Testing in R12, Support & Testing.

Confidential, SFO, CA

Sr. EBS Financial Analyst

Responsibilities:

• Involved in business process study and creating business process maps using Visio for Oracle E-Business Suite GL, AP, PO and AR modules during implementation.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions while executing and monitoring of cut over activities.
• Created intercompany Transaction, Consolidation, Elimination entries setups and configurations.
• Created Master/Detail Budgets, Mass Allocations and Summary Templates. Designed FSG Report for Budget Balance, Actual Balance and Funds Available.
• Worked on AR setups - defining the Auto Invoice options, accounting and invoicing rules, revenue recognition, auto lock box process, receipt classes, receipt sources, bank setups, transaction types, etc.
• Utilized Supplier third party relationships to clear payments for Supplier Levy. Designed Custom reports based out of TCA hierarchy to obtain the relationship and third party payment report.
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• Worked on the setups of e-Business Tax module - including the setups of Tax Rates, Tax Codes, Tax Regimes, and Regime to Rate flow - for EMEA and US.
• Oracle Solution Design for Ledgers and Multi-Org structure and have given a POC for Multi-LE to OU structure.
• Worked on the setups of AP Module - setting up financial options, payable Options, system options, pay groups, discount terms, AME rules, etc.,
• Configured payments module including Payment formats, custom payment methods, payment documents, Payment Instruction Formats, Payment Process Profiles, PPR Templates, etc.,
• Conducted Conference Room Pilots (CRP) sessions showcasing the proposed solutions and validating the business requirements.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules. Extensively worked on HP Quality Center for creating test scripts and tracking test results.
• Fixing small code changes as of when raised during UAT and during post production support.
• Performed effort estimation for design and development for data fixes, code fixes and change requests.
• Support Production issues on a day to day basis including month end closure priority issues.
• Performed both validation and technical IT General controls testing for SOX & GAP to make the test documentation meet Client’s compliance regulatory norms.

Environment: Oracle Apps Release 12.1.3 (AR, AP, GL, FA, PO, Cash Management, iExpense, e-Business Tax, Sub Ledger Accounting, Oracle Payments, AME, AOL), TOAD, Workflow Administration, Reports, Forms Personalization.

Confidential, Greenwich, CT

Sr. Oracle Specialist

Responsibilities:

• Implemented Oracle financial accounting hub (FAH) (R12.1.2) to integrate 36 legacy source systems into oracle EBS, including and not limited to People soft Treasury, HRMS, JD Edwards, Oracle Revenue Reconciliations Systems, etc.,
• 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.
• 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.
• Helped in set up of customized programs to allow the loading and auto reconciliation of the bank statements in CM.
• Set up a Bank reconciliation process in Oracle Cash Management and Accounts Payable.
• Validated Customer Master Data Conversion, utilizing TCA APIs for Customer accounts, sites, site profiles, profile amounts and other entities of MDM.
• Collaborated with the technical team to translate requirements into technical design.
• Facilitated the development of custom Oracle XML publisher reports by creating Functional Specification, Testing and Deployment.
• Unit and functional testing the changes and working with business partners to ensure full system testing is complete
• Performed Regression testing of any changes made in Oracle Customizations. Prepared & maintained Traceability matrix to keep track of all the test scripts, test scenarios, test cases to make the auditors and business’ work easy.
• Performing the Quality Analysis of the newly developed RICE Objects by preparing the Test Cases and Scenarios for the Integration & Document Management between Oracle EBS and other Legacy Systems.

Environment: Oracle EBS R12.1.3 (FAH/XLA, EBTAX, AP, GL, AR, CM, PO), Configuration, Support & Testing of Conversions & Integration of Business Objects from external legacy systems into Oracle EBS and vice-versa.

Confidential, Lake Forest, CA

Oracle EBS SME

Responsibilities:

• Worked as an Oracle Financial Functional Analyst and a Test lead for onsite, offshore team. Involved in configuration and testing of AR, AP, GL, CM, FA, E-Business Tax, SLA, PO, and P2P, O2C.
• Provided support for GL, AP, AR, FA and CM modules.
• Gained expertise in using the Oracle user training tool called User Productivity Kit (UPK). Used this tool to record the end to end functionalities of the above mentioned modules.
• Experienced in writing and documenting the test scripts, test scenarios and test cases for all the core financial modules.
• Implemented Location based tax for Accounts Payables & Accounts Receivables through E-Business Tax.
• Demonstrated/Trained the users on R12 functionalities.
• Conducted CRP (Conference Room Pilot) sessions to test the complete functionalities of the above mentioned modules before going into the production.
• Worked closely with the client BA’s of respective functional areas to understand the client business process, setups, working process and their timelines.
• Tested, documented and recorded (using UPK) the customization of client’s Order Management Interface with several third party vendors.
• Tested, documented and recorded the Finance Bank Interfaces of several Operating Units across the globe, with their respective Banks.
• In AGIS, defined Intercompany Order Management system and performed intercompany shipping and billing. Tested and documented the client’s intercompany orders, shipping and invoicing.
• Tested FSG Reports, using multi-currency features including foreign currencies for multi org structures.
• Performed the testing of Sub ledger Accounting Reports like Sub ledger Period-Close Report, Journal Entries report, Third Party Balances Report etc.
• Used Agile Software Development Life Cycle Methodology tool to manage projects, document different processes, promote development, collaborate with the customer throughout the life-cycle of the project.

Environment: Oracle EBS 11i/R12(AP, GL, PO, AR, FA, Cash Management, iExpense, iProcurement, iSupplier, AOL ). Configuration and Testing in R12

Confidential

Sr. Oracle BA

Responsibilities:

• Analyze design, customize, configure and test implement detailed Oracle applications and modules including GL, AP, AR, CM, FA, PO, P2P & O2C.
• Participated in the Conference Room Pilot sessions to interact with users to analyze the business process and identify the gaps.
• Participated and documented the requirement gathering sessions and analyzed the impact of the changes in the requirements.
• Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.
• Account Receivables (AR): Setups for TCA Architecture, Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, Auto accounting Rules, Auto invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Aging Buckets. Defined Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer & Sites, Remit to Address, System profiles.
• Helped the technical team in the customer conversion, Open AR invoices and receipts conversion.
• Have setup the system to allow the business to create the Automatic Receipts and send the Ach files to the bank.
• Have setup the system to create manual receipts which are not applied to the invoices and send the ACH file for these receipts to the bank using a custom program.
• Defined the Funds Capture Setup to process the ACH payments.
• Setup Taxes using E-Business Tax module.
• Helped the technical team in the supplier conversion, Open AP invoices and payments conversion.
• Used E-Business Tax module to setup taxes for Payables.
• Setup Currencies, Exchange Rates, Organization's, Set of Books, Bank Accounts.
• Setup all the banks, bank branches and bank account for all the countries.
• Set up bank transaction codes for the bank accounts for BAI and NSF files and assign GL Accounts to the bank accounts.
• Set up cash management for automatic loading and auto reconciliation of all the bank statements.
• Implementation of Fixed Assets, involved in requirements gathering sessions with the client.
• Led the Conference Room Pilots for the site implementation.
• Preparation of Functional Test Scenarios & Test cases for Fixed Assets.
• Assistance to SIT, UAT, Training and Production Support to End User.

Environment: Upgrade from 11.5.10.2 /R12.0.6 (AR, AP, GL, FA, Cash Management, i-Expense, e-Business Tax, Sub Ledger Accounting, Oracle Payments), AIM Documentation, Toad, SQL, Interfaces, XML Publisher, Reports.

Confidential

Oracle Applications Consultant

Responsibilities:

• Analyzed scope available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the functional design for customizations, in Processes, Programs, and Reports.
• Worked on customizing as well as developing new Workflow processes.
• Designed customized solution for Oracle Fixed Assets to resolve depreciation issues.
• Implemented iExpense in the client TEST environment for user training and testing purposes.
• Resolved issues after implementing iExpense by customizing the process flow of Expense report generation, and rule tracking.
• Integrated iExpense with AP for automatic invoice generation and processing.
• Performed all necessary setups for Corporate Credit Card transactions download and generating Expense reports on timely basis, for fully automating the employee expense through credit cards.
• Involved in the iExpense implementation, designing and performing a major modification to the AMEX daily inbound interface to handle multiple files on the same day.
• Interacted with development team for developing Custom Expense application, which transfers third party employee expense reports that are exported as flat file and in approved status to Project accounting Interface tables. The Custom code also validates and finally loads the transactions as expenditures in PA.
• Defined the Funds Disbursement Setup to process the ACH payments.
• Involved in the authoring and maintenance of documents like BR100, MD050, TE040 and BF45 as part of project deliverables & Preparing Business Process Flow diagrams with the use of MS Visio.
• Configuration of Production, SIT, UAT, instance & Loading of Data with the use of Data Loader.
• Worked with end users to document the business processes & functional requirements also providing them with training materials
• Coordinated with client through Conference calls and WEBEX sessions to get the requirements and also coordinating with the technical team for fixing the issues for proper deliverables to the client.
• Provided KT sessions to the testing and the technical teams

Environment: Oracle EBS 11.5.10.2 (AR, AP, GL, FA, Cash Management, i-Expense, e-Business Tax, Sub Ledger Accounting, Oracle Payments)

Confidential

Oracle Business Analyst

Responsibilities:

• Prepared Central GL setup document applicable for more than 110 legal entities / sites and configured the same in new Oracle instance
• Prepared GL setup documents for assigned sites and did setups in the instance using Data loader & Oracle Web ADI tools.
• Validated Clearing Account balances, Sub ledger to GL balances and Closing the books in Oracle.
• Designed Set of Books, built Chart of Accounts, set up Cross-Validation Rules, Flex field Segments, Journal Sources & Categories, Translation of balances from subsidiary units for reporting purposes and Consolidation, System Controls, Profile Options.
• Created the FSG reports for the balance sheet and the income statement.
• Resolving the issues by SR’s raised during the Project implementation life cycle.
• Attended and conducted Oracle Apps knowledge sharing sessions in modules GL, AP, AR, FA & CM.

Environment: Oracle Application 11.5.10 (GL, AP, AR, CM & FA), Windows XP, Data loader, MS Office Tools

Confidential

Oracle Functional Analyst

Responsibilities:

• Worked on the project by using AIM methodology.
• Involved in End to End implementation Life Cycle of Oracle Financial modules.
• Analyzed client's current business events and process based on client discussions.
• Prepared the Functional Document required for the business - Future Process module and Mapping design.
• Prepared BR100, TE040 and MD050 Documents as per the requirement.
• Document the main setup steps, definitions and implementation issues.
• Setup of Security rules, Cross validation rules and values for Value sets.
• Configured Financial Options and Payable Options.
• Defining Payment terms, Distribution set Internal Bank account and Supplier Bank Account.
• Defined Corporate books, fixed assets categories, assets keys etc.
• Setup the Access control for the users based on the responsibility.
• Setup of Financial Modules in PRE PROD and PROD instances and handing over of PROD instance to Users.
• Testing of Setups done in the above instances.
• Involved in CRP and UAT. Given training to End Users
• Providing the User with relevant Test Scripts to test the instances and helping them on Functional issues.
• Upload supplier & Customer Details from the legacy to the oracle application.
• Done System Integration testing with the sub-ledgers to the General ledger.

Environment:Oracle Application 11.5.8/11.5.10.2 (GL, AP, AR, CM & FA) AIM Documentation, Windows XP, TOAD, Rational Clear Case, Mercury Quality Center.

Confidential

Team Leader

Responsibilities:

• Supervised a team of 11 personnel involved in Online Banking Customer Service via e-mail and chat channel. Also, coordinated with the quality team to increase the performance of associates pertaining to Quality and Customer Satisfaction (C-SAT).
• Minimize variance percentage by conducting calibration sessions amongst all Front line Managers and associates.
• Ensure discussions and follow ups on process level updates through regular interaction with Line of Business Partners besides conducting Customer Experience huddles for the associates.
• Creation of awareness and customer handling skills among associates through sessions on  Enhancing Customer Experience.
• Conduct sessions on Six Sigma related topics like Lean, Spider Chart, Variation, Idea Generation, project Scope and DMAIC Concepts.
• Conducted quarterly and annual performance appraisals for the team assigned.

Team member

Responsibilities:

• Counsel students and enroll for online study courses at PCDI.
• Involved in B2B sales- Birch telecom
• Generated training documents and trained new joiners.
• Involved in user training and guiding other team members with the client business processes.