Ayesha Khan
Senior Data Analyst
[email protected] | +92 300 1234567 | Islamabad, Pakistan | linkedin.com/in/ayeshakhan-data | ayeshakhan.dev
Professional Summary
Senior Data Analyst with six years across banking, telecom, and SaaS reporting in Pakistan. Builds SQL pipelines, Power BI dashboards, and recurring variance packs for finance and product teams. Known for fixing broken source data, tightening month-end close, and writing bullets managers can paste into board slides without edits.
Core Skills
Data Analysis • SQL • Python • Power BI • Tableau • Excel • A/B Testing • Forecasting • ETL • Stakeholder Reporting • Metric Design
Technical Skills
SQL • Python (pandas, NumPy) • Power BI • PostgreSQL • Tableau • Excel • Git
Work Experience
Senior Data Analyst | Finova Digital Pakistan
January 2022 - Present
- Own 14 Power BI dashboards used by 40 stakeholders; cut monthly reporting time 35% and raised accuracy from 81% to 97%.
- Maintain SQL jobs on 2.4M monthly transaction rows; finance gets same-day variance splits by branch and product.
- Defined onboarding funnel metrics with product; activation increased 14% within two quarters.
- Migrated 26 legacy Excel workbooks to a warehouse model; reconciliation errors dropped 28%.
- Coach three junior analysts on QA checks, metric definitions, and stakeholder sign-off.
Data Analyst | ConnectTel Solutions
March 2019 - December 2021
- Segmented churn risk across 180,000 subscriber records; retention offers lifted 9% in targeted cohorts.
- Automated Python cleaning for weekly market packs; preprocessing time down 42%.
- Published Lahore and Islamabad sales variance notes every Monday for commercial leadership.
- Validated campaign attribution tags with engineering; reporting mismatch fell 22%.
Junior Business Analyst | Horizon Consulting Group
June 2017 - February 2019
- Built sizing models and competitor tables in Excel and Tableau for retail and fintech proposals.
- Cleaned survey data from 1,200 respondents for two go-to-market studies.
- Documented recurring client dashboards so handoffs stayed consistent across rotations.
Education
BS Economics and Finance, National University of Modern Languages, Islamabad
2013 - 2017
Focus: econometrics and applied finance. Thesis on treasury yields vs equity returns in Pakistan stress windows.
Google Advanced Data Analytics Certificate, Google Career Certificates
2021 - 2021
Regression, hypothesis testing, Tableau stories, stakeholder decks.
Certifications
- Google Advanced Data Analytics, Google (2021)
- Google Business Intelligence, Google (2022)
Languages
English (Professional), Urdu (Native)