Projects

Project Description:

I created Macro-Enabled Excel Template tools utilized by the Master Data team to perform monthly audits on the master data; analyizing PO pricing variances, MSA contract pricing discrepancies, and historical pricing records to perform high volume data updates/uploads, ensuring accurate master data and provide contractual compliance reports for review.

Throughout the brainstorming and development process, I collaborated with my Master Data teammates and Supervisor who would provide automation suggestions. They regularly tested and reviewed the macro-enabled templates providing valuable input.

I gained an understanding of their reports & audits including all of the steps & methods required to complete these processes. I gained an in-depth understanding of the data manipulation, date results, and data visualization goals.

Often, my supervisor challenged me to condense and enhance various process steps which ultimately improved the templates capabilities, versatility, improved data integrity and reduced the VBA code required.

Project Highlights:

In the Excel Templates, I created Macro-Enabled buttons utilizing numbering naming conventions, displaying the buttons step occurance number within the 12 step process.

I documented detailed instructions for the Macro-Enabled Excel Templates to enable all users, the ability to utilize the templates on their own.

I am proud of the final results. I could not have accomplished this without the collaboration efforts of my teammates and supervisor. The team continues to utilize and improve these templates today!

Project Description:

I completed a two week internship where I was hired by a medical service provider to collect, organize, and store their companies data into a few tables in Microsoft Access.

After I had completed the project I was hired on to continue to develop and maintain the database, which was utilized by all office staff members.

Through relational database organization & development I was able to accomplish the following:

Ensure data integrity.

Created over 50 digital automated forms, which the company no longer had to order and decreased the time required.

Provided on-demand SQL Queries which were utilized in various reporting, analyzing, tracking, and input forms.

Applied SQL queries to provide analytical reports-improving quality control.

Exported and submitted required data documentation to the state.

Project Reflection:

This course has taken me through many levels and has taught me so much. For the first time, I familiarized myself on how to utilize multiple local servers and the Discord platform. Next, I learned Html, then Php, then Css, followed by Jquery and Ajax, finishing with MySql and phpMyAdmin. Learning each of these platforms, languages, and extensions took a lot of research on my part because I had no prior experience with any them.

Phase 1 Project: In phase one of the project I oversaw the building of our database. I took this role very seriously because I know the importance of a database being built correctly from the beginning. Concurrently, my team began designing our front-end site visual.

Phase 2 Project: In phase two of the project I oversaw creating views and writing php validation code on the web pages. The views were simple enough but time-consuming.

Phase 3 Project: In phase three of the project I became needed on the user side of the project, creating the user profile page. To date this was my biggest challenge for it required a lot of php code, which had to merge properly with the other pages and classes.

Lessons:

I learned some valuable lessons from this course and project. First of all, it is hard to predict the time required to complete a programming assignment. This is crucial because one cannot submit a program until it functionally works.

Another lesson I gained is that your customer may not always have clearly defined requests. It can become your responsibility to help them through this process, in order to be able to create a product which they can benefit from.

Finally, never rely on another group members contribution to the point that if they falter the entire project falters. A group member of mine wanted to develop an alternative user profile page, which they believed would be more aesthetically appealing. This was the best decision because in the end their page was not ready, and we used my less aesthetically appealing but functional page.

Website Details:

The website link used to be included here for exploration purposes but unfortunately, IUPUI no longer hosts the website on a server.

Our website utilized multiple permission levels with credentials for SuperAdmin, Mid-Level Admin, Coordinator, and Basic User access.

Project Description:

I lead a group of three students as we hosted a garden event located in the IUPUI New York Street Garden along the canal. The mission of the event was to above all, to give the attendees a hands-on educational experience, igniting their excitement to garden.

To increase interest in the event, we delivered a special program. With the support of my group, I taught the attendees how to take a cutting from a bush and properly replant the cutting into a soil cup which they were allowed to take home as a souvenir.

This event required our coordination with Vincent Razo, the Urban Gardens Manager of the Developing IUPUI Gardens Sustainably (DIGS) program.

Project Results:

The event was a success! Resulting in 12 attendees volunteering for three hours, planting 436 plants. The development of the non-utilized land increased the area of the garden by 480 square feet.