SUMMARY

• Over 17 years’ hands on implementation and upgrade experience on the Oracle JD Edwards (JDE) EnterpriseOne (E1), One World and World enterprise resource planning (ERP) software systems with an overall 23 years’ experience in working with the JDE Finance, Manufacturing, Sales and Distribution Systems backed with a Bachelor’s of Science degree in Accounting.
• Accomplished strategist and JDE solutions architect with extensive experience in project scoping, system core and custom interface design, set up, configuration, validation, testing and execution.
• Excellent trainer, educator, presenter and visionary for the JDE financial systems including but not limited to; technical foundations, address book, A/P, A/R, G/L, fixed assets, job cost, contract and service billing, foreign exchange valuation, multicurrency and restatement processing, chart of accounts design and definition, financial reporting, real estate management, sales order management, advanced pricing set up and configuration, procurement set up including landed cost, real estate management and third party interface integrations into JDE.
• Supply chain and logistics expert for inventory management, procurement and the sales order management including item (SKU) set up, item branch and location master definition, DMAAI set up, advanced pricing set up with complex markups and rules.
• Extensive experience in the design of custom interfaces for integration in JDE E1 system.
• JDE Manufacturing accounting expertise with in - depth knowledge of the calculation for planned, yield and conversion variances resulting from standard cost methodology.
• Managed and led several successful E1 and world JDE implementations, upgrades, and data cleansings through migrations and conversions.
• Technical expertise in JDE systems administration functions, including menu redesign, JDE security profile, Object Management Workbench (OMW) interactive and batch version report modifications. SQL query select and update to tables.
• Solid understanding of system files and tables, field names, source system values and integrity checks as well as working with development and technical teams to troubleshoot issues and providing sound resolutions.
• Participated in several system clean up and integrity check in preparation for a smooth audit with the IRS and other external auditors for public companies.
• Effective communicator to all levels of management including C-level management, project sponsors, project stakeholders, IT directors and the user community.
• Address Book maintenance and compliance for 1099 reporting, as well as A/R Line of Business definition and processing
• Accounts Payable standard, and matching with Purchasing
• Accounts Receivable, including Credit and Collections Management
• General Accounting set up including new organization structure and COA implementation, allocation set up, budgeting, forecasting, multicurrency, monthly valuation, etc.
• Fixed Assets with complex tax computation rules and conventions set up
• Financial reporting development and maintenance through report design, other third party solutions such as ReportsNow, Hyperion, etc.
• Real estate and property management design and configuration
• Inventory management and set up of items, item branch and locations
• Purchase order management with received not vouchered accounting instructions
• Sales order management/advanced pricing
• Set up of user defined codes, automatic accounting instruction (AAI) definition, systems constants, versions set up with processing options and data selections
• Solid design and mock of JDE report development and templates
• Recommendations of data file purge and archive, as well as solutions for best practices, and third party solution integration with JDE
• JDE System Data clean up and reconciliation

PROFESSIONAL EXPERIENCE

Senior JDE Solutions Architect

Confidential, CA

Responsibilities:

• Hands on solution expert for the Oracle JDE Manufacturing, Distribution and General Accounting implementation using JDE standard processes and interfaces from external systems
• Provided project management as well as participated as the finance resource for the JDE 9.1 project
• Defined COA and the overall system framework for the project design to meet requirements
• Worked with CFO and controller to develop the manufacturing cost accounting per product line to show standard costs and variances calculated by the JDE system and explained to auditors for the 2014 audit
• Configured the AAIs for finance and distribution/manufacturing modules
• Reviewed the Work Order Inventory Issued and reconciled to the parts list and the production cost, as well as trace the WOs in the Item Ledger to the General Ledger.
• Provided support for the explanation of the financial presentation of actual amounts including manufacturing overhead allocations.
• Successful Oracle JDE 9.1 Rapid implementation for Inventory, Purchasing, Sales Order Management, Accounts Payable, Accounts Receivable and General Ledger
• Lead for the Finance and Distribution Modules - design, set up & configuration of the Legal Structures and Chart of Accounts as well as the automatic accounting instructions
• Designed and implemented a Sales Order Custom Interface to create complex accounting to record Revenue, COGS, Inventory and Accounts Receivable for Business to Customers online purchases.
• Recommended enhancements for tracking discounts, revenues on bundles to meet financial reporting
• Worked with business users to streamline processes and trained on the JDE 9.1 system
• Designed custom One View reports using BI publisher
• Performed multi-currency set up and consolidations of Financial reporting

Confidential, Denver CO

Responsibilities:

• Performed a 3rd party IT systems audit to provide the stakeholders with a risk assessment of their JDE 9.1 project in order to determine system readiness.
• Reviewed the JDE 9.1 implementation project plan and aligned it with the work that had been performed in the prototype and development environments. Determined requirement gaps and made recommendations for third party interfaces such as Concur, ADP, and Kyriba.
• Provided a work break down estimate and determine the effort that was needed to complete the remaining work for the JDE 9.1 project.
• Reviewed the security set up and made recommendations for ensuring SOX compliance.
• Finance consulting role on a system integration project for the Fox Home Entertainment
• Worked with the business on the design and requirements gathering
• Designed the A/R and G/L interface process documents and field mapping for three separate legacy systems for the conversions into the JDE
• Developed process flows for the project high level requirements
• Finance lead for the MediaMorph 3rd party contract system conversion of the contracts, A/R billed and unbilled amounts and the general ledger balances into the JDE World system
• Worked on the plan to convert the general ledger historical balances into the JDE World system for the conversion
• Reviewed and analyzed the use case documents to ensure that the mapping into the JDE system would capture the appropriate general ledger information necessary to report by revenue type, i.e., annual guarantee payments, minimum guarantees, and revenue share
• Participated in project meetings as the JDE IT liaison and provided the technical solutions for the systems conversions

Confidential

Responsibilities:

• Finance & Distribution lead role the 9.0 upgrade project
• Allocated resources to development efforts that was needed for retrofitting complex custom interactive and batch applications from XE into E1 9.0
• Developed testing scripts, prototype documents, and upgrade technical and functional documents, and worked with users to ensure a smooth transition from XE to 9.0
• Hands on testing of retrofitted objects, set up new functionality to support the upgrade
• Coordinated efforts for system stress testing, user training, and support
• Functional support role for the Customer Service, Purchasing, A/P, A/R, G/L & Distribution depts.
• Successfully prepared client for a major financial audit from parent company and the IRS
• Reviewed company structure in the JDE system and made recommendations to restructure the existing companies by legal entity as identified by management; Set up new centralized corporate shared services company; review business unit structure, chart of accounts roll up for financial reporting, and made recommendations for streamlining the general ledger accounts
• Worked with the Finance team to determine new allocation requirement for shared services; Set up, tested and implemented the allocation methodologies in the JDE system and trained users
• Developed technical specifications for rewriting new financial reports in JDE (source system) to align with the current Chart of Accounts. Worked with Finance Controllers to determine report roll up using category code mapping. Wrote new consolidated balance sheet and income statements as well as management reports.
• Worked on intercompany settlement reconciliation
• Made recommendations and performed GL summarization for Purge and Archive solutions
• Lead project liaison on the JDE migration/conversion for India localization in JDE
• Key project manager on FA implementation to load asset master and balances file; and successfully completed project on time
• Supported finance users on Contract Billing, Job Costs, Fixed Assets, Accounts Payable, Accounts Receivable, Sales Order Management, Purchasing, and General Accounting related issues for timely resolution
• Trained users on finance modules to minimize system errors and down time
• Lead resources for tax department’s data clean up effort to on integrity issues in preparation for 2008 audit
• Identified issues with Job Cost Profit Recognition Build (R51800) program affecting prior year calculations which led to the development of SAR for fix in later releases

Confidential

Responsibilities:

• Project lead for the JDE 8.11 implementation from legacy Solomon system for General Accounting, Job Costing, Contract Billing, Accounts Receivable, Accounts Payable, & Fixed Assets
• Worked closely with CFO and Controller to define and restructure the chart of accounts for multiple branch consolidation into one legal entity
• Set up and configured the development and prototype environments per business requirements: system constants, automatic accounting instruction, security role definition, interactive and batch versions, menu design, reports, etc
• Developed training materials and conducted training to multiple users/roles
• Wrote testing scripts and facilitated the conference room pilot for end users
• Responsible for the GL conversion & the reconciliation for balance/detail records into JDE
• Led the address book upload conversions to ensure customer and ship to records were properly defined to accommodate SOP and A/R requirements. Ensured the proper GL offset designation to allow branch reporting by subsidiary while designing the address book to accommodate year-end 1099 reporting.
• Project Manager for the upgrade project from Xe to 8.12 release on release tool 8.95
• Concurrently worked on restructuring the Chart of Accounts to streamline and correct account discrepancies and enhance flexible financial reporting.
• Provided end user system support to the finance, accounting, distribution & logistics departments
• Resolved and supported the business with ticket resolution through a help desk system
• Recommended improvement opportunities as well as trained the users on sound business processes
• Maintained and supported month end close activities:
• Reconciled an A/P to G/L out of balance of approximately $500K
• Set up the system integrity reports on the scheduler, review periodically, and notify Accounting manager of any discrepancies.
• Periodically review and follow up with users and clean up outstanding integrity issues
• Worked effectively with financial reporting user to modify reports for deployment
• Successfully implemented a commissions process for the accounting department based on new functional requirements:
• Reviewed and made modifications to the custom program to recalculate commissions
• Documented the new commissions’ process, reviewed the accounting entries for accrual processing, and tested the commissions’ calculation for accuracy and rolled out to users.
• Identified issue with the external A/P batch upload and corrected the mapping:
• Reviewed the “Z” tables, identified missing mappings, and tested the “Z” upload after correction
• Successfully resolved an advanced pricing project request to separate out the journal entries created during customer sales update for revenue and pricing promotions, while maintaining net billing for the customer: Tested the advance pricing functionality and set up rules to accommodate request Discussed the set up requirements with the users to ensure understanding of functionality
• Discussed the automatic accounting instructions effect on journal entry creation with the Controller
• Documented a net change and gap analysis for an upgrade from OneWorld Xe (EnterpriseOne) to 8.10 and presented the new functionality document to the Polk County, Iowa for General Accounting, Fixed Assets, Accounts Payable, Accounts Receivable, and Job Costing
• Assigned to the Jefferson County in Denver, CO, to test and document supplemental data process for reporting Draws to the Government. Developed process flows and trained the end users on the draw functionality. Also, reviewed financial integrity issues and resolved. Reviewed approach for upgrade from Xe to 8.10 with the IT team and made recommendations

