SUMMARY

• Certified Professional with 8+ years of experience in functional and technical aspects of Oracle Applications.
• Implementation and technical expertise in Oracle Applications 12i/11i which includes General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Inventory (INV), Purchasing (PO), Shipping, Order Management (OM), Service Contracts, Fixed Assets (FA), E - Business Tax, Customer Data Hub (CDH), Warehouse Management Systems (WMS), Project Accounting (PA), Service Contracts (SC), Installed Base, Advanced Pricing, iSupplier, iProcurement and iExpenses modules.
• Good Knowledge on Order To Cash (OTC), Procure To Pay (PTP) and Quote To Cash (QTC) process.
• Good Knowledge on Trading Community Architecture (TCA).
• Strong technical development skills on RICEW components (Reports, Interfaces, Customizations, Extensions and Workflow)
• Experience in Application System Administration like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, printers and providing support to business users for any technical and functional issues.
• Upgrading oracle systems to R12.
• Strong experience on Oracle Applications Frame Work (OAF).
• Strong programming knowledge in creating SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers and API.
• Exposure to UNIX shells scripting.
• Experienced in Data Mapping, Data Conversions and Interfacing.
• Experience working on Approval Management Engine (AME).
• Very good knowledge on interface programs to import data and convert data from legacy systems.
• Experience in designing and developing project plans for complete SDLC from gap analysis to post production support.
• Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation.
• Extensively worked on Oracle Workflow 2.5, Discoverer 4i/ 10g, Reports 4.5/6i/9i/10g, XML Publisher and Forms.
• Customizing Oracle applications with Custom.pll library to create new functionality to the application.
• Experience in using the tools like TOAD and SQL Navigator for Ad-Hoc Query development and database objects creation.
• Provided support for SIT (System Integration Testing), UAT (User Acceptance Testing) and Production Support.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request/ Service Request) with oracle support, managed and monitored TAR’s for several P1 issues.
• Good expertise using oracle software for applications design, development in a single and Multi-Org, Multi-Currency environments.
• Extensively worked on AIM (Application Implementation Methodology) documents like MD50, MD70 and MD120.
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual.
• Demonstrated good leadership skills with inspirational attitude with result oriented approach.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications R12 & 11i

Oracle Apps Modules: GL, AP, AR, FA, PO, Quality, WIP, BOM, MFG, INV and OM System Administrator, AOL

Oracle Apps Business Cycles: P2P, O2C, DropShip and Back-to-Back cycles.

Oracle Products: Oracle 9i, 10g, 11g, Reports, Forms, Discoverer, XML Publisher and Workflow Builder.

Programming Languages: SQL, PL/SQL, Java

Web Technologies: HTML, DHTML, XML, Java Script.

OS: MS-DOS, Windows 95, 98, NT, 2000, 2003, 2012 Server, XP, LINUX.

Others: TOAD, Putty, SQL*Loader, WinSCP, Microsoft TFS

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Oracle R12 Techno Functional Consultant responsible to work on PTP and OTC RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components, New Enhancements and Handling P1-P4 IBM Remedy Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications 11i and R12 Oracle Applications Finance (AP, AR, GL, CM and SLA) and SCM Modules (PO, INV, WIP, BOM, WMS, ASCP, OM, Shipping).
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Developed project plans and determine necessary resources, manage project tasks and timeline, and ensure delivery of necessary system configuration or specifications documentation.
• Developed Interface for the Standard Items of Sales Orders Import in OM.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Involved in entering transactions like Regular Orders, Inter Company Invoicing, Regular Invoicing, Invoicing with Rules and different methods of Receipt Processing and application in OM.
• Worked on Revenue Recognition of AR for the enhancement of Revenue accounting engine.
• Using OM Define sales order, calculate the price of items on order lines, reserve & pick items from INV, ship items and send information to an AR.
• Implemented the Payables Open Interface. Activities involved creation of Loader File, importing Invoices into the interface tables using SQL*Loader and then using Payables Open Interface to import the data into the Base tables.
• Developed a Supplier Conversion to load Suppliers data into Oracle Supplier base Tables by loading the data and validating the data using PL/SQL and then loading into the vendor information tables.
• Developed Vendor Conversion Reconciliation Report for the Conversion Process
• Involved in the development of Purchase Order interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Designed and developed a custom PO Output for Communication Report for the Standard, Blanket, Blanket Release and Contract Purchase Orders according to the business requirements by customizing Standard XSL-FO style sheets.
• Designed MD70 Technical Design Document, Development for PO Requisition Work Flow Approval Management Engine (AME).
• Developed Custom Self Service Page for iexpenses using Oracle Applications Framework (OAF).
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Customized the Oracle Standard Check Template according to the business requirements and made required setups for Check Printing. Changed and fine-tuned the template to generate checks by placing MICR font, Digital Signature on the preprinted watermark paper.
• Designed and developed custom packages, triggers and procedures.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Personalized standard Oracle forms using forms Personalization according to the business requirement.
• Assisted with user testing of reports, developing and maintaining quality Procedures, and ensuring that appropriate documentation is in place.

