• Responsible for Backups, Restores, and Disaster Recovery Strategies.• Responsible for Performance Tuning which includes Index Management, Statistics Management, Analyzing Query Execution Plans and more.• Responsible for the monitoring of the Database Instances and remediation of incidents reported by the monitoring processes.• Write performant T-SQL Queries, Stored Procedures, User Defined Functions, Views and other database objects.• Troubleshoot problematic Blocking and Deadlocking events.• Install, Configure, and Deploy SQL Server for application use.• Perform Operating System and SQL Server Patching on Database Instances.• Leverage PowerShell, Rest APIs, and SSIS for dataset acquisition process.• Develop SSIS Packages for data profiling, data cleanup, and data movement processes, leveraging both ETL and ELT ideologies.• Develop KPIs, Measures, and Data Collection Processes for Reports and Dashboards within Power BI for various business units.• Responsible for successfully engineering desktop application utilizing a VBA user interface with SQL to produce dynamic reports.• Lead ERP process integrator and corporate trainer.• CRM process integrator and corporate trainer. • Design, build and test SSRS reports and dashboards to address business needs within ERP and CRM.• Leverage SSRS Master / Sub Reports feature to build drill through capabilities in reports.• Create Dynamic reports with collapsible groupings, subtotals, custom calculated fields and dynamic formatting.

• Developed an application whereby the User Interface was built using MS Access and VBA code and the Database was modeled and implemented on SQL Server resulting in a $45K annual savings for the Chairman of the Board.• Developed MS Access Database leveraging a SQL Server Database and VBA to manage complicated process executions and switchboard.• Developed the SQL Server Database modeled in a 3rd Normal Form geared towards an OLTP workload to include appropriate indexes and referential integrity.• Responsible for supplementary IT support to include New Machine Deployments, New Employee Onboarding, Active Directory administration and some networking aspects to include DNS and DHCP administration.• Implemented machine Imaging software providing the organization with a 185% time to deployment increase.

• Development of an MS Access application to help track financial information in a more efficient way providing a time saving of 20%• Lead Corporate Payroll process training for 30 branch offices with responsibilities of developing training content, workshop materials, and deliver the content to ensure users understand how to leverage the technology.• Liaison between cross-functional departments and payroll functions.