SUMMARY

• 14+ years of Professional IT experience with 10+ Yr.’s as an Oracle Financials Functional Consultant in multiple versions of Oracle E - Business Suite Financials
• Extensive knowledge in General Ledger (GL) with Advanced Global Intercompany Systems (AGIS), Sub-ledger Accounting (SLA)/ Financials Account Hub(FAH), Account Receivables (AR), Account Payables (AP), Fixed Assets (FA), Cash Management (CE), E-Business Tax (EB-Tax), Purchasing (PO), i-Expenses and i-Procurment Modules.
• Tremendous knowledge of Multi-org, Advanced Global Consolidation Systems, Advanced Global Intercompany Systems, Financial Statement Generator, and Sub-ledger accounting
• Expertise in working on multiple versions of Oracle in both 11i /R12.
• Worked on multiple Global Implementations, Up gradations, and Post Production Support projects
• Played key role in providing manual work around solutions for critical business scenarios in order to minimize the customizations and provide sophisticated solution for constructive business transaction process
• Providing application requirements gathering, designing, development, functional documentation following with business approvals
• Excellent knowledge in preparing and maintaining Oracle AIM methodology documentation including BR100,RD20, MD50, TE40, and CV40 and Change Management Process documentation
• Preparing test scripts, performing quality assurance tests (Smoke testing) prior to user testing.
• Experience in using some tools, but not limited to, are ADI, Web ADI,BI/XML
• Excellent in process mapping, process improvement, configuration, development, functional documentation, training documentation, and production support
• Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through financial closing; revenue and expense cash/accrual concepts; adjustments and financial statements
• Configure Business access as per SOX compliances and setting up responsibilities accordingly to maintain the proper internal control mechanism
• Experience in all phases of full life cycle Oracle Financials implementation i.e. Requirements Definition, GAP Analysis, Fit-gap analysis, Application Configuration, System Testing, User Training
• Expertise in creating financials reports with Financial statement generator (FSG)
• Well versed with the integration and architecture of Multi-Org (MOAC), SLA (sub-ledger accounting) and Web ADI
• Excellent skills with playing vital role in conducting numerous business meetings for all key important business process decisions and proposed solutions in Oracle according to the size and nature of the organization
• Handled a team of 4 in onsite and 5 in offshore as a Team lead.
• Experience in Upgrade and Conversion/Migration of data from legacy systems to Oracle Systems

TECHNICAL SKILLS

Oracle Financials: GL, AGIS, AR, AP, FA, SLA (FAH), CE, E-B Tax, PO, Sys Admin, P2P / O2C

Operating Systems: Microsoft Windows 98/XP/Vista/7, Windows NT 4.0/2000 Server/Workstation

Other Tools: ADI, Web ADI, Discoverer, SQL*Plus, Data Loader, TOAD, PL/SQL Developer, SQL Loader,, HP/Mercury Quality Center, BI/XML Publisher.

Other software: Microsoft Office Project, Visio, Access; PVCS Tracker, Mercury

PROFESSIONAL EXPERIENCE

Confidential, Portland OR

Oracle Lead Financials Functional Analyst

Responsibilities:

• Coordinate with Business team on day to day application issues and provide quick updates on issue resolutions along with status updates on open items tracked in ACSI Service Centre.
• Activities in System administrator to assign user accounts, assigned responsibilities, menu selection, reports, etc
• Coordinate with DBA team to apply patches proposed by oracle after following up on existing issues
• Followed up with Oracle team to fix errors while conducting SQL code writing, upgrading, manipulating, editing, and inserting using SQL Developer for Oracle EBS.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 10g.
• Worked extensively on XML Publisher reports.
• Set up Multi-Currency environment.
• Configured all the General Ledger, Payables, Receivables, I-Expense set-ups.
• Setup MOAC for Payables module to restrict access to different operating units
• Configured the Balancing Rules for AGIS Transactions.
• Worked on File Net Document Imaging Solutions to store AP Invoices
• Created different transaction types and sources for Receivables (AR) and Created distribution sets, receipt sources, receipt classes & payment terms. Worked with customization of forms and reports

Confidential, Chicago, IL

Oracle Financials Functional Analyst

Responsibilities:

