SUMMARY

• Over 7 years of experience in Business Analysis and Solutions Architecture Worked at clients of various sizes primarily around Financials solutions and Product Information Management (PIM)
• Accomplished 4 Full life cycle implementation of Oracle Applications Releases 11i & R12
• Possess strong Functional Expertise with the blend of effective communication, excellent interpersonal and negotiation skills.
• Expertise in Oracle E Business Modules - AR, AP, GL, Sub Ledger Accounting, e-Business Tax, Project Accounting (Costing, Billing), Cash Management, Fixed Assets, i-Expense modules.
• Experience with Agile Product Life Cycle Management (PLM)
• Extensive experience with Order to Cash and Procure to Pay Business flows.
• Good working knowledge in Oracle AIM Methodology and OUM (Oracle Unified Methodology). Handled Service Requests (TARs) with Oracle. Knowledge on Oracle Accelerator and Oracle R12.
• Expertise in Implementation where am involved in Module selection, Requirement gathering, Gap Analysis, Solution Design, Building, Testing, User and Production.
• Proficient in Creating User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Extensive experience with EDI Standards and e-Commerce Gateway.
• Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center to perform User Acceptance Testing (UAT).
• In Upgrade projects, handled Discovery, Mapping, Testing and Transition.
• Enhancement and Support, which involved giving Production support by interacting with user for, trouble tickets and establishing the process to be followed.
• Extensive experience in conducting sessions for users to give them knowledge about how the system is going to work.
• Good documentation skills and Proficiency in MS Visio
• Good organization skills & Ability to interact at all levels in an IT organization to assess, evaluate, recommend a different and robust solution and lead through the development.
• Well-proven track in achieving the timeline for deliverables.
• Highly motivated with excellent interpersonal and communication skills.

TECHNICAL SKILLS:

ERP: Oracle e-Business Suite (11i and Release 12) - i-Procurement, Oracle Accounts Payables, Oracle General Ledger, Accounts Receivables, Oracle Purchasing, Oracle Order Management and Oracle Inventory, ASCP, GOP

Scheduling Software: APPWORX

Databases: Oracle 10g/9i/8.x/7.x

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Financials Functional Consultant

Responsibilities:

• Study AS-IS Business Process
• Analyze the expansion Requirements and strategize the migration of customizations.
• 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.
• Understand Division-specific business processes from the end users and implement the same.
• Worked on Project Accounting (Costing, Billing) module setups
• Worked on the Mass Addition process in Oracle Fixed Assets.
• Worked on the Depreciation process in Oracle Fixed Assets
• Worked on all of the configurations of Oracle Fixed Assets.
• Worked on the setups and configurations for GL, Service Contracts, Install Base, AP, AR, i-Expense, Procurement Contracts, Cash Management, Fixed Assets, Sub Ledger accounting, e-Business Tax modules.
• Worked on the AP Setups of the Payment Manager, Payment Process Profiles, ACH process, Payment Methods, Bank Interfaces, etc.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary in the Payment Manager in AP module.
• Worked on the Procurement Contracts module - defining the contracts workbench, contract repository, contract templates, standard clauses, importing clauses form external sources, approvers and approval workflows, etc.
• Worked with business users on planning and executing data conversion activities like Item, AR Invoices, AR Cash Receipts, AP Payments, AP Invoices, GL Balances, GL Journals.
• 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.
• Responsible for the end users on the new processes and facilitated on-the-job .

Environment: - Oracle Applications Release 12.1.1 Upgrade from Release R 12.1.1/11.5.10.2 Rollout for Canada OM, AR, Project Accounting (Costing, Billing), INV, Shipping and Advance Pricing System Administrator

Confidential, Foster City, CA

Financials Functional

Responsibilities:

