DAVID C. DESENGANO

**** ********* **** ******

North Las Vegas, NV 89031

909-***-****

ac7zrg@r.postjobfree.com

EXECUTIVE PROFILE

SR. ISERIES PROGRAMMER / JDE PROGRAMMER - DEVELOPER / BUSINESS ANALYST

Results-oriented Programmer and Application Developer with extensive experience delivering business flexibility, cost reduction, productivity, speed and responsiveness to internal/external customers. Specialize in managing software projects and presenting solutions that provide a good return on investment and better utilization of human capital. Proven record of system strategy development, customer management, project management, solution delivery and budget compliance. Hands-on manager who leads by example, focuses on training and adeptly aligns IT with overall business strategies.

Selected Highlights

Provided accurate and successful data conversion using DB2 SQL scripts from AS400 legacy system to an ERP system implementing SAP or Oracle. [Blue Shield, Disney, HealthNet, Toshiba]

Researched and analyzed the company’s sales forecasting program which has been flawed for more than a decade due to programming and design complexity. Developed a much more robust, straight forward and easy to understand logic utilizing method 10 exponential smoothing with seasonality and sales trend. Provided technical documentation using Visio and PowerPoint of the company’s DRP, Cost Roll and Sales Forecasting applications. Consistently delivers 74% of completed IT staff programming projects[Master Halco]

Provided thorough analysis/documentation using Visio of complicated order-entry system, enabling Toshiba to understand the order-entry system with 100% accuracy and make educated business planning or system maintenance decisions. [Toshiba]

Developed innovative sales forecasting tool for 10 largest customers and most-ordered products, tracking current/future orders, work in progress, current inventory and dates/quantities of available product. [Dynasty Classics]

Eliminated a 1-year backlog of existing MIS projects within 5 months. Eliminated manual research and reduced customer response time from 2 weeks to less than 1 hour by developing ILE with embedded SQL programs for Retail Return Analysis and Serial Number Tracking Systems on the AS/400. [Clarion Corp.]

Created an invoice mail sorting system in the United Kingdom with a return of 90% generated from eliminating manual sorting, decreasing errors and ensuring correct/timely mail delivery. [Viking Office Products]

Built utility programs to improve programmer’s productivity 75%, including program skeleton code generation, database analysis, and program analysis and mass compilation/distribution using RPGIV. [Sunclipse Information Systems]

Headed project team at Master Halco to integrate a sales tax system into JD Edwards’ order entry, purchase-order entry and financial systems, completing the project in 6 months when other consultants estimated 2 years. Successfully developed and implemented automated month end process [Master Halco]

Reduced consulting expenses and solved application issues by creating a trigger program that automatically tracked/ recorded database changes, solving a long-standing problem sporadic, incorrect updates. [QuikSilver]

Successfully implemented/enhanced WMS projects at Phoenix Footware Group for multiple clients, consistently completing assignments under time/budget. . [Phoenix Footware]

Single handedly, developed and successfully implemented file conversion programs from MC/400 to Oracle database. [Blue Shield of California]

Provided database extracts of video sales to management at Disney Corporation. Responsible for trouble shooting and fixing SQL extract problems. Made modification to existing SQL extract programs as required by top management. [Disney Corporation]

Delivered largest number of completed conversion programs, consistently finishing months ahead of schedule. Developed 95% of a complicated Medical Professional Claims Package, completing project ahead of schedule when pieces of the project from other groups did not even meet deadline. [HealthNet]

Areas of Expertise

Project Management Project Lifecycle Custom ERP Applications

Business/Systems Analyst Parallel Systems Operations EDI Interface Development

Program/Application Development Database Management IT-Needs Assessment

System Documentation Using Visio/PowerPoint/Word/SharePoint

SAP Crystal Reports/Data Warehousing/SQL DB2/PL-SQL

Free Format RPG, ILE, JDEdwards with Embedded SQL

Stored Procedures, Interface Programs, FTP-DATABASE-SSH Servers using GoAnywhere Managed File Transfer.

PROFESSIONAL SUMMARY

Mission Produce

Multi-million-dollar producer/distributor of avocado worldwide

