Ashim Shrestha

Data Analyst & Analytics Engineer | Growth Analytics

Download PDF

// Summary

Data analyst and analytics engineer with 8+ years of experience building end-to-end data pipelines, dimensional models, and reporting systems across fintech, e-commerce, and marketing. Strong hands-on skills in Python and SQL, including query optimisation, automation, and statistical analysis, paired with a track record of turning data into growth outcomes such as 20% acquisition growth, 50% churn reduction, and 18% conversion uplift. Experienced building customer and credit risk segmentation frameworks, dashboards used by 50+ stakeholders, and production-grade pipelines on Snowflake, BigQuery, and dbt. Comfortable working independently across time zones with distributed teams in the US, EU, and APAC.

// Experience

Where I've worked.

Business Insight Analyst Lead

Extensodata (F1Soft International)

Apr 2025 - Present

Kathmandu, Nepal

  • Led a team of 3 analysts on consulting engagements, scoping data deliverables and driving growth-focused insight projects from discovery through delivery.
  • Built a micro-loan eligibility scoring system in SQL and Python, deployed as a customer acquisition marketing tool that drove 20% growth in new customer acquisition for a fintech client.
  • Built transaction categorisation and customer persona pipelines to segment borrowers by spending behaviour and income regularity, feeding targeted acquisition campaigns.
  • Conducted statistical classification modelling on borrower behaviour and credit risk, improving loan approval accuracy by 15% and strengthening default prediction.
  • Designed post-disbursement repayment tracking that surfaced early delinquency signals, shaping credit policy and reducing default risk.

Marketing Analyst

Growthzilla

Jun 2024 - Mar 2025

California, USA (Remote)

  • Built RFM-based customer cohorts using Python and SQL to identify high-value, at-risk, and dormant segments; targeted campaigns lifted conversion rates by 18% and cut CAC by 12%.
  • Designed and executed A/B tests on email marketing campaigns (subject lines, send-time, CTA placement), improving open and click-through rates by 20%.
  • Owned end-to-end customer acquisition and retention reporting, translating weekly performance data into strategy recommendations for leadership.
  • Developed lifecycle marketing dashboards tracking activation and retention milestones to identify drop-off points and prioritise re-engagement.

Senior Business Intelligence Analyst

Daraz (Kaymu Pvt. Ltd.)

Feb 2021 - Mar 2024

Kathmandu, Nepal

  • Built and owned 15+ KPI dashboards tracking GMV, seller health, logistics, and retention for 50+ stakeholders, replacing manual spreadsheet workflows and saving 10+ hours per week.
  • Developed customer and seller segmentation models (SQL and Python RFM, clustering) that reduced churn by 50% and sustained 90% month-on-month retention.
  • Built seller acquisition risk scoring and onboarding quality prediction models, contributing to 75% month-on-month seller growth and a 65% improvement in onboarded seller quality.
  • Designed time-series forecasting models for core marketplace metrics, achieving 30% higher forecast accuracy and enabling data-driven target setting.

Junior Data Engineer

Impetus Inc.

Oct 2020 - Feb 2021

Lalitpur, Nepal

  • Built SSIS ETL pipelines integrating databases, APIs, and flat files into a central warehouse, with SQL-based validation workflows ensuring downstream data quality.

Data Analyst

Delta Creation

Mar 2019 - Mar 2020

Kathmandu, Nepal

  • Built reporting infrastructure and KPI tracking dashboards for finance, operations, and marketing, enabling performance measurement across teams.

Digital Marketing Officer

Janaki Technology (Khalti & Sparrow SMS)

Jan 2017 - Nov 2018

Lalitpur, Nepal

  • Set up Google Analytics tracking and built Looker Studio dashboards to monitor campaign performance and traffic trends.
  • Drove 20% growth in organic traffic, improved search visibility by 10%, and contributed to a 5% uplift in lead generation through SEO and content strategy.

// Skills

Tools and expertise.

Languages

SQL (CTEs, window functions, query optimisation, stored procedures)Python (Pandas, NumPy, Scikit-learn)PySpark

Data Engineering

dbt (incremental models, tests, Slim CI)SnowflakeBigQueryDuckDBApache AirflowDatabricksSSISGit/GitHub Actions

Analytics & Growth

Customer segmentation (RFM, clustering)Cohort analysisFunnel analysisA/B testingChurn predictionLTV/CAC modellingCredit risk scoringTime series forecasting

BI & Visualisation

Power BITableauLookerMetabaseLooker StudioGoogle Analytics 4Google Tag Manager

Domains

Fintech and credit riskE-commerce growthMarketing and lifecycle analyticsLoyalty and CRMKPI strategyCross-functional team leadership

// Selected Projects

A few things I've built.

Customer Transaction Segmentation & Persona Engine

Foneloan, Extensodata

Built a Python and SQL transaction categorisation pipeline using MCC-based mapping to classify spending and construct borrower personas covering spending patterns, income regularity, and financial risk signals, delivered as a reusable scoring framework feeding targeted acquisition campaigns.

NBA Shot Analytics (LeBron James)

Personal Portfolio

Full analytics pipeline on NBA shot data: API extraction to Snowflake with medallion architecture, dbt marts covering shot zones, scoring efficiency, and clutch performance, visualised in Tableau with spatial shot charts.

// Education

Education.

B.Sc. Computer Science and Information Technology

Tribhuvan University

2016

Kathmandu, Nepal