1. Internal Finance Reconciliation Tool
In need of a new process to automate and manage their team finances efficiently, the Information Delivery Team presented me with the opportunity to document and design a more efficient process to replace the current one. I organized meetings with the team's Data Sourcing and Operations Manager to create an extensive Business Requirements Document for the new tool, which outlined all test cases, requirements, and implementation details. The tool will be automated using Microsoft SQL Server and used by the Information Delivery team upon completion.
2. SharePoint Collaboration Website
The Data Management Team was seeking a new SharePoint collaboration website, as their current website was outdated, unorganized, and not user-friendly. I utilized Microsoft’s .NET Framework, HTML, CSS, Microsoft Visio, and SharePoint Designer to fully redesign, rebuild, and ultimately optimize the SharePoint website. In the process, I worked with another intern to organize and lead meetings with 15+ Vice Presidents of the Data Management team to document their website requirements and present updates. Currently, my site serves as the team's official website and is used for all communications, document storage, team info, key resources, etc.
3. Flood Insurance QA Project
Throughout the internship, I had the opportunity to modify tables/views and write queries for the Flood QA Project using Microsoft SQL Server Management Studio. Additionally, I performed Business-As-Usual changes for the Information Delivery Team, which involved creating tables in SQL.
4. Read Charlotte Web Development Volunteer
In my spare time, I took the initiative to learn more about the city's non-profit "Read Charlotte" organization, a program dedicated to improving the reading level of 3rd grade students in Mecklenburg County. I attended meetings with the leaders of the organization and helped edit their website as they worked to rebrand the organization.
1. Sourcefire Signature Fidelity Project
Identified and implemented a metrics-driven process to be run by Cisco quarterly or more to determine the fidelity of the Sourcefire signature. The process of measuring the accuracy of Sourcefire signatures is the foundation for strengthening Cisco's threat detection software. Cisco continues to use my project to improve its Intrusion Detection Software and Sourcefire signature rules.
Technical Skills Used: Linux, Shell Scripting (Bash), Sourcefire Software, Request Tracker Software
I presented the final project to the heads of the Security Operations Center.
2. VERIS Cyber Metrics Data Anlysis Project
Determined the VERIS (Vocabulary for Event Recording and Incident Sharing) metrics data for all security threats to the customer networks that occurred from June 2014 - June 2015. This involved measuring the asset, threat, and impact landscapes of nearly 1700 total incidents by performing incident tracking and statistical analysis of all threat actors, actions, varieties, vectors, exploits, CVEs, assets, attributes, etc.
Technical Skills Used: SQL, Request Tracker Software, Microsoft Excel, Tableau
Substantially furthered my knowledge and understanding of malware, hacking, and social attacks, as well as hot malware threats such as Angler exploit kits carrying CryptoWall ransomware.
Generated a professional cyber metrics report for the 2014-2015 year detailing all VERIS information, supplemented by charts, graphs, and statistics.
3. Adobe Flash Research and Data Analysis Project
Given the frequent Adobe Flash exploits that occurred at the beginning of the year, I researched all previous versions of Adobe Flash, dating back to 2010, to analyze the exploit trend over time. My main objective was to measure the length of time between the release of a new Adobe Flash update and the release of a new exploit kit targeting the patched Flash vulnerabilities.
I analyzed the data by collecting VERIS metrics for all Flash exploits, including recent zero-day attacks, and used the data to form meaningful conclusions.
As the only Indiana student selected to attend Chicago's “Girls Do Hack” event, I gained hands-on experience by collaborating with other students and working with mentors in STEM careers. Sponsored by Teza Technologies and partnering organizations, activities reflected a cross-section of STEM careers and included mobile app development, electrical engineering, prototyping and designing buildings, game design, and 3D printing. I was selected to return in 2014 to lead the mobile app development workshop, and again in 2015 as a volunteer and mentor. New activities added range from robot obstacle courses to making chocolate to conducting biotech experiments.
Victus ARS, Inc. is a team-approach food consultancy focusing on confectionery-related products. A high performance team of confectionery scientists provides prototype development and samples, application research, and technical training. Production efficiency, trouble-shooting, and setup expertise are also key capabilities.
I created a website for the company and organized an email service with the website domain using Office 365. My responsibilities included managing technical support and updating the website.