SUMMARY:

• 12+ years of Technical and Functional Experience in design, development, support and customization of oracle applications.
• Extensive experience in Oracle Financials and Supply Chain Modules.
• Handled R12 and 11i AP, AR, GL, PA, PO, FA, CM, HRMS, OM, INV, BOM, WIP, Install Base, Sales Contracts and Service Contracts Modules.
• Expertise in Implementation, Upgrade and Production Support Projects using AGILE/SCRUM Methodologies.
• Expertise in P2P and O2C processes.
• Worked as a Team Lead and as a Solution Architect for Onsite - Offshore Projects. Prasanna is an Oracle Certified Applications Developer.
• Full life cycle implementation experience in ORACLE Applications Release R12 and Release 11i.
• RICE: Technical Expertise in Reports, Interfaces, Conversions, Customizations, Enhancements.
• Expertise in ORACLE DB, SQL*Plus, PL/SQL, Forms, Reports, SQL*Loader, Data Loader Scripts and experience using XML Publisher Reports, Discoverer and Alert, Workflows and Concurrent Manager, OAF and Workflow.
• Expertise in Database Performance Tuning, Triggers, Procedures, Packages, Functions and Libraries.
• Hands on Experience in BI Tools like Discoverer Admin/End User Editions, XML/BI Publisher, and BI Dashboards, Views & BI Answers and OBIEE.
• Experience System Requirement Study, System Analysis & Development, Test Plan Preparation, Unit testing, System Integration testing and documentation. Interacted with the Oracle Applications end users, analyzed their business requirements and changed them to requirements, Customized and tested Oracle Applications modules.
• Experience in System Administration responsibilities such as registration of concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields in Oracle Applications.
• Experience in Development and 24/7 Production Support Projects.
• Developed Technical and Functional Specification (MD 50&MD 70) documents.
• Developed Test Cases. Conducted End User s.
• Implemented Projects as per SOX compliances.
• Good understanding on SOA and Oracle Fusion Middleware Architectures.

TECHNICAL SKILLS:

Operating Systems: Windows 9x/2000/NT, LINUX, UNIX on Sun/HP-UX OS, MS-DOS.

RDBMS: Oracle 10.7/11i (Oracle 11.5.8/11.5.9/11.5.10 ), Oracle 8i/9i/10g, MS-Access

Languages: C and C++, Java, SQL, PL/SQL.

Development Tools: Developer2000, Forms/Reports 6i/9i, Discoverer Administration, Discoverer Plus/Desktop, TOAD, SQL Plus, XML publisher, Work Flow Builder, Oracle System Administration, BI Publisher, Noetix Views, JDeveloper.

Networking: TCP/IP, FTP, TELNET, and HTTP.

Utilities: SQL Loader, UNIX Scripts.

Version Control Tools: KINTANA Mercury IT Governance Suite, PVCS, Microsoft Visual SourceSafe

Project Management Tools: MS Visio.

WORK EXPERIENCE:

Confidential

Sr. Consultant

Responsibilities:

• Designed and Developed Check Print Report from R12 Payables using XML/BI Publisher for
• Designed and Developed E-text Templates for Positive Pay File/ACH/WIRE Payments for
• Created Reports using XML/BI Publisher. Oracle reports were developed in XML/BI Publisher.
• Designed and Developed Discoverer Reports and Administered Discoverer - Several Ad-hoc Reports were developed (Around 72 for modules like GL, AP, AR, PO, INV) for Users according to their request. Created Business Areas. Migrated EULs and Business Areas and Folders from Discoverer 9g to 10g.
• Converted reports from 11i to R12. Finance Reports like AR Aging Report and AP Trial Balance Reports were modified and converted to Discoverer Reports. PO Reports like Open PO Report by Buyer/Cost Center, Uninvoiced Receipts Report Were customized and also converted into Discoverer.
• Designed and Developed Conversion programs for Suppliers and AP invoices. Developed Shell Scripts for the Conversion Programs.
• Designed and Developed Contractor Workflow Notification workflow for management of contractor’s
• Supported Production environment for the various Day-to-Day Operations in Finance, HRMS Payroll modules. Supported Conversions and Interface Programs. Interface Programs got feed from external systems like PEOPLE SOFT.
• Led team of developers on various enhancement requests.
• Customized OAF pages in ISuppliers.
• Developed WEB applications using Oracle APEX 3 and 4. Upgraded APEX applications from APEX version 3 to 4.1.
• Developed BI Publisher Reports in 10g and 11g. Migrated BI Publisher Reports from 10g to 11g.
• Customized Oracle Reports 10g.

Confidential, NY

Sr. Consultant

Responsibilities:

• Designed and Developed reports in XML/BI Publisher - Pick Slip Report, AR Invoice Print and AR statement reports.
• Designed and Developed Purchasing Workflows.
• Customized OAF pages in Iprocurement.
• Developed Packages to extract data from 3rd party applications.
• Supported Production environment for the Day-to-Day Operations in Financials Environment.
• Designed and Developed Objects with SQL, PL-SQL. Developed Concurrent Programs.
• Designed and Developed PL/SQL programs to load the assets from the acquired company into existing Oracle HR and FA system.
• Supported Production environment for the various Day-to-Day Operations in HRMS Payroll modules.

Confidential

Developer

Responsibilities:

• Led Onsite and Offshore developers in various development activities. Production Support Issues: Solved Production Issues 24/7 for the End Users.
• Designed and Developed AP Invoice Interface: AP interface program was created to handle the new business logic. Imagistics wanted to change the way it was receiving invoice files in their OMD system. Instead of different Batch files for different zones (East, West and South) they wanted to receive all these in a single file.
• Designed and Developed Discoverer Reports and Administered Discoverer - Several Ad-hoc Reports were developed for Users according to their request. Created Business Areas.
• Designed and Customized Reports in XML Publisher - Orders on Hold Report, Picking Slip Report& Order Status Report and AR Statement Report and AR Invoice Printing Reports and List of Available Sales Contracts, Order Status Report and Backlog Orders Report. Supported Workflow Issues.
• Developed Alerts, OAF customizations and Personalization for various business requirements.