William Wang

William Wang

Columbia Graduate & Software Engineer at Microsoft Azure

About Me

I'm a Software Engineer at Microsoft Azure, working on CosmosDB: MongoDB. I'm interested in database internals, systems development, and data-driven applications. I enjoy working in collaborative, fast-paced environments.

With a strong foundation in computer science from Columbia University, I'm passionate about creating efficient, maintainable, and user-friendly solutions that solve real-world problems.

In my free time, I enjoy snowboarding, taking photos, and playing lacrosse.

Work Experience

Microsoft Logo

Software Engineer

Microsoft Azure - CosmosDB

July 2024 - Present • Redmond, WA

Engineer on Azure CosmosDB MongoDB Team, building the Virtual Core MongoDB service.

  • Owned and shipped the Data API, a RESTful, HTTPs interface for MongoDB clusters, a RESTful, HTTPs interface that streamlines customer connection to MongoDB clusters, in both C# and Rust Gateways.
    • • Designed and developed the embedded request handler, dynamic server-load balancers, plain authentication mechanism, control plane elements, telemetry, and more.
    • • Supervised efficient customer rollout, after testing thoroughly in all cluster environments.
    • • Worked with support engineers to build the PowerBI Connector with Data API, allowing customers to query MongoDB data directly from PowerBI.
    • Data API GA Announcement →
  • Co-owned and developed the PG DocumentDB Gateway, a memory-safe, low-latency bridge for MongoDB clusters.
    • • Developed user CRUD operations, BSON request handler, HTTPs interface, verbose logging system, and more.
    • • Worked on cursor, sessions, and transaction management systems.
    • Open Sourced Rust Gateway →
  • Co-owning and developing Full RBAC (Role-Based Access Control) for MongoDB clusters, allowing customers to create, manage, and delete custom roles.
    • • Developed User CRUD operations for the open-source Gateway.
    • • Developed and designed role privilege system and username/password constraints for the open-source Engine.
    • • Developed and designed the Connection Status command, allowing customers to view authenticated users and their roles.
    • Open Sourced Engine →
  • Assisted with the development of read-only users, release validation pipeline, and Entra ID authentication.
C#CRustRubySoftware DesignSystems DevelopmentDatabase Internals
Columbia University Logo

Research Assistant

Columbia University, Fu Foundation School of Engineering & Applied Science

October 2023 - May 2024 • New York, NY

Research Assistant at The Wu Lab.

  • Developed a full-stack web application aimed at enhancing the accessibility and usability of data governance tools.
  • Engineered an end-to-end solution enabling administrators and analysts to upload data, execute queries, and visualize data lineage.
  • Implemented core governance features including auditing capabilities, compliance tracking mechanisms, privacy controls, and role-based access control.
  • Focused on empowering administrators to manage databases and analysts effectively while ensuring the protection of end-user data.
Full-StackWeb DevDatabases
Microsoft Logo

Software Engineering Intern

Microsoft Azure - CosmosDB

May 2023 - August 2023 • Redmond, WA

Engineer on Azure CosmosDB Backend Team, focusing on vectorization algorithms and database indexes.

  • Developed high-performance AVX SIMD Cosine & Normalized Cosine Distance functions:
    • • Achieved 82.3% and 89.1% time reductions in benchmarks
    • • Implemented solutions using Rust and C++ in CosmosDB's DiskANN repository
  • Built CosmosDB's first e2e vector index with multiple distance functions:
    • • Implemented L2, Cosine, Normalized Cosine, & Inner Product functions
    • • Created 4 test suites with 50+ scenarios
    • • Achieved 31.2% and 29.1% reductions in query and storage times
  • Spearheaded early-stage VectorDB initiative and created OpenAI embeddings utility
C++PythonAzure
Microsoft Logo

Software Engineering Intern

Microsoft Security - Intune

May 2022 - August 2022 • Redmond, WA

