SUMMARY:

• 8 years of progressive industry experience in requirements gathering, analysis, design, implementation, testing, upgrade, support and documentation of Oracle Financials (R12/11i).
• Good understanding of Business Process Flow Analysis and Business Modules (Accounts Payables (AP), Purchasing (PO), Inventory(INV), General Ledger (GL), Sub Ledger Accounting (SLA), Project Accounting (PA), Cash Management (CE), Internet Expenses (IE), Order Management (OM), Bill Of Materials (BOM), Fixed Assets (FA) and Human Resources (HR)).
• Proficient in functional knowledge of P2P (Procure to Pay) and O2C (Order to Cash) processes and end to end cycles of Oracle Applications E - business Suite.
• Good hands on in developing and implementing Oracle EBS customizations.
• Experienced in data conversions and migrations using interface tables and APIs from Legacy systems to Oracle Ebusiness Suite R12.
• Good knowledge with statistical reporting analysis and documentation.
• Proven efficiency in developing RICEW (Reports, Interfaces, Conversions, Enhancements (or Extensions) and Workflow) and Alerts.
• Well experienced in the preparation of Standard Operating Procedures specific to client’s business process.
• Good acquaintance with planning, preparation of test plans, test scripts, test cases and training end users.
• Experience in identifying and assisting implementation of new processes for efficient flow of work of various departments.
• Expertise in AIM methodology to enrich project management and documentation processes.
• Good experience in code reviews, integration and end-user support.
• Excellent analytical, problem solving, work ethics, communication, inter-personal and presentation skills.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, Web PL/SQL, HTML, UNIX shell scripting.

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

Reporting Tools: Oracle Reports Developer 10g, Oracle Forms builder 10g, Oracle Discoverer, BI publisher, MS Excel, Stone River Tracker.

Tools: Toad, SQL Developer, SQL * Plus, SQL Server Management Studio, SQL*Loader, Data Loader, Winscp, Microsoft Office Suite, G-Suite.

PROFESSIONAL EXPERIENCE:

Confidential

Senior EBS Techno Functional Analyst

Environment: Oracle Applications 12.1.3, AP, PO, INV, GL, OM, CE, PA, Internet Expenses, AOL, UNIX, pl/sql, reports 10g, Forms 10g.

Responsibilities:

• Integrate Global Vendor Portal (GVP) with Oracle Applications R12
• Created business process design documents and functional specification documents for interfacing Global Vendor Portal (GVP) with Oracle EBS R12.
• Identified business needs and performed GAP analysis.
• Worked on Approval Management Engine (AME), customizing PO and AP workflow, approval groups and assignments for designation of authority business process in Oracle Financials (12.1.3).
• Prepared test cases TE-020,030,040 for all the financial modules and played a significant role in system integration testing.
• Developed consolidation and reconciliation reports as well as customized seeded reports in PO, AP, INV, GL and PA modules.
• Created custom templates to upload items, prices and item categories.

Confidential

Oracle Techno Functional Consultant

Environment: Oracle Applications 12.1.3, AOL, UNIX, pl/sql, reports 10g, Forms 10g, BI Publisher, GL, AP, CE, PO, INV, OM, Internet Expenses and Project Accounting.

Responsibilities:

• Handled conversion efforts
• Vendors
• Items
• Purchase Orders(Open Purchase Orders)
• Requisitions(Open PR’s)
• Projects and Tasks
• HR Locations
• Manufacturers
• Created business process design documents MD050 functional setup documents, MD070 technical design documents and BR100 configuration and set up documents.
• Worked on interfaces to push changes from Oracle Financials to CATS in a timely manner.
• Worked on interfaces in Oracle EBS to integrate Inventory transactions originating from CATS.
• Install Transactions
• InterOrg Transactions
• PO Receipts
• PO Returns
• Site Returns
• Active participant in cut-off/shut down activities.
• Developed reconciliation reports for CATS and Oracle Financials.
• Upgrade Assessment of current business processes in Oracle 11i to provide Impact analysis on upgrading to R12
• Involved in documenting differences of architectures for upgrade releases of Oracle Financials 11i and R12.
• Involved in upgrade activities of current business processes (11i) to R12.1.3 (AP, PO, GL, PA, INV, OM, and CE).
• Developed pre-migration validation package to capture foreseen AP, GL and PO migration errors.
• Migrated AP, GL, PO, PA, INV, OM, and CE customized interfaces and reports to Oracle Financials R12 release.
• Tested the Standard ERP Functionality and XO specific business functionality in Oracle R12 during upgrade.
• Involved in pre and post upgrade production validation testing for financial and supply chain modules.
• Involved in System Integration Testing and supported UAT.
• Provided end user trainings and transition on newly upgraded Oracle applications.
• Involved in requirements gathering from business users for AP Invoices Interface and Supplier/Banks Interface, GL interface, PO and Receiving Interface and Material Transactions interface.
• Worked on Procure to Pay process and module integrations of AP, PO, INV, PA, OM, CE and GL modules.
• Part of team that implemented COSTING solution that suits XO needs.
• Customized cost calculations.
• Worked on APIs in AP, PO, INV and GL modules.
• Carried out Unit testing execution for each business process and full UAT testing Cycles with issue logs involved in providing cost effective resolutions, alternative solutions and workarounds without impacting cross functional application functions.
• Implemented the approved solutions as part of improvement of business processes
• Worked on interfaces to feed data to EDI (Electronic Data Interchange) for purchase order feed
• Handled proper flow of data through SOA to outside systems(feeder system being Oracle Financials)
• Developed data migration scripts and PL/SQL stored procedures.
• Provided production support to troubleshoot and fix bugs.
• Support for Month End Close/Quarter Close/Year End Activities.
• Part of functional and technical team in integrating Vertex tax solution for AP module.
• Involved in customization of forms using CUSTOM.pll.

Confidential

Oracle EBS Developer

Environment: Oracle Financials 11i, UNIX, pl/sql, Reports, Workflow, PO, AP, GL, INV, OM.

Responsibilities:

• Analysis of current system by interacting with business and functional team.
• Worked with functional and technical team members for integrating AP, PO, GL and INV modules.
• Developed conversion and interface programs for AP, PO, GL and INV modules.
• Worked on month end accrual programs.
• Developed new reports for AP, PO, GL and INV modules.
• Created and modified wrapper programs to call the custom Pre-Order import, Order Import, Post-order import, Order validation and auto booking programs with necessary validations.
• Developed pl/sql packages, reports, valuesets, triggers, tables, indexes, synonyms, sequences and concurrent programs.
• Developed pl/sql code for generation of B2B messages, error messages, exception handling and relevant messages in the log files.
• Recipient of Superior Solution Innovation Award for ‘Delegation of Authority’ project for Verizon integrations.
• Spotlight award for outstanding work on XO to Verizon financial data conversion project
• Generated reports for approximately 4, 00,000 assets for Depreciation Reporting Process.