Business Problem

Remote warehouses are not directly connected to the central office and thus are not connected to the ERP System (Microsoft Dynamics Ax 2009).  Employees at remote warehouses need to perform inventory transactions on iTouch devices and some of these transactions require a label to be printed on a Zebra label printer.  Label printing typically involves a centralized print server that formats and streams the print job to a Windows Print Queue.  Remote printing using a Microsoft Print Queue is not feasible across the internet.

Solution

The solution to this problem was to build  a simple Windows Service which self hosts a WCF service.  The Windows Service has the ability to function as both a server and a client.  The service can poll other services for print jobs, if the print job is local the job is sent to a local label printer, if the job is remote it is queued for a remote server to poll (via WCF Services).  Print jobs are archived which allows a user to load the Status Monitor application and reprint a label.

http://buildsucceeded.com/oldpics/PrintConfig

Users can reprint labels using the above status screen.

http://buildsucceeded.com/oldpics/PrintConfig2

User’s can configure the print server, start and stop the service, and update the application using the configuration screen.

This software is written in .NET 4.0 using WPF/XAML as the UI.  The application implements the Model-View-ViewModel MVVM pattern.  The Windows Service is written in .NET 4.0 and self hosts a WCF Service.  Remote printing is implemented using WCF with client/server X.509 certificates for security.

Business Problem

Microsoft Dynamics Ax 2009 has a gap in functionality with regard to order management for repair orders.  MDSi has several equipment repair and configuration labs on site.  Customer equipment can be staged and configured or physically repaired and reconditioned.  While Microsoft Dynamics Ax 2009 does provide some of the functionality required to perform in-house repairs, it falls short in supporting the expanded workflow of a repair lab.  Repair orders needed to be tracked, labor costs tracked, and part/item inventory locations need to be updated in Ax to reflect where the parts are located based on workflow transactions.  For example, if a repair technician brings a part to his/her workstation and marks the repair line as in process, Ax needs to be updated to reflect the inventory has been transferred to the repair technicians ‘bin location’.

Solution

The solution was to fill the gap with a Silverlight 4.0 line of business application that will provide a simple user interface that allows warehouse workers and technicians to simply change the status of a repair line.  The application will perform the necessary inventory movement journal transactions to move the part from staging bins to in process and finally to complete warehouse bins.  If a part is successfully repaired a sales order is generated to allow for the invoicing of the repair.  If the repair cannot be completed, a disposal order is created.

http://buildsucceeded.com/oldpics/AllRepairs

All repair orders show in the main view.  Users can filter or group using the data grid.  From this view the user can also view the repair lines of a repair order and edit the details of a repair order.

http://buildsucceeded.com/oldpics/RepairOrderDetails

Creating or editing a repair order is accomplished through the screen above.

http://buildsucceeded.com/oldpics/RepairOrderDetailEdit

Editing the details of a repair line displays a modal view.

http://buildsucceeded.com/oldpics/PostPickingList

Warehouse personnel can pick the repair lines that are awaiting staging.  The above view shows all the repair lines that were picked by user dsandor.  From here, the user can print repair labels for the items and post the items.  When the user posts the items it indicates to the repair technicians that there are parts in the ‘inbound’ repair staging bin location.  Technicians will retrieve the items from the staging location and indicate the part is now ‘in repair’ which transfers the part in Ax to the tech’s bin location.

This project was developed in Silverlight 4.0 and C#.  It leverages WCF Services and SQL Server 2008 R2 T-SQL Stored Procedures to query data from Microsoft Dynamics Ax 2009.  Create, Update, and Delete operations are performed by interfacing with the .NET Business Connector for Dynamics Ax.  The application uses the MVVM design pattern and was developed in little over one week.

Business Problem

Casino Operators need to have concise real-time views of their operations.  A different classification of user needs to be able to view data in a different manner.  The existing application did not provide any data visualization tools to quickly show how the data is currently changing.

Solution

Build 43 different data visualization web parts for SharePoint Portal Server and allow each user to customize their dashboard.  The web application leveraged Windows SharePoint Services, ASP.NET, and WebServices to power the dashboard.  Business Analysis was performed which included interviewing Casino Operators, Customer Service Operators, and Casino Managers in an effort to include useful data visualization elements for each classification of user.

Below is a screenshot of the final output.  This project was completed in 2005.