Environment: Oracle Applications 11i and R12 FIN and SCM Modules (GL, AP, AR, INV, PO, WIP, BOM, CE, CST, Shipping, iprocurement, iexpenses), Project Accounting (PA), Warehouse Management Systems (WMS), E-Business Tax, OAF (Oracle Application Frame Work), Customer Data Hub (CDH), Service Contracts, Installed Base, PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

Confidential, San Francisco, CA

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Oracle R12 Techno Functional Consultant responsible to work on PTP and OTC RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components, New Enhancements and Handling P1-P4 JIRA Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules (Account Payables (AP),Purchasing (PO), Account Receivables (AR), Project Accounting (PA), Service Contracts (SC), Cash Management (CE), Fixed Assets (FA), General Ledger (GL), Inventory (INV), Order Management (OM), iprocurement and iexpenses).
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Designed MD70 Technical Design Document, Development for MOPUB AP Supplier, Supplier Sites and Banks Conversion to R12.
• Designed MD70 Technical Design Document, Development for MOPUB AP Invoices Conversion to R12.
• Worked on development of Conversion and Interface packages to extract the legacy data related to projects, projects customers and tasks and to validate and import them into oracle.
• Designed, documented and developed staging tables, conversion routings, custom PL/SQL API’S for converting project, tasks and expenditure in Project Accounting (PA).
• Developed Conversion Programs to import Customers into Oracle Order Management using Trading Community Architecture (TCA) API’S.
• Supported with Service Contract Conversion which handles Sales Order Creation with Service Lines and the integrating order with service contract.
• Developed Account Receivables (AR) Invoice Integration including Adjustments and Receipt Integration from legacy applications to R12.
• Developed Account Receivables (AR) Customer Integration (Party, Party Sites, Party Contacts, Accounts, Account Sites and Site Uses) between Sales Force and Oracle R12.
• Involved in designing MD50, MD70 Functional and Technical Design Document, Development for Purchase Requisition Work Flow Approval Management Engine (AME) Process.
• Modified existing logic and customized receiving notification for PO Confirm Receipts Work Flow.
• Modified existing PO Account Generator Work Flow to derive charge account based on expense account rule.
• Developed Custom Self Service Page for iexpenses using Oracle Applications Framework (OAF).
• Involved in Planning and implementing data conversion methodology and programs using PL/SQL to bring Installed Base (IB) instances (software licenses) and Service Contracts (SCs) (service agreements and maintenance) from a legacy system into the Oracle 12i application.
• Developed Interface to Import On hand Quantity for Inventory (INV) Items in Oracle EBS.
• Developed Interface to Move On hand Quantity from one Sub Inventory and Locator to another.
• Designed and developed a custom PO Output for Communication Report for the Standard Purchase Orders according to the business requirements by customizing Standard XSL-FO style sheets.
• Developed Custom Fixed Assets (FA) RDF Reports Asset Additions, FA Cost Adjustments, Confidential FA Detail Register, Confidential FA Register Reports.
• Worked on Unix Shell Scripting for Code Deployment of Packages, Procedures, SQL Files, Reports and LDT files.
• Designed and developed custom packages, triggers and procedures.
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Personalized standard Oracle forms using forms Personalization according to the business requirement.
• Assisted with user testing of reports, developing and maintaining quality Procedures, and ensuring that appropriate documentation is in place.
• Tested and fixed the bugs in exiting forms and reports.
• Facilitate CRP (Conference Room Pilots), SIT (System Integration Testing), and UAT (User Acceptance Testing).
• Developed custom DB objects and AOL objects t for the project.

