Configuration Management Database Data Integrity
My first project at Monsanto didn't waste any time throwing me into the fire. I was assigned the task of replacing their old system of MS Access queries and tables, Excel Macros, and automated procedures. They wanted this system to be replaced with an automated procedure within Oracle. The task was to deliver a dashboard to display CMDB data integrity metrics for their thousands of servers, applications, and software servers. I utilized SQL queries to create views to enforce customized business rules given to me by my team members. These views were compiled daily and placed into a table, stamped with the date. I used SQL Reporting Services to display the current days data integrity metrics, along with the ability to see metrics of past days. Below shows the dashboard, along with the drilldown reports showing individual records for each data integrity issue.
Automated Notifications
An additional assignment given to me was to build off of my first project. Fixing data integrity issues is a time consuming, and often impossible task. These issues were created by someone with administrator privileges, which is a short list of people. I was tasked with creating an automated procedure to email the creators of these issues. This process would put the responsibility of fixing the issue on the person who is most capable of doing so. The project used coded PL/SQL logic, including 8 functions within the procedure to pass data, making the procedure flexible enough to be used in future email notification projects.