SUMMARY:

• My core competencies include: Program and project management, solution architecting, business transformation, application setup/configuration, business process re - engineering, business system analysis, custom solution design, business requirements gathering, business requirements mapping, systems testing ( Confidential
• Focus on under budget, on time and successful management of Oracle Confidential projects
• Expert architect in Legal Entity, Ledger, BU/OU solution designs along with corresponding Consolidation
• Worked in multiple vendor environments and managed/lead large teams across different geographies
• Experience in Oracle EBS applications releases 11i, R12 & Oracle Fusion -Cloud Financials
• Experience in Upgradations R11iX to R12 and R12 to R12.X
• Worked extensively on Confidential including Confidential and SLA, Accounts Payable (AP) including Payments ( Confidential ), Accounts Receivables (AR), E-BTax, Confidential (CE), Fixed Assets (FA), Order to Cash (O2C), Procure to Pay (P2P) and Record to Report (R2R)
• Extensive experience with all phases of Software Development Confidential (SDLC) including requirements definition, GAP analysis, fit-gap analysis, system configuration, testing, user training, and post-production support.
• Handled Data Migration of Vendor & Customers Masters, Open Payables & Receivables Invoices.
• Good working experience in Post implementation support and converting the new requirements into CR
• Expert in preparing design documents like BR 100, MD 50, BP40, BP 80 & TE 40 as per oracle standards (AIM - Application implementation methodology)
• Lead the large scale oracle conversion/migration projects from SAP, Quick Books, CONCUR, SAGE to Oracle
• Worked on the secondary ledger functionalities in Oracle R12 in order to meet the calendar changes / reporting requirements
• Effective in the identification of problem areas, development of alternatives and implementation of creative business solutions
• Working with Super Users, End Users and Consultants for RICEW development to resolve business needs
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards
• Intense experience on Trading Community Architecture (TCA) and Software Development Confidential (SDLC).
• Strong finance and accounts background to analyze and reconcile data
• Provided many process improvement solutions which resulted in long term financial & work force savings for the firm
• Sound Knowledge on the AP Payment process and exposure to implement payment process using Payment Process Profiles, Formats, XML Publisher templates to facilitate ACH & WIRE payment formats for US region
• Coordinated with multiple banks and technical teams to automate the payment process
• Leadership Skills - team-management, work allocation, responsibility for team delivery
• Training Skills - end-user training, module demonstration, product overviews
• Managerial Skills - Being responsible for quality delivery of the team; Reporting to senior management with Service Delivery reports; liaising with senior management on Demand and Capacity Management

TECHNICAL SKILLS:

Oracle: Fusion Cloud Financials Oracle E-Business Suite Oracle 11i and R12Confidential, Confidential, Fixed AssetsConfidential, Global Consolidation SystemEBusiness Tax, iExpenses, iSupplier, iProcurement, SLA, Supply Chain Management, Project Accounting, AGCS, Confidential, Global HRMS & HFM

Languages: SQL

Tools: Oracle Web ADI, Dataloader, Discoverer & SQL Developer, SmartView, FRS, OTBI, BIP, JIRA & MOATIS ticketing tools

PROFESSIONAL EXPERIENCE:

Confidential, Fostercity, CA.

Environment: Oracle Fusion Cloud Financials - 12

Oracle Fusion Cloud Functional Consultant

Responsibilities:

• Working with business stake holders to identify the system, operational requirements, and proposed enhancements.
• Responsible to create Functional Setups for all new entities / branches that was acquired by Confidential
• Preparing Business Requirement Document BRD, Future State Design FSD and Setup Documents BR100
• Working on process improvements for Confidential, AP, FA & CM Modules
• Provide functional support for reports created using all current and new oracle cloud reporting tools including but not limited to:
• Financial Reporting Studio & Smart View
• Oracle Transaction Business Intelligence
• Business Intelligence Publisher
• Conducted User Acceptance Testing (UAT) and develop the test plans, test cases and test data to be used in testing
• User training and working with business users to understand and troubleshooting the issues
• Lead weekly project status meetings for assigned team and actively participate in project’s weekly status, and/or, issues meetings
• Supporting on Month End Quarter end issues and assisting the business users while doing reconciliation subledgers with Confidential

Confidential, Milpitas CA.

Environment: Oracle Fusion Cloud Financials - 12

Oracle Fusion Cloud Functional Consultant

Responsibilities:

• Conducted detailed and comprehensive Business Analysis by working with end users and other stake holders to identify the system, operational requirements, and proposed enhancements.
• Preparing Business Requirement Document BRD, Future State Design FSD and Setup Documents BR100
• Conducted the Gap Analysis in order to understand the ' Confidential ' and the ' Confidential ' scenarios
• Configured setups for General Leger, Payables, Confidential and Fixed Assets Modules
• Conducted CRP1 sessions to demo the out of box functionality on the service modules
• Conducted User Acceptance Testing (UAT) and collaborated with the QA team to develop the test plans, test cases and test data to be used in testing
• Provided training and conducted practice and Business Requirements definition sessions. Supported the production environments and users on a daily basis by resolving user issues.
• Experienced in preparing Test Plans, Unit Testing, System Integration Testing and Documentation and Providing support for SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Logged, viewed, accessed, monitored, followed up and closed the Service Request (SR) with Oracle Support.
• Supported to Business users to build the smart view reports as per the requirements.

Confidential, San Francisco CA.

Environment: Oracle Fusion Cloud Financials - 11g

Sr Functional Consultant

Responsibilities:

• Identify business requirements and align them to Oracle Cloud Financials functionality.
• Preparing Business Requirement Document BRD, Future State Design FSD and Setup Documents BR100
• Created System Configuration Setups for Confidential, AR, AP, FA, CM, Confidential & Expenses based on client requirements.
• Designed complex Ledger, Legal Entity, Subledger Accounting (SLA) setups to meet multi-currency reporting requirements
• Analyzed requirements and established designs for new Confidential of Accounts (COA).
• Assessed impact on Record-to-Report track and provided input to redesign team
• Coordinated with and supported IT department in designing data conversions and 3 rd party system integrations
• Configuring Business Units Reference Data Sets
• Conducting the Confidential and User Acceptance Test
• Provide functional application leadership and guidance to client regarding “best practices” and the functionality of the software modules through all phases of an implementation.
• Data Conversion by using FBDI & ADFDI templates
• Provide thought leadership around industry best practices for improving operation efficiencies and profitability of client business.
• Participate with the respective client functional lead throughout system testing. Provide guidance to the respective client functional lead in the preparation of training materials
• Supporting the business users to reconcile and upload the data by using standard Fusion - FBDI and ADFDI templates
• Configuring the reports using smart view and Financial Report Studio
• Project Support: Support project team for successful delivery of the client’s business requirements through all phases of the implementation. Lead weekly project status meetings for assigned team and actively participate in project’s weekly status, and/or, issues meetings.
• User training and working with business users to understand and troubleshooting the issues

Confidential, San Francisco CA.

Environment: Oracle Applications R12.1.3

Sr Functional Consultant

Responsibilities:

• Responsible for Client interaction, gathering requirements and process mapping with oracle features
• Designing Confidential and Confidential process documents and demonstrate the POC Proof of Concept to the Business users.
• Preparing the functional design documents like BRD, MD 050, BR 100, Data conversion/Migration templates and preparing the test scripts.
• Create new fiscal calendar (August- July) for Secondary Ledgers
• Configure Secondary Ledgers for all Primary Ledgers
• Transfer historical account balances & Translated balances from last one year to till Confidential into the Secondary Ledger.
• Assisting the technical team to preparing the conversion scripts
• Create new Consolidation module and mapped all the secondary ledgers, to achieve the consolidated trial balance and other reports
• Analyzed and designed modifications to Confidential reports as per the Confidential Secondary Ledger implementation requirements.
• Designed custom financial reports using Confidential, for Corporate/Statutory Reporting requirements.
• Recommended additional COA modifications needed to synchronize Confidential 's and COA.
• Tested, tracked and implemented Confidential modifications into Production environment
• Created multiple Confidential and custom design reports relating to InterCompany Eliminations
• Propose process improvements and control mechanism in the business processes through R12 capabilities such as MOAC, Data Access & Definition Access Sets
• Responsible for driving Confidential, UAT and Cut-over activities of the implementation

Confidential, FLORIDA.

Environment: Oracle Applications R12.1.3

Project Lead / Sr Functional Consultant

Responsibilities:

• Responsible for Client interaction, gathering requirements transferring into technical solution
• Creating end to end setups for all the Finance and Procurement modules based on the design documents and business requirements. Confidential, Receivables, Payables, Fixed Assets, Confidential & E Business Tax, Purchasing & Projects modules
• Conducting Confidential Conference Room Pilot and supporting UAT User Acceptance Test
• Worked on SLA (Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction
• Created End to End Setups for Receivables & Projects
• Understanding of Revenue Recognition principles US GAAP
• Defined Invoicing and Accounting Rules to meet the revenue recognition schedules
• Defined Transaction Types, Sources, Receipts Classes & Sources
• Defined Auto Invoice & Auto Cash Rule Sets
• Co-ordinated with business users to get the requirements for the custom reports
• Extensively Worked on AP Payments Setup Module it includes:
• Defining multiple banks and payment formats
• Setting up ACH setups for bank
• Design & implement SEPA credit transfer in ACH/WIRE formats in Oracle Payments for JPMC & Confidential
• Design & implement NACHA payment format in Oracle payments for JPMC & Confidential operating in United States
• Coordinating the team to develop XML templates and logic to process Oracle checks, EFT and automatic wire transfers.
• Implemented and created process for XML Check Outsourcing payment formats using Oracle Host to Host Process
• Worked with Technical team to develop the check printing process for Fif th T hird and Confidential
• Worked on reconciliation of AP (Accounts Payable) with Confidential by running Accounts Payable Trail Balance report, posted invoice register report, posted payment register report and Unaccounted Transaction report.
• Integrating between Oracle and third-party tool Concur. Worked on Inbound and out bound interfaces between CONCUR and Oracle
• Responsible to gather details from third party tool manage engine
• Design of SOD Segregation of Duties including the MOAC Multi-Org Access Controls implementation
• Created intercompany Transaction, Consolidation, Elimination entries setups and configurations
• Assess the reporting and interfacing needs and interact with the development team to get the reports/interfaces deployed in Oracle R12 and Discoverer
• Monitoring data reconciliation of legacy data and migrated data project management, team management activities. Project deliverables review and functional testing, client handling and communications
• Develop design documents at various stages of the project as per Oracle’s AIM methodology like BR 100, MD 50, BP40, BP 80 & TE 40 documents
• Conducting end user training sessions and delivering the user manuals
• Participating in Client’s Change Management and Change Requests (CR’s) for any changes in existing processes
• Responsible to resolve user service tickets with SLAs.
• Work with technical team in order to resolve production support tickets related to custom functionality
• Participating in Client’s Change Management and Change Requests (CR’s) for any changes in existing processes and testing the Functionality on the application for all new change requests
• Tracking all development activities and provide updates to the client on daily basis and Lead Regression testing after release upgrade/major patching
• Supporting End users in solving their regular day-to- day problems
• Working with Business Users on a daily basis, providing functional support as well as technical troubleshooting assistance to ensure the successful flow of Business processes.
• Raising SR with Oracle with for getting assistance in resolving the issues
• Manage the Production support team and responsible for working with business users to understand and troubleshooting the issues
• Supporting on Month End Quarter end issues and assisting the business users while doing reconciliation subledgers with Confidential

Confidential, New York

Environment: Oracle Applications R12.1.3

Project Lead / Business Analyst

Responsibilities:

• Responsible for Client interaction, gathering requirements.
• Gather Business Requirement and working on customization as per business requirements
• Develop design documents at various stages of the project as per Oracle’s AIM methodology like BR 100, MD 50, BP40, BP 80 & TE 40 documents
• Creating end to end setups Confidential, Confidential, Fixed Assets, Confidential, EB Tax & Confidential
• Configuration, Testing and Data Conversion in Financial modules AP, AR, Confidential and FA
• Determining Batch Scheduling Requirements
• Conducting Confidential and User Acceptance Testing and Sign off
• Facilitate Change Management Processes, Prepare Process Documents and Diagrams.
• Working with business streams to reconcile the data
• Conducting Steering Committee with Confidential Senior Management and client leadership team
• Primary point of contact with client management for Production issues in Oracle Financials and their resolution

Confidential

Environment: Oracle Applications R12.1.3

Project Lead / Sr Functional Consultant

Responsibilities:

• Responsible for Client interaction, gathering requirements transferring into technical solution.
• Conducting and driving the study of ” Confidential ” and “ Confidential ” business process for Oracle especially in Confidential .
• Gather Business Requirement and working on integration between SAGE and Oracle Application
• Worked on reconciliation of subledger data before moving into Oracle
• Identify scope of integration required and
• Rationalization of Master data.
• Mapping between entities in two systems
• Solution Design and Development
• Preparation of roll-out plan
• Production Roll out
• Develop design documents at various stages of the project as per Oracle’s AIM methodology like BR 100, MD 50, BP40, BP 80 & TE 40 documents
• Creating end to end setups for all financial modules - Confidential, Confidential, Fixed Assets, Confidential, EB Tax & Confidential
• Conducting Conference Room Pilot and supporting User Acceptance Test
• Conducting Steering Committee with Confidential Senior Management and client leadership team
• Closing all issues & providing month / quarter end support it includes running the period closure exceptions reports at subledger level and assisting the team to preparation of schedules and reconciling the data with Confidential

Confidential

Environment: Oracle Applications R12.1.2

Team Lead / Sr Functional Consultant

Responsibilities:

• Study the business processes and find areas of improvement
• Propose applications that need to be sunset and utilize the Oracle e Business Suite capabilities
• Propose process improvements and control mechanism in the business processes through R12 capabilities such as MOAC, Multiple reporting conventions through the use of Secondary Ledgers, Confidential, EB Tax, India Local Taxes and Purchasing modules etc
• Collected requirements, led discussions and established design for new Confidential of Accounts (COA).
• COA design for 8 segments, including new Parent/Child rollups and COA Mapping design for conversion from legacy chart of accounts structure.
• Responsible for driving Confidential, UAT and Cut-over activities of the implementation
• Actively involved in Vendor Management and Project Control
• Worked on third party tool ‘ Confidential ’ to Confidential invoices to Oracle AP module
• Assess the Application GAPS in comparison with the BPR propositions
• Develop design documents at various stages of the project as per Oracle’s AIM methodology like RD 20, BR 100, MD 50, BP40, BP 80 & TE 40
• Participating in CCB meetings for the new Change Requests.
• Configure the Finance modules based on the design documents and business requirements
• Design Period close processes along with the schedule of close activities
• Lead the post implementation support team and provide high level of service with low turnaround time
• Giving support for Month, Quarter and Year end Closure activities including all Reconciliations

Confidential

Environment: Oracle Applications 11.5.9

Functional Consultant / Subject Matter Expert

Responsibilities:

• Assess the global and local reporting requirements
• Configure the Financial modules
• Coordinate the migration activities
• Support the post roll out/migration period close activities
• Interacting with 3 rd party application like Voyager, RMS, PAT, Delphi & Information Management (MIS reporting tool)
• After the acquisition of Confidential by Confidential, I was involved in creating the Consolidation Books as per Confidential reporting requirements
• Participating in Client’s Change Management and Change Requests (CR’s) for any changes in existing processes
• Giving support for Month, Quarter and Year end Closure activities including all Reconciliations

Confidential

Environment: Oracle Applications 11.5.10.2

Business Analyst

Responsibilities:

• Work closely with Oracle Support for the bug fixes and data fixes
• Report customization activity was carried out after the Confidential milestone.
• Interact with End Users and Business in completing all process and period closure
• Resolving the issues or trouble tickets that arise over various plants which span over various modules in Financials ( Confidential, AP and AR)
• Developing design documents as per oracle’s AIM methodology like MD 50 and TE 40
• Worked on Auto Lock Box setups and POS system Point of Sale
• Supporting and Resolving the issues on AME Approvals Manage Engine rules
• Supporting the month end and period end closure issues by running the exception reports
• Raising TAR to Oracle to resolve / fix the production issues

Confidential

Environment: Oracle Applications 11.5.10.2

Business Analyst

Responsibilities:

• Study the existing processes and development of Confidential documents
• Tested various reports like Aging 7 Buckets, Trial Balance, Supplier Report, Supplier Payment, Invoice on Hold, Transaction Register and Un-posted Items Register
• Defining assets as an items and tracking the assets details from purchasing to assets through payables (Mass addition process) and assist the users for PO Matching
• Assist Technical team to design and develop new reports as per client requirements
• Prepared the Master data sheets for the open invoice data in AP & AR
• Involved the Reconciliation of data with Business in order to match the creditors and debtors balances
• Preparing the documents as per AIM methodology like BR 100, MD 50, BP40, BP 80 & TE 40
• The support work includes helping the end users in transferring all invoices and payments from AP to Confidential and removing all errors and wrong entries.
• Created end user training manuals and perform end user training.

Confidential

Environment: Oracle Applications 11.5.10

Business Analyst

Responsibilities:

• Review Organization Structure and Study Process of Transaction Flow.
• Data migration activities and uploading the data through ADI
• Setting up financial and payable options, payment terms etc.
• Defining Calendars, COA and Confidential, Creation of Financial Statement Generator
• Define payment terms and pay groups and Setting up Banks
• Defining Asset Categories, Depreciation methods
• Define Expense Report Templates and enabled for iExpenses Module
• Define Lookup Codes based on existing system
• Define Auto Accounting and Tax Options
• Defining Banks and worked on the Auto Bank Reconciliation
• Define Profile Classes and Transaction Types
• Define Receipt Class and Receivable Activities mapping with client requirements
• Assist the team to do asset transfers, adjustments, assignments, retirements and depreciation.
• Provided the post production support for two months
• Supported closing month end periods in AP, AR and Confidential and raised SR when