SUMMARY

• Strong knowledge in Oracle financial modules (i.e. FA, AP, AR, GL and CM) in R11i/R12 environment.
• Sound knowledge and experience on other modules like Purchasing, Inventory, Order Management and System Administration.
• Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P) and FA to GL on Oracle e Business suite in R11i/R12.
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End - User Training and Supporting for Oracle Financials R12/11i GL, AP, AR, CM,andFAmodules.
• Participated in multiple Oracle apps 11i/R12 implementations in multi org/multi currency scenarios, Order management and worked as areas involving Pricing, Purchasing, and Inventory.
• Expert in preparingRD020, BP040, BP080, BR100, MD050andTE020documents.
• Experience in Data mapping the external source files with oracle columns inOracle Accounts Receivables, Accounts PayablesandFixed Assetsmodules.
• Prepared Functional design documents for customizations/conversions using AIM methodology.
• Experience in all phases of the system development/implementation life cycle.
• Prepared the Test scripts for all financial modules i.e. FA, AP, AR, GL and CM with all business scenarios to test in all phases i.e. CRP, SIT and UAT.
• Strong knowledge and working experience in end to end testing for all modules.
• Involved to conduct UAT session with Business user and prepared User documents for all financial modules.
• Co-coordinating and helping the Business user in executing the Business scenario in Oracle.
• Involved to provide USER Training to end user with the entire business scenario.
• Responsible for Fixed assets management like CAPEX and OPEX analysis, CAPEX viability (analysis of return on investment, net present value, lease/purchase, pay back) on Oracle fixed assets module.
• Ensure accuracy and discipline of accounting in O2C and P2P on a regular basis by running routine queries/checks.
• Has good experience in processing, maintaining and reconciling a high volume of O2C transactions on oracle financials modules Rel12 and Rel11i as per India/USA/Australia GAAP.
• Preparation of different FSG reports including Trial Balance, P & L A/c, Balance Sheets as per Australian and US GAAP.
• Responsible for Month-end close reporting, Variance Analysis, Trend Analysis, Quarterly and monthly forecasting and Forecast vs. actual comparison on oracle Hyperion financial Management tool.
• Debtors Management, Creditor management and providing all Oracle report for debtors and creditors management on a regular basis.
• Preparation of Balance Sheet, Intercompany and Fixed assets reconciliation reports.
• Various MIS reports as and when required for Cost control and performs root cause analysis.
• Prepared Tax Return of Individual, Partnerships, Sole traders and Companies.
• Involved in handling direct and indirect taxation matters including filing of returns, assessments and compliance related to employee and vendor TDS, Corporate Tax, Service Tax, Input and Output VAT etc.

TECHNICAL SKILLS

Oracle E-Business Suite: Oracle Applications R12.1.3, 11.5.10.2, 11.5.8, 11.5.5 & 11i

Oracle ERP Modules: Extensive Experience: GL, AP, AR, CM, FA, eBus. Tax, iexpense & Sys Admin Supplementary Experience: OM,PO & iProcurement

Oracle E-Business Components: Oracle Financial Statement Generator (FSG), Oracle Approval Manager (AME), Oracle Hyperion Finance Management and OBI.

Databases: Oracle 10g (10.2.0.4), Oracle 9iR2, Oracle 8/8i

Development Tools: Oracle SQL, PL/SQL

General Tools: Toad, Microsoft Office, MS Visio, MS Projects

OS Platforms: Sun Solaris, Oracle Linux, Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential

Sr.Finance Analyst-Oracle EBS

Responsibilities:

• Perform study on current business process, Conduct discussions and review requirements & impact on upstream and downstream applications (Boundaries Application.
• Evaluating the upgrade (including development of a comprehensive business case for order to cash)
• Upgrade Planning- upgrade objectives, decisions regarding any new features and functionality to be implemented, potential changes to business processes esp. Order to cash, the impact of the upgrade on customizations or interfaces in current environment, and system downtime requirements.
• Communication with key stakeholders in the upgrade plan
• Perform Functional Evaluation
• Perform CEMLI Evaluation and their Retro fitment
• Worked Order to Cash Processes and module integrations with AR, GL, AP, OM and INV with in EBS System
• Performing the technical upgrade (including conference room pilots/test rounds)
• Perform Multiple phase of CRP
• Prepared Test Plan for UAT and system readiness for UAT
• New Release Setup and maintain BR100 Doc
• Perform Testing Prepare/Review installation scripts and documentation
• Prepared Test Scripts for testing transactions and set-ups functionality according to the Customer Business Rules.
• Update System Test script document TE 40
• Perform UAT and Migrate technical objects to Prod Instance
• Facilitating end-user learning and adoption
• Cutover to production

Confidential, Boston MA

Responsibilities:

• Receipts of issue request from Business Users and attending to the request based on the priority
• Work closely alongside business users to recommend best practices and procedures in using Oracle Applications.
• Interaction with Oracle Online support through Meta-link for support related issues.
• Addressed new requirement and configured it in Applications.
• Maintain BR100 and MD50 doc as and when required.
• Configuration and system setups to map new business requirements e.g. Lease accounting in FA.
• System Integration Testing
• User Training and User Acceptance Testing.
• Preparing Setup Documents, Functional Specifications for Customizations, Test Scripts & Training material.
• Supporting the Key users and End users in the new environment.
• Provide 2nd level Oracle functional support for users and super users
• Ensure accuracy and discipline of accounting in Oracle Application O2C flow on a regular basis by running routine queries/checks.
• Work closely alongside business users to recommend best practices and procedures in using Oracle Applications.
• Identify training needs, produce training material or deliver training that will ensure the optimal usage and understanding of Oracle eBusiness Suite.
• Priorities issues as they arise according to business need and impact
• Work closely with technical resources (3rd level support) or other internal teams to resolve problems
• Work with Oracle or other 3rd parties to resolve issues
• Understand the business process and Oracle Financials application at the appropriate level to influence the future business process design and final custom build requirements.
• Coordinate with the Delivery team to ensure seamless transition from the Analysis phase to the Design phase.
• Build and maintain strong cross-functional relationships and maintain effective communications with team members, stakeholders, and business partners to effectively influence the achievement of business results.

Confidential

Responsibilities:

• Full life cycle experience of Oracle Financials (CM and AR modules) implementation in a Multi-Org environment, activities include requirements definition, GAP analysis, process modeling, application configuration, system testing, user training and data migration
• Worked for Order to Cash Processes and module integrations with AR, GL, AP, OM and INV with in EBS System.
• Conducted requirement gathering meetings with functional owners.
• Meetings with steering committee for the Status review and issues.
• Documenting Business requirement specifications.
• Solution Design and Gap Analysis
• Configuration and system setups to map business requirements
• Data Conversion scope includes AR and CM into Production and Build Interface with third party system
• Worked on integration of Order management with Account Receivable for Auto Invoicing
• Perform Multiple phases of CRP and issues resolution
• System Integration Testing
• User Training and User Acceptance Testing
• Interaction with Key Users for designing of New Business Process models necessary to be implemented due to available functionalities of new application.
• Preparing Setup Documents, Functional Specifications for Customizations, Test Scripts, Training material and Cut-over Documents.
• Supporting the Key users and End users in the new environment.

Confidential

Responsibilities:

• Requirement Gathering and Business Process Analysis of Confidential
• Business Process Mapping, Solutions, Design and Gap Analysis
• Conduct multiple CRP (Conference Room Pilot) and filled the GAP
• Prepared Setup doc (BR100) and Functional Design Doc (BP80).
• Prepared Test script (TE20) for end-to-end testing.
• Involved in Post Production support, Receipts of issue request from Business Users and attending to the request based on the priority.
• Monitoring the status of the tickets and providing on line solutions to the client using Support Central.
• Interaction with Oracle Online support through Metalink for support related issues and other 3rd party support team for providing solutions.
• Final closure of the tickets after receiving.
• Prepare Test plan for the upgrade and integration testing for all Operating Unit
• Weekly reporting to management in USA.
• Mapping new business requirements.

Confidential

Finance Analyst

Responsibilities:

• Requirement Gathering and Business Process Analysis of Confidential
• Business Process Mapping, Solutions, Design and Gap Analysis
• Conduct multiple CRP (Conference Room Pilot) and filled the GAP
• Prepared Setup doc (BR100) and Functional Design Doc (BP80).
• Prepared Test script (TE20) for end-to-end testing.
• Supporting day-to-day activities in financial modules mainly in Fixed Assets, General Ledger, Cash management, Accounts Receivable and Account Payables.
• Working closely with Business for all support issues.
• Sub-ledger interface and reconciliation with GL in Oracle financials.
• Bank and other major accounts reconciliation every month end.
• Monthly and Quarterly financial closing and reporting P&L and Balance sheet.
• Consolidation and Segment-wise reporting and performance analysis vs Budget and vs Previous Year.
• Debtors Ageing and reporting.
• Calculation of Transfer Pricing for Intercompany Invoicing
• Preparation of MIS reports for US office on every month end.
• Supplier and Customer dealing and payment.
• Month and year closing and opening in financials module.