Software Developer in Blaine, MN, United States

I initiated this project as a means towards a much larger goal of a functional motion-based model. This diagnostic tool provides the capabilities to search and navigate from one part of the body to another. It uses SQL common table expressions (CTE) to navigate through a hierarchical pair recursively.

The hierarchical pairs consist of 3D points extracted from vertices of 3D object files representing parts of the body and matched up as pairs where vertices meet. Each body part exists as part of multiple hierarchies within the Foundational Model of Anatomy (FMA).

There are options for avoiding different body part categories in the search. For example, I can avoid any paths that involve going through the skin when going from the tongue to the occipital lobe.

The search is asynchronous and happens in parallel in three ways:
- A task that traverses hierarchical pairs from the start node towards the end node.
- A task that traverses hierarchical parts from the end node towards the start node.
- A task that monitors the first two tasks can also end the search if the search goes beyond two minutes.

Using the cancellation tokens concept, any task can quit the search if any of the tasks meet their goal.

Re-tooled and re-platformed the existing VB6 system and database to an intranet ASP.NET application. The Public Safety divisions in the State of Minnesota use the system to order and receive items from the Public Safety Warehouse.

- Implemented a preordering functionality to improve self-service adoption for the public safety division admins, especially trooper districts, and removed the dependency on data entry staff who manually entered orders received via fax from divisions around the state.
- Integrated system with Speedee shipping system.
- Incorporated internal active directory groups as application groups within the app controlled by warehouse admins for application data and object security.
- Incorporated an "act as" functionality, allowing warehouse admins to ensure application groups and their users only saw data and pages they were entitled to see.
- Incorporated expiration of inventory items sent to all public safety personnel with notifications on upcoming expirations.
- Implemented workflow to allow warehouse staff to control and manage how orders came into inventory, including the triggering of backorders as needed.
- Added the notifications seen only by admins to review the items requiring immediate addressing.

Designed and implemented the replacement of the OpenText Process360 document management application. Vendor stack needed to be decommissioned while still allowing LOB to retain its robust functionality and integration with PeopleSoft procure-to-pay solutions.

-Re-architected the vendor-delivered document capture to use existing enterprise Kofax Capture push interfaces for fax, email, and scan.
-Vendor-delivered document storage was re-architected to use an intermediate FileNet web service interface to the enterprise FileNet storage.
-Replaced the vendor-delivered document workflow with a new custom C# workflow engine using Windows Services, XML, and SQL tables.
-77 servers were tech refreshed with significantly reduced VMs, reducing server footprint and costs while increasing application redundancy.
-Migrated FINRA documents from vendor repository to FileNet to meet FINRA WORM compliance for the company with both systems online at the same time without impacting document workflow.
-Rebuilt and redeployed a custom PeopleSoft browser for accounts payable line of business from VB6 to C# using Chrome APIs.
-Added PeopleSoft Financials application as a document capture source for the enterprise document centralization.

Implemented an OBIEE analytics solution for the supply chain department to enable the company to manage its suppliers and contracts better and spend from requisition-to-payment distributions.

The federation included all spending related-data sources such as Emptoris contracts, PeopleSoft procure-to-pay solutions, and spreadsheets used to analyze expenses and invoice images.

Various hierarchies such as product, supplier, people, general ledger, and accounting were included to provide one view of all expense-related data. Communications during invoice processing were included to identify process improvements and improve SLAs.

The default model came with PeopleSoft EPM (SCM). My involvement for each requirement agreed on with the supply chain line of business:
- Modeled existing warehouse schema in OBIEE to enable creating user dashboards.
- Modeled new schema objects from sources with the ETL team for the best representation in OBIEE.
- Ensured correctness and speed of daily dashboard queries.
- Recommended optimizations to the ETL team and end-user report writers and reseeded cache in OBIEE.

With my team, I provided PaaS services for other LOBs within corporate finance departments needing reporting or analytics.