OBJECTIVE:

Oracle Developer / Business Analyst / Tech Lead position

TECHNICAL SKILLS:

• Oracle Apps. R12 (OTL
• TCA
• OM
• AP
• PO
• INV
• Projects
• Service Contracts
• WIP
• Install Base
• BOM
• Routing
• Advanced Pricing
• Order to Cash (O2C)
• Procure to Pay (P2P)
• light Incentive Comp
• Oracle Apps. 11i (OM
• Supply Chain
• OPM
• ATP
• FA
• AP
• GL
• CE
• INV
• PO
• WSH
• AR
• CRM
• TCA
• Workflow
• RICE objects
• Oracle Reports (2.5
• 3.0
• 6.0
• 6i
• 9i)
• Oracle Forms (4.5
• 5.0
• 6.0
• 6i
• 9i)
• XML Publisher
• BI Publisher
• Logical Apps
• Personalizations
• Oracle (7.3
• 8i
• 9i)
• SQL+
• PLSQL
• Unix (AIX
• HP
• Korn)
• OBIEE
• Maximo
• MSDOS
• Windows (3.1
• 95
• 98
• 2000
• NT
• XP)
• Microsoft (Access
• Excel
• Word
• Powerpoint
• Outlook
• Project)
• Visio
• PC (building
• repairing)
• Business Objects
• light EDI.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer

• Converted Oracle 11i to Sales Force. Modules converted: TCA, OM, AR, and Service Requests)
• Designed and developed Custom Interfaces between Salesforce and Oracle. (TCA, OM, AR, and RMA’s)
• Designed and developed a front - end form for a custom Business Rules Engine using Oracle Forms.
• Designed and Developed interface between Oracle and Manhattan for Item Quantity Conversion.
• Designed and Developed custom interfaces between Oracle and Manhattan.
• Worked closely with Accounting to reconcile new inventory systems and processes with existing ones.
• Wrote several reports using SCI / Cognos.
• Production Support of Oracle 11i.
• Code reviews for onshore and offshore developers.
• Participated in all steps of the SDLC.

Confidential

Technical Lead

• Lead conversion team of 6 developers converting legacy systems to Oracle EBS R12. Modules converted: TCA, AP, PO, INV, OM, AR, Projects, Service Contracts, Install Base, BOM, Routings, and WIP)
• Designed and coordinated technical approach for project implementation.
• Designed and developed Custom Interfaces.
• Designed and developed BI Publisher reports.
• Designed and developed Custom Reports.
• Designed and developed OBIEE Reports / Dashboards.
• Designed and developed Oracle Forms for custom Estimating system.
• Code reviews for onshore and offshore developers.
• Trained legacy developers in SQL+, PLSQL, BI Publisher, Oracle Reports and Oracle Applications.
• Participated in all steps of the SDLC.

Confidential

Oracle Business Analyst / Developer 

• Business Analyst for AR, GL, FA, AP, OM, Advanced Pricing, Cash Management, and Projects
• Developer for AR, GL, TCA, Advanced Pricing, Incentive Comp, Cash Management and Projects
• Designed and developed Custom Interfaces for Oracle R12 and its satellite systems.
• Conversion of R11 customers to R12 TCA structure.
• Code Reviews for the R12 project
• Designed and developed BI Publisher reports. (R12)
• Designed and developed Custom Reports
• Designed and developed many custom processes.
• Performance tuning of many processes.
• PCI Compliance
• Production Support, enhancements and bug resolution.
• Participated in all steps of the SDLC.

Confidential

Oracle Developer/Systems Analyst

• Developer for OM, CRM, AR, PO, and INV.
• Designed and Developed a custom shipping rules engine.
• Designed and Developed of several process for IVR upgrade.
• Performance tuning of several processes.
• Item Conversion, Archiving and Purging.
• Production Support and bug resolution.
• Participated in all steps of the SDLC.

Confidential  

Oracle Developer

• Developer for CRM and AR applications.
• Designed and Developed customer conversion process from a custom Oracle VLDB into Oracle Applications.
• Production Support and bug resolution
• Participated in all steps of the SDLC.

Confidential

Oracle Developer/Systems Analyst 

• Developer for OM, CRM, AR and a custom inventory tracking/processing application.
• Designed and Developed an “online” credit card application process.
• Developed Custom forms using Oracle Forms 6i.
• Production Support and bug resolution
• Participated in all steps of the SDLC.

Confidential  

Oracle Developer/Systems Analyst

