Headline

Business Analyst | SQL (AWS Athena) + Python Automation + Looker Studio | BFSI & Lending Analytics — Freecharge (Axis Bank)

About

I’m a Business Analyst at Freecharge (Axis Bank subsidiary), working across lending and disbursement analytics for 200+ branches and ₹1,000 Cr+ in disbursed loans across 9 states. My work sits at the intersection of business analytics, operational data, and decision-making. I build SQL pipelines using AWS Athena to structure operational data, develop segmentation analyses across branch vintage, field-executive productivity, and pincode-level disbursement, and identify underperforming segments for business teams. I also build and maintain Looker Studio dashboards used in weekly leadership reviews. A key focus of my work is turning repetitive operational processes into scalable workflows. I automated recurring reporting process using Python (Pandas, xlwings), reducing a 50–60 minute manual cycle to under 8 minutes while maintaining validated output accuracy. I’ve also worked on data-quality and process-audit problems. While analyzing field-agent activity data, I identified that approximately 25–30% of daily entries from one workflow showed patterns consistent with fraudulent activity, which contributed to a subsequent process change. I also own the Monthly Complaints Report submitted to the RBI, where data accuracy, consistency, and regulatory compliance are critical. Core toolkit: SQL (AWS Athena) | Python (Pandas, xlwings) | Excel | Looker Studio | Power BI Alongside my BFSI analytics experience, I’m building toward advanced analytics and AI-assisted analytics workflows, including a RAG-based document Q&A system and an agent-based automation project. My goal is to combine strong analytical fundamentals with practical AI capabilities while continuing to build depth in banking, lending, and financial-services analytics. Open to: Data Analyst | Business Analyst | BI Analyst | Analytics roles across banking, fintech, and analytics consulting.

Location

Bangalore Urban

AI stack

claude

deepseek

gemini

openai

ChatGPT

ChatGPT Images

Work experience

Analyst at Freecharge, Jan 2025 - Present · 1 yr 9 mos, Bengaluru, Karnataka, India, • Build SQL data pipelines on AWS Athena to extract, clean, and transform operational data supporting loan-performance and segmentation analysis across 200+ branches • Design segmentation analyses across branch vintage, field-executive productivity, pincode-level disbursement, and loan-bucket trends to isolate underperforming segments and support business decisions • Automated a recurring manual reporting workflow using Python (Pandas, xlwings), reducing report generation time from ~55 minutes to ~8 minutes (~85% reduction) with validated output accuracy • Build and maintain Looker Studio dashboards across Area Manager, State, and Phase levels used in weekly leadership reviews, tracking ₹1,000 Cr+ in disbursed loans across 9 states • Independently rebuilt core production dashboards in Tableau to benchmark reporting logic, validate metrics, and strengthen BI capability • Track disbursement run-rates against monthly targets to project month-end performance, identify gaps, and support business planning • Investigated field-agent activity data and identified that ~25–30% of daily entries in one workflow showed patterns consistent with fraudulent activity, contributing to a subsequent process change • Own the Monthly Complaints Report submitted to the RBI, ensuring data accuracy, consistency, and regulatory compliance • Present analytical findings to leadership and onboard teammates on SQL-based analysis workflows

Data analyst intern at The Modern Data Company, Aug 2023 - Sep 2023 · 2 mos, Indore, Madhya Pradesh, India, During my 2-month Data Analyst Internship at The Modern Data Company in Indore, I honed my data analysis skills. I proficiently utilized SQL to analyze data and presented actionable insights to drive data-driven decision-making. One of my key achievements during this internship was the execution of a comprehensive data analysis project, which included the generation of synthetic data using Python. This project not only enhanced my analytical capabilities but also allowed me to communicate clear and valuable insights to stakeholders.

Education

Bachelor of Technology, Computational Science, Shri Ram institute of technology

Public links

github: https://github.com/tanmayjain2001