SUMMARY

• Over 8+ years of extensive experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e - Business Suite Applications (R12, 11i). This includes system design, development, post maintenance and production support of Oracle EBS
• Extensive experience in Development, Migration, Customization and Production support of various modules in Oracle Applications such as Oracle Financials (AP, GL, AR), Order Management (OM), Inventory (INV),Purchasing (PO), BOM, Warehouse Management System (WMS), HRMS, PAYROLL, OTL, OIC and Shipping (WSH)
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Expertise in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Techno-Functional experience in Order to Cash Process, P2P, SCM and Technical experience in all Financial, Manufacturing and Shipping modules in EBS.
• Strong knowledge of Unix Shell Scripts and Perl Scripts
• Strong knowledge of Application Implementation Methodology (AIM), Oracle Unified Methodology (OUM), Application Object Library (AOL) implementation standards and Software Development Life Cycle (SDLC).
• Expert in developing Technical design documents (MD070, DS140), Technical Test documents (TE020), Conversion (CV050), Migration documents (MD0120) and Installation Instructions (IM090)
• Experience in developing new forms and customizing standard Oracle forms with the use of TEMPLATE.fmb, Custom.pll.
• Experience working on Toad, SQL Developer, SQL*Loader, SQL* Plus, Oracle Import/Export utilities and SQL* Navigator
• Experienced in registering PL/SQL procedures, Reports, Forms, XML/BI Reports, and SQL*Loader scripts as concurrent programs in the APPS front end.
• Knowledgeable in using Oracle utilities FNDLOAD and WFLOAD.
• Experienced in handling, installing, and effective troubleshooting and up gradation of EUL from Discoverer 4i to 10g.
• Worked extensively on Infosec in order to protect the data from hacking.
• Experience in customizing applications using OAF, Java and ADF.
• Expertise in developing and customizing Forms using Oracle Forms, Reports, Oracle Discoverer and XML/BI publisher
• Proven ability to quickly learn and apply new technologies with strong technical background

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business Suite R12, 11.5.4 to 11.5.10. Oracle SOA Suite (10g and 11g), Oracle Manufacturing (OM,OPM, INV, BOM, WIP, PO), Oracle Financials (GL, AR, AP, FA, BOM), AOL, O2C (Order to Cash), eBTax, GL (SLA), P2P (Procure to Pay), Sys. Admin.

Application Tools: Reports 6i, Forms 10g/6i, Discoverer 10g/4i, Developer 2000, Developer Suite 10g, XML/BI Publisher, Siebel, Oracle Web Application Server 4.0.8, Oracle Enterprise Manager (2.1.0), OAF.

Databases & Tools: Oracle 10g/9i/8i/8.0, TOAD, SQL*PLUS, SQL* Loader, JDeveloper.

Scripting Languages: Unix Shell scripts, Perl, K shell, C shell.

Languages: SQL, PL/SQL, JAVA, XML, C, C++

Operating System: Sun Solaris, HP Unix, Linux, Windows XP/2000

PROFESSIONAL EXPERIENCE

Confidential, Tacoma, WA

Oracle Technical Consultant

Responsibilities:

• Designed, documented Technical Specification (MD070) for reports and custom programs development through meetings with functional team and business users.
• Worked on Oracle Incentive Compensation (OIC) integration with CRM.
• Developed Oracle Time and Labor Interface OTL to import work hours from PeopleSoft into OIC for commission/Bonus calculations.
• Worked on changes to the HR Employee Inbound Interface from PeopleSoft to Oracle.
• Developed Oracle Advanced Benefits OAB, Payroll Balances and conversion programs using API’s in HRMS Module.
• Worked on changes to the Work Order Collections Program Interface to in corporate a mailing procedure which notifies users the collections count for each site.
• Customized B2B Workflow according to the business requirements.
• Modified the shell script, PL/SQL packages for the HR demographic file changes in order to decrypt an inbound GPG (.gpg) encrypted file and load date into oracle.
• Developed programs for converting Legacy data into Oracle HRMS system for Employees, Assignments, Elements, Pay Methods, Salaries, Phones and Costing including history.
• Developed custom interfaces in AP, AR, GL, HRMS and OIC modules.
• Developed a PL/SQL procedure in PPM (Project Portfolio Management) to calculate work hours for named/ unnamed resources.
• Customized the Incentive Compensation Formulas to calculate Commissions/Bonus.
• Made changes to custom Inventory Sync Program to run parallel and process data for multiple orgs simultaneously.
• Customized the JSP Reports such as ‘Sales Rep Activity Report’, ‘Plan Element Summary Report’ in Incentive Compensation.
• Worked extensively on InfoSec to avoid Breaking IP-based ACLs via spoofing.
• Worked on different BC4J components for Extension (CO, VO) and Creation of new OAF pages in JDeveloper 10g environment.
• Worked on customization and Personalization of forms using Oracle Application Framework (OAF) to provide custom solutions to OIC module.
• Made changes to existing codes and tested it with business and functional users before moving it to production through Kintana Tool.
• Created Shell Scripts for Concurrent programs and migration scripts.
• Worked with production Support team to resolve production issues.