• Designed and Developed a custom application for a Home/Commercial Security business.
• Designed and Developed a custom Quote / Project module
• Designed and Developed a custom Order Capture module.
• Designed and Developed a custom Pricing module.
• Developed Custom many forms using Oracle Reports 9i.
• Developed Custom many reports using Oracle Reports 9i.
• Production Support and bug resolution
• Participated in all steps of the SDLC.

Confidential

Oracle Developer/Systems Analyst

• Designed and Developed a custom CRM module
• Developed Custom many forms using Oracle Forms 9i.
• Developed Custom many reports using Oracle Reports 9i.
• Production Support and bug resolution
• Participated in all steps of the SDLC.

Confidential

Oracle Developer 

• Developer for AP, HRMS.
• Designed and Developed Positive Pay and NACHA Extracts.
• Developed Custom reports using Oracle Reports 9i.

Confidential  

Oracle Developer/Systems Analyst 

• Developer for Order Management in an OPM (process) environment.
• Designed and Developed several custom processes.
• Developed Custom reports using Oracle Reports 9i.
• Performance tuning of existing processes.
• Production Support and bug resolution
• Participated in all steps of the SDLC.

Confidential

Oracle Developer/Systems Analyst

• Developer for Oracle Accounts Payable and Order Management.
• Designed and Developed custom Cash Management interface process.
• Designed and Developed several EFT and Positive Pay bank interfaces.
• Created and Designed a COGS engine.
• Developed a custom Accrual Redemption Process.
• Created custom ship manifest and interface process
• Performance tuning of many plsql processes and reports
• Developed Custom forms using Oracle Forms 6i.
• Developed Custom reports using Oracle Reports 6i.
• Participated in all steps of the SDLC
• Software debugging of custom and standard processes in PO, INV, OM and AP
• Working closely with developers, analysts, and users to troubleshoot and solve database issues
• Documentation of custom processes.

Confidential  

Oracle Developer/Systems Analyst

• Developer for Oracle Accounts Payable and General Ledger.
• Designed and Developed custom General Ledger interface process.
• Designed and Developed custom Cash Management interface process.
• Created custom email notification program

Confidential

Oracle Developer/Systems Analyst 

• Developer for Order Management in a OPM (process) environment.
• Designed and Developed several custom processes.
• Order Import performance tuning
• Created a Custom Form using Oracle Forms 6i and Custom.pll
• Written a PLSQL EDI extract.
• Developed four Custom reports using Oracle Reports 6i.
• Production Support and bug resolution
• Participated in all steps of the SDLC.

Confidential

Oracle Developer

• Converted 11 PLSQL extracts to Oracle Applications 11i.
• Designed and developed a Custom Form using Oracle Forms 6i.
• Designed and built a custom table, index, and synonym.

Confidential

Business Systems Analyst

• Lead Functional OM Analyst for a Vendor Managed Inventory Project
• Designed and written training documentation for a Order Entry conversion.
• Written several reports using Oracle Reports 6i
• Participated in all steps of the SDLC
• Software testing for custom processes for PO, INV, OM modules.
• Software debugging of custom and standard processes for PO, INV, OM modules.
• Solution Design
• Working closely with developers and users to troubleshoot and solve database issues

Confidential

Primary Order Management Developer

• Designed and implemented processes in the OM and CRM modules of an Oracle 11i Application environment including Advanced Pricing.
• Developed a business critical custom Order Entry form
• Developed several custom forms using Oracle Forms (6i).
• Wrote several reports using Oracle Reports (6i).
• Designed and developed several Workflow processes.
• Created custom defaulting rules in Order Management
• Created custom processing constraints in Order Management
• Wrote many scripts using PLSQL utilizing Oracle API’s
• Developed several processes in the Custom.pll
• Provided production support for OM, AR, and CRM modules.
• Tutored Confidential /Motion employees on Oracle Reports (6i) and Oracle Forms (6i).

Confidential

Oracle Developer/Business Analyst

• Wrote and maintained over 200 reports using Oracle Reports (3.0, 6.0, 6i) and Oracle Query Builder.
• Designed and implemented over 35 forms using Oracle Forms Oracle Forms (5.0, 6.0, 6i).
• Data mining using Query Builder, Business Objects.
• Created views, tables, procedures, database triggers using SQL + and PLSQL.
• Created users and roles in compliance to Aspen’s security policy.
• SQL + and PLSQL Tuning.
• Participated in all steps of the SDLC
• Developed processes and ensured successful execution.
• Documentation and training of processes, forms and reports.
• Worked closely with Accounting, Business Analysts, and users to develop and solve database issues.