SUMMARY

• Over 8 years of professional experience as Oracle Application Technical Developer, Consultant in Oracle E - Business Suite Applications with expertise in OracleFinancials modules(GL, AP, AR and PA), Manufacturing Modules(OM, INV, Shipping, BOM, WIP, PO, MRP, Project Billing, Project Costing),Human Resources (HRMS), Service Contracts and Advanced Pricing (AP) and Distribution modules.
• Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
• Experienced in various full life cycle implementations, production support, and upgrading Oracle Applications.
• Proficient in the E-Business Suite cycles of Order to Cash (O2C), Procure to Pay (P2P), Supply Chain Management (SCM).
• Expert level experience in Oracle Forms 10g, Reports, PL/SQL, Discoverer, BI (XML) Publisher
• Excellent skills in designing and developing different types of Reports using Oracle Reports 6i, BI Publisher/XML Publisher, Discoverer 4i, SQL & PL/SQL.
• Very good experience in creating and integrating custom built Forms with Oracle Applications and in using custom.pll and template.fmb.
• Sound experience in building, customizing, and debugging Oracle Workflows in AP, AR, GL, PO, PA, INV, OM, BOM module and Approval Management Engine (AME).
• Expertise in creating messages, processes, functions and notification workflows and Customizing Workflows using Oracle Workflow Builder 2.6
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Modified standard Project Billing Extensions to generate the revenue as per the client requirement.
• Worked in various projects involving migration, conversions and customization of Oracle Applications and also integration of Financials and Supply chain modules.
• Developed Interface Programs using SQL * Loader and PL/SQL procedures to load data into the interface tables from legacy systems and writing validations before transferring data from temporary table to interface tables
• Experience in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, Shell scripting, Performance Tuning.
• Proficient in SQL, PL/SQL, UNIX, Linux Shell scripting, Perl Scripting and Oracle 10g/9i/8i.
• Experienced in Performance Tuning using Explain plan, tkprof, optimizer hints.
• Experience in debugging, testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
• Good experience in Forms Personalization.
• Expertise in using tools like TOAD, SQL Developer and SQL*Plus.
• Good working knowledge on Multi-Org and TCA architecture.
• Involved in upgrading the system from oracle applications 11i to applications R12.
• Very good experience in preparing functional and technical design MD050, MD070 documents using AIM Methodology.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Experience in using Oracle Application Object Library (AOL) features including implementation of Flex fields (Implementing Cross Validation Rules, Security rules).
• Good knowledge and experience in Software Development Life Cycle (SDLC).
• Involved in Unit Testing and SIT, UAT and design issues resolutions.
• Good problem solving and trouble shooting skills, highly motivated and ability to work as an individual or as a dynamic member in a team.
• Excellent communication (Verbal / Written) and presentation skills, Quick in grasping client’s business requirements and good at adapting to new work environment.
• Proven ability to quickly learn and apply new technologies with strong technical background.
• Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

RDBMS: ORACLE 11g/10g/9i/8i

