SUMMARY:

• Having overall 6+ Years of extensive experience in Oracle E Business Suite (EBS), Finance and Accounting.
• As an Oracle Functional Financial Consultant expertise knowledge in full life cycle implementation of Oracle R12 applications, Up gradation and support experience in 11i
• Being Chartered Accountant (ACA) and Cost and Works Account (ACWA) expertise in preparing financial statements & MIS Reports.
• Proficient in functional aspects of Oracle modules: General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Cash Management (CE), Fixed Assets (FA), E - Business Tax, SLA, Trading Community Architecture (TCA), System Admin, iExpense, iSupplier and iprocurement.
• Authored various documents using AIM Methodology, which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, GAP Analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration, customization and testing and developing BR 100, MD 50, CV 40, TE 40 and MD120 documents.
• Created test scenarios, test scripts and coordinated with the users, development team and functional team.
• Experience in System Administration activities like creation/ maintenance of users, creating responsibilities, creation of menus, profiles, value sets, flex fields etc.
• Worked extensively with development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support).
• Worked in Offshore model projects, coordinating with the team.
• Prepared Test cases TE-020,030,040 for various financial modules.
• Working level knowledge of various Oracle developer tools including Oracle Forms, Reports, Workflow, Conversions, SQL,
• PL/SQL, etc.
• Extensive experience in Auditing, accounting and taxation works.
• Extensive knowledge in preparation of Monthly MIS reports, Financial Statements and Consolidated Financial Statements.
• Preparation of ITR's and arranging the information for notices received by departments for clients.
• Ability to interact with multiple levels of the business and stakeholders.
• Customer-focused professional, a strong team builder and an efficient multi-tasker.
• Ability to build lasting professional relationships across the teams, customers, users
• Good at usage of Microsoft Excel for data manipulation/reporting using V lookups and Pivot tables and other excel formulas
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open
• Consistently recognized by senior management, colleagues for assuming responsibility and completing projects with high quality on time with focused and innovated work style.
• Conducted requirements gathering workshops, prepared AS-IS(BP-040),TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP,SIT, UAT sessions and user training for accounting professions and users using AIM methodology.
• Very good Experience on Procure to Pay(P2P), Order to Cash(O2C), Record to Report (R2R)and Assets to GL Cycle's Using Multi-Org. Worked on R12 Financial Modules and SLAM, MOAC, TCA, E-BUSINESS TAX. Trained the client's super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports (RICE)
• Competent in understanding the functionality of the core Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• Developed test case, test plan and resting process and conduct core team and end user training. Conducted several CRP'S and UAT'S in Oracle Applications.
• Experience on Data Conversion and Migrations life cycle. Created Use-Manuals using User Productivity Kit (UPK) for standard, custom processes and user procedures.
• Good Team player and leading key business meetings with coordinating and getting signoff from business for the proposed business scenarios as part of Global Implementation.
• Proficient in Data retrieval using SQL queries and supporting the necessary service requested logged with oracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.
• Proficient in understanding client's needs and generating, modifying existing customized reports according to the requirements and specifications
• Well-developed Interpersonal and Communication skills with excellent documentation and presentation skills to work as part of a team with aggressive time schedules.

WORK EXPERIENCE:

Oracle Financial Analyst

Confidential - Memphis, TN

