About
Data Analyst with 1.5+ years of experience at CittaAI — an enterprise AI company — building marketing analytics pipelines across Python, SQL (MySQL), Power BI, and Excel. Experienced in data cleaning, EDA, KPI computation, and delivering stakeholder dashboards that drive business decisions. Proven ability to translate raw campaign data into actionable channel insights and spend optimisation recommendations.
Skills & Expertise (23)
Work Experience
SMM & Data Analyst
CittaAI
Aug 2025 - Present
Engineered end-to-end marketing analytics pipelines — ingesting raw multi-channel campaign data (paid search, social, organic), cleaning in Python, and computing KPIs for performance reporting. Designed and deployed interactive Power BI dashboards tracking spend, revenue, ROI, reach, and conversions — used weekly by senior stakeholders for budget and strategy decisions. Automated recurring data cleaning and transformation workflows in Python (Pandas), reducing report turnaround time by ~40% and eliminating manual errors. Delivered channel mix and audience segmentation insights that directly influenced ad spend allocation and content scheduling decisions across campaigns. Identified YouTube as the highest-spend, lowest-ROI channel — recommended reallocation to Google Ads, contributing to ~15% improvement in overall campaign ROI.
Data Analytics Trainee
CittaAI
Nov 2024 - Jul 2025
Analysed campaign performance data across paid and organic channels — identified channel-level inefficiencies and surfaced optimisation opportunities for client account decisions. Built Power BI dashboards and automated Excel reports, enabling internal stakeholders to move from weekly manual reviews to near-real-time performance tracking. Cleaned and validated large datasets (50,000+ rows) using Python (Pandas, NumPy) and conducted EDA using Matplotlib and Seaborn to identify trends and anomalies. Translated data findings into structured business recommendations for marketing and sales teams, supporting faster and more informed campaign decisions.
Independent Quantitative Trader
Self-Employed
Aug 2021 - Jan 2024
Managed a self-directed crypto futures trading portfolio (BTC, ETH, altcoins) — applied quantitative analysis including Fair Value Gaps (FVG), liquidity zone mapping, and multi-timeframe price action. Built systematic trade evaluation frameworks using RSI, MACD, volume analysis, and macro event tracking (Fed meetings, rate decisions) to validate entry/exit signals. Enforced strict risk controls — 1% capital per trade, stop-loss and trailing stops — and maintained detailed trade logs to track win rate, drawdown, and strategy performance over time.
Education
Bachelor of Engineering — Electronics & Communication Engineering - Birla Institute of Technology, Mesra
- 2022 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (23)
Click a skill to find developers with the same skill
