Over 7 years of with Oracle Apps Financial Functional Analyst with sucessfully Implementation of Oracle General Ledger, Accounts Payables, Accounts Receivables, Cash Management, Fixed Assets and Management of I-procurement, I-Expenses, Order Management Cycle, and Sys Admin. Possess a sound knowledge of Financial Accounting Applications and Business Process Analysis and US GAAP and Government Accounts. Having team oriented professional with strong interpersonal skills and Communications Skills.

SUMMARY:

• Having over 7 years of experience in Implementation of Oracle EBS projects and its Initiatives, Customizations, Testing, Go to Live, End user training, UAT and production support which includesGeneral Ledger (GL), Accounts Payable (AP), Payments, Accounts Receivable (AR), Cash Management (CE), Fixed Assets(FA), Purchasing Cycle, I-Procurement(I-Proc), I-Expense, Inventory, Project Billing, Project Cost.
• Implemented full life cycles of Oracle E Business Suite Applications in Financial area having globally operated Multi Organization, Intercompany, Multiple Legal Entities, Multi interfaces with multi currency business environment
• Well versed with US Financial Accounting Standards and US GAAP, Government Accounting, Grant Accountings, International Financial Reporting Standards, Financial Reports, Reconciliations
• Competent in full understanding of the functionality of core Oracle Financial Modules (GL, AP, AR, CE, FA, I-Proc, I-Exp) and their interplay in the application set-ups and overall accounting structure of an organization with its sub organizations.
• Extensively working experience on the full life cycle implementation of Procure to Pay cycle (P2P) and Order to Cash cycle (O2C).
• Generating SLA reporting and Customizing FSG Financial Reports and other non seeded reports, and other financial reports and analytics
• Well versed in Conversion, Allocation, Revaluation, Mapping, Consolidation, Recurring, Auto-Posting of journals, Reconciliations, Cash/Bank Reconciliations, Preparing Reconciliations Reports in GL
• Conducted requirement gathering analysis, documentation with help of Application Implementation Methodolgy (AIM).
• Identified product gaps, coordinated with Development Team by creating TAR/SRs tickets and obtained one-off fixes. Managed and monitored TARs for several Priority Issues.
• Participated in full life cycle projects in financial implementation and also as a post implementation support consultant.
• Extensively worked on development and customization of Oracle Reports.
• Conducted End user training, Support and prepared user guides for end users
• Queried SQL/PLSQL codes for testing and verification of data into the database and for other related investigations
• Successful in recognizing problems, troubleshooting solutions and reaching project goals on time.

QUALIFICATION:

• Master’s of Computer Application, India
• Bachelor of Advanced Accounting & Auditing with IT

SKILL SET:

• E-Business Suite : Oracle Ebs R12, 11i
• Domain Known : GL, AP, AR, PO, CE, FA, OM, I-Proc, I-Expense, O2C, P2P, Purchasing, Inventory
• GUI : Forms 6i, Reports 6i, OBIEE, IR Reports
• Tools : Oracle 11/10g, Toad, SQL* Plus, SQL Loader, Data Loader, Load Runner, ADI, SQL
• Languages : SQL, PL/SQL, .Net, C, C#, VB core, HTML, XML, Web forms, Reports, Web Servers
• Office Suite : Ms Word, Ms Excel, Ms Outlook, Ms PowerPoint, Ms Visio, Ms Project

PROJECTS:

Client : Confidential,( Philadelphia, PA)
Role : Oracle Financial functional Analyst
Duration : April 2011 Present

Confidential, Nation’s largest and fastest Internet, Cable and Voice service provider to the end consumers. It has more than 25000 centers across the country and having more than 50 custom, ClientServer and web applications running on different platform. Establish external Data Source Provider platform, gather supporting information from various third party vendors to provide innovative solutions and alternatives to company’s customers.

Responsibilities:

• Involved in Comcast’s Oracle EBS Implementations and it’s Initiatives and cutomizations 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 Upgarde
• 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, AppLoad, 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 testings 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 releases.
• Created Defects and forwarded to concerned developers and retested functionality
• Defined and Created and Tested Flexfield 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
• 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
• Created, submitted and Tested Different Purchase Requisitions, Catalog/Non-Catalog, Inventory, Expense, Capital, Professional Services and approved it using iProcurement and its Notifications
• Created and Tested Standard Purchase Orders and Approved it and Printed it. Created Automatic and Manual Purchase Orders and Blanket Purchase Agreements and Blanket Release for Procurement. Matched/ Quick Matched to Purchase Order Shipments/Distributions
• Generated Standard Receipts, Express Receipts through receiving against purchase orders, processed returns to suppliers

Client : Confidential, (Plainville, CT)
Role : Oracle Financial Functional Consultant
Duration : March 2010 Feb 2011
Environment : R12 General Ledger, Accounts Payable, Receivable, iExpense, iProcurment, Cash Management,
Fixed Assets

