Senior Node.JS Developer and Database Architect/Engineer implementing various solutions for the Financial Crime Enforcement Network. Architected and developed complex database solutions including creation of custom MySQL OLAP cubes and Oracle->MySQL ETL processes using SAS Studio and MySQL. Migration of MS Access application to MySQL and Node.JS. Established JavaScript coding standards and lead development of Express.JS REST micro-services. Provided code review and mentoring to other developers.

SAR Stats Interactive

Web application used to generate multi-dimensional (dimensions based on selection criteria) computational reports. Calculations are dynamically generated from a database architected using a custom OLAP solution in MySQL.

https://www.fincen.gov/reports/sar-stats

• Tools: VS 2012 Pro, Gulp, SAS, Mocha, Subversion
• Platforms: Express.JS, CSV, CSS3, HTML, PHP and JavaScript
• Databases: Oracle source, ETL using SAS and CSV, MySQL OLAP and persistence

Egmont Biennial Census

Web application used to submit, review and approve Egmont Biennial Censuses. Auto registration and login based on VPN/LDAP login. Migrated historical data from MS Access to MySQL allowing pre-population of PDF Form with data from last submission.

• Tools: VS 2012 Pro, Gulp, Adobe LiveCycle, Mocha, Subversion
• Platforms: Adobe XFA/PDF, LDAP, Express.JS, CSS3, Angular.JS
• Databases: MySQL migrated from MS Access

314B Reporting Application

Web application used to report suspicious financial activity, upload files, submit comments and respond to requests for financial information. Allows editing, reviewing and approving of submitted information. Migrated 40k+ user information from MS Access to MySQL.

• Tools: VS 2012 Pro, Gulp, Mocha, Subversion
• Platforms: Express.JS, CSS3, Angular.JS
• Databases: MySQL migrated from MS Access

314A Management Application

Web application used to manage the reporting of suspicious financial activity. Solution included enhancements and remediation of legacy defects.

• Tools: VS 2012 Pro, Gulp, C# Unit, Subversion
• Platforms: WCF C#, CSS, HTML, JavaScript, AJAX, ASP.NET Web Forms

Databases: Oracle 11g

Architected and implemented solutions to improve stability and performance issues in various C# Windows Service, MS SQL, Oracle PLSQL, Oracle Apex, VB6 and VBA applications for Qualcomm Legal Department. Provided mentoring and code review to developers for C#, SQL and Oracle Apex.

DMO DMS Monitoring Service

Windows service providing 24x7 monitoring of critical file management systems, web applications, and web services. Capable of downloading files and performing validations to ensure that correct document is downloaded and available for user consumption. Contains a reporting module for exception/error notification and periodic scheduled reporting.

• Tools: VS 2012 Enterprise, Perforce, Subversion, GitHub
• Platforms: C#, Entity Framework, SMTP, Enterprise Logger, SiteMinder Security Module
• Databases: MS SQL

DMO DMS OCR Processing Service

Windows service that determines which PDF documents need Kofax OCR processing. Able to check-out required documents from repository, transfer documents to Kofax system and perform check-in to repository and WorkSite servers. Database recording of all transactions and exceptions. Includes self-correcting logic in issues related to secured PDFs, network and server outages. Contains a reporting module for exception/error notification and periodic scheduled reporting.

• Tools: VS 2012 Enterprise, Perforce, Subversion, GitHub
• Platforms: C#, Entity Framework, SMTP, Enterprise Logger, NTLM
• Databases: MS SQL, Kofax Capture

SiteMinder Security Module

C# Class library used by Legal Department NET applications to obtain host and domain-based authentication cookie from SiteMinder R6 and R12.

• Tools: VS 2012 Enterprise, Perforce, Subversion, GitHub
• Platforms: C#, NTLM, SiteMinder R6/R12

Discovery Action Request Application

Workflow Application used to submit, process and track requests for legal matter discovery requests. Attorneys may submit requests for interviews, data collections, data preservations and other special requests in support of legal cases.

• Tools: VS 2012 Enterprise, Perforce, Subversion, GitHub
• Platforms: Oracle Apex, JavaScript, PLSQL, SiteMinder R6/R12, LDAP, Oracle Mail

Databases: Oracle SQ

Lead various NET Framework migration projects for State Department. Provide analysis of legacy VB6/VBA DLLs, databases and VBA\VB6\NET 2.0 applications. Architected solutions to replace legacy systems using NET 4.0, MVC Razor, C#, WCF, Entity Framework and SQL 2008 database. Implementation of solution using EF database first techniques in Visual Studio 2010 with TFS repository. Conducted interviews for new development team members and provided recommendations to VP Government Services to increase staffing as required.

No examples available for specific discussion due to security classification

Provided software and database engineering, architecture and development services using NET Framework to Department of Energy (Savannah River Site). Implementations include both web and desktop applications. Mentored developers in the use of Visual Studio, Team Foundation Server and Object-Oriented Programming using C# and VB. Migrated Oracle Forms application to ASP.NET MVC/C# application.

Equipment Rental Management Suite

Collection of applications used in the management of equipment rentals used for maintaining equipment rentals, including maintenance, usage, and lease management at a Department of Energy nuclear site. Application compiled in multiple DLL and EXE to support a group of three sub-applications.

• Tools: VS 2010 Pro, TFS, Quest TOAD, SQL SMS, SQLyog, and MS Access
• Platforms:
  • • Windows Desktop Application: VB.NET WinForms
    • Windows Service Batch Application: VB and C# NET DLLs
    • Web Application: ASP.NET C#, Web Forms, AJAX and JavaScript
    • Data DLL: C# library containing data access objects for all applications
    • Share DLL: VB library containing common/utility methods for all applications
    • Finance DLL: VB library containing methods to interface with PeopleSoft
