Responsible for the development of a rules-based payment tracking system. This system allows managers to track the amount and frequency of infrastructure payments at a major utility company. The Nextera Facilities Reporting application describes the amount and frequency of payments required to maintain the thousands of wind turbines, collection lines and transmission lines within Nextera Energy’s infrastructure.

• Created data access classes in C#/.net 10 for the infrastructure, measurement types, and payment rules used by the application
• Created WebAPI controllers to provide data access to the front end
• Used LINQ to filter and sort Entity Framework lists before returning results
• Implemented Microsoft Entra authentication
• Integrated the existing roles database with the claims (specifically, the email address) returned by Microsoft Entra authentication
• Matched the returned email against the existing roles database, allowing for current users to maintain their existing access level and privileges in the updated application
• Implemented CI/CD pipelines across Dev, UAT, and Production
• Used Visual Studio Test to create a test automation framework consisting of multiple test scripts that could be automatically run before a build
• Built views for infrastructure, measurement types and payment data

Responsible for the implementation of a .net Core/SQL Server application containing Nokia’s organizational structure, as well as the processes and dependencies of each organization. A .Net 8/Bootstrap user interface allows managers to enter their organization's structure and functions within their organization. Reports from the database allow managers to determine which projects are essential to Nokia’s daily operations and monitor their progress in planning for disruptions.

• Selected a leading Bootstrap template for the UI framework
• Built Razor Pages in .NET 8 for the business continuity workflow
• Implemented Azure Active Directory authentication
• Built user, role, permission, user-role, and role-permission views for administration and authorization
• Built SSRS reports on organizational compliance with Nokia's Business Continuity policy, by manager

Four databases across dev, UAT, and prod had drifted from source control in different directions. Built a WPF utility that ran 12 concurrent Red Gate SQL Compare threads, monitored them, and concatenated the results into a single deviation report.

• Built the C#/WPF comparison and monitoring utility
• Integrated Red Gate Subversion across 12+ existing databases
• Used the SharpSVN API to diff Subversion stored procedures against live SQL
• Built a generic multithreaded process list, cutting comparison cycle time over 80%
• Used MVVM to keep the presentation layer maintainable
• Distributed SSRS/HTML deviation reports via a Windows service and System.Net.Mail over IIS SMTP

Wells Fargo regularly pledges existing loan receivables to the Federal Reserve as collateral for new loans. The loan securitization application contains an inventory of more than ten million loans, from which users can search and select eligible loans and create a delivery file for the Federal Reserve. The development team’s primary challenge is performance: the system must quickly search, sort, and deliver a large, growing portfolio of outstanding mortgage loans.

• Added indexes based on user-authored rules
• Built SSIS packages to load and transform external data
• Denormalized large loan tables into manageable sub-tables
• Built ASP.NET UIs to preview, define, and run custom loan delivery processes
• Built SSRS reports on pledged/unpledged loan status
• Reviewed, tested, and deployed changesets from multiple developers to production
• Wrote deployment scripts, docs, and checklists covering SSIS, DDL/DTL, and ASP.NET/C# business logic across environments
• Maintained dev/UAT/prod integrity and handled ongoing change requests

Generated price quotes for cellular/wireless certification work (PTCRB, Bluetooth, Wireless, FCC/CE) based on requested services.

• Built the quote request site in C#/ASP.NET, matching existing Cetecom site markup
• Designed the database for price quotes and sales requests
• Built an ADO.NET data access layer returning generic object lists to the controller
• Extended the ASP.NET user/role application block with a permissions table defining each role
• Used ASP.NET AJAX and Telerik components for a more interactive, polished UI

ASP.NET/C# website for scheduling and reporting cellphone tests; the application allows users to add, edit, search, and monitor the status of device tests.

• Built the ASP.NET/C#/SQL Server UI to manage test projects
• Built user/role management and project-assignment interfaces
• Built an ADO.NET data access layer returning generic object lists to the controller
• Used ASP.NET AJAX components for a clean data presentation

Visa’s current fraud reporting system depends on two main components—a command-line based fraud processing module, and a web-based data entry and reporting application. Visa did not have source code for any of the command-line applications supporting the website and requested that they be decompiled from IDL using JetBrains dotPeek and rewritten.

• Decompiled the command-line application into C# and made it human-readable
• Added the PGP Blackbox library to meet PCI compliance
• Built ADO.NET data objects to store the encrypted data within SQL Server
• Built the ASP.NET/C#/SQL Server front end for compromised card reporting and management annotation
• Built Crystal Reports for summarized account data, including PDF generation from C# batch processes