SUMMARY:

• 16 Year Techno - Functional experience in Oracle manufacturing/financial module, R12.1.6, E-Business Suite 11i
• Exposure to TAX, retail (Retek Distribution Management), Fusion, DIMES, DEAMS and Discoverer Application.
• Database analysis, design, development, Upgrade, Unit testing, implementation and production support.
• Experience in Form & report generation using Form & Report Builder 6.0.8, 10g, 11g, Discoverer (4.1, 10g, 11g) and XML Publisher Template appended with MS Word, Purchase Order hierarchy setup and workflow.
• Developed custom application in financial module (AP, AR, PO, GL, I Procurement). Manufacturing (OM, INV, BOM, WIP, MRP, MPS forecasting), Distribution (WMS, WCS, ASCP) to suit specific business requirements.
• Master Customer Setup, Sales Order transactional data migration, Report, Interfaces, Conversion, Extension (RICE Objects), Apps Enhancement, Item, PO, AR and Order Import Programs, APIs to bring data into Interface.
• Setups, Flex fields, Order thru EDI package within the Oracle ERP Application. PO with e-mail transmission.
• Oracle Implementation AIM Methodology (MD050, 70,120) documents used with Apps EBS custom development
• Production support experience to work with Support group creating Service Request, Tech Ref Manual link in db.
• Oracle database: 7.x / 8.x / 9.x / 10g / 11.2g
• R12 Oracle Apps: 12.0.4 - 12.1.3 , 12.1.6, Oracle E-Business Suite application: 10.7, 11.0 and 11i
• Builder 6.0.8, Discoverer 4i, 10g and 11g - Report Dev 10g, XML Publisher Administrator. J Developer.
• SQL Navigator, SQL Developer, TOAD, SQL*plus, APEX Express, BPEL XML Tag, Unix, Linux box
• PVCS, Clear case, Clear Quest, SVN version control change, VSS winscp53, Putty, SQL*Loader Utility within R12 Apps and DIMES Fusion Middleware Apps

KEY SKILLS:

Oracle Apps 10.7 SC, 11.0.3 2 Years

Oracle Apps 11.5.9: 11.5.10.2 7 Years E-Business Suite

Oracle Apps 12.0.4: 12.1.3-12.1.6 4 Years

Report 2.5, 6i, 10g, Unix: PL/SQL 7 Years

Form 4.5, 6i, 10g, 11g Personalize 4 Years

XML Publisher, OBIEE, rdf Reporting 11 Years

Discoverer 3.1, 4.1, 10g, Plus 11g 7 Years

SQL Developer, Navigator, Toad, APEX 10 Years

AP, AR, PO, GL, PA, MRP, MPS 4 Years

OM, INV, BOM, WIP, XML Publisher 5 Years

PROFESSIONAL EXPERIENCE:

Confidential, Fairborn, OH

System Analyst

Responsibilities:

• Created,, modified and shared with responsibility/User - Discoverer workbook and worksheet using Discover User / Viewer tool
• Created, modified SQL Queries for workbook and data pull in APEX workshop using SQL Command and Script tabs
• Data mapping between DIMES Application and DEAMS staging / Interface and Import program core table in EBS 11i
• Deployment document created for Custom SQL folder, Joins between single item folder under custom and core bussines area in Discover Admin Edition -shared with User
• Parameter, Condition and Calculation created in existing or newly created discoverer reports
• Document created for workbook delete process, User profile setup, Delete Joins and how to register Package/Function in EUL

Confidential, San Antonio, TX

Oracle Application Developer

Responsibilities:

• Modified PL*SQL Package to create AR Misc Receipt with negative amt and AP Invoice with two distribution lines
• Inbound text file with three account line data format and values dropped into Unix box for BPEL to process.
• DIMES Application process the file, Error Correction screen and Reprocess file option after validation.
• Created EUL - End User Layer, Business Area's and Linked Custom Folder with Core Folder in Admin Edition, 25 workbooks created in Desktop Editions, SQL Script added in Oracle APEX 4.1 - Express
• Modified Procedure to insert data into ap invoice interface for AP Import program to run with Rejection Report.
• AP Invoice Credit Memo created in Application, source inbound text file, staging, Error and Interface table.
• DFF setup done in Apps mapped to the attribute in AP distribution lines. Freeze and compiled for Standard Date
• Java Conc Prog XDO Engine SQL query modified within data definition xml tag mapped to MS Word Template

Confidential, Pittsburgh, PA

Oracle Discoverer Developer

Responsibilities:

