• Extensive experience in SQL for database extraction and manipulation • Experience in handing huge data, with data cleaning using Python• Proficient in data visualization with Excel and Tableau• Deep understating of retail banking data analysis (fraud detection and mitigation strategies)• Strong Communication skills and adept at managing multiple priorities in fast-paced environment
-
InternBbd Insights Nov 2024 - PresentNorth York, Ontario, Canada -
Data Analysis TraineeSavvypro Edu Inc. Sep 2023 - Feb 2024North York, Ontario, CanadaIncome-Producing Real Estate Risk Rating Model• Assessed data quality and accuracy in data sources, propose treatments for data anomalies• Deep dived data attributes to identify potential risk drivers (i.e., predictors of default)• Applied Weight of Evidence transformation to evaluate the predictive power of continuous, ordinal, and categorical variables.• Validated model appropriateness and performance based on in- and out-sample testing result as well as subgroup analysis Fraud Strategy & Analytics• Hands-on experience in analyzing retail banking transactional data(200K+ records) • Deep understanding of commercial and retail payment products• Created complex features by using SQL joining and various data manipulation techniques• Developed rules to mitigate fraud trend (Taxi Scam, Worthless Deposits in multiple locations)• Used key metrics (value detection rate & false positive rate) to evaluate rule performanceTim Hortons RUTR• Worked on a consulting project for Tim Hortons, tasked to improve the profitability of their iconic program – Roll Up The Rim (RUTR) Campaign• Explored past campaign data and generated insights using data analytics techniques using Excel (Pivot tables and advanced functions)• Utilized data driven strategy principal to deconstruct the campaign profit into determining key factors (Location of Store / Winning rate / Add-on rate / Add-on items) -
Business Intelligence AnalystAdidas May 2021 - Oct 2021Shanghai, China• Demonstrated working knowledge of Supply Chain Management (SCM) and complex business logic and processes• Utilized SQL for data extraction and aggregation in summary report • Developed dynamic dashboard using Excel and Tableau to forecast SO(sales order) and PO(purchase order) for the next quarter • Maintained Strong communication with team members through regular reporting -
Html Developer InternHangzhou Wanyu Network Co. Ltd Jul 2020 - Sep 2020Hangzhou, Zhejiang, China• Participated in the development and maintenance of the front-end and back-end website by using JavaScript and bootstrap plugin
-
BaristaStarbucks Mar 2019 - Aug 2019Hangzhou, Zhejiang, China• Attained Barista Certification• Achieved Sales Champion of the second quarter
Kehao Wu Education Details
-
Information Technology
Frequently Asked Questions about Kehao Wu
What company does Kehao Wu work for?
Kehao Wu works for Bbd Insights
What is Kehao Wu's role at the current company?
Kehao Wu's current role is Intern @ BBD Insight | IT @ York University.
What schools did Kehao Wu attend?
Kehao Wu attended York University.
Not the Kehao Wu you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial