David J. Engel
University of Connecticut Storrs, CT
Bachelor of Science in Engineering Graduation: December 2017
Major: Computer Science and Engineering
Operations: Microsoft SQL Management Studio, IBM Cognos, Virtual Machines (Ubuntu and Windows), Eclipse, Git
Software Languages: Microsoft SQL, Visual Basic for Applications, Java, PHP, C, C#, Python, Linux, MIPS Assembly
Schmitt-Sussman Enterprises, Inc. Company, Orange, CT March 2019 – Present
Business Systems Analyst (Database Administrator)
●Updated ETL (extract, transform, load) tables for viewing through procedures for reports, production and testing data. These procedures ranged from creating test data in quality assurance environments to analysis reports for data processing.
●Managed day to day imports and fixed any incoming errors that may have occurred. With these imports, the corresponding companies were notified when their data needed to be corrected on their end so the errored data flowed smoothly in the future.
New London County Mutual Insurance Companies, Norwich, CT March 2018 – March 2019
●Created, managed and tested SQL procedures that corresponds with the Legacy system reports in a Guidewire system. These procedures ranged from claims, billing and policy center data.
●After the tables were made they were maintained and moved to views inside SQL. Those views were then published to Cognos and manipulated with filters to match the Finance department’s specifications.
East Lyme Oral Surgery, LLC, East Lyme, CT June 2009 – March 2018 Senior Laboratory Technician (Seasonal)
●Completed clerical tasks by organizing patient files to increase the efficiency and production of the office.
●Assembled intravenous sets and sterilized surgical instruments to ensure patient safety and improve patient flow.
Internal Drive Tech Camps, Middletown, CT June 2015 – August 2016
●Taught and supervised students how to use Java code. Students learned how to use Eclipse so they could create Java classes as mods or modifications to Minecraft.
●Oversaw each student’s project to allow modification classes within Java. Each project was a culmination of mods that made new blocks, sets of extreme armor, and super-hero potions.
Engineering Project Experience
New London County Mutual Insurance Companies, Norwich, CT
Year to Date Losses Report (R19) August 2018 – May 2018
The data was first pulled from Guidewire’s Claim Center then organized to correct categories depending on multiple columns. All the data was tested initially by another department for any incorrect values with additional testing being done as needed.
The report had a dozen columns approximately which included Losses Incurred, various expenses, outstanding reserves and other claim information. This was created from primarily Guidewire’s Claim Center database and each column was to match the legacy system’s version and calculations.
UConn School of Engineering, Storrs, CT
Senior Design Project for University of Technology Services of UConn Fall 2016 – Spring 2017
Earned third place 2017 Senior Design project for Computer Science and Engineering majors. The application analyzes data that came at approximately 500GB per day. Through a back-end escalation system, it takes specific actions depending on the indicators of compromise.
Extensive plans made with UITS for the setup and creation of a cyber-security project. Initialization included a dashboard that had notifications, a homepage, and a page with necessary data graphs in addition to a few more pages with data.