Parth Shah

Master's

Management Information Systems

Leaf Group

Data Analyst

- Built complex and dynamic SQL queries, to pull data from large data sets within BigQuery SQL and improved - Analyzed historical traffic, engagement, and ad revenue for over 50 websites using data from Google Analytics and BigQuery database - Crafted a data-driven strategy to identify areas for content creation and renewing old content to optimize ROI for website articles - Transformed complex analytical findings into meaningful data stories through data visualization, effectively - Developed automated Tableau dashboards and alerts to resolve website traffic and pin-point page issues - Led a team of 4 to completion of various projects, raising operational efficiency by 70% through automation - Established and optimized ETL pipelines using Dataflow to enforce business rules and metrics, and ensure - Performed data cleaning and pre-processing to analyze data, developed quality and opportunity score - Leveraged machine learning and statistical modeling to identify and predict trends for A/B testing across - Used ARIMA model for forecasting site traffic to allocate budgets to identify best investment opportunities - Boosted the content investment efficiency by 30% leading to an increase in quality and quantity of articles - Delivered compelling presentations to the executive leadership, effectively communicating recommendations and areas of opportunities - Built a Cash Flow Tracking Module using SQL and Python to track revenue and costs to company as a solution to take better business funding decisions, boosting the cashflow by 25% through cross-functional collaboration - Developed Dashboards