SAMUEL CHENG

**** ***** ****** ****** *******, WA 98118 206-***-**** acvwpo@r.postjobfree.com

SKILLS

Microsoft Excel/Access/Word/PowerPoint, SQL Server 2000-2008, SSIS, SSMS, T-SQL, Microsoft Power BI, DOS, HTML, VBScript, Tableau, GoogleAnalytics, DAX

EMPLOYMENT

Account Analyst 2015 2016

Quotewizard.com LLC, Seattle, WA

Created and maintained data dashboards using Power BI, Excel, SQL, and Tableau

Created and streamlined daily/weekly/monthly team reports using T-SQL and Excel

Automated report generation using batch scripts, SQL, Task Scheduler, and Excel

Provided ad hoc reports using SQL, Excel (including pivot tables), and Access

Database Manager 2005 2015

Seattle’s Union Gospel Mission, Seattle, WA

Managed offline donor database of 300,000+ records and online donor database of 15,ooo+ records

Created and maintained data segmentations for mailing campaigns

Created and maintained internal Microsoft Access databases for major donor tracking, acquisitions, call campaigns, and ad-hoc maintenance

Created agency reports, data integrity alert system, and volunteer-scheduling dashboards using SQL, ASP, VBScript, Access, and bundled reporting software

Managed and updated website using HTML, VBScript, and proprietary CM tools

Implemented task automation using AutoIt, DOS batch scripts, T-SQL, and Windows Script Host

Helped manage major database migration project (from MPX to DonorDirect)

Maintained data integrity and accuracy using SQL, SSIS, and Satori NCOA tools.

Performed SQL database backup and recovery tasks

Provided upgrade and technical support to end users as needed

VOLUNTEER

Inner-City Outreach 1996 2010

Parkway Apartments, Seattle, WA

Provided bi-weekly homework tutoring to at-risk neighborhood youth (grades K-12)

Provided recreational and educational activities to at-risk neighborhood youth

Provided applications assistance and advocacy to neighborhood ESL adults

Provided transportation to social functions, job searches, appointments, etc.

Administered emergency assistance fund to needy neighborhood families

EDUCATION

Certificate – Computer Information Systems

North Seattle College, Seattle, WA

Bachelor of Arts – Social Work

University of Washington, Seattle, WA

INTERESTS

Piano, basketball, cycling, fishing, traveling, camping, hiking, reading, international affairs

Contact this candidate