SUMMARY

• About 13 years of experience as an Oracle Applications Functional Analyst.
• Experienced in implementation and customization of Oracle Applications such as Federal Financials, AP, AR, GL, EBTAX, PO, FA, Project Costing, Project Billing, GIS, iProcurement, iExpense, OM, INV.
• Experienced in Federal Business Processes, Federal Accounting, and Federal Reporting.
• Over the Years, provided end to end, integrated solution to various Federal and Commercial Clients.
• Skillful Insight, Incisive Intuition and Positive Temperament to resolve extremely critical issues.
• Expertise in Solution Design, Solution Delivery, System Integration, and Business process Streamlining.
• Worked on all stages of SDLC (Software Development Life Cycle) including requirement gathering, analysis, design, development, testing, implementation and Maintenance.
• Good understanding of Process flow and Integration of different modules of Oracle Applications.
• Expertise in structured documentation and process documentation.
• Prepared documentation strategy to support various stages of SDLC (Software Development Life Cycle).
• Extensive experience using Microsoft Word, MS Visio, and PowerPoint.
• Strong verbal and written communication skills and problem - solving skills.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Functional Analyst

Responsibilities:

• Working as Oracle Financial Functional Analyst in R12 environment.
• Working on FSGs for Over 13 Countries and Multiple Legal Entities.
• Cleaned up about 600 FSGs, modified and redesigned them and created new FSGs also.
• Helped users in FSGs Reconciliation and Troubleshooted issues.
• Participated in R12 Chart of Account redesign discussions.

Confidential, Denver, CO

Functional Lead/Analyst

Responsibilities:

• Working as Oracle AP/AR/GL Functional Analyst in R12 Federal environment.
• Also contributed to B2R Business Processes and transactional streamlining and Solution design.
• Resolved very critical R12 Upgrade issues related with Treasury Confirmation.
• Involved in Solution Design for “Appropriation Year/Budget Fiscal Year” for B2R (Budget to Report).
• Customized R12 SLA (Sub ledger Accounting) for AP and AR.
• Provided Solution for Federal Payments.
• Provided Solution for 1099 Vendor Payment and 1099 Forms PDF Format Reporting.
• Provided Solution for AP/AR Netting.
• Involved in Designing solution for GL Approval Hierarchy.
• Reviewed GTAS patches for Federal Implementation).
• Troubleshooted various Payables, and AR issues and trained Users with R12 Functionalities.

Confidential, Sunnyvale, CA

Functional Lead/Analyst

Responsibilities:

• Worked as Oracle Financials Functional lead. Designed, configured and implemented solution for GL, AP, AR, CE, PO, FA, and EBTAX in R12 Multi Org environment.
• Designed Multi Org Solution based upon Organizational Access Control and Separation of Duties.
• Created and Modified FSG reports (Balance Sheet and Income Statement)
• Provided Solution for GL Approval.
• Provided Solution for EB Taxes.
• Provided Solution for Accrual Write-off and Reconciliation.
• Troubleshooted Key R12 Payment Issues, AR Issues, and EBTax Issues.
• Led and guided technical team in designing MD-070, and did testing and troubleshooted issues.
• Prepared User Training materials and trained users.

Confidential, Foster City, CA

Functional Lead/Analyst

Responsibilities:

• Working as Oracle Financials Functional Analyst.
• Involved in Oracle Country Rollout for different Confidential Entities around the world.
• Provided solution and resolved critical issues in Oracle Fixed Asset.
• Provided Solution for iExpense, Accounts Payables, Cash Management, Oracle Purchasing, and GL.
• Worked on India Localization (India Local Payables, India Local Purchasing)
• Created new FSGs and also modified several existing FSGs.
• Prepared BRD (Business requirement Document) for Customized report for Intercompany Reports for reconciliation.
• Prepared BRD (Business requirement Document) for Customized report for FA Reconciliation,
• Prepared FRD (Functional Requirement Document) for Confidential India, Confidential Australia, and other Confidential entities.
• Support Business Users in Oracle Financials.

Confidential, Dayton, OH

Functional Lead/Analyst

Responsibilities:

