Summary:

• Over 8 years of professional experience as a Techno-Functional consultant in Oracle EBS Applications R12/11i with comprehensive knowledge through all phases of software development lifecycle right from requirement analysis to maintenance of a project.
• Functional and Technical expertise in Oracle Application modules such as Payables, Receivables, Cash Management, General Ledger, Order Management, Purchasing, Inventory and iProcurement.
• Experience in preparing Technical design and Test Case documents using AIM methodology.
• Good experience in Order-to-Cash, Procure-to-Pay and Inventory business process flows.
• Good understanding of new SLA process by R12
• Comprehensive technical experience in Oracle Applications tools like Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i,Oracle Workflows, Oracle Discoverer, Oracle XML Publisher.
• Extensive technical experience in Oracle SQL 11g/10g/9i, Oracle PL/SQL 11g/10g/9i and UNIX Shell scripting.
• Hands on work experience in Oracle 11g and good knowledge on Oracle 11g new features.
• Worked extensively on Business Events, Processing Constraints and AOL features like Concurrent Programs, Responsibilities, Profile Options, Functions, Menus, Alerts, Request Sets flex fields and Value Sets.
• Technically proficient in RICE components Reports, Interfaces, Conversions, Extensions .
• Experience in working with Oracle Utilities like Oracle JDeveloper 11g/10g/9i, SQL Developer, SQL Loader, UTL FILE Package and Interfaces.
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers, Views, Indexes and other database objects using SQL and PL/SQL.
• Exposure to Service Oriented Architecture SOA /BPEL.
• Proficient in tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, SQLTRACE AND TKPROF.
• Working closely with end-users/clients through complex problems and providing a fix.
• Pro-active in identifying areas of improvements and work to finding solutions that meet the business needs of the customer.
• Good understanding of Database designing, ER diagrams, DFD.
• Very good work exposure on UNIX and Linux environment.
• Excellent analytical and problem solving skills quick learner, self starter and can work well in team environment with minimum supervision.
• Good verbal and excellent written communication skills with ability to relay technical information to non-technical staff and fellow developer.

Technical Skills:

Professional Summary

Confidential

Role:Techno-Functional Consultant

Responsibilities:

• Participated in Design/Development of customized application which is integrated with the modules like Account Receivables, Account Payables, Order Management, Oracle Service Contracts of Oracle Application.
• This customization enables various skillful parties Invoice Administration Team, Customer Care Center etc in RICOH internally to monitor, correct/adjust credit memo or debit memo.
• Worked on modifying the forms as per the business requirements to ease the tasks of several teams to correct and resend the error free invoices to the customers.
• Involved in requirement analysis, Preparation of functional design documents, Design and development, stakeholders interactions, Offshore coordination, Reviewing/Testing.

Environment:

• Oracle Applications Release 12, Oracle 11g, AR, AP, OM, Service Contracts, SQL Loader, TOAD, Forms, UNIX, OAF, Eclipse IDE , Java, J2EE, JDeveloper.
• Confidential Role: Techno-Functional Consultant

Responsibilities:

• Development/Customize the RICE components like Reports in Oracle E-Business Suite Applications R12 and Custom application which is integrated with Oracle Applications to get the output as per requirement.
• Developed staging tables, conversion routines and PL/SQL API to load the Open Legacy Purchase Orders PO , Open Sales Order OM and Suppliers AP from legacy system.
• Documentation of all RICE objects, like preparing technical design, test cases, MD120 as per AIM methodology.
• Written an API for Converting the Invoice Payments AP and was able to convert all the Historical Invoice Payment History into Production.
• Responsible for converting the entire Historical Purchase Orders PO using Import standard Purchase Orders into Production.
• Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Developed PL/SQL Procedures for Customer interface using TCA in R12 Accounts Receivables according to Client Requirements.
• Bug Fixing And providing Support to RICE components.
• Invoked standard API's within custom packages for creating and updating Customer, Sites and Contacts.
• Developed custom PL/SQL API's for converting Projects, Tasks, and Expenditure types from legacy system Mainframe to Oracle Applications.
• Wrote custom PL/SQL API's for converting Sub processes in Procure to pay P2P like Purchase Requisitions, Purchase Orders, Accounts Payable, and Managing invoice, Supplier Payment.
• Designed, developed and documented an Inbound interface for AP Invoices from windows based applications from 11i to R12.
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Involved in implementing iSupplier Portal that supplier can view orders, notifications, invoices and their status.
• Responsible for the deliverables of the RICE team Reports, Interfaces, Conversions and Extensions .
• Responsible for running the Open Interface to import data from OM interface tables into the base tables.
• Implementation of Financial modules GL, FA and CE in R12 version.
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Developed a custom report to daily list all the rejected invoices based on the interface table.
• Worked to check the accuracy of Accounts Payable AP with General Ledger by running AP Trial Balance Report, posted invoice register report, posted payment register report and Unaccounted Transaction Report.
• Developed the Items Import program, which does all the necessary validations before populating interface tables of Inventory Module.
• Created and developed complex Discoverer reports by communicating and interpreting end-user business.
• Developed a Report using report builder for End Users.
• Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash O2C and Procure to Pay P2P cycles.
• Mentored users on Projects Billing, project Costing, fixed assets uses and analysis and interface issues to Receivable
• Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader.
• Customized the existing workflow by adding notifications at the time of Purchase Order approval and also involved in customizing Requisition package in iProcurement modules as client requirements.

