by Derek Souers
on
Highlights:
- Project Dashboard - WPF On Demand Data Real-time data from SAP
- Sap-Enabled Excel Reports - On Demand Data from SAP reports
- Part Tracking MVC WebApp - Tracks part through the ToolRoom with access to Drawing Documents
- Part Demand Forecasting WebApp - Optimized a cutting edge web application for a Future 500, awarded multiple times in InformationWeeks Top 20 Most Innovative Programs, decreasing page response time by 30%
- Real-time E-commerce System - Optimized eCommerce code reducing transaction completion time thus increasing throughput for a $30k per hour system
Work Projects:
| Name: | Software description and Technologies: |
|---|---|
| Project Status, Planned Order to Activity Confirmation Execution Dashboard |
Created C# WPF extensive Project Status, Planned Order to Activity Confirmation Execution Dashboard utiliz-ing data from SAP. This dashboard has custom views for upper management, department leads, project man-agement, planners, and to the team lead. Data that is normally separated into silos is consolidated into an easy to read view.
C#, .NET, WPF, SAP, Excel and SQL |
| Tooling Machining Workflow Assistant and Start App |
Created Tooling Machining Workflow Assistant and Start App. This C# WPF app provides interactivity and in-tegration between applications using contextual actions based on the data. It also supports job time bookings through worklists and barcode scanning ability.
C#, .NET, WPF, SAP, Excel and SQL |
| Digital Communications Board |
Created Digital Communications Board. This C# MVC WebApp provides a slideshow of current events, KPI’s, and other useful information displayed in the plant. There is also a kiosk mode.
C#, .NET, MVC 5, .NET 8, Jquery and Telerik |
| Digital Shop Floor Management |
Created Digital Shop Floor Management system, that reads in and summarizes data from various sources, providing a at a glance high level view displaying KPI’s that provided an informative yet comprehensive quick daily status meeting.
Excel and VBA |
| Trucking Shipment Delivery Appointment system. |
This public facing C# MVC WebApp allows vendors and carriers to schedule appointments for the shipping bay.
C#, .NET, MVC 5, .NET 8, Telerik, and Excel |
| Tooling Magazine Item Optimizer |
This C# WinForm app reads in CAM programs available in the ToolRoom and Sorts and Groups them intelligently to minimize magazine item changes.
C#, .NET, WinForm, Telerik, and Excel |
| Consumable Item Forecaster |
This C# console app reads in CAM programs and forecasts out how many tools are consumed by the pro-grams by Calendar Week.
C#, .NET, Console, Telerik, and Excel |
| Line Length Calculator app |
This C# WPF program reads in and displays drawing files, extracting part geometries. The user then selects the line length and the program calculates the line length and thus the machine run-time providing better estimates for hours-based time planning.
C#, .NET, WinForm, and Telerik |
| Testing Layout Measurement Report |
This report is used to determine where the purchase order lines were where, which vendor was filling them and additional details.
SAP, Excel |
| SAP Generic Project Overview Report |
Created SAP Generic Project Overview Report that shows the entire Project Structure, Networks, Production Orders, Network Activities, Production Order Components, Purchase Requisitions, Purchase Orders, and Suppliers. This is used by the Project Management and Upper Management to gauge a projects progression.
Excel, VBA, SAP, and OCX |
| SAP Vending Machine Synchronization app |
Created C# WinForm utility to pull inventory usage information from the Tooling Inventory vending machine system so it easily allows the user to generate Purchase Requisitions in SAP.
WinForm, TSQL, SAP, and Excel |
| Goods Receiving app |
This C# WPF app reads in a Packing Slip using OCR and then matches up PR, PO Lines, Material numbers and Descriptions. This reduces time spent comparing physical documents by highlighting errors and reduces the chance of errors.
C#, .NET, WPF, .NET, SAP, SQL and Telerik |
| Migrated SAP enabled Excel VBA reports to SAP GUI 7.50 |
Migrated reports troubleshooting and correcting issues found.
SAP, Excel, VBA and OCX |
| ToolRoom Capacity Sheet Improvements |
Extended greatly the ToolRoom capacity sheets, so that planning can be visible by calendar week with drill-downs to see which orders were processed by each machine WorkCenter.
Excel, SAP, OCX and VBA |
| Variety of VBA Reports Optimizations |
Optimized several SAP enabled Excel VBA reports. One report now runs in less than 1 and a half minutes compared to its original 8 plus minute runtime.
Excel, SAP, OCX and VBA |
| Job Activity Confirmations Improvements |
Optimized the user input and performance of the Job Activity Confirmation app, so less keystrokes are required from the user and optimizing usage.
Excel, SAP, OCX and VBA |
| SAP Functions Library |
- Created SAP Functions library to streamline development to the tables of the SAP back-end systems, optimizing data performance calls and building SAP objects to minimize redundant C# to SAP code. Was able to minimize call times from 8 seconds to sub second.
C#, .NET, SAP, and NCO |
| Extensive VBA Functions library |
Created library to improve VBA code quality, error handling, speed up development and improve usability. It contains functions for object type conversions, formatting, sheet and ranges related functions, array functions, and VBA code updater.
Excel and VBA |
| Department Wide PR and PO Status Tracking Report |
This report is used to determine where the purchase order lines were where, which vendor was filling them and additional details
SAP, Excel, and OCX |
| ToolRoom Tracking System |
Created system that the ToolRoom uses to track part details of an assembly as the flow thru the ToolRoom. This C# MVC web-site with AJAX calls receives data from SAP to provide critical project information and planned vs actual hour confirmations to the team leads. It also reads complete Build Of Materials from SAP and imports them into the system. In addition, it has multilingual support.
C#, .NET, MVC 4, .NET, SQL, JQuery, and Telerik |
| Knowledge Based Engineering System |
Extended functionality on Knowledge
Based Engineering System to support 3rd party function calls and file
transfers streams in a secure environment thru WCF WebServices. Minimized manual transfers via USB key and minimized possible data exposure of sensitive munitions data. VB.NET, WCF, SQL |
| Part Demand Forecasting WebApp |
Optimized a cutting edge web
application, awarded multiple times in InformationWeeks Top 20 Most
Innovative Programs, decreasing page response time by 30%. Upgraded the
charts and maps to the latest technologies of Telerik Controls to Ajax
to WebAPI 2.0 further optimizing page size and responsiveness.
Implemented multilingual support and an inventory update allowing
customers to import sales data and ranks recommendations on what to
stock and which parts to return. This helps both the Bearing Manufacturing Company and the customers sell more parts, avoid ordering non-selling parts, and to minimize returns in the supply chain. VB.NET, ASP.NET, JQuery, AJAX, Web API 2, Telerik ASP.NET UI, Dundas Charts, SQL |
| Windows Server 2003 Sunset Migration |
Migrated 12 servers and their business
applications from Windows Server 2003 to virtual machines of Windows
Server 2008 R2 and 2012. Coordinated and tracked tasks between server
and business owners. Lead upgrade development efforts on non-compatible
apps from .Net 1.1 to Net 4.0. Moved critical applications off non-replaceable archaic hardware and operating systems, preventing costly down-times. Windows Server 2012, Windows Server 2008 |
| Part BOM Lookup |
Developed MVC application to WCF
WebService to return Build of Materials information using a recursive
approach, displaying on a public facing website. Migrated application from Classic ASP to MVC using a costly DB2 license with static data to an WCF Service receiving continually updated from SAP guarantying up to data part information. C#, MVC, WCF WebService |
| Sandcastle Integration |
Created coding templates, custom
installer, and best practices documents on how to implement Sandcastle
with the lowest amount of developer effort so that new developers could
quickly get started with existing projects. Significantly reduced new developer learning time and time spent documenting libraries and code bases. InnoSetup, Sandcastle |
| Automotive Internet Part Order System |
Provided technical development guidance
on Automotive Internet Part Order System, maintained system, and wrote
supporting client integration guide. Reduced calls on placing orders and order statuses to customer services freeing them to be more proactive on other tasks. VB.NET, WCF WebServices, XML, SQL |
| E-commerce System |
Optimized eCommerce code reducing
transaction completion time thus increasing throughput. Extended error
handling and logging code to include additional diagnostic information,
to reduce time spent debugging. Upgraded code base to newer technologies
reducing down-times. Identified bottlenecks and helped correct root
cause issues whether they were in my department or not, helping to
mitigate risk. Coded VB.Net Web Application that displays dashboard and
tools to be utilized by international locations to provide timely
self-support and diagnostic information. Added in a mass import utility,
that reduces keying errors and provides warning messages for bad data.
Developed tools to automate deployments and code refreshes to the
eCommerce environment. Setup Alert Systems for eCommerce transactions to
notify appropriate personnel and provides up-dates to business owners
on outages and performance slowdowns. Worked with offshore developers to
build a SAP PI WebServices correcting long
outstanding issues that were using the
SAP RFC functions. Reduced downtime, created self support tools for international locations, optimized error handling so errors related to missing customer information would be forwarded to the appropriate users, optimized system throughput. Worked with cross functional teams implementing a shipping solution that improved sales by $20,000 in the first month. VB.NET, threading, SAP RFC, SAP PI WebServices, SQL |
| Mobility Compliant Upgrades |
Participated in upgrading existing .Net
1.1 and classic ASP enterprise applications to be Cross Browser
Compatible and Mobile Compliant. Allowed important decision making data available to be quickly and easy to use consumer mobile devices. HTML, ASP.NET, VB.NET, Safari, Firefox |
| CommandLine SharePoint File Transfer Utility |
Developed Command Line SharePoint File
Upload/Download Utility utilizing WebDav and SharePoint WSE WebServices
to assist in uploading/download SAP scheduled data jobs to SharePoint
2013. Reduced the need for users to manually export data from SAP then manually upload it to SharePoint so they could work on more important business tasks. VB.NET, SharePoint WSE WebServices, WebDav |
| Body Sculpting System E-commerce |
Coded C# web application for As Seen On TV website C#, ASP.NET, GoogleMaps, Web Application, MainStreet Commerce's Lead development of high traffic As Seen on TV website. BusinessFlow SDK, IIS7 |
| As Seen On TV like E-commerce |
Developed C# website adding in
multi-theme, printer friendly pages, order status/tracking and multi
component color/size variations selector. Lead development of high traffic As Seen on TV website. C#, ASP.NET, RSS, SEO, Website, MainStreet Commerce's BusinessFlow SDK |
| Mailed In Order Entry |
Coded C# windows application allowing
catalog orders to be quickly entered from online sales and phone sales
representative with minimal key-strokes allowing custom coupon codes,
free shipping, volume discounts, packaging sheets, shipping labels and
sales documents. Also developed reports detailing
Total Items, Total Orders, Total Dollars
in both Cash, Check, Credits, Rejected Orders, Recovered Orders, and
Sales Rep Totals for Commissions. Minimized entry errors and speed up order processing on the phone and thru the mail. C#, WinForm, MainStreet Commerce's BusinessFlow SDK, SQL |
| Deal of the Day Luxury Products E-commerce |
Created C# website coding in extensive
SEO techniques that assisted with the deal of the day product being
presented within the top 20 of a Google search
and also has a friend referral system. This website helps to sell out idle inventory items within 24 hours like www.woot.com and also helps drive traffic to their main website. C#, ASP.NET, RSS, SEO, Website, MainStreet Commerce's BusinessFlow SDK |
| Safety Products E-commerce |
Ported and upgraded the existing website
to use the new E-commerce base functionality found in the
SeifertSuperSample web application. This helped reduce TCO and costs for future upgrades. C#, VB.NET, ASP.NET, Website, MainStreet Commerce's BusinessFlow SDK |
| SeifertSuperSample E-commerce |
Extended and enhanced C#/VB.NET
E-commerce web application based on the MainStreet Commerce's
BusinessFlow SDK. This site was redesigned to be highly reusable so that existing client's motifs and business processes can be easily integrated. Software upgrades can also be applied quickly to the site lowering a client's total cost of ownership. C#, VB.NET, ASP.NET, Web Application, MainStreet Commerce's BusinessFlow SDK |
| Performance Supplements E-commerce |
Extended and enhanced C#/VB.NET
E-commerce web application based on the MainStreet Commerce's
BusinessFlow SDK. Added in an admin interface so that new files and
content can be easily managed via the web. Also added in support for an
article engine, testimonials and FAQ's. C#, VB.NET, ASP.NET, Website, MainStreet Commerce's BusinessFlow SDK |
| Boutique Gifts E-commerce |
Extended VB.NET business to business web
application based on the MainStreet Commerce's BusinessFlow SDK to
include in a dealer store locator via a zip code radius search and
custom product attribute setup to streamline adding products to
inventory. VB.NET, ASP.NET, Website, MainStreet Commerce's BusinessFlow SDK |
| Business To Business E-commerce |
Extended existing VB.NET Extended
existing VB.NET E-commerce for business to business commerce. Added in
custom corporate security structures, reporting, point system, payment
method integration to the PeachTree System via a 3rd party COM component
PawCom for returning up-to-date inventory and adding in new purchase
orders. This site allows for promotional materials to be bought for local stores with high sales and managed by the corporate offices. VB, ASP.NET, Web Application, AbleCommerce, COM, PawCom, PeachTree |
| Document Control |
Created an windows utilitCreated a
windows utility that searches network drives and shares for a specified
file criteria through the windows file properties. C#, .NET, WinForm, Win32 |
| HMI Interface |
Extended VB.NET windows application,
utilizing the InGear ActiveX COM component that provides communication
between the PLC and the host computer, to include recipe support,
enhanced data logging and new graphing functionality so experimentation
results could be seen easier. VB, .NET, WinForm, InGear ActiveX Allen Bradley control |
| Echo Accreditation Tracking and Reporting |
Created an C# web application that
allows a nurse to enter patient test data and diagnosis and creates
required reports for the Echo Accreditation program. This app allowed accreditation reports to be generated allowing funding from the government health organizations. C#, .NET, Web Application, SQL |
| SQL Enterprise Log Manager |
Created C# windows application that
searches Active Directory for all computer names to see if a SQL server
is located. If it is, it then checks the transaction log sizes and disk
space and repairs it if necessary. Reduces time spent of the SQL server admin logging into each instance in an enterprise and manually reviewing sizes. C#, .NET, WinForm, ActiveDirectory, SQL |
| Productivity Report |
Created C# web application that compares
the build of materials for similar products then provides comparisons
between manpower and materials used for the purpose of increasing
productivity. Additionally teams can be compared and given incentives
for their increasing productivity. This report allowed the controller to gauge teams performance, optimize use of components and time then make further adjustments. C#, ASP.NET, Web Application, SQL, E2 ShopTech |
| Build of Material Report |
Ported existing classic ASP builds of
materials report and corrected it to use a recursive approach so that
sub-levels would always be included in the totals. Additionally added in
the ability to store pricing so that historic lookups could be done for
the use of the new productivity reports on material and time usage. This report allowed the controller to see how much a product costed and their sub component costs. C#, ASP.NET,VB, ASP, Web Application, SQL, ShopTech |
| PC Based Industrial Machine Control |
Debugged and extended Borland C program,
adjusted program run processes to encompass the new conveyor section
and additional proxy sensors. Added in additional diagnostic outputs to
assist in optimizing machine timings. Troubleshooted and corrected a
crash in the program that caused the machine state to become invalid
after an Estop had occurred and could no longer continue. Borland C, DOS, Serial, Parallel |
| HelpDesk |
Created C# web application that provides
a project-centric interface. Allows managers to track progress on
multi-user projects and provides billing details for the clients. It
also includes a customer portal for customers to type in questions,
report issues, and suggest enhancements. This reduced time spent on the phones with technicians giving project status updates to clients and bosses. C#, ASP.NET, Web Application, SQL |
| Enterprise Messaging and Employee Locator |
Created C# windows application that
utilizes web services to provide messaging and a virtual sign in/out
status to be used when an employee is visiting a client site. Provided low cost company controlled Instant Messenger services. C#, ASP.NET, ASMX WebService, WinForm, SQL |
| Purchase Order System |
Created C# windows application to
create/manage purchase orders/vendors and to receive items. It also
print outs related documents. C#, WinForm, SQL |
|
Enterprise Time Tracking and Reporting |
Created C# enterprise web application
that allows employees to enter weekly time billing data from the web via
an SSL connection. It allows managers to gauge their projects via
extensive real-time reporting. It also provides employee information for
the human resource department. In addition, time-tracking and payroll
is automatically imported into the Traverse accounting system removing
keying errors and thus speeding up the monthly billing and payroll
processes. C#, ASP.NET, IIS6, Web Application, SQL, Traverse, MAS90 |
| Functions Library |
Created C# library to streamline and
standardize of rapid development of both Windows and Web Applications.
It includes email services, control validation, error reporting and an
auto-updater module. This severely streamlines and standardizes rapid development. C#, .NET, Web Application, WinForm, SQL, Access, ODBC, OLEDB |
| Custom WebControls |
Created C# library that enhances and
adds to the existing control set in .NET. These provide further
control validation, data sanitation, and an enhanced user experience. This allows for controls to simply be dropped to a page, without extensive coding for each new element. C#, .NET, Web Application |
| Seifert.com |
Added in a dynamic news engine,
available jobs posting listing, IT promotions page, and event
registration system. C#, .NET, Web Application, Access |
|
Haines & Company Technical Support Web Application |
Created a web application that accesses a
MySQL Database. It assists technicians in taking vital call
information, retrieving previous ticket information, and suggests
possible solutions. PERL, HttpMod, MySQL, Apache |
Independent Software Consultant Projects:
| Name: | Software description and Technologies: |
|---|---|
| Designed and SEO Optimized a multilingual, internationally hosted website. | SEO, HTML, Google Search Console, Bing Webmaster, Edge Hosting |
| SEO Optimization for Engineering IOT Sensing Consulting website | SEO, Hostinger, Google Search Console, Bing Webmaster |
| SEO Optimization for Local Auto Repair Body website | SEO, WordPress, Google Search Console, Bing Webmaster |
| SEO Optimization for Local IT Consulting Group website | SEO, WordPress, Google Search Console, Bing Webmaster |
| Real Estate Property Lookup for Civil Government Agency | C#, MS SQL, ASP.Net, IIS, Windows 2012 |
| SEO Optimization for Local Church | SEO, HTML, Google Webmaster |
| Server Infrastructure Migration for Non-Profit Denomination | ASP.Net, IIS, Windows 2012, Windows 2003 |
| Report Scheduler Windows System Background Service | C#, Windows System Service |
| Windows Server and Network Installation for Local Church | Windows Server 2008 SBS |
| Boutique Business Presence Website |
Created a website for the local boutique business including a store map. HTML, CSS |
| Chamber of Commerce Website |
Created a website for the local Chamber of Commerce. HTML, CSS |
Personal Projects:
| Name: | Software description and Technologies: |
|---|---|
| derek.souers.org |
Custom Content Management System, Mobile Compliant, Cross Browser Compatible C#, ASP.Net, AngularJS, ng-Tag-Cloud, Smart-Table, JQuery, JQueryUI, RSS, SEO, MicroData |
|
LnkMgr |
LnkMgr is a link/shortcut creator and
editor for the Pocket PC. It allows a user to effortlessly create and
categorize links en-masse in the Start Menu folder.
It also allows you to remove invalid
shortcuts. C#, CF.NET, WinForm, Windows Mobile, Win32 
|
| TemperX10 |
Allows you to send on/off commands to an
X10 device when a temperature is in a certain range via the Temper USB
thermometer device. Download: TemperX10_083010.zip (137k zipped eke file) C#, Console, Win32 |
| SendTo |
An IE plug-in that allows a user to
simply select some text from a web page and sends it to either a note or
text file on your Pocket PC, by simply invoking the Right-Click Menu
item of SendTo. C#, .NET, CF.NET, Windows CE, Windows Mobile, Win32, Internet Explorer, InnoSetup 
|
|
In-Progress/Future Projects: |
|
| Brainstorming Application |
A idea generation and research program. C#, Win32, OpenGL |