SUMMARY

• Over 10 years of experience in Oracle Applications implementation, upgrading, supporting and involved in a few full cycle implementations of several releases 11i/11.x/R12.
• Modules implemented are General ledger (GL), Account Payables (AP), Account Receivables (AR), Cash Management, Fixed Assets, Purchasing and gained expertise knowledge in the above modules.
• Experience with Flex fields - Key Flex fields, Descriptive Flex fields.
• Knowledge with Cross Validations Rules, Security Rules.
• Expertise in Consolidation, Intercompany Journals and Mass Allocation Journals.
• Experience in Data mapping of Oracle functionality with Business requirements.
• Involved in the Conversion project of Consolidation of Set of Books.
• Involved in custom AR Aging Buckets Report for client needs to show the invoice aging by Project and by Contact.
• Knowledge in iExpenses and iReceivables.
• Knowledge in Withholding Taxes, Withholding Taxes with account’s range and Zero Payment Invoice in AP module.
• Designed & developed training material and undertook training for all levels of users on new functionalities configured.
• Worked on SLA(Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction.
• Extensive experience in understanding and providing Gaap and Fit analysis
• Good at Financial Statement Generator (FSG) Reports Architecture
• Has vendor specific objective evidence experience (VSOE)
• Created users, custom menu and responsibility, key and descriptive flex-fields, request groups and request sets through System Administrator responsibility
• Strong documentation, analysis, requirement skills and good interpersonal and communication skills to work with clients and team members.
• Have a good implementation and upgrade experience from Oracle 11i to R12
• Created test scripts, business process flows, and conducted multiple testing cycles Conducted analysis focusing on the development of creative solutions delivering substantial results to clients; evaluated business needs, user requirements, and functional specifications; and analyzed and understood client strategic direction, issues, and project goals in order to deliver exemplary customer service to clients.
• Perform implementation activities including, but not limited to, requirements analysis, business process redesign, training, and end-user support.
• Involved in QA Testing process and coordinated with end users for Acceptance Testing.
• Functional responsibilities: Interfacing with users, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
• Technical activities: identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, scheduling, producing documentation, user manual to users and providing production support.

PROFESSIONAL EXPERIENCE

Oracle Financials EBS R12 Functional Consultant

Confidential, San Francisco, CA

Responsibilities:

• Gathered business requirements, participated in setups & implementation and test scenarios for Oracle Financial modules.
• Performed the setups for South Korea for AP, PO, IPROCUREMENT
• Worked on fit gap analysis
• Gathered requirements through various meeting/discussions/workshops for implementation of iSupplier Portal
• Performed testing along with other users in various instances and resolved issues
• Assisted the team in setting up EBTax partially, setting up of Chart of Account, setting up of Fixed Asset Categories, Intercompany accounts
• Prepared Test Scripts
• Prepared BR100 documents
• Prepared the Rollback Plan
• Raised SR for several issues and resolved them
• Involved in Post Production Support for Oracle Financials Modules

Environment: Oracle Applications R12.1.1 Modules (IPROCUREMENT, PO, AP & ISUPPLIER PORTAL)

Oracle Financials EBS R12 Functional Consultant

Confidential, Chicago, IL

Responsibilities:

• Gathered business requirements and defined business processes, participated in setups, and test scenarios for Oracle Financial modules.
• Performed testing for AP & GL
• Installation, configuration and setup of web ADI for journal upload and FSG reports
• Created FSG reports and templates comprising row sets, column sets and content sets for reporting purposes.
• Design and testing the custom payment form template for printing payment checks
• Configured AP, Payment Terms, Transaction Type, Tax, Auto Posting, Past-due & amp, aging
• Prepared detailed user manual for GL & AP
• Prepared Test Scripts TE40s intended for unit testing
• Raised SR for several issues and resolved them
• Provided support after Go-Live date
• Worked on BR100 document
• Involved in Post Production Support for Oracle Financials Modules

Environment: Oracle Applications R12.1.3 Modules (AP & GL)

Oracle Financials EBS R12 Functional Consultant

Confidential, Tampa, FL

Responsibilities:

• Review and revised chart of accounts for CITI to make sure that the expense as well as asset accounts are aptly put together in the appropriate commodities and mapped to CITI GL accounts
• Conduct workshops to validate commodity mapping that would in turn be used by business users/partners and/or by CITI operation purposes.
• Defined functional requirements and responsible for implementation of modules including IP/PO, AP, FA & GL.
• Gathered requirements and Prepared BR100 & MD50 for Financial Modules for New features in IP/PO, AP & FA
• Prepared Test Scripts TE40s intended for unit testing in Fixed Assets for US and Puerto Rico (Test scripts for Mass Additions, Mass Reclass, Mass Transfer, Retirements and Reinstatements with the use of forms and external files upload).
• Designed and tested end to end flow of transactions (TE060s) for US, Canada, Brazil, Japan, Singapore, Hong Kong and Great Britain.
• Raised battle stations to indicate Fixed Assets code migration issues and worked closely with development team to resolve them.
• Performed set up for Fixed Assets by setting up new categories, defining tax books and accounts (Expense, CIP, CIP Clearing, CIP Cost, Cost, Accumulated Depreciation, Gain and Loss Account).
• Suggested changes to reports to be incorporated for Account Standardization Project to suffice statutory as well as reporting requirements.
• Categorized and strategized reports into Additions reports, Reconciliation reports, Reclassification reports, Asset detail reports, Transfer reports, CIP reports, and Tax reports for additional customization in order for the reports to illustrate the changes in Chart of Accounts.
• Recommended modifications to the different forms of Oracle Fixed Assets for the information that needs to be masked/unmasked and also for the purpose of incorporating the Major-Minor category combinations and Account values.
• Suggested customizations needed for external file templates for Mass Additions, Retirements, Reinstatements and Cost Adjustments.
• Devised a reconciliation process for Fixed Assets accounts to different legacy ledgers.
• Set up SLA for Fixed Assets with the CITI customizations.
• Incorporated changes in Project accounting template to take into consideration the Capitalized and non-capitalized projects in order for the different business groups (Advertising, Travel and Expense, etc.) to track the cost for different Advertising and Promotional projects regardless of Capitalized or Non-capitalized projects.
• Created new Category Matrix for Fixed Assets as part of Account Standardization changes (Global Account Standards GAS)
• Involved in the month end closing process, generating reports and reconciliation after running the month end process.
• Responsible to figure out solutions for the errors while running the Create Accounting for Fixed Assets.
• Created a detailed training manual for IP/PO, AP and FA customizations
• Implementation of setups for AP, FA & GL
• Installation, configuration and setup of web ADI for journal upload and FSG reports
• Design and testing the custom payment form template for printing payment checks
• Configured AP, Payment Terms, Transaction Type, Tax, Auto Posting, Past-due & amp, aging
• Created and performed testing for PO and non-PO invoices
• Defined Approval assignments and approval hierarchy in IP/PO & AP
• Knowledge in Core PO and Buyers Work center Application and customized with new DFF to support the business
• Worked on CITI custom Self Service Invoice system (eInvoice)
• Revised the workflow process of eInvoice to be more intuitive for business users & for better efficiency
• Created MD50s & TE40 for eInvoice
• Performed testing for eInvoice
• Involved in General Ledger implementation for Latin American countries Honduras and Costa Rica.
• Involved in various requirement gathering sessions with in country teams. Identified statutory reporting requirements from in country team for various ledgers.
• Defined Legal Entities and chart of accounts and set up ledger in R12 Accounting setup manager.
• Defined operating unit, Inventory organization and Asset organization using organization forms.
• Defined custom cross validation rules as well as Security rules in General Ledger.
• Experienced in Defining document sequencing and Assign those sequences.
• Defined outbound maps to feed data to legacy systems.
• Educate end users on maintenance of COA and web ADI functionality. Also educated users about CITI customization like prepaid functionality and single payer concept.
• Involved in PRODUCTION check out before go live.
• Worked on Production support and helped in resolving many critical issues.
• Worked with feeds team to import the files from external systems to P2P system, process those files in P2P and send those data to respective legacy GLs.

Environment: Oracle Applications R12.0.6 Modules (IP/PO, AP, FA & GL)

Oracle Financials EBS R12 Functional Consultant

Confidential, Bellevue, WA

Responsibilities:

• Administered business requirement definition and gap analysis, and defined business processes, setups, and test scenarios for Oracle Financial modules.
• Handled the application of Oracle Financials that automated accounts payable, accounts receivables, fixed assets and cash management;
• Created FSGs comprising row sets, column sets and content sets for reporting purposes.
• Participated in the design of Chart of Accounts and did the Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.
• Trained end users in AR, AP, GL, FA and CE and also created detailed user manual.
• Created corporate book, asset categories, system controls, flexfields - asset key, location and category in fixed assets.
• Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi OU through security profile in a secured environment; liaised with other personnel to deliver first-class customer service to clients; and adhered with governing policies and procedures enforced by the organization.
• Maintained proactive interaction with clients to understand business practices in rendering assistance in system configuration; analyzed various business functions to derive benefits that would be obtained in terms of cost rationalization and management control as a result of the implementation.
• Oversaw mapping business processes to Oracle Financials modules and conducted functional analysis, requirements, definition, and Oracle Financials module configuration and testing; designed and operated financial reports through the use of Final Statement Generator (FSG) tool; and trained users on various processes, such as AP, AR, GL, and CM (Release 12) while creating a detailed user manual.
• Documented the business requirements, current and future Processes.
• Created the Responsibilities for all the ledgers and attached the Responsibilities to the Ledger.
• Worked on SLA (Sub-Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction.
• Involved in Defining Month End Close Processes. Involved in Post Production Support for Oracle Financials Modules.
• Assisted users in month end closing process, reconciliation, generating month end reports.
• Designed & developed training material and undertook training for all levels of users on new functionalities configured.
• Conducted analysis focusing on the development of creative solutions delivering substantial results to clients; evaluated business needs, user requirements, and functional specifications; analyzed and understood client strategic direction, issues, and project goals in order to deliver exemplary customer service to clients.

Environment: Oracle Applications R12.0.6 Modules (EBTax, GL, AP, AR, CE and FA), Reports 6i, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer.

Oracle Financials EBS R12 Functional Consultant

Confidential, Houston, TX

Responsibilities:

• Successfully Upgraded and Gathered requirements for upgrade and implementation of R12
• Gathered requirements and Prepared BR100 Financial Modules for New features of AP and EBTax
• Gathered requirements and Partially Implemented Financial Accounting Hub for processing Accounting for external systems
• Implemented E-Business Sales Tax forUS - Regime to Rate flow with Rules and Exceptions and Self assessment Tax
• Assisted the client with the functional aspects of upgrade from 11i to R12 in AR, AP, FA and GL from end to end process cycle, month end close and reconciliation activities
• Created and Executed the Upgrade Test Scripts for all Financial modules and integration with EBTax

Environment: Oracle Applications R12.0.4 Modules (GL, AP, AR, OM, INV, Costing, FA and EBTax).

Oracle Financial Consultant

Confidential, Miami, FL

Responsibilities:

• Responsible for the support of financial systems, including Consolidation, Inter Company journals of Oracle ERP
• Manage the monthly, quarterly and annual financial closing process in conjunction with the different support teams.
• Work closely with the region finance managers to support the system requirements of the Finance Organization.
• Responsible for the implementation of the Financials modules like GL, AP, AR & CE. The role includes all tasks from business requirements gathering to user training and go-live / ongoing support.
• Implementation of setups and configuration of Oracle Financials 11i GL, AR, AP and CE for AR Lockbox, Inter-Agency funds transfer, cash/funds position and forecasting processes.
• Configured setups of iExpense, iSupplier & iProcurement
• Setup employee user account, default expense account and expense report templates for iExpenses.
• Worked on integration of CE module with AR and AP module for reconciliation.
• Reconciling Bank Statements, Reconciliation Tolerances, Posting Amount differences within Tolerances, Changing the Reconciliation Status, Entering Reversals
• Bank Statement Error Reconciliation, Matching Bank Statement Lines with Transactions
• Worked on functional specifications and test scripts
• Provide implementation and post implementation functional support for the Oracle eBusiness Applications suite Oracle 11i.
• Conduct user trainings for financial modules and create training material for them.

Environment: Oracle E-business suite 11.5.9, 11.5.10 .2 - CE, AP, AR, GL, SQL, PL/SQL, SQL* Plus, Forms 6i/4.5, Reports 6i, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer.

Oracle Application functional Consultant

Confidential, Miami, FL

Responsibilities:

• Involved in Oracle11i Applications - Financials Implementations.
• Created the General Accounting functionality by setting up Chart of Accounts and Fiscal Calendars.
• Defined the Multiple Set of Books, Accounting Periods, automatic posting, Journal Sources.
• Translate business requirements into process definition.
• Defined the functional requirements for the technical specification.
• Involved in setting up the setups of Oracle Payables, AR, GL with MRC and GCS.
• Wrote up journals (standard and formula) for the interfaces andDefined Mass AllocationFormula.
• Defined value sets, key Flex field segments and roll-up groups with security and cross validation rules and Used ADI (General Ledger Desktop Integrator) to integrate the GL module to the Excel spreadsheet.
• Defined custom FSG reports (Financial Statement Generator).
• Involved in Design, Development, Testing and Rollouts.
• Engineered full compliance with revenue recognition policies instituting various control points and vendor specific objective evidence analysis (VSOE).
• Involved in troubleshooting and issue resolution with Oracle applications financial modules

Environment: Oracle E-business suite 11.5.9, 11.5.10 .2 - CE, AP, AR, GL, SQL, PL/SQL, SQL* Plus, Forms 6i/4.5, Reports 6i, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer.

Oracle Application functional Consultant

Confidential, Richmond, VA

Responsibilities:

• Configured/ Set-ups of GL, AP, PO, FA, CM
• Tested Sub-ledger integration for procures to pay and order to cash cycles.
• Designed segments, key flex-fields, set of books, roll up groups, parent child relation sets, and hierarchies.
• Prepared FSG reports and templates
• Produced configuration documents for Order Management, customer conversion and set up, definition of profile classes, customer types, customer categories, transaction classes, transaction types, invoicing rules, revenue recognition and finance charges.
• Helped Client with month end closing process and generating reports
• Evaluated implementation and post-implementation of internal control processes in line with end user job descriptions.
• Completed the gap analysis and functional specification analyses after requirements were gathered from users; and developed solution designs.
• Provided production support for finance, distribution and manufacturing modules.
• Performed on-site requirement analysis and developed functional specifications for the modules and customized processes.
• Responded to notifications and monitored the status of a runtime workflow process.
• Provided post-production Support to the End-Users on Standard Oracle Application modules (includes GL, AP, AR, PO, and FA) along with the Customized Oracle Apps.
• Tested various scenarios in the Development Instance for the End-user.
• Participate with project manager and other project staff in determining the nature and scope of project activities

Environment: Oracle E-business suite, 11.5. - CE, AP, AR, GL, SQL, PL/SQL, SQL* Plus, Forms 6i/4.5, Reports 6i, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer.

Oracle Application functional Consultant

Confidential

Responsibilities:

• Worked across IT teams and business units to create solutions and participate in initiatives.
• Designed invoice status, assignment of delinquent invoices to collection agencies and continuous aging within receivables.
• Configured AR, AP, Payment Terms, Transaction Type, Tax, Auto Posting, Past-due &, aging.
• Performed Testing for various operations like Creation of Journals, Posting the Journals, Reversing the Journals etc in the Testing Environment.
• Performed the Translation and Revaluation processes.
• Defined the Set of Books (SOBs) by using the respective Chart of Accounts, Accounting Calendars, Functional Currencies, and by taking the required Accounting Combinations for various Mandatory Accounts.
• Defined the Cross-Validation Rules and the Security Rules.
• Configured Payables Financial Options for defaulting Accounting Information on AP Invoices distributions.
• Defined Banks for processing Suppliers Invoice Payments and to default the GL Accounts for AP Invoice Payments
• Performed Testing on various processes like Creation of different types of Invoices, Payment processes, and the application of Prepayments against the Invoices etc. in the Testing Environment
• Setup AR Transaction types, Payment terms, Auto Lockbox, Automatic receipts to test receipts workbench.
• Designed and implemented a custom cost of Account Solutions using Oracle Workflow with Extensions to Support Segment Value Derivation based on applicable Business Rules; also designed Custom Revenue Account, Receiving Account and Inventory Account Derivation Solution to meet the financial reporting needs of the Organization.
• Load the invoices into AR by running auto invoice daily and resolved all issues for invoices generating from order/sales management.
• Defined the setups required for Auto Reversing, Auto Posting and for scheduling the Transactions.
• Responsible for configuration of Order Management, Advanced Pricing, Inventory, Purchasing, and shipping.
• Responsible for multi-organizational setup business requirements, legal entities, multi-currency functional documentation for order management implementation

Environment: Oracle E-business suite, 11.5. - CE, AP, AR, GL, SQL, PL/SQL, SQL* Plus, Forms 6i/4.5, Reports 6i, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer.

Technical Analyst

Confidential, NJ

Responsibilities:

• Responsible for mapping business processes to Oracle Financial modules and performing functional analysis, requirements, definition, ERP module configuration and testing.
• Designed Financial Reports using Financial Statement Generator (FSG) tool
• Creating new OU and responsibilities and assigning to users and Setting profiles as needed
• Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals
• Monitoring cash application process through lockbox and manual receipts
• Developed Chart of Accounts in consultation with business owner and created value sets for the accounting flexfield structure
• Developed functional documents for technical customizations
• Trained users in the AP, AR, GL & CM processes
• Fixing issues in TEST environments and Closely interacting with users for final testing before solution migration to PROD
• Developed Test Plan / Test Cases and conducted User Acceptance Testing (UAT) sessions.
• Involved in gathering and analyzing the user requirements in coordination with Business and formulate planning, budgeting, forecasting and reporting strategies.
• Performed system administrator role and created users and custom menu, responsibilities documented business processes, system design after the requirements gathering phase.