Managing office, database management and data analysis

*

Martin (Zhan You) Li

***********@*****.*** 434-***-**** https://www.linkedin.com/in/just4martin Profile Summary

Experienced database management and analytics professional with a demonstrated history of working in diverse industries. Skilled in Data Management & Analytics, Donor Development and Relationship, and interpersonal communication. Bilingual: English and Chinese.

Related Work Experience

Donor Portfolios Manager & Digital Assets Database Management Administrator May 2014-July 2018 Christian Aid Mission, Charlottesville, VA

• Managed and collated the Central Donor Database by using Enterprise Studio as the platform to execute collecting, combining and integrating donor data from various related donor databases. This significantly improved the process of utilizing data companywide (Donor Direct Database, SQL).

• Implemented and maintained Customer Relationship Management (CRM) application to support donor account managers, the marketing team, and financial office for Ad Hoc data needs and analysis needs (CRM, Excel).

• Designed Donor Portfolio Management System by searching the fit metrics and writing criteria to screen, rate, and qualify new potential partners to be assigned to Major Gift Officers and other level account managers for engagement. This solved the overlay follow-up problems by reducing the time from 7 days to 2 days (Excel, Database).

• Improved donor development officers’ and regional directors’ work efficiency with a system to evaluate then group donors into different levels with evaluation criteria and metrics in terms of giving capability indicators

(Excel, VBA).

• Managed and maintained Central Donor Database to ensure data quality and daily data updating (SQL, Excel VBA).

• Supported leadership with ad hoc analytics reports upon request by querying against relational database and visualization applications (SQL, Excel, and Tableau).

• Managed & maintained digital multimedia assets database management system by developing new features. This resulted in over 20 formats of documents, such as text, image, audio, video clips and recordings to realize the compatibility in the system. Improved maintenance to improve system in performance, integrity, security, and reliability (Cumulus).

• Created reports and delivered presentations to support the data function for development & marketing teams

(Excel, Tableau, and PowerPoint).

Office Manager, International Ministry Pastor June 2007-May 2014 Covenant Church of God, Charlottesville, VA

• Managed and maintained donor database for ministry needs (Access and Excel).

• Developed and organized ministry educational programs for ethnic group pastors/ leaders in diverse immigrant communities. This resulted in the establishment of the international ministry. Communities include Chinese, Asian Indians, Burmese, Iraqis, Nepalese, Filipinos, Hispanic and Africans (Team-Building, Communication, Publisher, Power Point).

• Partnered with Hope Community Center to establish language and thriving skill classes for immigrants (Power Point).

2

Visiting Professor January 2005-June 2007

Lee University, Cleveland, TN

• Created student database as aid to teachers. (Access, Excel). Consulted with students who plan to go overseas

(Database, Teaching).

Visiting Scholar January 2001-September 2001

Fort Hays State University, Hays, KS

• Lectured on Chinese Education and diverse Chinese Cultures to faculty and students (Teaching).

• Initiated cooperation programs and accelerated academic exchanges between two universities, which resulted in the establishment of a Sino-US joint venture university in China. Assistant Provost and Director of International Affairs Office July 2000-January 2005 SIAS International University, XinZheng, China

• Developed and managed database and conducted analysis for recruiting overseas students traveling to China for seasonal exchange studies and summer camp activities and studies (Access, Excel).

• Recruited more than 80 overseas educators annually and performed faculty contract management by using the database I developed (Communication and Management). Publication

“Market Analysis: Vitamin C Series Products – Supply and Demand in China Health &Food Industry.” Henan Science and Technology Review, Vol.11 (1999), pp. 19-21.

Education and Certification

Analysis in Excel Certification 2016

Duke University

Business Analytics Certification 2015

University of Virginia

Ordained Minister Certification 2010

Church of God International Offices, Cleveland, TN M.A. World Religions Studies 2006

Lee University, Cleveland, Tennessee

M.A. English Linguistics and Literature 2000

Beijing Foreign Studies University, Beijing, China IBS (International Business Strategist) Certification 1998 The Ministry of Foreign Economic and Trade of the P.R.C. B.A. English Language and Cultures Studies, minor in Applied Computer Science 1988 Henan Institute of Education, Zhengzhou, China

Skills

• Data Analysis and Visualization: Excel, Tableau

• Programming Language: VBA in Excel, SQL

• Database: SQL Server, Access, Cumulus, Wealth Engine, Donor Direct, CRM, Raiser’s Edge

• Business Office: PowerPoint, Word, SharePoint, Outlook, Publisher

• Language proficiency: English and Chinese Mandarin

Contact this candidate