OVERVIEW

• Over 20 years of solid I.T. experience with 15 years of JDE experience: 10 years with Oracle EnterpriseOne JDE OneWorld , 5 years with JDE World software 10 years of experience in an AS/400 RPG environment as a Programmer/Analyst
• Functional experience with the following JDE modules: the Financial suite AP, AR, GL, FA , Distribution, Inventory, Sales Order, Procurement Purchasing , Property Management Real Estate , Job Cost, Advanced Pricing, Manufacturing, Transportation, HR and Payroll applications
• Extensive Report Writing using ERW, Application development using Form Design Tool, Names Event Rules NER using the Scripting Tool, data conversions, interfaces, and Master Business Function modifications using the OneWorld toolset
• Applied ESU, SAR, and Paper Fixes to the JDE software and performed basic CNC functionality like JDE package builds and Security setup
• Knowledgeable and skilled solving functional issues and in developing Interactive Batch applications, programming workflow, troubleshooting problems, debugging applications
• Strong knowledge of RPG II/ III/ IV, CL, PDM, SDA, SQL, RLU, and DFU
• Competent in all phases of functional analysis, technical design, coding, testing, implementation and documentation

SKILL SETS

• E1 Releases: B7.22 7.333 Xe 8.0 8.10 8.11 8.12 E9.00
• Tools: 8.98 Toolset, Object Management Workbench OMW
• Software: JD Edwards OneWorld/ World, Oracle EnterpriseOne, Enterprise Report Writer ERW , Form Design Tool, Powerhouse 4GL
• Operating System: Windows XP / NT / 2000, OS/400, VAX/VMS, Unix/Linux
• Languages: C , RPG II/ III/ IV, RPG/400, RPG/ILE

EXPERIENCE

Confidential

• Analysis of all custom and modified objects from EnterpriseOne 8.12 to determine what changes needed to be retrofitted into the EnterpriseOne 9.0 environment. Particular attention was given to remove custom code that was originally written to address issues that have been corrected the Oracle SAR process and/or redundant code.
• Performed all retrofitting and changes to the E1 9.0 environment and worked with the users to test and verify that the system applications were working as expected. I also created a document repository for all changes and retrofits performed to the EnterpriseOne 9.0 environment.
• Oracle EnterpriseOne 8.12 9.0 OMW, Financials, HR, Payroll, Expense Mgmt

Confidential

• Issue resolution prior to go-live for an upgrade of the software release from Oneworld Xe to EnterpriseOne 9.0. Debugged and trouble-shot retrofitted custom modifications from the prior Xe instance of the software for the new EnterpriseOne 9.0 instance.
• Resolved issues with setup for the Brazil Argentina localization.
• Ported custom business functions C from Xe to 9.0 modifying the code to account for moving to a double-byte environment.
• Extensive research to determine which SAR's had not yet been applied and which of those SAR's would be required to resolve issues within the system. Since the system was heavily modified and a lot of custom code had been added to the system, ESU's could not easily be applied. This facilitated some SAR's to be cherry picked and manually applied to the system as needed.
• Determined areas where custom modifications from Xe had been missed and merged those changes with the E1 9.0 code.
• Extensive cleanup of converted Media Objects which somehow inherited a lot of extra control characters during their conversion from Xe. This entailed performing a extensive amount of SQL to extract manipulate the contents of the Media Object Blob fields and then re-converting the modified text data back into the media object Blob fields.
• Provided additional support to the existing team members to resolve any last minutes issues.
• JDE OneWorld Xe, Oracle E1 9.0 OMW, Financials, Procurement, Manufacturing, Distribution, Pricing

Confidential

Senior Systems Analyst

• Implemented an interface to import Purchase Orders Receipts from an external system into the JDE E1 Procurement system using interoperability Z1 and EDI processes. Configured the setup for the Procurement system to insure it met corporate needs and acted as a liaison between the technical support team and the system users to ensure proper testing was completed.
• Project Lead to upgrade software release from Oneworld Xe to EnterpriseOne 8.12. Created and maintained all documentation for the project. Managed off-shore on-site consultant time, tasks, and budgets. Worked with business users to put together test scripts and ensure that new version was fully tested by the off-shore consultants. Conducted post implementation review.
• Provided support for the company's EnterpriseOne production systems. This involved analyzing problems as they arise, providing solutions or work arounds, and prioritizing immediate and future development efforts. I also performed JDE package builds and security setup.
• Created an interface from a new Point of Sale POS system to create Invoices and Receipts in JDE using the interoperability processes. Developed daily reconciliation reports for the new transactions so that record count and dollar values could be compared between JDE and the external POS system.
• JDE OneWorld Xe, Oracle E1 8.12 OMW, Financials, Procurement, Billing

