[back to Bio]

Projects at Sunny Direct:

Phoenix Logistics Management System (LMS)

Client: International Transload Logistics | ITL Chicago
Project Status: 90% complete, in production use.
Role: Solution Architect, Team Leader, Primary Software/DB Developer, UI/UX, Business Analyst.
Comments: An internal enterprise business application used to manage warehouse and logistics activity.
The Phoenix LMS family has four interrelated layered solutions:

  • Main LMS (orders, inventory, customers, locations, moves, invoicing/billing, POs, etc.)
  • Crystal Report Server (Azure VM),
  • Floor Manager – custom user interface for hand-held tablets in the warehouse,
  • Membership/Role Manager (integration with Azure Active Directory).

Technologies:  ASP.NET 4.8,  MVC, C#, Entity Framework, Telerik Kendo UI components, MS SQL, Ajax, jQuery, Bootstrap, Crystal Reports. A layered software architecture:  Presentation, Service, Data, and DB (database project) layers. All solutions are hosted in Azure.


NetSuite Integration

Client: International Transload Logistics | ITL Chicago
Project Status: In production use.
Role: Solution Architect and Software/DB Developer, UI/UX, Business Analyst.
Comments: An internal business application used to manipulate and export data for NetSuite consumption. This application is a bolt-on to their legacy LMS.
Technologies:  ASP.NET 4.8,  MVC, C#, Entity Framework, Telerik Kendo UI components, MS SQL, Ajax, jQuery, Bootstrap. A layered software architecture:  Presentation, Service, Data, and DB (database project) layers. All solutions are hosted in Azure.


Document Management Tools and Frontend 

Client: Enterprise Holdings, Inc (EHI).
Project Status: Legacy and new systems in production use.
Role: Solution Architect, sole developer.
Comments: Document management tools track content/text changes to Rental Contracts and other legal documents. EHI business units would each have a custom version of the document tool. There are five document tools and a frontend application for SSO (SingleSignOn/SAML) and reporting.  EHI business users nationwide are responsible for updating, reviewing, and approving document changes.  Upon completion of the change process, documents would be sent to the printers, and business users could place orders for EHI car rental locations.
Technologies:  ASP.NET MVC and Webforms, C#, Entity Framework, Telerik Kendo UI components, MS SQL, Ajax, jQuery, SAML. A layered software architecture:  Presentation, Service, Data.


Warehouse Management System (Internal) 

Client: Sunny Direct.
Project Status: Legacy system in production internal use.
Role: Primary developer responsible for maintaining, refactoring, and maintaining this legacy system.
Comments:
Technologies: Classic ASP, MS SQL


eCommerce System

Client: Sunny Direct and Enterprise Holdings, Inc.
Project Status: Legacy system in production.
Role: Primary developer responsible for maintaining, refactoring, and maintaining the system.
Comments: An older eCommerce system used for B2B with EHI, modified to integrate with the new eProcurement system.
Technologies: Classic ASP, MS SQL


eProcurement  System 

Client: Sunny Direct, Coupa, and Enterprise Holdings, Inc.
Project Status: 100% in production for three years.
Role: Solution architect, business analyst, and sole developer.
Comments: A complete B2B eProcurement solution that generated up to $1.2 million in revenue per month.
Technologies: ASP.NET MVC / WebAPI, C#, Entity Framework and Dapper, cXML with Coupa, Telerik Kendo UI components, MS SQL, Ajax, jQuery, SAML. A layered software architecture:  Presentation, Service, Data, and DB (database project) layers. All solutions are hosted in Azure.


PriceLab  

Client: Sunny Direct and Springrock Gutters.
Project Status: 70% complete.
Role: Solution Architect, sole developer.
Comments: Project estimator  and invoice generator
Technologies: ASP.NET  Core, C#, Entity Framework and Dapper, Telerik Kendo UI components, MS SQL, Ajax, jQuery, KnockoutJS, Google Maps API. A layered software architecture:  Presentation, Service, Data, and DB (database project) layers. All solutions are hosted in Azure.


Projects at TEC Services:

Training Management System/Portal

Client: Cook County Department of Homeland Security
Project Status: 90% complete.
Role: Architect and Primary developer (sole).
Comments: Website CMS, courseware builder functionality, user registration, approval workflow, grid calendars, attendance tracker, certificate generator/mailer, document management, responsive design.
Technologies: Umbraco CMS is a development platform that is heavily customized and extended. ASP.net MVC5, C#, MS SQL, Ajax, jQuery, Web API, Bootstrap, AngularJS, Google Maps API.


