Anthony Sun

Background

About Anthony Sun

I have extensive experience in business/data analytics, database management, VBA programming, financial modeling, and business intelligence with strong problem solving skills. My Professional qualifications include, but not limited to, the followings: Project Management • Manage consultants on various database and reporting automation projects. • Liaise with various departments regarding database related project. • Develop work scopes, schedules and fund allocations commensurate with study needs. Report Automation & Application Development • Develop data management and reporting tools utilizing VBA, SQL and ADO programming. • Develop various GUI applications against different databases for reporting and analysis purposes. Database Management • Design, develop, implement, and maintain data warehouse in support of business intelligence operation. • Perform ETL processes by compiling data from various database servers into a data warehouse. • Validate data to ensure database integrity using SQL queries. Business Analysis • Identify opportunities for database and reporting enhancement. • Provide recommendations on appropriate solutions for analytics, reporting and database projects. • Gather and translate business requirements into clearly defined and easily understood documents. Quantitative Analysis • Build advanced analytics models such as Classification & Segmentation models, Multiple Regression analysis, Monte Carlo Simulation, Hypothesis Testing, and Time Series analysis. • Analyze customers’ industries, demographics, and financial information with trend analyses and KPI reporting. • Designed statistical/mathematical models. Financial Analysis • Perform financial and capital budgeting analyses such as benefit/cost analysis, CAPM, Black Scholes Option Pricing models, Portfolio Optimization, and financial ratios analysis. • Generate financial models that compute metrics such as NPV, ROI, IRR, Payback Period, P&L, systematic risk and beta under CAPM.