• Databases: Oracle, MS SQL, MySQL, MS Access and XML/Data Schemas using a mix of ADO.NET, ODAC, MDAC and/or LINQ.

Off-Shift Duty Website

ASP.NET workflow application used to request, approve and track overtime, including a mobile web application specifically developed for Blackberry support, but designed to detect and format to most mobile devices.

• Tools: VS 2010 Pro and TFS
• Platforms: ASP.NET 3, C#, AJAX, CSS, HTML and JavaScript
• Databases: MySQL using ADO.NET

Automated Load Planning System

ASP.NET application used to plan and calculate multi-crane load lifts.

• Tools: VS 2010 Pro and TFS
• Platforms: ASP.NET 3, C#, Entity Framework 4, AJAX, CSS, HTML and JavaScript
• Databases: MySQL using ADO.NET

Provide software and database engineering, architecture and development services to various small businesses, religious and academic organizations. Implement solutions designed and developed that use technology stacks and frameworks tailored to the needs of the customer.

Christian Organizational Website

ASP.NET application for a 509(a)(2) Non-Profit Christian Organization using .NET micro-services. Non-standard features include automated data backup and restoration, and a CMS for managing content, security and site activity reporting.

http://www.genesisproclaimed.org

• Tools: VS 2015 Pro, TFS, and Artweaver
• Platforms: ASP.NET 4.5, MVC 5, Razor, C#, Entity Framework 6, HTML, CSS 3, and JavaScript
• Databases: MS SQL using ADO.NET

Individual Author Website

ASP.NET application for a Christian Non-Fiction Author-Book that contains local and embedded media including YouTube linked videos. Non-standard features include CMS for managing content, security and site activity reporting.

http://www.historicalgenesis.com

• Tools: VS 2015 Pro, TFS, and Artweaver
• Platforms: ASP.NET 3, C#, CSS, HTML and JavaScript

Databases: MS SQL (User Mgmt.) and MS Access (Content) using ADO.NET

Application to support oncology healthcare teams in ordering, preparing, and documenting the administration of chemotherapy. The original versions front end was coded in Ext.JS 4.1 and was converted to React.JS. Solution is hosted in AWS EC2 with Windows 2012 R2 OS for MS SQL Server, Red Hat Linux 7 for the application components, and S3 for backup.

Express.JS application that provides REST capabilities to perform federated and aggregated data querying of any Vista instance and network-wide data synchronization.

MUMPS solutions to address critical legacy defects for VA FileMan and Kernel APIs.

MUMPS solution to provide new VA FileMan data types which extend the data validation capabilities within VistA to ensure data integrity of complex health data.

MUMPS regression and data integrity testing solution used to validate all VA FileMan MUMPS APIs. Written in Java to provide an open source solution for the VistA community.

MUMPS solution to provide backend conversion of MUMPS formats.

MUMPS solution to provide backend processing of data used to synchronize FileMan Data Dictionary files.

MUMPS solution to provide backend querying (CRUD) of FileMan Data Dictionary file data.

Web application used to generate multi-dimensional (dimensions based on selection criteria) computational reports. Calculations are dynamically generated from a database architected using a custom OLAP solution in MySQL.

Web application used to submit, review and approve Egmont Biennial Censuses. Auto registration and login based on VPN/LDAP login. Migrated historical data from MS Access to MySQL allowing pre-population of PDF Form with data from last submission.

Web application used to report suspicious financial activity, upload files, submit comments and respond to requests for financial information. Allows editing, reviewing and approving of submitted information. Migrated 40k+ user information from MS Access to MySQL.

Web application used to manage the reporting of suspicious financial activity. Solution included enhancements and remediation of legacy defects.

Windows service providing 24x7 monitoring of critical file management systems, web applications, and web services. Capable of downloading files and performing validations to ensure that correct document is downloaded and available for user consumption. Contains a reporting module for exception/error notification and periodic scheduled reporting.

Windows service that determines which PDF documents need Kofax OCR processing. Able to check-out required documents from repository, transfer documents to Kofax system and perform check-in to repository and WorkSite servers. Database recording of all transactions and exceptions. Includes self-correcting logic in issues related to secured PDFs, network and server outages. Contains a reporting module for exception/error notification and periodic scheduled reporting.

C# Class library used by Legal Department NET applications to obtain host and domain-based authentication cookie from SiteMinder R6 and R12.

Workflow Application used to submit, process and track requests for legal matter discovery requests. Attorneys may submit requests for interviews, data collections, data preservations and other special requests in support of legal cases.

Collection of applications used in the management of equipment rentals used for maintaining equipment rentals, including maintenance, usage, and lease management at a Department of Energy nuclear site. Application compiled in multiple DLL and EXE to support a group of three sub-applications.

ASP.NET workflow application used to request, approve and track overtime, including a mobile web application specifically developed for Blackberry support, but designed to detect and format to most mobile devices.

ASP.NET application used to plan and calculate multi-crane load lifts.

ASP.NET application for a 509(a)(2) Non-Profit Christian Organization using .NET micro-services. Non-standard features include automated data backup and restoration, and a CMS for managing content, security and site activity reporting.

ASP.NET application for a Christian Non-Fiction Author-Book that contains local and embedded media including YouTube linked videos. Non-standard features include CMS for managing content, security and site activity reporting.