SQL
Covid-19 Data Exploration with SQL.
Skills used: Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types
SONALI GUPTA
A graduate student of Masters of Business Analytics at Saint Peter's University and with over 5 years of experience in software engineering, I am now upskilling in the analytics domain and documenting my work and projects here. Combining solid academic foundations with hands-on experience in software development and data analytics, I am keen on advancing in the fields of software engineering and analytics, bringing innovative solutions and expertise to the forefront.
Python + Pandas
Kaggle: Exploratory Data Analysis of Video Game Sales.
Skills used: Statistics, Python, Numpy, Pandas, Visualization
Work experience
Analytics Consultant
EXL Analytics
Dec 2024 - Feb 2025
- Managed email marketing operations for a leading U.S. telecom company, deploying 10+ campaigns weekly to a 250k audience.
- Collaborated with marketing, analytics, creative agencies, and Eloqua developers to align on campaign assets and communication.
- Created and executed marketing campaigns, handling segmentation, email suppressions, and scheduling for on-time deployment.
Senior Software Engineer II
Delphix
Nov 2020 - AUG 2023
- Worked in a 10-member team to enhance & maintain data virtualization products supporting SQL Server & SAP ASE data servers.
- Pioneered a team of 5 developers and QA in implementing read-committed snapshot isolation support for SQL Server data sources.
- Led end-to-end project execution, from requirement gathering, planning, scoping, implementing, unit testing, and documentation.
Software Engineer
HSBC
Jul 2018 - Nov 2020
- Worked in a global team to develop customer-facing insurance projection APIs for Singapore, Hong Kong, and Macau markets.
- Designed a custom ETL process to extract, transform & load insurance data from semi-structured sources to an Oracle database.
- Gathered requirements from business and actuarial stakeholders; Used CI/CD pipelines for code deployment across environments.
Software Intern
Wikimedia Foundation
May 2017 - Aug 2017
- Selected among 39 interns world-wide for the Outreachy open-source program organized by the Software Freedom Conservancy.
- Created documentation for building Zotero translators in JavaScript for research citations in Wikimedia's production environment.
Director's Gold Medal
The LNMIIT GPA 9.34/10