Environment:

Oracle EBS Applications R12, Oracle 10g, PO, AR, AP, GL, OM, INV, Reports 6i/10g, Forms, Discover, XML Publisher, PL/SQL, SQL Loader, TOAD, UNIX

Confidential

Role: Techno-Functional Consultant

Responsibilities:

• Developed a Custom Interface in Order Management that accomplishes Pick Release and Ship Confirm Process using APIs against the feed from WMS.
• Designed developed and documented conversion process for Open Sales Orders and Customers using TCA from ISSESS legacy system to Oracle.
• Designed and developed staging tables, SQL loader scripts conversion routines and custom PL/SQL API for converting Open Sales Orders and Customers using TCA from ISSESS legacy system to Oracle.
• Wrote functional specifications CF250 and technical specifications MD200 and conversion mapping documents CV40.
• Wrote the technical specification documents with PL/SQL pseudo code including comments.
• Developed a Custom Form Customer Controlled Ship , which allows defining different levels of controls on Customer Parts.
• Developed a Custom Form Customer Engine Model , which is used to assigns an Engine Model BOM to a Customer.
• Developed a Custom Form Product Line Sequence , which is used to assigns a Product Line to a Part.
• Developed a Custom Interface that Creates Sales Orders in Entered/Booked Status, Using Order Import.
• Customized the ZOOM functionality on Shipping Transaction Form Using Form Personalization.
• Responsible for customizing Workflow for orders by adding custom Holds for certain customers and added payment terms for the customers.
• Customized the Oracle Seeded Order Management Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.
• Developed various reports in OM like Price Override Report, Open Units and Dollar
• Report, Past Due Summary Report, Unprocessed Orders Report, Shipped Not Billed Orders Report.
• Developed Interface for the Standard Items in Inventory generating the SQL Loader scripts and PL/SQL procedures for validating and loading data into oracle tables.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Created the Technical Documents for the above objects and coordinated with the off shore development team.
• Created Shell Scripts to move the Objects from One Instance to the other Instance.

Environment:

Oracle Applications R12, Oracle 11g, PO, AR, AP, GL, OM, Reports 6i/10g, Forms, Discover, XML Publisher, PL/SQL, SQL Loader, UNIX, Shell scripting,TOAD

Confidential

Role: Technical Consultant

Responsibilities:

• Used the Custom.pll to open the Custom Form from the Zoom Button on the Create Receipts Screen in Receivables Manager
• Created a Partner Level and Influencer Level repository and history table structure on a custom customer site mapping table
• Designed, documented and Developed a Custom Interface Program which maps the SIEBEL Partner Accounts data to Oracle Customer Sites
• Designed, documented and Developed a Custom form to query the Partner Accounts data from SIEBEL and update the required Partner Accounts
• Wrote Technical MD70 design documents and Conversion Mapping Documents for various interfaces.
• Developed an interfaces from AP, AR PA to external system RAS to transfer the payments, AR transactions project expenditures, events related data.
• Developed billing nightly batch script to submit and validate various billing related requests including submit payment batch set, AR refund invoice approval, submit invoice supply costs, submit post payment process, update payroll request FC billing notification.
• Developed a host script for general FTP/SFTP related file transfers in out of Oracle system. This script reads the config file parameters and does the appropriate transfer.
• Designed, documented and Developed Novell Workflow Reprocess Interface Program which will retry any workflow process that is error
• Designed, documented and developed a Novell Tag Serial Form to enter Tag and Serial Number based on the Purchase Orders
• Modified the sales order/contract processes in OM and OKS to provide additional discounts based on the Reseller name, Reseller address, Reseller status and Influencer status
• Wrote Technical specification document and Developed a custom interface programs to update part numbers on Contracts
• Imported Payments from legacy system into Oracle Receivables using Lockbox Interface. Involved in the process of splitting the bank file to feed Auto lock box.
• Developed a Custom Form to find the status of the Contracts in the Custom Interface Program
• Designed, documented Functional and Technical Specification documents and Developed a interface to Reprice the Updated Contracts
• Created the Technical Documents for the above objects
• Created Shell Scripts to move the Objects from One Instance to the other Instance

Environment:

Oracle Applications R12, Oracle 10g, PA, AR, AP, GL, OM, Reports 6i/10g, Forms, Discover, XML Publisher, PL/SQL, SQL Loader, UNIX Shell Scripting,TOAD

Confidential

Role: Techno-Functional Consultant

Responsibilities:

• Designed, developed and documented an inbound interface for AR Invoices.
• Customization of the Lockbox hook for getting the relationship between the custom invoice number and the oracle transaction number before applying the receipt.
• Involved in production support.
• Involved in maintenance of sales representatives in CRM by end dating the old roles with new and also update the territory.
• Involved in custom consolidated billing process.
• Worked on development of custom JSP pages based on business requirements.
• Used AJAX in JSP pages.
• Worked on the conversion of data from the legacy to update both the OM and Inventory parts of the system.
• Implementation involves data from different sources to flow to Oracle E-Business Suite Applications R12 through a series of custom and standard programs to create Order, purchasing and Receivables data and complete the entire Order to Cash and Procure to pay cycle.
• Designed and developed an inbound interface for bringing the prospects and account shares from salesforce.com to Oracle.
• Worked on CUSTOM.PLL to default customer specific Price List on the Sales Order form.
• Work with DBA to migrate new objects in to production environment, Bug fix and applying Patches.
• Worked on Production ticket issues based on priority and provided regular updates to clients until resolution.
• Developed the OM custom reports in XML Publisher.
• Coordination with Oracle on SR's.

Environment:

Oracle Applications R12, Oracle 10g, PO, AR, AP, OM, INV, Reports 6i/10g, Forms, Discover, XML Publisher, PL/SQL, SQL Loader, UNIX, TOAD

Confidential

Role: Techno-Functional Consultant

Responsibilities:

• Involved in maintenance and production support of interface and reports.
• Updated to update the username integrating from Cool compliance using FND USERS PKG.
• Modified/customized AP Invoice and I-expense workflow using custom hook to meet the business requirements.
• Worked on AME approval of Invoices.
• Designed, developed and documented an inbound interface for AR Invoices.
• Personalized form AP invoice screen and FND concurrent request screens to disable, validate and submit programs.
• Developed program for loading credit card transaction for Master card into I-Expense tables.
• Developed custom reports like invoice prepayment report, undistributed liability report/extract, uninvoice receipts report to meet the business requirements using XML Publisher BI Publisher .
• Developed custom interface and reconciliation report between oracle and Maximo, used for importing and reconciling purchase orders and receipts.
• Used CRON Jobs to submit the Concurrent programs and custom Interfaces as applicable
• Interacted with the end user during production support by helping them to develop user required reports and modify the existing as per the requirement.
• Performance tuning of the PL/SQL objects and report using DB links to interact with Maximo and other system. During this process I have used trace, TkProf and Explain plans for optimization.
• Experience using advanced Oracle features like Blob's and XML's.
• Worked on Importing Asset Information into Oracle Assets Using Mass Additions in Fixed Assets.
• Developed custom alert to send notification on close/open periods, payments.
• Worked actively to trouble shoot problem and resolve production issues.
• Involved in EBS R12 upgrade analysis discussions.
• Involved in writing interface for Invoice Interface using XML data source from third party application.
• Used AOL and System Administrator modules for registering the developed and customized reports and programs.
• On site offshore co-ordination and knowledge transfer to team.

Environment:

Oracle Applications 11i/R12, Oracle 10g, PO, AR, AP, OM, FA, Reports 6i/10g, Forms, Discover, XML Publisher, PL/SQL, SQL Loader, UNIX, TOAD

Confidential

Role: Techno-Functional Consultant

Responsibilities:

• Involved in the system study and analysis of business requirements of the users.
• Working on issues related to Item import, Requisitions import, PO export, custom imports and exports of vendor data and Receipts.
• Analysis of customizations and enhancements: evaluate design, quality, stability and maintainability of custom code developed to fill gaps between standard Oracle Applications functionality and business requirements. Recommended, tested and implemented solutions as needed.
• Make changes to standard Oracle Applications views to improve the performance of PO CHANGE HISTORY form as advised by Oracle Support and involved in cloning, troubleshooting technical issues
• Provided production support for 24 x 7 Oracle E-Business Suite Applications 11.0.3 environment. Logged the Change requests in RT System to resolve user's requirements.

• Modified and validated the code to facilitate the descriptive flex fields columns in the vendor load interface. Involved in writing shell scripts to execute SQL Loader, check the data file in the working directory and make history of the data file in archive directory.
• Modified the custom PO approval workflow to prioritize the notifications so that users can identify the high severity notifications.
• Authoring SQL and PL/SQL scripts to analyze underlying data for inconsistencies and integrity issues focus on querying data associated with Purchase order lines, Requisitions, Receipts, and revision information to find data issues, create a plan to resolve the problems, and then test and implement the solution.
• Written shell scripts to ftp the files to legacy systems and to send error message notifications to the user groups.
• Monitor and manage programs in the Application Object Library that run all above processes, transfer files to and from Oracle, and have incoming files properly loaded into the Oracle Applications database Concurrent Manager .

• Prepared the summarized documents for all customizations related to interfaces and reports to bring offshore team up to speed with the standard system functionality Involved in training the offshore team.

Environment:

Oracle Applications 11.0.3, Oracle 10g, PO, AR, AP, Reports 6i/10g, Forms, Discover, XML Publisher, PL/SQL, SQL Loader, UNIX, Shell Scripting, TOAD