mark anand

Data Analyst

Bangalore, KA 560037 2+ yrs exp 85 · Excellent

About

Results-driven Data Analyst with a B.Tech in CSE (Data Science) and proven experience engineering automated data extraction, mining, and visualization pipelines. Expert at processing large-scale datasets exceeding 1M+ records using Python and SQL. Adept at leveraging advanced AI tooling to accelerate scripting workflows, optimize query processing speeds by 30%, and translate complex, raw mined data into structured business insights that improve reporting efficiency by 20%.

Skills & Expertise (20)

Python Intermediate

6.5/10

Years Exp

Data Mining Intermediate

6.5/10

Years Exp

Web Scraping Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.0/10

Years Exp

GitHub Intermediate

6.0/10

0.1

Years Exp

Google Sheets Intermediate

6.0/10

Years Exp

NumPy Intermediate

6.0/10

Years Exp

Matplotlib Intermediate

6.0/10

Years Exp

VS Code Intermediate

6.0/10

Years Exp

Seaborn Intermediate

5.5/10

0.1

Years Exp

Git Version Control Intermediate

5.5/10

0.1

Years Exp

Machine Learning Intermediate

5.5/10

0.1

Years Exp

MySQL WorkBench Intermediate

5.0/10

0.1

Years Exp

Tableau Desktop Intermediate

5.0/10

0.1

Years Exp

AI Prompt Engineering Beginner

5.0/10

0.1

Years Exp

ETL Pipelines Beginner

5.0/10

0.1

Years Exp

ARIMA Beginner

4.5/10

0.1

Years Exp

LSTM Beginner

4.5/10

0.1

Years Exp

Work Experience

Data Analyst / Data Mining Specialist

LenzGig (Ultrabig Tech Pvt. Ltd.)

Aug 2024 - Present

Built Python-based web scraping and data mining pipelines to systematically extract, clean, and structure high-quality creator and 3D/AR market datasets from multiple online platforms. Accelerated weekly reporting and lead collection workflows by 2x by leveraging advanced AI tooling (GPT, Gemini, Claude) to write optimized scraping scripts and automate manual data pipelines. Transformed raw mined datasets into structured insights using SQL, Excel, and Google Sheets, providing critical user-acquisition and platform-growth metrics directly to the founding leadership team. Maintained database integrity by tracking, cleansing, and preprocessing thousands of raw records before importing them into core business tracking sheets.

Data Analyst Intern

Mentorness

Jul 2024 - Aug 2024

Refined complex SQL workflows on large backend databases, increasing insight clarity and query execution speeds by 30%. Processed 10K+ sales records via SQL to identify regional demand patterns, lifting marketing efficiency by 15%. Spearheaded an IPL performance system in Power BI, mapping core operational metrics to reduce stakeholder reporting time cycles by 20%.