SUMMARY:

• Over Ten Years of experience in Oracle Applications (ERP) in Oracle General Ledger, Payables, Receivables, Fixed Assets, Cash Management, Procurement, Inventory, and Order Management
• Ability to plan, monitor, support and deliver on time while within the budget in high pressure environments, proactive initiation and solution oriented proposition contribution
• Self - motivated and results oriented collaborative thinking, experienced in managing multiple competing priorities and tasks effectively across multiple functional tracks
• Interface & conversion mapping, data warehousing, custom ERP reporting
• Expertise in Reconciliation of Sub-ledger modules with GL
• Experience in defining Business process, risk analysis, cost-benefit analysis, base-lining acceptance criteria, deliverables
• Good Understanding of the business processes across various domains
• Expertise in creating Financial Reports with Financial Statement Generator (FSG)
• Domain experience in Finance and Accounting
• Proficient in understanding business/ customer needs and technology and possessing strong skills in research and analysis of the existing systems and suggestions to re-engineer business processes
• Expertise in Requirement gathering and GAP Analysis
• Experience in AIM Methodologies
• Good exposure in tracking and resolving application bugs via the oracle support process
• Good knowledge of database design, relational database schema, functional dependencies.

PROFESSIONAL EXPERIENCE:

Confidential - Queens, NY

Responsibilities-

• Actively involved in implementation and integration activities with modules such as- Account Payables, General Ledger, Cash Management, FA and Advance collection, Account Receivables, iReceivables.
• Automated procurement processes significantly and Leveraged Buyers work center and i-Procurement to perform daily procurement activities.
• Worked on the setups of Ledgers, Ledger Sets, Data Access Sets, Chart Of Account Design, Calendar, Secondary Ledgers, etc in Oracle GL
• Worked on the setup of the Collection Scoring Engine, Operational Data Level of Customer and Account, collector work queues, multi level strategies for different Operating Units, Strategy work node, broken promise node, delinquent node in the Advance Collection module.
• Responsible for performing the end to end testing of Advance Collections and iReceivables with AR. Designed script for Month End Process, Promo Code and Bank Handling Errors. Worked on defects, fixing it and retesting the scripts and updating the QC.
• Worked on Translation and Revaluation process in GL Module.
• Worked on Consolidation process in GL Module.
• Setting Up iReceivables.
• Setup Tasks in Oracle Applications for iReceivables.
• Define iReceivables Internal Users.
• Oracle Advanced Collections supports the ability to collect from Receivables and Lease and Finance Management invoices in the same instance. Using Oracle Lease and Finance Management, configure Oracle Advanced Collections to integrate the functionality of the two applications.
• Assisted business team to load data by using standard/customized programs.
• Provided support on general GL and AR issues.
• Developed user and system procedures, training materials, Test scripts, test plans and project plans.
• Extending the iReceivables Search.
• Worked on the Lock Box setup in Oracle AR with Bank of New York
• Worked on the Auto Invoice Setups in Oracle AR - setting up the sources, line ordering rules, grouping rules and line transaction flex field
• Worked on the Revenue Recognition process in AR module
• Worked on the TCA Setups in Oracle AR Module
• Led & coordinated tasks related to conversion and mapping of requirements from Ariett & Softrax (old system) into Oracle Financails R12.
• Actively communicated with Buyers, Controllers, Budget Managers and CFO’s, to optimize the approval workflow for requisitioning within the company.
• Created and maintained all functional design documents and Visio process flow diagrams
• Identified existing gaps, worked on solutions, and collaborated with the technical team to develop workarounds and customizations to enhance efficiency of existing business process.
• Initiated Global training sessions and walk-throughs within the application.

Confidential - Long Island City, NY

Solution Architect

Responsibilities -

