Aryan Farswan

Data Analyst

80 · Excellent

About

Data Analyst with hands-on experience translating business requirements into data-driven solutions – writing SQL queries, building Python-based analysis pipelines, and developing dashboards that surface actionable insights for stakeholders. Skilled in identifying trends and opportunities through exploratory data analysis across large datasets, and in communicating findings clearly to both technical and non-technical audiences. Seeking to bring strong analytical and stakeholder-management skills to a Business Analyst role supporting product, operations, and leadership decision-making.

Skills & Expertise (48)

Power BI Advanced

8.3/10

Years Exp

Python Advanced

8.2/10

Years Exp

Data Visualization Advanced

8.1/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Statistical Analysis Intermediate

7.8/10

Years Exp

Machine Learning Intermediate

7.5/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

Data Quality Data Integration Data Governance GitHub Data Validation Spreadsheets XLOOKUP VBA Git Advanced Microsoft Excel Jupyter Notebook FastAPI Streamlit AWS Analytical Thinking Problem-solving Communication Attention to Detail Critical thinking Tableau Operational Reporting Data Storytelling Stakeholder Management Cross-Functional Collaboration Pandas Matplotlib Plotly Postgresql MySql Power Pivot Dashboard Development Exploratory data analysis Trend Analysis Root Cause Analysis Predictive Analytics Data Modeling KPI Reporting Pivot Tables Power Query

Work Experience

Data Analyst

SaaS Churn Prediction & Retention Intelligence Platform

Present - Present

Translated business requirements into analytics-ready SQL and Python data pipelines for 10,000+ user behavioral records, enabling efficient data management, KPI reporting, customer performance analytics, and operational reporting. Analyzed customer behavior, funnel conversion, retention metrics, and churn drivers to generate actionable business insights, translating business requirements into analytical solutions for stakeholder decision-making. Developed a real-time predictive analytics platform achieving 79.2% recall, enabling proactive customer retention through automated analytical reporting, churn risk monitoring, and business insights.

Data Analyst

Ecommerce Sales & Customer Analytics Dashboard

Present - Present

Developed a 6-page interactive Power BI dashboard analyzing 1,000 ecommerce transactions, by building a star schema, using Power Query, and creating 20+ DAX measures to track revenue, profit, customers, returns, and marketing performance. Identified key business opportunities, uncovering that 84% of customers generated 95.2% of revenue and discounts above 20% led to loss-making orders, by implementing customer segmentation, KPI dashboards, and dynamic DAX analysis. Improved decision-making, highlighting that returns reduced profit by 5.12K (7.18%) and Organic Search was the top-performing channel, by developing interactive visualizations and advanced profitability analysis.

Data Analyst

Bank Loan Risk & Performance Analysis

Present - Present

Analyzed 38.6K+ loan applications and $435.8M in funded loans using Advanced Excel, identifying a 13.82% charge-off rate and key portfolio trends through operational data analysis. Developed an interactive Excel dashboard with KPI reporting, operational reporting, and dynamic visualizations to monitor $473.1M in repayments and support data-driven business decisions. Performed trend analysis on borrower profiles, loan purposes, and repayment terms, identifying a 47% concentration in Debt Consolidation loans and elevated risk among 60-month loans to support business reporting and portfolio analysis.