Usashi Surajit Roy
Boston,MA
Summary
Data Analyst with 2+ years of experience and a proven track record at Northeastern University, leveraging Python and SQL to enhance data quality and processing efficiency. Successfully automated ETL workflows and developed impactful Tableau dashboards, showcasing strong analytical skills and collaborative problem-solving.
Overview
5
5
years of professional experience
Work History
Assistant Data Analyst
Northeastern University
Boston, Massachusetts
09.2023 - Current
- Automated Tableau Prep ETL workflows to structure Qualtrics survey data, improving data quality, and processing efficiency.
- Gauged survey responses into a 5-point sentiment scale, leveraging NLP BERT with 97% accuracy, and automating data organization.
- Optimized ad-hoc DEI dashboards in Tableau using calculations and interactive parameters, improving user experience by 28%.
- Conducted hypothesis testing of cross-campus performance across 8+ parameters with Python in Tableau to identify improvements.
- Led Snowflake data management for 15+ annual surveys, developing aggregated SQL views that streamlined analytical insights.
Data and Design Analyst Co-op
Northeastern University
Boston, Massachusetts
01.2024 - 08.2024
- Engineered identification of Qualtrics respondents with LinkedIn data via RESTful API, achieving 96% accuracy through Python.
- Orchestrated an ETL pipeline using AWS (EC2, S3, Lambda), and Airflow DAGs, automating structured data incorporation by 94%.
- Automated CDC data ingestion to Snowflake using Stream and optimized SQL views, cutting dashboard latency to 12 seconds.
- Developed Tableau dashboards to analyze career KPIs and trends, enabling the provost to optimize strategies for career outcomes.
- Collaborated with the admin team to troubleshoot failures using CloudWatch and root cause analysis, reducing downtime by 30%.
Data Analyst Intern
GrowHeaven India Enterprises
New Delhi, India
10.2020 - 03.2021
- Streamlined contract expense and funding calculations in SQL with window functions, saving 20 hours of manual work monthly.
- Modernized ARIMA rolling forecast Python scripts for budgeting, reducing preparation time by 70%, while aligning financial plans.
- Generated reports in Tableau, integrating budget-to-actual variance analysis, and KPI tracking, leading to annual savings of 500,000.
Data Analyst Intern
Cybees
New Delhi, India
07.2020 - 09.2020
- Devised data cleaning of customer demographics and website transactions in Excel, enhancing data quality for client reporting.
- Led A/B testing on influencer campaigns, comparing video posts to static images, driving a 25% increase in engagement rates.
- Designed Google Analytics dashboards, analyzed the conversion funnel and audience targeting, driving a 20% increase in ROI.
Education
Master of Science - Data Analytics Engineering
Northeastern University
Boston, MA12.2024
Bachelor of Engineering - Information Technology
Mumbai University
Mumbai, Maharashtra05.2022
Skills
- Python programming
- SQL
- PySpark
- AWS
- Airflow
- Snowflake
- Microsoft Excel
- Tableau
- Power BI
- Google analytics
- ETL processes
- Streamlit
- Alteryx
- Tableau Prep
- Talend
- A/B Testing
- Hypothesis testing
- Statistical modeling
- Decision trees
- Predictive analytics
Projects
Redfin Housing Market Analysis Pipeline | 09/01/24 to 11/30/24
- Processed Redfin housing market data using AWS EMR and PySpark, enabling scalable analytics on large datasets.
- Optimized Jupyter Notebook on EC2 for seamless Spark session management, enabling efficient testing and schema validation.
- Enabled scalable, high-performance analytics on market data, providing insights into housing trends and listings on QuickSight.
Targeted Offer Optimization for Customer Segments | 08/01/23 to 11/30/23
- Analyzed and normalized transaction, demographic, and offer data into Snowflake using SQL to identify offers for cohorts.
- Predicted customer spending basis offers over rolling windows of 240 hours using XGBoost Regressor with 77% accuracy.
- Built a Streamlit app to predict propensity to buy on receiving an offer with 90.8% accuracy, using LGBMClassifier features.
Timeline
Data and Design Analyst Co-op
Northeastern University
01.2024 - 08.2024
Assistant Data Analyst
Northeastern University
09.2023 - Current
Data Analyst Intern
GrowHeaven India Enterprises
10.2020 - 03.2021
Data Analyst Intern
Cybees
07.2020 - 09.2020
Master of Science - Data Analytics Engineering
Northeastern University
Bachelor of Engineering - Information Technology
Mumbai University
Similar Profiles
Gregory Hall, PhDGregory Hall, PhD
Grant Administrator at Northeastern UniversityGrant Administrator at Northeastern University
You SisiYou Sisi
Campus Life Ambassador at Northeastern UniversityCampus Life Ambassador at Northeastern University
Mehdi ZahediMehdi Zahedi
Research Assistance at Northeastern UniversityResearch Assistance at Northeastern University
Katie RiversKatie Rivers
Assistant Coach & Recruiting Coordinator at Northeastern UniversityAssistant Coach & Recruiting Coordinator at Northeastern University
Nahiem CokeNahiem Coke
Environmental Service Aide at Tufts Medical CenterEnvironmental Service Aide at Tufts Medical Center