• Confers with department heads and management to discuss strategic data planning, application development, and prioritization.
• Key liaison for communication to and from accounting personnel in relation to systems use and development.
• Knowledge of Financial consolidation systems and upload/reporting solutions
• Using knowledge of ORACLE E-Business Suite (11i/R12), XML, APEX, SQL, PL/SQL, XL4Apps application developer, and business intelligence report writer technology, works with a cross-functional team to identify and assess solutions to business requirements or improvement opportunities.
• Provides technical and functional guidance to project teams during all phases of the Systems Development Life Cycle.
• Designs, develops, tests and documents new applications, reports, queries, and programs.
• Develops and maintains technical configuration documentation for applications and reports.
• Analyzes new application modules and additional software solutions to meet the needs of the finance group and proposes recommendations for management review.
• Training finance end users on key reporting tools.
• Involved in Comcast's Oracle EBS Implementations and its Initiatives and customizations for General Ledger, Payables, I-Procurement, Accounts Payable, Receivables, Fixed Assets, PTP, Inventory, IExpense, Project Costing and Billing, Cash Management
• Performed Oracle Business ERP and Quality Analyst role throughout 2011 Roadmap and implemented and upgraded releases successfully
• Performed meeting within Business stack holders, Developers, DBAs, Quality Assurances and End users of Business high level requirements and its updates
• Recommended best solutions and methods per requirements and functionalities of Oracle EBS
• Used IR Tools and OBIEE for customized reports and Reconciliation Reports and Prepared Data sheets for Reports for updates and to present in Meetings
• Recommended necessary Financial Reconciliations reports and assisted to design reports and tested
• Prepared Bank and Cash Reconciliation Reports and Other Financial Reconciliation and other standard reports
• Placed meetings for Requirements, Implementation, QA, Go to Live for Implementation and Upgrade
• Performed Oracle EBS Functionality Testing of business requirements for Quality Assurances
• Used other major Oracle's such as IPM and Other outside applications such as KOFAX, App Load, Formscap for Images Management and uploading bunch of data using Excel Sheets into the Oracle Database
• Used QTP and Quality Center to manage QA testing and regression testing’s and defects and its reports. Ran automated tests.
• Assisted to Business users for new implementations and Initiatives for testing and Designed, Created Use cases, Test Cases, Test Scripts, Test Plans and uploaded to the Quality Center and ran manual testing for Implementation on each release.
• Created Defects and forwarded to concerned developers and retested functionality
• Defined and Created and Tested Flex field structure, Cross Validation rules, Accounting Calendars, Functional currencies, foreign currencies and budget for QA testing
• Defined and Created and Tested Primary Ledger, sub ledgers and Operating Units for Ledgers
• Created Journal and its Batches (with STAT), Recurring Journals, Mass allocations, Consolidations, Conversions, Journal line Reconciliation, Generated reversal and scheduled automatic reversal journals for QA Testing
• FSG Reports, Financial Reports, Account summary reports, Income and Expense Reports and other Oracle standard reports.
• Liaison between mentors and lead team members helping to increase knowledge of PeopleSoft HCM.
• Involved in the process of identifying the PeopleSoft Definitions used in the existing PeopleSoft HCM 8.8 application that will be impacted during upgrade process and documented the same.
• Planed, Setup and tested Suppliers (with 1099), Supplier sites, Banks, Freight Charges, Sales Tax, External and Internal Bank Accounts, Payment terms, Electronic Payment setups,
• Entered Invoices, Withholding Tax Invoices, Debit Memos, Refunds, Created and scheduled payments and batches with Check, ACH, Electronic, Matched with PO's, validated invoices and Batched Initiated workflow, Initiated and released holds on invoices and payments, Prepayments, Scanned paper invoices and imported images through IPM into Oracle Instance

Financial Accountant Analyst

Confidential, Arlington, VA

