Karen (Keying) Pei Email & Phone Number

San Jose, California, US

San Jose, California, US

Zurich, CH

• Translate business requirements to technical requirements, analyze key dependencies and system capacities to design & build tech data infrastructure, system workflow, production planning tools with SQL, Sheets.
• Design & develop project On-Time, predicted On-Time, Execution, Compliance metrics and dashboards. Improved business planning & operations process by monitoring performance & trends under various scenarios and actively.
• Automate change management process by automating bug filing process with created customized bug template with scheduled SQL, JavaScript function workflow, automating analytics of datasets across multiple systems &.
• Plan & forecast impact from natural/public events (e.g. COVID-19, wildfire, hurricane) to projects, estimate and manage change to project pipelines by developing forecasting models & dashboards with considerations of.

Zurich, CH

• Built SKUs selection model for push notification, newsletter and influencer marketing improvement. Selected top selling SKUs with high PDP (Product Display Page) Richness score, high impressions, price competitiveness.
• Developed critical metrics based on product events data source & current PDP scoring model. Score each component in model, further analyze impact of products PDP with total PDP score. Combined PDP with product.
• Helped merchants onboard better matched business models, improved merchant sales by reducing 90% of EDD (estimate delivery days) and bringing more traffic to their store. Prepared researches on market, product, user.
• Developed cross board trading EDD goal metric benchmarking and modeling, with checkout page EDD combined forecast volume impact from planned promotions and transportation facts.
• Optimized assortment for online shopping platform by optimizing PDP Richness scoring modeling, helping merchants onboard better matched business models, and adjusting pricing strategies to make onboard SKUs more.
• Visualized data with Dashboard and merchant growth performance charts deep dive by channel, shipping origin country, EDD, top SKU, price competitiveness. Improved business process & info acquisition efficiency for both.

Zurich, CH

• Developed logics and metrics on shopping logistics performance and quality to root cause misses, found trends, and locate weakness for designing action items.
• Visualized data, trends and exceptions details with dashboards and data studio, improved business process and efficiency.
• Automated data process workflow & reporting tools with SQL, Python, JavaScript (pandas, numpy, scipy.stats), improved efficiency for various projects, saved 80% of working hours on deep dive & reporting process.
• Led daily & weekly performance reporting meeting for transportation carriers on-time performance review, visualized data on high-level summary & root caused details, callout exceptions & trends and designed action.
• A/B testing on impact from strategy changes and track performance with cohort analysis.
• Identified, analyzed, and interpreted trends or patterns in complex data from multiple sources and provide business insights and suggestions on customer online shopping experience improvement. Quantify improvement for.

Sunnyvale, California, US

• Led Market Research for dynamic top trending topics and User Behavior Research. Built database and Mathematical models to evaluate marketing promotion performance and ads quality. Scaled ads targeting audience groups/.
• Data mining and analysis on several platforms to improve product features and select the best resources. Increased DAU & LTV by 50% by A|B testing different features and providing strategies on feature optimization.
• Analyzed performance reports (Google Analytics/Facebook Analytics) and provided suggestions to decision makers on how to adjust business strategies. Planed in-app online marketing events, improved user.
• Worked cross-functionally with Editing, Art and Engineering teams across the company and present pipelines on project and product.

New York, NY, US

• Improved customer experience by programming and customizing feature designs on transaction devices, managing transaction database.
• Improved customer retention by 15% by troubleshooting end-user hardware, software, operating system, basic network and server access problems, analyzing transaction database and deep diving for root cause, provided.

Chicago, IL, US

• This is my Capstone project sponsored by CME.
• Compared hourly and daily trading data for Copper and Aluminum futures contracts of CME, LME and SHFE using Bloomberg. Analyzed ask-bid spread, volume, open interest and with Bloomberg analytic tools and Excel.
• Generated Amivest Liquidity ratio, Granger Causality test, F test and other statistics to evaluate market liquidity under different market factors scenarios. Evaluated weakness and designed strategies to help CME.

• Explored start-up business investment opportunities by analyzing with combining knowledge of law, accounting, finance and statistics in PE industry.
• Collected news and data, including financial statements and historical quotes, analyzed data with Excel, R and SQL. Collaborated with senior analysts to do research and wrote securities and industries analyzing reports.

Master Of Science (Ms), Financial Mathematics

Exchange Program, Master Of Business Preparation Program

Bachelor Of Economics, Finance (Investment And Financial Management)