Data Warehousing & Business Intelligence
Current- Spearheaded the management of 10+ Telerik Reporting projects, including both dashboard and detailed report designs, ensuring insightful and actionable analytics.- Developed and launched 3+ financial dashboards using Telerik and Node.js, delivering real-time insights for financial performance monitoring.- Led the development and automation of over 10 synchronized stored procedures, streamlining ETL processes through SQL Agent and Cron Jobs for efficient data integration.- Engineered and maintained 5+ Python ETL scripts, facilitating seamless data transfer and storage into the Clickhouse data warehouse, optimizing data processing capabilities.- Analyzed and managed large-scale sales data, ensuring data integrity and readiness for ETL workflows, contributing to improved data accuracy and business intelligence.- Created and managed 5+ dynamic Excel financial reports by integrating API data with Power Query, enabling faster decision-making and reporting processes.- Designed and maintained APIs using Node.JS to enable data retrieval across various databases, including Clickhouse, Oracle, and SQL Server database, ensuring seamless integration and data flow.- Addressed and resolved daily reporting data challenges, enhancing the accuracy and reliability of business-critical reports.