Free Format RPG/ILE/ Embedded SQL, FTP Sr. AS/400 Developer 2018 to Present

Dole Fresh Vegetables

Multi-million-dollar producer/distributor of fresh vegetables worldwide

Free Format RPG/ILE/ Embedded SQL Sr. Business Systems Analyst / JDEdwards Developer 2017 to 2018

IPS Corporation

Multi-million-dollar manufacturing company with locations worldwide

Free Format RPG/ILE/Embedded SQL JDEdwards Developer / Senior Programmer Analyst 2014 to 2017

Curves/Jenny Craig Carlsbad, California

Multi-million-dollar health and fitness company with locations worldwide

Free Format RPG/ILE/Embedded SQL JDEdwards Sr Programmer Analyst 2013 to 2014

Master Halco

Multi-million-dollar fencing company with more than 500 employees nationwide

Free Format RPG/ILE/Embedded SQL JDEdwards Sr Programmer Analyst 2008 to 2013

DaCaDe, LLC

Small technical Support/Software development and maintenance.

Free Format RPG/ILE/Embedded SQL Developer Consultant 1998 to 2008

Health Net

Billion-dollar medical/dental health insurance company with more than 1,000 employees nationwide

Free Format RPG/ILE/ Embedded SQL Senior Programmer Analyst 2002 to 2004

Clarion Corporation of America

Multi-million-dollar automotive parts and service company with more than 500 employees.

Free Format RPG/ILE/ Embedded SQL Senior Systems Analyst 1997 to 1998

Viking Office Products

Office products distribution company with branches worldwide. Now a subsidiary of Office Depot.

Free Format RPG/ILE/ Embedded SQL Project Leader 1994 to 1997

.

Sunclipse Information Systems

Provider of information services for AMCOR - Kent Landsberg company. Manufacturer and distributor of paper, packaging and corrugated cardboard products.

Free Format RPG/ILE/ Embedded SQL Project Leader 1993 to 1994

Dynasty Classics Corporation

Manufacturer/distributor of decorative lamps, lighting fixtures and seasonal decorative products. Employs more than 500 people.

Free Format RPG/ILE/ Embedded SQL Project Leader 1991 to 1993

Barksdale Controls

Manufacturer of valves and transducers for use in aircraft, shipping vessels and heavy equipments

Free Format RPG/ILE/ Embedded SQL Project Leader 1989 to 1991

PROFESSIONAL EXPERIENCE BY COMPANY

Mission Produce 03/2018 to Present Sr AS/400 Developer

Developed Free Format RPG/ILE with Embedded SQL programs on the AS400. Project lead on EDI implementations and other third party software such as SAP/Concur, GoAnywhere, Xmedia Fax System. Trouble shooting production problems and development of new programs as requested by various departments of the company. Designed and developed programs for business applications such as Sales Projection Daily Pricing, Exchange Rates, Field Rep Daily Comparison and Bin Count. FTP-DATABASE-SSH Servers.

Dole Fresh Vegetables 01/2017 to 03/2018 Sr Business Systems Analyst

Developed Free Format RPG/ILE with Embedded SQL interface programs on the AS400 for IBM/Mainframe to have access to JDEdwards tables based on filter specifications on the mainframe. Also developed SQL programs to monitor fax failures and potential faxing issues using fax log files and APIs (QSPROUTQ, QDCRCFGS). Developed ILE program interfaces between dotnet applications and AS400/JDE to process company credit card and employee expense transactions. Business requirements and Functional specifications for projects such as: user provisioning tool, bank reconciliation, and job scheduler. Support and analysis on issues in JDEdwards applications and 3rd party softwares such as InformDecisions Imail, Idocs and dotnet applications.

IPS Corporation 06/2014 to 01/2017 JDE Developer/Sr Programmer

