Subject Matter Expert (sme Resume
Lake Zurich, IL
SUMMARY:
- Confidential is a highly seasoned and reliable Oracle professional with a superb customer satisfaction record. He is adept at interdepartmental coordination to maximize business functionality and efficiency. Committed to ongoing and research to ensure currency and innovation in management and problem - solving. He has implemented and maintained numerous sophisticated financial, manufacturing and custom applications in numerous industries. In addition to his business analytical skills, he is also quite verse technically and has a unique ability to develop strong client partnerships.
- Evaluated multiple e-Commerce providers (Sterling, GHX/Open Text, Inovis, TRU Commerce, SPS Commerce etc.) and selecting a business partner for implementation.
- Lead and supported ecommerce assessments at multiple client sites. This includes as is/to be design sessions and documentation to enable solution development.
- Extensive data mapping to and from external systems.
- Design business architecture associated with ecommerce strategy and solution.
- Collaborated with technical resources to define technical architecture that to support a growing ecommerce solution.
- Governed the integration of all solutions and their integration patterns.
- Provided expertise and consulting to all projects regarding integration, interfaces and data flows and technologies.
- Implemented numerous transactions to support electronic commerce (XML/e-Commerce Gateway) in multiple order to cash, procurement and warehousing implementations. (110, 210,180, 850,855,856, 860, 865, 870, 810, 820, 830, 832, 846,862, 867,888, 940, 943,944,945, 947)
- Extensive e-commerce experience with Purchasing and Payables, Oracle Receivables, and Order Management.
- Order Management configuration to support standard orders, drop shipments and inter company orders.
- Extensive order management knowledge.
- Developed custom transactions for the e-Commerce Gateway and the XML Gateway and all associated test plans.
- Implemented the Oracle B2B Gateway to support both EDI and XML documents.
- Developed custom transactions to support custom, EDIFACT, X12, RosettaNet and OAG standards.
- Worked with an Oracle implementation team upgrading Oracle Financials software from release 10.7 to release 12.2
- Provided support for the overall solution design and configuration of Oracle E-Business Suite, HCM Fusion, Hyperion, custom extensions and reports, integration components, OBIEE reports and dashboard components in the production environment as part of the support team.
- Key P2P contributor for an upgrade from version 11.5.8 to 12.1
- Designed developed and implemented solution to support Confidential / JMPC credit card integration with Oracle Payables.
- Conducted change impact analysis of identified changes by business and ensure optimal solution selection.
- Planned, documented and implemented regression testing of business and system changes.
- Developed coding standards to support Oracle Application R11 and R12 implementations.
- Responsible for the installation and configuration of Oracle Applications.
- Solicited, evaluated and implemented electronic commerce in a SaaS model.
- Oracle Procure-to-Pay Technical lead
- Oracle Procure-to-Pay Functional lead
- Key contributor for a global P2P implementation including multiple languages and currencies
- Participated as a key member of an Oracle advanced conversion team in converting data from a custom application to Oracle Financials. Conversions included, but were not limited suppliers, open purchase orders, open invoices and historical payables transactions.
- Created functional design (MD50) and Technical Design (MD70) documents to support numerous business requirements.
- Developed extensive customizations to support Oracle Purchasing and Accounts Payable.
- Completed Setup (BR100) documents for Purchasing, Accounts Payable, Cash Management, e-Commerce and XML Gateways.
- Technical and functional expertise on many Oracle modules specifically purchasing, accounts payable, cash management, e-Commerce Gateway and the XML Gateway
- Developed custom code and scripts to support the integration of financial data with Oracle Cash Management.
- Developed custom integration from regional and national banks to support integration with Oracle Cash Management.
- Engaged on various implementations of Oracle Manufacturing and Distribution modules.
- Developed strategies and solutions
- Functional and technical expertise on numerous modules.
- Converted open orders, inventory items, BOM, customer items, inventory balances, categories on numerous projects to support Oracle 10.7 through Oracle 11i.
- Developed conversion document for on-shore and offshore resources to support conversion and interfaces.
- Integrated Oracle Warehouse Management System and a third party application (Clear Orbit) for label generation.
- Worked with an Oracle implementation team in upgrading Oracle manufacturing software from release 10.7 to release 12.1
- Developed extensive integration between Oracle Applications and shop floor equipment.
- Vast experience in system integration in a manufacturing, distribution and financial environment.
- Extensive experience designing custom Accounts Payable applications
- Extensive experience designing and maintaining a custom Purchasing application
- Extensive application integration experience.
- Designed and developed barcode standards for the Agricultural Chemical Industry.
- Integrated radio frequency devices with a custom Oracle application to support the movement, picking, packing and shipping processes.
- Technical lead for the implementation of Oracle Human Resources (HR), Advanced Benefits and Self Service HR. Strong Oracle Advance Benefits Resource.
- Oracle HR and Advance Benefits conversion.
- ADP Connection and ADP Payroll Interfaces both inbound and outbound.
TECHNICAL SKILLS:
Software, Tools & Languages/Database: Clear Orbit, ERWin, Loftware, XML Publisher, COGNOS, COBOL, Oracle Discoverer, Oracle Forms 2.3, Oracle Forms 4.5, Oracle Reports 4.5, TOAD, Oracle SQL*Loader, SQL*Plus, PL/SQLOracle DBMS, Oracle Applications System Administration, MS Access
Hardware & Operating Systems /Other: HP-UNIX, MPE, MPE-IX, MPE-XL NT Server, VMS, MS Windows, MS Windows NT, UNIX Disaster Recovery, Performance Tuning, Benchmarking, Oracle Parallel Server
PROFESSIONAL EXPERIENCE:
Confidential, Lake Zurich, IL
Responsibilities:
- Subject Matter Expert (SME) Responsible for the design configuration and testing of all integrations including EDI. Extensive partner interaction. Developed implementation and testing plans to support an aggressive go-live date.
Confidential, Muscatine, IA
Responsibilities:
- Configuration and integration testing to support Oracle EBS 12.2 procure to pay and order to cash modules. This included, but was not limited to the standard EDI transactions, but also custom integration and custom EDI transactions. Coordination of all testing and onboarding.
Confidential, Weston FL
Responsibilities:
- Reviewed the system configuration and addressed area for possible improvements. Analyzed, documented and presented area for improvements. Facilitated JAD sessions to ensure requirements were been met and the impact on potential system changes.
Confidential, Rockville MD
Responsibilities:
- Configured Oracle Payables to support procurement cards with Confidential and Confidential with Oracle EBS 12.2. This included the development of custom programs to complete the validation and reporting of spending to the organization. Reviewed and modified the Purchasing setups to ensure that approved suppliers are used for each purchase. In addition, ensured that requisitions are evenly allocated to each approved supplier. Provided consistent quality support to both the Procurement and Finance Departments. Extensive supplier management and supplier cleanup. Developed custom reports to assist the Purchasing Department analyze their purchases and reporting.
Confidential, Valencia CA
Responsibilities:
- Developed custom to program to validate and load Order Management, Inventory and Advance pricing. Designed, developed and implemented multiple scripts to clean existing data.
- Evaluated, selected and implemented a managed service solution to electronically support the following EDI transactions 832, 850, 855, 856, 860, 810, 820,846, 940,945. This solution consisted of approximately 150 maps for multiple trading partners numerous standards and currencies. Additionally, duties included, but not limited to the gathering the business requirements, specification development, mapping and integration testing.
Confidential, Westfield IN
Responsibilities:
- Developed specifications and implemented transactions to support several procure to pay and order to cash transactions in a Release Management environment. Implemented standardized processes to facilitate the automatic creation of releases to the warehouse. Developed custom programs to support the printing of barcoded labels generated during the receiving and shipping process. Implemented the 830, 850, 856, 860, 862 and numerous warehousing EDI transactions to support the customer’s operation.
Confidential, Harrisburg PA
Responsibilities:
- EDI Technical lead for a large distribution implementation. Worked extensively with Order Manager/Shipping, Purchasing and Finance to develop functional and technical design documents to support a very customized implementation of Oracle Application. Worked at length with the functional team to ensure that business requirements were met. Developed custom transactions to support the customer Inventory and warehousing requirements. Developed mapping specifications to support the mapping of several standard and nonstandard inbound and outbound transactions. Assisted with the testing of several transaction with BOOMI and established trading partners.
Confidential, Indianapolis, IN
Responsibilities:
- Evaluated, selected and implemented a managed service solution to electronically support the following EDI transactions 850, 855, 856, 860, 810 and 820. This solution consisted of approximately 150 maps for multiple trading partners numbers standards and currencies. Additionally, duties included, but not limited to the gathering the business requirements, Oracle Order Management, e-Commerce Gateway and Receivables configuration, transactions testing implementation and support.
Confidential, Plainsboro NJ
Responsibilities:
- Assisted with the evaluation, selection and negotiation of multiple EDI partners. Implemented the e-Commerce Gateway along with GHX to support standard and custom EDI transactions (832, 850,855, 856, 888 and 846). This included, but not limited to all setups, mapping, testing and support. Project management, development and user support. Developed customer code to support the item master (888) and the Organizational Relationship (816) transactions.
Confidential, Collegedale TN
Responsibilities:
- Completed the mapping and implemented the 810 inbound invoice and the 820 outbound payment for most supplier payments and all employees expense reimbursement. Provided quality support for Oracle Purchasing in a very demanding manufacturing environment utilizing Min Max Planning and MRP to generate purchasing requisitions.
Confidential, New York, NY
Responsibilities:
- Assisted with the configuration of Oracle HRMS and Oracle Payroll to support a growing global shipping organization. Developed a series of interfaces from Oracle Payroll to support the integration with Fidelity, Vanguard and a series of external third party systems.
Confidential, New York, NY
Responsibilities:
- Technical lead on an Oracle Human Resources (HRMS) and Oracle Advance Benefits (OAB) implementation. Duties include but not limited to the conversion of employee data and employee benefits as well as the development of several custom Oracle Discover reports, Oracle Alerts, project management / administration.
Confidential, Paterson NJ
Responsibilities:
- Designed, developed and implemented an outbound interface for Oracle HRMS R11i to support ADP. In addition, designed and developed and inbound interface to support Oracle GL. Assisted with the functional setup requirements for a full implementation of Oracle HR & Payroll.
Confidential, Linden, NJ
Responsibilities:
- Technical Lead on a fast forward implementation. Developed the HR/ADP Interface for Release 11.5.9; assisted in the design and development of a Shop Floor Control System using barcodes. UNIX System Administration, Oracle System Administration and DBA responsibilities. Converted open AR invoices and open orders from the client’s legacy system to Oracle AR and Oracle OE. Developed numerous database trigger and procedures. Designed, developed and implemented a custom Promotional Money module as defined by the client.
Confidential, Washington DC
Responsibilities:
- Purchasing lead for the international multi-currency implementation of Oracle Government Purchasing. Interviewed employees to gain knowledge of the current system and gather requirements. Worked closely with the Accounts Payable team. Developed conversion programs to load Oracle Purchasing, Accounts Payable and Accounts Receivables from the legacy application.