Claire Hong Zhu, PMP

**** ******* **, *** ****, CA 95131

Phone: 202-***-**** Email: acgm2c@r.postjobfree.com

SUMMARY of QUALIFICATIONS

SKILLS and CERTIFICATIONS

WORK EXPERIENCE

. Bilingual (English and Chinese) Business Data Analyst with 5 years of

experience in both government contracts and education industry. Performs

business trend analysis, risk analysis and develop business strategies

by using advanced data analysis tools such as SAS, SQL and VBA.

. 5 years working experience using SAS with SAS Base Certificate

. 3 years working experience with SQL and VBA

. Office, high-level Excel (pivot tables, lookups, macros, keyboard

shortcuts, data automation)

. Project Management Professional Certificate and Competent

Communicational Leader Certificate

. Experience with MS Project, Sharepoint, Geographic Information System

(GIS), Bloomberg Terminal, LexisNexis

. Language skills: Mandarin and English

Sales Analyst, Learning Tree International

Reston VA,October 2013 - Present

. Created three automated sales performance dashboards which consolidate

22 reports by using VBA and SQL to monitor daily sales activities and to

track key performance indicators. The automation saves more than ten

hours of Sales Managers' time on a weekly basis

. Conducted in-depth analysis and evaluation of key business operational

issues using Excel Pivot tables and SQL, and made recommendations for

cooperate business decisions

. Partnered with cross-functional stakeholders and executives to

frequently communicate and verify requirements, scope and status of

business projects and escalated issues as appropriate

. Proformed revenue assessments, analyzed findings and communicated

results to senior management team using SQL

Junior Project Manager/ Business and Data Analyst, Kratos Defense and

Security Solutions Inc.

Arlington VA, June 2009 - September 2013

Assisted project manager with managing 10+ projects and 30+ personnel under

a multi-year Navy Service Contract through the full project life cycle.

. Utilized multiple programming languages and software tools (such as SAS

SQL and MS Office) to develop and automate recurring business reports

for the purpose of supporting project management

. Identified operational risks, recommended business resolutions and

worked in collaboration with internal offices to implement resolutions

. Acted as a liaison between the cooperate departments and subcontractors,

assisting with a range of operating issues

. Verified project deliverables and financial data, confirmed with key

contract stakeholders and perform project contract

closeout

Worked on projects with the U.S Department of Labor (DOL),

U.S Department of Education

. Developed and executed quantitative analysis, measured

performance, and provided actionable recommendations that

improve cost efficiency and retention for federal agencies

. Researched, summarized and analyzed programs outcome and

impact using SAS and SPSS

. Summarized and presented reports to key stakeholders at

national conferences, helping key stakeholders identify

best practices

Research Assistant, Johns Hopkins University

Baltimore MD, June 2008 - August 2008

. Summarized literature review pertaining to public welfare,

and drafted literature review for research papers

. Conducted sample selection, analyzed sample statistics and

performed research data analysis with SAS

Consultant, Roland Berger Strategic Consultants

Shanghai China, August 2008 - September 2008

Researched market entry strategies in the Cold chain

transportation industry

. Analyzed the market value chain to evaluate customer

trends, potential market threats, major competitors and

legislative reform, helping the client to understand

market entry barriers

. Designed financial report of clients cost estimate and

future market projections associated with three growth

scenarios

Summer Consultant, Mayor's Office of Employment

Development

Baltimore MD, June 2008 - August 2008

. Performed an independent program evaluation of existing

policy initiatives; wrote an extensive report prioritizing

favorable program for senior management decisions

. Analyzed program financial trend for internal briefing

. Wrote a data analysis manual on Excel functions for

manipulating large workforce data sets using MS Excel VBA

models for the data group, which saved half of the time

for data manipulation

VOLUNTEER Volunteer of Habitat for Humanities, City Food Homeless cooking

Service, Chairmen

ACTIVITIES of Asian Women Association facilitating female career

forums

EDUCATION

AWARDS

Master of Arts - Public Policy, Johns Hopkins University, Baltimore, MD,

USA. Graduated: May 2009

Bachelor of Arts - Sociology and Economics, Fudan University, Shanghai,

P.R China, Graduated: July 2007

Johns Hopkins Scholarship Tuition Waiver 2007-2009, Excellent Student

Scholarship 2003-2007, Independent Research Scholars

Contact this candidate