Converted FTP sales file from a third party company to JDE creating sales history, Item Ledger, G/L, Item Location, Item Balance and as of records by item. Created the following programs: mass update program to change the base price of products needing price change, system to extend price deal to selected customers by customer number or sales region and buyer grouping, freight processing module to accurately report charges by G/L account, parsing program to convert a comma delimited file into a fixed format database file for sales processing in JDE, complicated file extracts for special corporate projects and inquiries using SQL, interface programs for third party softwares. Resolved on going issues in JDE such as: incorrect vendor names being sent to banks through positive pay, order backdating. Successfully uploaded user requested updates into JDE files with ease and accuracy. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Curves/Jenny Craig 11/2013 to 2014 Senior Programmer Analyst

Responsible for providing JDEdwards technical and programming support to US and Australia. Created automated sending of purchase orders to third party warehouses via FTP and email with recovery feature when FTP fails. Modified JDEdwards Positive Pay program to accommodate JPMorgan Chase file format requirement. Developed programs using free format RPG and embedded SQL to recover missing cardex records, inventory on hand report, complicated file extracts, data recovery and updates. Created technical and user documentation for all programs created. Led team installation and configuration of MessengerPlus 8.0 to monitor programming and system errors. Created complicated SQL extracts for audit reports. Successfully researched the company’s intercompany settlement and cost of sales related issues in JDE which has been unsolved for more than 4 years. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Master Halco 11/2008 to 11/2013 Senior Programmer Analyst

Responsible for automating emailed sales, inventory reports. Developed SQL scripts for extracting data from JDE system on the AS400 to feed Brio data warehouse. Revitalized and enhanced an inaccurate sales forecasting tool program. Developed and implemented the following: Automated 11-months rolling sales forecast upload program based on changes requested by branch managers and approved by regional managers. New item creation program which enabled users to create multiple items in minutes rather than weeks. Prior year to date and current year to date product grouping sales report by location and part number. Weeks of supply and demand inventory report. Last sales order and last purchase order reports by part number, unit cost and price. Monthly commission reports by product group based on percentage of month end total sales to last year’s month end total sales. Branch item master and global item master mass change upload programs. Vendor price mass change upload program. Gross profit margin report by invoice by branch. Prior to date and year to date Order statistics report by price level. Developed an auto emailed year to date and month to date product grouping report by sales region and item class. Created documentation on business processes such as Sales Forecasting, Distribution Resource Planning and Global Cost Roll using Visio, Word and PowerPoint. Imported Visio and Word documents from SharePoint. Developed a system to calculate monthly sales forecast based on actual sales from last 2 years by part number and branch location using method 10 exponential smoothing with seasonality and sales trend during the last 12 months. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Blue Shield of California 10/2008 to 11/2008 AS/400 Technical Consultant

Developed programs to extract and convert data from MC/400 database to Oracle Database. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Disney Corporation 05/2007 to 10/2008 AS/400 Database Consultant

Developed programs to extract and format video sales data and exported them to excel spread sheets for management. Provided technical database support to both SAP conversion and AS/400 teams. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Phoenix Footwear Group 08/2006 to 04/2007 AS/400 Technical Consultant

Developed financial, inventory and trigger application programs using RPG, ILE and SQL. Extracted and downloaded files from ABS application software into excel format for company executives. Provided technical and application support to top executives and staff. Evaluated user project requests for development approval, prepared statement of work, program specification and program testing and quality assurance to make sure project requirements are met. Performed code review to assure coding standards are followed. Researched application program errors and recommends and/or apply program fix on the Apparel Business Systems and WMS. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

QuikSilver 02/2006 to 06/2006 AS/400 Technical Consultant

Developed application programs using ILE and SQL. Maintained existing applications written in RPG, ILE and SQL. Projects includes maintenance of existing EDI interface programs for 810, 850 and other documents, Bill of Lading Interface program enhancement which includes: validation of data sent by third parties, validation error routines, data cleansing routines and pushing validated records for final processing. System documentation using visio flowcharts. Prepared statement of work, program specification and timeline schedules. Performed project requirements and application analysis and program testing and quality assurance. Performed code review to insure coding standards are followed. Prepared flowcharts and documentation for third party vendors on system workflow. Interact with third party vendors and users on program interface requirements. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Master Halco 12/2004 to 11/2005 AS/400 Technical Consultant