• Actively involved in implementation and integration activities with modules such as- Account Payables, General Ledger, Cash Management, FA and Advance collection, Account Receivables, iExpense.
• Responsible for performing the end to end testing of Customized AR Invoice Import Programs, AR Transaction Detail Report and AR Customer Interface Program Designed scripts for each scenario specified in the MD050. Worked on defects, fixing it and retesting the scripts.
• Worked on the Auto Invoice Setups in Oracle AR - setting up the sources, line ordering rules, grouping rules and line transaction flex field
• Worked on the Revenue Recognition process in AR module
• Led & coordinated tasks related to conversion and mapping of requirements from legacy systems into Oracle Financials R12.
• Identified existing gaps, worked on solutions, and collaborated with the technical team to develop workarounds and customizations to enhance efficiency of existing business process.
• Provided support on general GL and AP issues.
• Performed cost/benefit analysis and risk assessment.
• Developed user and system procedures, training materials, Test scripts and test plans and project plans.
• Created Sandbox and UAT environments in R12 for the modules implemented.
• Initiated training sessions and walk-throughs within the application.

Confidential, Houston, TX

Oracle Finance Functional Lead

Responsibilities -

• Actively involved in implementation and integration activities with modules such as- Account Payables, General Ledger, Cash Management, FA and Advance collection, Account Receivables, iReceivables .
• Automated procurement processes significantly and Leveraged Buyers work center and i-Procurement to perform daily procurement activities.
• Worked on the setups of Ledgers, Ledger Sets, Data Access Sets, Chart Of Account Design, Calendar, Secondary Ledgers, etc in Oracle GL
• Worked on the setup of the Collection Scoring Engine, Operational Data Level of Customer and Account, collector work queues, multi level strategies for different Operating Units, Strategy work node, broken promise node, delinquent node in the Advance Collection module.
• Responsible for performing the end to end testing of Advance Collections and iReceivables with AR. Designed script for Month End Process, Promo Code and Bank Handling Errors. Worked on defects, fixing it and retesting the scripts and updating the QC.
• Worked on Translation and Revaluation process in GL Module
• Worked on Consolidation process in GL Module
• Setting Up iReceivables
• Setup Tasks in Oracle Applications for iReceivables
• Define iReceivables Internal Users
• Oracle Advanced Collections supports the ability to collect from Receivables and Lease and Finance Management invoices in the same instance. Using Oracle Lease and Finance Management, configure Oracle Advanced Collections to integrate the functionality of the two applications.
• Review and Update Receivables Lookups
• Configuring Oracle iReceivables
• Editing iReceivables Messages
• Extending the iReceivables Search

Confidential, Hilliard, OH

Oracle Financial Functional Lead Consultant

• Designed Chart of Account (COA) to provide Flexibility for Recording and Reporting Accounting Information.
• Configured Accounting Flexfield, Account Maintenance, Calendars, Currencies, Ledger and Legal Entity Setups, Data Access Sets, Document Sequences, Mass Allocations, GL Profile options and Transactions Processing.
• Configured the FSG to Create Balance Sheet and Profit Loss/Income Statements.
• Implemented iSupplier portal to View/Changes POs, Acknowledgements, Submit ASN, Create and View Invoices.
• Implemented Purchasing (PO) with 3-way match, INVENTORY, CM, Cash Management modules.
• Configured AP Financials, Payable System and Payables options, Vendors and Sites, Bank and Bank Account for Fund Disbursements.
• Implemented the Third Party Payments feature in AP.
• Created Mapping Documents for Supplier Sites, Items, OPEN PO, AP Invoices, conversions.
• Prepared Project Documentations, AS IS documents, Solution design document, BR100.
• Prepared Cutover Plan document, Monthly Closing Procedure etc.
• Used WebADI to Load Journals to the GL.

Confidential, Dallas, Texas

Oracle Financial Functional Consultant

Responsibilities:

• Worked on the entire Financials business process.
• Performed all of the setups for i-Procurement, PO, GL, Sub Ledger Accounting, Project Accounting, Project Billing, Project Costing, AP, AR, Advance Collection and i-Expense modules
• Developed several enhancements to the Business Processes on the Finance side.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary.
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Automation of Receipt Automation (Lockbox) through Account Receivables module
• Pre upgrade testing and Post upgrade production live support. Yahoo Inc successfully had 3 upgrades (Linux Operating migration, Oracle 10G database and Oracle Apps Version 11.5.9 to 11.5.10.2 upgrade).
• Support Production issues on a day to day basis including month end closure p1 issues
• Worked on conducting Conference Room Pilots (CRP) and User Acceptance Testing (UAT)
• Developed Test Scripts and Executed Test Scripts.
• Worked on Mercury Quality Center to log defects and report back to the team.
• Create a Work Item
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options