http://buildsucceeded.com/oldpics/Dashboard_Latest_4_2006

Below is an example of the wireframe that the business analysis produced in order to green light the project.

http://buildsucceeded.com/oldpics/Dashboard_PreDesign

Summary

  • Over 15 years of programming and enterprise-level application development experience.
  • 10 years of experience with the Microsoft .NET Framework and C#.
  • Extensive involvement and management of all stages of the application development lifecycle including requirements gathering, architecture and modeling,  design, development and implementation.
  • Advocate for Agile development and usage of 37 signals Getting Real development concepts.
  • Completed all projects worked in the last 10 years.

Certifications

  • MCPD: [Charter Member] Web Developer 4 (ASP.NET 4.0, Visual Studio 2010, .NET 4.0)
  • MCPD: [Charter Member] Windows Developer 4 (WPF .NET 4.0, Winforms 4.0, .NET 4.0)
  • MCTS: [Charter Member] .NET Framework 4.0 Web Applications
  • MCTS: [Charter Member] .NET Framework 4.0 Windows Communication Foundation
  • MCTS: [Charter Member] .NET Framework 4.0 Data Access with ADO.NET
  • MCTS: [Charter Member] .NET Framework 4.0 Windows Applications (WPF / Winforms)
  • MCTS: [Charter Member] SQL Server 2008 Implementation and Maintenance
  • MCTS: .NET Framework 2.0 Distributed Applications
  • MCSE ( TCP/IP, Internet Information Server, Networking, Server 4.0, Workstation 4.0 )
  • MCSD ( Windows Operating Systems Architecture I & II, Visual Basic 5.0, Visual Basic 6.0, Microsoft
    Access, Visual Interdev 1.0, Front Page 2000 )
  • MCTS: Distributed (Microsoft Certified Technical Specialist: Distributed Applications)
  • MCT (Microsoft Certified Trainer)
  • C# Certification, Java 1, JavaScript
  • Linux Administration, Internet Security, Network Security

Publications

Microsoft: Unable to disclose title.
12/2005 – Windows Forms .NET 2.0, ASP.NET, Enterprise Development
07/2006 – Windows Mobile 6 .NET Developer
10/2007 – Workflow Foundation (.NET 3.0)
11/2007 – ADO.NET 3.0 / 3.5 (LINQ/MARS/XML)
07/2008 – ASP.NET 3.5
07/2008 – Windows Forms .NET 3.5
07/2008 – ADO.NET 3.5 (Entity Framework, LINQ)
03/2010 – .NET 4.0 Windows Presentation Foundation (WPF)

Generics and Predicates: Real World Examples
The .NET Framework 2.0 has introduced the concept of Generics and the use of predicates. This article should shed some light on the concept of predicates and give you some examples of using predicates in the real world.

Publication: Microsoft Developer Network Academic Alliance 10/2007

Dynamically setting properties of a class from a Database
In this short example I will demonstrate a powerful feature of Reflection that will allow you to dynamically set the values of a class. By setting the properties of a class dynamically, you can create a simple method that allows your class to be constructed and pre-populated from a database.

Publication: Microsoft Developer Network Academic Alliance, C-SharpCorner 05/2003

Writing an ActiveX Control with .NET
Software developers have used ActiveX controls on their web pages to add advanced functionality to the web experience. In this example, I will walk you through creating an ActiveX control that will show a simple user interface and accept input from a web page.

Publication: Microsoft Developer Network Academic Alliance, C-SharpCorner 03/2003

Events Made Easy: Lesson 1
The ability to fire an event is core to most Windows development projects. Events are useful for updating a user interface with changed data, or causing a piece of code to run after another piece of code has completed. .NET has brought us a powerful model for programming events. In this lesson we will write a small application that will show an example of an event.

Publication: Microsoft Developer Network Academic Alliance, C-SharpCorner 01/2003

Events Made Easy: Lesson 2 – A Little Advanced
In the previous lesson we created an event and consumed it. In doing so you probably noticed that our code would have been a little better if we could have determined whether or not the file actually existed. We could then provide more information to the user and make our code a bit more useful.

Publication: Microsoft Developer Network Academic Alliance, C-SharpCorner 01/2003

Open Source Contributions

