Bruce Dow's Email Addresses & Phone Numbers

Sr. SyteLine Consultant & EDI Architect @ OnSyte Consulting Group, LLC OnSyte Consulting Group is an Infor Preferred Delivery Partner Peoria, IllinoisSr. SyteLine Consultant & EDI Architect @ JD Noles & Associates • Created and supported customized SyteLine EDI interfaces for multiple clients, integrating and mapping EDI using Gentran, Radley, Aurora Technologies, and TrueCommerce mapping.• Designed and...

Sr. SyteLine Consultant & EDI Architect @ OnSyte Consulting Group, LLC OnSyte Consulting Group is an Infor Preferred Delivery Partner Peoria, IllinoisSr. SyteLine Consultant & EDI Architect @ JD Noles & Associates • Created and supported customized SyteLine EDI interfaces for multiple clients, integrating and mapping EDI using Gentran, Radley, Aurora Technologies, and TrueCommerce mapping.• Designed and developed Multi-Site EDI for SyteLine, providing automatic creation of local and remote site addresses and trading partner information.• Handled daily EDI process for clients, troubleshooting and fixing any EDI problems.• Created shipping confirmation HTML-formatted emails, displaying order details and shipment tracking links.• Designed and developed robust Ledger Compression system, providing backup to remote database and verification of data before compressing.• Created and supported extensive SyteLine customizations for Daily Stats tracking and reporting, UPC number assignment and pre-assignment, PDF File renaming, and Finish BOM Utility.* JD Noles is an OnSyte Consulting Group Partner Knoxville, Tennessee AreaEDI/SyteLine/VB Consultant & Owner @ SGD Consulting • Continued supporting Trusted Link for Windows (TLW) EDI systems for former Cornerstone Data clients, adding new Trading Partners and customizing TLW transaction overlays (EDI mappings), maintaining and writing release integration, ASN, and invoice drivers for legacy MRP system (EOS).• Continued enhancing & supporting customized VB program for former Cornerstone Data client to translate TLW EDI text files of customer forecast, sales orders, and remittance advice for importing into M2M ERP system and for translating M2M text files of shipments and invoices for importing into Trusted Link for Windows to send EDI information back to customers.• Helped three clients migrate legacy MRP system (EOS) to modern ERP systems (SysPro, IQMS).• Provided troubleshooting and enhancements to client’s in-house EDI system that is tightly integrated with the company’s SyteLine ERP system, utilizing vb.net and SQL.• Provided troubleshooting and support for client’s IQMS ERP system. Peoria, Illinois AreaBoard Member, Secretary, Vice-Chairman of the Board @ Share International Inc. www.shareint.netShare International is a mission agency that ministers to the spiritual, physical, cognitive, and economic needs of the Turkana people of northwestern Kenya, sharing the Gospel and our very lives through training and sending indigenous missionaries to establish self-multiplying, holistic churches.• Pioneer Team, Vice-President (1990-1995) Established US & Kenya Board of Directors, wrote constitution• Vice-Chairman of the Board (1996-2017)• Secretary of the Board (2017-present) EDI Specialist / Sr. Systems Developer/Analyst @ Morton Industries LLC • Provided thorough testing and rollout of Shop Floor Labor Collection. Front-end user interface written in vb.net. SQL backend interface to SyteLine ERP system.• Part of two-man team that completely designed and developed our own in-house EDI system that is tightly integrated with the company’s SyteLine ERP system, utilizing vb.net and SQL.• Replaced 3rd party “bolt-on” EDI package, saving $15,000 annual maintenance fee and eliminating cumbersome, confusing user interface.• Designed and created complex SQL stored procedures for the EDI Integration system, updating multiple tables as a single transaction, utilizing commit and rollback.• Significant part of small IT team that selected and successfully installed ERP system, replacing legacy MRP system for two companies, providing thorough testing of EDI interface and highly customized shipping modification.• Developed automatic EDI Remittance Advice processing and posting to SyteLine accounting for Caterpillar and Deere checks, saving 8 hours per Cat check twice a month and 1 hour daily per Deere check, saving ¼ Accounting person per year.• Redesigned and created in-house Quality system, tightly integrated with SQL and SyteLine ERP system, replacing standard SyteLine Quality module.• Provided on-going support and significant expansion of VB program to read spreadsheets and text files of customer forecast and sales orders, importing results into SQL database and SyteLine ERP system.• Streamlined shipping process in areas of order entry, creating labels and shipping paperwork, processing shipping, and sending EDI order confirmation (ASNs) and billing invoices. Served as backup Shipping Data Entry clerk.• Greatly enhanced, simplified, and unified SyteLine HR and Payroll system.• Designed and developed process for exporting weekly payroll data for outsourcing payroll.• Very comfortable with manufacturing environment, gathering ideas and collaborating programs and solutions with shop floor operators. From November 2004 to May 2015 (10 years 7 months) Morton, IllinoisEDI Specialist / Sr. Systems Developer/Analyst/Consultant @ Cornerstone Data Systems • Installed and supported Trusted Link for Windows (TLW) EDI systems for seven clients, adding new Trading Partners and customizing TLW transaction overlays (EDI mappings), maintaining and writing release integration, ASN, and invoice drivers for legacy MRP system (EOS).• Created customized VB program to translate TLW EDI text files of customer forecast, sales orders, and remittance advice for importing into M2M ERP system and for translating M2M text files of shipments and invoices for importing into Trusted Link for Windows to send EDI information back to customers. From November 2000 to November 2004 (4 years 1 month) Morton, IllinoisChurch Founder and Sr. Pastor @ Great Oaks Community Church • Researched needs and selected target community; developed community and government contacts; developed and cast vision, mission, and core values for new church beginning Easter 1997, with average attendance of 220 in 3½ years.• Recruited, organized, and developed teams of volunteers from mother church and the community to serve as workers in worship, youth ministry, children’s ministry, Sunday School for all ages, small groups, and weekly setup in temporary facilities; prepared and delivered weekly presentations.• Helped develop and oversee budget of $217,000.• Helped build consensus and develop 100-acre master site plan and preliminary needs analysis for phase one of building project. From August 1996 to October 2000 (4 years 3 months) Germantown Hills, Illinois areaSr. Systems Developer/Analyst/Consultant @ Computer Task Group • Reduced the time to determine the scope of a critical engineering crisis from an estimated three weeks to two days for Navistar International Transportation Company, a major trucking manufacturer.• Enhanced the drive line system for Navistar, enabling them to implement engineering cost reductions of $1.1 million annually, and to increase revenues by $9.6 million annually.• Automated the daily production data merge for Navistar, saving 180 man-hours annually.• Re-engineered the 10,000-line report program for electrical harnesses for Navistar, improving data integrity, reducing errors, adding enhancements, and greatly improving maintainability.• Enhanced and maintained the Engineering Attribute Database for Navistar, adding major new components using Rdb, SmartStar, and SQL.• Ported numerous legacy systems from VAX VMS to Alpha VMS using Fortran, C, Ratfor, and SmartStar for Navistar. From October 1993 to July 1996 (2 years 10 months) Fort Wayne, Indiana AreaSystems Analyst/Programmer @ STS Consultants • Developed unique approach using SmartStar SmartGL and alternative indexed files to provide efficient searches and report generation for unsophisticated users who wanted to qualify many different fields for project information and history databases with 75,000 plus projects.• Optimized program for creating alternative indexed files, reducing run-time from 5½ hours to 17½ minutes.• From conception to finish, designed and implemented a nationwide, networked marketing database system for 40,000 plus names in 16 distributed databases for this consulting firm specializing in geotechnical and geoenvironmental engineering.• Optimized process for creating aggregate corporate marketing database, reducing run-time from 21 plus hours to 2 hours.• Maintained and enhanced a comprehensive set of database and reporting programs for processing concrete test results. Forty thousand concrete cylinders tested annually.• Saved 180 man-hours annually by reducing interactive report creation several times daily for concrete cylinders from 23 minutes to 45 seconds.• Conducted user training in seven regional offices plus corporate headquarters. From July 1984 to April 1993 (8 years 10 months) Northbrook, Illinois area