An Oracle 11i/R12 application SOA 11g techno-functional specialist, architect, tech lead with extensive experience in application architecture, system analysis, application development, software engineering and programming. Specialized in Oracle related business packages such as: Oracle Applications 11i/R12 OM, Purchasing, Inventory, Receiving, Shipping, Oracle Time and Labor and Oracle SOA 11g.Proficient and experienced in Oracle SOA Suite 11g/R12 BPEL, OSB, ESB, BAM and AIA . Good experience in installing and configuring Oracle SOA Suite 11g and Weblogic server. Good exposure to AIA Application Integration Architecture Foundation Pack. Supported and maintained Finance, Manufacturing and Distribution modules and skilled in providing ERP software services. Highly proficient in Oracle tools, 20 years with Oracle technology, excellent technical and interpersonal skills, quick learner, interested in acquiring new technology. Possess Public Trust clearance, current till Oct 2013.

Skills Summary

Hardware Platforms and System and Application Software

Major Assignments

Confidential

• Enhanced and supported Oracle EBS Order Management and Purchasing modules
• Completed numerous Oracle Forms personalizations in the Purchasing module
• Resolved Oracle EBS production tickets on the daily basis SQL, PL/SQL, XML Publisher, Forms, Reports, personalizations etc.
• Designed and completed Oracle XML Publisher reports in EBS AR and PO area
• Improved custom Oracle EBS purchasing requisitions process by utilizing Oracle PL/SQL
• Enhanced custom Oracle EBS inventory PL/SQL procedures for replenishing inventory stock
• Created Oracle EBS APIs for Oracle SOA Gateway processes, utilized SOAP UI tool for testing web services
• Presented and demoed the client Oracle Fusion Middleware Suite of products as a potential replacement for SOA Gateway

Project duration: ongoing

Confidential

• Designed and completed Oracle SOA composites in Oracle 11i/R12 environment utilized SOA adapters: Oracle Apps, File, FTP, DB, Web Services
• Designed Oracle Apps 11i/R12/SOA architecture for porting legacy ftp programs into Oracle SOA 11g B2B environment, configured ftp/sftp trading partners setups in Oracle B2B console
• Designed and created Oracle SOA solution for integrating Oracle EBS 11i/R12concurrent programs and SOA BPEL processes utilized SOA EDN Event Delivery Network publish/subscribe model
• Integrated Oracle EBS scheduled programs with Oracle SOA infrastructure, published events from PL/SQL code and subscribed to them in SOA BPEL, integrated Oracle EBS and Siebel apps
• Simplified BPEL processes by elimination of redundant and expensive web services database polling every few minutes to accommodate scheduling processes
• Identified and catalogued the list of the current Oracle Apps 11i processes for Oracle Apps R12 upgrade
• Researched and inventoried current Oracle Apps 11i interfaces in the area of Order to Cash, Human Capital and Sales and Service for Oracle Apps R12 upgrade project
• Maintained custom Oracle Forms related to shipping processing and generating XML Publisher reports
• Provided functional and technical expertise for Oracle EBS Returns in the Hub project by utilizing Oracle packages, procedures, functions, XML Publisher reporting, barcode generation
• Maintained and supported Oracle Apps 11i Order Management and Field Services modules
• Utilized AIA error handling and email notification service
• Utilized Oracle EBS Adapter for integrating EBS Item Master modifications with Siebel products
• Completed Oracle SOA 11g Service Oriented Architecture classes at Oracle Corp.

Project duration: 2.5 years

Confidential

• Designed and created BPEL and ESB processes for orchestration
• Implemented concepts of AIA utilizing canonical data model
• Replaced legacy PL/SQL interfaces with SOA web services
• Designed and created error exception handling in SOA and EBS environment
• Ported and tested Oracle Apps 11i concurrent jobs to Oracle Apps R12
• Configured JNDI and Data Sources in Weblogic console for related SOA composites
• Subject matter expert for design and implementation of interfaces for FPS Foreign Post Settlement project
• Designed and completed Oracle Apps XML Publisher reports related to interface processing and error handling
• Designed and implemented data loads for FPS utilizing SQL Loader, PL/SQL, Unix shell and Oracle Apps concurrent programs
• Responsible for collecting and implementing interface business rules
• Created custom ETL Extract Transform Load PL/SQL programs for EDW Extract Data Warehouse system
• Designed and completed over dozen interface programs for FPS
• Designed technical block diagrams and supporting documentation for FPS interfaces
• Actively involved in post implementation activities

