Payal Gore

As part of a cross-functional research team, I work on data-driven public health initiatives that combine statistical rigor with real-world impact. Nutritional Study: Protein vs. Carb Bars We aimed to evaluate how different snack types affect post-meal behavior. I cleaned and analyzed data from 250+ participants using Python (Pandas, NumPy) and Excel. Through exploratory analysis and A/B testing, I discovered that high-protein bars reduced post-meal calorie intake by 20%. These insights directly shaped the product formulation strategy, favoring whey protein and low-sugar variants based on participant preferences. Skills Used: Python · Excel · A/B Testing · EDA · Statistical Analysis Student Engagement Analytics: CRM + Web Tracking In a parallel project, I led the development of a cloud-based pipeline on GCP to understand how students interact with wellness initiatives. I integrated CRM and Google Analytics data for 1,200+ students using BigQuery, DataFlow, and Cloud Functions. Segmenting users into engagement profiles allowed us to identify outreach gaps. I visualized these insights in Looker Studio dashboards, which helped stakeholders redesign campaigns—resulting in a 25% increase in program participation. Skills Used: GCP (BigQuery, DataFlow, Cloud Functions) · Looker Studio · SQL · Data Integration · Segmentation · Behavioral Analytics These projects have deepened my interest in behavioral analytics and product-driven data science, especially where public health and technology intersect.

As part of the BI & Finance team, I contribute to automating revenue analytics and AR reconciliation processes, ensuring financial accuracy and compliance. Revenue & AR Analytics I design SQL/dbt pipelines and Tableau dashboards that track AR aging and revenue flash metrics. These reporting views streamline manual workflows and accelerate month-end close cycles. Financial Compliance & Reporting I support ASC 606 revenue recognition by reconciling outputs from billing data with legacy finance systems, improving reporting accuracy and audit readiness. Skills Used: SQL · dbt · Tableau · Redshift · Data Integration · Financial Analytics · AR Reporting

As a Research Analyst, I contributed to two major initiatives: improving student engagement through behavioral analytics, and supporting online program growth through enrollment insights and market research. Student Behavior Analytics I analyzed usage logs from 1,000+ students to uncover how they engaged with academic collaboration tools. Using SQL and Tableau, I tracked login times, edit frequency, and peer interactions—finding that 35% of highly active users weren’t collaborating with others. To deepen our understanding, I applied time series analysis to uncover peak usage windows and session durations, which helped academic support teams better target outreach. I also collaborated with product managers to define research objectives and shared insights with leadership through visual, presentation-ready reporting. Online Program Growth In a parallel effort, I worked closely with the Director of Online Programs to strengthen Luddy’s digital outreach strategy. I analyzed enrollment trends using R and Excel, uncovering key applicant segments across global vs. domestic pools. I also created Tableau dashboards and delivered competitive landscape analyses, helping leadership differentiate Luddy’s online degrees in a growing higher-ed market. Skills Used: SQL · Tableau · R · Excel · Time Series Analysis · KPI Dashboards · Market Research · Cross-functional Collaboration

Founded and operated a produce retail and wholesale business managing procurement, pricing strategy, and profitability optimization across 15+ perishable product categories. Key Achievements: - Built demand forecasting and pricing frameworks from scratch using Excel, reducing weekly spoilage by 20% and improving profit margins through data-driven procurement and pricing decisions - Analyzed daily sales patterns, supplier costs, seasonal demand shifts, and competitive pricing to dynamically adjust pricing strategy across product categories - Developed supplier cost tracking system that enabled volume-based negotiations, reducing procurement costs while maintaining quality standards - Managed high-velocity, perishable inventory operations requiring real-time pricing adjustments to balance competitive positioning with margin protection - Functioned as a one-person pricing and FP&A operation, applying analytical rigor to optimize revenue, margins, and working capital efficiency Skills: Pricing Strategy · Financial Analysis · Demand Forecasting · Margin Analysis · Excel · Data Analysis · Vendor Management · Profitability Optimization

A community by the students, for the students and of the students where aim was to equip students with technical skills by arranging various workshops, webinar etc.

Project: Mental Health Impact Study During the Pandemic Objective: Understand how the pandemic affected student well-being across different colleges using real-world data. What I Did: Led end-to-end analysis of Qualtrics survey data from 1,000+ students to study the impact of the pandemic on mental and physical health. Cleaned and preprocessed the dataset (handled missing values, encoded categorical variables) and applied both linear and logistic regression using Scikit-learn to uncover the top 5 stress predictors. Found that academic pressure affected 80% of students—emerging as the dominant stressor. What I Built: Developed interactive Power BI dashboards featuring: • Geospatial heatmaps to compare anxiety levels across regions • Campus-type slicers (urban vs. rural) • Clustered bar charts to visualize key demographic stress indicators Insights revealed 40% higher anxiety in urban campuses, enabling targeted wellness strategies across 3 focus regions. Skills Used: SQL · Python · Scikit-learn · Power BI · Regression Analysis · Data Cleaning · Data Visualization · Geospatial Analytics

Course Work: Introduction to Statistics Data mining Applied Algorithms