SUMMARY:

• IT Professional wif over 20 years of extensive experience in Oracle Applications. A resolute problem solver wif strong interpersonal and analytical skills. Technical savvy combined wif strong work ethics will add value and impact bottom - line results. Demonstrated ability to work TEMPeffectively at all organizational levels wif both internal & external customers.
• Maintaining Oracle Application Databases and Oracle Standalone Databases .
• Application Tuning using TKPROF STATS Pack, DBMS PROFILER and SNAPSHOTS.
• Database administrative functions - Oracle Export/Import/SQL*Loader, External Tables, FND LOAD, CONCSUB Utility, writing shell scripts, creating Printer Drivers, Printer Styles and Printer Types.
• PL/SQL development- Packages, procedures, functions, triggers, sequences, nested tables, types, views.
• Oracle Forms - migrating forms from Forms 6i to 11g, Forms Customization and Development using Template.fmb. Maintaining application screens and reports.
• SQL, PL/SQL tuning using various Oracle Tools- TK-PROF, Explain Plan, level 8 trace.
• Documenting the Modules under AIM standards, Client Specific Standards for different application functionality.
• Programming skills to independently analyze and identify comprehensive solutions considering all functional implications. Participated in all phases of the SDLC.
• Knowledge of R12 manufacturing, Oracle Work in Process, Oracle Bills of Material, Oracle Inventory and Oracle Shipping Execution, Oracle Order to Cash, Procure to Pay and Record to Report.

TECHNICAL SKILLS:

Engagement Expertise:

• Application Development
• Data Conversion
• Technical Architecture
• Application Implementation
• Business & Technical Process Re-engineering

Applications

• Oracle Advanced Pricing
• Oracle Warehouse Management (WMS)
• Oracle Fixed Assets
• Oracle Trade Management
• Oracle Accounts Receivable
• Oracle Accounts Payable
• Oracle General Ledger
• iProcurement, iPayment & iExpense
• Oracle Incentive Compensation (OIC)
• Oracle Purchasing
• Depot Repair
• Oracle Service Contracts 11i
• Oracle Core Contracts 11i
• Advance Benefits & Time & Labor
• Oracle Learning Management
• iSupplier

Oracle Applications Implementation (AIM)

Technology:

• Oracle DBMS 10g, 9i, 8i, 7, 6

• Oracle Applications - R12 & 10.4 to 11i
• Report Versions - 9i, 6i, 3.0, 2.5, 2.0
• Form Versions - 9i, 6i, 4.5, 4.0, 3.0, 2.3
• Application Object Libarary
• SQL*Plus, SQL*Loader, PL/SQL
• XML / BI Publisher
• ConfigSnapshot
• JDeveloper
• Taviz
• Toad
• Designer 2000
• Versioning tools - Kintana & PVCS
• Oracle Workflow 2.6
• Designing Tools   Erwin Data Modeler
• SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Independence, OH

Oracle Applications Consultant

Responsibilities:

• Extensively Tuned Cap Analysis Report in Oracle Applications

• Requirements gathering and worked in scrum/agile development.

Confidential, Van Buren Township, MI

Oracle Applications Developer

Responsibilities:

• Worked on reports for Turkey General Ledger (Defter Kebir) and Italy General Ledger (Libro Journal).

• Worked on BI Publisher, STAT Tax and VAT Fluctuation reports for Mexico in Oracle PL/SQL.
• Worked in ConfigSnapshot Tool migrating the one time setups from one instance to another instance.
• Generating a BR100 Document from ConfigSnapshot.
• Worked on FNDLOAD to migrate concurrent Programs from one instance to another.
• Developed a custom XML Publisher report via .XLS template design for VAT Fluctuation report.
• Developed a Custom Concurrent Program for STAT Ledger Reporting purpose for different countries.
• Created Customer Sites Listing Program in Oracle Account Receivables for Russia.
• Worked in Oracle Reports Builder, Oracle Forms, Oracle Workflow Builder, Oracle PL/SQL.
• Design and Developed Custom FA Asset Assignment Listing Report in Fixed Assets using XML Publisher.

Confidential, Ann Arbor, MI

Oracle Applications Developer

Responsibilities:

• Worked on Order to Cash Release 11i.

• Worked in loading employee data in Oracle HRMS.
• Worked on Item usage report, tuned the report for performance from 22 Hours to 45 minutes in Production.
• Performed workflow customizations for Requisition Workflow.
• Worked in Oracle Work in Process Module, Developed 1st piece Inspection Report in Oracle Reports Builder which gets the data from BOM (Bill of materials) and BOM Bill Components.

Confidential, Ann Arbor, MI

Oracle Applications Developer

Responsibilities:

• Worked on Order to Cash Release R12.

• Worked on Freight Calculation Program in Oracle Shipping Execution.
• Worked on Invoice Report, Oracle Core Contracts workflow customization.
• PL/SQL development.

Confidential, Adrian, MI

Oracle Applications Developer

Responsibilities:

• Used Oracle’s Forms/Reports 11g to develop, enhance, and maintain application screens and reports.

