Kevin S

Coordination of project management, data scientists, AWS infrastructure, software design, data architecture, configuration management, data risk management, disaster recovery, IT asset management, business consulting, production support, and IT security across 60+ teams Data quality validation, data analysis, and migration of data to the AWS Cloud on Snowflake from on-prem data centers Designed an AWS web application that can provide daily monitoring and multi-level filtering of key performance metrics, customer survey data, dealer data, and instant messaging data Design of business analytical SQL queries for key performance metrics Designed a PostGreSQL database for storing data from the on-prem data centers and optimizing filtering operations for the AWS web application Coded scheduled batch jobs (Python) that extracted, transformed, and loaded production data into PostGreSQL databases for analysis and dashboards. Coded API (Java Spring Boot) and stored procedures (PostGreSQL) for retrieving multi-level quantitative and qualitative data for analysis, word clouds, and dashboards

Automation of building SQL scripts and loading data into databases Coordinates the scheduling and execution of database changes during production releases DevOps: Managed the configuration and synchronization of the development environment

Supervised students as they built power electronics circuits and took measurements Managed the inventory of power electronic components

Automation of tracking, code promotions, and updates to servers using C# in Visual Studio. Wrote software that speeds up the planning and management of Agile software engineering groups using Excel VBA Coded and fixed the forms for Small Business Portfolio Management using Excel VBA

Learned PERL and UNIX Applied software engineering to write scripts that support control systems operations Automated report generation of real-time fault data in the transmission system Scripts that automatically update or reconstruct modeling files Script that verifies data between departments Design of websites that display real-time power system data about the power grid's state

Coordinated efforts to update databases with additional data that can help improve the efficiency of IT maintenance, patching, and restoration. Standardized database requirements to coordinate an orderly restoration of database servers at data centers Helped develop IT models for Oracle DBAs

Tutored students in Circuit Theory and Linear Systems and Signals

Technical Cores: Communications, Signals, Networks and Systems Energy Systems and Renewable Energy Software Engineering