Professional Summary

Results-oriented Professional with over 20 years of experience in Consulting , Analysis, Support, Development and Implementation of Oracle EBS Financials , P2 Energy and Manufacturing applications for major USA Energy companies and business corporations, Federal and State Government agencies.

PROFESSIONAL ACCOMPLISHMENTS

Specialized in implementation . development and deployment of all Oracle EBS financial and Project accounting suites from 10.5 , 11i to 12 version. Ssuccessfully built interfaces , extensions, form personalization , EDI , ETL OBIEE reports for the company. Implemented third party software P2 Energy suites on production , costings ,allocation , and revenue modules interface to Oracle AP / AR / GL. Acted as tier 2 level support for major global corporation EBS suites , and data management systems for Europe , Asia Pacific , and United States. Implemented Oracle SOA to run Oracle J2EE applications for AP , iExpense nationwide and overseas on image processing and approval workflow.

Professional Experience

Confidential

Sr. Oracle Developer/Analyst

As Oracle EBS applications R12 and P2 Energy suites support lead

• Accomplishments and Projects Worked on
• Implemented the P2 Energy Revenue , Production , and Joint Interest Accounting applications successfully in 10 months
• Supported oil fields exploration , transportation data collection and volume sales reporting
• Reconciled all business units reporting for internal audit and SOX requirements
• Developed Oracle system alerts successfully for the company Production and Revenue team in daily / monthly production volumes XML reporting
• Administered for change management system fir application upgrades and changes using STAT / PVCS migration tools
• Collaborated with DBA in migration of legacy applications from downtown data centers to corporation enterprise iCloud servers environment
• Reconciled all monthly production volume data and interface to SAP PRA system
• Troubleshot application interface problems for company Wellcore and Openwells interfaces and performance tuning on real time transaction processing

Confidential

Principal Consultant

Techno functional developer implementation of Oracle r11i , r12 EBS financial and manufacturing suites

• Accomplishments and Projects Worked on
• Implemented Oracle AP for US Air Force Agency overseas base and built XSD query models and documentation.
• Implemented Oracle R12 manufacturing supply chain applications including BOM , Inventory modules and RICE components for a major US and UK steel manufacturer
• Uplifted and created manufacturing Sales Order Entry workbench to Discrete WIP jobs creation for the factory manufacturing planners in London
• Developed Inventory Costing Reports using BI XML publisher output format for control of manufacturing production variances.
• Implemented Oracle R12 for Emerson Manufacturing. Developed assemble-to-order ATO , Configure to order CTO , Advance shipping notice / EDI form 854 for Order fulfillment extension for the Oracle Order Management module
• Troubleshoot and configured a major client's Oracle Enterprise Asset Management installation
• Developed some XML publisher reports , iPayment and Gateway for credit card authorization and internal processing for an Aviation Fuel company on b-to-b ordering fuel from different aviation supplier using XML punch out purchases of stock fuel.
• Collaborated with client's controller in setting up FSG Financial Analyzer to build up data mart for their marketing department Sales On line database , and use BI model language UML to translate their reporting requirements on Advance collection modules
• Troubleshot and suppored t for a complex Fuel pricing customized billing and AR system for an Aviation company.

Confidential

Sr. Oracle Developer/Analyst

• Business System Analyst to implement Oracle EBS financial suites and support outside investment data interfaces
• Accomplishments and Projects Worked on
• Implemented Oracle Financial Cash Management Applications support group on developing muti-currency reporting , consolidation , audit reports utilizing Oracle KPI dashboard, Reports 6i and Discover 10g..
• Worked as project lead for implementation of Markview 170 system imaging system successfully for global AP invoice and PO processing and iExpense , iPayment using JDeveloper , and SOA 3 Tiers architecture. It involved modification of Oracle AP FORMs and PLL library and iExpense Self Service FORMS localization for global deployment. Converted 300,000 archive AP invoice images from outside system to Oracle AP attachments
• Maintained and support for Oracle Financials interface to company Oracle OTL, and Enterprise Data Warehouse Informatica ETL to monthly budget reporting tool CLARITY , Crystal reports loading from the fact and dimension tables.
• Maintained and developed an Unix based CA Autosys job scheduling system to submit Oracle Financials reports , Automated all outside import and export of secured data transfer from the major financial institutions and to the clients.
• Supervised an offshore development team of 5 for new development projects in create some customized in house Sales Order and outside feed to AR and iPayment system for the marketing department.

Confidential

Senior Computer Scientist

As Technical Consultant /Developer for CSC EBS group

