As SME for fraud analytics in Visa, one of my most recent achievement is to redesign of Visa Direct fraud performance dashboards where I have optimized the sql to be aligned with Product team and cut down the process time/steps significantly. As the site owner of Global Risk Tableau site, I had to leverage my strong SQL skill plus Tableau knowledge to reduce the largest dashboard (15 GB) to 3 GB by consolidating various duplicated datasets into one.Currently I manage 4 offshore consulates for our monthly refresh of up to 46 BI assets by mainly providing guidance on optimizing SQL plus Tableau with the goal to be fully automated.In 2024, I successfully lead and completed the data base cluster migration to a Dpan environment to compliance with Visa data privacy commitment. Specifically, tasks include creating enterprise role, ad group, allocation of capacity such as memory, vcores, and queues.Earlier achievements includes building out the monthly fraud BIs, major single event risk daily tracking such as Olympic game, Fifa World cup as well as major US holiday. Besides, I also covered all ad hoc fraud related analytical requests for all six regions around the world. Leveraging my strong BI skills such as MicroStrategy, Tableau, and Excel, I have built several highly impactful dashboards such as Global Fraud Trend, Issuer dynamic benchmark dashboard, Global CSR Default Risk dashboard, as well as Global Fraud Rate deep dive Insight dashboard.As the dedicated fraud analytic expert, I have handled various ad hoc requests such as Digital fraud, Fallback fraud, fraud by local currency banding, etc. These requests often involve complex SQL query against various data source such as authorization, clear & settlement plus fraud data.As most knowledgeable member in global risk, I have held comprehensive series of training on BI dashboards for our global risk managers during 2022, with great feedback.

As the leading analyst supporting eBay's fraud team covering key areas such as ATO, high risk selling, I have gained tremendous knowledge how to prevent and detect fraud. Leveraging industry-leading identity solution from vendors such as ThreatMetrix as well as eBay internal device-finger-printing techniques, we have achieved the lowest ever ATO rate in eBay history.During last two years, I have built many Tableau tracking/monitoring reports to support the daily operation of business team on fraud activities such as potential attack volume, challenge rate, hit rate, leakage rate, etc. The automatic process of Tableau enables me to respond quickly to any sudden increase in fraud activities so that, if necessary, I can focus my time and effort to deepdive the cause and share the insight quickly with the team.

As the head of eBay CLV and CRM analytic team supporting the marketing team, responsible for Leading the analytic support for CLV project. Key milestone of V5 includes 90% FPA cost allocated to each customer. Conducted a project to truly predict customer lifetime value with a reputable 3rd party vendorProviding comprehensive ad hoc analytic insights related to eBay's various user/customer segmentation, Axiom's demographic data profileSupporting consumer to consumer marketing programs. Type of program measured are email, onsite display, paid search. Implemented predicative model by user segm to increase response rateLead the latest attribution model for onsite billboard, resulted in 10X increase in tracked sales

As head of Safeway's dedicated analytical support for Marketing Planning Dept, my responsibility includesProviding ad hoc analysis on weekly basis for events such as online coupon, mfg coupon, in-store couponPerforming the post promotion analysis on key quarterly mass campaign in term of basket size, traffic as well as new/retained customerSupporting retail operations by scheduling weekend daily tracking report on several key initiatives such as Retail Sales Force, 48 Hour salesLeveraged shopper insights to design, execute, measure and optimize targeted marketing programsRunning predictive model on DM campaigns via SAS regression to improve effectiveness Managing 2 direct reports

Installed the 3rd party mobile merchandising data collection and reporting systemProvided the technical support to over 240 field assistant across the nationBuilt an Access database to provide labor cost fairshare billing for Safeway's SCOP process using Apollo schematics, Informix databaseModified and added new Crystal Report for outside reps to track their performance

Managed the marketing and distribution of four major brands of a $3.5 billions Asian consumer product manufacturing and distribution company in Canada and US. Specific tasks include marketing plan, print and TV media buying, distribution, purchasing, and trade promotion.

Participated in various marketing aspects for product relaunch for Dental Floss, ACT� oral rinse including agency briefing, packaging design as well as focus group

Designed and executed the marketing plan for first product launch of Johnson's Baby� toiletries (7 brands, 26 SKUs) in major cities across ChinaParticipated, with agencies, in creating the first TV commercials for China marketDesigned and negotiated TV and Print media buying with major city TV stations and newspaper bureaus