Abu Fraz Abbas
Data Analytics & Engineering Portfolio
📂 Featured Engineering Projects
⚡ Dynamic Business Reporting Pipeline
VBA AutomationA highly optimized data pipeline utilizing advanced Excel VBA scripts to clean, structure, and dynamically map multi-layered business metrics. Engineered to handle large datasets seamlessly, preparing clean historical snapshots for reporting tools.
🛠️ Excel-to-SQL ETL Pipeline
Data EngineeringAn end-to-end automated data pipeline that bridges programmatic Excel data layers with robust database structures. It executes deep data cleaning, maintains versioned local CSV backups, and synchronizes seamlessly with a centralized PostgreSQL server for downstream analysis.
📊 Jewelry Business Intelligence Dashboard
Power BIA premium multi-view analytical solution built specifically for factory and wholesale jewelry ledgers. It integrates dynamic conditional formatting alerts for credit ledgers, an interactive activity aging tracker, time-series sales forecasting, and comprehensive breakdown matrices.
💼 Corporate Ledger & Financial Documentation
Accounting DataA comprehensive professional documentation framework built around Tally Prime processes. Formulated to streamline accounting workflows, corporate ledger bookkeeping audits, and optimized financial report schemas for fast compliance checks.
📐 Mathematical Frameworks for Analytics
Data Science FoundationsAn analytical knowledge repository outlining critical mathematics and core scientific concepts required for quantitative data models. Explores numerical optimization algorithms, statistical reasoning, and technical computational structures necessary for advanced data engineering pipelines.