Resume
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
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.