Trevor Downs Email & Phone Number

Ann Arbor, Mi

Responsible for mining and analyzing data from 20 franchise systems (over 4000 stores) to provide detailed reporting solutions and dashboards used in decision making throughout marketing, franchise development, operations, IT, and executive departments. My current primary initiatives include:- Manage internal BI Portal for Neighborly and two franchisee-facing portals- Develop SQL stored procedures to be used in reporting solutions- Design and deploy SSRS and Power BI dashboards for effective analysis- Develop integration solutions to migrate and cleanse data from disparate databases and POS systems into a new centralized data warehouse- Work with third-party vendors to develop APIs, stored procedures, and SSIS packages for franchisee-facing services such as back marketing and customer retention- Collaborate with operations departments to develop weekly budgeting tools used to measure and rank the performance of their team members- Manage the day to day tasks and overall direction of the Business Intelligence team- Utilize SSRS, SSIS, and SSMS to develop and push hundreds of individualized reports to franchise locations and internal executive team every weekPreviously, I had been responsible for the rollout of a Microsoft CRM Dynamics system for our Mr. Handyman brand which has included the design and execution of a new training program along with a transition process from our legacy platform.

Ann Arbor, Mi

Initially managed the progress and development of the proprietary software for 1-800-DryClean brand before switching to the Mr. Handyman brand. Duties included providing level 3 technical support to franchisees, maintaining relationship with third-party software vendor, tracking software bugs and issues, presenting proprietary software to prospective franchise candidates, training new franchisees, and writing T-SQL queries and stored procedures to generate reports through SQL Server Reporting Services.

Ann Arbor, Mi

Provided technical support for the Mr. Handyman and Molly Maid franchise systems (over 300 locations). Presented proprietary software systems to prospective franchise candidates. Trained new franchisees to use proprietary software. Wrote T-SQL queries to create reports for internal staff. Provided dedicated support for home office staff.

Bowling Green, Oh

Contract position at Sky Financial Datacenter. Responsibilities included monitoring the status of over 300 branch locations & automatic teller machines, assigning tickets to the proper parties when issues arose, and mitigating issues to higher levels of support when needed. Additionally, this position was responsible for monitoring daily database backups, changing & cataloging backup tapes for databases & phone logs, and retrieving backups when data was ordered from a team member.

Monroe, Mi

Performed a wide variety of customer service duties for campground guests, including booking reservations, processing check-ins, stock management in on-site store, and served as acting manager for store staff. Additionally served as on-site technical support for store and office staff, graphic designer for campground guide given to guests (redesigned annually) , and administrator for campground website and staff email.