Claire Hong Zhu, PMP
**** ******* **, *** ****, CA 95131
Phone: 202-***-**** Email: ***********@*****.***
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