• Performed AS IS Analysis for the 11.5.10 setup and Identified GAPs with R 12.0.3
• Provided detailed understanding to the users on change points and impact of moving to a Multi-Org environment through extended key user sessions
• Involved in dealing with all the stakeholders on the project to gather requirements, firm up the requirements and then get the signed off by the stakeholders for each functional track.
• Worked on the setups of the Corporate Book and Tax Book in oracle Fixed Assets.
• Worked on the Mass Additions and Depreciation process in oracle Fixed Assets.
• Project Accounting (Costing, Billing) - Worked on the configuration of the Project Costing and Project Billing modules.
• Worked on the setup of i-Expense module and integration with American Express business cards, setting up expense reporting templates, expense categories, approval rules, etc.
• Worked on the configuration of the Vertex module in Oracle - defined the Tax Rates, Tax Codes, Tax exemptions, Tax exceptions, etc.
• Customized the Requisition import process form i-Procurement to Purchasing.
• Designed a Streamlined process for Fulfillment flow.
• Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM and OUM methodology
• Responsible for developing and maintaining documentation like BR-100, CV-40, test scripts and results
• Worked on designing the power point presentations for the business requirements and solutions for the GAPs that were identified.
• Worked with Oracle support for Oracle functionality issues by raising Service Requests.
• Was involved in developing Use Cases for testing of the Quote to Cash business process
• Was involved in designing the communication plan for any changes that were made to the system, any changed that were made to any of the functional processes.
• Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.

Confidential, Mountain View, and CA

Finance Functional Consultant

Responsibilities:

• Worked as a Financials Functional Consultant implemented modules - AP, GL, AR, Project Accounting (Costing, Billing), FA and I-Expense of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on a Deferred revenue customization using the Revenue Recognition process in AR.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Implemented Auto Lock box Functionality in AR for Bank of America & Royal Bank of Canada.
• Functional Designing and executing ‘Data migration’ strategy for Master and Transactional data.
• Developed different reports as per the client’s requirement.
• Trained business owners and business end-users on OM, INV, BOM, PO, AR, Shipping and Advance Pricing modules as part of User Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Confidential

Financials Functional Consultant

Responsibilities:

• As a Financials Functional Consultant implemented financial modules: AR, AP, GL, FA and Cash Management Release 11.5.10.2
• Performed all the Configurations and Setups for AR, AP, GL, FA and Cash Management Modules
• Preparing BR30, BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications from BAAN & D1.
• Created New FSG Reports, using multi currency features including foreign currencies for multi org structures.
• Worked on a customization for Deferred Revenue is 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.
• Implemented the Data Quality Management (DQM) in TCA.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks.
• Establish the best practices and controls in Oracle like... Security, Segregation of duties.
• Unit & Integration testing across all modules.

Confidential, Mountain View, CA

Functional Consultant

Responsibilities:

• Managing the project end-to-end. Management responsibilities include planning, coordinating, executing, tracking, reporting, Issue resolution, dependency/risk management/Mitigation, change management and quality assurance.
• Implemented modules: INV, Shipping, Pricing, OM along with PO integrated with internal e-Procure system, Release 11i of oracle (11.5.7).
• Implemented 3 SOB’s (3 Operating Units) using multi org structure, multi currency along with Consolidation SOB.
• Worked on Revenue recognition in AR.
• Implemented the TCA including setting up Parties, Customer Accounts, Party Relationships, etc.
• Implemented Party Relationships in the TCA.
• Implemented the Data Quality Management in TCA.
• Setup document validation, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created New FSG Reports, using multi-currency features including foreign currencies for multi org structures.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.7, OM, PO, AR & INV).

Confidential

Order to Cash Functional Consultant

Responsibilities:

• Gathering business requirement by having detailed discussions with business team.
• Functional Specification writing, Reviewing Master business requirement details, Gap analysis.
• Review other functional Specifications.
• Worked on the set ups all the modules in Order to cash cycle.
• Preparing various functional requirement and propose high-level design details for programs to keep data in Order Management and i-Store,
• Involved in setups, requirement gathering and functional specs preparation for Oracle incentive compensation.
• Prepared high-level technical design document.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, conversions, customizations, testing,, documentation and implementation of modules.
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), AR, i-Procurement, PO & AP.