Summary
Overview
Work History
Education
Skills
Accomplishments
LEADERSHIP + AWARDS
Timeline
Generic

SHWETA SANGANI

Jersey City,NJ

Summary

Equipped with strong problem-solving abilities, willingness to learn, and excellent communication skills. Proficient in Python, SQL, and AWS, with a proven ability to optimize processes, reduce errors, and deliver insights through data visualization tools like Tableau and AWS QuickSight.

Overview

10
10
years of professional experience

Work History

Senior Data Analyst

Shift4 Payments
05.2021 - 11.2023
  • Automated bonus payout and quality control (QC) reports using Python (Pandas/Numpy), reducing manual effort and error rates.
  • Created dashboards in AWS QuickSight and Tableau, providing visibility into key revenue metrics and financial insights.
  • Improved data accessibility by 60% through AWS Athena and SQL-based databases for monthly billing and payments.
  • Reduced data lag by 120 seconds in financial reporting processes by optimizing AWS database functions.
  • Saved $3M annually by automating QA processes with Python scripts integrated across EC2, RDS, and S3.

Data Analyst

Mintex Tech
01.2020 - 05.2021
  • Aggregated and structured data from 20+ sources, establishing foundational database structures for new product lines.
  • Eliminated 50% of manual reporting efforts through automated bi-weekly reports in Python.
  • Developed Excel and Tableau dashboards to interpret data insights, aiding strategic decision-making across teams.
  • Performed data cleansing and analysis with advanced Excel functions (pivot tables, v-lookup, conditional formatting).

Analyst

Atos Global
05.2014 - 04.2019
  • Managed client-specific relational databases for optimized data storage, integrity checks, and SQL query performance.
  • Compiled and analyzed data using Excel, presenting key trends and insights to management.
  • Conducted quality checks on 1,000+ datasets using SQL scripts, ensuring data accuracy and completeness.
  • Supported customer service and development teams with data-based problem resolution and causal analysis.

Education

Bachelor of Computer Science -

MVLU College
University Of Mumbai
05.2013

Skills

  • TECHNICAL SKILLS
  • Programming Language: Python, SQL, PL/SQL, HTML
  • Data Visualization: Tableau Desktop, Tableau Server, AWS QuickSight
  • Data Management: AWS Athena, AWS RDS, EC2, Amazon S3
  • Software: MS Word, MS Excel, Outlook, PowerPoint
  • Analytics: Google Analytics, Google Tag Manager

Accomplishments

    Sales Report Using Tableau

  • Developed an interactive sales performance dashboard in Tableau that analyzed store-level sales trends, seasonal patterns, and customer demographics.
  • By visualizing KPIs such as revenue growth, product popularity, and regional performance, this dashboard provided actionable insights that guided marketing and inventory decisions.
  • SQL Injection Analysis Through Basic Queries

  • Designed queries to expose security weaknesses and optimize data protection measures, enhancing query structures to prevent unauthorized access.
  • Strengthened the organization’s database security, reducing vulnerability risks and supporting compliance with data protection standards. The initiative led to the development of a secure query framework that served as a template for future projects.

LEADERSHIP + AWARDS

  • High Potential Resource – Atos Global, Oct 2016
  • Pursuing: AWS Certified Data Engineer - Associate
  • AWS Certified Cloud Practitioner – Nov 2022
  • ITIL V3 Foundation – Jan 2015

Timeline

Senior Data Analyst

Shift4 Payments
05.2021 - 11.2023

Data Analyst

Mintex Tech
01.2020 - 05.2021

Analyst

Atos Global
05.2014 - 04.2019

Bachelor of Computer Science -

MVLU College
SHWETA SANGANI