Michael Hessel Email and Phone Number

• Use SSMS and excel to create one-time reports to help the firm understand their business, help with client requirements, and maintain firm standards• Use SSMS to Build, Maintain, and Update views, functions, stored procedures, and tables for use in both reporting and for use in the company’s Case Management System• Use SSMS to create Jobs for various needs from updating records over night to restoring test databases• Build, Maintain, and Update Reports using SSRS and Visual Studio• Build, Maintain, and Update in-house reporting within Case Management System• Use SSRS to schedule reports both internally to help end user’s daily task and externally to update third-party entities and/or Clients• Assist in creating Merge Documents that create Legal Documents/Forms• Perform simple one-off updates to complex mass updates in the database when needed• Create or Alter table structures within the database to handle changes in the Case Management System• Use execution plan in SSMS to help optimize queries and create indexes where needed• Handled Data migration from a MySql Database to the firm’s MS SQL Server Database with the help of SSMA• Maintain/Develop in house Case Management Web Application in C# MVC with Angular and in VB.net Webforms • Maintain/Develop in house Applications using C# and VB.net• Maintain/Develop Web Services in VB.net• Set up Several tasks using C# Console Applications for automation • Back up IT coworkers in any IT needs that fall out of normal Software Development when the need arises

• Residential SQL guy• Web Development using ASP.Net• Utilize TFS for managing code• Complete projects developing code for both Web and WinForms• Maintaining and creating in-house Applications for Clients• Suggest and Implement Indexing in SQL Server• Manage Application Tuning in SQL Server• Troubleshoot Performance Issues in SQL Server• Create and Manage SQL Server Databases for Clients• Create and Manage Stored Procedures for Applications

• Transferred as well as optimize reports from Cognos Reporting to SQL Server Views for future reporting service• Created new reports • Worked with their Data Warehouse

• Maintain Applications in Visual Basic• Manage in-house web applications• Build, Maintain, and Update Reports using SSRS and Visual Studio• Assist in SQL Server Database Management• Manage inventory on Access Database• Responsible for Helpdesk needs

• Manage all store operations, opening and closing procedures• Supervises crews of 10-15 employees• Handles Money: $100-$750 daily receipts• Handles morning bank deposits• Works with Customers and Sales