Environment: Oracle Apps R12 (12.1.3), 11.5.10,SOA 11g, Oracle Incentive Compensation (OIC), HRMS, Supply Chain Management (SCM),Oracle manufacturing, Financial, HRMS, OAF (Oracle Application Framework), AP, INV, PO, Info sec, UNIX.

Confidential, CA

Oracle Technical Consultant

Responsibilities:

• Prepared Technical specification documents (DS140) and code pack for Reports
• Performed application support in single and multi-Org environment for Oracle Financials (Purchasing (PO), Accounts Payables (AP),iExpenseandiProcurementmodules).
• Worked in (AP, AR, PO, FA) on various reports like Purchase Orders Report, Gauss Patch Sheet Report, Claims and Deduction, Customer Specific Invoice Report.
• Developed various reports in shipping module like Pick Slip Report, Packing Slip Report, Straight Bill of Lading and Master Bill of Lading Report.
• Worked on OPM to Optimize margins with multiple cost methods and improve inventory valuation.
• Used Bursting technique to email the XML publisher output file.
• Created Workbooks based on the custom Folders with cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop
• Developed AP/AR/INV reports using discoverer such as Inventory Reservation Report, Inventory on-hand Report,
• Developed month-end reports using XML Publisher such as Sales Invoice PST-GST Tax Summary Report, In-Transit Report.
• Worked on Projects Employee expenditure XML Publisher report.
• Worked on Projects Forecast Budget Inbound, Billing Milestones Outbound Interfaces between Oracle R12 and Clarity system
• Worked on Oracle EBS Production issues related to Projects (Costing, Billing and Project Management), OTL, I-Expenses, I-Procurement, INV, AR, GL and EBS Tax modules
• Worked on implementing theiProcurement RequisitionandReceivingcustomization using xml framework.
• Worked onUnit/Functional TestofiProcurement Requisition and Receiving pageswhile developing the customized
• Made changes to existing codes and tested it with business and functional users before moving it back to production through change management.
• Worked closely with functional team and business to resolve bugs and defects in SIT and UAT.
• Used FND-LOAD to migrate Concurrent programs, Request sets, and Data Definition, by downloading the LDT files
• Worked on Infosec to avoid cross Site Scripting hacking.
• Worked withSales Order Open Interfacein Order Management module to import Sales Orders from flat files
• Responsible for Database Manipulations and Generating reports using UNIX Shell Scripting and PL/SQL packages.
• Worked on Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.

Environment: Oracle Apps R12 (12.1.3),SOA 10g,Supply Chain Management (SCM), OM, WSH, Warehouse Management, Oracle manufacturing( INV, PO,OPM,AR, AP), FA, Discoverer 10g, XML/BI Publisher, PL/SQL, Projects (Costing and Billing), iProcurement, Reports 10g, Toad, Windows XP, OUM, AIM, Shell Scripting, Oracle 10g.

Confidential, Kansas City, MO

Oracle Technical Consultant

Responsibilities:

