Howard Mendelsohn Email & Phone Number

Oxford, Ct

Reported directly to the Director of Information Services with responsibility for converting the corporate database to an AS400 and MACPAC software. Maintained and upgraded MACPAC after conversion; developed and managed the firm's EDI program. Played major role in company's successful ERP conversion, writing software applications to meet the needs of business users in the Purchasing, Accounting, and Distribution departments. Saved a key customer (Estee Lauder) relationship by rapidly implementing a third-party EDI system to meet the Lauder deadline for electronic data transfer. Within one year, the program expanded to accommodate four other corporate clients. Improved customer satisfaction as well as shipping, tracking, and inventory accuracy by writing programs and integrating/enhancing third-party software to implement bar coding, simultaneous label/packing slip printing, and automatic labeling of incoming shipments.

Reported directly to Manager of Business Application Development with responsibility for developing specifications, writing and testing code, supervising user testing, and overseeing implementation and training. Partnered with vendors and customers to resolve tax discrepancies and with Channel Sales Department to design automated pricing and reporting systems. Maintained successful operation of the AVP Sales and Use Tax system used data to create custom financial reports. Improved customer service and marketing productivity by creating an automated price book system and discount tables that:Generated customized product catalogs.Enabled pricing by customer number rather than by line item.Increased productivity and reduced paper expense by developing an automated e-mail report distribution program that leveraged third-party software to convert DB2 databases to Excel spreadsheets and AS400 spooled files into PDF documents. Automated the EDI discrepancy report reporting process by designing a system that gathered data from multiple EDI acknowledgments and transmission reports. The system:Saved approximately 20 employee hours per week by eliminating manual compilation.Automatically e-mailed reports appropriate recipients.Reduced report size from 20-50 pages to no more than one page. Increased the accuracy of the medical film sales rebate program by developing an automated system that produced reports in EDI 867 format and eliminated:Payment for items that were not part of the rebate program. Double rebates for customers who left one buying group and joined another (prior payments had exceeded $500,000 annually).Created a custom system that enabled automated sales reporting to Premier and Novation, two of the nation's largest healthcare group purchasing organizations.; Producer of industrial pigments, vitamins, and chemicals for the automobile, medical, and cosmetic industries, with approximately 200 employees and annual revenue of $5 billion

Of Completion, Data Processing

Coursework, Data Processing