SUMMARY

• F inancials System Consultant/ Business Analyst with total experience of 12 years out of which almost 11 years of experience in Oracle Apps 11i and R12 Financials, Accounting, Taxation and SOX compliance.
• Oracle Application Implementations, Rollouts, Upgrade and Support Projects
• Comprehensive experience in analysis, and design, testing implementation of business systems involving Oracle Applications 11 i./R12 Modules:
• Also Expert in R12 new Modules/Functionalities including Sub - Ledger Accounting(SLA), Accounting Set up Manger, MOAC, Reporting Currencies, Secondary Ledger, AGIS, BPA
• Rich Exp in Record to Report, Procure to Pay and Order to Cash Cycles
• Experience and knowledge in SQL, PL/SQL, Toad, SQL Developer, FSG, Web ADI, Desktop ADI and other Reporting Tools.
• Always open for new challenges and enriching my knowledgebase.
• Strong communication skills and ability to build strong working relationships with business users
• Ability to learn and adapt quickly to a dynamic environment.
• Ability to multi-task and efficiently prioritize tasks assigned.
• Expert in Documentation, creating flowchart and business process flows.
• Preparing User Manuals and SOP and training key users.

• Co-ordinate business for Month end closing.
• Meeting with business for new requirements and developments.
• Executing new projects and doing project management using Primavera.
• Work with Change management to prioritize and schedule changes for the migration window and complete SOX compliance for all the change / project related activities.
• Working closely with vendors and contractors on the project.
• Preparing test scripts and user training documents.
• Suggesting business for improvements in business process.
• Executed projects with Banks, PayPal and PYANEARME to provide solution based on Webservices to record realtime payment in Oracle EBS.

• Supporting day to day business process, month end, quarter end and year end closing.
• Acting as Finance SMEs and approving all the CRs related to Financial Modules.
• Responsible for all the financials modules GL, AP, AR, FA, CM, iexp .
• Managing Custom modules like Labor Distribution System (LDS), DPTS(Direct Pay Tax System) etc.
• Monitoring Lockbox, Bank Statements, Hourly Payroll Files coming and loading on daily basis.
• Peoplesoft Employee Interface with Oracle Employee Data on daily basis. Fixing issues related to PeopleSoft Interface.
• System and Security Admin and
• Mentoring and managing offshore team.
• Resolving critical issue directly onsite.
• Assigning development to offshore with proper inputs and guidance.
• Preparing Business Process Documents for New processed or changes.

• Involved in As Is, To Be Process, Mapping and Gap Analysis.
• Hosting CRP for Client on Oracle Financials module and demonstrating various useful functionalities and features.
• Discussion on To be Process (BP080) and Sign Off for the same.
• Productions Setup and BR100 Document
• MD050 for Custom functional designs.
• Creating User Training manuals.

• Involved in As Is, To Be Process, Mapping and Gap Analysis.
• Hosting CRP for Client on i-Procurement, Service Procurement, iSupplier/Sourcing, VMI/ Collaborative Planning, i- Expense and eAM.
• Discussion on To be Process ( BP080) and Sign Off for the same.
• Conducting Weekly Review Meeting.
• Preparing Weekly Status Report.
• Managing Resources, assigning task, tracking progress and preparing Agenda to meet project plan.
• Conducting Quality Review for Important Documentation and Deliverables.
• Following up escalations.

• Involved in As Is, To Be Process, Mapping and Gap Analysis.
• Designing Chart of Account (CoA) Structure, Cross Validation Rules (CVR), Security Rules, Security Profiles, and Data Access Set etc.
• Units Test Plans Preparation and Testing.
• Using Business Accelerator Tool for setting up CRP Instances.
• Preparing Business Flow docs for Order to Cash, Procure to Pay, Expense Report to Invoice, Period End Close to Financial Report, Subledger Journals to Post etc.
• Demonstration of different business flows to users.
• Preparation of Functional Spec, Documents on AIM- RD20, RD30, BP80, BR100, TE40
• Go Live and Production Support.
• Supporting Period Close for Financials Modules.

• Manage the production support queue for Financials Modules like GL, AP, AR, FA, CM, PO, INV, OM etc. Responsible for working with business users to understanding, troubleshooting and resolving production support tickets.
• Work with Oracle Support to resolve e-Business Suite issues with Oracle seeded functionality.
• Work with development staff in order to resolve production support tickets related to custom functionality.
• Lead or be a part of a team for small enhancement projects and ensure all development activities are carried according to Clopay's development processes.
• Work with business users to gather requirements and complete functional and technical specifications for small enhancement projects.
• Assist technical staff with development activities.
• Assist business users preparing and executing functional test cases for small projects.
• Additional duties and responsibilities as requested by the Oracle Development Manager.
• Supporting Period Close and Year Close for Financials Modules.

• Supporting All the Financials modules GL, AP, AR, FA, OM, CE, Project Accounting, Costing and Billing.
• Solving tickets coming from users and complying with the SLAs.
• Also supporting problems on Desktop ADI and Web ADI.
• I have also been involved in providing user training and cross module trainings and preparing SOPs and training manuals.
• Using ITSM (Remedy) tool to generate report on the issues and updating SRs and providing root cause analysis.
• Actively Participating in UAT/QA Process for preparing Functional Test Cases and co-operating users in executing the test plans and doing impact analysis for any patch or data fix.

• Defined the Set of Books and Chart of Accounts. Summarized accounting information required by product, by department.
• Design of Accounting Flexifield Structure and Set of Books
• Set up budget organizations & set up systems for entering budget amounts & journals.
• Set Cross Validation and Security rules.
• Defined Rollup Groups, Summary Accounts and Suspense Accounts.\
• Set up of Oracle Receivable that included - Defining System Options, Accounting Rules, Aging Buckets,
• Banks, Bank Charges, Bank transaction Codes, Dunning Letters, Transaction Types, Payment Terms, Invoicing etc.
• Implemented Payables - Payment Terms, Pay Group, Tax Set up, supplier's Sites, Bank, Distribution set and Financial and Payable options.
• Defining Budgets and Budget Organizations
• Setting up of security rules and assigning to different responsibilities
• Defining accounting aliases to ease the account entry
• Generating financial statements using FSG
• Define Payment terms, Transaction type, Transaction Sources Receipt Class, Sales Person, Collector Etc.
• Defining Organization
• Defining System Profile Option
• Defining Customers and Customer Profile Classes
• Setup Invoice, Credit Memo, Receipt, Deposit, Guarantee, Charge back and Recurring Invoices
• Setting up Asset Key, Location and Category KFFs
• Defining Fiscal Year, Calendar and Prorate Conventions
• Defining Book Controls- Corporate, Tax and Budget
• Defining Depreciation Methods- Flat, Production, Calculated & Table
• Asset Additions- Mass, Detail and Quick Additions
• Asset Retirement, Transfer, Changes and Revaluation
• Production Support, Change Management following SOX compliance.