Pricing & Margin Analytics
Integrates product, list price, discount, rebate, and cost data to compute net price, margin, and waterfall KPIs. Provides time-series marts by region, segment, and channel, powering exec dashboards and pricing playbooks.
Finance — Data Engineering & Analytics
Projects spanning pricing, forecasting, fraud, and valuation — building data foundations for financial decision-making.
Featured Finance Projects
Financial Forecasting Pipelines
Automated ingestion and modeling for sales and margin forecasts by product and region. Uses Python-based models scheduled via Snowflake Tasks / Airflow, with outputs feeding planning dashboards.
Transaction Fraud Analytics
Processes streaming transaction events into a fraud monitoring mart with features like velocity, geo-distance, device fingerprints, merchant risk, and rule/ML scores. Supports alert queues and analyst workflows.
Treasury Cash Flow & Liquidity Analytics
Consolidates AP, AR, and bank statement data into a unified view of cash position, short-term forecasts, and covenant metrics. Supports working capital analysis and scenario planning.
Valuation & DCF Analytics Workspace
Python-based toolkit for DCF valuation including UFCF modeling, WACC, sensitivity tables, and scenario analysis. Integrates with spreadsheets / BI for analyst-friendly interfaces and audit trails.
What this demonstrates
- Designing financial data models for pricing, forecasting, treasury, and fraud.
- Combining SQL, Python, and BI for end-to-end analytics delivery.
- Building valuation and DCF tooling aligned with finance practice.