Sumary

Swastik Tripathi

Data Analyst skilled in communicating with stakeholders and management, gathering requirements and translating them into technical solutions. Strong analytical, critical thinking, and problem-solving abilities. Experienced in SQL, Excel, DataBricks, PowerBI, Tableau.

  • India
  • +91 9123998339
  • swastiktripathi10@gmail.com

Experience

PwC

Data, Analytics and Technology Solutions | Associate

Kolkata, West Bengal, India

Oct 2025 - Present
  • Supported 20+ parallel client engagements, including multiple high-profile accounts, rapidly adapting to diverse data systems and delivering consistent, high-quality ETL pipelines, reconciliations, and analytical outputs.
  • Performed multi-stage data analysis on large financial and operational datasets using SQL, Excel, and Databricks (PySpark) and Snowflake to support audit and compliance engagements.
  • Executed data transformations, validation checks, and reconciliation workflows to ensure completeness, accuracy, and audit readiness of multi-source client datasets.
  • Communicated findings, anomalies, and validation issues directly to managers and client stakeholders, enabling faster decision-making and resolving data inconsistencies under tight timelines.

TrainerGoesOnline.com

Business Operations & Financial Analyst Intern

Vile Parle, Mumbai, India

Jun 2025 - Aug 2025
  • Built optimized Power BI dashboards and integrated multi-source datasets, reducing data processing time by 50% and delivering insights for daily founder briefings on company performance and strategic initiatives.
  • Automated lead-tracking and operational workflows using Looker and SQL, enabling real-time visibility for outreach/sales teams and contributing to a 5% reduction in related operational expenses.

Education

B.Tech in Computer Science and Engineering

West Bengal University of Technology

2021 - 2025

CGPA : 8.89

Higher Secondary (Computer Science) - CISCE

St. Thomas' Church School

2019

Percentage : 73.2

Secondary (Computer Science) - CISCE

St. Thomas' Church School

2017

Percentage : 92.3


Co-Curriculur Activities

GDSC Lead (aka GDG on Campus Organizer)

Google Developers Group

Sep 2024 - May 2025
  • Organized and led 7 successful tech events while managing a 30-member team; managed stakeholders, analyzed engagement data to optimize processes, and fostered collaboration, growing membership from 900 to 1,350.

Content and PR Coordinator

Newton School Coding Club

Sep 2022 - Aug 2024
  • Led and executed content, PR, and educational initiatives as a founding member—creating promotional materials, organizing seminars and online events, and building collaborations with clubs and students.

Certifications

Career Essentials in Data Analysis by Microsoft and LinkedIn

Microsoft

2024  Link

Career Essentials in Business Analysis by Microsoft and LinkedIn

Microsoft

2024  Link

Tata Group Data Analyst Job Simulation

Tata Group

2024  Link

Python for Data Science, AI & Development

IBM

2024  Link

Data Analysis with R Programming

Google

2024  Link

Amplitude Foundations

Amplitude

2024  Link

Python And Django Framework For Beginners Complete Course

Udemy

2024  Link

Data Structures and Algorithms Specialization

University of California San Diego

2024  Link

Entrepreneurship: Growing Your Business Specialization

University of Virginia

2024  Link

Achievements

Winner in Arduino Based Intra-College Competetion

Juno at BPPIMT

2023
  • Secured first place in the annual competition by designing a weather monitoring system to track environmental changes such as temperature, humidity, and precipitation.

Runner-up in Entrepreneurial Pitch Presentation

B-Plan at BPPIMT

2023
  • Developed a detailed business plan for a jute-based product line, recognized for innovative market analysis and a practical approach to addressing market opportunities.