Sonali Gupta's Portfolio

Hi,
I'm Sonali Gupta

I'm a

Seeking Full-Time Opportunities in Data Engineering, Analytics, Project Management | MS Business Analytics @ SPU | Data Operations Co-Op at GSK | Ex-HSBC, Delphix, EXL Analytics | Expertise in Project Delivery, Data Engineering, Analysis, Product Roadmaps and everything in between that contributes to successful project delivery. Open source lover.

About Me

Data Engineer & Analyst

Hi there! I’m Sonali Gupta, a Master’s student in Business Analytics at Saint Peter’s University. Over the past 5 years, I’ve worn multiple hats in my professional journey — from starting as a Software Engineer at HSBC to becoming a Lead Engineer at Delphix. I grew from fixing bugs to leading teams, designing, and delivering end-to-end projects, collaborating with multiple stakeholders, embracing the challenges of every role along the way. Currently turning data chaos into clarity, I specialize in leveraging technologies such as Python, Spark, SQL, Power BI, Databricks, and Airflow to transform complex datasets into actionable insights that optimize business outcomes. I am currently seeking full-time opportunities in Data Engineering and Business Analytics, where I can apply my skills to drive impactful, data-driven solutions.

Experience

Jun, 2025 - Present

Data Strategy and Operations Co-Op - GSK

Acted as a liaison between brand leads and technical teams by translating business needs into clear development deliverables through comprehensive user stories, sharing Gantt-based project updates and collecting feedback./li>
Orchestrated a data pipeline setup to extract, transform and model patient journey data for 46 metrics (spanning sales, performance, market access and digital engagement), to power 33 trend charts, improving analytical visibility for 15+ stakeholders.
Led an international team of four; Cultivated relationships with cross-functional teams in the Insights and Analytics department to align business requirements with deliverables, support end-user reporting queries, troubleshoot, and drive successful project outcomes.
Automated Reporting: Built and deployed a Databricks pipeline to automate and validate weekly reporting of referrals vs. forecasted goals, integrated Power Automate for 100% automated distribution, enabling senior leadership to access time, data-driven insights.
Documented process flows, data flow diagrams between systems in MS Visio, summarized insights through PowerPoint and Excel.

Dec, 2024 - Feb, 2025

Analytics Consultant - EXL

Worked as an email marketing analyst contracted by EXL Analytics for a leading telecom company, deploying campaigns to a 250K audience weekly.
Client Engagement: Drove project alignment and timely delivery by monitoring progress in Smartsheet, leading client status calls, and strengthening cross-functional communication.
Executed an A/B test to optimize Samsung Galaxy email campaign, increasing click-through rates by 10% and conversion by 5%.
Deployed 10+ weekly campaigns, collaborating with 3 client teams to ensure 100% on-time delivery and cut errors by 15%.

Nov, 2020 - Aug, 2023

Senior Software Engineer II - Delphix

Design & Development: Led end-to-end project execution, including requirements gathering, preparing detailed solution design documents, delivery and documentation, ensuring high-quality releases of database virtualization enterprise software features.
Partnered with the customer support team to develop a prioritization pipeline for feature enhancements, aimed at reducing customer support cases and achieving quarterly performance targets.
Production Support: Resolved high priority service tickets in collaboration with support and engineering teams, achieving quick turnaround times, minimal business disruption, and improved customer satisfaction.

Jul, 2018 - Nov, 2020

Software Engineer - HSBC

Designed a process to extract, transform and load (ETL) insurance rates data from semi-structured sources to Oracle database, resolving data quality issues and improving efficiency by 80%.
Spearheaded Agile Scrum adoption, leading sprint planning, retrospectives, and daily stand-ups, optimizing collaboration and delivery.
Worked in a global team to develop 10+ customer-facing insurance projection APIs for Singapore, Hong Kong, and Macau markets.
Participated in 15+ API releases while applying industry best practices, performed and documented root cause analysis to mitigate risk.

Education

2024 - 2025

Master of Science in Business Analytics - Saint Peter's University, New Jersey

CGPA - 3.94

Relevant Courses: Data Analysis and Decision Modelling, Statistics, Data Visualization with Power BI, Corporate Finance and Economics, Data Science with Python

2014 - 2018

Bachelor of Technology in Computer Science - LNMIIT

Grade - 9.34

Relevant Courses: Computer Programming, Algorithms, Database Management Systems, Big Data Analytics, Advanced Mathematics, Operating Systems, Computer Networks, Business Visualization, Cloud Computing, Artificial Intelligence

Tech Stack

Languages and Tools

SQL, Python, Pandas, Matplotlib, Seaborn, Databricks, PySpark, Airflow, Snowflake, Jira, AWS, Git

Data Visualization and Reporting

PowerBI, Tableau, Microsoft 365(Advance Excel, PowerPoint, Word, Visio)

Databases

SQL Server, SAP ASE, Oracle DB, PostgreSQL, Teradata, Snowflake

Latest Projects

AI Shakespeare NLP-Driven Text Generation

Utilizing NLP and deep learning to generate text in the style of William Shakespeare. Based on LSTM neural networks.

Telco Customer Churn Analysis

Predicting customer churn for a telecommunications company using supervised machine learning techniques.

Amazon Product Comparator

A tool designed to revolutionize the way consumers engage with e-commerce by enabling efficient product comparisons on Amazon.

Visual Analytics of the Meta Kaggle Dataset

Comprehensive analysis of the Meta-Kaggle dataset to explore trends within the Kaggle community.

Social Media Mining

Research proposals and papers detailing analyses on various topics using data from social media APIs and sentiment analysis.

Hi, I'm Sonali Gupta