Environment: Oracle Applications 11i and R12 FIN and SCM Modules (GL, AP, AR, INV, PO, WIP, BOM, CE,CST, Shipping, iprocurement, iexpenses), Project Accounting (PA), Warehouse Management Systems (WMS), E-Business Tax, OAF (Oracle Application Frame Work), Customer Data Hub (CDH), Service Contracts, Installed Base, PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

Confidential, Palo Alto, CA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Oracle R12 Techno Functional Consultant responsible to work on PTP and OTC RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components, New Enhancements and Handling P1-P4 JIRA Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules (Account Payables (AP),Purchasing (PO), Account Receivables (AR), Project Accounting (PA), Service Contracts (SC), Cash Management (CE), Fixed Assets (FA), General Ledger (GL), Inventory (INV), Order Management (OM), iprocurement and iexpenses).
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Designed MD70 Technical Design Document, Development for MOPUB AP Supplier, Supplier Sites and Banks Conversion to R12.
• Designed MD70 Technical Design Document, Development for MOPUB AP Invoices Conversion to R12.
• Worked on development of Conversion and Interface packages to extract the legacy data related to projects, projects customers and tasks and to validate and import them into oracle.
• Designed, documented and developed staging tables, conversion routings, custom PL/SQL API’S for converting project, tasks and expenditure in Project Accounting (PA).
• Developed Conversion Programs to import Customers into Oracle Order Management using Trading Community Architecture (TCA) API’S.
• Supported with Service Contract Conversion which handles Sales Order Creation with Service Lines and the integrating order with service contract.
• Developed Account Receivables (AR) Invoice Integration including Adjustments and Receipt Integration from legacy applications to R12.
• Developed Account Receivables (AR) Customer Integration (Party, Party Sites, Party Contacts, Accounts, Account Sites and Site Uses) between Sales Force and Oracle R12.
• Involved in designing MD50, MD70 Functional and Technical Design Document, Development for Purchase Requisition Work Flow Approval Management Engine (AME) Process.
• Modified existing logic and customized receiving notification for PO Confirm Receipts Work Flow.
• Modified existing PO Account Generator Work Flow to derive charge account based on expense account rule.
• Developed Custom Self Service Page for iexpenses using Oracle Applications Framework (OAF).
• Involved in Planning and implementing data conversion methodology and programs using PL/SQL to bring Installed Base (IB) instances (software licenses) and Service Contracts (SCs) (service agreements and maintenance) from a legacy system into the Oracle 12i application.
• Developed Interface to Import On hand Quantity for Inventory (INV) Items in Oracle EBS.
• Developed Interface to Move On hand Quantity from one Sub Inventory and Locator to another.
• Designed and developed a custom PO Output for Communication Report for the Standard Purchase Orders according to the business requirements by customizing Standard XSL-FO style sheets.
• Developed Custom Fixed Assets (FA) RDF Reports Asset Additions, FA Cost Adjustments, Confidential FA Detail Register, Confidential FA Register Reports.
• Worked on Unix Shell Scripting for Code Deployment of Packages, Procedures, SQL Files, Reports and LDT files.
• Designed and developed custom packages, triggers and procedures.
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Personalized standard Oracle forms using forms Personalization according to the business requirement.
• Assisted with user testing of reports, developing and maintaining quality Procedures, and ensuring that appropriate documentation is in place.
• Tested and fixed the bugs in exiting forms and reports.

Environment: Oracle Applications 11i and R12 Finance (AP,AR,PO,GL,CE, Shipping), iprocurement, iexpenses, Fixed Assets (FA), Enterprise Asset Management (EAM), WMS, Installed Base, Service Contracts, Customer Data Hub (CDH), Bill of Material (BOM), Cost Management (CST), Global Consolidation System (GCS), Advanced Global Intercompany System (AGCS), Sub Ledger Accounting (SLA) and SCM (OM, INV), PL/SQL, EDI, OAF (Oracle Application Frame Work), TOAD, XML/BI Publisher, SQL Plus, SQL Loader, Discoverer Reports, Form Personalization, Oracle Reports 10g, Work Flow Mailer, UNIX Shell scripting.