• Responsible for designing, developing, unit testing, implementing and maintaining custom extensions for Oracle Applications R12/11i versions.
• Experience in PLSQL Interfaces, PLSQL APIs, Conversions, Customization and Development of Forms, Workflows and Reports
• Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs
• Involved in developing a custom package for importing Orders from web-based system COPS through Order Import Open Interfaces PLSQL API in Order Management.
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Developed Cycle Count Report and Open Item Details Report in INV using XML Publisher.
• Developed Order/Invoice Detail Report, Back Order Detail Report in Order Management using BI Publisher.
• Worked on iExpense reports.
• Worked on OPM to conduct detailed cost analyses for current and historical purchased material costs, applied resource costs, and batch costs
• Developed Daily Shipping Report and Payments Processed Report using Oracle Discoverer 10g
• Customized the Standard Workflow Items and process such as Order Header, Order Line, Change Order Close order, and Close line.
• Used Forms Personalization created a special trigger in sales order for booking according to user requirement
• Worked on Personalization of forms such as making fields mandatory, Validating fields using custom code in triggers.
• Customized standard forms with CUSTOM.pll library to create new functionality.
• Worked on various activities like preparation of Functional Specification (MD050), Technical Specification (MD070) documents, discussions with the client regarding the proposed solution and related reports, forms and design document to implement Custom Workflow
• Developed UNIX Shell scripts to run the interface program and to archive the data.
• Used SQL trace facility and TKPROF accurately to assess the efficiency of the SQL statements when application runs & used tools with EXPLAIN PLAN.
• Expert in Creating temporary tables and developing SQL*Loader control files to load the legacy data into the temporary tables for all the conversions.
• Registered Concurrent Programs and defined new users, menus and responsibilities

Environment: Oracle Apps R12/11i (11.5.10), Supply Chain Management (SCM), OM, WSH, Warehouse Management, Manufacturing INV, PO, OPM, AR, AP, CM,TCA Architecture, Discoverer 10g, XML/BI Publisher, PL/SQL, GL, Reports 6i/10g, Forms 6i/10g, Toad, Windows XP, AIM, Oracle 10g.

Confidential, Atlanta, GA.

Oracle Technical Consultant

Responsibilities:

• Gathering Business Requirements and setting up Business Processes within the Applications
• Involved in customer conversion from legacy system into Oracle Accounts Receivable(AR) by using Customer Interface
• Writing PL/SQL scripts to migrate the data from customers’ legacy system to Oracle Applications tables.
• Customization of Order Header workflow to close the order header once all the lines are closed.
• Modified the ‘PO: Printed Purchase order report (printed)’ to meet the client’s requirement
• Report development Character reports Daily Orders Report, Inv Shortages Report, Shipment Exception Report and label reports using Discoverer
• Customized standard reports like aging report and Invoice in AR.
• Extensively worked and resolved the issues on OM, Shipping Execution, INV, PO, BOM, WIP, AP and AR Applications.
• Worked on OPM to Maximize planning efficiency with customizable views of supply and demand
• Experience in Debugging and error fixing using PL/SQL debugging tools like TOAD.
• Worked on Form personalization in receivables, where the user can’t update the last and first name of customer, bank account number, when that record is validated.
• Proficient in generating Forms using Oracle Forms meeting variety of Business needs including custom Reports.
• Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Resolved the issues on Sub inventory transfer, Inter-Org transfer in Inventory Application
• Developed custom XML/BI publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a particular Organization in the Inventory module.
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Worked on OPM to improve process execution with clear and detailed formulation definitions.
• Documented all the work using AIM methodology.
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked on Open Interfaces for importing transactions using Auto Invoice in AR.
• Customized Auto Lockbox Receipt Interface program to automate the receipt processing in AR.
• Wrote UNIX shell scripts for process for Data Loading, FTP, and sending mails

Environment: Oracle Apps R12, Supply Chain (SCM), OM, WSH, Supply Chain Management (SCM), Warehouse Management, Manufacturing INV, PO, AR, AP,FA, CM TCA Architecture, Discoverer 10g, XML/BI Publisher, PL/SQL, GL, Reports 6i/10g, Forms 6i/10g, Toad, Perl, Windows XP, AIM, Oracle 10g.

Confidential

Oracle Technical Consultant

Responsibilities:

• Involved in data validation and build designing to upload data from existing systems
• Developed PL/SQL procedures and functions for processing the Customer information captured in the front end
• Used descriptive flex fields extensively to capture additional information
• Developed Open Purchase Orders report using Report 6i.
• Tuning the SQL queries to improve the reporting performance in the application.
• Extensively used System Administrator module for set up of various Concurrent Programs, Request Sets, Users and Responsibilities.
• Wrote custom code with validations to transfer the data from staging table to interface tables.
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Have worked in Oracle Discoverer 4i, creating Business area, folders and workbooks using Discoverer Administrator and Discover Desktop for financial department.
• Developed and designed Invoices using Oracle Reports 6i.
• Wrote PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.

Environment: Oracle Applications 11i (11.5.x), GL, AOL, AP, AR, PL/SQL, SQL*loader, Oracle Reports 6i, Discoverer 4i, Oracle System Administration AOL.