• Prepare monthly and year-end Financial Statements for Head Office in Frankfurt (Balance Sheet and Profit & Loss)
• Responsible for month-end and year-end close for A/P, Fix Assets, and GL
• Prepare monthly Divisional Operational expense budget and Variance analysis; forecast models for the New York Branch managers by creating and using Oracle FSG reports and Excel.
• Responsible and perform monthly cost center expense allocations between departments by creating a cost allocation model in Oracle financials General Ledger module
• Provide ad hoc query analysis on product level (Loans products, FX, CDS, CDO, CPI, CPB, FUT, PUT, CAL, MM Loans and Deposits), departmental P and L and Legal entity control / reporting using Oracle Discoverer Business tool, Oracle Hyperion Essbase, Oracle OBI, MS Access and FSG
• Prepare Year - end Balance Sheet Forms to Head Office per German regulatory bodies
• Responsible for GL maintenance and mapping (creating new accounts, cost center, product codes, portfolio and affiliate code) and accounting structure (US GAAP, HGB, and IFRS) in Oracle Financials applications and the back office systems (Impact ICI-securities (accounts, and product) PHX-Loan Deposits (accounting structure), MM-Swaps, FX, and Loan IQ (accounts, product and purposes codes).
• Prepare and post fixed assets entries and maintain up-to-date Fixed Asset records. (Depreciation schedules) by using Oracle Financials Fixed Assets module.
• Prepare daily module reconciliation between the General Ledger and back office sub Ledgers (Impact ICI-securities, PHX-Loan Deposits, MM-Swaps, FX, and Loan IQ), analyzes and resolves discrepancies by reading trades and loan bookings.
• Support the regulatory group with data to support their monthly and quarterly regulatory reporting by creating ad hoc reports.
• Reconcile and maintain suspense, clearing and intercompany accounts on a daily basis
• Prepare annual accounting policy and procedure on the maintenance of Internal, external and GL accounts.
• SOX Documentation: Prepare quarterly Balance Sheet Substantiation for manual and sub ledger driven GL accounts.
• Provide information and analysis to management regarding improving processes. Develops recommendations and provides viable options using independent analysis of information and content of reports.
• Serve as a resource for training, documentation, and knowledge base for Oracle Financial systems
• Conduct User Acceptance Test programs for enhancements and modifications accuracy, reliability and conformance to standards in Oracle financials and back office systems.
• Investigate and resolve day to day problems as they relate to user and data errors; work with IT developers to diagnose and resolve software errors within Oracle Financials and back office systems.
• Create and Posted G/L account journals.
• Special Projects related to implementation of new financial systems, system upgrades and new deals to the system

Oracle Financial Analyst

Confidential, San Diego, CA

• Codes such items as invoices, vouchers, expense reports, check requests, etc., with correct codes conforming to standard procedures to ensure proper entry into the financial system.
• Handles all vendor correspondence via phone or email
• Prepares non-inventory purchase order requisitions.
• Attaches the corresponding purchase orders to incoming invoices with all supporting documentation.
• Investigates and resolves problems associated with processing of invoices and purchase orders.
• Prepares batch check runs, wire transfers, and ACH transactions.
• Assists with monthly status reports, and monthly closings.
• Reconciles various accounts by identifying errors in posting or omissions by applying appropriate accounting standards.
• Process remittance information from checks, drafts and wire transfers for invoices provided by vendors, reviewing instructions accompanying items to determine proper disposition and crediting accounts in accordance with standard procedures.
• Receives, researches and resolves a variety of routine internal and external inquiries concerning account status, including communicating the resolution of discrepancies to appropriate persons.
• Files, maintains, and distributes accounting documents, records and reports.
• Performs other duties as required to support Accounting Department, Vice President And CFO. Also process all company expense reports and new vendor setup.
• Coordinate complex meeting/conferences/event logistics and program budgetary activities with Finance & Administrative Services including media services, printing services, catering, travel agencies, airlines, hotel and restaurant arrangements, etc.
• Assist with arrangements and coordination for on-site conferences to ensure all participants, both internal and external, have a positive experience.
• Expertise in Agile and waterfall methodologies uses during SDLC process for multiple projects in banking and manufacturing industries. Worked as Scrum master as well as Product owner for different project.
• Extensive experience in project planning, executing and implementing projects, and managing project resources and taking ownership on timely delivery of products in every sprint.
• Experienced Business Analyst /Product owner/Domain consultant/Scrum Master.
• Strong knowledge in Oracle financial modules (i.e. FA, AP, AR, GL, eBTax, iExpense and CM) in R11i/R12 environment.
• Experience of full lifecycle Implementations R12 with GL, AP, AR, FA, CE, iProcurement, iReceivables, iExpenses, isupplier E-business tax and Sub ledger Accounting (SLA).
• Experience of full lifecycle Implementations of Vertex integration with Oracle ebtax module and post production support.
• Sound knowledge of writing SQL quires for research and analysis for requirement gathering and post production troubleshooting.
• 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, and FA modules.
• Participated in multiple Oracle apps 11i/R12 implementations in multi org/multi currency scenarios,
• Expert in preparing RD020, BP040, BP080, BR100, MD050 and TE020 documents.
• Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, Accounts Payables and Fixed Assets modules.

Finance Analyst

Confidential, Perth, WA

• Full life cycle experience of Oracle Financials (AP, iexpense 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
• 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 AP into Production and Build Interface with third party system
• Worked on integration of Order management with Account Receivable for Auto Invoicing.
• Configured AP/AR Netting functionality.
• Resolved Refund related issues for the users.
• Configured generation of multiple payment transmission files for single payment batch.
• Performed period closing process by reviewing the period close exception report from general ledger in addition to other exceptions reports generated from sub ledgers.
• Involved in Credit card process configuration in Payables
• Involved in configuring Lock box functionality in receivable.
• 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.

SKILL:

• Budget management , Business Intelligence , Business requirements , C hange management, Documentation , Microsoft Excel , Outlook , Project management , Reconciliations , Requirements Gathering , T raining , U ser Acceptance Testing , Powerpoint .