• Worked as Oracle Accounts Payables Functional Analyst in R12 Federal environment. Also contributed to AR, GL and Federal Administration Solution.
• Involved in Analysis, design, implementation and testing of Federal Financials Cash Reconciliation Interfaces, extensions, and reports.
• Provided Solution for Federal Payment, IPAC Payment, Fast Payment, Treasury Confirmation, Withholding Taxes, Split Schedule, Prior Period Receipts, Economically beneficial Discount and Interest Calculation, Credit Memo, Assign Reason Codes.
• Worked on SLA (Subledger Accounting), and SFIS Elements.
• Configured R12 Payment Templates and Payment Profiles.
• Worked on MD-050s for Payables, Receivables, Federal Admin and Cash Reconciliation Interfaces and Extensions. Also, participated in peer reviews.
• Involved in designing solution for 1080, 2 Sided 1081, and Integration of Oracle with CDS, MyInvoice (WAWF). Also, worked on Federal 7113 report (Cash Reconciliation Report).
• Led and guided technical team in designing MD-070, and did testing for Interfaces and Extension and troubleshooted issues.
• Troubleshooted various Payables, AR and Cash Reconciliation issues and helped testing team in writing and executing Test Scenarios and Test scripts.

Confidential, San Francisco, CA

Functional Lead/Analyst

Responsibilities:

• Gathered requirements related with Insurance Business processes related with Claims, Premiums, and IBNR etc.
• Prepared design documents for reporting solutions.
• Worked on Business Objects and BOXI (Adhoc and Canned) Reports
• Developed Test Plan and Test Scripts.
• Worked on enterprise level monthly reconciliation processes.
• Interacted with Business Team and led UATs.
• Assisted Technical team in designing solution for reports and in troubleshooting issues.

Confidential, Virginia

Functional Lead/Analyst

Responsibilities:

• Performed Requirement Gathering, Map and Gap Analysis, Defined ‘To Be’ Processes for B2R, suggested Streamlining, and integration of Business Processes to enhance end to end visibility, auditability and traceability at the enterprise level.
• Prepared Requirement Matrix, Narratives, and Process Flow Diagram for end to end solution of Budget to Report
• Led the Requirement Gathering, Map and Gap sessions, workshops, and Focus Groups.
• Gathered requirement and performed analysis for DWCF (Defense Working Capital Fund), Trust Fund, and Milcon and BRAC Fund, Contract Authority, Fund Control/Fund Check mechanism, Budget Levels, Budget Distribution, Fund Distribution, Federal Budget Execution, Budget/Spending Plan Monitoring, Supplemental/Rescission/Reprogramming, Prior year Upward and Downward Adjustments/Recoveries, Appropriation Parameters.
• Gathered requirement and did analysis for Month end, Quarter end and Year end reconciliation, Federal reporting (FACTS I, FACTS II, SF 132, SF 133, SF 231, SF 1080, SF1081, SF 1151, 224, 1307 Reporting, 707 and 725, 1166, Statement of Transactions, and Statement of Accountability) and Year end Closing.
• Mapped Capabilities with ‘AS-IS’ System, also mapped B2R process with EDM (Enterprise Data Management) requirements.
• Worked on SFIS Data elements.

Confidential, Kansas City, MO

Functional Lead/Analyst

Responsibilities:

