Selected Projects within my experience

Applies dynamic colouring scheme for projects that are above or less than 30 days with or without PMO date data.

​

A fully automated data stream from Keyedin using m-code. 

Used m-code to API to Keyedin, collect data, and feed it to the listbox as shown below. The "Load Data" button would load selected row into the next available cell. 

Created recursion for login credentials to prevent code from running until Keyedin.com's authentication was correct.

​

Once credentials were validated, data transformations wrapped up in various function collected data using API requests, and converting to equivalent excel file

​

All exceptions were covered to report user of any said errors

Created star schema DB in Microsoft Access for storing data that was otherwise a limitation in Excel 

Created a dynamic, contiguous slicer using date table, and range find through use of calendar functions. Custom columns were created to categorise numeric data for number of days to PMO closure

Using For loop and .count method, we ascertained charts and copy pasted them to respective sliders within PPT at Bristan