Designed and developed programs using RPG, ILE and SQL to extract sales and purchase order shipments into a file and send via ftp to an outside logistics company. Also designed and developed programs using ILE and SQL to receive bill of lading and payment request files from logistics company via ftp and update shipments and create payment vouchers in the Accounts Payable module on the AS/400. Also designed and developed programs using ILE and SQL to print shipment and payment reconciliation audit reports. Installation and implementation of the Vertex Sales Tax software on the AS/400, Set up procedures, constants and files to successfully implement the software. Analysis, design, development and modification of programs in the JD Edwards system to accommodate requirements of the Vertex Sales Tax system. Set up conference calls with third party vendors regarding requirements, government ruling and other issues that may affect the project. Preparation of project plan to show timelines and completion of tasks, Schedule bi-monthly meetings to update the team on issues and status of the project. Coordinate with team members in resolving project related issues. Performed code reviews to insure coding standards are followed. Created a recovery plan to facilitate business resumption with minimal interruption when installation fails. Creation of a production installation plan to facilitate accurate project implementation. Major projects include analysis, design and development of Freight System interface to JD Edwards Accounts Payable module, Implementation of Vertex Sales Tax System interface to JD Edwards Sales Order, Purchase Order modules. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Toshiba of America 02/2004 to 07/2004 AS/400 Technical Consultant

Developed RPG, ILE and SQL interface programs to feed WebMethod files for the Oracle conversion project. Prepared statement of work which details project requirements and timeline for deliverables. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Health Net 10/2002 to 11/2004 Sr. Programmer Analyst

Analysis, maintenance and development of membership related modules to divert direct access to membership files to a central database repository using RPG, ILE and SQL. Responsible for developing interface programs to feed Informatica files for conversion, analysis, maintenance and development of programs to convert institutional claims from the Arizona system to the MC400. Heavy involvement in test conversion runs for a period of 6 months before the actual conversion. Responsible for development of a system to identify obsolete programs on the MC400. Worked on the ABS system claims pricing conversion. Responsible for analysis, maintenance and development of conversion programs to convert institutional claims from the Arizona system to the MC400. Responsible for the major portion of program development, technical documentation in the form of flowcharts. Major projects include: Analysis, database design, program development and system implementation of the following: North East and California Membership Repository Consolidation, North East and Arizona Claims Consolidation, Health Net Initiatives on Arizona Claim Tracking, Health Net Initiative on North East Multiple Modifiers, Health Net Initiative on North East Cost of Benefit Tracking, North East, California, Oregon and Arizona Professional Claim Pricing Consolidation as part of the company’s major conversion project. Preparation of Business Requirements, Statement of Work and System Work Flow documents. Interface with business and IT staff responsible for making critical decisions. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Hyundai Motor America 08/2002 to 10/2002 AS/400 Technical Consultant

Analysis, maintenance and enhancement of parts system applications using RPG, ILE and Embedded SQL. Provided production support on parts system related issues. Created process flow and recovery documentation of the entire parts system.

Toshiba of America 08/1999 to 06/2002 AS/400 Technical Consultant

Development of business applications using Free Format RPG, ILE and Embedded SQL. Projects include: Analysis and maintenance of a multi-divisional Credit Card Charges and Credits, Order Warehouse Assignment, Public Sector Special Program, Special Order Processing Interface for Web Orders, Regular Order Processing and Distribution System, Processing of Orders from multi media sources such as EDI, WEB, FTP and direct entry, Order Performance Reporting, Special Order Priority Processing by Product Class, Special Back Order Priority Processing, Receiving/Shipping Warehouse Change Conversion, Expedite Exchange, Cross Ship, Warranty Transactions, Trouble Shooting of Production Problems, Automatic Billing by Product Class, Documentation of Order Entry System and Parts Substitution, Automatic Generation of Return Labels by Product Class, Receiving and Shipping Tracking, Transmission of EDI 856 outbound shipment notices, Maintenance and enhancement of ASP Referral System, Return Authorization, Demand Solution and Forecasting, Pricing System, Stock Code and Build Database enhancement, Parts Rapid Exchange System, Inventory Reserve Valuation System, Shipment Confirmation System, Back Order Release System, Siebel Interfaces Supporting Onsite ASP and Customer Replaceable Units. Provided ILE, ILE with embedded sql programming interface support to Public Sector projects such as Broad Vision Web Support and Siebel Sales and Marketing integration of customers, orders, & contract pricing. Prepared Statement of Work which details project requirements and project plan.

