Rohan Gupta

Data Analyst

Get in touch - LinkedIn, ad06gm@r.postjobfree.com, +1-617-***-****

Work Samples and Projects: GitHub

Boston, MA - Open to relocation, Authorized to work in the US for any employer. Skills

• Languages: SQL (BigQuery, MySQL, SQL Server), Python (Pandas, PySpark, NumPy), Prompt Engineering

• Ecosystems: Snowflake, Google Analytics, AWS, Meta Ads, Hadoop, Marketo, Django

• BI Tools: Google Analytics, Looker, Power BI, Tableau, Advanced Excel, chatGPT

• Core Competencies: Data Modelling, Machine Learning, Big Data Computation, LLM Models, A/B Testing, Statistical Modelling, Quantative Analysis, Extracting & Presenting Insights, Data Visualization Experience

•

Data Analytics Consultant Boston, MA

Kasmo Consulting May 2023 - Present

Conducted Market research on the industry trends, product popularity and pricing, methods of marketing, and advertising to inform marketing strategies, driving 9% increase in share of wallet for Q4.

Queried large financial data sets with 100+ Billion rows to answer ad hoc queries by high level stake holders to provide data driven insights and driving a revenue impact of 10+ million dollars

Created actionable KPIs and reported on channel-wise ad campaign performance metrics using SQL to enable efficient tracking by stakeholders at all levels, reducing lead time to decision making by 3+ days

Designed customer attribution model in Python, calculating accurate baseline and attribution estimates weekly, enabling 11% higher projection accuracy of the attribution KPIs.

•

Data Analyst Boston, MA

Rue Gilt Groupe Jan 2022 - Dec 2022

Examined acquisition channels using statistical analysis and market research to identify key performance drivers and make data driven recommendations, increasing ROI for ad campaigns by 6%.

Streamlined reporting process by designing dynamic Tableau dashboards, enabling real-time monitoring of KPIs and reducing reporting time by 30+ hours per month, enabling rapid decision-making.

Analyzed pre and post data of A/B tests running on email marketing campaigns to understand the impact, and made recommendations leading to an increase in CTR by 21%.

Conducted regression analysis in Python to identify significant predictors of customer churn, resulting in a 12% reduction in churn rate and a corresponding increase in customer retention.

Constructed datasets from existing distributed file systems and external data sources, using SQL, to extract and present insights and enable complex analyses for the 20+ members of the Data team.

•

Data Scientist Ahmedabad, India

Contezy Media Aug 2019 - Dec 2020

Conducted quantitative analysis of subscriber data using a time series model in Python to predict future subscriber trends, increasing marketing spending efficiency by 19% and reducing overspend by 11%.

Utilized regression analysis in Python to identify significant predictors of customer churn, resulting in a 12% reduction in churn rate and a 26% increase in customer satisfaction rating.

Delivered presentations via PowerPoint slides to various clients to drive overall marketing strategy, leading to a 25% boost in client retention through enabling access to data-driven decision-making.

Improved the performance of long running views and stored procedures to reduce load times by 5+ hours in Snowflake data warehouse and Tableau dashboards, thus increasing workflow efficiency. Education

•

Northeastern University Boston, MA

Master of Science in Engineering Management (Specialization: Data Analysis) 2020 – 2023

•

Manipal Institute of Technology Manipal, India

Bachelor of Engineering in Electrical and Electronics 2015 – 2019