CenterPoint Energy

The Project

During my first co-op opportunity with CenterPoint Energy I was given the freedom to work for different departments. This provided me with distinct challenges all with their own unique solutions. I also had the privilege of meeting and working with exceptional people who helped me achieve my goals and from whom I learned a lot from. Below are images from a PowerPoint slide showing the work I did for CenterPoint Energy.

The Results

Under the Pole Attachments Department, I was tasked with finding a solution that would facilitate the storage of information and allowed the personnel to easily search and modify this data. To complete the project, I created the back-end and the front-end using VBA (Visual Basic for Applications) and SQL to request data from the database. This allowed me to provide an easy to use interface and a flexible program that allowed the personnel to quickly find the requested information. The program also included the ability to automatically generate emails further facilitating the ease of use for the personnel.

The second project under the Reliability Consulting Department required that a single report be generated at the start of every month from a collection of sub-reports. To accomplish this, I again used SQL and VBA to pull the necessary information from the collection of multiple reports. All the information would then be stored in a single report with appropriate formatting and highlights to make it easy to read and printable.

The final project under the Asset Management Department had me generate survival curves for different assets that the company owned. For this I implemented the Weibull formulas to help me predict the life expectancy of these various assets. I then used Microsoft Excel to generate the shape of the curve which allowed for easier visualization.