Confidential

Responsibilities:

• Tier 1 production support for the IT department at Confidential Inc. for 3 years
• Managed, resolve and track logged NorthStar issue tickets for the application support operations in Denver. Support areas included: G/L, A/P, A/R, Fixed Assets, Contract Billing, SAR system, Job Cost, Real Estate (Property) Management, etc.
• Developed financial reports for the Accounting and Finance departments
• Run queries using SQL and perform updates to files to fix system integrity issues
• Provided after hours on call service for the EnterpriseOne/World™ production related issues
• Handled security related changes, including UDC requests, AAI setup, etc.
• Performed financial system testing after the production package build
• Developed financial modules testing scripts for testers
• Customized a multi-tier withholding and payment processing procedure for Japan localization
• Setup Brazil Boleto flat files for electronic payment processing
• Project manager for the successful JDE full cycle implementation of the PeopleSoft EnterpriseOne (ERP 5) financial modules from Business Works accounting software
• Developed the work breakdown structure and project plan for the implementation
• Designed the company’s chart of accounts and business unit structure
• Converted financial information from legacy system into PeopleSoft EnterpriseOne
• Designed custom report templates for batch versions
• Administered post-implementation support
• Processed 1099’s for year end, documented process and trained users
• Researched and resolve financial data integrity issues
• Reconciled the EnterpriseOne subsystems to the general ledger
• Reviewed and corrected system set up discrepancies
• Documented system procedures for the accounting and finance departments

Senior Consultant

Confidential

Responsibilities:

• Successfully restructured the client’s chart of accounts
• IT Business Analyst role for over 2 years for this client
• End user support/troubleshooting
• Proposed approach and performed a system implementation from Timberline accounting software into the JD Edwards World (A7.3) software
• Developed custom financial report templates for finance and accounting as well as through the showcase report writer tool.
• Developed an action plan and completed a successful upgrade of Genesis Software A6.2 to World Software A7.3
• Trained end users on the financial modules
• Performed reconciliations on integrity issues of the General Ledger
• Set up new dream writer versions due to base file changes from the Genesis Software to the World Software.
• Made changes in the UDC tables and Data Dictionary, as well as user profile set up based on requirements.
• Conducted issue analysis and made recommendations for resolution
• Designed and developed procedures for reconciliation
• Led the accounts payable and procurement implementation of an in-house accounting system to the JD Edwards World (A7.3) software
• Supervised 13 A/P clerks & Purchasing coordinators and performed annual reviews
• Developed and implemented A/P goals to meet upper management goals
• Successfully implemented A/P positive pay and P-card programs
• Audited, approved, and coded check requests and expense reports for payment
• Trained A/P and non-A/P staff on Accounts Payable standards
• Prepared federal, state and local payroll taxes for all of the divisions of Dole Food Company and its subsidiaries
• Worked with the taxing authorities to respond to inquiries, abatement of taxes, and all other tax related questions.
• Managed the monthly Fixed Assets depreciation and disposals and reconciled to the general ledger.
• Reconciled bank account statements to the General Ledger on a monthly basis
• Other project management and development.
• Prepared high volume payroll, handled tax deposits and filing requirements.
• Managed employee workers’ compensation claims, 401(K) reports, and garnishment deductions.
• Other general accounting functions, including A/P, A/R and Payroll.