On my Promotion Effectiveness Analysis project, I integrated three raw data sources into a Snowflake SQL model and a matching Python pipeline covering 2.6M transactions. I found duplicate promotion records and removed 914 invalid rows.
I added checks to catch join errors and wrote a SQL validation script to compare results with the Python output; both pipelines matched exactly. The analysis found promotions lifted sales 82–177% but returned $0.50–0.73 per $1 discounted.
I also built and deployed InsightAdvisor, a platform that automates data cleaning, quality scoring, analysis, and reporting. It includes anomaly detection and forecasting, and was validated on 200,000 retail rows with a data quality score of 96/100.
As a Big Data Analyst Intern at Chengdu Suncaper Data Co., Ltd., I cleaned and joined flight data with airport and country reference tables, then built route and timing analyses. The project was rated Excellent. I’m a Software Engineering graduate and MBA student, and I’ve worked with Python, SQL, Git, and Jira.