• Worked as Oracle Financials Lead (Oracle Purchasing, Payables, AR, GL and Federal Admin) in R12 Federal environment.
• Designed solution and performed Configuration for GL. Involved in finalization of Charts of Accounts, Cross validation rules, and Security rules in GL.
• Defined Budget, Budget Organization, Account Assignments, Summary Template, Roll-up Groups, MassBudget, and Formulas.
• Designed Solution for Fund Control mechanism, Budgeting and Budget Forecasting in GL based upon Fixed and Variable costs.
• Designed Solution for GL integration/interface with STARS (the System of record for JPATS).
• Designed Solution for Federal Budget Execution, Fund Check/Availability, Prior year Upward and Downward Adjustments.
• Defined Federal Options, Federal System Parameters, Treasury Symbol, Appropriation Parameters, Budget Levels, Budget Distribution, Transaction Types, and Fund Distribution.
• Designed solution for Month end, Quarter end and Year end reconciliation, Federal reporting (FACTS I, FACTS II, SF 132, SF 133, SF 231, 224 and 1307 Reporting) and Year end Closing.
• Loaded Budget/Actual journal entries with Web ADI in GL.
• Worked on FSG Reports for Balance Sheet, Income Statement, Budget vs. Actual.
• Worked on Federal/Non Federal Billing (AR), Reimbursable Agreements, MFAR.
• Troubleshooted AR (Accounts Receivables) issues related with Autoinvoice Interfaced with OTM (Oracle Transportation Management).
• Troubleshooted Federal AR accounting issues related with Invoice/Debit memo/Credit memo, Adjustment, Cash Application based upon specific Fund.
• Configured Grouping rules for Federal and Non Federal Invoices and Worked on SF-1081 for consolidated Billing for Federal Customers.
• Designed Revenue Receipt report for monitoring/reporting Billing for Federal Customers against the Reimbursable Agreements.
• Designed and Implemented AP, and Purchasing and Federal Admin Solutions.
• Performed Configurations from scratch for Purchasing, AP, and Fed Admin.
• Designed Solution for Federal Budgetary Accounting (based upon Working Capital Fund), Fund Reservation, Federal 157, 182, 1164, OBD 38, Federal Ratification, Approval Hierarchy, Item Based Approval mechanism, Bulk Purchases, ASO Bulk Travel, Employee Travel, and Non-travel Reimbursement, Capital Asset and Improvement, and Receipt Accrual.
• Designed AP solution for Federal SPS Payments, IPAC Payment, Treasury Confirmation, Prompt Payment, Discount and Interest Calculation based upon Federal regulations. Also, designed solution for Federal AP Accounting, and Federal Reporting.
• Also designed solution for Purchasing, AP, and GL integration with STARS.
• Prepared BR-100 and MD-50 for Fed Administration, AP, and Oracle purchasing solutions.
• Provided solution for Period closing, and Month end reconciliation of AP, AR, GL and Purchasing.
• Prepared Test scripts, conducted CRPs, and prepared training documentation for AP, and Purchasing.

Confidential, Brisbane, CA

Functional Lead/Analyst

Responsibilities:

• Worked as AR, AP, Cash Management, and Oracle Purchasing Lead.
• Designed and Implemented AR, AP, Cash Management, and Purchasing Solutions for 35 Operating units in Multi Org and Multi Currency environment for Confidential, MySpace.com, and other Fox Subsidiaries.
• Performed Configurations from scratch for AR, AP, Cash Management, and Purchasing.
• Designed AR solution for Deposits, Recurring Invoices, 'Make good' invoices, VAT, Autoinvoice, Conversion of Invoices, Printing incomplete invoices, and Enabling Batch Completion of Invoices.
• Designed Solution for Autoinvoice interface with Operatives (Order Management Software.). Also, troubleshooted issues related with Invoices, credit memo, and debit memo import.
• Designed AP solution for Withholding Tax, VAT, Interest Calculation, Wire, ACH and Check Payments for 35 Operating Units.
• Designed Solution for Bank Statement Import and Reconciliation.
• Implemented European Localization for France, Finland, UK, Spain, and Italy in AP, and AR. (Defined Document Sequencing, VAT registers, Tax group, Tax Codes, Tax Authority. Also, Defined Globalization Flexfields for Suppliers, Invoices, Banks, Customers as per the Localization requirements. Also, worked on Country specific Payables (AP) and Receivables (AR) VAT Registers/Reports.)
• Prepared BR.100 and MD-50 for AR, AP, CE, and Oracle Purchasing solutions.
• Provided solution, help and guidance in Period Closing, and Month end reconciliation of AP AR, and Purchasing.
• Prepared Test scripts, conducted UAT for AR, AP, CE, and Purchasing and Involved in sign-off activities.
• Providing Post Production Support for AR, AP, CE, and Oracle Purchasing.

Confidential, Washington DC

Functional Lead/Analyst

Responsibilities:

