* Submit required California State MIS Reports each term and annually by their deadlines. * Efficiently operate Colleague Software including the Cal-Gold reporting module as well as the underlying SQL database. * Work with departments to ensure their data is coded accurately along COMIS specifications. * Provide programmatic support for database administration tasks including implementing the provided Data on Demand reporting database. * Support the college with any other… Show more * Submit required California State MIS Reports each term and annually by their deadlines. * Efficiently operate Colleague Software including the Cal-Gold reporting module as well as the underlying SQL database. * Work with departments to ensure their data is coded accurately along COMIS specifications. * Provide programmatic support for database administration tasks including implementing the provided Data on Demand reporting database. * Support the college with any other reporting needs usually involving custom queries and reporting tools such as SAP Buisness Objects. Show less

Support system test engineers with various internal software solutions. These could fall under small application and micro service development, software testing/packaging/deployment strategies, technical and use case documentation, database administration, cloud administration, network security, and even pipeline implementation. Meeting with system test teams to determine workflow improvements offered by provided enterprise services and infrastructure, many times even assessing new tools that… Show more Support system test engineers with various internal software solutions. These could fall under small application and micro service development, software testing/packaging/deployment strategies, technical and use case documentation, database administration, cloud administration, network security, and even pipeline implementation. Meeting with system test teams to determine workflow improvements offered by provided enterprise services and infrastructure, many times even assessing new tools that teams found helpful. Sprint Planning and retrospect meetings were done on a monthly basis.Personally owned/maintained applications.• Results Data API was a Node.js/Express.js application deployed using Dokku. It allowed our test engineers to upload structured, unstructured, and historical data to their proper endpoints(MySQL DB/S3/ELK) over REST. Using REST provided a portable interface so that test data could be processed from any environment(Jenkins/Python Scripts/Custom Team Frameworks, etc...). • Dygraphs application used for displaying large data sets from longer tests in the browser written in Node.js. Utilized LTTB downsampling in order to process upwards of 18 million data points down to ~4 million while maintaining useful results and rendering in a timely manner. This application was developed in response to Excel not being able to process these data sets. Dygraphs was used for its ability to display an unlimited amount of series since the data was recorded from upwards of 200 devices at a time. This was a very specific case and most other historical data was visualized efficiently using ELK. Show less

Group project to implement a honey-net that emulates a SCADA network. Collect and visualize any attack surface data for future security improvements.Tools used were VMWARE to host the services, Conpot to emulate a SCADA system, and apache/mongodb/google visualizations serve the data visualizations.

Individual project to implement iOS application(XCode/Obj-C) that can accurately display annotations on image and map views in an offline environment. • Create plans using annotations from google earth for a given location. Export the underlying KML. • Build/Store Static Mapbox maps, satellite images of target location, and KML plans on the device. • Parse Google Earth KML in iOS to get lat/long locations of Annotations(Targets/Civilians/Resources/etc...) from plans.•… Show more Individual project to implement iOS application(XCode/Obj-C) that can accurately display annotations on image and map views in an offline environment. • Create plans using annotations from google earth for a given location. Export the underlying KML. • Build/Store Static Mapbox maps, satellite images of target location, and KML plans on the device. • Parse Google Earth KML in iOS to get lat/long locations of Annotations(Targets/Civilians/Resources/etc...) from plans.• Convert Google Earth Coordinates to Pixel and other respective coordinate systems for accurate placement in other map views(NTIF Images, Mapbox iOS maps and GeoPDF's specifically).Challenges here were storing enough map data locally on the device to provide detailed maps in the field. Parsing KML in iOS. Converting between pixel and multiple geographical coordinate systems depending on the mapping tool. Having only a small amount of iOS experience. Show less