SUMMARY:

• Over 12 years of experience in Oracle E - Business Suite & Fusion Cloud Applications as a Sr Functional Consultant, Involved in Implementations, Upgrading, Migration
• Rollout and Post Production Support of Oracle EBS in various industries like IT Service, Banking, Telecom, Insurance, Retail Industry & Government Organizations. Expert in identifying Gaps & translating business requirements into technical solutions
• 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 (CRP’s, SIT’s, UAT’s), end-user education and post implementation support.
• Focus on under budget, on time and successful management of Oracle ERP 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 ( USA, Europe, Middle East, India) in onsite-offshore model
• 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 General Ledger (GL) including AGIS and SLA, Accounts Payable (AP) including Payments (IBY), Accounts Receivables (AR), E-BTax, Cash Management (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 Life Cycle(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 Life Cycle (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

SKILL:

• Oracle Fusion Cloud Financials &
• Oracle E-Business Suite
• Oracle 11i and R12
• General Ledger, Payables, Receivables, Fixed Assets,
• Cash Management, Global Consolidation System,
• EBusiness Tax, iExpenses, iSupplier iProcurement, SLA, Supply Chain Management
• Project Accounting, AGCS, AGIS, Global HRMS & HFM
• Oracle Web ADI, Dataloader, Discoverer & SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential - Milpitas CA

Sr Functional Consultant

Environment: Oracle Fusion Cloud Financials - 12

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 'as-is' and the 'to-be' scenarios
• Configured setups for General Leger, Payables, Cash Management 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

Sr Functional Consultant

Environment: Oracle Fusion Cloud Financials - 11g

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 GL, AR, AP, FA, CM, AGIS & 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 Global Chart 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 3rd party system integrations
• Configuring Business Units Reference Data Sets
• Conducting the CRP 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

Sr Functional Consultant

Environment: Oracle Applications R12.1.3

Responsibilities:

• Conducted the POC Proof of Concept to the stake holders
• Rationalizing the Oracle Secondary Ledgers features in order to achieve the business requirements
• Responsible for Client interaction, gathering requirements and process mapping with oracle features
• Designing as-is and to-be 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 Go-Live 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 FSG reports as per the GL Secondary Ledger implementation requirements.
• Designed custom financial reports using FSG, for Corporate/Statutory Reporting requirements.
• Recommended additional COA modifications needed to synchronize FSG's and COA.
• Tested, tracked and implemented FSG modifications into Production environment
• Created multiple FSG 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 CRP, UAT and Cut-over activities of the implementation

Confidential - Maitland FLORIDA

Project Lead / Sr Functional Consultant

Environment: Oracle Applications R12.1.3

Responsibilities:

• Calendar changes as per the legal requirement
• Implement all Oracle Financial, Procurement & Projects modules.
• Calendar Changes:
• Implemented the secondary ledger functionality in order to meet the calendar change & reporting requirements for all 40 operating units
• Developed new FSG reports and Account Analysis reports in Oracle R12 to meet the requirement of TB and other schedules
• Implementation of Financial & Procurement Modules for Digital Risk entities:
• Study the present business process and implement Oracle R12 for the Digital Risk and their entities.
• 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. General Ledger, Receivables, Payables, Fixed Assets, Cash Management & E Business Tax, Purchasing & Projects modules
• Conducting CRP 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 & CITI banks
• Design & implement NACHA payment format in Oracle payments for JPMC & CITI banks 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 Fifth Third and Citi Banks
• Worked on reconciliation of AP(Accounts Payable) with General Ledger (GL) by runningAccounts PayableTrail 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

Confidential, New York

Project Lead / Business Analyst

Environment: Oracle Applications R12.1.3

Responsibilities:

• Solution designing for roll out of Oracle Applications at specific market, considering country specific requirements. Process Reengineering 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 General Ledger, Payables, Receivables, Fixed Assets, Cash Management, EB Tax & GCS
• Configuration, Testing and Data Conversion in Financial modules AP, AR, GL and FA
• Determining Batch Scheduling Requirements
• Conducting CRP 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 Mphasis Senior Management and client leadership team
• Primary point of contact with client management for Production issues in Oracle Financials and their resolution

Confidential

Project Lead / Sr Functional Consultant

Environment: Oracle Applications R12.1.3

Responsibilities:

• Responsible for Client interaction, gathering requirements transferring into technical solution.
• Conducting and driving the study of ”As-Is” and “To-Be” business process for Oracle especially in General Ledger.
• 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 Confidential 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 - General Ledger, Payables, Receivables, Fixed Assets, Cash Management, EB Tax & GCS
• Conducting Conference Room Pilot and supporting User Acceptance Test
• Conducting Steering Committee with Mphasis Senior Management and client leadership team
• Consolidation mapping and setups for the Wyde and Mphasis. Transfer the GL transaction data from Wyde to Mphasis through consolidation on every month end
• Revaluation & Translation Setups
• Created Auto Bank Reconciliation setups using BAi2 format for CITI Bank accounts
• 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 GL

Confidential

Team Lead / Sr Functional Consultant

Environment: Oracle Applications R12.1.2

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, GCS, EB Tax, India Local Taxes and Purchasing modules etc
• Collected requirements, led discussions and established design for new Global Chart 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 CRP, UAT and Cut-over activities of the implementation
• Actively involved in Vendor Management and Project Control
• Worked on third party tool ‘Newgen’ to interface 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

Functional Consultant / Subject Matter Expert

Environment: Oracle Applications 11.5.9

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 In the regular support function the activities carried out included:
• Interacting with 3rd party application like Voyager, RMS, PAT, Delphi & Information Management (MIS reporting tool)
• After the acquisition of Mphasis by EDS, I was involved in creating the Consolidation Books as per EDS 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

Business Analyst

Environment: Oracle Applications 11.5.10.2

Responsibilities:

• Work closely with Oracle Support for the bug fixes and data fixes
• Report customization activity was carried out after the go-live 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 (GL,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

Business Analyst

Environment: Oracle Applications 11.5.10.2

Responsibilities:

• Study the existing processes and development of To-Be 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 GL and removing all errors and wrong entries.
• Created end user training manuals and perform end user training.

Confidential

Business Analyst

Environment: Oracle Applications 11.5.10

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 SOB’s, 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 GL and raised SR when

Confidential

Sr Executive - Finance and Accounts

Responsibilities:

• Independently Handling & Maintaining accounts of Branches
• Preparing MIS Reports - Daily/Weekly/Monthly
• Preparation of Branch wise Monthly Budgets
• Analyze monthly expenditures with the sanctioned budgets to identify major variations if any
• Preparing Monthly financial Reports for Board Meeting and others.
• Ensure Finalization of periodical Accounts on time with utmost accuracy
• Maintaining records & ensure in time fulfillment of all statutory requirements.