Project duration: 3 years

Confidential

• As an Oracle Applications Developer / Coordinator, created an Oracle Applications Concurrent Manager program for Accounts Receivable / Point of Sale POE conversion
• Wrote SQL scripts to move massive data from legacy system to Oracle Applications TCA architecture
• Completed PL/SQL program to convert 1,000,000 components per day into Oracle Applications as part of Accounts Receivable / POE conversion
• Maintained Oracle PL/SQL packages for POE SEND and RECEIVE events
• Completed Oracle procedures for reconciliation and measuring volume performance

Project duration: 4 months

Confidential

• Designed and completed Oracle back end packages, functions, procedures for web based Java application
• Written complex PL/SQL data layers for financial reports
• Improved existing ETL processes and simplified database design in Data Warehouse
• Eliminated staging tables and created Oracle pipelined functions to return data sets to Crystal Reports
• Utilized advanced Oracle analytic function for complex calculations

Project duration: 6 months

Confidential

• Designed and developed PL/SQL database back end extensions to existing Java web based application
• Maintained and supported 600 database objects stored procedures, functions, packages
• Worked closely with Java team as an Oracle architect/lead on upgrade project
• Completed impact analysis on changing PL/SQL code prior to making any modifications proactive vs. reactive approach saved about 30 time on development life cycle tasks
• Merged Oracle code from old system into new database model to support new business requirements
• Utilized new Oracle 10g features
• Documented all database changes and generated ER diagram with SchemaSpy java open source code
• Completed Java Programming classes at St Paul Tech

Project duration: 8 months

Confidential

• Designed and developed AR interface project for calculating customer balances between Oracle AR and mainframe system
• Designed and developed Web based Customer Contract application with Oracle Application Express formerly HTMLDB
• Designed and completed 11i concurrent programs to load mainframe data into Oracle Application 11i
• Integrated Customer Contract application with Oracle Application 11i
• Maintained and supported existing Oracle Application 11i programs Oracle Forms, Oracle Reports, PL/SQL, Unix shell scripts in the area of Oracle Financing, Oracle Inventory, Oracle Manufacturing and Oracle Order Management

Project duration: 9 months

Confidential

• Designed and developed interface project between 11i and WMS Warehouse Management System external system
• Provided technical and business expertise in 11i areas Order Management, Purchasing, Inventory
• Reverse engineered about 50 Pro C and Unix shell programs and rewrote them utilizing Oracle 11i Concurrent Manager utility, 11i APIs and PL/SQL stored procedures
• Developed 11i Order upload program from external system utilizing 11i Process Order API
• Designed and developed 11i interface for putting product on HOLD and taking product off HOLD 11i Inventory Adjustment
• Supported HRMS Oracle Timer and Labor - OTL custom application, utilized OTL APIs
• Created 11i interface program for returning customer products 11i Inventory posting API
• Developed PL/SQL Concurrent Program for 11i Physical Inventory Upload from external system
• Designed and completed 11i receiving interface program for receiving purchase orders into 11i from external system ROI Receiving Open Interfaces, RTP Receiving Transaction Processor
• Developed 11i receiving inventory transfers program from external system custom Oracle package
• Completed technical documentation

Project duration: 3.5 years

Confidential

• Oracle WebDB development and support
• Custom Oracle application development in Forms6I, WebDb reports, PL/SQL
• Built custom password management for Oracle WebDB Web site
• Developed and enhanced PIMS Prosecutor Management Information System Web application written in Oracle tools
• Performed Oracle 8I DBA duties on Windows NT Installed WebDB, Oracle 8I, Oracle Forms6I, supported PIMS application, created and managed database objects, user management etc.
• Developed stored procedures/functions/packages
• Wrote technical specs and documentation for the PIMS system

Project duration: 2 years

Confidential

• Developed new features for inventory replenishment project in Oracle PL/SQL
• Developed and maintained Oracle packages for General Ledger GL application in PL/SQL
• Converted DB2 queries into Oracle Discoverer Tool ver 3.1
• Created Oracle views for better performance Improved Oracle Discoverer querying
• Improved data extraction from Oracle warehouse with database back end development and Oracle Discoverer
• Created and maintained Oracle stored procedures, functions and packages in PL/SQL

Project duration: 7 months