About
Data Analyst with 3+ years of experience building ETL pipelines, automating enterprise reporting workflows, developing SQL-based analytical datasets, and delivering business intelligence solutions. Proficient in Python, SQL, Tableau, and relational databases with experience collaborating with Data Engineering teams to deliver scalable data solutions.
Skills & Expertise (22)
Work Experience
Data Analyst
Aadhar Housing Finance Ltd.
Nov 2024 - Present
Cheque In-Hand Automation | Python, SQL, ETL, Pandas, Data Warehouse, Apache Superset • Reduced manual reporting effort by 70% by developing Python and SQL-based ETL pipelines integrating operational files with enterprise warehouse data into a unified analytical dataset. • Implemented business logic for cheque status classification and operational KPI calculations, enabling standardized reporting across products and branches. • Delivered an interactive Apache Superset dashboard replacing Excel-based reporting, enabling faster business insights and improved operational visibility. BT-OUT Analysis Automation | Python, Pandas, SQL, ETL, Microsoft Power Automate, Excel • Reduced monthly processing time from 4 hours to 20 minutes by automating customer data extraction, validation, reconciliation, transformation, and upload file generation using Python and SQL. • Built reusable SQL extraction workflows and automated validation checks, improving data quality and eliminating recurring manual requests. • Automated stakeholder notifications and monthly reporting workflows using Microsoft Power Automate. Portfolio Monitoring Dashboard | Tableau, SQL, Excel • Enhanced Tableau dashboards and optimized SQL queries supporting portfolio monitoring, loan performance analysis, AUM tracking, delinquency trends, and business KPI reporting. • Implemented business classification and data validation logic to improve reporting accuracy and consistency. • Partnered with business stakeholders to translate reporting requirements into scalable analytical datasets. Loan Reject Scorecard Analytics Platform | Tableau, SQL, Python, Excel • Developed SQL-driven analytical datasets and Tableau dashboards for loan rejection analysis across daily, MTD, YTD, and fiscal-year reporting. • Automated KPI calculations, dashboard subscriptions, and recurring reporting workflows, improving reporting efficiency and consistency. • Performed comprehensive data validation and reconciliation to ensure accurate business reporting.
Python Developer
Getepay
Nov 2022 - Jun 2024
• Developed backend applications using Python, Django, REST APIs, JavaScript, and MySQL to support education and administrative platforms. • Designed and optimized relational database operations, SQL queries, and data validation processes to improve application performance and data accuracy. • Built reusable APIs and backend modules supporting fee management, form processing, authentication, and reporting functionalities. • Collaborated with cross-functional teams to deploy scalable applications and resolve production issues.
Education
Bachelor of Technology (B.Tech), Computer Science - Poornima Institute of Engineering and Technology
2018 - 2022 · India
Senior Secondary School (Class XII) - Shekhawati Sr. Sec. School
2015 - 2017 · India
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Depends on Offer
Skills (22)
Click a skill to find developers with the same skill