Open to opportunities

Mirza Ismail Baig

@mirzaismailbaig

Message

Data analyst specializing in LTV/CAC modeling, cohort forecasting, and eCommerce performance insights.

Pakistan

Message

What I'm looking for

I’m looking for a role where I can build LTV/CAC and cohort forecasting, automate dashboards, and translate SQL and analytics into actions that improve retention, profitability, and growth.

I’m a data analyst who turns messy commercial data into clear growth decisions. In my recent role at Clearstem, I built LTV vs CAC models across Meta Ads, Google Ads, and TikTok Shop using Shopify data, and developed rolling 12-month cohort forecasting to project future LTV channel wise.

I also focus on retention and profitability—structuring cancellation reasons into categories to pinpoint churn drivers and identifying key issues (including ~80% of cancellations concentrated in a single SKU). I translate SQL analysis into actionable insights, build and maintain dashboards in Amazon Quick Suite and Power BI, and support ETL workflows so leadership can move fast with clean, reliable datasets.

Experience

Work history, roles, and key accomplishments

Data Analyst

Clearstem

Jan 2026 - Apr 2026 (3 months)

Built LTV vs CAC models and rolling 12-month cohort forecasting for Meta Ads, Google Ads, and TikTok Shop using Shopify data to assess channel profitability and spend optimization. Developed SQL data models and Amazon Quick Suite dashboards to track LTV, CAC, retention, and churn drivers using analyzed subscription cancellation reasons.

LTV Modeling Cohort Analysis Forecasting Performance Marketing Analytics Quick Suite SQL ETL Data Modeling Dashboarding Text Analysis

Pricing Analyst

Astreya LLC

Apr 2025 - Sep 2025 (5 months)

Designed pricing models to optimize gross margin across multiple resource deals and conducted salary benchmarking by country to support customer rate cards. Built Power BI dashboards for automated deal margin analysis and supported ad-hoc profitability assessments aligned to business KPIs.

Pricing Models Salary Benchmarking Power BI Margin Analysis Profitability Assessments

Ecommerce Analyst

Khaadi

Oct 2023 - Mar 2025 (1 year 5 months)

Built a unified eCommerce marketing dashboard in Power BI integrating GA4, Google Ads, Meta Ads, and Salesforce to automate reporting for ecommerce marketing. Analyzed returns and engagement metrics, applied regression analysis in Python for sales sensitivity to temperature across cities, and created dashboards for inventory allocation and sell-through visibility.

Power BI GA4 Google Ads Meta Ads Salesforce E Commerce Metrics Python regression Engagement Metrics Inventory Allocation Dashboards

Senior Seller Marketplace Associate

Alibaba Group Daraz

Oct 2022 - Oct 2023 (1 year)

Led planning and execution of 11:11 and 12:12 campaigns, achieving $8M GMV across five regions. Automated campaign reporting to reduce resource hours, managed SKU alignment and inventory availability, supported seller tool adoption, and optimized promotions based on seller performance.

Campaign Management Marketplace Operations

Transformation Analyst

Aga Khan University

Nov 2021 - Sep 2022 (10 months)

Led transformation initiatives across five supply chain departments to improve operational efficiency. Conducted exploratory analysis of 500K+ data points, redesigned procurement processes delivering $50K in annual savings, and identified $350K potential revenue loss due to poor project oversight.

Supply Chain Transformation Operational Efficiency Data Analysis Process Improvement