Ayesha Khan
Lead Data Analyst & BI Specialist
[email protected] | +92 300 1234567 | Islamabad, Pakistan | https://linkedin.com/in/ayeshakhan-data | https://ayeshakhan.dev
Professional Summary
Lead Data Analyst with over six years of experience across fintech, telecom, and commercial banking in Pakistan. Specializes in building end-to-end SQL/ETL pipelines, executive Power BI dashboards, and automated reconciliation frameworks. Proven track record of reducing month-end close reporting by 35%, resolving high-volume transaction variances, and translating complex metrics into actionable commercial decisions for C-suite management.
Core Competencies
Data Modeling • ETL Pipelines • Business Intelligence • Statistical Analysis • Variance Analysis • Financial Reporting • A/B Testing • Stakeholder Presentation
Technical Skills & Tools
SQL (PostgreSQL, MS SQL) • Python (pandas, NumPy) • Power BI & DAX • Tableau • Advanced Excel (Power Query) • Git • Apache Airflow
Professional Experience
Lead Data Analyst | Finova Digital Pakistan
January 2022 to Present
- Architected 16 production Power BI dashboards utilized daily by 45+ senior stakeholders; cut monthly management reporting cycle from 6 days to 3.5 days.
- Maintained automated SQL validation jobs monitoring 2.8M daily transactional records; resolved ledger variances between branch switches and payment gateways.
- Collaborated with product and growth teams to redefine user onboarding funnels; lifted 30-day active user retention from 18% to 32% within two quarters.
- Migrated 26 fragmented legacy financial spreadsheets into a central PostgreSQL data warehouse, slashing recurring reconciliation discrepancies by 44%.
- Mentored and supervised 4 junior data analysts in SQL optimization, automated DAX reporting, and stakeholder delivery standards.
Senior Data Analyst | ConnectTel Solutions
March 2019 to December 2021
- Developed predictive churn segmentation models across 220,000 active telecom subscribers; targeted retention campaigns improved subscriber stickiness by 9.4%.
- Automated Python ETL cleaning workflows for commercial market share packs, reducing weekly data preparation time from 14 hours to 3 hours.
- Delivered weekly regional sales variance briefings for the Commercial Director covering Islamabad, Rawalpindi, and Northern regions.
- Audited marketing campaign attribution logs with core billing engineering; corrected misaligned billing parameters to recover Rs. 8.5M in unbilled data usage.
Business Intelligence Analyst | Horizon Consulting Group
June 2017 to February 2019
- Formulated statistical sizing models and competitor market share tables in Excel and Tableau for banking and retail client pitches.
- Cleaned, cross-tabulated, and validated empirical survey datasets covering 1,800 consumer respondents across urban Punjab.
- Standardized recurring client reporting documentation, establishing a reusable analytical component library across project teams.
Key Projects & Assignments
- Real-Time Branch Variance & Settlement Pipeline: Engineered daily automated reconciliation pipeline across 18 banking partner channels, reducing discrepancy identification time from 48 hours to under 30 minutes. (https://github.com/ayeshakhan/finova-recon-pipeline)
- Subscriber Churn Prediction Engine: Trained supervised classification models on historical subscriber telecom logs, enabling targeted retention incentives that preserved an estimated Rs. 24M in recurring revenue.
Education & Academic Qualifications
BS Economics and Mathematics, National University of Sciences & Technology (NUST), Islamabad
2013 to 2017
CGPA / Marks: 3.78 / 4.00 CGPA
Dean's Honor Roll (4 consecutive semesters). Final thesis on predictive econometric time-series modeling for consumer inflation indices in Pakistan.
Key Achievements
- Employee of the Year 2023 at Finova Digital for architecting the automated settlement reconciliation system.
- Eliminated Rs. 18M in unallocated transaction suspense accounts within first 90 days of tenure.
Certifications & Training
- Microsoft Certified: Power BI Data Analyst Associate (PL-300), Microsoft (2023)
- Google Advanced Data Analytics Professional Certificate, Google (2021)
Professional Strengths
Cross-Functional Leadership • Stakeholder Communication • Problem Solving • Technical Mentorship
Languages
English (Professional / Fluent), Urdu (Native)
Personal Details
References
- Dr. Farhan Ahmed, Head of Data & Analytics, Finova Digital Pakistan, [email protected]
- Asim Raza, Director of Business Operations, ConnectTel Solutions, [email protected]