SUMMARY

• Over Seven years of functional & technical experience in Oracle E - Business Suite/Oracle Applications releases 11.x and 12.x.
• Experience in Oracle Applications - General Ledger, Account Payables, Federal Administrator and Purchasing modules.
• Strong understanding of R2P, P2P and O2C business cycles.
• Sound knowledge of configuring of different modules of Oracle Purchasing, Inventory, Order Management, Payables, Receivables, General Ledger and Federal Administrator.
• Expertise in Oracle R12 SLA setups for Fed Admin, AP and PO modules.
• Experienced in Sub ledger to General Ledger accounts reconciliation.
• Knowledge of Federal Accounting.
• Created various Procedures, Packages, Functions, Triggers, APIs and other database objects using SQL and PL/SQL.
• Experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, FNDLOAD, Data Loader etc.
• Proficient in using SQL Navigator, TOAD, Forms 6i/4.5 and Reports 6i/3.0/2.5 for both development and customizations as per client specifications.
• Experience in generating adhoc reports from Sub ledger and General ledger for data analysis and reconciliation purposes.
• Handled Production Support, Operations and Maintenance activities.
• Excellent Analytical skills and ability to work in a time-constrained and team-oriented environment.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite releases 11.x and 12.x (AP, AR, GL, PO, INV, OM, Fed Admin)

Languages: SQL* Plus, PL/SQL,XML, C, C++

Database: Oracle 11i/10g/9i/8i, SQL Server

Oracle Tools: SQL * Loader, SQL * Plus, SQL Developer, SQL Navigator, Toad, XML Publisher, Oracle Discoverer 10g/ 9i/4i, Developer 6i/10g (Forms 6i/10g & Reports 6i/10g)

Platform: Windows, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Oracle Financials Analyst

Responsibilities:

• Interact with business customers to understand and document their business processes and requirements.
• Drive meetings with the customer and manage the analysis through design phases.
• Create business requirements documents, system configuration documents, detailed functional design documents, test plans and test cases, user training documents and implementation documents.
• Perform gap analysis to determine e-Business suite system configuration and development changes.
• Conduct workshops to identify the change management required.
• Involved in gathering requirements for Financial Procurement Desktop (FPD), a custom procurement tool.
• Developed Generic Packages using PL/SQL to build flat files to convert data from Legacy to Oracle System.
• Configured various payment templates to process daily payments to vendors.
• Customized the existing payment format templates according to Treasury Guidelines.
• Involved in setting up user responsibilities, privileges of users, administering concurrent manager.
• Involved in migrating vendors from legacy system to Oracle Applications.
• Performed user migration from legacy system to SSP Appliance.
• Customized various Oracle Forms as per client requirements.
• Worked on Open Invoice Interface to import data from external systems. Used SQL*Loader for import into Interface tables, and PL/SQL procedures to validate and insert into Oracle Invoice Interface API tables.
• Configured Oracle SLA setups for Account Payables - Prior Year Accounting.
• Customized the existing 1099 process and 1099 Bulk file format to produce 1099 forms as per client requirements.
• Involved in Daily Payment Operations - Treasury Payments, IPAC Payments and Treasury Confirmations, Returned Payment Handling and Vendor Management.
• Provide TIER II and III Support for Operational issues encountered by customer.
• Involved in Reclassifications and Data Managements.
• Perform SF 224 monthly Statement of Difference analysis and generating control report for the same.
• Generate Expense and UDO Extracts at end of each quarter as per customer requirements.
• Work with Financial Statements Team in performing data analysis and identifying issues with data from Sub Ledger and General ledger.
• Performed various Tie-Point Analysis at the end of each quarter and year.
• Analyze and respond to Audit findings.
• Performed AP - GL Reconciliations as required.

Confidential, San Jose, CA

Oracle Financials Analyst

Responsibilities:

• Member of the core team responsible for implementing and setup of GL and AP.
• Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers.
• Defined the 1099 suppliers and the tax payment extractions for reporting purpose
• Create SQL queries against Oracle tables to troubleshoot, develop metrics, and create ad-hoc reporting as needed.
• Work with the business and development team to design and implement system modifications.
• Analysis of Business and Invoicing process for key Suppliers
• Defined Invoicing information including Payment methods, Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources
• Resolving issues assigned in timely manner
• Preparation of Test Plans and handling Functional Testing of various interfaces & reports.
• UAT and E2E Testing for P2P Cycle.
• Post implementation support and maintenance - performed successful period close activities in the newly implemented modules
• Identify and Resolve the Reconciliation issues with Sub ledgers to GL
• Create and follow up on Service Request (SR) with Oracle support.
• Prepare documentation for change management process along with impact analysis on the proposed solution

Confidential 

Oracle Applications Consultant

Responsibilities:

• Involved in current system and GAP analysis
• System configuration and testing of GL and AP modules.
• Involved in organizing workshops with the end users for requirement gathering, limitations of existing system and proposed the solutions.
• Setup suppliers, supplier sites, banks and bank transaction codes
• Set up the approval hierarchy for expense reports
• Created employee expense templates for different departments
• Involved in developing test scripts, creating user manuals and end user training
• Configured the setup for batch invoices and batch payments, multi-currency invoices and multi-currency payments to meet the requirements in AP.
• Used FND LOAD utility to migrate concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc.