Managed pre-assessment system for several of CAI's top clients, including requirements management, specification development, deployment scheduling, data analysis, QA, and operational support. Identified, corrected, and developed preventative solutions to operational issues throughout assessment windows.-Managed configuration of complex specifications and their deployment to production environments in support of millions of annual high-stakes online assessments across Texas, Indiana… Show more Managed pre-assessment system for several of CAI's top clients, including requirements management, specification development, deployment scheduling, data analysis, QA, and operational support. Identified, corrected, and developed preventative solutions to operational issues throughout assessment windows.-Managed configuration of complex specifications and their deployment to production environments in support of millions of annual high-stakes online assessments across Texas, Indiana, Arkansas, and Nebraska-Completed dozens of successful operational software and/or configuration deployments and provided or coordinated ongoing operational support.-Wrote hundreds of SQL scripts to extract operational data for reporting, measure system performance, aid in configuration management, or support analysis of code/data issues or new feature development-Principal contributor to new feature design of Forms module, including writing detailed requirements, designing database schemas, and managing development, testing, and implementation.-Wrote internal technical documentation of multiple features and processes, including database diagrams-Initiated and contributed to multiple internal process improvement projects, including specifications management Show less

-Manage updates to SQL Server 2014 databases using batch files and SSIS packages-Write T-SQL scripts, functions, and stored procedures that perform routine data loads and updates-Develop quality assurance reports to ensure data accuracy and integrity-Debug SQL errors and investigate gaps in business logic-Document technical details of key tables and business logic-Designed and coded ETL process that tracks changes across loads for ease of historical audit and reporting

-Evaluated the information security programs for federal agencies according to FISMA, FISCAM, and NIST-Analyzed client documentation to determine compliance and test for operating effectiveness-Articulated analysis, audit findings, and recommendations to client management in written reports

(Information Systems Capstone Course)-Created the conceptual, logical, and physical data models of a relational database for a board game café-Developed administrative web application for an inventory-management system-Developed customer-facing website with advanced search functionality and the ability to read/write reviews-Programmed front- and back-end of both websites utilizing HTML5, CSS3, JQuery, PHP, and MySQL

-Wrote complex SQL queries based on client specifications for quality control checks on custom data feeds-Documented ETL code in automated process to prepare for migration of system from Expressor to Pentaho-Identified inefficiencies in existing ETL process and revised plan for new system accordingly-Improved relations with Client Services by documenting business processes and creating workflow diagrams that accessibly communicate technical requirements and procedures to… Show more -Wrote complex SQL queries based on client specifications for quality control checks on custom data feeds-Documented ETL code in automated process to prepare for migration of system from Expressor to Pentaho-Identified inefficiencies in existing ETL process and revised plan for new system accordingly-Improved relations with Client Services by documenting business processes and creating workflow diagrams that accessibly communicate technical requirements and procedures to less-technical employees Show less

-Enabled small defense and aerospace contracting company to more efficiently handle the multitude of opportunities in the government sector, better directing their business development-Redesigned company’s bid/no-bid decision matrix used for evaluating proposal opportunities-Conducted focus groups with employees to ensure new matrix compatibility-Worked with team to develop coarse-fine dual matrix approach that weeds out weak opportunities early and evaluates remaining opportunities… Show more -Enabled small defense and aerospace contracting company to more efficiently handle the multitude of opportunities in the government sector, better directing their business development-Redesigned company’s bid/no-bid decision matrix used for evaluating proposal opportunities-Conducted focus groups with employees to ensure new matrix compatibility-Worked with team to develop coarse-fine dual matrix approach that weeds out weak opportunities early and evaluates remaining opportunities by strength through metrics-Streamlined proposal development process with phase-gates, allowing for better prioritization Show less