Michael Li

Experience

• 

  Presidium

  Dec 2017 - Aug 2018

  Internship

  ● Dealing with 37 properties’ data by using Yardi (An ERP software for property management).● Processing accounting activities for 3 RV parks, such as tenants’ payment, utility bills, and bank reconciliation.● Increasing the speed of weekly invoice report generation up to 30%.● Improving daily invoice entering for 20+ Properties in the Yardi system by using the VB.● Preparing monthly bank reconciliations for 6 properties.

• 

  Zuri Furniture

  Jun 2019 - Jul 2019

  Ecommerce Business Analyst

  • Collaborated with SCM teams to identify cost-effective methods to improve shipping processes.• Extracted data through SQL and explored data using Python (Pandas, Seaborn, and Matplotlib), including imputing missing data, figuring out critical features, and normalization.• Predicted the best shipping method by using machine learning models (Linear Regression, Logistic regression,Neural Networks, SVR, etc.) through Python.• Executed 5-Fold Cross-Validation to adjust models to reduce the overfit.• Improved shipping cost forecasting accuracy and enhanced the shipping procedure efficiency up to 50% byimplementing this model.• Presented and delivered the model to the supply chain team and sales team Show less

• 

  Porch Group

  Jan 2023 - now

  Data Analyst

  ● Automated Six financial reporting pipelines through Azure Data Factory, enhancing self-servicecapabilities and scalability for internal teams.● Optimized financial forecasting reports by developing and deploying machine learning models using Pythonand SQL, improving accuracy by 25% and reducing runtime by 60%.● Developed real-time risk reports managing databases with 1M+ records using SQL Server, Python andintegrating GIS data via ArcGIS API.● Automated ETL workflows on Azure for seamless data integration, improving reporting efficiency andaccuracy across third-party systems.● Enhanced system performance by optimizing database queries and integrating cloud-native services. Show less