Jobs4People.org, Website, Job Board, Resume Gallery, Display Kiosk

Client: Workforce Services Division of Will County
Project Status: Complete (2017)                   http://www.jobs4people.org/
Role: Architect and primary developer with minor UI assistance from a junior developer
Comments: The current website/app is the second version; I also solely developed the previous version, which was in production for the last seven years. Businesses can register, create, and manage job posts and view uploaded resumes from Job Seekers. Including an event management system with a calendar, user registration, and attendance tracking. Automated slide generator for an on-location display kiosk. There is a built-in workflow for job board admins. Responsive design. Built an automated PDF conversion engine utilizing Sharepoint and WCF, Auto post to Facebook.
Technologies: Umbraco CMS platform with custom user controls, ASP.NET MVC5, Web forms, C#, Entity Framework, Web API, WCF, jQuery, Bootstrap, MS SQL, Sharepoint, Facebook API, Windows Service.


Will.Works Website

Client: Workforce Services Division of Will County
Project Status: Complete (2017)     http://will.works/
Role: Architect, Team Leader, and developer
Comments: An informational website development that provided training for team members
Technologies: Umbraco CMS platform, ASP.NET MVC5, Bootstrap, jQuery.


Document Printing Kiosk for Touch-screen

Client: Workforce Services Division of Will County
Project Status: Compete (2017)
Role: Architect and primary developer (sole)
Comments: To be used by career consultants at the Workforce Center. Utilizes a web-based CMS to manage a central hierarchical document library with fast touchscreen printing.
Technologies: Umbraco CMS platform, ASP.NET MVC5, Bootstrap, jQuery.


High-Performance Document Conversion Engine

Client: TEC Services (internal development)
Project Status: Complete
Role: Architect and primary developer (sole)
Comments: TEC Services was in need of a high-volume automated MS Word to PDF document conversion solution that could used on multiple projects for training certificates, resumes, invoices, etc. I implemented a standalone Sharepoint instance on a virtual Windows 2012 server. Sharepoint provides conversions internally with no automation.  I built a Windows service that integrates with the Sharepoint conversion utility, listens for remote conversion requests, manages the conversions, returns completed PDFs, and cleans up. To complete the Service Oriented Architecture, I built a class library that exposed simple methods to initiate and manage conversions; Windows Communication Foundation (WFC) was used as a transport service. DLLs could be dropped into any project, and the underlying complexities of remote server communication and conversions would be completely hidden from the parent app.
Technologies: ASP.NET, .Net, C#, Sharepoint, WCF.


Events Calendar Phone Native Application (iPhone and Android)

Client: TEC Services (internal development)
Project Status: Phase I complete (2017)
Role: Co-Architect, API developer (Team project)
Comments: The application displays local events based on the user’s geographic location using a selectable radius of the user’s location.
Technologies: ASP.NET Web API, C#, Asynchronous Programming, MS SQL Spatial data types, GIS Google Maps integration, Xamarin, REST, Facebook API, Portable Class Library,  Open Auth 2.0


Time Reporting System

Client: Chicago Housing Authority
Project Status: Completed
Role: Architect and primary developer (sole)
Comments: A time tracking and reporting system was needed for a summer youth employment (internship) program. I built a web-based application for entering and managing employees and businesses associated with the employees.  Employees are organized into supervisory groups under a given business with multiple levels of account authorization. Daily time would be recorded for each employee. I built a reporting system where highly-formatted bi-weekly time sheets for each employ could be generated in bulk, printed, and later signed by the supervisors, paper was required.
Technologies:  ASP.NET Web forms, C#, Visual Studio Business Intelligence,  MS-SQL, SQL Server Reporting Services (SSRS).


DNS Zone Explorer

Client: TEC Services (internal development)
Project Status: Completed
Role: Architect and primary developer (sole)
Comments: Monitoring and managing dozens of websites, web applications, and DNS domains deployed across multiple servers became challenging, especially in a crisis mode.  I designed and built a web-based tool that hooked into our DNS servers and provided a real-time reporting interface for all DNS zones. All zones are listed, and each DNS zone can be examined in detail, showing all data (A-records, MX, NameServers, etc.). IP addresses are mapped to internal server names for quick access.  An interface to an external Whois API was built,  which pulled records to allow domain registration information and assigned Names Servers to be available in reports.
Technologies:  ASP.NET Web forms, C#

Total Living Network Roku Channel

