Elwin Zhang Email & Phone Number

New York, NY, US

New York, New York, United States

Los Angeles, California, United States

• Optimized GMV/hr by creating Snowflake-powered Metabase dashboards to identify shop’s most productive live hours
• Created a live projection of GMV for the day that would recalculate each hour based on how the day was trending, allowing the business to pivot strategies at any moment if GMV was lagging behind forecast
• Led an analysis comparing streams with and without giveaways, examining giveaway trends in app and GMV 5/10/15 minutes before and after each event, and shared findings with sellers to enhance audience engagement
• Improved seller team's Hubspot data accuracy with Snowflake/Segment to enable automated Sinch SMS messaging
• Quantified the impact of app auction downtime and inefficiencies in Shippo transactions, highlighting key business opportunities

Santa Monica, California, United States

• Engineered and implemented a robust data architecture and backend workflow, seamlessly transitioning data from S3 to Redshift, to enable the generation of expansive Tableau reports and analyses tailored for the public.
• Boosted Go-To-Market efficiency by automating ETL processes with Python and SQL, resulting in faster insights from critical metrics (TAS, hierarchy, revenue) and seamless integration of 3rd-party data sources (HG.
• Collaborated with business leaders in optimizing selling strategies through data-driven insights and modeled scenarios, leading to territory planning optimization and increased accuracy of quota setting
• Developed and automated monthly account sizing, revenue, and cloud adoption rate to provide timely market and account level changes to the field to accelerate selling strategy

Washington D.C. Metro Area

• Designed the new database and workflow to calculate lifetime values for monitoring retention health and reporting to quarterly earnings as Rosetta Stone moved to a 100% subscription based company
• Developed the sole source of truth across Rosetta Stone for performance vs. forecast on a daily level that made intra-month strategy pivots possible for both US and EU sectors
• Spearheaded multiple collaborative analytics projects to assess and create company profitability- drivers, such as usage vs. renewal analytics and the development of email customer profiles to increase conversion rate

Herndon, Virginia

• Improved relationships with Audi's Digital Analytics teams by daily face-to-face interactions, by designing automated internal process with SQL Server, SSIS/SSRS, Excel and other back-end tools, and by providing SQL.
• Developed and launched an automated Lead-to-Sale matching algorithm that empowers dealerships to submit uncaptured sales requests while also providing education about the Audi's Lead Program
• Managed data deployments, dealer and partner lead invoicing, and CRM technical support issues

Saddle Brook, NJ

• Data mined Catalina's industry-leading shopper database and leveraged SAS Enterprise to draw marketing insights and predict changes in buyer behavior to help boost sales and build brand names
• Collaborated with Sales and Brand Development teams to identify in-depth marketing drivers, optimize loyalty segmentation and provide strategic support on marketing campaign designs

New Brunswick, NJ

• Analyzed and interpreted sensory data and panel performance for all sensory projects
• Communicated statistical outcomes yielding actionable decisions with management
• Assisted multidisciplinary teams by generating data summaries for presentations
• Applied experimental designs to various sensory experiments
• Conducted correlation studies to understand different test methodologies

Cranbury, NJ

• Analyzed drug markets and competitors for new generic drug product development using financial models and information from IMS Smart system and other databases, as well as all materials/tools that related to FDA.
• Nominated potentially profitable generic drugs for new product development

Princeton, NJ

• Developed methods and performed preparative supercritical fluid chromatography (SFC) separations to resolve target chiral drug molecules in support of drug discovery for many major pharmaceutical companies including.
• Supported research of graduate students at Princeton University Chemistry Department by providing SFC and High Performance Liquid Chromatography (HPLC) method development, analysis and purification.
• Independently resolved an instrument issue that was critical for completing separations for Amgen. Built a creative device that enabled self-sustaining preparative SFC operation.

Masters, Biostatistics

Bachelor Of Science (Bs), Neurobiology And Behavior

Senior Research Project •Simulating an oncology drug discovery and development process through a computer program designed by Pfizer.