Senior Data Analyst

Shruti Amin

Tyngsboro, MA, *****, United States,

978-***-****, ************@*****.***

US CITIZEN

Summary

Results-driven Senior Data Service Analyst with over 10 years of experience in data analysis. Proficient in automating ETL processes and developing advanced dashboards using Tableau and Power BI, optimizing data management for strategic decision-making. Successfully led teams to improve data accuracy and integrity, supporting business growth across multiple organizations.

Work Experience

Senior Data Service Analyst, Zeta Global 08/2022 – 07/2025

New York, NY

Extracted and validated data from multiple internal and external sources using advanced SQL (PostgreSQL); managed FTP/SFTP file transfers and assessed DBT-based ETL pipelines to ensure data integrity and business alignment.

Designed, managed, and troubleshot batch processing systems for large-scale data workflows across cloud-based (e.g., Snowflake) and on-prem environments, ensuring stability, scalability, and minimal downtime.

Implemented ETL pipelines using Python and loaded data into a Snowflake-based data warehouse.

Designed and deployed automated ETL pipelines in Python and Snowflake, reducing manual processing time by 40%

Collaborated with cross-functional teams to establish data accuracy requirements and bolster data cleaning initiatives.

Built and maintained real-time dashboards tracking KPIs and performance metrics, enabling rapid detection of anomalies and actionable business insights.

Partnered with business stakeholders and BI teams to translate requirements into SQL-based transformations and Snowflake models.

Collaborated with business partners and QA teams to define test scenarios, acceptance criteria, and issue triage workflows.

Ensured data quality and consistency through validation checks, transformation logic, and version control during data migration.

Designed and implemented scalable data models using star and snowflake schemas, supporting advanced analytics and reporting needs.

Developed and maintained executive-facing dashboards to visualize client data and performance trends across weekly, monthly, and quarterly cycles.

Drove testing and implementation phases of automation solutions, guaranteeing high-quality delivery within project deadlines.

Senior Data Analyst, Unifirst 01/2021 – 08/2022

Wilmington MA

Extracted and manipulated extensive datasets using TOAD to facilitate data-driven decision-making processes across the enterprise.

Validated source data for completeness and accuracy, strengthening support for database platform migrations and conversions.

Spearheaded the testing and validation of ETL processes, ensuring that data loaded into target databases fulfilled business transformation requirements.

Customized SQL scripts for automated recurring reports, minimizing manual effort and enhancing report accuracy.

Contributed to IBM iSeries (AS/400) to Oracle migration efforts by analyzing legacy data structures, validating record-level accuracy, and ensuring integrity during transformation and load stages.

Collaborated with cross-functional teams to develop and maintain Tableau reports, delivering valuable graphical insights into business data.

Validated data for completeness and consistency across systems, supporting seamless platform migrations and data conversions.

Executed ad-hoc data queries to identify and rectify data inconsistencies, thereby improving data quality across systems.

Used TOAD for data extraction and manipulation, supporting enterprise-level decision-making.

Created Power BI dashboards with drill-down capabilities and trend visualizations, enabling executive-level insight into performance metrics.

Structured and analyzed data using statistical techniques, providing detailed reporting for decision-makers.

Developed Java applications with JDBC to interact with Oracle and MySQL databases for real-time data processing.

Implementation Data Analyst, Syndigo 05/2017 – 12/2020

Waltham MA

Engaged with business users to gather requirements and deliver effective solutions for data-related issues.

Enhanced data export/import performance by optimizing Oracle and SQL procedures, functions, and queries.

Supported data and reporting migrations from Oracle to SQL Server, including rewriting complex SQL queries, adapting stored procedures, and aligning data types and logic between platforms.

Engineered ETL processes using Pentaho Data Integration (Kettle) to extract, transform, and load data from diverse sources into data warehouses.

Automated manual procedures using Kettle and compiled comprehensive documentation on data processing workflows.

Provided analytical resolution for data-related issues, ensuring consistency and accuracy throughout.

Created ETL mapping documents to define data flow from source systems to target databases.

Data Analyst, Environmental Health and Engineering 10/2011 – 07/2016

Newton MA

Designed and developed custom SharePoint applications utilizing SharePoint Developer/Designer and Nintex workflows.

Created SharePoint 2010 applications and integrated them with data using Access, Excel, and Nintex workflows.

Developed SQL queries to facilitate data migration between SharePoint and SQL servers.

Constructed dashboards in Power BI using Excel data, sharing reports with to support strategic planning.

Education

Stevens Institute of Technology 09/2010 – 05/2014

Master of Science, Computer Science. Hoboken NJ (2014)

GPA: 3.30

Gujarat University 08/2004 – 05/2008

Bachelor of Engineering, Information Technology. Ahmadabad India (2008)

GPA: 3.70

Skills

SQL

Analytical abilities

MySQL

Java

PostgreSQL

Pentaho

DMexpress

Dataflow

SSIS

TOAD

SQL Server

Oracle

Snowflake

MongoDB

Google Big Query

MySQL

Python

SSRS

Tableau

Power BI

Apache Airflow

Kafka

Jaspersoft

Postman

Citrix

Git/SourceTree

AWS (S3)

Grafana

Bitbucket

PowerShell

Informatica

HTML

XML

Agile (Scrum)

Kanban

JIRA

Confluence

Communication

JSON

Problem Solving

Troubleshooting

Root cause analysis

People skills

Collaboration

Documentation

Teamwork

Matillion

Master Data Management

Positive Attitude

Debugging

Microsoft Office

Power BI

Linux

Data Engineering

Data Modeling

Big Data Solutions

Data Visualization

Data Warehousing

SDLC

Waterfall methodologies

Contact this candidate