• My core responsibilities involved with Training Finance Users/ trouble shooting in the area of AR, AP, and GL modules and developing Complete new FSG Reports.
• Defined and generated FSG’s for Balance Sheets where rollup groups are considered for Parent’s/child relationship
• Resolved any month end related issues involving and data fixes or configuration changes.
• Create and follow-up on multiple SEV1 & SEV2 SRs for speedy resolution explain business team with cause of issue
• Provide impact analysis on proposed changes and document the complete Change Management Process
• Daily monitoring of incident issue tracker in Service Center team by Coordinating.
• Configured and tested various FSG Reports (Income summary reports etc) that were designed to meet the requirements of CORP Conducted and participated for daily upgrade teleconference meeting with team, discussed about findings and issues. Attended and discussed issue resolutions and work-in-process update at the meetings with clients in regular intervals.

Confidential, Madison WI

Oracle Financials Functional Analyst

Responsibilities:

• My core responsibilities involved with Training Finance Users/ trouble shooting in the area of AR, AP, and GL modules.
• Perform the related set-up tasks in the applications that work together with Expenses template to create an integrated environment for expense reporting.
• Configured all the General Ledger, Payables, Fixed Assets and I-Expense set-ups in the test instance.
• Created Process Maps and reviewed Desktop Procedures for Payables and iExpense Module.
• Setup Multiple Organizations, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets Cash Management, iExpenses, Order Management and Purchasing Modules in development instance, SIT, UAT and Training Instances
• Completed set up for banks, payments, payment programs, automatic and custom payment formats & programs, tolerances, payment terms, approval limits, signing limits, employee expense reports and expense report templates. Customized vendor letters. Defined payable holds, distribution sets. Completed Credit card and Procurement Card set up by defining credit card code sets, programs, profiles and card references. Defined VAT and Canadian Tax codes, groups and assignments to handle VAT tax calculations.
• Payables process had been designed and system had been configured and setup for (Financial option, Payable system option & Payable option) to meet the requirements such as batch invoices, batch payments, employee expense report process and reporting.
• Designed chart of accounts (COA) to meet the client’s business requirements and Set up the financials and payables options
• Created different bank accounts for Payables and Receivables. Set up the CE module to reconcile Payables and Receivables with bank statements
• Did Setup’s for CYBERSOURCE Credit card Payment Integration for AR Modules
• Resolved Settlement Process Issues with CYBERSOURCE credit card Payment gateway.
• Set-up Multiple Organization Access Control (MOAC) and Multiple Reporting Currencies
• Troubleshooting of the Order Management (OM) and Inventory (INV) modules.
• Setup File Net Document Imaging Solutions to store AP Invoices.
• Worked with iProcurement to place purchase requests and completed the work-flow approval process, populate the orders in the purchasing module to complete the purchase orders
• Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers
• Created Users and modified the privileges for the Users, Rollup group and Summary Accounts.
• Did setup for AGIS (Advanced Global Intercompany Systems) to handle internal company transactions

Confidential, Portland OR

Oracle Lead Financials Functional Analyst

Responsibilities:

• Worked on GL Interface to import multi-currency Journals.
• Worked closely with the team members who conducted trouble shoot activities for the other Oracle applications such as Oracle Projects, Oracle Fixed Assets, AP Check Printing, BI, XML both in US /UK / Singapore operations
• Reviewed and extended the use of purchasing data (e.g., Requisition templates, categories, BPAs, ASL, etc) and made these data structures available to i-Procurement
• Provide detailed root cause analysis on all assigned issues with reproducing the same in latest cloned copy of test environment.
• Provided Users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi-Operating Units through Security Profile in a secured environment.
• Implemented Vertex tax Setup.
• Worked with development of packages and procedures using PL/SQL.
• Configured the Multi-Organization Access (MOAC), Ledger Setup, and Legal Entities
• Utilized the Application Object Library to register SQL*Loader programs, shell scripts, PL/SQL procedures and RDF Reports.
• Worked on the setups of Financial Accounting Hub (SLA/FAH) module including the setups of Event Models, Sources and Source Data, Worked on the definition and build, accounting program integration, Accounting event setups, accounting event analysis, transaction objects, accounting method builder, etc.
• Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, Establishment Setups, MOAC security
• Involving PO, i-Expense, i-Procurement, AP, AR, GL Modules meet with customers to understand their system and service requirements and then Writing Functional Test Scripts for the end to end testing, coordinating with the technical team to develop load testing scripts for all of the data conversions as well as inbound and outbound interfaces.
• Oracle base table analysis related to form errors and coordinate with technical team for speedy resolution
• Provide Analysis in identify SQL code logic to trouble shoot application errors at different intervals