Paramount Pictures 02/1999 to 07/1999 AS/400 Technical Consultant

Responsible for the analysis and development of the Send Back Leased Credit and Debit Tracking System for Revenue Sharing using RPG, ILE, Embedded SQL. Documentation and unit testing, menu setup, database design and setup, processing options, dream writer setup and modification. Also responsible for modification, enhancement and system testing of affected programs. Validated procedure links and data flowing through the JDE, EDI and ACMR systems. Troubleshooting and verification of system exception errors.

Sony Pictures Entertainment 09/1998 to 02/1999 AS/400 Technical Consultant

Responsible for providing production support to all of Home Video Domestic users in Sales,

Accounting, Distribution and Financial departments. Also responsible for modifications and enhancements to existing applications such as EDI, Order Entry, A/R, General Ledger and other Financial systems using RPG, ILE and Embedded SQL. Provided user support on JDEdwards financial and interface applications.

Country Wide Home Loans 07/1998 to 09/1998 AS/400 Technical Consultant

Responsible for programs and database analysis on the Y2K project. Responsible for parallel testing of production and Y2K versions of programs. Troubleshooting and modification of program errors. Monitor, document and fix batch-processing errors. Data synchronization and file compare analysis.

Fox Sports Net 02/1998 to 07/1998 Senior Systems Analyst

Developed financial, insurance, banking and 401K applications using RPG, ILE and Embedded SQL on AS400. Responsible for providing programming and user support on JDEdwards Payroll, Human Resources, Accounts Receivable, Accounts Payable and General Ledger and Benefits Administration. Setup of new disbursement accounts, Automatic Accounting Instructions and Dream Writer versions, User Defined Codes, User Menus and Security. Also responsible for employee setup in the JD Edwards applications, AS400, Client Access and Rumba. Trouble shoots problems on AS400, SNA and Ethernet connections. Provides user support on Rumba and Client Access installation. Developed programs using JD Edwards database for tracking and maintaining Employee Deductions, Benefits and Accruals and transmission of 401K transactions to the Administrator. Responsible for coordinating AS400 and JD Edwards and other software installations and upgrades.

Clarion Corporation of America 02/1997 to 02/1998 Senior Systems Analyst

Responsible for overseeing theJDEdwards One World Development Project. Maintenance and enhancement of the current Service System. Coordinates hardware, software, installation, and upgrade requirements for One World Software. Analyze systems and programming requirements. Evaluates and assess programming projects. Responsible for timely completion of the current Service System help desk issues and improving communication between MIS department and customers. Responsible for the programming, design and implementation of Service System applications in RPG, SQL and ILE on the AS/400. Major accomplishments included completion of all outstanding MIS projects (1-year backlog) within 5 months. Developed ILE and ILE with embedded sql programs for Retail Return Analysis and Serial Number Tracking Systems on the AS/400. Currently involved in the New Service System Project. Developed Serial Tracking and miscellaneous applications using One World Case Tool. Supervised and coordinated the EDI processing, setup and programming. Provided user and programming support on JDEdwards General Accounting, AP, AR. Utilizes Free Format RPG/ILE/ Embedded SQL in all program developments.

Viking Office Products 07/1994 to 02/1997 Project Leader

