Ashutosh Goyal

Data Scientist

Faridabad, Haryana, India4 yrs experience

Most Likely To Switch

Key Highlights

Expert in SQL for campaign analysis
Proficient in developing automated dashboards
Skilled in data ingestion and transformation

Stackforce AI infers this person is a Data Analytics professional with expertise in Marketing Analytics and Data Engineering.

Contact

Skills

Core Skills

Data AnalyticsCampaign AnalyticsMarketing AnalyticsData Engineering

Other Skills

AWS GlueAmazon EC2Amazon KinesisAmazon RedshiftAmazon S3Amazon Web Services (AWS)Apache SparkAutomationCustomer InsightDBeaverDashboardingData AnalysisData IngestionData TransformationDatabricks

About

With two years of experience, I am an accomplished data analytics professional adept at leveraging complex SQL for campaign analysis and customer behavior insights across loyalty programs, including email, SMS, and push campaigns. Skilled in designing end-to-end dashboards for automated campaign measurement and manually measuring email, SMS, and push campaign performance. I collaborate with stakeholders to interpret performance metrics, craft SQL queries for ad-hoc reporting, and Always-On campaign measurement. Proficient in data ingestion, transformation, and cleaning using Snowflake, PySpark SQL, and other tools. I bring expertise in developing ETL pipelines, Python scripts for data migration, and utilizing big data technologies like Hadoop, Hive, and Azure Synapse Analytics to extract valuable business insights.

Experience

Target

Data Analyst -Marketing and Digital Analytics

Jul 2024 – Present · 1 yr 8 mos · Bengaluru, Karnataka, India · On-site

Analyzed sales data to identify top categories, brands, and customer favorites, driving the design of products based on customer preferences.
Developed a dashboard to track key metrics including customer preferences, top categories, adoption, coverage, sales lift, and freshness rate.
Automated the tracking process using an in-house automation tool for increased efficiency.
Managed data validation and handled ad-hoc requests to identify and resolve critical issues in email marketing tables.

SQLDashboardingData AnalysisAutomationCustomer InsightData Analytics+1

Alchemy techsol

Data Analyst - Marketing Measurement and Customer Analytics - DACI

Jul 2023 – Jul 2024 · 1 yr · Bengaluru, Karnataka, India · Remote

Client: Lowe's India
Developed end-to-end dashboards that automated the campaign measurement process, reducing the need for manual work and improving efficiency.
Utilized advanced SQL queries to evaluate campaign impact and collaborated with stakeholders to interpret key performance metrics, including incremental sales, margin analysis, and response rates.
Analyzed the effectiveness of various campaign channels, including email, SMS, push notifications, and personalized campaigns.
Specialized in crafting measurement frameworks for Always-On campaigns to derive actionable insights and optimize campaign performance.
Worked on reporting for onsite, Meta, and Yahoo campaigns for top brands, creating reports to analyze spend, ROI, conversions, and sales at placement and creative levels.
QCed the entire customer scorecard at the enterprise-level dashboard by writing over 500 lines of complex SQL queries, identifying critical bugs that impacted numbers by more than 80%, and collaborating with the data engineering team to ensure accurate reporting.

SQLDashboardingCampaign AnalyticsMarketing AnalyticsReporting

Latentview analytics

DATA ENGINEER 1

Oct 2022 – Apr 2023 · 6 mos · Chennai, Tamil Nadu, India · On-site

Worked on data ingestion from Amazon S3 to SNOWFLAKE and transforming and cleaning data through SQL and Python.
Automating data ingestion of different file formats like json ,avro,parquet using Snowpipe in Snowflake.
Created CDC stream ,zero copy cloning , unloading data on cloud using Snowflake.
Created events , notification,triggers using Snowflake.

SQLPythonSnowflakeData IngestionData TransformationData Engineering