• Provided Solution for 1099 Vendors payment, Interest Payment, Invoice Matching, Invoice Tolerance, Processing of Payment Batches, Manual Payment, Wire transfer and Foreign Draft, Bank Statement Import, Autoreconciliation, Sweep Account, Bank Charges, Bank Errors, Federal Clearing, and Miscellaneous receipt.
• Designed Solution for Federal Financials requirements such as Treasury Confirmation, IPAC, SPS Payment, SPS Interface, Federal Reconciliation, Federal 224 report, Federal Prompt Payment, Sweep Account, Treasury Symbol, and Appropriation Code
• Participated in AP/GL Month-end reconciliation and in Year end closing process and resolved issues related with reconciliation and closing process.
• Resolved issues involving Appropriation Code, Treasury Confirmation, Federal Cash reconciliation, Deferred expenses, Fund Check/Control, Journal import, Journal Posting, Interfund, Receipt Accrual, Receipt Accounting, Accrued Expenses, AP Liability, Discount Calculation, and Rounding Account.
• Troubleshooted issues of Fund availability, Summary Account, GL Balances, and Appropriations.
• Sound understanding of Federal Accounting including USSGL, Transactions Codes, Budgetary control, and Federal Reporting.
• With AIM Methodology prepared Functional and, Configuration documentation.
• Conducted functional meetings with the Users and Superusers for ascertaining Business Processes and resolution of design and configuration issues.
• Assisted technical team to comprehend, and analyze functional and business requirements.
• Conducted CRP sessions to demonstrate the project milestones.
• Led User Acceptance Testing and Sign-off Process and assisted users in Testing.
• Prepared Test scripts on UPK for integrated testing and training.
• Trained Users and Superusers to facilitate Change Management.
• Performed AP, and Cash Management Configurations.
• Performed Troubleshooting for AP, AR, Cash Management, PO, FA, Federal Financials, Project Costing, Project Billing and GL.
• Supported the users in the production environment.

Environment: Oracle Applications 11.5.10 on UNIX

Confidential, Olympia, WA

Functional Analyst

Responsibilities:

• Involved in Gap Analysis, Requirement Gathering, requirements verification, state accounting and prepared Requirements Specification Document (RSD) and DSDD (Detailed System Design Document) for AP, AR, GL, FA, Project Costing and Project Billing.
• Utilized AIM Methodology and prepared Functional and, Configuration documentation.
• Developed Use Cases for the RSD and prepared the materials needed for each functional meeting (FG - Focus Groups) with the state users.
• Prepared Process Flows, and Presentations to facilitate discussion with state users for resolving configurations, design issues and Business Process Re-engineering activities.
• Guided the technical team to sync with functional and business requirements
• Involved in executing multiple Collaborative Application Development sessions to review and obtain approval for initiating the development activity for the appropriate project milestone (LG - Logical Groups).
• Involved in integration of Oracle Financials with various subsystems (Drug Rebate, COB/TPL, Claims).
• Prepared Requirement-Use Case Mapping Matrix for the State User to fine-tune the requirement verification.
• Identified list of action items and other design issues and addressed through web portal to update the client.
• Performed AP, AR, GL, Project Costing and Billing Configurations.
• Provided Solution for Fixed Assets (FA), Configured Book Controls, Asset Location, Asset Categories, Asset Key, Fiscal Year, Calendar, Prorate Convention, Security by Book. Also, provided solution for depreciation, accumulated depreciation, Asset Retirement, Asset Transfer. Also led the asset conversion process and Prepared Design document for Asset conversion.
• Designed Solution, Configured Oracle Projects and Billing, and Prepared BR.100. Prepared training document, and did Testing for end to end integrated business process for PO, AP, Project Accounting, and FA. Also, designed solution for project billing based upon integration of Project Billing and AR.

Environment: Oracle Applications 11.5.10 on UNIX

Confidential, MA

Functional Consultant

Responsibilities:

• Involved in implementation of Accounts Payable, Purchasing, FA, iProcurement, iExpense, GL, GIS (Global Intercompany System), Project Costing and Project Billing.
• Prepared Functional Specifications for COA (Chart of Account.)
• Provided solution for Budgeting, and lent help and guidance in Month end reconciliation.
• Provided Production Support and resolved issue involving GL Balances, Account Analysis, and Month end reconciliation, Translation, Consolidation, Summary Template, and Rollup Group.
• Worked on FSG reports and ADI.
• Designed FA Solution, And Performed FA Configuration. Designed solution for Asset creation, Asset categories, depreciation, transfer, retirement, asset security by book, and asset reconciliation.
• Wrote Functional Specification for Employee conversion, and P-Card and interface.
• Prepared Functional Specification for Positive Pay, and ACH Payment Interface
• Prepared Functional specifications for SOX compliance Customized Reports.
• Prepared Test Scripts for different modules of Oracle Applications, contributed significantly in making the system stable and robust, and made the testing process systematic and systemic.
• Involved in Process Development to set up appropriate processes, which enhanced team and organization level efficiency and increased the output.
• Prepared Test scripts for AP, iExpense, AR, Cash Management, GIS (Global Inter company System), FA, GL, PO, iProcurement.
• Prepared Scenario List and Test Repository for different modules.
• Prepared Test Scripts for Project Costing and Project Billing.
• Interacted with Business team to define and identify Key Functions (Business Critical) in each module
• Also identified Categories to interrelate the process flow within a module. Identification of Categories also provided modularity to testing process.
• Found critical bugs during preparation of test scripts and during integration testing.
• Test Scripts and Process Development generated additional high scale organizational benefits.

