Ted Schaefer Email & Phone Number

Ann Arbor MI

Ann Arbor, MI

• Manage and maintain custom Tableau dashboard reports for Michigan Medicine Development Senior Leadership Team (SLT)
• Educate and Train users on Tableau, Business Objects and other tools
• Coordinate dashboard scope and creation for internal Michigan Medicine Development Tableau Dashboards
• Manage access and maintenance to the Michigan Medicine Development Tableau Server for department of 140
• Provide analytical and technical consulting to a variety of end users, technical staff and external vendors; resolution of complex data or application problems.

Durand, MI

• Leverage fundraising, communication and technical skills to solicit businesses and constituents to construct the City of Durand Veteran’s Memorial Park

Durand, MI

• Met monthly to provide recommendations to the city council regarding the planning, development and maintenance of the city park system
• Reviewed the five year city-wide park plan (2013-2017), necessary to be eligible for state and federal park and recreation grant programs

Ann Arbor, MI

• Work closely with other University Development and Unit Development Staff to assist and support the comprehensive fund-raising programs of the University of Michigan with focus given to the Annual Giving Program.
• Assists in the development, coordination, and analysis of the marketing portion of the comprehensive fund-raising communication strategies and overall program diagnostics.
• Develop new, modify and run existing reports utilizing Business Objects, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, and Tableau
• Provide analytical and technical consulting to a variety of end users, technical staff and external vendors; resolution of complex data or application problems.
• Create and present Tableau dashboard report via server to OUD Annual Giving marketing effort performance.
• Evaluate complex requests to determine best method for data retrieval and integration in DART and external systems, if required

Ann Arbor, MI

• Closely monitor fundraising giving and update the Chief Development Officer of weekly progress from a custom Tableau dashboard report
• Create custom Tableau reports for the RSB Annual Fund team and other departments on current and prior fundraising performance
• Serve as lead RSB DART Unit Liaison on DART issues and manage security roles for the department of 20 users
• Serve as department Subject Matter Expert (SME) on DART development and financial reporting, Relationship Management System, Alumni EIS and business objects report and provide one-on-one training
• Actively participated on several DART teams (Annual Giving Design Team, Online Email Design, BBDW Report Development Team, Reporting Standards Task Force) in strategic assessment with Office of University Development.
• Selected by OUD to participate in the DART Direct Marketing (BBDM) pilot training with only three other SCUs