# Purvil Mehta > Software Engineer II @ Sigma Computing | MSCS Honors at USC | Ex-Amazon SDE Location: San Mateo, California, United States Profile: https://flows.cv/purvilmehta A dedicated and diligent software engineer at Sigma Computing with a Master’s in Computer Science. Experienced in Web Development, Software Programming, and SQL generation optimization, I thrive on deciphering challenges and crafting algorithmic solutions. With a strong academic and research foundation, I bring meticulous attention to detail and a passion for enhancing performance through innovation. An independent problem solver with a positive outlook, I’m driven to contribute creatively and meaningfully to my team and the broader tech community. ## Work Experience ### Software Engineer II @ Sigma Jan 2025 – Present | San Francisco Bay Area - Build and maintain a compiler that translates spreadsheet interactions into optimized, warehouse-specific SQL - Improve performance via client-side strategies like prefetching, query merging, caching, and an in-browser WASM engine - Led design and implementation of Sparklines - Delivered native `VARIANT` support in Sigma for Databricks dialect - Design multi-stage IR pipelines and apply advanced query optimization techniques ### Software Engineer @ Sigma Jan 2024 – Jan 2025 | San Francisco Bay Area - SQL Generation & Optimization: Develop and optimize the compiler to generate SQL queries with enhanced query performance for various databases like, Snowflake, BigQuery, Redshift, MariaDB, AxureSQL, Databricks, MySQL, and Postgres - ⁠Browser Cache Management: Implement and manage caching strategies to determine the necessity of backend requests, reducing unnecessary SQL generation. - ⁠Performance Enhancement: Lead initiatives to minimize end-to-end latency, improving overall system responsiveness and user experience. - ⁠Continuous Bug Fixing: Identify, troubleshoot, and resolve bugs to maintain the stability and reliability of the BI tool. ### Software Engineer Intern @ Sigma Jan 2024 – Jan 2024 | Los Angeles, California, United States - Worked on adding a functionality to create semi-structured data within Sigma - Contributed to ongoing team projects and open issues - Bug fixing and ramp up on more complex internal architecture ### Course Producer @ University of Southern California Jan 2024 – Jan 2024 | Los Angeles, California, United States Course Producer for CSCI 576: Multimedia Systems under Prof. Parag Havaldar for Spring 2024 (10 hours) Responsibilities (Spring 2024): - Assignment Environment Setup - Grading assignments - Dataset Creation for Assignments ### Lead Graduate Teaching Assistant @ University of Southern California Jan 2023 – Jan 2024 | Los Angeles, California, United States Teaching Assistant for CSCI 572: Information Retrieval and Web Search Engines under Prof. Saty Raghavachary for Fall 2023 (20 hours) and Spring 2024 (10 hours) Responsibilities (Spring 2024): - Grading assignments and exams - Conducting office hours - Rubric Reviews Responsibilities (Fall 2023): - Managing a team of 3 TAs and 20 CPs - Helping students with their questions/doubts through Piazza - Conducting office hours - Preparing rubrics for exams and assignments ### Software Engineer Intern @ Sigma Computing Jan 2023 – Jan 2023 | San Francisco Bay Area Working with a compiler team that generates SQL for different data warehouses like Databricks, Snowflake, MySQL, Postgres, Trino, Redshift and BigQuery. Added native JSON support for BigQuery within Sigma. Implemented ArraySlice, ArrayDistinct and Repeat functions for all data warehouses through SQL ### Course Producer - CSCI 585 Database Systems @ University of Southern California Jan 2023 – Jan 2023 | Los Angeles, California, United States Course Producer for CSCI 585: Database Systems under Prof. Saty Raghavachary Responsibilities: Helping students with their questions/doubts through Piazza, Holding office hours, Grading assignments & exams ### Software Developer Engineer @ Amazon Jan 2021 – Jan 2022 | Bengaluru, Karnataka, India Implemented an end-to-end manual suppression functionality for Amazon Pay Later which will suppress the payment method on the Payment Method Page if a third-party lander is down. Extended the Manual Suppression feature by enabling an automated process with the help of continuous monitoring for ASR (Attempt Success Rate). Worked on Amazon Pay Wealth product as a lead software developer, starting with Infrastructure creation, End-to-end implementation, Testing, and Release for over 150 million customers. ### Research Intern @ Dhirubhai Ambani Institute of Information and Communication Technology Jan 2021 – Jan 2021 | Gandhinagar, Gujarat, India Analyzed the robust way to automate the process of finding erroneous data points by finding outliers using the DBSCAN clustering algorithm. Assigned reliability index to each observer to ensure that the quality of the data in the analysis shouldn't be compromised. ### Software Development Engineer Intern @ Amazon Jan 2020 – Jan 2020 | Bengaluru, Karnataka Built end-to-end 1:1 video calling application using WebRTC and Kurento Media Server with the waiting-queue system, the functionality of capturing snapshots and video recording of meetings on the server-side to avoid possible data leaks. Built an Android and iOS mobile application using WebView for rendering web pages inside the application. ### Rural Intern @ navchetna.ngo Jan 2018 – Jan 2018 | Chandigarh, Chandigarh, India Conducted small fieldwork explaining to people the benefits and disadvantages of using plastic money, net banking, etc. Rough plan of making an application for blood donation camp which help people to know the nearest camp details and provide blood to needy people as soon as possible. ## Education ### Master of Science - MS (Honors) in Computer Science University of Southern California ### Bachelor's degree in Information and Communication Technology Dhirubhai Ambani University ### Science Diwan Ballubhai Secondary School ## Contact & Social - LinkedIn: https://linkedin.com/in/purvil-mehta - Portfolio: https://purvil-mehta.netlify.app/ --- Source: https://flows.cv/purvilmehta JSON Resume: https://flows.cv/purvilmehta/resume.json Last updated: 2026-03-31