Bryan Kessler Email & Phone Number

We specialize in custom web, Windows, and database application development using Microsoft tools and technologies.

Delivery of an enterprise-wide tool that allows Planners to enter and update their individual projects, group projects into plans, track key milestones and dependencies between projects, and forecast and track capital spread. The individual projects in the system can be summarized into an integrated Plan of Record so that key stakeholders can benefit from better information and track the variances against the plan. This tool allows different users to view details and summaries of planned and in-flight work and it helps facilitate management discussions. This application was built with SQL Server 2005, ASP.Net, C#, and VB.Net. The tool used AJAX web-services extensively to create a better user experience.Delivery of an application for the South East region that allows Engineers to manage the execution of planned work by updating actual milestone dates, capital spreads, procurement information, and other project related data. Reports were created that helped mangers know the status of individual jobs, what milestone a job was currently on, and when the job was expected to be completed. This application was built with SQL Server 2005, ASP.Net, C#, and VB.Net.

Delivery of a Data Mining module that allows LRI’s clients to analyze summary-level and detailed-level customer, product, vendor, order, shipping, and inventory data. Incorporating the business practices of LRI, this application uses SQL Sever 2000 for data storage, data mapping, and data cleansing. Relying heavily upon SQL Server Analysis Services and Data Transformation Services (DTS), this tool can take data from any data source and transform it into an efficient data warehousing solution that allows users to slice and dice their data. The user interface and business rules were developed in ASP.Net and VB.Net.Delivery of an Inventory Optimization module that incorporates LRI’s world-class inventory management principles. This tool helps users determine the optimal inventory levels for their most popular products, find the appropriate balance between safety stock levels and stock outs, calculate optimal reorder quantities, and assess the Gross Margin Return on Investment. This application was developed in SQL Server 2000, ASP.Net, and VB.Net.

Delivery and management of an extensive build process that extracts customer, product, shipment, order, inventory, sales, and budget data from multiple data sources, cleanses and transforms the data according to client-defined business rules, and loads the data into a normalized database. This build process is the mission-critical middleware to an enterprise-wide forecasting and planning system. This application was developed using Access 2000 and Visual Basic 6.0.Delivery of a Leadtime Analyzer tool that helps production planners determine when they can take new orders. The application was developed using Access 2000 and Excel 2000.Delivery of a Production Planning module that helps production planners manage production plans using sophisticated inventory models. The application was developed using Access 2000.Delivery of an SKU Analyzer module that helps production planners manage properties about an SKU. The application was developed using Access 2000.Delivery of an Inventory Review and Disposition module that helps production planners manage the disposal of obsolete inventory. The application was developed using Access 2000.

Delivery of a data migration solution that helps users move their legacy data into a SQL Server or Oracle database. The application was developed with “wizard” type functionality using Access 2000 and Visual Basic 6.0. The application validates the user’s data against business and validation rules, while ensuring that keywords are entered correctly.Delivery of an Internet-based Invoice Tracking System that allows sales staff to track invoices. The application was developed using Access 2000, ASP, Visual Basic, and XML.

Delivery of multiple $100K+ n-tier internet/intranet solutions utilizing Active Server Pages (ASP)/DHTML user interface layer, Visual Basic 6.0/MTS/MSMQ COM middle layer, and SQL Server 6.5 (including stored procedures and triggers) data layer. Worked on the following types of solutions:- 401K internet application- Call Tracking intranet application- Document Management intranet application- Delivery of SQL Server 6.5 based data warehouse and Access 2.0 reporting application- Delivery of Access 97 Event Management system- Utilization of the Microsoft Solutions Framework (MSF) to successfully deliver solutions on time and within budget- Design n-tier architectures and write functional specifications for business solutions- Design and build databases