Projects

Project Scheduling and Reporting

A Window’s application written in C# for .NET 2.0 that allows the user to update custom date fields in Timberline’s Project Management. When certain dates are changed, business logic stored in an XML file is used to update related/dependent fields. The business logic takes into account business days so an Access database is used to store a calendar and allows the user to enter their own holidays which are then used in the calculations.

The reporting component utilizes the Crystal Reports Runtime Engine. To pass parameters to the reports a custom UI was designed that allows the user to pick filter criteria from drop down lists. These lists are dynamically populated based on the data available in Timberline. The Crystal Reports template files (RPT) are stored outside of the application so that they can be modified without requiring a new version of the application.

Microsoft Dynamics GP Integration a For Staffing Company

Created a C# application that allows a staffing company to download time cards for their employees from a web service provided by a Time Tracking website. The time cards were then pushed into Dynamics GP via another web service to create invoices so that the customers could be build. The project also involved create numerous SQL Reporting Services Reports from invoices to custom ageing reports.

Microsoft Dynamics GP Integration a For Real Estate Franchisor

Created a C# application that took in a feed of properties that were recently closed by their franchisees and automatically created invoices in Dynamics GP for royalties due. The project also involved create numerous SQL Reporting Services Reports from custom invoices to production reports for regional directors.

Excel 2007 Addin

Using Microsoft's VSTO 3.0 and C# an Addin was created for Excel 2007. The Addin allowed the user to download property budget information from a MS SQL Server database. Then the user could manipulate the values to figure out what the CAM charges would be for particular tenants. The CAM charge amount could then be uploaded back to the SQL Server.

Amazon Associates Web Service

Helpubuy.com allows the user to search for items to purchase. Behind the scenes HelpUBuy queries Amazon's product web service to find products meeting the visitors criteria and then re-directs the visitor to Amazon to purchase the particular item. One goal of the project was to allow the site to be easily indexed by the search engines.