SUMMARY:

• 7 years of Experience in IT with Expertise in Oracle Applications Accounts Receivable, Accounts Payable, General Ledger, Fixed Assets, Cash Management, i - Expense,, i-Procurement, i-Supplier, i-Store, Modules as a Functional Consultant.
• Experienced two full life cycle implementation (SDLC) on Release 12 and has very good understanding of the new features of R12 like Multi Org Access Control (MOAC), Sub Ledger Accounting (SLA), Payment Module, Legal Entity Configuration.
• Experienced in full life cycle implementation with AIM methodology - Scoping, Project Preparation, Business Blue Printing, Realization, Final Preparation, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities, Go-Live and continuous support including AS IS - TO BE and Gap analysis.
• Complete setup of BOM, which includes defining and maintaining the BOM’s, Routings, maintaining departments and resources
• Extensive experience with writing of BR100, MD 050, TE40 and FSD.
• Experienced in Post Implementation Production Support and training the end-users using the RWD Perform tool.
• Performed Unit Testing, Integration Testing and also assisted end users in User Acceptance Testing to validate the business scenarios using quality tools such as HP Quality Center.
• Expertise in analyzing and extracting core issues in complex business and technical processes as well as providing guidance and supervision to large and small groups.
• Experience in running Journal Import from GL Interface from External Legacy system and Data conversion.
• Expertise with working on Discoverer reports 4i/10g including creating Business Areas and End User layers. He also has extensive experience with working on developing Financial Statement Generator reports (FSG) in General Ledger.
• Experience in carrying out Procure to Pay (P2P), Order to Cash (O2C) and various other crucial business flow cycles while mapping them to businesses.
• Efficient team member with excellent work/time management skills, excellent leadership, communications and interpersonal Skills, ability to work under strict deadlines.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Functional Business Analyst

Modules: AR, AP, GL, FA, AR, i-Procurement, i-Supplier, i-Store.

Responsibilities:

• Worked on the setups for the AR, AP, GL, FA, i-Procurement, i-Supplier, i-Store & Cash Management Modules
• Preparing BR30, 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.
• Worked on a customization for Deferred Revenue in AR using Revenue Recognition process.
• Implemented internal control features using Form Personalization’s for modules GL, AP, and AR.
• Configured Auto Invoice in AR to import data from the non Oracle ERP instance in Japan.
• Implemented TCA - for AR customer master conversions.
• Establish the best practices and controls in Oracle like... Security, Segregation of duties.
• Unit & Integration testing on all cross modules.
• Provided post Implementation support.
• Created New FSG Reports, using multi currency features including foreign currencies for multi org structures.
• Worked on the OM Setups of Transaction Types, Processing Constraints, Order and Line workflows, Price Lists, Credit checking, etc.
• Performed setups for Inventory module including setting up of the Item Master, defined item templates, categories, catalogs, defined item attributes
• Worked on the Advance Pricing module - setting up Modifiers, Qualifiers, Formulas for pricing, etc.
• Enabled items in various organizations, controlled item attribute changes, defined roles and implemented role-based security
• Performed organizational set ups including inventory locations, freight carriers
• Performed implementation of ABC codes, Cycle counting and Physical Counting
• Set up the approval hierarchies and workflows in Purchasing
• Complete setup of BOM, which includes defining and maintaining the BOM’s, Routings, maintaining departments and resources
• Created Supplier setups, Approved Supplier List and defined Sourcing Rules
• Worked on i-procurement setups, shopping categories, content zones and stores
• Worked on the configuration of Purchasing and Inventory modules
• Involved in understanding the existing business process & conducted meetings on client business overview
• Performed Gap Analysis so as to integrate the business requirements to oracle applications
• Prepared business requirements documents for Purchasing and Order Management

Confidential, CA

Environment: Oracle Application Release 12.0.5

Responsibilities:

