Oracle Ebiz Resume Profile
summary
- 10 Years of IT experience on Oracle Applications E-Business Suite 11i, R12i and Oracle Fusion Middleware - SOA 10g, 11g
- Sun certified Java Programmer SCJP 1.4, Oracle Certified Associate OCA Oracle 9i, Certified Oracle E-business suite essentials for implementers.
- Multiple project experience involving Implementation, Upgrade, Customizations, Conversions, Re-implementation, Support, Solutions, Multi-Currency and Multi-language development.
- Programming and Applications Development experience using Oracle 8i/9i/10g/11g, Forms6i/9i, Reports6i/9i, , XML Publisher, PL/SQL, Oracle Fusion Middleware technologies, which includes BPEL 11g, 10g , OSB 11g , AIA, BAM 11g , ODI 11g , ESB, EBO, XSD, XSLT, XQUERY, XPATH, WSDL.
- Three Full Life Cycle Implementation Experience of Purchase to Pay and Order to Cash Business Flows on Oracle Applications R12 for Merial US and France Implementation, Gilead Life Sciences and Amway.
- One-upgrade Projects Experience from 11.0.3 to 11.5.10 for EMC Inc.
- Specialized in extensions, conversions and interfaces using Oracle Ebiz R12 and Oracle Fusion Middleware technologies.
- Functional Knowledge of Modules INV, OPM, AP, PO .
- Experience in developing R.I.C.E components across different modules in oracle Ebiz R12.
SOFTWARE SKILLSET
RDBMS | Oracle 11g/10g/9i/8i |
Languages | PL/SQL, Java, UNIX Shell Programming, Java Stored Procedure, JDBC. |
Tools/IDEs | Kintana, Remedy, WinScp, Toad, SQL Developer, Microsoft VSS, Citrix ICA Client, Share Point, Harvest, STAT, Jdeveloper 10g,11g , Eclipse, ODI 11g, BAM11g |
Oracle Fusion Middleware | BPEL 11g, 10g , OSB 11g , AIA, BAM 11g , ODI, ESB, EBO, XSD, XSLT, XQUERY, XPATH, WSDL. |
Oracle Applications Modules | Oracle Inventory, Oracle Process manufacturing OPM , Oracle Payables, Oracle Purchasing, System Administrator, Application Object Library, Flex fields. |
Oracle Tools / Components | Oracle Developer 6i / 9i Forms 6i/9i and Reports 6i/9i , Oracle Workflow, Workflow Business Events, Oracle SOA Gateway, XML Publisher, Data Template, SQL Plus, SQL Loader, Advance Queuing AQ . |
PROFESSIONAL EXPERIENCE
Lead Developer - Oracle Ebiz R12/Oracle Fusion Middleware
- Client is a global technology leader in power management solutions that make electrical, hydraulic and mechanical power operates more efficiently, reliably, safely and sustainably. It has three business groups/sectors i.e.: Electrical, Corporate and finance within the organization and has approximately 103,000 employees and sells products to customers in more than 175 countries. Project: Eaton Unify Description
- CONFIDENTIAL project is the implementation of oracle Ebiz R12 across the organization develop new RICEW components to fill GAP. Integrate new and existing components using Oracle Fusion Middleware i.e.: SOA 11g .
Responsibilities
- Involved in overall architecture design for implementing the interfaces using Oracle Fusion Middleware i.e.: SOA11g and Oracle Ebiz R12.
- Designed, developed Global error handling Framework and error monitoring Dashboard for end to end tracking of the interfaces.
- Responsible for functional and technical design reviews and assist process team members in functional unit and integration testing activities
- Collaborated with the process team on cutover planning and in coordinating integration and user testing cycles, migrations.
- Managed the technology cutover activities, reconciliations, issue management during the post-production hyper case period
- Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
- Responsible for design and development of critical Interfaces using latest technology like SOA11g, OSB11g, AIA11g and with oracle Ebiz R12. List of some of the key interfaces includes:
- 1 Chart of Accounts Interface: Outbound interface to transfer the COA relevant data from the R12 Unify Oracle source system to the Eaton manufacturing facilities Plants target systems and any other external non-Eaton users of the data.
- 2 Purchase Order Interface: Inbound interface to transfer the purchase orders from all legacy source ERP/Third Party systems to the R12i Oracle system.
- 3 PO Receipts Interface: Inbound interface to transfer the PO Receipts and Returns from all legacy source ERPs to the R12i Oracle system.
- 4 Supplier Interface: Outbound interface to transfer supplier details from R12i Oracle system to Eaton multiple ERP systems.
- 5 AP Invoice Interface: Inbound interface to transfer the Invoices from all legacy source ERP/Third Party systems to the R12i Oracle target system.
- 6 Employee Interface: Inbound interface to transfer the relevant data from the HRMS Link source system to the R12 UNIFY Oracle target system.
Environment Oracle Applications R12 GL, AR, AP, PO, OM, INV, HR Oracle DB 10g, PL/SQL, AQ, Toad, Winscp, Putty, Jdeveloper11g, Eclipse, Oracle Fusion Middleware SOA11g , BAM11g, AIA
CONFIDENTIAL
Lead Developer - Oracle Ebiz R12/Oracle Fusion Middleware
Client is a worldwide leader in direct selling business with more than 3 million independent business owners IBO in over 80 countries and territories around the world.
CONFIDENTIAL Description
The project is the fresh implementation of Oracle Applications R12 and integrates with existing external systems using Oracle Fusion Middleware i.e.: SOA11g .
Responsibilities
- Involved in functional Requirements Analysis, Technical Designs, Development and Testing.
- Involved in overall architecture design for implementing the interfaces using Service Oriented architecture between custom e-commerce solution and Oracle Ebiz.
- Responsible for design and development of critical Interfaces in the engagement using latest technology like SOA11g, OSB11g, AIA11g and ODI along with oracle Ebiz.
- Collaborated with the process team on cutover planning and in coordinating integration and user testing cycles, migrations.
- Managed the technology cutover activities, reconciliations, issue management during the post-production hyper case period
- Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
- Developed complex inbound/outbound interfaces to integrate boundary application and oracle Ebiz using Service Oriented Architecture.
- Designed and developed Global Error handling and Monitoring Framework for interface monitoring, which is used across the project.
- Designed and developed Global Message reprocessing framework to reprocess Error/stuck records. This framework is used across the project for message reprocessing.
- Worked on design and development of many interfaces, list of some of the key interfaces includes:
- 1 Shipment Confirmation Interface: Inbound interface to send the shipment information from Red Prairie to Oracle Ebiz.
- 2 PO and PO Receipts Inbound Interface: Inbound interface from JDE to send the Oracle Purchase Order and receipt to Oracle EBS to create Purchase Order and receipts.
- 3 ASN Inbound Interface: Inbound interface into Oracle EBS of ASN Advance Shipment Notice from JDE for creating the Receiving transactions in Oracle EBS.
- 4 On-Hand Outbound Interface: Outbound interface to send On Hand details by affiliate level From oracle Ebiz to the JDE and Manugistics system ASCE system to satisfy the requirement for the DRP and demand planning.
- 5 Receipts Outbound Interface: integration components involved sending the receipt information from Affiliate warehouse from oracle Ebiz to ASCE JDE system.
- 6 Shipment GDW Outbound Interface: Outbound Interface that will send the Shipment details information from OEBS to Global Data warehouse GDW . This interface will support better processing for the Inventory Optimization system and will support the new Allocator program being built. This technical solution will support batch data push from Ebiz to GDW. There will be another ETL job on GDW side, which will validate and load into GDW schema. Due to large volume data movement and batch-processing nature of the interface, this interface is designed using ODI
- 7 Employee Inbound interface: Inbound interface to move data from external Employee central system to oracle Ebiz.
- 8 Order Interface: Inbound interface used to get order creation, update information from OMS to oracle Ebiz.
- 9 Magic GL Interface: Inbound Interface required to create Journal Entries in Oracle EBS, those are coming from MAGIC system.
- 10 AR Adjustment Interface: Inbound interface from RMS to oracle Ebiz to send AR Adjustments i.e.: credit, debit memos
Environment Oracle Applications R12 GL, AR, AP, PO, OM , Developer 10g, Oracle DB 10g, PL/SQL, Toad, WinScp, Share Point, Putty, Workflow BES,Jdeveloper11g, Eclipse, Oracle Fusion Middleware SOA11g , OSB 11g , BAM 11g , AIA, ODI 11g
CONFIDENTIAL
Lead Developer - Oracle Ebiz R12/Oracle Fusion Middleware
CONFIDENTIAL is a world-leading health care company producing pharmaceutical products and vaccines.
Project: Gilead Description
CONFIDENTIAL is implementing Oracle Applications to streamline, integrate its business operations worldwide and for mapping the company's business processes. The current project caters to building new system in oracle applications for its key business operations and to obsolete its various legacy systems in future. This also addresses building business intelligence reports for its key users. Also included in the scope of this project is the data conversion and interface from legacy system JDE, MES, and KRONOS etc. to Oracle Application R12.
Responsibilities
- Responsible for design and development of some of the critical Interfaces in the engagement using latest technology like Oracle Ebiz R12, SOA10g and AIA.
- Responsible for functional and technical design reviews and assist process team members in functional unit and integration testing activities
- Collaborated with the process team on cutover planning and in coordinating integration and user testing cycles, migrations.
- Managed the technology cutover activities, reconciliations, issue management during the post-production hyper case period
- Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
- Developed complex inbound/outbound interfaces to integrate boundary application and oracle Ebiz using SOA and AIA. Designed a framework to control all outbound interfaces to Boundary system MES to follow Singleton architecture.
- Worked on design and development of many interfaces, list of some of the key interfaces includes:
- 1 Item Outbound Interface, this interface is used to send information from Ebiz to MES. It helps to synchronize Ebiz and MES for items information.
- 2 Work Order Outbound interface, from Ebiz to MES: This interface is used to Publish Work Order OPM batch related information to MES.
- 3 On-Hand Outbound from Ebiz to MES for Reconciliation: This interface is used to publish on-hand quantity related information to MES for Reconciliation.
- 4 Lot Status Change Outbound from Ebiz to MES: This interface is used to publish Lot Status and related information as per the business requirement to MES.
- 5 Work Order Inbound interface from MES to Ebiz: This is an inbound interface, where MES Publishes Work Order OPM Batch related information to Ebiz. This interface updates the status of the Batch in Oracle EBS.
- 6 Work Order Step Inbound from MES to Ebiz: This is an inbound interface, where MES publishes Work Order Step OPM Batch Step related information to Ebiz. This interface updates the status of the Batch Step in Oracle EBS.
- 7 Designed a framework/architecture using SOA to control all the outbound interfaces from oracle Ebiz to MES to maintain Singleton architecture. Maintain the sequence of the messages as per their occurrence in Ebiz and control the flow of the messages in the same sequence to MES.
- 9 Payable Invoices from Brainware to Ebiz Inbound: This interface gets data from Brainware, to oracle Ebiz and as per the business requirement does validation, derivation and using oracle Payable Standard Import program create the invoice with attachments in oracle Ebiz.
- 10 Involved in defect fix and resolution of the interfaces.
Environment Oracle Applications R12 GL, AR, OPM, INV, AP, PO , Developer 10g, Oracle DB 11g, PL/SQL, Toad, SVN, Putty, Jdeveloper10g, Oracle Fusion Middleware SOA10g , AIA
CONFIDENTIAL
Developer - Oracle Ebiz R12
- CONFIDENTIAL is leading manufacturer of environmental and industrial measurement instruments.
- CONFIDENTIAL Description
- The Implementation of oracle application R12 GL, AP, AR, OM, SCM, PO modules is to enhance their business and revenue.
Responsibilities
- Involved in functional document FD walk through and discussion with client regarding requirements.
- Creation of technical design.
- Development of two custom forms and personalization for sales order screen
- 1. POPUP Form which get invokes when control moves on the unit selling price first time at sales order lines and user can invoke the same form using ZOOM functionality and many business rules are applied on this form.
- 2. Data Entry form to hold information in the custom table.
- Preparing UTP Unit Test Plan and IG Installation Guide for the build.
- Worked on Various AOL related activities.
Environment Oracle Applications R12, Oracle DB 10g, PL/SQL, Toad, SVN
CONFIDENTIAL
Developer - Oracle Ebiz R12
Client is a leading animal health company producing pharmaceutical products and vaccines for livestock, pets and wildlife.
CONFIDENTIAL Description
Implementation of Oracle Applications R12 as mapping the company's business processes.
Responsibilities
- Involved in requirement gathering with client and designing functional document FD walk through and technical design preparation.
- Involved in specifying and review of coding standards for the team.
- Coding and preparation of build for RICE objects.
- Mainly worked on various conversions related to OPM, INV, AP modules.
- Such as Suppliers, Operations, routing, Formula, Recipe, Stock Locator, Notes Conversions etc.
- Worked on design and development of interfaces, using BPEL, ESB.
- Developed XML Publisher Reports using Data Template.
- Lot Genealogy Report, Invoice Print Report using Data template etc. .
- Developed various Forms and PL/SQL extensions.
- Worked on Forms personalization, custom.pll and Zoom functionality.
- Preparing UTP Unit Test Plan and IG Installation Guide for the build.
- Various AOL related activities.
- Developed various objects and gave production support for those objects.
- Developed some reusable components which organization is using across modules.
Environment Oracle Applications R12 GL, AP, AR, INV, PO, OM, OPM , Developer 6i, Oracle DB 10g, PL/SQL, Toad, STAT, XML Publisher, Oracle Fusion Middleware SOA10g
CONFIDENTIAL
Developer - Oracle Ebiz 11i
- CONFIDENTIAL. is one of the largest data storage providers in the world.
- CONFIDENTIAL's current Customer Services processes and systems are focused on hardware support and in some cases focused onCONFIDENTIALSymmetrix product line. The increasing software focus is putting pressure on these processes to sustain the business. Additionally, many of the CS systems are on aging platforms that are approaching the end of their support from vendors. Finally, a requirement coming out of the acquisition team is the integration of the Documentum and Legato systems and processes.
- Update archaic disparate systems enable state of the art response across all divisions.
- Provide a unified customer service experience including self-service, software capabilities, entitlement and electronic license management.
- The Customer Service Integration project is focused on four major functions within Customer Service:
- Field Service Support,
- EMC Support Centers,
- Logistics and Warehouse Management
- Service Contracts.
- Responsibilities
- Developed Workflow objects.
- Worked on conversion contract discount and Historical pricing .
- To keep execution of conversion in production on time helped onsite team and pulled the reconciliation success and fall rate during execution reports for the same.
- Working on enhancements and fixed SIR's Service investigation Request for RICE objects specially related to Oracle CRM module .
- Working on enhancements, fixes SIR's and investigation tickets for workflow objects.
Environment Oracle Applications R11i INV, CRM , Toad, PL/SQL, PUTTY, WINSCP
CONFIDENTIAL
Developer - Oracle Ebiz 11i
- CONFIDENTIAL . is one of the largest data storage providers in the world.
- CONFIDENTIAL Description
- CONFIDENTIAL's current QTC functions include varied processes on disparate ERP platforms. In order to comply with the CONFIDENTIAL tax structure, realize the corporate cross-selling strategy, capitalize on back office synergies, and facilitate future scalability, these processes must be standardized on a common ERP system. The QTC project is charged with delivering the following key capabilities:
- Single, common ERP platform worldwide.
- Common and consistent policies and procedures across BU's.
- Compliance with EMC commissionaire tax structure.
- Consolidated master data, including customer master, item master, sales hierarchy and price repository.
- Creation of single, cross BU quotes.
- Automated integration of quote and order entry tools.
- Support of Direct and Indirect Channels.
- Electronic fulfillment.
- Automated tracking of SW license keys.
- Automated commissions processing for Legato and Documentum.
- Common and consistent cross-BU data definitions and business rules.
- Governance structure for data creation, maintenance to ensure quality.
- Clearly defined reporting data security rules across business units.
- The scope of the project involves implementation of new 11.5.10 version and migration of custom objects from 11.0.3 to 11.5.10.
Responsibilities
- Involved in functional document FD walk through and discussion with client regarding requirements.
- Creation of technical design.
- Customization of Reports, JSP Customization.
- Worked on Inventory Item Conversion Item, Revision and category .
- Mainly worked on development and customization conversion and bug fixing.
- Preparing UTP Unit Test Plan and IG Installation Guide for the build.
- Interaction with client-Solving SIR's.
- Coding and preparation of build for RICE objects.
- Various AOL related activities.
- Developed objects and also gave production support for those objects.
- Developed some reusable components which organization is using across modules.
Environment Oracle Applications 11.0.3, 11.5.10 INV, OM, AP, GL , Developer 6i, Oracle DB 9i, PL/SQL, Toad, Putty