costing and pricing of Sales
Dev. Business Analyst, Senior
Tech lead designer analyst and developer for integration solution between Infor CPQ (Configure Price to Quote) and Infor EQ (Enterprise Quoting) to Oracle EBS.
Integration package manages the generating of Sales Orders, configuring items, creating configurations, bill of materials, routings, and all related activities.
Handling the costing and pricing of Sales Order and lines.
Generating of Web service composites to interact with diverse applications with Oracle and other external applications (intra/extranet) using SOA Suite set of components.

Barcode printer and scanners

Enterprise Solutions Architect
 Tech lead for design and implement solution for new Distribution Center to utilize mobile devices - Android and Windows CE - and barcode printer and scanners.
Integration extending Oracle e-Business Suite APIs for Receiving, Shipping and Physical Inventory through Oracle SOA technologies – DB Adapters, Web Services, JDBC, JNDI, WSDL, XSD, XSLT, Java, ADF.
Activities: Gathering requirements from meetings from VP Supply Chain, setting Proof of Concept, designing and presenting prototypes, demos, generating and performing test scripts, handling migration and production support.
 Tech lead for design the integration for new Blending facility and integrating it to Oracle Manufacturing modules – Bill of Material, Inventory, Work in Progress.
Activities: Database objects created to integrate e-Business Suite BOM, INV and WIP modules to support Blending facility activities.
 Key member for the implementation of the Change Management tool STAT that help the Newpark to streamline the process of code maintenance, approval and migration to Production environments. Handle the maintenance and creation of new objects – LCT – that are available for the STAT migration tool.
 As member of the Oracle e-Business R12 implementation team, for a couple of US implementations, designed, developed, implemented and supported Interface programs and data conversion packages for TCA / HZ – Customers, accounts, addresses, profiles -.
 As member of Canada Oracle e-Business R12 implementation team, developed several reports for Tax department to reduce the time of reporting the monthly reports for Canada Sales and Use Tax
 As member of New Zealand and Australia Oracle e-Business R12 implementation team, collaborate setting the security profiles for Responsibilities and Functions created for the integration between EBS and BI.
 Lead designer and developer the custom HR interfaces for 401K and benefits – Medical and Dental – in collaboration with the HR and Payroll Directors.
 Created a custom solution for Business Units to interface Project Accounting modules transactions (Project Billing) for Expenditures using APEX and integration with R12 EBS.
 Extensive work on Reports, Interfaces, Extensions, Conversions and Workflow items – RICEW – R12.1.3 on modules: BOM, WIP, INV, AP, AR, GL, SLA, PO, QA, PA, ONT, OIE, HR, BEN, PAY.
 Resolution of production Oracle Application support issues.

Salary Planning

Senior Oracle Applications Developer
 Tech Lead for design several solutions for Global HR using Oracle Application Express (APEX): Salary Planning, Organization Leadership Planning and Long Term Incentives award process.
Integration between solutions and the Oracle e-Business HR was handled via APIs and interfaces.
Activities: Gathering requirements with HR Directors and Project Managers, setting POC, creating a prototype, demos, handling migration and production support.
 Tech Lead developer for an application using APEX for a Drill-Down dashboard for all manufacturing hours/project information
Information for the Application was sourced from Oracle e-Business suite modules WIP, INV, HR and PA.
 Tech Lead on the Universal Content Management implementation.
Three main projects where part of the implementation:
o Migration of Oracle e-Business Suite attachments to UCM and integrate.
Integration developed using Oracle SOA components: BPEL, SOA Composites, and Java
o Financial Support Documents
Custom solution created using Oracle UCM and integrated to Oracle e-Business Suite to Link every document to its journal entry.
o Risk Document Approval
Custom solution created using Oracle UCM.
 Develop Custom extension application for HR pages for access and look up employee and contractors information using ADF. Information was interfacing data from core Oracle EBS Global HR instances.
 Implementation and Support for Cash Management module that include Bank reconciliation process and integration with Receivables and Payables modules of Oracle Financials.
 Member of the GSP - Global Singular Process- Technical Team in the 11i (11.5.10) global implementation project – United States, France and Germany -, and then to the 12.1.3 upgrade.
 Extensive work on Reports, Interfaces, Extensions, Conversions and Workflow items – RICEW – on 11i (11.5.10) and R12.1.3 on modules: BOM, WIP, INV, CE, AP, AR, GL, PO, QA, PA, OE, OM, ONT, OKS.
 Data Conversion for Oracle e-Business Suite modules: INV, PO, AP, PA.
 R12 and 11i (11.5.10) Production support on Oracle Applications modules GL, AP, AR, CE, OM, PO, INV, WIP, BOM, PA, Workflow. Worked extensively in fixing the Post Production issues raised by users, for which I used Oracle Meta link for SR/TAR logging.
 Handling migration of development objects and support through Oracle instances using HP-Project and Portfolio Management, formerly known as Mercury/Kintana.
 Collaborate with the leadership on deploying Discoverer for US, France and Germany: Administration and Development of Reports, Creation of Business Areas, Folders, Item Classes, PL/SQL Functions, maintenance of privileges and use of Export/Import utility.

e-Business Suite

Senior Oracle Applications Techno-Functional Consultant – Part Time (On Demand)
 Worked on Oracle e-Business Suite R12.1.3 upgrade implementation for Financials – Payables, Oracle Payments, ebTax and Cash Management – Bank reconciliation process.
 Created a Customized Check Format and Positive Pay file – R12.1.3 – using XML Publisher.
 Lead the implementation of Advance Pricing module configuration for Qualifiers and Modifiers rules.
 Outline the Oracle Payments: Profiles, Payment Methods, Payment Format, and Check Format.
 Collaborate with functional team and users in the configuration and setup for ebTax module: Set taxes for Suppliers and Sites.
 Extensive Production support for module AR clearing the Interface errors.
 Collaborate with functional team to setup Inventory revenue accounts for different organizations.
 Extensive custom solutions and integrations for Trade Management, Advance Pricing (Qualifiers-Modifiers) Modules for Oracle e-Business Suite R12.1.3.
 Post-Production support on modules GL, AP, AR, Oracle Payments, ebTax, Order Management, Advance Pricing on Oracle Applications R12.1.3. Worked extensively in fixing the Post Production issues raised by users, for which I used Oracle Meta link for SR logging.
 Extensive Development of web-applications using APEX and integration with Oracle e-Business R12.1.3.