Mono Project
http://mono-project.com/
Mono is an Open Source implementation of the .NET CLR. Mono is a free multi platform version of the .NET runtime and compilers written by .NET enthusiasts. I contributed to some of the Data Entity portions of the System.Data namespace. My contribution to mono was key to the success of an application I was involved in which required a .NET application to work on non-Microsoft operating systems such as Linux, Solaris, and a few non-traditional flavors.

.NetTiers
http://nettiers.com/
.NetTiers is a set of code generation templates that implement data layer and business entities while conforming to best practices and patters from well known and well respected subject matter experts like Martin Fowler. I began using .NetTiers in 2004 and really liked the conformance to patterns and practices. After using the product for some time I began contributing out of necessity and practicality.

FileHelpers
http://filehelpers.com/
FileHelpers is a high speed .NET Library that can be used to import/export/transform flat files from one format to another. This library is incredibly fast and can handle any input format and convert a file into any other format easily. I used this library at RBS Lynk to assist in transforming ISAM and COBOL formatted flat files that were well over 1GB in size into a MS SQL Server bulk import file in less than 90 seconds.

Work History

Microsoft Corporation – Contractor (via Studio B), Redmond, WA
March 2010
Author / Subject Matter Expert

  • .NET 4.0
  • Windows Presentation Foundation (WPF)

Microsoft Corporation – Contractor (via Studio B), Redmond, WA
July 2008 – August 2008
Author / Subject Matter Expert

  • .NET 3.5 ASP.NET
  • .NET 3.5 Windows Forms
  • ADO.NET 3.5 / Entity Framework
  • LINQ

