·Responsible for full system lifecycle including analysis, coding, testing, and implementation of components for new and existing custom systems: Order Analysis, Sales, Commissions, Bonuses, Quote Entry for Lutron Electronics, Inc
·Participated in the development and implementation of series of applications to add new manufacturing facility to Lutron and incorporating it into JD Edwards.
·Designed and implemented Interbranch Orders analysis programs for assessment and G/L
·Developed Project Costing programs to integrate service expanses into G/L
·Coded, implemented and supported custom Credit Collection Management module to
streamlinebusiness-to-business and/or business-to-consumerCollections on past due
accounts. System improved cash flow and collection performance by 20%.
·Developed, implemented and supported applications to control Orders fulfillment, Open
orders, Open invoices, Discounts and Auto write-offs.
·Created Commissions Evaluation tool to track the commissions paid versus sales revenue.
Procedure drills down to the region, contract, product class and sales representative level.
·Developed and enhanced Sales Journals, Corporate sales, Commissions and Discount reports and G/L audits
·Architected, designed and implemented robust ETL system to integrate VB based Quoting Tool data into JDE. System extracts, converts transfers and loads Quota data into JDE format order. FTP script and AS400 job is initiated from Quoting software
Over 75K quotas successfully processed since deployment..
·Developed and Implemented interfaces between 3rd party software and JDE.
·Developed numerous custom applications to pull data from JDE to help streamline the month/year-end closing process.
·Created and supported programs to monitor and track daily Sales Journals., Invoice printing and Quote data transfer executions.
·Applied CUM13 local enhancements for existing JD Edwards A 7.3
·Programmed additions to JDE A 7.3 base package functionality. Modules include Invoice Reprint, Transfer order entry for configured items, Custom systems data load.
·Coded and implemented upload and local exit validation programs for JDE Item configurator
·Designed, developed and delivered custom utilities for in-depth analysis and evaluation of
source code, libraries and files to field level, IQ, DREAM Writer and World Writer
·Extensive use of RPG, RPG ILE, CL, SQL, FTP