Hailiang Wang Email and Phone Number

- Develop, design, and maintain advanced data visualization (dashboards) and self-serve tools using Power BI/Tableau- Provide analysis gathered from SQL queries, related to business operations, productivity, performance, planning, work methods and procedures- Work closely with business units and data analytics team to communicate concerns, business requirements and needs- Design and develop underlying data structures for reporting and BI solutionsCreate SSRS report and build SSIS package to support automated business unit data request

- Retrieve financial data from various API and web scraping (Trade Station, Esignal, iqfeed, Yahoo finance, Federal Reserve) and transform them in usable format- Perform data analysis on return performances and model results, as well as automate and create reports(Power BI) for internal teams and external clients- Strong proficiency in using python (Panda & Pyspark) to handle big data for backtest and use Power BI to perform business intelligence analysis on data result- Assist in developing financial metrics, indicator and zone, perform hypothesis testing and performance analysis- Apply machine learning such as ‘scikit-learn’ and ‘TensorFlow’ to create models of prediction algo returns based on financial metrics

• Extract and compile government financial data in 50 states and 75 cities • Analyze, verify and transfer extracted data into internal TIA database • Collaborate with Marketing team to build data visualization for the company’s website • Develop understanding of governmental accounting

- Assist with data entry, filing and other general office activities necessary- Complete bank statement reconciliation and month-end financial reports- Research and respond to notices from states tax authorities