Confidential, makes hydraulic and magnetic circuit breakers, electric switches and assemblies, power distribution centers, digital switching systems and electronic control. The project consists ofOracle modules (General Ledger, Accounts Payable, I Expenses, Purchasing and I-procurement)
Responsibilities:

• Responsible for end to end implementation of Oracle R12 EBS Financial Modules General Ledger, Accounts Payable and Internet Expenses (I Exp)
• Carried out functional requirements gathering, requirements analysis, gap analysis, functional setups and customizations and testing
• Interacted with client team to understand the existing business practices and prepared the business requirement definition documents and designed business requirement definition document and Functional Specification documents for Business Apps
• Involved with study of existing system, preparing the BRD100/ Functional (MD50), Technical (MD70) design document and Conversion Data Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables and for implementation of GL, AP and I-Expense
• Defined Segment security for accounts and User access controls over segments and oracle responsibilities
• Involved in designing, setup and configuration of Organization structure with chart of accounts, calendar and currency, SLA
• Helped in Inventory module for costing problem. Inventory valuation report was not tying with General Ledger Inventory account. Cost group was the problem and physical inventory was not updating the quantity in the right cost group. Supporting users after going live on all financial modules.
• Used accounting setup manager for implementation Intercompany multi-organization framework on GL, AP
• Have done Setup for Consolidation, Conversion, Allocation In General Ledger
• Created MRC(Multi Currencies) having Multi Organization, Running FSG Reports and Sub-ledger Level reporting
• Customizing FSG Financial Reports as per clients requirements and Creating and Setup with SLA and Reporting and prepared financial reconciliation reports and tested using OBIEE IR tool
• Performed and scheduled month end activities/process on Journals, Posting, reporting, conversion and opening and closing periods across financial implemented modules
• Have setup Profile Options for Accounting Applications under General Ledger, Accounts Payable and I Expenses, Receivables and Cash Management for Implementation
• Have done I Expense Setups, Profile options for I expenses and setups for I Expenses Reports, Fixed Assets, Accounts Payable and Cash Management
• Have done setups and implemented for Credit card payment reimbursement on I expense
• Done setup to assign different authorities and defined Sign limits and supervisors for I expenses Approvals
• Customized I expense using Oracle Accounts Payable, Project, HRM, Work flow and System Administrator for implementation
• Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing for Accounts Payable.
• Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc for accounts payable
• Created and generated system test scripts for different test scenarios covering all aspects of project functionality.
• Handled functional and technical related issues by investigating and applying solution for specific problems.
• Conducted designing test automation strategies, Functional Acceptance testing (FAT), created test scenarios, test plans and performed inspection of test scripts.
• Interacted and worked with the development team to solve the problems encountered in the test scenario run.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules Involved in development of RICE components as per business requirement.
• Defined payment terms and recurring invoice templates. Set up employee expense template.
• Customized AR Aging Report to incorporate the “Offline Invoice Number” in the report. As the report has invoice number generated automatically. So this field is termed as ‘Reference Number’ for reconciliation issues.
• Designed and Developed and Conducted End User training & materials/ Quick User Guide
• Provided support to users during go live by way of problem solving and instructions.
• Used SQL, PL/SQL, SQL*Loader and Toad for generating required reports and customization of reports and Oracle Database

Client :Confidential, (Simsbury, CT)
Role : Oracle Financial Techno-Functional Consultant
Duration : July 2009 Feb 2010
Environment : General Ledger, Payables, Receivables, Cash Management, iExpense,

Confidential,makes high tech products like cable fillers, synthetic tapes, reactive armor and demolition products The Oracle modules involved are General Ledger, Accounts Receivable, I-Expense and Cash Management.

Responsibilities:

• Acted as liaison between client and development team for product development as per requirements.
• Authored AIM documents for accounts Receivable module including: BR100-Setup Document, CV60- Conversion document.
• Involved in Enhancement of custom objects to meet the business requirements and integrate them with Oracle Application.
• Participated in planning and set-up of accounting flexfield structure and chart of accounts.
• Planed, Setup and Implementation of Account Receivables, I Expense, Cash Management and General ledger.
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to functionality as per requirement.
• Developed cross-validation rules to restrict and determine departmental use of accounts.
• Involved in writing validations before importing the data into tables and then running the interface programs.
• Designed and Created Customers, Profile Classes & Bank information and General Ledger Accounts.
• Worked on Allocation, Revaluation and Conversion on GL
• Involved in month end processes for journals, SLA, Recurring and Reports with subsequent accounting
• Defining Application Rule Sets, Auto Accounting Rules.
• Have done I Expense Setups, Profile options for I expenses and setups for I Expenses Reports
• Assigned different authorities for submission of I Expense reports and defined Sign limits and supervisors for I expenses Approvals
• Customized I expense using Oracle Accounts Payable, Project, HRM, Work flow and System Administrator for implementation
• Configures ADI to download I expenses report in excel spread sheet for end users
• Applied setups for Credit card transactions processing system on I expense and tracking reports
• Involved in development and customization of reports.
• Developed comprehensive quality assurance documentation including test plan, test scenarios, and test scripts.
• Worked with Oracle Support to resolve application issues, bugs and TAR/SR management
• Defined testing methodologies, designed test plans and test cases, verified and validated the system and documentation based on standards for software development and effective QA implementationin all phases of Software Development Life Cycle (SDLC).
• Assisted client with final acceptance testing, and post implementation support issues for AR
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Develop Customized Supplier Interface to import customers from Legacy System and write validations for same and import in Oracle Base tables.
• Created Test Scripts (TE040’s) for UAT sessions.
• Develop Missing Mailer Expense Report based on combination of Cost center, Cost center description, UPN, Employee name, Email address, Expense Report Number, Submit Date, and Expense Amount using Oracle XML Publisher/OBIEE.
• Developing PL/SQL (Stored Procedure, Functions & Packages) implementing business logic.
• Responsible for writing of SQL queries as procedures/functions at the back end which are called from front end form.
• Registering Reports, PL/SQL Procedures, Packages and creating executables.
• Tested new enhancement (Regression Testing/ Functional Testing, Security Testing) and bug fixes before deployment into production environment.

Client : Confidential, (Aiken, SC)
Role : Oracle Functional Financial Consultant
Duration : June 2008 June 2009
Environment : General Ledger, Accounts Payable, Receivable and Cash Management, Order Management,

Confidential, is a world leader in high performance materials used in a broad range of markets, including Automotive, Construction, Defense, Electronics, Aerospace, Marine, and Recreation. The Oracle modules worked on are General Ledger, Order Management and Accounts Receivable.

Responsibilities:

• Participated in meetings with business heads to gather the required process flow and developing functional specifications.
• Conducted end-user meetings to review current business processes and requirement gathering.
• Prepare the documents for CV-20 for the data conversion and MD-50 and MD-70 for the functional design and technical design.
• Setup of Account Receivables, Account Payable, Payments and General ledger.
• Defined Period Types, Accounting Calendar, Special Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Creating Customers, Profile Classes & Bank information.
• Defining Application Rule Sets, Auto Accounting Rules.
• Completing Setup procedures in various environments such as Development, Production and Testing.
• Documentation for User’s reference related to Order Management and receivable interface issues.
• Providing support to users during go-live by way of problem solving and instructions.
• Develop Revenue Reconciliation Report for the revenues generated and transferred to General Ledger using Oracle XML Publisher/OBIEE.
• Defined Cost Types, Cost Groups, Materials, Resources, Overheads & Material Overhead cost copying cost across multi-organizations.
• Develop a Month End Sales Report which gives the detail information of Open order, back order, shipped orders and quantity in inventory using Oracle XML Publisher/OBIEE.
• Involved in RICE data conversion, developing, customizing report and interfaces.
• Registration of Concurrent programs and request sets in AOL and System Administration.
• Worked with technical team for the migration of legacy data like suppliers, merging suppliers, journals and open invoices and batches

Client : Confidential, (Omaha, Nebraska)
Role : Oracle Functional Consultant
Duration : Oct 2007 Apr 2008
Environment : 11.5.9, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets

Confidential, is one of the North America’s largest packaged food companies. Its products are supplied to various supermarkets and food service establishment. The modules worked on areAccounts Payable and Fixed Assets.

Responsibilities:

• Worked with the client team in understanding the business process and assisted the team lead in preparing the Business Requirement definition document.
• Performed on-site Requirement Analysis and developed functional specifications for the modules and customized processes.
• Migrated historical data for Accounts Payables, Accounts Receivables and Fixed Assets.
• Did set up and matching of invoices with the purchase order.
• Set up of transaction types, invoices, guarantees, deposit, and credit memos, debit memos.
• Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations.
• Defined Split payment terms for invoice installments that have different due dates and assigned multiple discounts to each payment line.
• Defined the Cash Discounts, which will calculate the discounts for the customers for early payments. They were manually adjusting the discounts for the customers previously and they are giving discounts to all customers.
• Creating value sets for report parameters and registering them in oracle application for validation of values entered.
• Designed and created reports for client using the Financial Statement Generator (FSG).
• Provided support to users during go-live by way of problem solving and instructions.
• Define depreciation methods for all assets in all books.
• Customization of AP Transaction Detail Report by adding voucher number field to it. This field is used in identification of PO’s. PO number are imaged and this image number is entered in the voucher number field of AP Invoice All table and then these PO number and their invoices are identified using these voucher numbers.
• Worked on setting up and customizing Invoice Approval Workflow that routes invoices to designated individuals for Approval.
• Involved in Invoice import from legacy system. The data was loaded into temporary tables from data files and loaded in Oracle tables along with some default values and with other values as per Oracle Set up. The process involves stored procedures