• Involved in the Implementation and Post-Implementation Support
• Impact analysis done on the service items and professional service items with the new setup done for the Event-based Revenue Recognition process
• Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10).
• Written standard Integration test scripts for Oracle Financials, AR, AP, GL, FA, Project Accounting, Project Billing, Project Costing, Cash Management, Purchasing, i-Procurement, WIP, BOM, OM & INV Modules.
• Created reusable actions for user-defined functions to enhance code efficiency.
• Submitted weekly status updates and reports showing the progress of Software Testing.
• Responsible for validating the back-end data that was migrated from previous versions.
• Recommended areas for fine-tuning the system based on the analysis to the server experts(s) and system administrators.
• Generated test scripts to be used as Virtual users and scenarios to imitate the business processes and behavior of real users using Load Runner.
• Created DNS Test Scripts for all FTP jobs as a part of upgrade project introduces Multi-tier Environment and change the hard coded server names to DNS names.
• Worked on testing the Revenue Recognition functionality in AR for all the Accounting and Invoicing rules that were defined.
• Tested a patch that we had applied for the Revenue Recognition process.
• Performed Standard Functionality testing in AR, AP, GL, Project Accounting, Project Billing, Project Costing, Cash Management, i-Procurement, Project Costing, Project Billing, and OM.
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Tested Multi-Org Setups as a result of the new Parts Operating Unit that is being introduced as part of the upgrade to R12.
• Involved in Unit Testing and System Testing.
• Documented and communicated test results to the Test Management and Business Management Team
• Worked closely with Developers team for different issues

Environment: Oracle (AR, AP, GL, FA, Project Accounting, Cash Management, Purchasing, i-Procurement, OM INV) Oracle 10g/9i, SQL, PL/SQL, Developer 6i (Report 6i & Forms 6i), Toad 8.1.6, Workflow 2.6.

Confidential, Seattle, WA

Business Analyst

Environment: Oracle applications R12 (Technology: AR, Cash Management, AP, GL, i-Procurement, i-Expense, Project Accounting, PO, OM, INV, Sub Ledger Accounting, Localizations for Europe, Israel and China), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD

Responsibilities:

• Study AS-IS Business Process.
• Analyze the Upgrade Requirements and strategize the migration of customizations to Release 12 instance.
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on setting up the Intercompany Accounting process including both GL and Internal Order Internal Requisition Process (IRISO)
• Worked on setting up of Revenue Recognition process in AR Module
• Defined the Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
• 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.
• Setup the AR, AP, GL modules
• Good understanding Financial Accounting standards and Revenue Recognition Standards.
• Understand Division-specific business processes from the end users and implement the same.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation.

Confidential, Austin, TX

Functional Consultant

Responsibilities:

• Member of Global GL/GIS team responsible for OM, AR, AP, Cash Management, and GL
• Core member of CRP2
• Worked on Mercury Quality Center as a Test Director.
• Functional design for GL interface with external systems for 70 SOB
• Responsible for communication with overseas IT resources for different global GL components
• Worked closely with IT team for different issues.
• Set up, created the FSG profile options and created datasheets for the FSG reports.
• Developed FSG reports in Oracle General Ledger, which includes balance sheet, income statement, revenue recognition reports, and profit and loss statement.
• Developed and maintained functional specifications for custom reports
• Created test scripts for validating the FSG reports.
• Met with Confidential leads and users to generate and review the current and future reporting requirements of the client.
• Provide end user support of financial and analytical reports using Oracle General Ledger, FSG, ADI and Discoverer.
• Developed several reports using Discoverer 4i.

Environment: Oracle Applications 11.0.3, 11.5.8 (AP, GL, Cash Management, Fixed Asset, AR, OM, WIP, BOM, Discoverer 4i), ADI

Confidential, Santa Clara, CA

Oracle Financial Functional Consultant

Responsibilities:

• Examined the client’s current and future business processes.
• Defined the calendar and chart of accounts. Defined the Multiple Set of Books, Accounting Periods, Journal Sources, Journal Categories, Automatic Posting, Suspense Accounts, Round difference accounts and Summary Accounts.
• Created journals (standard and formula) for the interfaces.
• Defined Mass Allocation Formula.
• Used ADI (General Ledger Desktop Integrator) to integrate the GL module to the Excel spreadsheet.
• Defined value sets, key flex fields segments and roll-up groups with security and cross validation rules.
• Prepared documentation provided adequate knowledge transfer.
• Generated several FSG Reports.
• Work with team to resolve critical issues. Identify, document and expedite resolution of Oracle functionality issues. Track and expedite Oracle TARS (Technical Assistance Requests) and assist with the planning and testing of updates and patches.
• Worked on testing the applications end to end. Wrote test scripts, worked with business to execute test scripts.
• Developed financial statement generator reports in Oracle General Ledger, which includes profit and loss statement, balance sheet, revenue recognition reports.
• Developed and maintained functional specifications for custom reports
• Met with users to generate and review business test cases.
• Developed several reports using Discoverer 4i.

Environment: Oracle Applications v.11.5.3 (AP, GL, Cash Management, Fixed Asset, AR & OM, Forms, Reports 6i, Discoverer 4i), ADI, Workflow, Workflow Builder 2.5, Oracle 9i, SQL, PL/SQL.