Confidential

• Implemented the standard JDE Auto Cash functionality for the client. This allowed them to be able to match their Cash Receipts downloaded from their Banks to their Invoices and automatically apply the payments.
• Analyzed clients systems and identified required objects and tables that needed to be modified to properly implement Auto Cash functionality. This also involved reviewing their AAI's and having necessary updates made to the AAI's.
• Customized the standard application screen for Reviewing Electronic Receipts to provide better functionality to the User group.
• Designed a front-end process to load the inbound 'Z1' table that is used by the Auto Cash application. This involved creating a non-standard JDE technical solution to do the actual download from their banks to populated the JDE Z1 table.
• Oracle E1 8.11 OMW, Financials, Real Estate Management

Confidential

• Integrated a new business partnership into the parent corporate IT system structure. A new company had been formed and we needed to standardize them to the existing parent company's systems. This involved integrating all their Vendors, Tenants, and business entities into the corporate system and training them with in the use of JDE financial software. Additionally, we had to setup all their properties they owned and managed into the JDE Property Management system and integrate the software with JDE financials to track billings and payments. Job Cost was also setup to track expenses and billings relating to new developments that were being done.
• Created a custom application to import prior information on what had been paid for Job Cost and allow them a process to look up the history of any prior Invoices.
• Oracle E1 8.11 OMW, Financials, Real Estate Management, Job Cost

Confidential

• Automatated a manual process so that inbound Progress Payments Sub-Contract system could automatically be applied to existing Contracts or Work Orders.
• Developed a process to port Invoices from third party software into JDE using table conversion programs to read the inbound flat file and populate the Z1 tables used by the standard JDE Z1 pre-processor program. This process also entailed allowing the users to be identified by Business Unit and subsequently, process the transactions into separate databases. Error handling and data archiving was also built into this process.
• Created customized UBE reports as per the client requirements relating to the Property Management and Financial Reporting systems and also for FASB 13 reporting requirements.
• Oracle E1 8.11 OMW, Financials, Real Estate Management

Confidential

• Developed an inter-operability process between Domestic U.S. systems Xe and International 8.11 systems, to push changes made to 'Bill of Materials' and 'Supplemental Data' from one system to the next. This entailed developing business functions to process the changes and interface between systems via BizTalk. This also required making application changes to trigger the process as changes to the data were made.
• Ported Oracle E1 applications from version Xe to Oracle E1 8.11 for International operations.
• Modified interactive applications as per business requirements.
• Maintained detailed documentation of custom modifications and enhancements.
• Oracle E1 Xe 8.11 OMW, Distribution, Manufacturing, Supply Chain

Confidential

• Upgrade from WorldSoft 7.3 to Oracle E1 8.11
• Re-developed numerous custom financial reports in E1 that were previously developed in WorldSoft. This entailed reviewing the RPG code, extracting the logic, and streamlining processes for E1 Version 8.11 .
• Modified interactive applications to customize to customer requirements. Created processes to transfer journal entries between Customer Service Jobs.
• Documented custom modifications and enhancements.
• Oracle E1 8.11, WorldSoft 7.3 OMW, AR, AP, GL, Job Cost, Service Billing

Confidential

• Created a new process to convert and maintain data for all the Fabrics used in the manufacturing process.
• Working as a Business Analyst, developed processes and reports to aid in the planning and demand requirements for fabrics and materials used in the manufacturing of furniture.
• Upgrade from custom AS/400 RPG systems Mainframe systems to JDE OneWorld
• JDE OneWorld Xe OMW, AR, AP, GL, Job Costing, Manufacturing

Confidential

• Upgrade of legacy systems to meet Sarbanes-Oxley Security requirements.
• Led a team of seven developers who were based remotely across the United States to apply custom modifications to approximately 150 RPG programs.
• Managed the time and budget constraints of the project and reported statuses to the end-client.
• Successfully completed modifications on-time and on-budget.