NJ5J Software Corp

Client List and Samples

Stream Global

  • Build data structures, constraints, triggers, auditing, stored procedures for Employee event tracking.
  • Saphire Tables
  • Saphire Stored Procedures
  • Saphire User Defined Functions
  • Saphire Triggers
  • Saphire Visio Designs

Sproc Sample - Merge - with Surrogate Key (Identity Key) - without replication flaw!


  •      
    /* Copyright 2013 Carl R Perkins. All Rights Reserved.

Boy Scouts of America

Voice of the Scout

  • Purpose: Send email surveys to Members and collect statistics and report on the feedback.
  • Screen Shots
  • SSIS Packages
  • Visio Charts
  • Triggers
  • Stored Procedures
  • User Defined Functions
  • Constraints

Persons Merge

  • Purpose: Identify potential duplicate members, track and allow Council members to Merge data or delete duplicates.
  • Screen Shots
  • SSIS Packages
  • Visio Charts
  • Triggers
  • Stored Procedures
  • User Defined Functions
  • Constraints

Be A Scout

  • Purpose: Allow people to Join Scouts. Collect data from potential members.
  • Screen Shots
  • SSIS Packages
  • Visio Charts
  • Triggers
  • Stored Procedures
  • User Defined Functions
  • Constraints

Data Quality Tracking / Analysis

  • Purpose: Track data as it flows through system and sent notifications when anomalies occur.
  • Screen Shots
  • Visio Charts
  • Stored Procedures
  • User Defined Functions
  • Constraints

Pioneer Natural Resources

  • Identify SSIS design flaws and recommend new approach. Rebuild SSIS Packages and Stored Procedures to add error trapping and auditing and correct existing query flaws.
  • Tables
  • Stored Procedures
  • User Defined Functions
  • Triggers
  • Visio Designs

Army Air Force Exchange Service

  • Design Failsafe Fault Tolerant system to acquire DMDC data on all worldwide military personnel and push to mainframe, identifying data flaws and notifying DMDC of data flaws for their corrections.
  • Tables
  • Stored Procedures
  • User Defined Functions
  • Triggers
  • Visio Designs

Screen Shots of Web Applications

  • Build database and web site and data warehouse to acquire new DSL customers and track their data.
  • Tables
  • Stored Procedures
  • User Defined Functions
  • Triggers
  • Visio Designs

© 2013-2015 Carl Perkins. All Rights Reserved.