Accounting

  • As the IT manager I used my developing skills to help imporove many business processies
  • Automated upload from Excel programs and remove redudantant data entry
  • Integration between multiple systems to improve data flow
  • Data mining and exporting Excel

Bill of Lading Application

Win32 application written in C++ with ADO and Crystal reports 11.5 Users can create bill of ladding reports and print out for records and truckers Previously SEMCO had to purchase special template pre printed BOL paper and hand write or type using a typewriter. Cost 3000 per year in mate…

  • Win32 application written in C++ with ADO and Crystal reports 11.5
  • Users can create bill of ladding reports and print out for records and truckers
  • Previously SEMCO had to purchase special template pre printed BOL paper and hand write or type using a typewriter. Cost 3000 per year in material, plus labor costs

bol1 bol2 bol3

Automated LTL Reader

Automated LTL Reader Win32 application written in C++ Builder, XML, ADO, MS Access and LTL vendor APIs (SAS) This application will allow user to read all our Freight rate lookups from different vendors automatically. Previously user had to go into each individual Freig…

LTL Home Page LTL Home Page

  • Win32 application written in C++ Builder, XML, ADO, MS Access and LTL vendor APIs (SAS)
  • This application will allow user to read all our Freight rate lookups from different vendors automatically. Previously user had to go into each individual Freight company website and do a manual entry for each origin to destination zip codes and get a quote.
  • [151 destinations] x [3 plant origins] x [6 weight class] = 2718 entries. User had to submit data 2718 times for each freight carrier which would take at least 2 or 3 months of data entry and user error percentage would be higher. Cost savings at the time up to 3K+.

Datamine and Compare tools

Datamine Jobs/Projects created by SEMCO Microlink selection tool Ability run analysis and break down by labor, material, rep firm, discount and costs Allow team to validate price changes and imapact on sales ML Compare allows user to compare two jobs side by side and check pri…

  • Datamine Jobs/Projects created by SEMCO Microlink selection tool
  • Ability run analysis and break down by labor, material, rep firm, discount and costs
  • Allow team to validate price changes and imapact on sales
  • ML Compare allows user to compare two jobs side by side and check pricing differences.

datamine1 datamine2