SONY September 2005 to March 2024
Position: Senior JDE IT Manager/Finance Business Analyst
Experienced with new software implementations to EnterpriseOne 9.2 and 64-bit releases. Which includes, JDE application and E1 Tools upgrades to the latest software releases, JDE World to EnterpriseOne migrations and data conversions and company Finance restructuring.
Experienced with E1 and World module implementations. Which includes General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Purchasing, Sales Order, Expense Management, Budget, Inventory, EDI, internal and external integrations, data conversions, etc.
During my time at Sony, my job responsibilities included providing the Finance Steering Committee with time saving and cost reduction solutions, transaction automation and managing all Finance applications such as HFM, Managerial reporting tools, JDE EnterpriseOne solutions and support, EDI, external and internal integrations, Procurement, Inventory, Sales Order Management, Finance shared services, Expense Management applications, CNC activities, custom development, change management and upgrades.
- Customized E1 Expense Management for company’s T&E allowing for detailing meal attendees and hotel expense itemization. Developed a receipt images report, consolidated meal allowance audit report and a manager expense detail review report providing quick at a glance details for auditing purposes and approval.
- Customized E1 Expense Management for company's P-Card purchases, allowing for expensing purchased transactions to multiple departments or POs. Developed an internal department workflow, automating approvals for purchases made on behalf of other recipients outside of the cardholders department. Developed a receipt images report and a manager expense detail review report providing quick at a glance details for auditing purposes and approval.
- During the E1 software implementation rolled out Inventory Management, Manufacturing Cost, Allocations, Procurement, Sales and Finance modules including GL Accounting, Accounts Receivable, Credit & Collections, Accounts Payable, Fixed Assets, Budgets and Forecast.
- Manage teams, plus providing hands on development of JDE E1 applications. Development using E1 OMW tools and implementations that includes Training and Change Management.
- Analyzed the E1 application and developed a migration strategy.
- Heavily engaged in hands-on development using JDE E1 OMW and software configurations.
- Wrote core system integrations, UBE reports, interactive applications and custom software modifications.
- Developed a business case and presented findings to the Finance Steering Committee.
- Designed the E1 infrastructure plan, hardware requirements, OS and database.
- Engaged CNC, Sys Admins, DBA groups in order to build the environment.
- Developed an integration strategy and development plan.
Provided daily support to all application areas using EnterpriseOne
- Accounts Payable: Module Configurations, Batch Versions Support, Outbound EDI820, Checks, Wires, Positive Pay, EDI Procurement PO and PO Receipts, Custom Expense Item Logic via Procurement Module, EDI810 3-way match, AP-E1 APPL, UBE, TC customizations, Custom Aging, Vendor Spend, Vendor Master Change Audits, Receipt Not Vouchered Reporting/Reconciliation, ME and Top 10 Vendor Spend, AP Discount Redistribution, 1099, 1042, HST Taxes, Local Tax, PD-Debit Memos, PV-Vouchers, AP Voucher Integrations, Voucher Entry, Automated and Manual Payments, Advance Payment Terms, Work Day Calendar, AAI Offsets, YE & ME Activities, User Training and more.
- Accounts Receivable: Module Configuration, Batch Versions Support, Inbound EDI820, Auto Cash, RC-Cash Receipts Entry, RB-Customer Charge Backs, RU-Unapplied Cash, RS-Credit Memo Spreads, Cash in Advance, Deductions, Write-Offs and AAI Accounting, Customer GL Class Logic, Custom Revenue Item Logic via Sales, Flex Accounting, AAI Offsets, Customer Statements and Executive Aging Reporting, Customer Master Change Audits, Integrations with BI, Customer Credit and Collection Services, SOD Controls, AR-E1 APPL, UBE, TC customizations, YE & ME Activities, User Training and more.
- General Ledger: Module Configurations, Batch Versions Support, GL Integrations using Z-Batch processing, Integrated Reversing Accruals, Redesigned and Implemented Robust Cost Center and COA, Journal Entry Processing, Intercompany Settlements, AAI Offsets, Custom Mask Trial Balance, Account Reconciliations, Resolve Batch Issues, GL Control Reports Period Ending, YTD Summary, Standard and Variance, Inventory Flow, Period Close, Date Fiscal Calendar, YE & ME Activities, User Training and more.
- Expense Management: Customized Meal and Hotel Itemization, Detail Custom UBE Expense Report, Receipts Images Report, Travel and Expense processes for Amex integrated transactions, PCard Purchase processes for JPMC/Master Card integrated transactions, Workflow, Credit Card and Employee Reimbursement, YE & ME Activities, User Training and more.
- Fixed Assets: Module Configurations, Batch Versions Support, Master Data, Depreciation, Transfers, Splits and Disposals, YE & ME Activities, User Training and more.
- Sales: Module Configurations, Batch Versions Support, Integrations, Flex Accounting, Custom Revenue Item Logic, Customer GL Class and AAI Trade AR Offsets, Sales Update, RI-Invoice, RM-Credit Memos, YE & ME Activities, User Training and more.
- Procurement: Module Configurations, Batch Versions Support, Integrations, Custom Expense Item Logic, EDI-47 System Processing, OV-Receipts, RNV Account/Reconciliations, YE & ME Activities, User Training and more.
Manage JDE applications, development and upgrades
- Installed Shop Floor, Inventory Localizations, Sales and Procurement for small plant solution installation in Brazil.
- Sales, Credit Collections and customer statements in Mexico.
- Shared Services in the USA that include Inventory Management, Manufacturing Cost, Allocations, Procurement, Sales, Expense Management and Finance modules including GL Accounting, Credit & Collections, Account Payable, Fixed Assets, Budgets and Forecast.
Manage Oracle HFM Hyperion applications and provide global support.
- Global Consolidations, Corporate Tax Reporting,
Manage Infor BI 11 applications, OLAP integrations and provide global support.
- Customer profitability, Income Statements, Balance Sheet reporting.
- Global Budget and Forecast reporting.
Manage support in Brazil, Mexico and Canada Localizations.
- NFe Nota Fiscal and SPED Fiscal Reporting
Manage Magic XPI System Integrations.
- Designed integrations between Manufacturing, Sales, Procurement and Accounting systems with E1, Banks, EDI, Treasury, Company Consolidations, Sharepoint, etc.
JOB RESPONSIBILITIES
- Supervise contracted staff in general IT functions for Shared Services Finance.
- Involved with all stages of planning and deploying projects.
- Lead requirement definition efforts at the design, development, implementation and system levels. Document results of requirements definition process. Requirements gather for custom development or adaptation of third party or packaged application software.
- Ensure the quality of developed and delivered IT capabilities. Coordinate and execute systems testing. Ensure proper change control procedures are followed. Evaluate system integration impacts beyond the scope of specified change. Evaluate the work of junior team members for technical quality, adherence to standards and completeness.
- Ongoing user support for JDE Applications including Finance, Accounting, Receivables, Payables, Fixed Asset, T&E, Procurement, Sales, Manufacturing, Distribution, Inventory, requiring knowledge base of subject matter with each area’s function.
- Gather requirements for project initiatives directed by Shared Services Finance.
- Provided mentoring to technical staff. Maintain current technical skills and develop new skills through formal and informal skills development regimens.
- Provide support as necessary to existing suite of applications within a functional area. Solve software problems in a timely fashion. Provide support to user-customers on technical and process questions.
- Perform and provide feasibility analysis in response to various project request(s).
- Assign and delegate IT/JDE Projects to staff members and teams.
- Implement and execute full project life cycle development methodology.
- Institute department standards and repeatable development process.
- Nurture and grow department documentation and reference material.
- Oversee Segregation of Duties related to JDE duties and assignments.
- Perform Special Projects and other related duties as directed by management.
- Evaluate and recommend change in departmental processes and procedures where applicable, and when there is a recognizable benefit.
- Hands on in the development of software solutions.
- Able to read and write specs using OMW creating APPL, UBE, NER, E1-Tools.
IT WORK RELATED EXPERIENCE 1988 THROUGH 2024
EMPLOYED:
Sony Sep 2005 to Mar 2024 JDE IT Manager/Finance BA
Royal Caribbean International Jul 1990 to Dec 1995 JDE Sr. Program Analyst/Manager
OCWEN Financial Corporation Dec 1989 to Jul 1990 RPG Sr. Program Analyst
United Southern Assurance Sep 1988 to Dec 1989 SME Business Analyst
CONSULTING:
Merck Pharmaceuticals Jan 2004 to Sep 2005 JDE Consultant - Sales
Laird Plastics Apr 2003 to Dec 2003 JDE Consultant - Sales
GSI Commerce Nov 2002 to Apr 2003 JDA Consultant - Online Retail
Rohm and Haas Company Aug 2001 to Nov 2002 RPGLE Consultant - Mfg
The Sports Authority HQ Jan 2000 to Aug 2001 JDA Consultant - Retail
The Seagram Companies/UMG May 1998 to Jan 2000 JDE Consultant - Finance
Royal Caribbean/Celebrity Cruises Oct 1996 to May 1998 JDE Consultant - Finance
g.Neil Companies Apr 1996 to Oct 1996 AS400 Consultant - Sales
Office Depot HQ Dec 1995 to Mar 1996 DBA AS400 Consultant - Sales
Education:
Wayne State University