Confidential, Atlanta/Raleigh, NC

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Oracle R12 Procure to Pay (PTP) Track Lead responsible for mentoring 6 team members, scheduling daily status call and tracking the PTP RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components.
• Highly responsible in Coordinating with Project Manager, Business Leads and Functional Owners to gather requirement for all RICEW Components.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications 11i and R12 Procure to Pay Modules (AP,PO, Cash Management (CE), iprocurement and iexpenses).
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Responsible for Encryption, Decryption and Transmission of Secure File Transfer from Oracle Applications to Trading Partners and vice versa.
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Designed MD70 Technical Design Document, Development for PO Requisition Work Flow Approval Management Engine (AME).
• Designed MD70 Technical Design Document, Development for Credit Memo Approval with Approval Management Engine (AME).
• Developed Custom Self Service Page for iexpenses using Oracle Applications Framework (OAF).
• Involved in the development of Vendor interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Developed Vendor Conversion Reconciliation Report for the Conversion Process
• Involved in the development of Purchase Order interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Designed and developed a custom PO Output for Communication Report for the Standard Purchase Orders according to the business requirements by customizing Standard XSL-FO style sheets.
• Customized the Oracle Standard Check Template according to the business requirements and made required setups for Check Printing. Changed and fine-tuned the template to generate checks by placing MICR font, Digital Signature on the preprinted watermark paper.
• Developed Purchase Order Conversion Reconciliation Report for the Conversion Process
• Worked on Enterprise Asset Management - EAM Work Order Scheduler Report, EAM Weekly Schedule Report.
• Involved in Planning and implementing data conversion methodology and programs using PL/SQL to bring Installed Base (IB) instances (software licenses) and Service Contracts (SCs) (service agreements and maintenance) from a legacy system into the Oracle 12i application.
• Developed and implemented Service Contracts conversion from Eclipsys to Oracle
• Developed All Scripts Portal Sales Force (SFDC) to Customer Data Hub (CDH) Conversion which includes Party Contacts, Contact Roles and Contact Points.
• Developed User Portal SFDC to Customer Data Hub (CDH) Conversion which includes Parties, Party Sites, Locations, Party Classifications, Accounts, Contacts, Contact Roles and Contact Points.
• Designed and developed custom packages, triggers and procedures.
• Development of user interface, menus and writing PL/SQL libraries for Forms and Reports.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Developed the data audit scripts and reports using PL/SQL.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Personalized standard Oracle forms using forms Personalization according to the business requirement.
• Assisted with user testing of reports, developing and maintaining quality Procedures, and ensuring that appropriate documentation is in place.
• Tested and fixed the bugs in exiting forms and reports.
• Set up executable, concurrent programs, request sets, value sets and scheduling the jobs

Environment: Oracle Applications 11i and R12 FIN and SCM Modules (GL, AP, AR, INV, PO, WIP, BOM, CE,CST, Shipping, iprocurement, iexpenses), Warehouse Management Systems (WMS), OAF (Oracle Application Frame Work), Customer Data Hub (CDH), Service Contracts, Installed Base, Enterprise Asset Management (EAM), PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

Confidential, Sanford, NC

Oracle Applications Techno Functional Consultant

Responsibilities:

• Developed Order Import Interface to create new/booked Sales Orders in EBS
• Developed PL/SQL Packages, Procedures, Functions for validating the journals (for accrual and payment information) in the staging table and importing them into Oracle Application using the GL Open Interface and populated the base tables, which involved in creation of multiple journal entries for each type (accrual and payment) and journal import.
• Interfaced data from the Flat Files into Interface tables of Accounts Payable using SQL*Loader and executed the Payable Open Interface Import Program to generate invoices.
• Imported ITEMS from legacy system to Inventory base table MTL SYSTEM ITEMS B using the standard item import program through a custom package that validates individual records.
• Involved in developing a brand new PL/SQL Program from the existing RDF report for WIP Account Distribution Report and Material Account Distribution Detail.
• Developed Pick confirm and Ship confirm Interface using oracle API’s.
• Involved in rewriting some of the existing custom interfaces in PL/SQL to reduce the turnaround time of execution and completion of concurrent processes.
• Developed code to import costing data of items imported from flat files to Costing tables directly.
• Experience in importing requisitions from legacy system to Oracle Purchasing through Requisition Open Interface (PO).
• Involved in Open Transaction Interface to import transactions from legacy system to Oracle Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Transferred GL Account Balances from legacy system.
• Responsible for designing, developing, unit testing, implementing and maintaining the custom extensions for Oracle Applications.
• Worked on AOL to register new reports, forms, functions, and created validation sets, request sets and concurrent programs.
• Created Direct Margin Report, Fleet Expense Report, GL Inventory Reconciliation report, GL Variance by account, Trial Balance by account, Trial Balance by Departments reports, Detailed Trial balance Report, Trial balance-by account Report in FSG’s using Oracle Reports 6i.
• Involved in customization of reports in SCM Modules - PO, WIP, INV such as Printed Purchase Order Report, Material Account Distribution Report and WIP Account Distribution Report using Reports6i.
• Developed reports in Oracle inventory for comparison of available and on-hand quantities in various lots.
• Used UTL FILE facility for inbound and outbound interfaces.
• Wrote UNIX shell scripts to automate the conversion from the legacy systems and also to ftp the files to the legacy systems and to send error message notifications to the user groups.
• Implemented performance tuning in the application program to enhance the speed by utilizing Indexing SQL HINTS and Materialized Views.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.

Environment: Oracle Applications 11i FIN and SCM Modules (GL, AP, AR, INV, PO, WIP, BOM, CE, CST, Shipping), PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, UNIX Shell scripting.

Confidential, Tampa, FL

Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on upgrading Oracle systems to R12.
• Written conversion programs for GL journals, AR customers, AP invoices, PO vendors and Open PO Import.
• Developed GL Interface to load Journal data from legacy system into General Ledger. Loaded data into the staging table using Loader Program, validating the data using PL/SQL and then loading into the base tables by running Journal Import.
• Implemented the Payables Open Interface. Activities involved creation of Loader File, importing Invoices into the interface tables using SQL*Loader and then using Payables Open Interface to import the data into the Base tables.
• Developed a Vendor Conversion to load Vendors data into Oracle Purchasing base Tables by loading the data and validating the data using PL/SQL and then loading into the vendor information tables.
• Developed Customer Conversion in Receivables. Created PL/SQL procedures and functions necessary for customer record validations before loading records into customer interface tables.
• Experience with complete Order to Cash cycle (Quoting, Order Management, Inventory, Advanced Pricing, Shipping Execution, Account Receivables, Account Payables and General Ledger) and Procure to pay cycle.
• Developed Auto Invoice Interface which imports invoices into the Oracle Receivables module using SQL*Loader and PL/SQL validations.
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Customized and designed Customer wise Orders Report, Order Returns Report, Order wise Discounts Report, Pending Orders Report etc.
• Worked on Fixed Assets module by managing assets and leased assets.
• Worked on Period-End Process in Fixed Assets which includes ensuring all assets have been properly assigned, copying new asset entries into tax books and running depreciation for the corporate book.
• Strong Accounting experience.
• Worked on different Costing method that oracle supports.
• Worked on Setting up Frozen Costs, viewing and updating costs and costing for Bills of Materials.
• Developed an interface to integrate cash movements from investment system to oracle cash management system.
• Setting of a receipt class to do reconciliation in cash management (CE) and uploading bank statement for reconciliation.
• Creation on automatic receipts in AR for bank interest through auto reconciliation, creation of manual receipts.
• Worked on creating Cash Forecasting templates which helps in effective use of funds.
• Worked with Administration and desktop Edition of Oracle Discoverer. Involved in creating business areas, user views, custom folders and material views for reporting using Oracle Discoverer 10g. Generated ad-hoc reports in end user layer.
• Created and Customized Reports in AR, AP, GL, PO using Oracle Discoverer 10g, Oracle Reports 6i and XML Publisher 5.6.3.
• Customized CUSTOM.pll to fulfill critical business requirements avoiding form template development
• Used Template.fmb to customize the various forms in all modules.
• Developed and customized various Reports like Customer Summary Listing, Invoice Report, Prepayment Status, Invoice On-Hold Reports and Invoice Aging Report.
• Developed Oracle Workflow with iExpenses to automatically route expense reports for approval, and enforce reimbursement policies.
• Used AOL and System Administrator modules for registering the developed and customized reports. Also used features like Descriptive Flex fields, LOV’s, Value Sets, Concurrent Programs, Standard Request Submissions (SRS) and Parameters in the process of development.
• Modified existing codes and developed oracle report, PL/SQL Packages to perform certain specialized functions/enhancements on oracle application as specified by the user.
• Wrote Technical Documentation for conversions and customizations.