• Migrated Customer from legacy system to Oracle using SQL*Loader utility control and source file
• Sales Order transactional data Import from Fusion into Oracle using SQL*Loader utility and SQL Package
• Check Print Custom Template, Data definition, Document and Profile setup.
• Created MD50 functional design, MD70 Tech design and MD120 Installation document
• Created .rdf and .rep Custom reports, customer data load and production support for fusion and Oracle apps
• Payables Open Interface Import Program to Import AP Invoices with Distribution line for different accounts thru Inbound file dropped in Unix, Staging table validation, data feeder to AP Invoice Interface and Lines tables
• Production Support, Development and User Setup with Mapping in Oracle BI Discoverer Plus, Created EUL, Business Area and Linked PLSQL folder in Admin Edition, Approximate 60 workbooks customized in Desktop Edition.
• Descriptive Flex Field Setup Freeze, compiled, assigned to Core Distribution lines table’s attribute in Application

Environment: EBS, BIP, OEM, AP, AR and Fusion Application

Tools: SQL Navigator/ Developer, Forms / Reports Builder, putty, Discoverer, Clear Case, Clear Quest

Confidential, Irving, TX

Oracle Application Developer

Responsibilities:

• Quality reviewed Oracle 10g custom reports, package, procedures called by concurrent program for correct parameter passed from Apps to (Data model) in report or in database, Report triggers, tables and views used are the one where application is storing data in R12
• Modified Oracle Process manufacturing (OPM) 10g Forms in Order to cash(OTC) related modules, Release load to customer, Shipment Reservation, pick lots, Customer Credit information, Toll Detail -Scale Receipts, ASN
• Trading Partners, Legacy Customer Map, Customer Segmentation and EDI 856 Transmission for upgrade from 11.5.10.2 (11i) Application to 12.1.3
• Personalize Page in Oracle Field Service technician portal, field destination Locator based on source Org
• Created trigger on mtl material transactions table to assist receiver to receive parts in portal and verify on Trunk
• Stock management quick link in a part group depend on source sub-inventory location in staging shipment form

Environment: REL 12, Database 10G, Module OM, INV, AR, AP, PO, WMS, Quality Plan

Tools: TOAD, Forms/Reports Developer 10g, Putty, XML Publisher, rtf Template

Confidential, Beavercreek, OH

Oracle RICE Developer

Responsibilities:

• Created 8 Inbound Interface RICE Packages, Custom Utility in OM, INV, AP and AR module
• BPEL Insert data (Inbound XML and text files from Trading Partner) into staging tables
• BPEL Execute Concurrent Program in Application after validating incoming data
• Concurrent Program use SQL*Loader utility method to insert data into Oracle Core table’s
• BPEL communicate with JACK’s ARMY Web Service - transfer data (To and From Application)
• Created 13 Outbound Interface RICE Packages in OM, INV, AP, PO, WIP and BOM module
• Transaction thru BPEL, Validated by SFIS Transform to update data in Cash Recon module
• XML and text files transfer from Oracle Application to Trading Partner using DALMS Standard
• Created (Document Set) Shipping Transaction concurrent program for ORDER in Entered status to Finally Closed Status using SOA-RICE custom Inbound, Outbound Message Utility and API’s

Environment: Apps E-Business REL 12, Database 10G, Module OM, INV, WIP, BOM, AR, PO

Tools: SQL*Dev, BPEL control panel, XML Publisher, Clear Case

Confidential, NY

Oracle Apps Developer

Responsibilities:

• Project manufacturing Discrete Job shortage Report (Slick view) created from scratch.
• Data Imported from MAC System to Oracle after manipulation used in Oracle Database and Apps.
• NCR Screen (FORM) created from Template with LOV and single Canvas.
• Material and Distribution transaction data involving 15 type of INV transaction created in Discoverer
• 8 Inventory, WIP, BOM and GL module related Discoverer and RDF reports made in custom apps.
• Inventory Period closing reconciliations and ABC descending value Oracle seeded report customized.
• Outside Processing Discover report created in Project Accounting with WIP Ops and Resources
• Fnd, mfg Lookup lists Analysis for (Item Import Conc. Program) data migration from Legacy into Oracle.
• Utl file, fndfile data output into Application thru (PL*Sql Procedure method) as a Concurrent Program.

Environment: Apps Suite11.5.10.2, Database 10G, Module OM, INV, PA, WIP, BOM, PO, GL

Confidential, Forest Grove, OR

ASCP Planner/Analyst

Responsibilities:

• AR Invoice Tax calculation, discount, tax accounting, Tax codes and rates at different locations, Tax exemption, groups and rate exception used in Interface, form and reporting database objects.
• Credit card transaction into auto invoice interface table - auto Import program on monthly balance.
• Modified AP Invoice report by adding company logo, item barcode, and contact info at site level.
• AP and PO Conc. program output directly into Excel, option of PDF and XML thru XML Template
• Modified discoverer and 6i report using XML Publisher, Data definition Template path thru SVN, RDF file In Unix environment to get XML and Excel output in OM, INV, WIP, HR modules
• Form personalization limited to responsibility and use of (when validate trigger) in wip discrete job form.
• Modified PO printed Purchase Order Report, template and PO Output for communication Package in Confidential .

Environment: E-Business Suite11.5.10.2 & R12.0.4, module - AP, PO, ASCP