Sandesh Gavali on Tal
Headline
Data Analyst - Audit Analytics | IDFC FIRST Bank | SQL, Python, Power BI | Automation & Process Optimization
About
Data Analyst with 2 years of experience working with large-scale banking datasets at IDFC FIRST Bank. Skilled in SQL, Python, and BI tools to analyze data, build dashboards, and deliver actionable insights. I specialize in transforming raw data into structured insights, automating reporting workflows, and ensuring data quality for analytics and business use-cases. 🔍 WHAT I DO: I work with large datasets across Oracle, Impala, and Hive environments to analyze trends, identify anomalies, and support data-driven decision-making. My work includes building dashboards, developing data pipelines, and creating monitoring systems to improve efficiency and accuracy. 💡 KEY ACHIEVEMENTS: • Authored 1000+ SQL queries across Oracle, Impala, and Hive to support analytics, reporting, and root cause analysis • Automated 20+ recurring reporting workflows using Cloudera CML, improving efficiency and reducing manual dependency • Built Python-based data pipelines (Playwright) to scrape and organize regulatory data from RBI, NPCI, and IFSCA sources • Developed exception reports and monitoring frameworks to identify data inconsistencies and improve data quality • Created Power BI dashboards using DAX and Power Query to analyze banking sector KPIs (including NPA trends) • Built VBA-based automation tools to standardize reporting and eliminate repetitive manual processes • Designed an AI-driven workflow using Dify to compare regulatory circulars with internal SOPs, identifying compliance gaps 🛠️ TECHNICAL SKILLS: SQL (Advanced) | Python (Pandas, NumPy) | Power BI | DAX | Excel (Advanced) ETL | Data Pipelines | Dashboarding | Data Analysis | Data Quality & Monitoring 📊 MY APPROACH: I focus on solving data problems efficiently—whether it's improving reporting processes, identifying inconsistencies, or enabling better decision-making through structured analysis and dashboards. 🎓 CONTINUOUS LEARNING: Currently expanding my skills in machine learning fundamentals and cloud technologies to grow in the analytics space. 💬 LET’S CONNECT: Open to Data Analyst roles and opportunities involving analytics, dashboarding, and data-driven problem solving. 📧 sandeshgavali01@gmail.com
Location
Mumbai Metropolitan Region
Work experience
Audit Executive – COE & Audit Analytics (Data Analyst) at IDFC FIRST Bank, Jul 2024 - Present · 2 yrs, Mumbai, Maharashtra, India, Driving data analytics and automation initiatives for Internal Audit by leveraging SQL, Python, and data tools to improve reporting efficiency, data quality, and decision-making. • Authored 1000+ SQL queries across Oracle, Impala, and Hive to support analytics, reporting, and root cause analysis • Automated 20+ recurring reports using Python and Cloudera CML, reducing manual effort and turnaround time • Built data pipelines using Python (Playwright) to collect and structure regulatory data from RBI, NPCI, and IFSCA sources • Developed exception reports and monitoring frameworks to identify data inconsistencies and improve data quality • Performed data validation and reconciliation across multiple systems to ensure accuracy of reporting datasets • Collaborated with business, audit, and operations teams to define data requirements and improve reporting accuracy • Built VBA-based automation tools to standardize reporting and eliminate repetitive manual tasks • Developed AI-driven workflow using Dify to compare regulatory circulars with internal SOPs and identify compliance gaps Skills: SQL · Python · ETL · Data Analysis · Automation · Data Quality · Reporting
Education
Bachelor's degree, Electrical and Electronics Engineering, Thakur College of Engineering and Technology
