Python, SQL, GA4, Excel, R, Power BI, Tableau, Adobe Analytics

YASH SHAH

Edison, NJ ***** +1-848-***-**** ************@*****.*** https://www.linkedin.com/in/yash-shah-263737204 WORK EXPERIENCE

Bright Mind Enrichment & Schooling – Marketing Data Analyst New York, NY July 2024 – Present

* Interpreted campaign performance and ROI trends by translating CAC, CPA, and ROI data into story-driven recap decks, cutting reporting turnaround by 30%.

* Assessed creative and campaign initiatives against engagement and acquisition-cost goals by partnering with creative and content teams, contributing to a 15% reduction in customer acquisition costs.

* Audited marketing data accuracy and integrity by reconciling tagging and attribution gaps across GA4 and CRM integrations, reducing discrepancies by 40% through routine reviews.

* Automated recurring and ad hoc reporting by engineering Python and SQL workflows with AI-assisted scripting, boosting reporting speed by 35%.

* Extracted and verified insights across 100,000+ CRM records by writing SQL joins, CTEs, and window functions, lifting reporting accuracy by 30%.

* Guided marketing stakeholders on audience targeting strategy by converting business objectives into actionable audience and reporting specifications.

* Formulated audience selection criteria by examining customer attributes and campaign objectives, sharpening targeting accuracy and informing strategic segmentation decisions.

* Coordinated recurring campaign performance reviews with internal and external stakeholders, achieving 100% on-time completion and 25% faster approvals.

* Trained team members on CRM and reporting workflows by documenting best-practice tagging guidelines, shortening analyst onboarding time by 50%.

* Supported campaign experimentation and testing initiatives by validating audience segments and CRM data inputs, contributing to a 25% gain in campaign targeting accuracy.

* Enhanced reporting frameworks by standardizing Excel models like VLOOKUP, pivot tables, and INDEX MATCH, reducing ad hoc audience request turnaround by 50%. Rajdeep Technologies – Marketing Data Coordinator Mumbai, India March 2020 – April 2022

* Organized and streamlined marketing operations by managing multiple business requests and campaign workflows, improving tracking efficiency by 25% and cutting reporting cycle time by 60%.

* Analyzed marketing performance trends and campaign metrics by writing SQL queries to extract and aggregate data across CRM and platform datasets, improving reporting accuracy by 35% and turnaround by 30%.

* Built standardized Excel reporting models using VLOOKUP and pivot tables, cutting manual formatting effort by 45% and extending planning visibility by 3 weeks.

* Liaised with cross-functional business stakeholders as measured by improved team coordination by maintaining ongoing communication and aligning priorities across marketing and reporting initiatives.

* Engineered Python-based workflows using Pandas for data cleaning and NumPy and SciPy for campaign performance analysis, streamlining raw marketing data preparation and enabling faster identification of underperforming segments.

* Consolidated 15+ marketing data sources into standardized dashboards, accelerating deployment by 40%. TECHNICAL SKILLS

* Marketing & Analytics Tools: Looker, Google Analytics, Adobe Analytics, Qualtrics, Salesforce Marketing Cloud, Tableau, Power BI, Google Ads, Meta Ads

* Programming Languages: SQL, Python (Pandas, NumPy, Matplotlib, SciPy), R, VBA, SAS

* Software & Tools: MS Excel, MS PowerPoint, Google Sheets, MS Word, Outlook

* Databases & Cloud: Snowflake, SQL Server, Azure, Databricks

* Certifications: Data Analyst Associate, Databricks Generative AI Engineer Associate, AWS AI Practitioner, AWS Cloud Practitioner, SAS Base Programming

EDUCATION

Master’s, Information Systems, Pace University, New York, United States September 2022 - May 2024 Bachelor’s, Computer Science, Mumbai University, Mumbai, India August 2018 - May 2022

Contact this candidate