SEO Analyst | Marketing Analyst

I’m a Marketing Analyst specializing in SEO and data-driven growth. I have hands-on experience in keyword research, on-page optimization, and performance tracking using tools like Google Search Console, SEMrush, and Looker Studio. With a background in data analysis (Python, SQL), I approach SEO with a structured mindset—identifying opportunities, tracking performance, and continuously optimizing for better results. I enjoy improving website performance, analyzing competitors, and finding new growth opportunities through data.

Pune

mahendrajain1998.mj@gmail.com

8605368329

Download CV

Education

My education qualification

TSSM's Bhivarabai Sawant College of Engineering and Research, Pune

2017 - 2021

Bachelor of Engineering

Studied Computer Engineering with strong foundations in algorithms, computer organization, and operating system concepts.

Experience

My real work experience

The Glocal Resource

Mar 2024 - Present

Marketing Specialist – Analytics & SEO Reporting

Executed SEO strategies including keyword research and on-page optimization
Built dashboards to track SEO KPIs such as CTR and keyword rankings
Conducted competitor analysis to identify new keyword opportunities
Optimized 400+ WordPress pages to improve engagement and performance

Atos

Oct 2021 - Mar 2023

Data Analyst

Worked with Python, SQL, and Power BI to generate business insights
Built interactive dashboards and improved data reliability
Automated data collection using Selenium and BeautifulSoup

Skills

My expertise skills

SEO: Keyword Research, On-Page SEO, Technical SEO, Link Building Basics, SEO Audits, SERP Analysis
Marketing Analytics: Google Search Console, SEMrush, Google Analytics (Basics), Looker Studio
Data Analysis: Python (Pandas, NumPy), SQL, Advanced Excel
Visualization: Power BI, Looker Studio, Excel Dashboards
Tools & Platforms: WordPress, Google Sheets
Automation & Data Collection: Selenium, BeautifulSoup, n8n
AI Tools: Claude, ChatGPT, Gemini

Portfolio

My Recent Works

SEO Performance Dashboard

Built an interactive dashboard using Looker Studio and Google Search Console to track impressions, clicks, CTR, and keyword rankings. Identified optimization opportunities and improved reporting efficiency.

Website SEO Audit Project

Conducted a complete SEO audit, fixing issues like broken links, missing meta tags, and crawl errors. Improved keyword relevance and contributed to better rankings and organic traffic.

👋 Hello