Resume

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 data science
  • 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 insurance sector
  • Familiar with R, SAS, C++, JavaScript, Lua, VB, Jinjia2
  • EXPERIENCE

    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 migration
  • 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 service
  • Designed various report and dashboard, especially create automated weekly, monthly report.
  • Data process modeling, IT project management, and knowledge of IT standards, procedures, and policies.
  • 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 information.
  • 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 coding.
  • Maintain and create AWS RDB database instance.