Data Analyst/ Intern

SHREY VACHHANI

Boston, MA +1-508-***-**** linkedin.com/in/shreyvachhani ***************@*****.*** EDUCATION

University of Massachusetts Boston (3.5 / 4.0) Sept 2021 - May 2025 Concentration: Business Intelligence

Bachelor of Science, Information Technology

Coursework: Data Structures and Algorithms, Relational Databases, Calculus, Statistics, Discrete Mathematics, Programming in Python, Data Communications and Networking, Online Analytical Processing, Data Warehousing, Web Analytics, Cloud Information Management (AWS), Managerial Decision Making, Operations Management, Project Management, WBS (Work Breakdown Structure), Information System Security. SKILLS

Data and Analytics: SQL (Advanced), PostgreSQL, R, Tableau, Data Cleansing, Visualization, Aggregation, Warehousing, ETL Pipelines, Data Modeling, Pandas, NumPy, Matplotlib, Seaborn, Scikit. Programming: Python, Java, C, C++, Algorithm Development, Object-Oriented Programming, Scripting and Automation, Version Control (Git), Scala.

Cloud and Tools: AWS (EC2, S3), Snowflake, Agile, REST APIs, PySpark, GitHub AI/ML Tools: OpenAI API, Google Cloud AI, Azure AI Web & Scripting: JavaScript, HTML, CSS, JSON

Platforms: Visual Studio, PyCharm, Sublime, Terminal, Windows, MacOS, Linux Microsoft Office Tools: Excel, Word, PowerPoint, Access, Visio Certificates: Google Data Analytics Professional Certificate: Coursera. Penn Computational Thinking for Problem Solving in Python Language: Coursera. Six Sigma Black Belt certification : Project Management Institute, Inc. WORK EXPERIENCE

Roessel Joy LLC May 2024 - Aug 2024

Data Intern

• Streamlined ZOHO to Salesforce migration, cutting data errors by 30% via standardized formatting and automated validation.

• Collaborated with a cross-functional team of 4 to define data integrity metrics, leading to 25% fewer post-migration corrections.

• Managed and cleaned structured datasets using Excel, working with over 10,000+ rows of client data for reporting & reconciliation.

• Conducted preliminary data assessments to flag inconsistencies, contributing to a smoother Salesforce migration process. PROJECTS

Contact Management System (Python, Pandas, CLI)

• Built a modular CLI-based system that managed 500+ user records with search filters, tag classification, and timestamp-based sorting.

• Integrated Pandas for structured data transformation and storage, improving data retrieval speed by 38%.

• Designed algorithmic logic for fuzzy search and attribute matching, reducing user query time by 2x.

• Resulted in a 40% faster task completion rate in test scenarios. Data Cleaning Project (SQL, Pandas, Python)

• Developed an automated ETL pipeline processing ~600 cross-source records/week, reducing manual effort by 60%.

• Implemented real-time schema validation alerts, resolving 95% of schema mismatches within 24 hours and preventing data corruption across three critical data environments at the organization.

• Added audit logging and error reporting, enabling real-time visibility and reducing transformation bugs by 70%.

• Enhanced data type enforcement and schema validation, enabling consistent ingestion across 3 data environments. Exploratory Data Analysis Project (EDA, Tableau, Python)

• Analyzed 10K+ rows of layoff data to identify trends across region, size, and funding stage.

• Created dashboards in Tableau that displayed KPIs by time, geography, and sector, used in a 5-member strategy presentation.

• Constructed trend visualizations with Seaborn/Matplotlib, including funding-stage correlation heatmaps, which substantiated the hypothesis that early-stage startups experienced 2.3x higher layoff rates. Restaurant Web Application (HTML, CSS, JS)

• Designed a responsive app with booking, menu, and feedback features; tested across 10+ devices for cross-compatibility.

• Applied media queries and JavaScript validation to reduce UI errors by 45%.

• Launched 3 A/B UI iterations that improved user feedback ratings by 25% in controlled testing. CupidPlan: AI-Powered Dating App

• Developed an AI-driven match suggestion and event planning engine leveraging OpenAI and third-party APIs.

• Engineered a personalized user messaging system that tailored communication based on customer behavior, improving engagement metrics and contributing to a 30% increase in repeat bookings and user retention over six months.

Contact this candidate