Aman Rath

• Worked on the Sahara Refund project, responsible for developing PL/SQL queries and stored procedures to generate data and statistical reports for client presentations. • Optimized PySpark jobs handling 10M+ records, reducing pipeline runtime by 35% and improving reporting accuracy. • Built 8+ Power BI dashboards with DAX and custom visuals, enabling 20+ business users to cut reporting time by 15 hours/week. • Contributed to the Quicklyz project at Mahindra Finance , working on backend data processing, MIS report generation and performance optimization. • Utilized Azure Data Factory (ADF) to build and schedule ETL pipelines for seamless data integration from multiple sources. • Developed 12+ ETL pipelines in SSIS to integrate data from 5+ sources, ensuring 99.5% reliability in daily loads. • Implemented Azure Data Lake storage layers for structured and unstructured data, ensuring scalability, security, and seamless integration with downstream analytics tools. • Built data ingestion and transformation workflows using Azure Databricks to streamline lease portfolio data consolidation across multiple sources