Xingchen Luo

Background

About Xingchen Luo

As a data professional with a finance background from McGill University, I'm enhancing my skills through a Master's in Management in Analytics at McGill, expected to graduate in 2024. At KPI Digital, I excelled as a Data Scientist, developing data infrastructure, optimization models, and analytics reports with Power BI, alongside designing Figma prototypes for public transportation clients. My tenure as a Research Assistant at Yonsei University focused on analyzing money laundering activities in decentralized applications and cryptocurrencies. Proficient in SQL, PowerBI, Python, Azure, R, SAS, and Excel, I excel at converting complex data into actionable insights. I'm eager to leverage my data analysis and strategic insight skills to drive value in new settings. Contact me at xingchen.luo@mail.mcgill.ca to discuss potential collaborations. Microsoft Office: Pivot Table | XLOOKUP and VLOOKUP | If statements | SUMIF and COUNTIF | Macros | VBA | Chart creation | Data analysis | data validation | goal seek | advanced filtering | conditional formatting | What-if | Index and Match | Data modeling | PowerPivot | Power Query | PowerView | Power Bi | DAX | R / Python Integration | PowerPoint | ppt | Pivot Tables | Power Point SQL: UNION | INSERT | UPDATE | DELETE | CREATE | ALTER | INDEX | TRIGGER | STORED PROCEDURES | CURSOR | TRANSACTION | TEMPORARY TABLE | INDEX | NORMALIZATION | OPTIMIZATION | DDL | DML | DCL | Data warehousing | ETL | Extract, transform, and load | Bi | NoSQL | Big Data | Cloud databases | MongoDB | MySQL | SQL Server | Oracle | PostgreSQL | SQLite | AWS | Azure | Good Coud SQL | Data Governance | Data modeling | Agile Python: Numpy | Pandas | Matplotlib | seaborn | Jupyter Notebook | Machine Learning | Test-driven development (TDD)| Data analysis | Data visualization | Data science | Automation | Web scraping | Multiprocessing | Scikit-learn | Modelling | Gurobi | Causal ML Additional: Porter Five Analysis | Supply Chain Data Analysis | Demand Forecasting | Inventory Turnover Analysis | Supplier Performance Evaluation | Data Analysis | SWOT Analysis | Cost-Benefit Analysis | Business Intelligence Tools | Performance Measurement | Market Trend Analysis | Organizational Analysis | Market Segmentation | Consumer Behavior Analysis | Competitive Analysis | Financial Modeling | Customer Journey Mapping | Digital Marketing Analytics | Product Life Cycle Analysis | Pricing Strategies | Social Media Analytics | Campaign Performance Analysis | Customer Satisfaction and Loyalty Analysis | Sentiment Analysis | Causal ML