Microsoft Corporation – Contractor (via Studio B), Redmond, WA
October 2007
Subject Matter Expert

  • .NET 3.5 Windows Workflow Foundation (C# / WF)

Management Data Systems International, Cumming, GA
October 2007 – Present
Software Architect / Lead Software Developer

  • Microsoft Axapta 2009 (Dynamics AX)
  • Integration with Business Connector & X++ Customizations
  • SharePoint Portal Server Development
  • WPF, WCF, WF development
  • MS SQL Server 2008 & 2005 Automation, Data Warehousing, BI (SSAS & SSRS)
  • Built a Windows Mobile application for Barcode Scanners*
    Windows Mobile,  and iOS iTouch code bases
  • Customized and Integrated with Microsoft Solomon IV and Microsoft Dynamics AX (Axapta) for inventory automation.
  • Provided integration points via SOA based WCF / Web Services.
  • Provided an Enterprise Disaster Recovery plan and architecture for Global Availability
  • Silverlight 3.0 and 4.0 based Line of Business Applications that provided Sales Forecasting, heads-up data visualization for salespeople.
  • WPF based RFID Inventory Management* and asset automation software deployed to remote logistics facilities around the US.  Global map with GIS features to visualize facility status and drill into outages.

* See project portfolio for more details on these projects.

Royal Bank of Scotland, Atlanta, GA
July 2007 – October 2007 (Contract)
Software Engineer

  • SharePoint Portal Server Development
  • WPF development and WF development
  • MS SQL Server 2005 Automation, Data Warehousing, BI
  • Enterprise IT Automation: Built network inventory and monitoring solution with .NET 3.0. Using WMI, ADSI, SNMP and other network management tools for display in a SharePoint portal server using ASP.NET and a SQL 2005 backend.
  • Automated data loading processes into data warehouses with trillions of records.
  • Trimmed data load times from 7+ hours to less than 10 minutes.
  • Advised senior management on Enterprise Application Integration Architecture

The Software Factory, Alpharetta, GA
Feb 2007 – July 2007 (Consultant)
Principal Consultant

  • SharePoint Portal Server development in .NET
  • WPF Development in C# 3.0
  • Windows Workflow Foundation (WF) development for a complex decision matrix
  • Grid based distributed Software Architecture in .NET (Provisional Patent)
  • MS SQL Server 2005 Data Architecture, Data Modeling, Stored Procedure Design
  • Continuous Integration, MS Build Automation, Unit Testing, Code Generation

Microsoft Corporation – Contractor (Direct), Redmond, WA
July 2006
Subject Matter Expert (SME) / Contributing Author

  • Contributing author for a .NET 2.0 related project
  • Microsoft Learning
  • Windows Mobile 6 Application Development

Microsoft Corporation – Contractor (Direct), Redmond, WA
December 2005 – January 2006
Lead Author

  • Lead Author for a .NET 2.0 related project
  • Windows Forms & ASP.NET 2.0
  • Distributed Application / Enterprise Application Development

RealTime Gaming, Atlanta, GA
2005 – 2007
Software Engineer

  • Converted legacy systems from ASP 3.0 to .NET 2.0
  • Architected and Coded a web portal with 43 unique pluggable web part displaying real time financials.
  • Assisted conversion from SQL Server 2000 to SQL Server 2005.
  • Pioneering advanced caching techniques for high traffic transaction systems.

Digital Evolution (SOA), Alpharetta, GA
2004 – 2005
Senior Software Architect

  • Assisted optimizations of SQL Server 2000 database that handles over 11 million rows per day.
  • Polished and bug fixed a .NET 1.1 application that runs on a headless web service proxy appliance.

Shop ‘n Check (Chek) International, Norcross, GA
2005
Senior Software Architect

  • Developed modules with .NET 2.0 to integrate into archaic application.
  • Re-Architected a componentized survey application.
  • Coded an online web-based image upload and manipulation application.  Provided advanced cropping and rotation functionality to novice web users.

Scientific Games International, Alpharetta, GA
2003 – 2004
Senior Software Architect

  • Author and Architect of a Lottery transaction, inventory and financials management system.
  • Authored code generation scripts that produced > 750,000 lines of code that represented 98% of the data layer. If schema changes were made during the project we simply regenerated our data layer to account for the schema changes without breaking object code.
  • First of its kind technology leap in the Lottery industry. Technology touted as the latest and greatest software achievement for our customer, reported by our customer.
    Six-Nines uptime hardware architecture featuring a Web Application Farm, a Web service Farm, and redundant SQL Server Cluster’s using MSCS.
  • Architected a ground up object based application development interface for rapid redeployment and redesign. Fully documented object model using MSDN style API documentation.

MCI WorldCom, Atlanta, GA
1998 – 2003
Enterprise Architect

  • Designed and single-handedly built a software deployment application using pre-web services technology and ASP 3.0 (SQL Server, Active Directory, ADO, ASP 3.0, VB5&6). System replaced Microsoft SMS server in the enterprise and deploys software to 230,000+ machines and mission critical servers globally.
  • Built web based software license enforcement application that managed all software licensing across 230,000+ computers world-wide.
  • Maintained and managed employee database of active and terminated employees for all of domestic WorldCom ~ 500,000 records. Database automatically recalculated employee lineage and organizational hierarchy using DTS jobs that ran at night.

Previous employment history is available upon request.

Mastered Development Technologies

Languages
C# 1.0 – 4.0, VB 4 – 6, VB.NET 1.0 – 3.0, C, C++, JAVA, X++ (Dynamics Ax 2009), Javascript, VB Script, T-SQL, Objective-C

Technologies
XAML, XML, HTML, Silverlight 1.0 – 4.0, WPF, WCF, WebServices, SOAP, WinForms, ASP.NET, XCode / iOS (iPhone, iTouch, iPad), Dynamics AX 2009

Development Tools
Visual Studio (All – 2010), Team Foundation Server (2005, 2008, 2010), Subversion, CVS, SQL Server Management Studio, SoapUI, Microsoft Expression Blend (3.0 – 4.0), Adobe PhotoShop, Adobe Illustrator

SDLC and Patterns
Agile, Waterfall, Model View Controller (MVC), Model View ViewModel (MVVM)

Business Problem

Mobile laser scanning applications for Microsoft Dynamics Ax 2009 are complicated, over-engineered, and down right ugly.  Many applications exist and are very configurable but provide a very poor user experience which in turn slows down the end user and makes the data gathering more error prone.

Solution

After evaluating several tools to provide Cycle Count, Purchase Order Receiving, Inventory Transfers, and Miscellaneous Receiving we decided it would be best to take a 37signals approach to Get Real with our application.  We provided our warehouse team a set of tools that allowed them to accomplish their job in a simple and user friendly manner.  In addition, we minimized our cost per mobile barcode scanner.  By using a $200 iTouch as the brains and a $499 Linea Laser Barcode cradle we dropped our $3,000 mobile scanning hardware to $699.

The user interface is built using Novell’s MonoTouch and is written in C#.  The XCode tools were also used for some screen layout.  No Objective-C was used on this project.  The iTouch applications make WCF calls to interact with Dynamics Ax 2009.  The WCF Services are written in C# 4.0 and employ the .NET Business Connector to interact with the ERP system’s data.  An Ax project that uses X++, Forms, Classes, and Schema Additions is used to provide a succinct API to the WCF Services.

http://buildsucceeded.com/oldpics/Screenshot 2011.02.01 17.02.54
PO Search Screen

http://buildsucceeded.com/oldpics/Screenshot 2011.02.01 17.02.46
PO Details Screen

Business Problem

Large companies have lots of facilities which need spare part inventory on hand.  Facility operators may not reorder parts in a timely fashion which can lead to a local shortage of equipment.  Some facilities may hoard equipment creating a local surplus of equipment.  Both extremes are costly to a company.

Solution

Provide a simple to use touch screen computer that detects when a part is leaving or entering the spare parts room.  Upon detection of the part the touch screen computer displays a ‘tag’ with information about the part.  The facility user can touch the tag on the screen and note the use of the part.  When parts come in for replenishment the facility user can notate the put away location of the part.  When are part is used inventory levels at MDSi are updated.  If the minimum stocking level is reached a reorder is automatically generated and shipped to the facility to keep the stocking level true.

Components

RFID Client (Touch screen workstation)
This is the device with which the facility users interact.

image

The client is built with Microsoft .NET Framework 4.0 and uses Windows Presentation Foundation (WPF) to present the UX.  The client leverages the Model-View-ViewModel (MVVM) architectural pattern and is written in C#.  Communication to the home office is provided via WCF services.

image

RFID Tags are read via a Motorola XR-450 tag reader.  This reader was selected because it has a built in Windows CE operating system that allows us to write Mobile Embedded .NET applications to interact with the reader and with our WCF Services.  The RFID Client Workstation has a Windows Service written in C# and .NET 4.0 which continually polls the XR-450 reader for new tags.  The service exposes a .NET Remoting service which is consumed locally by the client UI.  Multicast events are thrown and the client system can respond to new tags accordingly.

RFID WCF Services
All RFID Clients communicate to a set of centralized web servers in an NLB farm.  The WCF Services provide a data exchange layer which provides caching by leveraging the AppFabric Cache feature of Windows Server 2008 R2.  Data is stored in a SQL 2008 R2 Cluster and the data is organized through Microsoft Dynamics AX 2009.  X++ and Business Connector code was created to interface through the ERP system and pass through all of the business rules configured in the Dyanmics Ax system.  In addition to using the .NET Business Connector and custom Dynamics Ax projects to manage the data, ADO.NET, Linq and C# is used in the creation of these services.

RFID Management Display
A Network Operation Center (NOC) application was created to provide real-time node (RFID Touch Screen Client) availability data.  This data is organized on a map and allows an operator to drill in to a workstation and remotely manage the system.

image

RFID Warehouse Printing
Tools were created to interface with the Microsoft Dynamics Ax 2009 ERP system which allow a warehouse employee to print RFID labels for items being shipped out for replenishment.  This system interfaces with the Zebra RZ 400 RFID Printer.  This application was created using WPF, WCF, MVVM.

image

RFID On-Site Inventory and Auditing Tool
This application allows a warehouse specialist to audit a sparing facility.  This application is written using WPF and .NET 4.0.  The application consumes the same WCF services provided for the RFID Client to connect to the ERP system.  The application allows a specialist to print labels via a wireless Zebra RP4T RFID Label printer.  Using this application a project coordinator can determine what inventory is needed on site and what can be returned for general usage to the Distribution Center (DC).  This allows for a quick and efficient auditing process.  The warehouse specialist does not need to know anything about the product, just scan the serial number and the application tells the specialist the disposition of the part based on the Min/Max settings in the ERP system.

image

RFID Node Creation Tool
The Node Creation Tool allows a support engineer to provision a remote RFID Touch Screen Client from a central location.  A support engineer can provision all of the standard configuration settings for Development, Test, and Production from the single tool.  This application was created with WPF, C#, WCF, MVVM.

image

RFID Online Spares Management Web Application
A Silverlight application was created to provide scaled down functionality for locations that do not have the RFID Touch Screen client installed.  Some locations need the ability to consume, count and audit their inventory without an RFID client.  In this case a laser barcode scanner is used to scan the RFID barcode.  This application was written in Silverlight 4.0, uses WCF Services, and employs the MVVM architectural pattern.

image