Data Analyst specializing in transforming raw data into business impact using
SQL, Python, Excel, and Power BI.
Experienced in experimentation, retention modeling, KPI design, and executive dashboard development.
4 End-to-End Analytics Projects | 25K+ Rows Analyzed | Statistical & BI Modeling
Programming & Query Optimization: SQL (CTEs, Window Functions, Subqueries, Aggregations, Indexing), Python (Pandas, NumPy, Matplotlib)
Analytics & Statistical Modeling: Exploratory Data Analysis (EDA), A/B Testing, Hypothesis Testing, Regression Analysis, Forecasting, Cohort & Funnel Analysis, KPI Modeling
Business Metrics & Strategy: Retention & Churn Analysis, Customer Lifetime Value (LTV), CAC, Revenue Optimization, Conversion Rate Analysis
Data Visualization & BI: Power BI (DAX, Star Schema Modeling, Data Modeling), Excel (Pivot Tables, Advanced Formulas, Dashboards)
Tools & Workflow: Git, GitHub, Jupyter Notebook, VS Code, SQLite, DB Browser, Structured Documentation
Analyzed 25,000+ transactional records using optimized SQL queries and Excel modeling to uncover revenue drivers, VIP customer segments, and product-level trends. Designed full conversion funnel (6.63%) and delivered actionable insights to improve revenue performance and customer targeting strategy.
Designed and executed statistical Z-test in Python to evaluate two landing page variants. Validated statistically significant uplift and recommended rollout strategy with projected 12% improvement in conversion rate. Structured reusable Python scripts with clean modular documentation.
Built cohort retention matrices using SQL and Python to analyze behavioral patterns across acquisition periods. Calculated Customer Lifetime Value (LTV) and identified high-performing segments to support long-term retention and revenue growth strategy. Implemented structured data transformation pipeline for clean analysis.
Designed executive-level Power BI dashboard using DAX measures and star schema modeling. Built centralized KPI layer tracking revenue, customer behavior, product contribution, and operational performance to support data-driven decision making. Delivered interactive reporting framework for stakeholders.