Hanyue Zhao's Email Addresses & Phone Numbers

- Focus on leveraging the vast data resources and advanced analytics solutions to identify business insights, trends and patterns to enhance business performance and mitigate risks. - Experienced in statistical/data-driven consulting, statistical model validation, model risk assessment (SAS & R) - Experienced in product/tool/application design and development by leveraging tech skills in database design, data visualization and...

- Focus on leveraging the vast data resources and advanced analytics solutions to identify business insights, trends and patterns to enhance business performance and mitigate risks. - Experienced in statistical/data-driven consulting, statistical model validation, model risk assessment (SAS & R) - Experienced in product/tool/application design and development by leveraging tech skills in database design, data visualization and object-oriented programming - Experienced in leading data analytic work-stream, managing client communication and expectation, and mentoring junior onshore / offshore resources on 24/7 work schedule - Passionate in Big Data Techniques and Data Visualization - Basic knowledge and hands-on experience in portfolio risk management; Chief Risk Officer of a $20,000 student-run portfolio - Capable of programming in Java and C++, self-studying PythonExperienced Associate - Data Analytics @ - Leverage data analytic techniques to identify potential risks, anomalies, frauds, errors in advisory and compliance engagements - Design innovative data solutions to handle massive and complex data sets, identify data issues, control data quality and perform targeted data analysis to provide business insights and drive business decisions - Provide data-driven consulting service and develop tool/application to enhance client's business performance, risk management and reporting * Statistical Analysis & Model Validation 1. Anti-money laundering (AML) Look Back - Transaction Monitoring Algorithm Design (Client: Financial Service) 2. Time-series SAS Model Validation (Client: Fortune 500 Insurance) 3. Loan Loss Emergence SAS Model Review & Re-performance (Client: Commercial Bank) 4. SAS Code Review - Critical Data Element Movement (Client: Mortgage) * Data Analytics: 1. Data Intensive Deals & Divestiture Analytics (Client: Silicon Valley Software Provider) 2. Healthcare Physician Incentive Award Assessment (Client: Healthcare Provider) 3. SQL Programming - Financial Service External Audit Support * Tool Development & Prototyping / Data Visualization Dashboard Development 1. Enterprise Risk Mgmt Tool Prototyping for NIST Security & Privacy Control (Client: Utilities) 2. MS Access Investment Accounting Reconciliation Tool Development (Client: Home Loan Mortgage) 3. Dashboard Design & DB Development for Resource Planning & Scheduling (Qlikview, MS Access, SQL) 4. Dashboard Design & DB Development for Corporate Intelligence (Qlikview, MS Access, SQL) 5. Dashboard Design for Fraud Investigation (Tableau, Qlikview) 6. Excel VBA Engagement Template Development & Value-added Function Design * Misc 1. Enterprise Content Management Assessment - EMC Documentum (Client: Utilities) 2. SAS99 Fraud Testing across industries & ERP (Oracle, SAP, Peoplesoft, JDE, Great Plains, Lawson, Elite, Quickbook) From July 2013 to Present (2 years 4 months) San Francisco, CA; McLean, VAData Assurance Intern @ From June 2012 to March 2013 (10 months) McLean, VAGrader of Multivariable calculus @ - Graded weekly homework and quiz for APMA 2102 Multivariable calculus - Wrote homework feedback to Professors and communicated with professors about student understanding and course process - Managed online grading system and the course website From August 2011 to May 2012 (10 months) Charlottesville, Virginia AreaCommercial Banking Intern - Channel Management @ - Used Excel to analyze the daily operation data such as foreign exchange transactions, operations of checking accounts - Monitored operation data of 134 sub-branches in Shanghai and provided feedback to directors; Involved in discussion and notified the decision to sub-branches - Participated in 3 projects with 12 professionals, directly communicated with HQ in Beijing, other departments and clients From June 2010 to July 2010 (2 months) Shanghai, ChinaUndergrad Teaching Assistant, Department of Statistics @ - Graded homework for Intro level Statistics course - Wrote weekly quiz feedback to Professor about common mistakes and students' learning progress - Compiled solutions, manage online grade book and proctor exams From January 2010 to May 2010 (5 months) Champaign, IllinoisB.A with distinction, Statistics, Economics, Computer Science @ University of Virginia From 2010 to 2013 Bachelor, Statistics, Recreation Sports and Tourism @ University of Illinois at Urbana-Champaign From 2009 to 2010 Kongjiang High School From 2006 to 2009 Hanyue Zhao is skilled in: SAS, R, Java, Access, Data Analysis, C++, Statistics, Stata, Data Visualization, VBA, Audit Command Language, Tableau, SQL, Teradata, Anti Money Laundering, M&A analysis, Databases, Microsoft Excel, Risk Management, Matlab, Minitab, QlikView, Quantitative Analytics, Teradata Studio (Aster)