SUMMARY:

• 8+ years of Experience in IT with Expertise in Oracle Applications Accounts receivable, Fixed Assets, Inventory, Purchasing, and General Ledger 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.
• Strong Understanding of the New Features Of R12 like Multi Org Access Control (MOAC), Sub Ledger Accounting (SLA), Payment Module, Legal Entity Configuration.
• 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 EXPERIENC:

Confidential, Los Angeles, CA

Implementation of Oracle e-Business suite Release 12.1.3

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

Responsibilities -

• As a Functional Consultant implemented the Business flows including AP, AR, GL, I-Expense, I-Procurement, and Cash Management modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for AP, AR, GL, I-Expense, Advance Pricing, I-Procurement, i-store, OM, Cash Management and Service contract and install base.
• Involved in setting up of Merchant UI in i-Store
• Creating specialty store and hierarchy in i-Store module
• Setting up Product catalog in i-Store
• Customized and developed screens for i-Store using JSP, Java Script and CSS
• Worked on the European Localizations for NL and UK
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• 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.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• I-Expense - Configured i-Expense module including setting up of Payables Lookup Types for i-Expense, Setting up Credit Card expense types, Expense check reimbursement address, Expense reporting template for Connected and Disconnected expense reporting, Defining the expense clearing account, establishing the multi currency setup, setting up itemization in iExpense, Setting of i-Expense P-Card functionality, mapping of credit card expense types, entering employees as suppliers in order to facilitate iExpense access, assigning signing Limits, etc
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Accounts Receivables and Account Payable Module
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, Advance Pricing and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, CA

Business suite implementation

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, Cost Management, SLA, e-Business Tax, AR, FA, INV, OM, AP and PO 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 dat 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 dat were defined.
• Tested a patch dat we had applied for the Revenue Recognition process.
• Performed Standard Functionality testing in i-Procurement, Project Costing, Project Billing, PO, AP 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 dat 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 (AP, AR, PO, Advance Pricing, i-Procurement, FA, GL, Load Runner, CM, HRMS, Payroll) Oracle 10g/9i, SQL, PL/SQL, Developer 6i (Report 6i & Forms 6i), Toad 8.1.6, Workflow 2.6.

Confidential, Dallas, TX

Business Analyst

Environment: Oracle applications R12 (Technology: AR, Cash Management, AP, GL, i-Procurement, i-Expense, PO, OM, INV, Demantra, Sub Ledger Accounting, e-business Tax, Cost Management, Localizations for Europe 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, Demantra, 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, Demantra, AR 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 Dell 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 (OM, AR, AP, Demantra, Advance Pricing, PO, GL, Discoverer 4i), ADI

Confidential

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 noledge 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, PO, GL, Advance Pricing, INV, WIP, Forms, Reports 6i, Discoverer 4i), ADI, Workflow, Workflow Builder 2.5, Oracle 9i, SQL, PL/SQL.