Vicky Wenqing Li

Open Source

See Github for more details.

Workday Adaptive Planning

Worked on OfficeConnect for CFO and FP&A teams, helping evolve it from a Windows-only add-in into a cross-platform experience for Mac, Windows, and web.

• Helped to migrate OfficeConnect, a Windows desktop tool used by CFO and FP&A teams, to a cross-platform web application using React, ExcelJS, and WebAssembly.
• Refactored legacy VSTO, WPF, and WinForms add-ins with full PR unit-test coverage and shared core logic.
• Converted sync flows to async for WASM compatibility and fixed critical migration-related system hangs.
• Improved performance through memory/CPU profiling and optimizations to data lifecycle, data structures, and algorithms.
• Standardized engineering with editor configs, static analysis rules, and centralized package versioning.

Tesla

Built smart features powered by machine learning algorithms for Tesla's global Service Center Application using .NET and Angular.

• Delivered APIs used by the Tesla Mobile App for scheduling, estimates, payments, and service notifications.
• Created a reusable HttpClient NuGet package, cutting boilerplate by 90% and standardizing auth, headers, circuit breaker, and logging.
• Implemented 20+ APIs across 10+ features, including reusable patterns for distributed race conditions and overwrite conflicts.
• Improved end-to-end performance by 40% via API/SQL profiling, query tuning, caching, and front-end optimization.
• Used factory and builder patterns, Pub/Sub messaging, and Hangfire cron jobs to improve scalability and reliability.

Verisk Analytics

Built APIs for Verisk's A-Plus Auto Loss History product, helping insurers assess risk and price policies faster and more accurately.

• Integrated internal and external APIs for A-Plus Auto Loss History and VIN decoding workflows.
• Analyzed and enriched request payloads to increase Elasticsearch hit rates.
• Built reusable internal tooling with reflection and middleware, including raw-request capture and nested object comparison.
• Designed APIs to batch process millions of rows using input-distribution analysis and optimized execution plans.
• Improved throughput with chunking, Parallel.ForEach, and async Task.WhenAll.
• Diagnosed production issues with Splunk and CloudWatch; worked across S3, EC2, Lambda, and SQS.

NYU IT

Built data pipelines and marts for education analytics, improving reporting quality and processing speed.

• Partnered with data scientists to turn stakeholder needs into pipelines and analytics for better learning outcomes.
• Moved Kaltura interaction data from S3 to Databricks (Spark), transformed it, and loaded Snowflake for clickstream analysis.
• Built data marts from flattened Spark outputs and validated edge cases to ensure data integrity.
• Reduced processing latency by 30%+ by converting nested JSON to Parquet and partitioning datasets.

Headway Digital

Managed global mobile CPA publisher partnerships, matching quality traffic to target segments to improve delivery and revenue.

• Managed global publisher onboarding for mobile CPA campaigns to improve programmatic delivery and revenue.
• Led China market expansion and secured 50 top clients.

Mobikok

Managed mobile CPA advertiser and publisher partnerships, ranked #1 in sales in year one, and supported growth from 20 to 60+ employees.

• Ranked #1 in sales within one year on the mobile CPA team; supported growth from 20 to 60+ employees.
• Built a Selenium/Python crawler with lxml export to Excel to gather competitive data from thousands of sites.
• Drove 300% profit growth in 8 months by using ad-spy insights and statistics to adjust campaign strategy quickly.