Environment: Oracle Applications 11.5.8 on UNIX

Confidential, IN

Functional Consultant

Responsibilities:

• Involved in Map and Gap analysis, and prepared the functional design for interfaces in Oracle Applications and prepared Business Process documentation.
• Performed documentation for assignment of Items to Category and Category sets.
• Documented Product Life Cycle of Item Categorization, and prepared training manual for developers.
• Prepared Functional Specification for the Customer Interface to load customers from Legacy to Oracle Receivables.
• Prepared Functional Specification for the Invoice Interface to load open invoices from legacy to Oracle Receivables using Auto Invoice Program.
• Configured Auto Lockbox and documented its application and different test cases for engineers and end users.
• Wrote test scripts and trained users.

Confidential, Detroit MI

Functional Consultant

Responsibilities:

• Mapped, Designed, Developed, and documented strategy to Import Vendor/Supplier Information into Oracle Purchasing.
• Wrote Functional Specification for AP Invoice Import.
• Documented how to perform containerization in order management.
• Prepared documentation for modification of PO Approval Workflow.
• Prepared Functional Specification for P-CARD Interface.
• Prepared Functional Specification for ACH interface in AP.
• Prepared Functional Specification for Positive Pay Report in AP.
• Led CRP sessions, wrote test scripts and trained users.
• Conducted testing and was involved in the analysis of the bugs found in the testing phase and was responsible for providing fixes to the technical team for debugging.
• Involved in training the client core team members and end users in the configured solution and documented the entire implementation stage.

Environment: Oracle Applications Release 11.5.7 on RedHat LINUX Advanced Server 2.1

Confidential, IL

Functional Consultant

Responsibilities:

• Prepared functional and technical requirements specifications based on the business requirement documents.
• Involved in System study, Requirements Analysis, Gap analysis, design, Design documentation, Configuration, Implementation, testing and Production Support.
• Worked as ‘Procure to Pay’ Analyst, did PO and AP configuration.
• Assisted preparing Project Plan.
• Assisted writing Issue and Risk Management document.
• Involved in Business Process Reengineering.
• Prepared Joint Application Development Document (JAD). Participated in the preparation of AS IS and TO BE documentation.
• Participated in the implementation team plan meetings to oversee and documented the status of the project.
• Prepared Functional Specification for Order Entry and created training manual for developers.

Environment: Oracle Applications Release 11.5.3 on Unix

Confidential, Chicago, IL

Functional Consultant

Responsibilities:

• Involved in requirement gathering, Map and Gap Analysis, Design, implementation, testing, and Maintenance.
• Provided Solution for AP, and PO and Performed AP and PO Configuration.
• Involved in GL Configuration and wrote Functional Specification for COA (Chart of Account) and Budget Import in GL.
• Wrote Functional Specification for Customization of PO reports.
• Wrote Functional Specification for Order Import process.
• Wrote Functional Specification for Items Import into Oracle Inventory.
• Conducted CRP sessions, wrote Test Scripts and trained Users.
• Performed Unit testing, integration testing and fixed issues that occurred in UAT (User Acceptance Testing).

Environment: Oracle Applications 11.5.3 on UNIX

Confidential, Dayton OH

Functional Consultant

Responsibilities:

• Gathered user requirements, and Performed Map and Gap Analysis, Designed Solution, Performed Configuration, Did Implementation, and Supported AP, PO, and AR.
• Prepared Functional Specification for Auto invoice and Customer Interface.
• Documented the scope, purpose, relevance, use of functionalities of Auto Lockbox.
• Wrote Functional Specification for Requisitions Import to load requisitions into Oracle Purchasing.
• Involved in Unit testing and system testing.
• Trained Users, and Prepared Test Scripts.
• Involved in Production Support and fixing production problems.
• Wrote Functional Specification for Customization of reports in Accounts Payables.
• Experience in understanding Oracle supplied TRM’s and the relationship among tables.
• Logged TARs, interacted with Oracle support and resolved production issues.