• Developed a CO2 emissions calculator using Carbon Offsetting and Reduction Scheme for International Aviation (CORSIA)'s formula and International Civil Aviation Organization (ICAO) data, comparing methods and creating CO2 emissions curves in Excel. Integrated the results into the troops- and police-contributing countries (T/PCC) Passenger Movement Database, enhancing carbon footprint tracking for peacekeeping operations• Cleaned and consolidated cargo datasets from dozens of countries in Python, reducing data inconsistencies by 95% and improving database reliability for logistics decision-making• Designed Power BI dashboards analyzing Passenger and Contingent-Owned Equipment (COE) performance by mission, carrier, etc., showcasing time delays and on-time performance, improving operational monitoring

• Spearheaded in-depth research to compile background information and relevant political and economic datasets on election violence in Bangladesh, focusing on data cleansing, feature selection, and analytical processing of The Armed Conflict Location & Event Data Project (ACLED) dataset• Designed a predictive tool with Random Forest and XGBoost models using Python, extracting features from ACLED dataset for forecasting monthly political violence incidents in 13 countries in Asia Pacific Region over a six-month period• Developed and implemented a dashboard using Looker Studio for visual analysis and continuous tracking of predictive results, optimizing data-driven decision-making processes• Part of Operations Consulting Course at Columbia University

• Conducted on-site observations of warehouse supply chain processes, mapped workflows into flowcharts, and identified bottlenecks and pain points through time studies and data analysis• Implemented Kaizen methodologies and optimized inbound supply chain processes to enhance operational efficiency and streamline warehouse management workflows• Part of Operations Consulting Course at Columbia University

• Out-of-focus Image Deblurring and Image Drift Correction: To improve the meter reading accuracy of robots at substations, implemented with Python a stereoscopically attentive multi-scale network (SAMNet) for lightweight salient object detection in the pre-processing phase, currently testing the performances of mobile single shot detection (SSD) and YOLOv4 algorithms• Multi-object Tracking (Single Pedestrian Locking): Performed instance segmentation based on YOLOv7 to track pedestrians in videos, and applied ByteTrack to improve the tracking performance; realized a feature function of locking one pedestrian while effecting a Gaussian blur on the contours of other people on the screen• Musical Applications Creation: Performed edge detection on photos featuring sunlight, converted obtained characteristics (like RGB and HSV values) to musical notes, and created multimedia applications with TouchDesigner for an art exhibition

• Crawled 4,100 entries of IoT B2B businesses from Tianyancha's database, studied the 2020 white paper of China Smart Home Industry Alliance (CSHIA), visualized analysis results (of competitive landscape, industry chain, pain points of target firms) with Tableau, streamlined the development of the IoT industry in China in the past decade in a 7-page report• Conducted a similar case study of industrial automation in artificial intelligence, particularly studied academic papers on the application of predictive maintenance to evaluate its prospect of mass adoption• Compared the performances, specifications, and sales statistics of iFLYTEK's CSK400X chip and competitors thereof, created a parallel comparison report, and assisted with decision making of the product manager and marketing staff

• Drafted a report on the food retail industry, reviewed all the legal terms and conditions in the contracts• Remade the internal template for data consolidation, particularly the attributes and forms for a certain assignment• Entered data into the new risk control system, liaised between the department and the tech team about adding new features, organizing the data formats, and generating reports