• Converted applications from Oracle Forms 6i to Forms 11g.
• Developed PO Error Form, GL Error Form from scratch using Form Builder.
• Worked in Designer Advantage program - Custom Application like Oracle Incentive Compensation where me developed new Forms from scratch using Forms 11G.
• Worked in Oracle BOM explosion Report, Oracle Inventory Report and Item usage Report.
• Performed PO form customization to populate supplier item number in the DFF (using custom.pll).

Confidential, Edison, NJ

Oracle Applications Consultant

Responsibilities:

• Worked on Transfer of Flat file for PO, AP, Invoices to Ariba.

• Oracle Forms 10g development and Customizations.

Confidential, Charlotte, NC

Responsibilities:

• Worked on Printed Purchase Order Report.

• Oracle Purchasing Workflow Integration - worked on sending email and fax directly from Oracle’s purchasing workflow process, Send binary attachments wif notifications in Workflow.
• Forms Customizations.

Confidential, Mayfield Heights, OH

Responsibilities:

• Documenting the Modules under AIM standards.

• Design, Development, Testing, Deployment and Post Production Support Activities of the System. Worked in Oracle Forms Customization using Custom.pll and Forms Development from scratch using Template PO.
• Hands on experience on interfacing protocols and methods like TCP/IP, FTP, SMTP, JDBC, HTTP and HTTPS.

Confidential, Redwood Shores, CA

Oracle Applications Consultant

Responsibilities:

• Worked in Inventory Organization Transactions, consigned Inventory, FIFO Costing

• Worked in Discoverer 4i - Created Workbooks, Worksheets, Cross Tab, Page detail Cross tab, Page Detail Table Reports. Knowledge of data points and axis items in cross tab reports.
• Trained users to use Discoverer to develop reports and retrieve data from business folders.
• Worked on Discoverer Admin side - Created EUL (End User Layer), summary tables, (me.e. materialized views), database users, scheduled and shared workbooks to other users, exported them to excel and HTML formats.
• Created analytical functions, alternative sorts, item classes, hierarchies (Date and item hierarchy) in Discoverer.
• Worked on Order Capture APIs in Oracle Quoting, creating quotes from templates.
• Worked in Oracle Workflow Modules - Customization of Engineering Change Order.
• Creating Jobs, Position Approval Groups, and Security Attributes.
• Actively involved in Database Design & Shell Scripting.
• Developed a PL/SQL program to import the price lists from COPICS system into Oracle.

Confidential, Troy, MI

Responsibilities:

• Technical design documentation for the Custom Pick Rlease, Order load and Item Extract and customized Pick Slip reports.

• Forms development - Custom Pick Release Rule and Custom Release Sales Order form.
• Configuration of OM and shipping modules for functional team.
• Performance Tuning of the Order Load and Pick Release Process
• Reports development - Character reports, Daily Orders, Inventory Shortages and Shipment Exception Reports.
• Worked in Oracle HRMS - Application programming Interface to create employees, dependent, address, updating assignments and managing employee data
• Development of conversions and interfaces for Oracle Receivables, Fixed Assets, General Ledger using SQL*Loader and Taviz
• Performed extensive SQL, PL/SQL tuning using various Oracle Tools such as TK-PROF, Explain Plan, Level 8 trace, creating snapshot of the database.

Confidential, Houston, TX

Responsibilities:

• Custom Forms Development, and upgrade from 10.7 to 11.5.7

• Migrated all customized forms from Oracle Applications 10.7 to 11i using Designer 6i and Flint 60 method for custom forms.

Confidential, Cleveland, OH

Responsibilities:

• Customized the shipping reports - Bill of Lading, Commercial Invoice, Pick Slip Report.

• Worked on Oracle Trading Community Architecture (TCA), mapped all the Data Warehousing Order Entry queries to the corresponding queries using Oracle Hot Zone Tables (HZ tables in 11.5.8)
• Developed Open Interfaces in Oracle Purchasing module called Purchasing Document Open Interface (PDOI)
• Customized Sales Order Forms
• Migrated all customized forms from Oracle Applications 10.7 to 11i.

Arvin Meritor, Troy, MI

Responsibilities:

• Worked on various Oracle Reports - Bitmap, Character, Matrix, Nested Matrix, Conditional Duplex, Check printing through Report, Purchase Order, Invoice Print and Requisition Activity Summary Reports.

• Worked on converting Oracle AP, AR, HR data to People Soft interfaces.
• Customized the process developed for Engineering Change Order (ECO) Approval Workflow
• Customized Order Management & Oracle Engineering Module Workflows

Confidential, Kalamazoo, MI

Responsibilities:

• Developed Pack Release Order Customization, an MRP-like program dat drives the entire material handling and packing process for after market operations

• Performed Inventory transactions such as Sub-inventory transfer, miscellaneous receipts, checking availability of components, verifying and creating Bill of Materials.
• Developed a PL/SQL program to import the price lists from COPICS system into Oracle.
• Loaded customer items into Oracle automotive tables using PL/SQL.

Confidential

Oracle Applications Developer

Responsibilities:

• Implemented MultiOrg option, Y2K compliance and performance tuning.

• Extensively worked in Forms 2.3