Data Analyst

DADIAN (JASON) QU

205-***-**** **** S Joyce St. Arlington, VA 22202 *******@******.***.***

www.linkedin.com/in/dadian-qu

EDUCATION

THE GEORGE WASHINGTON UNIVERSITY, School of Business Washington, DC Master of Science, Information Systems Technology – GPA: 3.59 11/2018

Areas of focus: Info System development; Python & SQL; Relational Database; Project Management; Internet Computing; Web and Social Analytics.

THE UNIVERSITY OF ALABAMA, School of Business Tuscaloosa, Alabama

Bachelor of Science in Accounting – GPA: 3.55 05/2016

Awards: Latin Honor Graduation; Investment Banking Immersion Program Scholarship; Dean’s Exceptional Award; President’s and Dean’s Lists

Investment Banking Immersion Program: Performed company valuations utilizing comparable company analysis, precedent transactions analysis; Built fully integrated financial statements projection models.

TECHNICAL SUMMARY

Certifications: SAS, Bloomberg Market Concepts, IRS Basic, QuickBooks

Software/ Technology: MS Excel, Tableau, MySQL

Statistics Analysis: Hypothesis Testing, A/B Testing, Text Mining, Exploratory Data Analysis

Programming Skills: HTML, JavaScript, CSS, jQuery, Python, SAS, SQL

EXPERIENCE

DASDAK COMPANY Washington, DC

Data Analyst 05/2017 – 08/2017

Developed advanced SQL queries and built complex SQL reports to audit inventory transactions according to corporate standards and conducted investigative analysis to provide the appropriate resolutions.

Performed data extraction, transformations, and cleansing by analyzing and eliminating duplicate and inaccurate findings, using PRO FREQ, PRO UNIVARITE, and Macros in SAS from 6000+ records.

Designed and built statistical analysis models on company’s data set from 5000+ customers using SAS and Excel.

Utilized SAS statistical software to analyze data, interpreting data to identify key metrics and draw conclusions.

PILDOLAB COMPANY Barcelona, Spain

Data Analyst 05/2015 – 07/2015

Performed data queries with SQL and prepared monthly financial reports spreadsheets and pivot tables.

Tested and ensured data accuracy through the creation and implementation of data integrity queries, debugging, and troubleshooting within SAS program code while maintaining data integrity and structured programming logic.

Manipulated data from website using VLOOKUP; matched from Excel to obtain accurate data feed for visualization.

Led a team of eight to create and update the accounting information system, the company’s first proprietary system, leading to a 5% reduction in operating costs and improvement to work efficiency by 35%.

PROJECTS

Homeless Shelter Staff System (GreaterGoods.care)

Proposed and implemented site content architecture and navigation scheme by developing data flow diagrams.

Designed web interface, an application that allowed homeless shelter staff to lookup their shortage goods, publish their needs and communicate with donors using HTML, JavaScript, CSS, and JQuery.

Developed login system, implemented email verification system and input validation system using regular expression.

Coordinated various web pages with appropriate links and multimedia elements in collaboration with design team members.

In-Store Navigation System

Developed project timeline, resources needed, WBS and scope activities based on the initial business plan.

Led the design and testing phases, including economic and technical feasibility by researching data in the market.

Manage project deployment lifecycle, define requirements, research solutions, design systems, support testing and oversee live implementation.

Manage full software development planning process including the design of specifications, diagrams, techniques and strategies.

Contact this candidate