Jeffrey(Haiyang) Qiao

Technical Business Analyst II at dv01

Jeffrey (Haiyang) Qiao has a diverse work experience spanning various roles and industries. Jeffrey(Haiyang) has recently worked as a Technical Business Analyst at dv01 since 2022. Prior to that, they were a Principal Associate at Capital One, where they played a key role in revamping financial reporting dashboards, developing centralized reporting, and evaluating business intelligence tools.

Before joining Capital One, Jeffrey worked at Fannie Mae as a Financial Planning and Analysis Senior Associate, Business Intelligence Senior Associate, and Business Analyst. During their time at Fannie Mae, they provided monthly reporting and analysis to senior executives, automated reporting deliverables, closed budget gaps, developed financial planning processes and dashboards, and standardized approval processes.

Jeffrey's earlier experience includes roles as an IT Consultant at FDM Group, Financial Consultant at Merrill Lynch, Consultant Intern at EY, Marketing Consulting Intern at Envirofit International, and Project Student at TSC STORES LP. These roles allowed him to gain expertise in areas such as business analysis, IT service management, financial consulting, and market research.

Overall, Jeffrey's work experience showcases their skills in data analysis, automation, financial planning, business intelligence, and market research across different industries. Jeffrey(Haiyang) has demonstrated strong technical abilities in tools like Tableau, Power BI, SQL, and Excel, and has consistently delivered value by improving reporting efficiency, accuracy, and decision-making processes.

Jeffrey (Haiyang) Qiao has a strong educational background, with a focus on business and finance.

In 2008, they obtained their Bachelor of Science degree in Finance, General from Minzu University of China, where they studied from 2008 to 2012.

Jeffrey(Haiyang) then pursued a Master of Science degree in Finance at DePaul Driehaus College of Business from 2012 to 2014.

Continuing their education, Jeffrey attended the Ivey Business School at Western University in 2015 to 2016, where they obtained a Master of Science degree in International Business.

During the same period, they also joined CEMS - The Global Alliance in Management Education and completed a Master of Science degree in International Management.

In 2016, they furthered their studies at The University of Sydney Business School and earned another Master of Science degree, this time in Management.

In addition to their formal education, Jeffrey also obtained several certifications. In February 2018, they earned the ITIL Foundation certification from AXELOS Global Best Practice.

Jeffrey(Haiyang) also obtained the Series 66 - Uniform Combined State Law Examination certificate from NASAA in January 2017.

In December 2016, they acquired the Series 7 - General Securities Representative License from the Financial Industry Regulatory Authority (FINRA).

Furthermore, in November 2021, they completed several certifications on Coursera, including Google Sheets - Advanced Topics, Creating New BigQuery Datasets and Visualizing Insights, and Exploring and Preparing your Data with BigQuery.

Links

Previous companies

FDM Group logo
Capital One logo