Jiarui Han

🔬Research Interest

AI in Business

🤖 AI+X Focus Tags

AI+business strategy

🐾 My AI+X Journey

Amzon project

🎬 Content & Media Highlights

Project Title: ESG-Integrated Portfolio Selection for Tech Companies – An Automated Azure ETL & TOPSIS Ranking Framework

Brief Description:

This project tackles the critical challenge of ESG-aware investment screening, where investors must balance sustainability, financial health, market strength, risk, and public controversy—yet traditional ESG ratings are often fragmented and provider-inconsistent. To address this, we built an automated Azure cloud ETL pipeline that ingests and standardizes multi-source data from SEC EDGAR, XBRL, Alpha Vantage, World Bank, Kaggle, NewsAPI, and Yahoo Finance. The unified dataset feeds into an entropy-weighted TOPSIS model to generate objective company rankings, with an additional controversy penalty adjustment to capture negative news exposure and reputational downside risks.

This framework offers a scalable, transparent decision-support tool for asset managers and sustainability analysts, demonstrating how multi-criteria decision-making (MCDM) can navigate tradeoffs between profitability, responsibility, and risk.

GitHub Repository: https://github.com/dragcom/topsis-esg-portfolio-selection

🎈 Fun Facts

Music, travel

🏆 Achievements & Honors

1. National Second Prize, China Undergraduate Mathematical Contest in Modeling (2023)

2. National Second Prize, National English Competition for College Students (2022)

3. Second Prize (Beijing Region), 9th National Statistical Modeling Competition (2023)

4. Third Prize, "Challenge Cup" Capital College Students' Extracurricular Academic Sci-Tech Works Competition – Red Special Track (2023)

5.Third Prize (Beijing Region), 8th China International "Internet+" College Students Innovation and Entrepreneurship Competition (2022)

💡 Your Motto

Follow your heart and time will tell.

🧑‍🧒‍🧒 Community & Collaboration

I'm open to collaborate on projects and discussions at the intersection of AI and management science. As a management engineering researcher, I hope to bridge the gap between cutting-edge AI models and practical, transparent decision-making frameworks for investors and policymakers. Happy to connect with engineers, data scientists, and domain experts who care about making AI both impactful and accountable!