Data Engineer
CurrentDeveloped an ETL pipeline utilizing Azure Data Factory (ADF) and SSIS to ingest, transform, and load flat-file data into on-prem SQL Server, supporting real-time reporting.Automated data flows to reduce manual intervention, enhancing data accuracy and reliability.Implemented complex transformations in SSIS to optimize data for SSRS reporting.Optimized and restructured five ETL packages, significantly improving data transfer efficiency from standalone databases to the analytics database, resulting in a 35-hour monthly reduction in processing time.Built and deployed SSIS packages for effective data extraction, transformation, and loading (ETL), ensuring stable, real-time reporting and analysis.Created a Power BI dashboard that provides insights into key metrics such as deposits, advances, NPAs, and ledger balances.