Zainab Aftab

Analytical and result-driven Data Analyst & CRM Specialist with a strong foundation in Computer Science (BSCS). Expertise in building scalable relational databases, developing end-to-end ETL pipelines, and deploying automated data-wrangling architectures in Python. Proven track record in customer churn optimization, advanced predictive modeling, and designing enterprise-level Business Intelligence tools (Power BI, Tableau, Advanced Excel) with complex DAX scripting.

Adept at bridging technical data systems with executive business strategy to unlock actionable insights and maximize ROI.

Data Analyst & CRM Specialist at Sales & Customer Analytics Enterprise Initiative (2024-01 – 2024-05)

• Architected automated ETL workflows and optimized central Data Warehousing infrastructure across 50,000+ complex transactional records, directly eliminating 15 hours of manual structural reporting work every single week.
• Engineered highly relational analytical databases and programmed high-performance SQL scripts (Window functions, advanced JOINs, subqueries) to systematically accelerate query execution speed by 35% across 10+ business-critical tables.
• Programmed robust automated data cleaning systems, missing value arrays, and operational data wrangling frameworks using Python (Pandas, NumPy), ensuring 100% downstream data integrity and pipeline accuracy.
• Deconstructed advanced CRM analytics matrices and customer lifecycle segments for over 5,000 active user profiles to isolate churn patterns and deliver clear retention strategy frameworks to key corporate stakeholders.
• Spearheaded data storytelling operations and delivered weekly strategic visual dashboards to a cross-functional board of 8 department managers, explicitly guiding data-driven commercial pivots.

Business Intelligence Analyst & CRM Specialist at Interactive Executive Analytics Initiative (2023-08 – 2023-12)

• Designed and customized real-time BI and CRM tracking panels inside Power BI and Tableau utilizing complex cross-functional DAX modeling formulas, deep relational charts, and advanced metric-driven trend slicers.
• Automated financial performance tracking dashboards and underlying metric extractions using Excel Power Query, complex VLOOKUP tables, and advanced PivotTables, systematically cutting report generation cycles by 40%.
• Evaluated end-to-end customer lifecycle health metrics and active sales funnel leakage points to explicitly isolate, forecast, and reduce user churn across 3 major high-revenue commercial product lines.

Bachelor of Science in Computer Science (BSCS) – Virtual University of Pakistan (2020-10 – 2024-10)