Environment: Oracle Apps 11.5.10/R12 (Technology: Order to Cash (AP, AR, GL, OM, Shipping), PO, INV, CE), E-Business Tax, Fixed Assets (FA), iExpenses, Oracle 10g Database, SQL Navigator, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, Discoverer 10g, UNIX Shell scripting, XML/BI Publisher 5.6.3.

Confidential, Sunnyvale

Oracle EBS Techno Functional Consultant

Responsibilities:

• Customized and Developed the Quote to sales agreement process and create the new price list based on quote process dynamically.
• Developed the Payable interface process using Web ADI for purchasable and non-purchasable items.
• Customized Blanket/ROM Release process based on the client business needs.
• Developed the Lot tagging form and calling standard order form using ZOOM functionality.
• Worked on XML Bursting program to send emails and FTP the PDF files.
• Developed Turnkey Engine process customized standard procure to pay process to meet the client requirements.
• Developed Turnkey Rejection form to project the rejected Purchase orders based on client requirement.
• Implemented Advanced Global Intercompany (AGIS) for Subcon intercompany process.
• To in corporate Subcon intercompany Key Automation process customized standard process and developed custom objects to meet client requirement.
• Developed the multiple process using Standard API’s like Inter org transfer, DOT, Miscellaneous issue, receipts and internal order import.
• Worked on upgradation process from 11. .1.3, Retro fit 11i objects code to make sure should not disturb exiting functionality and maintain the 12i standards.
• Critical process design and validations in Procure to Purchase cycle
• Use of SQL * loader utility to load data from legacy system to interface.
• Involved in customizing reports and interfaces.

Environment: Apps Supporting Release R12 (12.1.3), 11i (11.5.10.2), Finance (FIN) and Supply Chain Management (SCM) Modules: PO, OM, INV, AP, AR, CE, Shipping, SQL, PL-SQL, Forms 6i, and Reports 6i, SQL plus, Web ADI and UNIX Shell script.

Confidential, Fairburn, Atlanta

Oracle Applications Technical Consultant

Responsibilities:

• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec)
• Created the new concurrent program to translate the standard accounting entries into the required accounting entries for Reporting set of books.
• Designed and Developed the AR auto-invoice interfaces.
• Developed the AR Receipt (Lockbox) interface.
• Designed and developed the General Journal Interface program.
• Developed the GL Extract Program.
• Developed the AP Invoice Interface.
• Developed the Purchase Requisition Approval Workflow.
• Designed, developed and tested Oracle PL/SQL packages, stored procedures, functions and triggers to translate the accounting entries into the required entries.
• Used AOL and System Administrator modules for Registration of Developed and Customized reports.
• Developed reports using Oracle Reports and XML Publisher.

Environment: Oracle Applications 11.5.10, GL, AP, AR, CE, PO, SQL, PL/SQL, Workflow, UNIX, TOAD, Windows XP.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Implementation and customization of Oracle FIN and SCM Modules - AP, INV, OM, PO.
• Responsible for Item Interface and material transactions in INV and also Currency, calendar, Key Flex Fields, Descriptive Flex Fields, Profiles, Value Sets and Lookups.
• Developed Load statements (control files) for SQL*Loader to load legacy data from flat files in to oracle tables.
• Implemented Pl/SQL Stored Procedures to load data from staging tables to interface tables.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed interface for loading supplier invoices from various sources.
• Developed Auto invoice program for loading customer invoices.
• Responsible for Month Close, Quarter close process for General Ledger.
• Working with oracle support to resolve TAR and performance issues.
• Provided support for Data conversion from legacy system into oracle.

Environment: Oracle Application 11.5.10 Finance and SCM Modules (AP, INV, OM, PO), Oracle 9i, Oracle Reports/Forms 6i, TOAD, UNIX Shell Scripts, PL/SQL, SQL Loader.