CenterPoint Energy

The Project

For my second co-op opportunity with CenterPoint Energy I worked remotely and under the Distribution Projects & Lighting Design department. I had the opportunity to work on new projects and I had the privilege once again to work with my former team members who were excited to have me back. Below are images from a PowerPoint slide showing the work I did for CenterPoint Energy.

The Results

The first project I worked on saw the team waiting hours for Excel to produce crucial data from a set of formulas entered. The total number of data points where so large and the formals too complex that it caused excel to run sluggish. I solved the issue by creating a program using VBA (Visual Basic for Applications) that would take the values in the Excel field and run its own calculation using the same formulas. The results where phenomenal, the program was able to compute these values within seconds satisfying all the personnel.

The requirements for the second project was to provide users with a program that would download multiple Excel files from the internet easily and seamlessly. To achieve this goal, I designed my app using an Excel macro as my web scraping tool. Once completed the users would enter the dates of the files they wish to download followed by pressing the enter button and the files would be stored immediately on their local machine.

For my final project I was tasked with developing a program that would store SAP information and allow the user to export the queried data to Excel and generate automatic emails. I design the application using VBA (Visual Basic for Applications) as my front-end and I used SQL as my database to store the SAP data the user uploaded. centerPoint/App navigation is quick and easy, and all user were able to perform the tasks they requested.