Client: Total Living Network (TLN)
Project Status
: Development completed, then abandoned (2015).
Role: Architect, primary developer, and graphic designer.
Comments: A working channel was completed, but due to contractual issues, the work was canceled
Technologies: BrightScript, WOWZA streaming engine, various streaming protocols, AWS.


Athlete Data Management

Client: Chicago Training Center (CTC)
Project Status: Nearly complete — suspended development
Role: Architect and primary developer (sole)
Comments: CTC used a Microsoft Access application to manage and track athlete data: membership, performance, and attendance. I developed a plan to migrate (over time) this application to an enterprise-level solution with a web-based front-end for remote data entry. The existing app used a Microsoft Access Split Database Architecture. As an intermediate solution, I moved the Access DB application to a virtual machine configured as a web server. I then built an ASP.NET web front-end on top of the Access database back-end. I used Petatpoco as the data access layer (ORM) and Ninject as the DI framework, as Bootstrap for a responsive design front-end for mobile devices.
Technologies: ASP.NET Web forms, C#, MS Access, Petapoco, Ninject, Bootstrap


Chicago Public Computing Center Site Survey Tool

Client: Chicagoland Chamber of Commerce
Project Status: Compete/Retired (2012)
Role: Architect and primary developer (sole)
Comments: A web-based tool used to collect data regarding public computing centers in Chicago. A public website was created to allow users to view a (Google) map with placeholders and filters based on radius and available site services.
Technologies: ASP.NET Web forms, C#, MS SQL, Google Maps API


Chicago Housing Authority Operation Warm Order Processing and Inventory Application

Client: Chicago Housing Authority
Project Status: Retired (2010-2016)
Role: Architect and primary developer (sole)
Comments: This app provided a web-based front-end for CHA residents to order coats and an Admin back-end for inventory management (typically around 10,000 coats per year). This app has been used for 5+ years.
Technologies: ASP.NET Web forms, C#, Ajax, MS SQL


ITLaunch Training Program Website and Application

Client: Workforce Investment Board of Will County, DCEO, DOL (National Emergency Grant)
Project Status: Complete/Retired (2016)
Role: Architect and primary developer
Comments: Complex multi-part registration form with security and data encryption features. Approval workflow, document upload and management.
Technologies: Umbraco CMS platform, ASP.NET Web forms, C#, Ajax, XML, XSLT.


TeraU eLearning Center (Learning Management System / eCommerce)

Client: Tec Services (internal project)
Project Status: Complete (2015)    http://www.terau.com
Role: Co-architect, primary developer (internal team project)
Comments: Custom Learning Management System (LMS) with an eCommerce component. I built the checkout components, credit card processor, automated certificate generator/mailer, Reports, and Skillsoft API components and developed the website’s look and feel.
Technologies: ASP.NET MVC, C#, MS SQL, Ajax, WCF, SharePoint


Chicago Cook Workforce Partnership Website

Client: Chicago Cook Workforce Partnership       http://www.workforceboard.org/
Project Status: Complete ~2008 older website still alive.
Role: Architect and primary developer
Comments: An informational website with custom features, responsive design, 508 compliant
Technologies: Umbraco CMS, ASP.NET Web forms, XML, XSLT.


Workforce Investment Board of Will County Website/CMS

Client: Will County
Project Status: Complete ~2012 older website still alive.  http://www.willcountyworkforceboard.com/
Role: Architect and primary developer
Comments: A CMS upgrade in 2017. An informational website with custom features.
Technologies: Umbraco CMS, ASP.NET MVC, C#, Web API.


TEC Services Consulting Corporate Website (Previous Version)

Project Status: Retired (2007-2017)
Role: Architect and primary developer (sole)
Comments: It has served our company for ten years. I was not involved with the development of the current version.
Technologies: Umbraco CMS, ASP.NET Web forms, C#, XML, XSLT.


disabilityworks Website and Membership Management System

Client: Chicago Chamber of Commerce
Project status: Complete, retired (2006-2012)
Role: Architect and Primary developer (sole)
Comments: Complex member registration and membership management system, conducted group usability testing utilizing people with disabilities.
Technologies: Umbraco CMS, ASP.NET webforms, C#, MS SQL, XML, XSLT,  XPath.


Grundy Livingston Kankakee Workforce Board Website CMS Upgrade

ClientGrundy Livingston Kankakee Workforce Board
Project Status:  Complete (2017)
Role: Primary developer (sole)
Comments: The existing CMS was too difficult for office staff to use, and they requested additional editing features; they needed a CMS transplant and retained the existing layout. I scraped off the website front-end and integrated a new CMS.
Technologies: Umbraco CMS, ASP.NET MVC, C#,  razor views.