"The data analysis supported the team leader’s credibility for the proposed arguments to improve the situation.  The client accepted the arguments based on the data analysis …"

Project Portfolio:
  Database Reconciliation Analysis Project

Challenge

This project involved the analysis of a database reconciliation project.  The challenge was to analyze the database before the reconciliation and after the reconciliation.  The reconciliation of the database project involved cleaning up a large database of contacts and the relevant contacts’ information.  The clean-up also involved the acquisition of updated information from the contacts.

Solution

The solution to this project involved comparing the database before and after the reconciliation of the database.  Using data extracted from the Lotus Notes Database onto excel spreadsheets I was able to have both states of the database.


Once the data was on excel I used various excel formulas and programing constructs to compare and contrast the database before and after the cleanup project.  I used computer programing concepts (i.e. functions, boolean expressions, relational operators & conditional statements) in combination with the excel formulas.


Using these techniques, I was able to analyze the database, saving tens to hundreds of resource work hours, enabling the performance of work not possible otherwise due to a limited budget.

Results

The analysis I conducted of the database project work helped contribute findings to the final project report presentation.  The data analysis supported the team leader’s credibility for the proposed arguments to improve the situation.  The client accepted the arguments based on the data analysis and was receptive to the proposal to improve the situation.