Summary

• Confidential is a Functional Lead and Solution Architect with 27 years significant experience on Financial and Supply Chain which includes 14 years IT as Functional Consultant and Systems Analyst with consulting organizations in Oracle EBS Consulting Services. Played Functional Lead, Solution Architect and Project Controller roles in ERP system implementation and Upgrade projects and shouldered great responsibilities in project deliverables in end to end implementations which includes Requirement Gathering, Current System Analysis, to - be Process and Solution design, Documentation (AIM), Change Management, Integration, System Testing and Production Support activates. He has great experience in preparing project plan, change request creation, Go-Live cutoff, obtaining business sign offs on requirements, UAT activates. Extend co-operation to counter parts in complete System Lifecycle Management process and PMO working on the projects.
• Confidential has 13 years good experience in Financial and Marketing domain worked as Senior Executive (Manager) in a Manufacturing, Food Processing and Service organizations.
• Confidential holds MBA (Master of Business Organization) certification besides holding Bachelors in Commerce and has instructed PGDCA certification review courses. He brings “Big Six” consulting experience where he specialized in Financial and Supply Chain Management business process re-engineering programs. His early professional experiences included GAAP, Financial Management, Marketing Management, Management Information System (MIS) reporting and analysis, P2P, Q2I (Quote to Invoice), O2C (Order to Cash), A2R (Acquire to Retire), R2R and Source to settle process designing, System Implementation and software development.
• Confidential is a certified financial professional and proficient in interacting with senior executives like CXOs, SVPs and Directors and providing high level and detailed solution design and eliciting requirements. Also proficient in project planning, change order process and assured project deliverables in a timely fashion.
• Confidential is a subject matter expect and contributed to many Oracle ERP implementation, upgrade and functional enhancement projects as functional lead with consulting teams reporting to him and as a contributing team member. Companies have included start-ups to Fortune 100 organizations that have global operations with multi Ledger and multi-currency operations. These interests have spanned high tech, Financial and Service oriented (Banking, Investment services, Telecommunications, Airport Authorities), Manufacturing and Food Processing and retail industries. He is proficient in interfacing with senior executives like CFO, Director Finance, and VP in eliciting requirements and process design.
• Expertise in Financial Analytics, Begets, Variance Analysis, Cash Flow Analysis, Forecasting and Projected Profit and Loss analysis, Debt and Equity coverage analysis. Provided design and created reports for various MIS reports in Financial and Cost Analysis, Budgeting and Variance analysis and Accrual Analysis through Oracle EBS reporting tools such as OBIEE and FSG.
• He has extensive experience with project life cycle management, business fit assessments, creative problem solving strategies, software extension and EBS and third party system integrations, classroom instruction and business development. He is experienced with Oracle Application versions dating back to the late 1990s with emphasis on the business process flows surrounding core financials and SCM applications. Confidential is experienced with Oracle Business Flows, Reporting and AIM Methodologies.

TECHNICAL SKILLS

