Senior Oracle Technical Consultant Resume
TECHNICAL SKILLS:
- Java/J2ee
- HTML,JSP,XML,XSLT,EJB,STRUTS,SERVLET,JSF,WEBSERVICES
- SPRING,JTA
- Oracle eBusiness 11,12
- Functional extensive background iExpense iPayment iProcurement iSupplier iSupport iStore
- ADVPRICING
- AR
- BOM
- FIELD SERVICE
- INV
- Confidential
- PO
- QUOTING
- TCA
- TELE SERVICE
- WIP
- Technical extensive background
- Forms
- Reports
- Discoverer
- Workflow
- PL - SQL
- Interfaces/APIS
- SOA Gateway
- OA Framework
- JTT-JSP
- Oracle Development Suite
- Forms
- Reports
- Discoverer
- PL/SQL
- Oracle Fusion Middleware
- Confidential 11g,12c
- SOA-BPEL 11g,12c
- BPM 11g,12c
- OBIEE
- B2B 11g
- Confidential /WEBCENTER
- Oracle Cloud Applications ( Procurement, Financial, Projects, Customer )
- File Import Loading ( manual )
- File Import Loading OER Programmatic Java Development
- OER Programmatic Java Development
- OTBI/BI Development
PROFESSIONAL EXPERIENCE:
Confidential
Senior Oracle Technical Consultant
Responsibilities:
- Oracle EBS/On Premise
- Supplier Load Processing API Development
- Customer Load Processing Development
- Item and Item Cross Reference Load Processing Development
- Sales Order Import Load Processing Development
- Open POs
- EBS Forms Customizations
- Item Cross Reference Checks
- Confidential Order Header and Line Entries
- PO Order Line Entries
- TCA OAF Personalization Work
- Oracle Cloud
- Responsible for various Setup & Maintenance Organizational Structure Functional Data Population ( Business Units,Payment Terms)
- Manual File Loading ( Programmatic Oracle Excel Spreadsheet Data Population )
- Responsible for data, data integrity, constraint verification, error validations and re-processing when necessary
- Suppliers, AP Invoices, Customers ( external data provided by the client )
- Responsible for post processing UI data verification
- File Loading Programmatic Web Services Development
- Developed Java based file loading module based upon OER web services that parallels the manual file loading process
- OER Web Services Development
- Developed Purchase Order Creation Java module based upon OER web services using JDeveloper proxy creation facility to first generate the necessary proxy code based upon the OER PO WSDL as well as security authorization requirements; module allowed free form data entry or input file processing capabilities and had detailed error handling reporting
- Developed Item Creation Java module based upon OER web services using JDeveloper proxy creation facility to first generate the necessary proxy code based upon the OER Item WSDL as well as security authorization requirements; module allowed free form data entry or input file processing capabilities and had detailed error handling reporting
- Minor BI Report Development
Environment: Oracle-EBS 12.1.3 ( FIN/ Confidential /PO/INV/TCA footprint ), Oracle Cloud 11.1 ( PROCUMENT,FINANCIAL,PROJECTS ), JDeveloper 12.2
Confidential
Senior Oracle EBS/Fusion Developer/Consultant
Responsibilities:
- Oracle EBS customized GL Forms development and GL support responsible for taking a legacy and extensive grouping of MOD-PLSQL screens known as the Confidential internally based financial system and converting these into Confidential /SOA based solutions; the main thrust of this current application is that it takes data and feeds the Oracle EBS GL sub-system as well as other Oracle EBS areas; this project is premised on Oracle’s discontinuing support of MOD-PLSQL
- Confidential replacement UI component requirements
- DB/Model component requirements application rule based requirement definitions application flow based requirements definitions user security based requirement definitions using EBS/ Confidential integration components extensive Confidential based development extensive Confidential application testing extensive J2ee development extensive SOA based development extensive use of the Human Workflow extensive SOA application testing
Environment: Oracle-EBS 12.1.3, SOA/WLS 12c, JDeveloper/ Confidential 12
Confidential
Senior Oracle EBS/Fusion Developer/Consultant
Responsibilities:
- responsible for developing a custom re-engineering Confidential based solution that converted a global legacy windows based application into an Confidential /WLS/SOA/EBS application platform extensive MD50 documentation describing and analyzing the legacy system in place and preparing the re-engineering/migration plan
- Confidential replacement UI component requirements
- DB/Model component requirements application rule based requirement definitions application flow based requirements definitions user security based requirement definitions using EBS/ Confidential integration components extensive Confidential based development extensive Confidential application testing extensive SOA based development extensive SOA application testing
Environment: Oracle-EBS 12.1.3, ODI, SOA, Confidential 11.1.2.3
Confidential
Senior Oracle Fusion Developer/Consultant
Responsibilities:
- Responsible for developing an Oracle Confidential mobile application for Confidential that allowed customers to access their profiles and view specific BDI catalogue information as well as promotional material pertaining to their individual accounts.
- Security/login layer development
- Presentation layer development text, images
- Interactive layer development inquiry
- Data layer development
Environment: Confidential /MAF, WLS, JDeveloper 12c
Confidential
Senior Oracle EBS/Fusion Developer/Consultant
Responsibilities:
- Responsible for modifying the Oracle based WDK/DRM out of the box Confidential /SOA BPEL solution to fit the customized needs of Confidential ’s business requirements extensive Confidential based development and SOA integration work
Environment: Oracle-EBS 11.5.2, Hyperion DRM, Essbase, ODI, SOA, Confidential
Confidential
Senior Oracle Fusion Developer/Consultant
Responsibilities:
- Responsible for developing a small prototype Oracle Confidential mobile application that demonstrated the technology to an individual customer as well as acting as a direct comparison to seeing the native behavior of a native Confidential application being accessed and run via the handheld browser.
Environment: Confidential /MAF, WLS, JDeveloper 12c
Confidential, Atlanta, GA
Senior Oracle EBS Developer/Consultant
Responsibilities:
- Development of an EBS Financials outbound and inbound set of interfaces that extract and reconcile GL based information into a second party financials’ system which is the main accounting system for Confidential
- PL/SQL, internally developed java based web services
- External web service call interfaces
- Development of an extensive Confidential dashboard like application that acted as a front end utility for both monitoring, viewing and searching the transactions that encompassed the interface as described in the previous line
- BC4J and EJB (JPA) model components
- FAH Transaction Object Creation and Data Mapping
- Development of a BPM workflow specifically designed for GL accounting users to approve and facilitate month end closings
- Development of various financial GL reports using OBIEE specifically for line of business drill down requirements
- RPD creation
- OBIE design and development
Environment: Oracle-EBS 12.1.3, GL,FAH,,JDeveloper 12c, BPM, OBIEE, Weblogic Application Server
Confidential
Senior Oracle Fusion Apps Developer/Consultant
Responsibilities:
- RICE based Confidential UI customizations and extensions
- Development of a custom extract XML based HR payroll process that feeds a centralized corporate accounting system; this extract was designed to accommodate a necessary process that needed to be built as it currently existed in the legacy HR system that Confidential was migrating off; numerous data dependent elements, both payroll and demographic/user based, had to be both captured and extracted on a scheduled and ad-hoc basis
- Responsibilities included
- Detailed review of the current functional specifications
- Modification and revamping of the current process to accommodate the Fusion Apps HR schema
- Development of the data capture event processes automated
- Development of the extract and output build processes
Environment: Oracle-EBS HR Fusion Apps, JDeveloper 11.1.2.2, Weblogic Application Server
Confidential
Senior Oracle Fusion/ Confidential /Webcenter Developer/Consultant
Responsibilities:
- Conversion of an existing Oracle Confidential 10g application into an Oracle Webcenter/ Confidential 11g operating environment
- Responsibilities included detailed review of the existing Oracle Confidential 10g application re-engineering of all Oracle Confidential 10g/ Confidential 11g incompatibilities into the Oracle Confidential 11g framework conversion of the heavily customized existing BC4J data model re-testing of all Oracle Confidential 11g converted components designing Webcenter central application login facility designing Webcenter central Confidential application framework re-engineering all converted Oracle Confidential 10g pages into taskflows
Environment: Oracle WLS, Oracle Webcenter, JDeveloper 11g/ Confidential, Oracle OID
Confidential, Petaluma, CA
Senior Oracle e-Business Developer/Consultant
Responsibilities:
- Implementation of an automatic input file based order entry system that feeds EBS directly using Confidential based APIs
- Modification/enhancements to various SOA-BPEL and OSB processes
- AR inbound invoices
- AR outbound invoices
- Inbound POs
- Inbound Advanced Shipping Notices
- B2B configuration support and modifications new trading partner configurations new agreement configurations new transaction configurations
- Augmentation and improvement of error handling techniques used within the SOA/B2B/EBS processing
environment: and the replacement of BAM integration points with a customized code and a customized error dashboard the idea here being to replace the requirement of BAM as a product with indirect use of Oracle B2B metadata tables
Environment: Oracle EBS 12.2,SOA 11g,B2B,BAM,JDeveloper 11g
Confidential, Chicago, IL
Senior Oracle e-Business Developer/Consultant
Responsibilities:
- General and ongoing EBS Confidential, B2B and EBS manufacturing technical support
- General and ongoing support of iExpense OAF based customizations
- General and ongoing support of a customized OAF based quoting system that integrates directly into Confidential
- Development of various internal PL-SQL/SOA-Gateway webservices used for external EBS data integration functionality
- WMS customizations ( minor receiving screen customizations )
- Support of an in-house Oracle SOA 10g custom application integrating Siebel and Oracle Field Service new feature and support and maintenance of the application
- Development of Oracle SOA 11g custom applications with specifics to external data integration into EBS R12 development of numerous complex composite/mediator/human workflow applications integrating various external environments with WMS; BAM integration with SOA used for programmatic error reporting purposes new EBS item integration new EBS customer integration warranty integration
Environment: Oracle EBS 11.3,12.2,SOA 10g,SOA-Gateway,11g,B2B,BAM,JDeveloper 9,10g,11g
Confidential
BPM Developer/Consultant
Responsibilities:
- Designed and built two BPM prototype projects involving UI, Rules, Gateway, and various SOA components
Environment: Oracle SOA,BPM 11g,JDeveloper
Confidential, Chicago, IL
Senior Oracle e-Business Developer/Consultant
Responsibilities:
- Customized SOA/BPEL/OSB process development integrating EBS and various external project management systems
- EBS HR Integration
- EBS Financial GL Integration
- Oracle Primavera Integration
Environment: Oracle EBS 11.3,SOA 11g,Primavera,JDeveloper 11g
Confidential, Baltimore, MD
Senior Confidential Developer/Consultant
Responsibilities:
- Review and comprehend Oracle Forms application
- Develop strategy and design behind the migration effort task flow based
- Evaluate the Forms Application
- Determine workarounds for all non available Confidential parallel components
- Design/evaluate navigation requirements
- Map each and every forms component to Confidential
- Map security issues
- Map triggers
- Develop each and every component involved in the Confidential rewrite project
- Develop and execute test plan scripts
Environment: Oracle 11g,JDeveloper
Confidential, Chicago, IL
Senior Oracle e-Business Developer/Consultant
Responsibilities:
- Oracle Confidential Forms based customization work
- Oracle PO Forms based customization work
- Oracle Confidential Workflow extensions
- Oracle AR outbound invoicing extract processing
- Oracle Sales Contract Forms based customization work
- Oracle Tele-Service Forms based customization work
- Oracle Field Service Forms based customization work
- OBIEE based customization work tied to specific Order Management dashboards related to shipping and carrier management
- AME Customization PO
- Oracle Inventory based customization work
- Oracle Quality plan creations
- Developed numerous automated OM/Shipping Email applications Java based
- Development of various customized SOA-Gateway based PL/SQL stored procedures to allow external web service calls into the environment
- Quick Orders
- Order History
- Oracle TCA/OCO OAF custom extensions
- Oracle iProcurement OAF custom extensions
- Oracle iSupplier OAF custom extensions
- Oracle iPayment Integration
Environment: Oracle EBS 12.2,JDeveloper 9.3, SOA-Gateway
Confidential
Senior Oracle Confidential /SOA Developer/Consultant
Responsibilities:
- Confidential 11g custom development
- UI and Model
- SOA-BPEL 11g custom development
- Data integration processing involving complex XSD mapping
- Human Workflow integration for user review and re-execution of various processes
Environment: Oracle 11g,Oracle SOA 11g,JDeveloper
Confidential, Atlanta, GA
Senior Oracle e-Business/SOA/B2B Confidential Developer/Consultant
Responsibilities:
- Worked on various Oracle B2B server setups/configurations channels file,ftp, partners,transactions,agreements,reports,queue setups,auto-generation of 997s
- Developed and enhanced various inbound and outbound SOA based B2B/EBS processes
- Confidential 810 Outbound Invoices
- Confidential 820 Outbound Payment Order Remittance Advice Transaction
- Confidential 824 Inbound Acknowledgement re: 820
- Confidential 850 Inbound Sales Transaction
- Confidential 855 Outbound Sales Order Acknowledgment Transaction
- Confidential 856 Outbound Advanced Shipment Notice Transaction
- Confidential 869 Inbound Order Status Transaction
- Confidential 870 Outbound Order Status Report
- Developed error handling code for various B2B BPEL processes
- Developed and Confidential based tool for managing and reviewing all Confidential B2B/SOA/EBS process flows
Environment: Oracle EBS 12.2,Oracle SOA 11g,JDeveloper 11g
Confidential, New York City
Senior Oracle Confidential /J2ee Developer/Consultant
Responsibilities:
- Designed and developed new Confidential based applications ( UI and Model components )
- Designed and developed various Webcenter prototype applications
- Customized Confidential taskflow components
- Customized login functionality
- Integration of the Search and Document Manager seeded taskflows for file based search capabilities
Environment: Oracle 11g,JDeveloper 11g
Confidential, New York City
Senior Oracle /J2ee Developer/Consultant
Responsibilities:
- Designed and developed new Confidential based applications ( UI and Model components )
- Designed and developed security model for the Confidential application base integrating directly with OID
- Designed and developed various OBIEE dashboards and reports using BI answers
- Developed and assisted with modifying various ODI workflows
- Designed and developed various test scripts for UAT
Environment: Oracle 11g,OBIEE,JDeveloper 11g/ Confidential, ODI