SKILLS AND QUALIFICATIONS
Over 3 years of hands-on experience in Python, Adv SQL, VBA programming
3 years’ perfect experience in in pandas, NumPy, Matplot, Seaborn, TensorFlow
Hands-on experience of data collection and cleaning, custom ETLs, descriptive statics and
visualization, machine learning, structured and unstructured data in a variety of formats XML, JSON
3 years’ experience in report and dashboard designing, especially developed automated report on
MOM(WOW) and MTD(WTD) using Power BI, Apache Echarts.
Extensive experience in Neural Networks, CNN, RNN and time series analysis with solid knowledge of
Over 1 year of GitHub & AWS environment for Web design, Database (MySQL), backend (Django)
Good understanding of public cloud computing technologies, architecture and big data technologies
including MangoDB, Spark, Hadoop, Hive, Cassandra
Experience working with Dynamic 365(CRM, ADX and Operations and Finance) with Microsoft Azure, MS
SQL Server, Proven expertise in Access, Excel (pivot table, conditional format, multi table
operation), PowerPoint, Google Analytics.
Diverse business knowledge accumulated within education, digital media, eCommerce, banking, and
Data Engineer --- FundPage Inc. 2020.8 – 2021.05
Performed ETL source data files from different relational database, such as SQL Server, Oracle, DB2
and web data. Processed data validation, cleansing, large data manipulation, system integration and
Transfer all data by using python and Flask with data validation, customer information and
investment account information into database
Process large datasets using data management and analysis systems, mainly built on SQL Server BI
platform, to analyze the data and create new looks of financial insights with SSIS
Manage Investment Transaction Data on Microsoft SQL Server, and analyze that data primarily using
Power BI, pyecharts
Develop integrated data sources, spreadsheets, KPI reports, dashboards and presentations, with
visualized and interactive reports, using Power BI for frontend business
Joint forces with Content Manager, Technical leaders, and QAs to ensure business acceptance
Creating UI populated on web pages
Use Python to generate REST API for the output
Data Analysis --- Dewey Institute 2018.06 – 2020.08
Processed various industry marketing campaign analysis. Selecting target student base on various
analysis method, set up control group, proceed A/B test analysis.
Worked in a project group of 10 to complete the University of Toronto Green Path Cup Winter Camp
into a fully digital platform. The new ePlatform integrated web portal, social media, and mobile
Designed various report and dashboard, especially create automated weekly, monthly report.
Data process modeling, IT project management, and knowledge of IT standards, procedures, and
Office 365 admin
Developed and maintained a portfolio with over 2000 clients under management
Managed CRM solution export, import from development, UAT and production
Delivered 5+ projects using Waterfall and Agile mythologies
Self-Web Developer (Python Full Stack)
Use AWS Elastic Beanstalks and Github as developer environment
Design MySQL database for a gaming csv.
Migrate Flask website to Django
Transfer all data by using Django ORM with data validation, player information into database.
Use Django, CSS, HTML to build company website include add, update, customer information and account
Analysis potential player in database and use Apache Echarts to build dashboard.
Build Financial Dashboard from open source(yfinancial). Including RSI Bollinger Band, with Dynamic
Maintain and create AWS RDB database instance.