Joe Hanson Email & Phone Number

Dubuque, Iowa

• Administer company Power BI service environment• Develop and maintain company data warehouse environment. • Develop reports, dashboards, and datasets to bring insights to leaders and colleagues using Power BI• Develop web applications utilizing ASP.NET MVC as well as ETL applications for data warehousing. • Utilize T-SQL to create and maintain views, stored procedures, and jobs in SSMS • ETL data from various sources (Epicor ERP, Microsoft Dynamics CRM, Excel, Hyperion, web APIs etc) using SQL, SSIS, Power BI, and Python• Perform administrative tasks to maintain Microsoft SQL data warehouse environment (backups, replication, indexing, etc..)• Actively work with business leaders and colleagues to manage data request projects

Dubuque, Iowa Area

Dubuque, Iowa Area

• Actively work with business leaders and colleagues to analyze company needs to plan and develop effective IT solutions• Write T-SQL stored procedures, jobs, views, and queries in SSMS to accompany solutions• Administer company DMS and third-party applications across multiple servers and environments (VMware, Citrix,Microsoft Server, Ubuntu, IIS, Office 365, etc.)• Develop business intelligence and company reports using SQL, Crystal Reports, Excel, and data visualization software• Perform database administrative tasks in production Microsoft SQL Server environment (backups, table/DB/jobcreation, indexing, database migration, etc.)• Work with third-party vendors to coordinate new software implementations/upgrades and follow through with creating an execution plan

Dubuque, Iowa Area

• Lead project to develop truck inventory and audit system that was rolled out for 20+ locations• Deployed and configured HP layer 2/3 networking equipment to new dealerships and satellite locations• Provided remote end-user support for Citrix, Shoretel VoIP, network connectivity, hardware issues,Active Directory, Microsoft Office 365, OEM diagnostic software, etc.• Regularly updated and deployed production Citrix XenDesktop image• Repaired broken HP workstations and laptops (Hard drive, LCD, keyboard replacement etc.)• Worked with systems team to upgrade VMWare ESX hosts• Managed and provided support for company Sprint and Verizon mobile phones