Sonali Gupta

Associate Consultant

New York City, New York, United States6 yrs experience

Key Highlights

  • 5+ years in software engineering and data analytics
  • Director’s Gold Medal for academic excellence
  • Recognized as HSBC’s Star Performer
Stackforce AI infers this person is a Data Engineer with strong software development and analytics skills in the Healthcare and Marketing sectors.

Contact

Skills

Core Skills

Data EngineeringProject ManagementData AnalysisMarketing AnalyticsSoftware DevelopmentBusiness Analysis

Other Skills

Agile Project ManagementAmazon Web Services (AWS)Apache AirflowAzure DatabricksCC++CommunicationDatabasesDjangoEloquaHTMLIT Business AnalysisLeadershipManagementMicrosoft Excel

About

Here's to the ones who dream, foolish as they may seem.Hello there! A little about me.💡 With 5+ years of experience in software engineering and data analytics across insurance, healthcare, media, and software product companies, I bring a unique blend of technical expertise and analytical acumen. I have a proven track record of leading cross-functional requirement-gathering projects, optimizing business systems, and translating business needs into impactful technical solutions.✨ My career journey includes delivering end-to-end projects at HSBC using the SDLC approach, and enhancing enterprise software at Delphix for SAP ASE and SQL Server Databases with Java and Spring Boot — thriving in innovation-driven environments and consistently delivering results. Recognitions such as the Director’s Gold Medal for academic excellence, winning the Delphix Engineering Hackathon, and being named HSBC’s Star Performer highlight my dedication to excellence and problem-solving.🚀 Currently, I’m transitioning into data analytics and project management. As a Data Science graduate student at Saint Peter’s University and an intern with GSK’s Data Strategy and Operations team, I aim to bridge the gap between business strategy and data-driven insights. I bring expertise in Python, SQL, Power BI, Tableau, Databricks and Excel to uncover insights and drive impactful solutions.Proud Member of Rewriting the Code and AnitaB.org, past volunteer at Girls who Code.🌍 Let's connect and explore how we can drive impactful change together!

Experience

Gsk

2 roles

Data Strategy and Operations Co-Op, ViiV Healthcare

Aug 2025 – Present · 7 mos

  • Orchestrated ETL pipelines and dashboards, powering 46 KPIs and 33 visualizations across sales & marketing metrics, used regularly by 15+ senior leaders.
  • Analyzed sales data with SQL and PySpark, sharing insights to 5+ business partners, influencing channel optimization.
  • Compared referral vs. forecast data, automated report generation via Power Automate, reducing manual effort by 90%.
  • Designed dashboards to track patient metrics for Specialty Pharmacy, National & Sub-National (Regional) IQVIA data.
  • Bridged with brand leads & technical teams; Translated business requirements, created stories, shared project updates.
Azure DatabricksSQLPythonApache AirflowProject ManagementData Engineering

Data Strategy and Operations Intern, ViiV Healthcare

Jun 2025 – Aug 2025 · 2 mos

  • Carried out frequent ad-hoc data analysis requests (using SQL, Databricks, Python, Excel, and Power BI) involving cleaning, exploring, and visualizing patient journey data for stakeholders across the company.
  • Supporting data integration and quality assurance efforts using PySpark and SQL, ensuring alignment with ViiV SOPs and data governance policies.
  • Developing process documentation and workflow diagrams, contributing to scalable data operations and improving stakeholder collaboration across hybrid environments
PythonSQLMicrosoft Power BIMicrosoft Power AutomateMicrosoft ExcelAzure Databricks+2

Exl

Analytics Consultant

Dec 2024 – Feb 2025 · 2 mos · Philadelphia, Pennsylvania, United States · Remote

  • 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.
  • Designed and executed targeted emails in Oracle Eloqua, segmenting 3 audience groups by engagement and applying suppression rules, boosting engagement by 5%.
  • Deployed email marketing campaigns to a 250K audience weekly for Business-to Business customers.
SQLAzure DatabricksEloquaProject ManagementTrelloMarketing Analytics

Delphix

2 roles

Senior Software Engineer II

Apr 2023 – Aug 2023 · 4 mos

  • Led end-to-end project execution, from requirement gathering, project planning, scoping, sprint planning, coding, unit testing, and documentation.
  • Functioned as Scrum master, facilitating ceremonies like sprint planning, backlog grooming, running daily standup, sprint review & retrospection.
  • Contributed to product design, and development while collaborating with cross-functional teams to resolve high-priority customer escalations.
Software DevelopmentDatabasesProject Management

Senior Software Engineer

Nov 2020 – Mar 2023 · 2 yrs 4 mos

IT Business AnalysisData EngineeringSoftware DevelopmentBusiness Analysis

Hsbc retail banking and wealth management

Business Analyst / Software Engineer

Jul 2018 – Nov 2020 · 2 yrs 4 mos · Pune Area, India · On-site

  • Involved designing, developing, deploying and supporting Application Programming Interface(APIs) for Quotation Engine for the Insurance team.
  • Developed Java scripts to clean, organize semi-structured CSV data from files to automate preparation of SQL scripts thereby enabling team of 3 to cleanup and update insurance product rates, cutting down time from 12 hours to 30 minutes.
  • Followed Agile methodology for development and testing, used technologies JAVA and Spring Boot.
  • Created a chatbot using GCP Dialogflow to assist and suggest customer best suited insurance products.

Wikimedia foundation

Outreachy Intern

May 2017 – Sep 2017 · 4 mos · Remote

  • Documented how to create Zotero translators for Citoid which is a citation tool of WikiMedia. Created multiple translators in JavaScript that scrape web pages.

Zulip

Google Code-in mentor

Nov 2016 – Jan 2017 · 2 mos · Remote

  • Mentored pre-university students who contributed to Zulip during the duration of Google code-in. Guided students in working with version control system Git, reviewed patches submitted on Github, helped in development of user-guide documents.

Malaviya national insitute of technology jaipur

Summer Intern

May 2016 – Jul 2016 · 2 mos · Jaipur Area, India

  • Drew all possible combinations of intents with source types to save call logs into secure digital card
  • Developed 52 apps (26 pairs) for inter-app communication by varying the source of information and sink to store it. Varied source among activity, service and broadcast receiver. Varied intent type among explicit, implicit and pending intent.

Computer society of india- student chapter

Vice Chairman

Apr 2015 – Apr 2017 · 2 yrs · Jaipur Area, India

  • Managed and coordinated the team in organizing various technical events, workshops and competitions. Mentored students under winter internship programme initiated by the chapter, Vice chair for session 2016-2017, Won Best Accredited Student Branch Award for 2016 and 2017

Education

Saint Peter's University

Master's degree — Business Analytics

Sep 2024 – Feb 2026

The LNM Institute of Information Technology

Bachelor of Technology (BTech) — Computer Science

Jul 2014 – May 2018

Stackforce found 100+ more professionals with Data Engineering & Project Management

Explore similar profiles based on matching skills and experience