Scott Vereen Email & Phone Number

Alabama, United States

Developed 25 custom financial and auditing databases linked to Power BI.Provided technical support for new software systems by creating database structures and tables based on government requirements.Enhanced users’ understanding of created systems by conducting pre-implementation workshops, delivering group and individual training sessions, and creating user-friendly training materials Perform detailed data analysis to assess and address data design.Conduct testing of systems, provide input for feasibility, and prepare user documentation and follow-up evaluations.Collect data and clean it to remove duplicates and fill gaps for a well-rounded and understandable set of data.Analyzed data from US Army financial active users and used outputs to guide financial officers to easy contact overview of spending and obligation needs.Cut projected time for data analysis by developing reusable data visualization.Created dashboards using Power BI and Tableau to display several distinctive areas of interest within departmental operations.

Rhode Island, United States

Creating a database for WAF project to pull in from several data sources BITS, CMDB and Plant account information. This database will pull in information from several sources and give an accurate inventory list and hardware location for clients.Improved data storage capacity from by optimizing the archival database structure.Developed custom financial and auditing reports using SAP Crystal Reports with T-SQL, JDE Report Design Aid, MS Excel, and Access.Enhanced users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions, and creating user-friendly training materials.Perform detailed data analysis to assess and address data design.Conduct testing of systems, provide input for feasibility, and prepare user documentation and follow-up evaluations.Develop reconciliations of Access DB results to the Strategic system resultsEngaged in end-to-end data collection processes using qualitative and quantitative methods for several projects.

Middletown

Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis.Develop and Administer SQL Server database (T-SQL, Stored Procedures, SSMS, SSIS)Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions.Worked on the BLQ10 project creating Microsoft Access databases for tracking parts and creating several queries for reports of parts within RDSI. Also created an MS Access database utilizing BITS, CMDB data for project replacement and installment including scheduling times, dates, and hardware. Worked on EWPRO project evaluating application with Network Security Government STIG’s. Also Utilized SonarQube for code validation and security checks.Improved data storage capacity from by optimizing the archival database structure.Perform daily monitoring of multiple databases to include Backup Execution/Monitoring and Performance Tuning for several databases. Design & development of new capabilities to include data structure design and capacity planning.Design & development applications with VBA/SQL/C# code in combination with cloud services such as AWS and Microsoft Azure.Application, testing, and documentation of database upgrades.Enhanced users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions, and creating user-friendly training materials.Independently perform moderately difficult assignments in the design, detailed configuration, integration, and support of existing and future technologies within the database development arenaProvided technical support for new software systems by creating database structures and tables based on government requirements.

Bachelor Of Technology - Btech, Computer Software Engineering

Associate'S Degree, Computer Software Engineering