Developed and maintained order entry customer development and financial applications using ILE RPG and SQL. Developed interface programs from AS/400 to RS6000 for data warehousing, data feed and parallel run system applications. Responsible for analysis, design, and development of Power Builder applications such as: Order Entry, Inventory Allocation, Invoice Inquiry, Customer Inquiry, and Order Shipment Inquiry. Designed and implemented database files stored procedures (functions), Power Builder EA/400 power script codes to access data from the AS/400 database. Developed a complete series of date validation and conversion programs. Also developed a source code analysis program on the AS/400. Analysis and design of program and database interfaces between Power Builder on PC, RS6000, and AS/400. This included establishing the communication devices and entries, interactive communication, physical and logical files, functions, and other objects such as data queues, data areas, and user profiles. Provided key support in interactive communication, programming and database related inquiries. Established programming and database standards for client server and AS/400 teams. Developed Advance Program to Program Communication applications for Order Entry, Catalog Request, Customer Survey, and Address Validation. Major accomplishments included new development, maintenance, and application program support for the Customer Development Department in the US, Europe and Australia using ILE, and ILE with embedded sql, RPGIV, and RPGIII on the AS/400. Designed, developed and implemented the Invoice Mail Sorting System in the United Kingdom using Royal Mail Database and ILE and ILE with embedded sql. Headed the team in programming and maintaining an accurate change of address system for US customer database utilizing tapes from the US Postal Service, NCOA, and ACS service bureaus using ILE and Embedded SQL.

Sunclipse Information Systems 03/1993 to 07/1994 Project Leader

Major accomplishments included analysis, design and development of the Resale Certificate System with interface to Vertex Sales Tax database, Roadshow Truck Routing System interfacing with Order Entry, Company Fiscal Calendar System, and the Date Validation and Conversion System using RPG IV. Developed and implemented programming standards for programming staff. Member of the team that developed strategic plans for the MIS department. Also responsible for development, modification and enhancement of Order Entry, Manufacturing, Financial, and Distribution applications on the AS400. Developed utility programs to improve programmers productivity such as program skeleton code generation, database analysis, and program analysis and mass compilation and distribution using RPGIV. Analysis and evaluation of case tools and other software.

Dynasty Classics Corporation 06/1991 to 03/1993 Project Leader

Responsibilities were focused on managing the development and maintenance of applications such as Retail, Sales Forecasting, Order Entry, Financial, Manufacturing, Import Tracking, and Inventory on the AS/400 using RPGIII and RPGIV. Responsible for setting up Electronic Data Interface to transmit and receive purchase orders and shipment notices to and from vendors through a consolidator. Managed the maintenance and enhancement of Import Tracking and Financial systems. Trained executives to accurately read and interpret a confidential sales forecast analysis data. Major accomplishments included development of an accurate sales forecasting tool for top executives.

Barksdale Controls 03/1989 to 06/1991 Project Leader

Responsible for the analysis, design and development of Product Delivery Check System (MRP System), Purchase Parts Variance System, Past Due Accounts Tracking and Automated Past Due Letter Printing System on the System 38 using rPGIV and RPGIII. Headed programming team on enhancements and user support for MAPICS and other system applications. Provided technical training to programming and computer operation staff. Major accomplishments included completion of all outstanding MIS projects (1-year backlog) within six months. Improved customer inquiry turnaround on product lead-time from 10 days to less than a minute. Increased collections 90% by replacing the existing form letter with a system that automatically selected from various templates based on degree of lateness, merged in customer information and used up-scale fonts/paper

National Medical Enterprises 03/1987 to 03/1989 Senior Programmer Analyst

Responsible for the analysis design, development and implementation of the Automated Medicare Log System that included Medicare patient maintenance, Patient Status analysis and Medicare Log file maintenance. Other responsibilities included maintenance of Hospital Patient Management System such as: Cash Receipts/Billing, and Admission/Discharge/Transfer using RPGIII on the System 38. Responsible for a major portion of Program Streamlining Project which involved analysis and replacement of inefficient codes and procedures.

Continental Foods Services 06/1983 to 03/1987 Senior Programmer Analyst

Major accomplishments included analysis, design, development and implementation of a real time Order Entry System utilizing Advance Program to Program Communication programming in RPGIII on the System 38. Other responsibilities included major enhancement and modification of the Order Routing System, Financial System, development of Truck Availability System, Warehouse Location System and Sales Promotion Analysis System using RPGIII. Redesigned and enhanced Receiving, Stock Adjustment, and Credit/Debit Memo Entry Systems. Provided technical support to Programming and Computer Operations staff in trouble shooting application and system problems on the System 38.

California Cartage Company 10/1980 to 06/1983 Senior Programmer Analyst

Responsibilities included analysis, design, development, and implementation of the Warehouse Inventory

Contact this candidate