Arno (Chaoya) Zhang https://www.linkedin.com/in/chaoyazhang
Hartford, CT 06105 • 213-***-**** • ****.******@*****.***
Business Analytics • Information Management • Project Management
Data analyst with great experience in business analysis, strong background in information management. Proficient in software including: Excel, SQL, SAS, Tableau, JMP and VBA. With the combination of skills in data analysis and knowledge of project management, can offer practical analysis or solutions that take both relative data and real world situation into consideration.
EDUCATION:
University of Connecticut School of Business Hartford, CT
Master of Business Analytics and Project Management Dec 2015
Courses: Data mining, Data Visualization, Predictive Modeling, Risk and Cost Management, etc.
Henan University of Science and Technology Luoyang, China
Bachelor of Science in Computer Engineering June 2014
Third-grade Scholarship for outstanding students 2012-2013
EXPERIENCE:
Bank of America East Hartford, CT
Contractor Data Analyst April 2016-Aug 2016
Review, validate and analyze forms and data sets for FATCA, a tax remediation project set forth by IRS
Execute data collection, data cleaning and verification with Excel, SharePoint and VBA
Improved the efficiency and simplified the process by formulated the process of data management within Excel, which automated the process and improved the accuracy by 80%
Hong Yuan Securities Co., Ltd. Beijing, China
R&D Dep. Analyst Assistant Summer 2013
Developed and analyzed daily and weekly report of price fluctuation of row material, drafted data visualization and presentation materials
Initiated recommendations to company based on the analysis of market conditions
ACADEMIC PROJECTS:
SAS Challenge Project Jan 2016-Apr 2016
Used past, current and projected data to explain, predict and plan for predicted changes associated with population shifts over the next 45 years
Focused on disease diagnoses, labor force, and tax and social security revenues. Projected figures and suggestions for the future with Tableau
Priceline: Optimizing Email Promotions Aug 2015-Dec 2015
Analyzed Priceline and its competitors’ email campaign systems, provided contrast reports
Identified potential customers and developed user segmentations by modeling and data visualization
Refocused the targeted advertising system, improve the click-through rate by 20%
Generation UCAN: Marketing Research Jan 2015-May 2015
Administered products’ position and promotion based on market research and sales data analysis
Redesigned data collection system through Excel VBA, simplified 40% of the process
Skills:
Expert in VBA, SQL and Tableau, advanced user in SAS, and JMP
Expert in Excel, good at MS Visio, PowerPoint, Project, SharePoint etc.
Knowledge of R and python