Confidential, Los Angeles, CA

Oracle Financials Functional Consultant

Responsibilities:

• Worked with the client team in understanding their business process and prepared various requirement gathering and functional design documents
• Prepared “To Be Docs” for all five modules including GL, AP, AR, FA, and CE
• Identified process flow through Grants module to introduce accounting activities to AR and FA
• Identified and configured as per Client’s Requirements two future segments in COA
• Defined grouping and Line ordering rules for Auto invoice, Auto accounting rules, Auto Cash rules, Receivable classes and Payment terms, Statement cycle, Dunning Letters etc.
• Worked on the setups of AP/AR Netting.
• Set up supplier auto numbering and AME workflow for invoice approval process and hold resolution
• Introduced TCA to manage customer/supplier information and Bank information
• Templates creation for Cash Forecasting, Cash positioning in CE module
• Defined auto-reconciliation process to handle electronic bank statements with Cash Management module
• Created New Mass Allocation Formulas, to allocate head office rent expense to branch offices
• Defined one Corporate Book for managing assets. Defined asset cost, asset clearing, depreciation expense, accumulated depreciation, CIP cost, CIP Clearing, Depreciation Adjustment as Fixed assets accounting
• Per clients requirements, defined Straight Line Method (STL) asset depreciation and proposed depreciation ceilings and bonus rules
• Identified the use of the current Descriptive Flex fields (DFF) in Purchasing into AP. Discussion how to integrate Confidential ’s current Asset Work to proposed FIS.
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components

Confidential, Hudson, NH

Oracle Financials Functional Consultant

Responsibilities:

• Interaction with Business Users to understand better their main points and Key requirements
• Understanding current Chart Of Accounts and propose a future design to enhance the way Atrium does Business currently with a new Chart of Accounts in R12
• Configuring/Updating Functional Setups of GL, AP, AR, and CE modules
• Discuss and analyze handling of Project Capital Assets As-Is and To Be Process
• Define Scoring models and Credit checklists for validated/ Approved customer list
• Gathering Business Requirements for Upgrade considerations and documenting them
• Capture and upgrade all the Custom Processes and Reports
• Actively involved in implementation of E-business suite including gathering the requirements from the user and understanding their business model the modules worked on includes AR, AP, FAH, GL and FA Modules
• Provide a Demo environment to show the Intercompany (AGIS) Future transactions in R12
• Upgrade and modify the current Revenue Recognition schedule in AR to reflect R12 changes and Future Business needs
• Develop Unit (TE.020) and System Integration Test Scripts (TE.050).
• Designed chart of accounts (COA) to meet the client’s business requirements
• Set-up accounting period types and accounting calendars
• Set up Fixed Assets including defining category, location, and asset key flex fields.
• Designed and configured Location and Fixed Assets Key Flex Fields, Asset Books, Asset Categories, Asset Sub-Categories, Asset Depreciation, Fiscal Calendar, Prorate Calendar, Security by Book.
• Defined Asset TAX Book Performed Quick Additions, CIP Additions, Mass Additions and Capitalized CIP Assets.
• Performed Asset Transfer, Mass retirement, Reinstate the retirement and Mass Changes in Assets
• Grouped assets associated with a specific project, department, and location to track CIP assets in the organization
• Setup Oracle Payments for Check, ACH, and Credit Card Payment Methods
• Set up the financials and payables options and created different bank accounts for Payables
• Involved with migration of historical data for Account Payables(AP)
• Involved with study of existing system, preparing the Functional (MD50) with Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables
• Configuration of CRP1, and UAT instances

Confidential, San Luis Obispo, CA

Oracle Financials Functional Analyst

Responsibilities:

• Implemented new Auto accounting rules for Receivables to help drive the right accounting
• Supported procure to Pay issues with month end and additional configurations.
• Defined the prorate convention, prorate calendar, depreciation rate and calendar, fiscal calendar and system controls
• Grouped assets associated with a specific project, department, and location to track CIP assets in the organization
• Designed and created test scripts and user-manuals for the modules.
• Resolved any month end related issues involving and data fixes /configuration changes
• Configured AGIS for mainstream to handle intercompany transactions along with defining intra company rules
• Conducted study on the existing business practices, gathered requirement specifications and performed Gap Analysis for implementing GL, AR.
• Involved in AP AR Netting control Account/ Bank accounts/ configure AP AR netting Receipt Class/ Netting agreement.
• Configured AGIS for mainstream to handle their intercompany transactions along with defining Intercompany rules
• Implemented Dunning letters in Receivables for customers to send on a monthly basis based on the aging of the invoices
• Worked on all the setups for the Revenue Recognition, FAH and AR (O2C) modules
• Defined Sub ledger accounting (SLA) rules to handle third party transactions in Receivables (O2C)
• Provided solution for cleaning up Security access with the appropriate responsibilities as per the employee position
• Correct any auto invoice errors while importing the invoices and while working with Oracle wherever necessary
• Resolved month end issues with Projects and helped import successfully any accounts or invoices related
• Provided post production support for all financial modules with month end closing related as well as regular issues

Confidential, San Jose, CA

Oracle Functional Consultant

Responsibilities:

• Identified gaps between system processes and Business processes and documented using Gap Analysis Document. Also analyzed and indicated proposed workarounds and resolutions.
• Identification of master data like Items / Suppliers and setting up the master data
• Project was a reimplementation of General Ledger wherein many interfaces were integrated into Oracle Apps culminating into FAH and in turn to Oracle GL
• In FAH, certain validations were required to be performed in order for the journal to seamlessly land into oracle general ledger without errors, Worked on requirement documentation and analysis for such interfaces with FAH and GL
• Design Document (MD 50) based on the business requirements for enhancements. Also worked extensively with developers to make sure that development / testing and migration to production is in compliance with the AIM Methodology.
• Business process study and creating business process maps using MS Visio for Oracle E-Business Suite GL, AP, AR and FA modules implementation
• Worked with business users to define their business requirements in preparation for developing program solutions and translated the requirements into 11i Processes.
• Reviewed the existing reports and collected requirements to develop additional custom reports for Engineering change order report, Warehouse summary report etc
• Involved in data conversion for data like supplier data, customer data and Address details
• Prepared end user training material with specific business cases and conducted end-user training.
• Involved in post-production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions.

Confidential, Roseland, NJ

Oracle Financial Functional Consultant

Responsibilities:

• Performed GL Code combinations and FA Assets from one set of books to another by running appropriate jobs.
• Updated Organization Parameters, Receiving Accounts, Expense AP Accrual Accounts, P&L Accounts, Clearing Accounts, Cost Group Valuation Accounts
• Updated Purchasing (PO), Receiving (AR), Financials(GL), and Payables(P2P) options
• Changed Auto Accounting rules to accommodate the new organizational structure
• Developed Year End process using Mass Allocation Formulas, configured Mass Allocation Year End formulas
• Configured new cross validation Rules and Security Rules
• Configured and tested various FSG Reports (Income summary reports etc) that were designed to meet the requirements of CORP in ES
• Used ADI and tested various GL Journal import process through ADI. Also performed standard and statistical Journal entries in GL
• Set-up Supplier and Supplier Sites for vendors in Accounts Payables (P2P).
• Set-up Banks, Receipts, Transactions, Plus training for invoicing, Receipts, Adjustments, and Period closing.
• Participated in test reviews and defect report meetings periodically
• Developed GL Consolidation Process, Configured Consolidation Rules and Implemented GL Consolidation.

Confidential, Englewood, CO

Oracle Techno Functional Consultant

Responsibilities:

• Registrations of Tables and Forms for custom applications.Developed custom reports based on Business requirements.
• Creating SQL, Object Views, PL/SQL database objects.Participated in developing interfaces
• Involved in unit testing, integration testing, and system testing (SIT).Developed Customer interface in Receivables(AR)
• Responsible for preparing procedures, functions, packages as per requirements. Registered various applications, reports, PL/SQL packages, Request Sets, Forms, Menus and Tables. Developed queries and provided data as per user requirements.Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets.
• Defined receipt class, specifying creation method, Payment method, clearing method, defining collectors
• Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.
• Set-up transaction types, invoices, guarantees, deposit, and credit memos, debit memos.
• Implementation/Go-Live support & Knowledge Transfer

Environment: Oracle 8i/9i, PL/SQL, TOAD, Stored Procedures, Shell Scripts