Mapromar

Mapromar is a business I started in my last year of high school developing reliability engineering tools. My first contract was to develop a tool in Excel and VBA for Root Cause Analysis (RCA). I later developed a tool in Access and VBA for Reliability Centered Maintenance (RCM). I continued to develop tools in Excel, Access, VB6, VB.NET Winforms, ASP.NET, ASP.NET MVC.

I then decided to build a more professional tool for RCM, RCM Tuner. Branching off the development of RCM Tuner I also created a tool for Failure Mode Effect Analysis (FMEA), FMEA Inspector.

These projects were creating entirely from requirements to market in VB.NET and WPF. This included writing a complete control library for user input and a suite of charting controls and a reporting engine to export and print data. An MVVM framework was created to facilitate in the quick development of data entry pages and powerful data mining features. A custom data access layer was implemented to write all database queries in code similar to LINQ and convert these expressions into SQL for the appropriate Relational Database Management System (RDBMS). The library could manage databases and create SQL queries for MS SQL, Oracle, MySQL, and PostgreSQL.

An additional feature was the ability to manipulate data offline and sync this data to a central server and updating across an entire network. A data synchronization framework was coded from scratch to sync data between clients and servers and also servers to other servers using WCF. This also allows mining data for changes over periods of time. A custom WCF channel was implemented to compress data and securely exchange a cryptographic key for communication across the network using AES.

Screen shots and trail versions can be obtained at www.mapromar.com.