• Accomplishments and Projects Worked on
• Acted As Technical Consultant /Developer for CSC Inc. Oracle 11i 11.5.8 .9 support for BAE system. Developed Contract Billing report for the Oracle Order Management module, and Troubleshoot problems for the Oracle Depot Repair and Work Order systems, and Self Service Contract renewal. Converted three custom FORM for RFP from FORM4.5 to 6i.
• Acted as Technical lead in Legacy Purchasing and Inventory conversion project to Oracle iProcurement for General Dynamics Land Canada . Designed and developed programs to process over 50,000 purchase Orders / Price Lists , Project costing, and attachments from legacy SAP system and manual processing . Successfully converted PO on time for the client , and support all client pilot room raining setup and data on Oracle Purchasing. Troubleshoot and fix all client purchasing data issues , and followed up on Oracle TAR issues on Purchasing / Inventory.
• Implemented Oracle Project Accounting , Time and Material Billing conversion / interface project for General Dynamics USA SRS , FSU/IES departments. Designed and developed three custom interface processes for Accounts Payable module , and utilized the CSC custom Interface Module to automate the user submittal processing efficiently.
• Bulk loaded successfully all Approved Supplier list from SAP Purchasing data , and modified some Java Server program units in iProcurement module , and Oracle Workflow process for locations approval
• Assisted the client to setup and implement of Oracle Project Accounting and wrote inbound and outbound interfaces. Also set up Enterprise Asset Management modules to support the Warehouse Work Order system nationwide.

Confidential

Principal Consultant and Developer

• Implemented and developed Oracle financial applications
• Accomplishments and Projects Worked on
• Acted as Technical Lead Consultant for Oracle 11i Global Deployment of Sales Order Management for USA and Canada . Design Oracle Extension , Interfaces , and Workflow for the client , and send it to offshore development center at McGraw Hill Publishing Corporation
• Customized the A/R Customer and Product Search , Self-Service Contract renewal, Order Hold and Combine , Advance Pricing , and legacy system interface using TIBCO toolset
• Performed setup and configuration for Oracle 11i Purchasing 11.5.8 to Project Accounting , iProcurement re-engineering project for the Department of Energy at New Mexico
• Developed some J2EE class and subclass standards for the Procurement reporting and queries
• Converted a legacy system Purchase Orders into Oracle Purchasing using Oracle API. Designed an extension to Oracle Purchasing for importing outside Change Orders
• Collaborated with client's Data warehouse group to design reporting data models using Informatica ETL tools and Object Oriented topology to formulate user and regulatory reporting requirements from Oracle FND tables and views
• Implemented Oracle Sales Order Management and CRM 11.5.3 implementation at Olshan Foundation Repair Corporation and customized the Oracle Sales Order Acknowledgment for different divisions and Accounts Receivable Aging report
• Developed Oracle Collection Credit Card Center and CRM - 11i Tele Services implementation at Thousand Trails Corporation using Oracle Advance Pricing Model to implement complex pricing membership fees calculations at renewal time
• Designed an extension of Pick-To-Order shipment screen for in transit shipment of metal slabs to warehouses for Texas Lone Star Steel manufacturing plant. Implemented Oracle Discrete Manufacturing OPM , Receiving and Deliver control of raw materials to the shop floor control. Assisted the Project Lead in using Oracle Configurator to set up BOM model for the ATO items , and developed some Oracle BIS Discoverer 3i views for the clients to do special ad hoc reporting of inventory planning management
• Converted 10000 inventory items and pricing schedules from Oracle 10.7 to 11i Inventory module for Hotworx Furniture Wholesale Corporation . Imported Supplier price list , catalog , and export items to iSTORE applications. Implemented Inventory distribution logistics using Oracle Warehouse Management System WMS Drop Shipment functionality
• Provisioned Oracle Project Accounting OPA 10.7 Stabilization implementation at Kaiser Aluminum Corporation including interfaces to third party system , inbound and outbound on materials and purchases.

Confidential

Principal Consultant

• Technical Lead Consultant Financial and Energy suites
• Accomplishments and Projects Worked on
• Implemented Oracle Energy Upstream products now P2ES at Conoco, Inc. In Ponca City , OK successfully. Responsible for Legacy data migration, building conversion, GL accounts generator and interface program modules. Using Oracle Discover to develop End User Layers query views requirement for the Financial Reporting.
• Developed Oracle Application Programming Interface API for Legacy data conversion, Forms ,Reports and GUI version of Production Accounting and Market Accounting/Revenue applications at Oracle Energy Development Center in Denver , Colorado.
• Worked as Technical Lead Consultant for implementation of Oracle Energy Upstream products at Phillips Petroleum Company, OK. Responsible for Legacy data migration and third party financial software package SAP interfaces. Acted as technical lead and liaison between the client IT project team and Oracle Development Center in Redwood Shores.
• Successfully implemented Oracle Energy and Gas Marketing applications for two Phillips Divisions. Elected as Consultant of the Month for the Oracle Energy Consulting.