ERP/Modules: Oracle Applications R12/11i/ 11.0.3/10.7 (Order Management (OM), Advanced pricing (AP), Oracle Shipping (WSH), Inventory (INV), Oracle Purchasing (PO), Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Work in Process (WIP),Project Billing, Project Costing.

Lang & Scripting: UNIX Shell Scripting, SQL, PL/SQL, HTML, XML.

Release Eng. Tools: CVS, VSS, PVCS.

Development Tools: TOAD, Reports 9i/6i/3.0/2.5, Forms 6i/4.5, BI Publisher/XML Publisher, Workflow builder 2.6/2.5, Import/Export.

Operating System: Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Application Technical Developer

Responsibilities:

• Developed several API’s for custom applications in AR and OM.
• Performance tuning of custom packages and standard API’s
• Developed customized API’s for the preprocessor programs in AR with general flow from OM
• Designed, developed and tested the customized API’s to integrate with other databases which are part of oracle and out of oracle.
• Worked on Subscription delivery platform(SDP) to maintain the end client’s customer data base.
• Integrated Oracle EBS with SDP with SOA through BPEL. Loaded data to custom and staging tables through EDI as XML pay loads.
• Developed PLSQL API to let BPEL call the endpoint to let the integration happen between database entities.
• Worked on the workflow from OM to AR.
• Extensively involved in the meetings to develop Business required documents, Functional required documents and Technical required documents.
• Discussed with client on their web portal functionality in order to get the initial and recurring purchase orders.
• Worked on customization of AR invoice report, standard API and developed a custom API to customize the tax calculation.
• Developed reports on BI publisher by creating layouts, data templates and integrating it with Oracle ebs .
• Created invoice reports in BI publisher by converting .rdf reports to .rtf through xml script.
• Created custom and staging tables in SDP schema integrating them with EBS.
• Participated in several meetings which dealt with designing of a workflow to create an initial invoice for customers of client.
• Responsible for implementation and customization of OM, INV, AR, PO, PA, GL, and Purchasing.
• Designed and implemented interface programs to load Purchasing (PO) data from legacy systems to Oracle Applications.
• Coding of custom reports for Purchasing (PO) module, defining concurrent programs, value sets and parameters.
• Development of custom XML publisher and rdf reports in Purchasing (PO) and in Account Payable (AP) modules.
• Worked on the work flow for initial invoice which has no tax but for the recurring bills. Create a pro-forma invoice by suppressing tax on it.
• Developed that initial invoice from EBS but the recurring from Client.
• Upgraded the custom packages and API’s of existing database.
• Worked with internal team of OM SDP SOA INFORMATICA in creating the workflow and getting the invoices printed in BI publisher.
• Worked with the support team of deploying, testing and User acceptance testing.
• Analysis and design strategy for conversion of Legacy Data into Oracle11i Project Accounting(PA) module
• Worked on oracle standard API using PL/SQL in Order Management and Advanced pricing modules.
• Performed several setups in Inventory, Order Management and Shipping modules.
• Developed the AOL forms using the TEMPLATE.fmb and built the PL/SQL code as per the AOL coding standards.
• Customized several oracle standard forms using CUSTOM.PLL and Forms Personalization.
• Involved in Enhancement of the existing system by developing new forms for the system and integrating them with existing modules.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.

Environment: Oracle E-Business Suite 11i(11.5.10), AP, AR, OM, Forms 10g,Forms 6i,Reports 6i, Reports 10g, Work Flow, BI publisher, SQL*Loader, TOAD, UNIX.,Purchasing

Confidential, Las Vegas, NV

Oracle Techno functional consultant

Responsibilities:

• Expertise in testing the flow of Order to Cash and Procure to Pay cycles.
• Performance Tuning of Custom PL/SQL Packages and Standard Oracle APIs.
• Worked on rebuilding the Interfaces and Customizations on Account Payables and Purchasing
• Designing and Development of custom interfaces on the Oracle AP and Oracle AR.
• Developed and integrated Interface programs for porting Legacy Data into Oracle database.
• Analysis and design strategy for conversion of Legacy Data into Oracle11i Project Accounting(PA)
• Worked on oracle standard API using PL/SQL in Order Management and Advanced pricing.
• Performed several setups in Inventory, Order Management and Shipping modules.
• Developed the AOL forms using the TEMPLATE.fmb and built the PL/SQL code as per the AOL coding standards.
• Customized several oracle standard forms using CUSTOM.PLL and Forms Personalization.
• Involved in Enhancement of the existing system by developing new forms for the system and integrating them with existing modules.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Implemented AME (R12) (Approval Management Engine) for AP Invoice approval.
• Personalized seeded and custom OA Framework pages to hide fields and buttons on the pages.
• Customized the Timecard entry page in Oracle Time and Labor. This involved changing ldt files and OA Framework changes to a couple of pages.
• Extensively worked on Workflow builder in AR.
• Developed a new workflow to send notifications.
• Customized standard Oracle Apps Reports by adding extra field or extra parameter to sort data in a report for Manufacturing, Financial and CRM Modules.
• Modified existing reports by creating additional joins and Designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
• Created and customized output format in XML, new templates for XML Publisher to display the reports in client requirement format.
• Customized XML publisher report for AR Invoice in the client specified layout.
• Setting up users and roles in Oracle BI/XML Publisher.
• Designed and developed customizations using Oracle Application Framework in Project Resource Management, IExpenses and IProcurement modules.
• Developed reports and data extracts in OM, WSH, INV and AR.
• Worked on AR Account Status Report using Discoverer.
• Migrated some of the existing custom Oracle Reports to Discoverer.
• Customized the Customer Credit Hold Report using Discoverer 10g in Account receivables (AR).
• Developed Finance Reports like: Comparative Sales Report, Daily Sales Report using Discoverer Admin, Discoverer Desktop and Discoverer Viewer.
• Validation and code fixing of all database objects in Oracle Applications 11i INV, PO modules.
• Involved in Importing the Order Management data from legacy system to Order entry Interface tables using SQL*Loader, validating the data using PL/SQL script and creating orders using Order Import Program.
• Created SQL Loader scripts to load data from legacy systems to Oracle Apps.
• Developed programs to load data from intermediate tables into BOM Interface tables.
• Expertise in writing PL/SQL packages for Creating and managing customers using TCA (Trading Community Architecture) in AR.
• Developed SQL queries to compare summary information of the standard and custom reports in Order Management, Inventory, Receivables
• Responsible for the technical and user documentation of the customizations.

Environment: Oracle Applications EBS 10g/11.5.10/R12 (AR, AP, PO, OM, INV), Reports 6i/10g/11i, Forms 6i/10g/11i, SQL* Loader,OAF, Discoverer, PL/SQL, Workflow builder 2.6, XML publisher, TOAD, Windows XP.

Confidential, Ramsey,NJ

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in Requirement Gathering and Business analysis document Preparation, with extensive involvement in the technical design of R12 implementation and conversions in various modules including AP, GL, PO and INV.
• Involved in post-production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions.
• Worked as a consultant for the implementation of Oracle Project Accounting (Costing & Billing).
• Another major functionality change from 11i to R12 was the move from customer/vendor data model to the TCA model. This involved major design changes and hence had a major impact on the upgrade activities. Hence this needed the usage of custom and TCA APIs to upload the new architecture data from previous version to the next version.
• Configuration of key areas in Project Costing, Project Billing and suggesting suitable Business flow setups to the client.
• Worked on costing, i.e capturing cost, distribute cost and cost budget etc.
• Developed packages for conversion of various TCA objects like, parties, party sites, party site uses, customer accounts, customer account sites, customer account site uses, party and customer account profiles, profile amounts, etc., using oracle standard API calls. During the process developed validation procedures, error handling and debug logic as per the client’s complex design specifications.
• Developed various outbound interfaces, which are run on the periodic basis. The modules worked on include AP, GL, AR, PO and inventory modules.
• Involved in Month end support for the period close for AP, AR & reconciliation through CE.
• Resolved the issues related to payment processing, payment authorization, suppliers.
• Developed various oracle custom reports such as Journal detail report, Cancelled invoices report, Top ten supplier report, Standard/Blanket purchase orders which are not invoiced with in particular duration, Users and their responsibilities report, Report to list all the functions and menus attached to responsibilities using oracle report builder and XML publisher.
• Involved in development of importing AP Invoices from legacy systems to Oracle using Invoice Import Program.
• Customized various reports in Account Payables (AP) like AP Invoice Register, Payment Distribution Report, Account Payable Trail Balance Report and Trail balance reports in GL.
• Defining Descriptive Key Flex fields, Key Flex fields, Set of Books, Accounts, and Approval rules for Journal Entries, Reconciliation, Post Journals, Year End and Period Closing in GL.
• Defining Supplier, Organization, Items, Purchasing Options and Buyers in purchasing implementation.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Decide Approval Hierarchy Set-up and Maintenance for approving PO using Oracle Workflow.
• Set up iProcurement, Train, Troubleshoot and debug iProcurement Modules. Load Items, Set-up and Maintain Punch-out Items.
• Worked on iExpense creating reports, sending reports to AP, converting reports to invoices.
• Worked on iExpense related Oracle Service Request (SR) on incorrect Mileage rate after adjustment and mileage rounding to threshold value bugs.
• Worked on iExpenseproduction fixes such as duplicatelines for AMEX transactions, incorrect mileage adjustment for second expense report for the same user in the same period.
• Worked on data fixes for invoice holds in Accounts Payables (AP).
• Worked with PVCS for code/setup migrations between test instances, generating LDTs for concurrent programs, forms personalization, menus, responsibilities, value sets and other AOL objects.

Environment: Oracle Applications 11i, Oracle 10g, Oracle Reports 10g, Oracle Forms 10g, BI/XML Publisher, SQL, PL/SQL, UNIX, TOAD, Workflow Builder, SQL*Developer.

Confidential, Philadelphia, PA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• The project involved the implementation of data conversions in various modules like AP, AR, GL, PO and customization of reports.
• Worked on different tools like JDeveloper, XML/BI Publisher and Discoverer to generate the reports.
• Developed Sales Order Report, Purchase order report, Purchase Order Arrival using XML Publisher.
• Performed Technical analysis for R12 Implementation.
• Involved in developing Implementation standards for standard Discrete Manufacturing (ODM).
• Creatednew OAFpages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data throughEO(Entity Objects).
• Created customized folders/views in OAF for requested to users based on pickup status.
• Developed, implemented and unit tested AP Invoice interfaces. This involved importing data from the legacy system into staging tables using SQL Loader, validating the data using a PL / SQL procedure, inserting data into interface tables and running the invoice import concurrent program to load the data into oracle AP tables.
• Developed Profitability Report in PA (Project Accounting).
• Data was converged using standard functionality (Data Loader) to import On Hand balances with Inter-organization transfers, Discrete Jobs and beginning balances in Projects.
• Implemented Trading Community Architecture (TCA) to support complex trading communities and relationships within a trading community using PL/SQL APIs.
• Performed internal costing, revenue accrual, and billing for any type of burdened costs that company applies to raw cost.
• Written PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Developed multiple custom enhancements in P2P implementation.
• Created new concurrent request sets and scheduled the Order Import interface program to run periodically.
• Used standard Order import to load the open orders from the interface tables to the standard OM tables.
• Designed and developed an Inbound Interface between web based Order management systems to Order Management for Sales Orders import.
• Worked on enhancements to custom ship confirmation process that that takes ship confirmations from the vendor’s warehouse management system and load them into the interface tables so that the data can be populated into OM modules.
• Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
• Developed custom forms to maintain custom tables in P2P process.
• Customized AP invoice form using form personalization. Customizations include adding menus, Hiding fields and changing prompts.

Environment: Oracle Applications R12 (AP, AR, OM, GL, PO), TOAD, PL/SQL, SQL*LOADERReports 10g,forms 10g, XML Publisher, UNIX shell scripting.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Modification of existing report to see items that make up the balances: Modification of existing report to see items that make up the balance of the accrual sorted by PO.
• Supplier Analysis Report showing no of PO-s raised on a supplier with closed, open for receiving, open for invoicing info. This report is list of detail of Suppliers information about how many purchase orders has been released and how many are closed status, open status and briefly.
• PO Attachments Conversion: Importing the Purchase Order Attachments data from the legacy system into Oracle Applications data by using the Oracle Provided (Application Program Interface)
• Report that shows, for a PO or release, the revision amount, incremental amount, and total amount of each revision: The report is the list of details of the Purchase Order releases, revision amount and incremental amount and total of the revision by using XML Publisher by using XML Publisher.
• Dropship PO custom report by sales person and receipt: Developed a custom report to display the details of Purchase Orders, sales person and receipt number that are created during Drop Shipment process by using XML Publisher.
• Workflow: Customized the Purchase Order workflow for the PO business. Enhanced the flows, mainly WF functions, processes & notifications related to business flow using Oracle Workflow Builder and PL/SQL coding. Worked on some notifications in po approval for sending the notification, like in a HTML table format to the Quality inspection team and Receiving clerk based on the certain specification of items attachment.
• Customized the Order Header level workflow, which will send a notification based on the data mismatch between order header level and order line level.
• Developed a new workflow, which will send the notifications.
• API: Process Order changes using an API.Order’s data is successfully updated in current Oracle applications using seeded API’s. Also created report of updated information of the Sales order.
• Developed a new report to displays the information about the matching the PO and Invoice details.
• Developed new report to displays the information about the Item cost comparison report.
• Customized Account Payables invoice report as per the client requirement by using reports 6i.
• Developed Requisitions Interface to upload the requisitions data into Oracle apps base tables.
• Participate in the gathering of functional requirements.
• Planning and establishing post go-live activities including ongoing application support.
• Work with the end users & business owners to map standard processes to the business needs of the client
• Prepared the Technical Design Document based on the Functional design documents.

Environment: Oracle Applications Release 11.5.10.2 (AP, GL, AR, PO, FA) Oracle 10g, SQL, PL/SQLForms 10g, SQL * Loader, and TOAD.