Engineer on Intune R&D, focusing on Apple device enrollment systems.

  • Engineered Apple enrollment capabilities for Microsoft Intune:
    • • Enabled 1,000,000+ tenants to manage 500,000+ macOS devices
    • • Developed UI components and Graph processing systems
    • • Enhanced data warehouse performance
  • Led cross-functional collaboration with Apple's API team and internal teams
  • Managed scrum meetings with PMs and delivered production-ready service
C#.NET MAUISwiftObjective-CKotlinJava
Microsoft Logo

Software Engineering Intern

Microsoft Security - Intune

May 2021 - August 2021 • Redmond, WA

Engineer on Intune R&D, working on Win32 application systems.

  • Developed the Win32 application analyzer/collector:
    • • Engineered three scalable, map-based solutions in C#
    • • Enabled comprehensive application details collection across all machines
    • • Implemented tenant administrator access and storage systems
  • Conducted thorough analysis of solutions:
    • • Performed time, space, and Azure-resource cost analysis
    • • Collaborated with teams to assess solution efficacy
    • • Successfully merged implementations across multiple Intune codepoints
C#Azure DevOps
Microsoft Logo

Explore Intern

Microsoft

May 2020 - Aug 2020

  • Engineer and Program Manager on MMD; collaborated with engineers, PM's and designers to develop an innovative, comprehensive KPI dashboard for executives in the Microsoft Security organization.
  • Leveraged HTML, CSS, JavaScript, React, and Angular.js for front-end with Kusto and CosmosDB for back-end; established a flexible, dynamic feedback loop with executives, ending the summer with a 97% approval rating.
  • Performed project manager duties; designed creative mockups with Figma, mediated ideas between multidisciplinary executives, wrote product requirement documents (PRDs), and represented project in scrum meetings.
HTMLCSSJavaScriptReactAngular.jsKustoCosmosDB

Education

Columbia University Logo

Columbia University

Bachelor of Science in Computer Science

September 2022 - May 2024 • New York, NY

Fu Foundation School of Engineering & Applied Science

Relevant Coursework:

Computer Networks, Advanced Programming in C, Object-Oriented Design, Computer Systems, Databases, Analysis of Algorithms, Artificial Intelligence, Computer Science Theory, Data Science, Natural Language Processing, UI Design, Open Source Development, Engineering Software as a Service, Full Stack Web Development, Safeguarding Intellectual Property

Claremont McKenna College Logo

Claremont McKenna College

Bachelor of Arts in Economics & Engineering

September 2019 - May 2022 • Claremont, CA

Earned Economics & Engineering degree (3+2 Program) before transferring to Columbia University.

Relevant Coursework:

Introduction to Computer Science, Data Structures and Algorithms, Data Science, Discrete Mathematics, Computational Engineering, Computational Quantum Physics, Linear Algebra, Differential Equations, Microeconomics, Macroeconomics, Corporate Finance, Financial Accounting, International Economics

Projects & Awards

Intel ISEF Logo

Implementation of Gyroscopically Leveled Spherical Drones

Intel ISEF 2018: 3rd Place in Engineering Mechanics

View Project Abstract →

Developed an innovative spherical drone optimized through Neuro-Evolution of Augmented Topologies (NEAT) for reconnaissance and imaging of Martian environments. The project addressed limitations of traditional rovers by creating a dust-storm resistant, gyroscopically leveled spherical drone capable of autonomous operation.

  • Engineered an axle-driven main motor assembly suspended inside an enclosed sphere with mounted camera capabilities
  • Implemented machine learning algorithms for surface optimization through neural network simulation
  • Designed wireless communication systems for autonomous sensory and synchronized 3D imaging
  • Received Third Award of $1,000 and INCOSE Certificate of Honorable Mention

Skills

Languages

Java, Python, C#, C/C++, JavaScript, Rust, HTML/CSS

Cloud & Databases

Azure CosmosDB, SQL

Tools & Frameworks

Git, Docker, JUnit, TypeScript, Pandas, Matplotlib

Design

Figma

Contact Me