• SME in Oracle EBS Financial R12, R 10.7, 11i (11.5.4, 11.5.7, 11.5.9, 11.5.10 and 11.5.10.1).
• Oracle Financials (GL, AP, AR, FA, CM, Grants, i-Expense, i-Receivables, i-Payments and Advance Collections)
• Oracle Supply Chain (PO, OM, INV, Advanced Pricing, Cost Management, i-Supplier, i-Procurement)
• Oracle Project Accounting (Project Costing, Project Billing).
• Oracle HRMS
• Oracle CRM (Foundation, Install Base, Depot Repair, Contracts, Service Spares Management, Customer Support, Quotes, Depot Repair, Field Service, TCA)
• Oracle Report Manager, FSG, OBIEE, Web ADI and Data Loader
• Oracle Business Flows, Accelerators, UPK, AIM Methodology
• MS Office Word, Excel, Projects, Power Point and Visio and AIMs methodology.
• Business System Design, Process Improvement and Change Process Management etc.
• Financial Analysis, Analytics, Begets, Variance Analysis, Cash Flow Analysis, Forecasting and Projected Profit and Loss analysis, Debt and Equity coverage analysis and Cost Analysis etc.
• Merge and Acquisition process.
• Proficient in Project Management, Resource and Project Planning and Change Orders.
• Knowledge on RDBMS Oracle 9i/8i, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i
• Knowledge in Operating Systems (Linux, Sun Solaris 2.8 and Windows.

FUNCTIONAL EXPERIENCE:

• Subject Matter Expert (SME) with significant functional experience including Requirements Gathering and analysis, Requirement mapping, process design and system setup activities in implementation of General Ledger, Payable, Receivable, Fixed Assets, Cash Management, Inventory and Purchase, With Chart Of Accounts (COA), MRC, Global Consolidation and Global Intercompany System setups in global Multi-Org environment in a single instance, which consist all aspects of software Development Life Cycle and Production troubleshooting of Oracle Financials implementation. I have good experience in GAAP analysis, developing business requirement and Business scenarios, Unit testing, System integrity tests and user acceptance test. I am self-motivated and well versed with organizing workshops, functional process designing and documentation.
• Comfort Level in CRM Foundation, Service-Contracts (SC), Field Service, Install Base (IB) and Depot Repair in service module. Good experience in Quote to Order and invoicing process for service contracts in contract billing process.
• I have experience in Sub Ledger Accounting (SLA) and EBS Tax configuration to meet the business requirements., Knowledge in Accounting Method Builder (AMB)
• I have worked as senior executive with good experience in generally Accepted Accounting Principles with knowledge in Sales Taxes such as Location Base Tax and VAT Tax. I also have hands on Withholding Tax and Assets tax reporting.
• Expertise in RICE object process designing, documentation and configuring setups in Oracle (EBS) AP, FA and AR systems and Oracle EBS systems integrate with various legacy systems like ADP, Barcode, Vertex Tax and other third party Systems.
• Expertise in Data Conversions such as Customer Master, Supplier Master, Asset Data, AP Open Invoices and AR Open Invoices and receipts.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Functional Consultant,

Responsibilities:

• Involved in requirements gathering for projects system implementation for USCG and Change Request (CR) RICE objects requirement gathering and documented the content requirements.
• Reviewed the current projects system process and Statement of Objects (SOO) in regards to CRs.
• Provided to be process and created functional design documents for RICE objects in Project Systems implementation. The RICE items include the following.
• CANAPS, CPS and Direct Access Interfaces
• Auto-Create Project Budget, Project Budget Mass Load and Project and Task Mass Load extensions
• OBIEE reports for reconciliation.
• Projects System has been configured for TSA and USCG to meet the consent requirements.
• The project budget interface design is most challenging in the project where the standard functionality does not support the business requirements.
• Created the test scripts for creating and managing the project and project budget and end to end process of project costing and project billing.
• Supported various test cycles and end user testing (UAT).

Environment: Oracle R12 Federal Finance, GL, AP, AR, FA, CM, PO, CLM, INV, iProcurement, Projects, Federal HRMS systems.

Confidential

Oracle Financial Business Process Architect,

Responsibilities:

• Process design has been provided to integrate Oracle EBS systems with third party system using BEPL for data file process and calling interface to execute several extensions to create Project Task, Agreement, Baseline the Funding for indirect and contract projects and creating Purchase Requisition, Purchase Orders.
• The solution includes several custom RICE objects design to meet the business requirements in Oracle Projects System integration with DSAM system.
• The design also includes the error handling process and components such as error correction web page etc., to meet the needs in interface error handling.
• A process has been designed for Refund Receipt for negative billing transaction created from Oracle Projects Billing into AR.
• Provided Functional Design Documentation, Test Scenarios and Test Scripts for above stated processes

Confidential, Winston-Salem, NC

Responsibilities:

• Worked with the business and identified the issues in period close and reconciliation of Inventory, Cost Management and OPM sub-ledger transaction with GL.
• The custom SLA has been reviewed to account derivation for Inventory, Cost Management and OPM sub-ledger transactions to meet the business needs in accounting and reconciliation.
• Period Cole and Reconciliation procedures provided.
• Accounting reconciliation have done in Cost Management, OPM, OM, Purchase and Financial modules and provide the best practice in reconciliation process.
• Recommended reports in various modules to be used in reconciliation process.
• Identified and fixed the issues in Inventory, OPM Financials and Discrete Manufacturing closing.

Confidential

Senior Principal Consultant

Responsibilities:

• I have played significant roles such as functional lead, Solution Architect, QA and Project Controller roles in various EBS implementation, Upgrade and Functional enhancement projects with Confidential on Financials, Supply Chain and EBTax systems. I have successful completed the following challenging projects at respective clients for confidenti.
• Client: Confidential, CA - It was iProcurement system global implementation. I have played Solution Architect with QA and project control in Oracle iProcurement system global rollout for 49 Operating Unites in various countries by replacing a third party system named VeriWeb. My responsibilities include solution design to implement iProcurement system for global business needs in Purchase Requisition Creation and Approval process through e-purchasing.
• Current Financial and Purchase systems were analyzed and identified the need of implementing iProcurement system at Operating Unit level based on legal entities and organization structure.
• Provide design to implement Oracle iProcurement system at Operating Unit level Based on existing financial and purchasing system process and business needs.
• Reviewed the current Purchase Requisition approval process and recommended changes to fix major WF issues in current system used for USA Operations and to improve efficiency and automate the PR approval process in global environment.
• Provided design to default local code in GL expense account code combination to meet the business needs with regards to few operating units Asian and other countries.
• Provided a design replacing third party Expense Item setup process used for PR creation in global rollout to meet the various countries business needs.
• Testing strategy has been provided and created test scenarios and test scripts with test matrix and scorecard to for various types of testing in global rollout project.
• Completed system testing and UAT for 27 operating units rollout in 1st phase of iProcurement system global rollout.

Environment: Oracle EBS GL, AP, AR, FA, CM, PO, INV, iProcurement, HRMS systems.

Confidential, Boston, MA

Finance Functional Team Lead.

Responsibilities:

• End to end system test to meet the business and current system process such as Quote to Order, Order to Cash which includes IB and Service Contract functionality.
• End to end system test to meet the current process like Supplier/Vender Management, Purchase Order Process, Supplier/Vendor Invoice and Payment process, Customer Management, Quote and Tax application process, Order Creation and Ship Confirmation process, Service Contract creation and extension process, Tracking Install Bases and AR invoice creation and receipt application process.
• System integration test to meet the current process in third party systems and Oracle Systems used in various processes in global environment for various countries.
• Provide support on various test cycles and fixed the issues. Faced challenges in in third part system integration and custom objects testing and fixed the issues.

Environment: Oracle Apps EBS 11i GL, AP, AR, FA, CM, PO, INV, iProcurement, HRMS, BOM, Advance Pricing, OM, Advance Collections and CRM modules Quote, Service Contracts, Install Base, Depot Repair systems.

Confidential, FL

R12 Finance Functional Team Lead.

Responsibilities:

• Implementation includes GL, AR, FA, AP, CM and EBS Access Controls in Multi Org environment.
• Chart of Accounts change from 5 Segment to 8 Segments which includes one to one, one to many and many to one segment values mapping.
• Captured the business requirements and performed fit and GAP analyses in requirements mapping.
• Functional design has been provided and configured GL system to incorporating the business requirements such Period Closing and financial reporting at each legal entity and line of business with in a group.
• Implemented multi ledgers in R12 to meet the business needs.
• Implemented CVRs, Rollups, Security Rules, Intercompany Accounting and Budgets considering the new segment mappings of R12 COA structure.
• Migrated 6 Years of historical GL data specific to business line in to R12
• Created Web ADI templates for Actual and Budget Journal upload in GL.
• Created FSG reports with new R12 segment value mappings.
• Configured AR to meet automated business process in R12 considering the COA structure changes.
• Analyzed and migrated 150 CEMLI objects used in various automated process in AR. Reviewed and migrated millions of custom table data incorporating the changes in R12 COA Structure and HR Organization and Locations.
• Implemented Revenue and Expense tracking by LOB, Location and Department for reporting needs.
• Enhanced cash application at transaction line level functionality to meet the auto application of cash receipt at transaction line process through customization.
• Migrated one year of high volume of historical data and Open transactions into R12
• Implemented FA to track the assets pertains to specific business line.
• Enhanced functionality to auto populate asset account segment values based on Employee assignments.
• FA system has been configured to meet the requirements specific to various business lines such as Implemented Book level securities to restrict the access to FA books, Asset Categories and Prorate Convention Calendars to meet the business depreciation needs with regards to fixed assets.
• Migrated active assets and current year retired assets for historical data needs into R12 with a strategy to merge various from OUs assets in to one in OU merger process.
• Data Migration strategy design for open and historical transaction and master data in GL, AP and AR modules and Custom application tables.
• Followed AIM documentation for deliverable like BR020, BR030, BR100, CV010, MD050 and TE040 etc.

Environment: Oracle Apps EBS R12 GL, AP, AR, FA, PO, INV, iExpense, HRMS and Payroll systems.

Confidential, Rockville, MD.

Senior Finance Functional Consultant

Responsibilities:

• Provided production support in financial modules (GL, AR, FA, AP, FA and PO) as well as design and implementation of functional enhancements for financial modules in R12.1.2.
• Provided functional design to upload the D&B data for customer in Account Receivables.
• Identified root cause in receipt application issue in customer account merge and provided alternative workaround and work with Oracle support fix the bug.
• The standard Aging Report has been analyzed to identify the issue in customer balances issues.
• Provided the solution in default payment method for supplier payment in Account Payables.
• Attended resolved footprint tickets of P1, P2, and P3 categories in regular production support and period end close.
• Involved in review of BR-100 documents of Oracle Financial Systems for India Operating Unit.
• Assisted in Cross Validation rules to incorporate new cost centers proposed for Indian operations.

Environment: Oracle Apps EBS R12.1.2 GL, Grants, AP, PO, FA, CM, INV, OM Credit Management and iStore modules.

Confidential

Principal Consultant.

I have played great roles such as functional lead, Solution Architect, and Project Controller roles in various EBS implementation, Upgrade and Functional enhancement and system integration projects with Confidential . I have successful completed the following challenging projects with Confidential which were discussed in detail in this resume.

Confidential, Arlington, VA

R12 - S2S Functional Lead.

Responsibilities:

• Responsible for enhancements, design and development as well as production support for financial modules (GL, AR, FA, AP and CM) in a Multi Org and global environment for 11i to R12 upgrade. I have played functional lead role in Source to Settle (Procure to Pay) system Implementation.
• Involved in requirements review, requirements mapping and gap amylases, functional documents review and confirmation, Test scripts preparation and system testing in Source To Settle (P2P) Purchase and iProcurement systems implementation.
• Implemented requisition approval process using AME rules based on Dollar amount and purchase categories.
• Defined and implemented Contingent Worker requisition process in P2P.
• Configured system to process Purchase Order in cXML format to P-Card vendors, restricted PO approval process to 2 levels, customized Ship-To location and PO Charge account generation.
• Provided test scripts for various functional scenarios in end to end system testing, purchase requisition approval rules and functional extensions.
• Defined Purchase Requisition and PO data conversation strategy
• Stores are configured for catalog items in iProcurement to meet the business needs in P2P process.
• Provided process to upload Supplier catalog items into iProcurement.
• Implemented Punch-out process in iProcurement.
• Approval process designed to include cost threshold of $5000 for technology items relates to projects.
• Provided pre and post go-live support in Purchase, iProcurement, OTL systems implementation.
• Extensively worked on MIS reports design and testing of OBIEE report in Source To Settle. About 55 reports were designed and developed to display the data in detail and summary.
• Provided solution on post go-live issue such as P-CARD supplier process for Non-Catalog requisitions and auto close of 2-Way match POs and PO cXML process issues for Non-Catalog requisitions.
• Provided functional design for development of generic AR Customer and Invoice interface to integrate AR with various third party source systems used in ETRADE.
• Tested the AP invoice process through IMP (ODI)
• Designed customer statement generation process in XML, configured AR to meet the requirement.
• Configured AR system for auto receipt process.
• Provided functional design document for development of AR Invoice and Credit Memo printing process.
• Provided functional design and system process to print the customer statements in Oracle AR.
• Provide functional document for Geographical data extraction from Oracle EBS system to update in the third party system.
• Configured VAT Tax for UK in EBSTax.
• Provided functional document for Payroll journal interface integrating third part system with Oracle GL for Philippines operations.
• Provided solution and support in changing in to Ledgers (R12) such as primary, secondary and consolidated ledgers used for global operations with Multi Currency in multi Org system for management reporting purposes.
• Created the Cross Validation Rules to meet the business rules. Analyzed the current cross validation rules and provided solution in regards to the account code combinations which are violating the CV Rules in GL.
• The Global Intercompany fund transfer process has been designed and AGIS System has been configured to meet the business requirements in fund transfer process between global operating units.
• The AGIS transactions include IC Trade Payments, IC Trade Receipts, IC Receivable Transactions, IC Long Term Receivables, IC Payable Transactions and IC Long Term Payments.
• Provide functional design and procedures for assets auto retirement process in Corporate and various Tax Books in Oracle FA system implemented in the countries such as US, UK, HK and Philippines etc. The custom programs have been designed to meet the business requirements.
• The three custom Balance Roll Forward reports which are developed to review/reconcile the FA balances with GL in FA are improved meet the business needs.
• Created and tested Web ADI templates for Single Currency, Multi Currency and Multi Ledger Journal Entry upload process in Oracle GL as per business requirements.
• Created and tested web ADI templates for Asset Additions in Oracle FA.
• SLA has been updated to stop posting in in secondary ledger to meet the business needs.
• System and integration testing have been performed to meet the business requirement in regards to above development objects and functional enhancements.
• Provided process for Multiyear Invoice and revenue recognition process and configured the AR system to meet the requirements.
• Provided production support and fixed the issues in FSG report and Cross Validation Rule definition in GL and improved and fixed the bugs in custom reports in Fixed Assets.
• Provided support in period closing issues in financial modules.
• Open POs migration from third party system Ariba to Oracle Purchasing.
• Involved system upgrade through patch application process and system testing.
• Interacted with the business and took the business requirements for above functional enhancements and documented and provided functional and test documentation such as MD 50, TE 40 and UPK test scripts.

Extensively worked with UPK tool and created test scripts for above functional enhancement and negative test scripts for user testing in GL, FA, AP and AR modules.

Environment: Oracle Apps EBS R12.1.1 GL, AP, AR, FA, CM, PA Contracts, IPM, HRMS and iRecrutment.

Confidential, DC

R12 - Access Control and Cross Modules Activity Lead.

Responsibilities:

• Extensively worked on Grants/Projects Implementation on Grants and Project Configuration and Projects Data Conversion and provided support on Purchase Order and Asset Data conversion issues.
• Created training material for Awards and Projects/Tasks creation and Fund Management in Grants module.
• Implemented Grants functionality like Creating Award, Coping Award, Updating Existing Award, Funding to Projects, Create Award Budgets, Reviewing and Approving Award Budgets, Adjusting Award Amounts, Managing Award Compliance and Fund Check and Processing Grants OBIEE Reports.
• Review of test scripts and training material pertaining to Purchase, iProcurement and Sourcing and confirmed the end to end process in P2P.
• Review of SLA to meet the requirements in encumbrances for purchase.
• Created Custom Menus and Request Groups to create new roles and responsibilities based on the user access as per the requirements in FA, Purchase, iProcurement, GL and OBIEE.
• GL Security rules have been configured and Assigned to Roles and Responsibilities to meet the business needs with regards to user access.
• Involved in implementation of Advanced Collections system for effective customer credit management setting the collectors and dunning programs.
• Involved OM and WMS system configuration, Bar Code system integration process design and integration through MSC. Provided support on system testing of various test cycles in system implementation.
• Implemented security for Inventory Organization (DCA/IAD) access to Purchase Roles and Responsibilities.
• System access control matrix created and implemented functional access controls configuring Function, Menu, and Request Group and Responsibilities across all the modules used in various process like P2P, O2C, A2R, R2R.

Environment: Oracle Apps EBS R12.1.1 GL, Grants, AP, PO, AR, iReceivables, Advance Collections, FA, CM, iProcurement, iSupplier, iSourcing, INV, OM, MSC and WMS modules.

Confidential, Reston, VA:

Played Finance Lead and Solution Architect role and responsibilities includes business process designing and functionality enhancements in AP and implemented ACH payment process with Oracle ERP and Bank System integration which includes system configuration, EFT file formatting, System testing to meet the business needs in ACH payment file process.

Confidential, NJ

Functional lead and Solution Architect with great responsibilities which includes process designing, configuration and integration of Oracle ERP systems AP and AR with ADP and PayPal systems respectively to meet the business needs with regards to Employee Expense Reports Payments and Customer Credit Card process.

The Oracle iPayments (Payments Gateway) systems have been implemented to meet the Credit Card authorization and funds capturing process with regards to customer payments.

• Process has been designed to meet the business needs in Credit Card (P-Card) process starting from Order entry, Ship Confirm and Auto Receipt.
• Implemented Credit Card integration with Order Entry process in OM and fund capturing through automated receipt process using iPayment gateway.

Environment: Oracle Apps EBS 11.5.10.2 Financial, Supply Chain and CRM (GL, AP, AR, OM, PO, INV, FA, CM, iExpense, iPayments CRM Service Contracts, Deport Repair, Sales Force) modules with Read hat Linux.

Confidential, DC

R12 - A2R Cycle Implementation Functional Lead.

Responsibilities:

• Designed FA system to meet requirements including acquire to retire process and integrated various systems in Oracle R12 to meet federal asset accounting.
• Interacted with FALs & TALs in designing and decision making process for key flex fields in fixed assets, asset data conversion strategy and data mapping from source system to target system
• Designed end to end assets creating process to meet acquire to retire process (PR-PO-AP-FA) which includes P2P process for asset acquisition in Oracle
• Process integrating iProcurement, and Purchase and Payments systems with Fixed Assets system.
• Designed process for asset tracking and physical Inventory taking for fixed assets. Configured the Fixed Assets and Inventory modules to meet the requirements in Asset tracking process where asset items are moved between the Internal Organizations, Projects and sub-inventories.
• Provided the functional design to capitalize the project cost to create assets in FA through setting up projects in Oracle Grants.
• Configured FA to meet requirements such as Capitalized, Non-Capitalized for Real, Personal and Sensitive property assets with capitalization threshold in federal financial accounting process.
• Setup system to track the fixed assets purchased specific to projects through Oracle Grants and accounted on fund base in Oracle General Ledger to meet federal norms.
• Configured Excess Assets, Lost and Found items and fully reserved assets in Oracle Fixed Assets
• Customized Accounting Generator workflow to meet Federal accounting requirements.
• Updated the Accounting Definitions to meet business needs using SLA.
• System has tested to meet the business functionality and integrity.
• Prepared and provided Business process mapping document and system configuration documents (BR-100) to meet functional requirements in asset management lifecycle.
• Key flex field conversion cross walk and asset data conversion documentation review has been done with FALs and TALs successfully.
• Provided fixed assets system demo on acquired to retire in Oracle Fixed Assets system integrity and capability test with the user which meets the requirements.
• Prepared functional specification (CV-40) documents for RICE object such as conversion cross walk of three Key Flexfield (Category Flexfield, Location Flexfield and Asset Key), Assets Data Migration strategy and Conversion from three legacy systems, and MD-50 for custom reports to extract excess assets static. Also provided functional specification (MD-50) documents for Inbound and Outbound Interface between Oracle Fixed Assets and Barcode system.

Environment: Oracle Apps EBS R12.1.1 GL, Grants, AP, PO, AR, iReceivables, Advance Collections, FA, CM, iProcurement, iSupplier, iSourcing, INV, OM, MSC and WMS modules.

Confidential

Systems Analyst and Solution Architect

I have played significant roles such as functional lead and Solution Architect roles in various EBS implementation, Upgrade and Functional enhancement projects with Confidential . I have successful completed the following challenging projects at respective clients.

Confidential, CA

Senior Financial Functional Lead,

CMA is a private Providence Hospital. Responsibilities included implementations of Budges and Financial Reports design and configuration in GL and functional enhancement in AP such as 1099 reporting and period and closing and supported day to day production issues. The implementation activity includes gathering requirements, configuring and system testing, documentation, and user training.

• Provided period end closing process for AP and GL. Resolved period end closing issues.
• Designed process in Payables for 1099 reporting and configured Payables accordingly
• Provided production support on GL and AP and resolved period end process issues.

Environment: Oracle Apps EBS GL, AP, PO, and Payroll modules of 11i (11.5.10) version and FSG, Web ADI and ADI tools.

Confidential, Cleveland, OH

Senior Financial Functional Lead

• Project Lead role for Oracle system upgrade process form 11i to R12 in GL, AP, AR, PO, and CE
• Completed system setup audit to ensure setups in R12 meet requirements for GL, AP, AR, PO, CE.
• Review the R12 setups with the CFO, Manager and users of respective modules/systems and updated the setup as per requirements.
• Reviewed new functionality like Sub Ledger Accounting (SAL) and functionality changes in various modules with CFO, Super users and Users of various business areas.
• Carried out system integration and regression testing to meet various functional scenarios.
• Tested Purchase to Pay with matching and payment batch process in payables system.
• Tested invoice to cash process applying manual and Auto Lockbox receipts, and revenue reorganization in Receivables. Configured location based and VAT tax setups in R12 EBS Tax to meet the requirement.
• Tested Cash Management system for bank file reconciliation process.
• Developed training documentation for various functional scenarios using UPK tool and user training has been provided new system.

Environment: Oracle Apps EBS GL, AP, AR, PO, and CM modules in 11i (11.5.10) version have been upgraded to new system R12. Data Base 10G, FSG, Web ADI and ADI tools.

Confidential, Reston, VA

Senior Financial Functional Lead,

Responsibilities:

• Responsibilities included requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
• Designed system to capture various costs against the different types of projects, and customized Project Billing process such as fixed billing and Cost + margin for project billing process.
• Defined Multi Org Access Control (MOAC) sets for global security in Oracle shared services control.
• Configured Project Costing and Project Billing systems to meet requirements, setup project access controls based on user roles and responsibilities, integrated projects with PO, AP, and AR to track the cost incurred towards the projects for billing.
• Provided system process for bundling and period end closing
• Configured payable process to meet the requirements such as batch invoices, batch payments, employee expense report process, withholding tax, 1099 reporting, cross currency invoices and payments.
• Designed process to associate project, task and expenditure on PO and Invoice Entry
• Reviewed the current reconciliation process in Cash Management and configured to encompass Auto reconciliation of bank statements, Journal entry creation and reconciliation of Sweep and ZBA transactions, and Cash Forecasting.
• Configured setups for Web ADI to upload Journal entries and trained users
• Integrated Cash Management with Payables, Receivables and Treasury modules for reconciliation.
• Reviewed current business process and documented procedures for Purchase to Pay and Project Invoicing to Cash Receipts.
• Extensively worked on configuration of R12 EBS Tax to meet the requirements such as Location base Tax and VAT for various countries.
• Developed deliverable documentation like MD-50, CV-60, BR-20 and BR-100 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test script in AIM methodology as part of project implementation task.

Environment: Oracle Apps EBS R12 GL, AP, AR, PO, FA, CM, PA, iProcurement, iExpense, HRMS, OTL, TOAD, Discovers Web ADI,, ADI.

Confidential, Houston, TX

Senior Financial Functional Consultant - Support

• Provided production support on core financial modules GL, AP, AR, FA, CM and PO modules and on Web ADI. Attended service dusk tickets on Production issues resolved the issues under P1, P2, and P3 categories.
• Resolved user training and change request issues, reviewed the financial patch level, provided recommendations
• Resolved process issues, period end closing and interface issues in GL, AP, AR, FA, CM and PO modules.
• Developed functional specs and custom report to review payment batch details using Discoverer.

Environment: Oracle Apps EBS R12 GL, AP, AR, PO, FA, CM, Web ADI, TOAD.

Confidential, Albany, NY

Senior Financial Functional Lead

Responsibilities:

• Conducted preliminary study on current asset creation process and system (Access Database).
• Organized interaction with Users, Accounting and Auditing for requirements gathering, current system analysis and solution designing.
• Provided As-is and To-be process documentation
• Completed functional and technical evaluations in current inventory control and defined the requirements for Oracle FA. Reviewed Oracle FA capabilities with users to meet requirements.
• Developed several business processes in solution designing to meet the following business needs.
• NYSIF policy has to create an asset which cost is beyond $50,000 and less then said amount shall be expensed and the asset information should be tracked in Physical inventor.
• Current system does not track the asset financial information and Auditors recommended implementing integrated Oracle FA system to meet the audit requirement in regards to asset financial as well as physical inventory information.
• Asset items purchase process should be tracked from requisition level to create an asset in fixed assets and should default the Financial and deprecation information. It should meet Purchase to Pay and Asset acquire to Retire process.
• Secure effective management of assets between the equipment managers in districts and area offices. Period end process in the new system.
• Assets physical inventor stock taking process. Process for print Bar Code Labels for fixed assets labeling for accuracy and time saving in asset identification and stock taking for audit purpose.
• Depreciation for various asset categories defined as per GAAP recommended by audit section.
• Designed & configured FA to meet federal and state government requirements. Designed and defined Key Flex Field structures, Asset Categories, Corporate Books, Fiscal and Prorate calendars, System Options, Depreciation Methods.
• Configured setups in INV, PO, and AP for Purchase Requisition to create asset process.
• Performed QA testing consisting of system integration and functional tests.
• Developed migration strategy to convert the asset data from current system (Access Database) in to Oracle Fixed Assets using ADI, ensuring financial data validation.
• Developed (AIM) documentation for Requirements, As is and To be process, GAP analysis, setup document BR-100 and RICE document (MD-50, CV-60) for data conversion and custom reports.
• Provided user training and developed Test Scripts
• Led CRP, UAT, resolved issues, and provided post production support. Provided user training on enhancements

Environment: Oracle Apps EBS 11.5.10.2 GL, AP, AR, PO, FA, CM, iExpenses, iProcurement, TOAD, ADI.

Confidential, CA

Oracle Applications On-Site Project Manager

• Led FA implementation
• Performed current system study, requirements gathering, designed business process to meet the requirements. Organized workshops and interacted with client business team to define strategy.
• Designed and configured the Fixed Assets to meet the following requirements.
• Effective asset management in corporate Books and for Federal and State tax reporting purpose.
• Two separate corporate books for US and Canada to track the asset information separately at each operating unit level.
• Report the asset information in CAD currency where the GL used with USD at Canada operating unit. Proposed and designed Multi Reporting Currency setup to report in CAD currency.
• Configured book level security
• Created asset data conversion process to migrate data in the middle of fiscal year in to Corporate Books.
• Designed and defined key flex field stricter for asset categories, locations and asset key for effective asset management
• Configured setups in INV, PO, AP and FA, including purchase to asset creation process.
• Configured FA for USA and Canada operating units and defined tax books for USA.
• Designed conversion strategy to migrate asset data from third party (FAS) system into Oracle system for US and Canada operating units using ADI.
• Performed unit testing, system integration testing various functional scenarios in FA, PO, AP, and GL systems to meet the business requirements.
• Provided user training and carried out CRP and UAT testing and issue resolution
• Asset data migration data strategy and provided design to convert data from third party system to Oracle EBS.
• Developed and delivered documentation for requirement gathering, requirement mapping, High level business process design, GAP, System Setups, test scripts and project plan to meet SOX audit standards. Developed RICE documentation for Data conversion and custom reports.

Environment: Oracle Apps EBS 11.5.10 GL, AP, AR, PO, INV, FA, CM, OM, HRMS, TOAD, ADI, Read hat Linux.

Confidential, TX

Financial Functional Consultant

• Lead Role for the development of Financial and management reports through FSG in GL module implementation. Extensively worked on FSG report builder and created 300 reports to meet the requirement.
• Analyzed the current financial reports in Lawson system and Oracle GL accounting structure and set of books used at different divisions and consolidation. Created generic Income statement and Balance Sheet for financial reporting purpose, which can be run various set of books level.
• Created several types of Variance analysis reports like rolling months, PTD, QTD and YTD variances. Also created division wise periodic P & L variance reports.
• Enabled and defined security rules at balancing segment to restrict the data access.
• Configured setups to print FSG report through XML publisher.
• Designed a process for Financial Consolidation process through Financial Consolidation Hub and configured Enterprise Performance Foundation system to meet the requirements in Financial Consolidation Hub at various regions. Provided role based security.

Environment: Oracle Apps EBS 11.5.10 GL, AP, AR, PO, INV, FA, CM, HRMS, TOAD, ADI, Read hat Linux.

Confidential, FL

Financial Functional Lead

• Led the implementation of GL, AP, AR, FA, P2P and Cash Management and iExpense in 11.5.10.2.
• Conducted study on current business and system process, gathered requirements, created business process design.
• Setup GL, AP, AR, FA, Cash Management and iExpense modules in 11i
• Designed new COA structure, Enter budgets and controls, Multi Reporting Currency (MRC) setup for Canada Operating unit, FSG reports for financial statements like Profit and Loss, Balance Sheet and various reports, Period end process and reconciliation and GL balance conversion and migration from Oracle (10.7) to 11i (11.5.10.2)
• Extensively worked on AR and configured setups. The requirements included Auto invoice process design for service contracts, Revenue reorganization process for service contracts, auto accounting rules should meet service contracts and Manual invoices, Consolidated Billing and printing, Auto lockbox Receipts Application to transactions, invoice printing with remit to address. Statement generation and dunning letters for effective monitoring of collections. Vertex Tax system integration with Oracle 11i to update the location base tax rates. Customer profiles to manage customer credit, Customer master data conversion considering customer relations, customer contacts and customer profiles, and AR open invoice conversion etc. Adjustments approval limits for different reason codes. Revenue recognition process for service contracts has been designed and setups are configured in AR to meet the requirement of AMC.
• Set up payments system configuration to meet multi-currency invoices, cross currency payments, Batch invoices, Batch payments, Employee Expense report process, Electronic Fund Transfer & manual check payments.
• Integrated CE with AP, AR and Treasury modules to meet auto reconciliation and Cash Forecasting
• Developed Functional specs for Ad-hoc reports and created custom reports through Discoverer to identify the bank statement lines required to create journal entries
• Configured FA with two corporate books for United States and Canada for effective asset management under various asset categories.
• Configured iExpense for for approval process, and invoice creation in payables. Employee expense reports approval process were designed on supervisor and cost center basis Designed and defined Credit Card process, Vacation rules, expenses policies and receipt limits for expense reports.
• System integration and testing for OKS (Service Contracts), OE (OM), AR, AP, and iExpense
• Designed Data conversion and migration strategy for conversion of Customer Master, Open Invoice and Service Contracts.
• Developed and delivered documentation like MD- 50, CV- 60, BR-20, BR-100 and TE- 40.

Environment: Oracle Apps EBS 11.5.10.2 (GL, AP, AR, OM, PO, INV, FA, CM, CRM Service Contracts), TOAD, Read hat Linux

Confidential, PA

Functional Consultant

• Implementation of Accounts Receivable for 27 operating units in global environment on Oracle EBS 11.5.10 version.
• Business requirement analysis, developed setup documentation (BR-100), System configuration and system audit
• AR system configured to meet the requirements like service oriented revenue recognition and periodical generation, region vide (VAT) taxes have been implemented for various countries. Auto invoice process has been designed and auto accounting rules have been setup for project billing and manual invoice process.
• Interacted with users and documented the changes and coordinated with offshore team to configure and test the system to the meet the required functionality.
• Developed and provided RICE documentation like MD-50, CV-60 documents towards custom reports, conversion and interfaces like in born and out born interfaces for update of customer data between legacy and Oracle system.
• Performed functional test and provided functional test scripts.

Confidential, TX

AR Lead

• Led the Implementation of Accounts Receivable module for USA and Canada Operating Units.
• Configured transaction flex field structure (descriptive flex field) and remit to territories & locations, transaction types & sources, quick codes, defined grouping and Line ordering rules for Auto invoice, Auto accounting rules, Receipt classes and Source, customer profiles, Payment terms, Internal Banks, lockbox, Transmission Formats, system options and Tax Codes, Receivable activates and Profile Options to meet the business requirement
• Developed strategy for data conversions, interfaces and custom reports. Developed RICE documentation for customer master data and open invoice conversion.
• Inbound and Out bound interface for customer master update between legacy and Oracle system. Scheduled the interface programs for customer, auto invoice, and lockbox process through Standard Request Submission.
• Prepared and provided the functional specks like BR - 100, MD - 50, MD - 70 and TE - 40.
• Post go-live production support was provided to resolve the issues.

Environment: Oracle Apps 11.5.4 (GL, AP, AR, PO, FA and CM), PL/SQL, Forms & Reports 6i, Solaris 2.6.

Confidential, WA

Financial Functional Lead

Responsibilities:

• Conducted study on current business process and designed future state functional requirements in GL, AP, FA, GIS and Cash Management. Designed payment batch process for EFT process and tested.
• Migrated custom reports and Interfaces in to new system. Customized Check Print format for payments and Withholding tax certificate report for suppliers as per the requirement. Configured VAT Tax codes, Tax groups and tax authorities for Europe and Asian operating units. System audit has been done and confirmed setups.
• Performed system integrity and functionality test by running the test scripts for various scenarios in General Ledger, Account Payables, Fixed Assets, Cash Management and Global Intercompany System to meet the desired business process.
• Configured setups for Global Inter Company system (GIS) and tested the system by initiating transactions and approving the Intercompany fund transfer at receiver’s end.
• Designed process for Financial Consolidation Hub and configured setups in Enterprise Performance Foundation to meet the requirements in Financial Consolidation Hub to synchronize the data from various ledgers for consolidation. It comprises Ledger assignments, Balancing rules, dimension rules, hierarchy rules enabled with role based security.
• Carried out CRP and UAT, trained the end users in major changes in version 11.5.10 and resolved the issues during UAT, provided post production support.
• Developed MD- 50s for custom reports and documented Test Scripts for user training.

Environment: Oracle Apps 11.5.10 (GL, AP, AR, OM, PO, INV, FA, CM, iProcurement), PL/SQL, Forms & Reports 6i, Discoverer, Solaris 2.6.

Confidential, Atlanta, GA:

Functional Consultant

• Implemented functional enhancements such as Cross Validation Rules summary accounts, account aliases, currency translation, conversion, and revaluation Global consolidation, Multi reporting currency and FSG reports to meet the requirements in GL module.
• Reviewed the current system, GAP analysis, and configured the GL system and tested the system to meet the business needs.
• Configured AP system to meet the business needs with regards to batch invoices and batch payments, multi-currency invoices and multi-currency payments.
• Delivered (AIM) documentation such as BR-20, BR-100, MD-50, CV-60, and TE-40 for enhancements.

Environment: Oracle Apps 11.5.10 (GL, AP, AR, OM, PO, INV, FA), PL/SQL, Reports 6i, Linux

Confidential

Manager - Development & System Analyst

• Implemented Financial Accounting packages ex next gen.
• Involved in System Analysis, designing of database, Reports, implementation and testing of custom software in Procurement and Sales, system and accounting structure design including re-engineering of business process according to business needs. Product pricing analysis preparation and filing of sale tax returns, financial planning and Funds management, preparation of annual budgets.
• Developed finance proposals for projects and working capital proposals.
• Responsibilities include project appraisal, sanction and release of funds from commercial banks and State authorities and availing the investment, sales tax incentives from various Govt. bodies.

Confidential

Senior Executive (Accountant)

Executive for financial planning and management. Involved in System Analysis, data modeling, reports design, testing and implementation of software for sales. Approved expenses, effectively maintained the accounts and records. Involved in year-end reconciliation and preparing financial statements and auditing.

Confidential

Senior Executive

Confidential is a huge distribution and power transformers manufacturing organization located in Hyderabad, India. Started as Management Trainee, then appointed Junior Executive with a fairly wide range of responsibilities like floating tenders, analyzing market competitors, organizing QC checks for customers, deliveries scheduling, raising invoice against supplies and collections. Designed reports like Order execution status report, Periodical Payment dues statements, withholding guaranties amounts report for MIS. Responsibilities included day-to-day operations, annual budgeting, planning and controlling of expenditure incurred at after sales service division. Designed different types of failure analysis reports for MIS to insure the quality at various levels of process.