Business Analyst , EXL
Apr 2025 to present
- Supported 5 major business processes for a UK utility client. Translated business requirements and ad hoc requests into validated datasets and reporting solutions using Databricks and Spark SQL.
- Migrated 35+ SQL/HQL scripts from Amazon Redshift and Hadoop to Databricks using Spark SQL.
- Handled 80+ ad hoc data requests for UK stakeholders, delivering 90% within SLA.
Tools: SQL, Python, Databricks, Spark SQL, Power BI, DAX, Pandas, Tableau, Alteryx
More detail
- Standardized script formatting and optimized queries.
- Investigated billing data using Python, Pandas, Tableau and Alteryx, finding unbilled leaving accounts that needed final bills despite reads being available.
- Analyzed customer leaving and dispute processes using Power BI, DAX and data modelling, monitoring KPIs for leave-journey completion, final-bill generation, read receipt, communication status and dispute resolution, and identifying process gaps through flow checks.
- Owned an end-to-end Power BI dashboard covering product end-date extensions, product-switch reasons and open-request ageing, identifying idle, overdue and errored requests through KPI analysis.
- Independently managed complex requests through to resolution; 5% of requests evolved into major projects that needed cross-functional coordination and end-to-end ownership.
Assistant Manager , TVS Credit
Jan 2025 to Mar 2025
- Developed Excel dashboards and MIS reports for daily delinquency monitoring, tracking non-payment ageing buckets up to 5 days.
- Automated recurring reporting using Excel Macros, Pivot Tables, INDEX-MATCH and VLOOKUP.
Tools: Advanced Excel, Excel Macros, Pivot Tables, INDEX-MATCH, VLOOKUP
Career break and upskilling
Feb 2023 to Dec 2024
Continued building analytics skills; completed the IBM Data Analyst Professional Certificate and the Codebasics Data Analytics Bootcamp. The break was for competitive government examination preparation.
Senior Associate and Associate , Think & Learn Private Limited (BYJU'S)
Jul 2020 to Jan 2023
- Used MySQL, Power BI and Power Query to assess scholarship test and student assessment data.
- Contributed to the BYJU'S Neo Classes project from ideation and sample collection through content preparation.
- Built and maintained Power BI dashboards and KPI reports on student engagement, learning progress, dropout trends and assessment performance.
Tools: MySQL, Power BI, Power Query, Excel
More detail
- Performed data cleaning, transformation and exploratory analysis on large tagged question datasets.
- Evaluated topic difficulty and accuracy and identified student strengths and weaknesses, supporting personalized test recommendations.
- Coordinated with 4 subject teams (Science, SST, Mathematics, Biology) to segregate questions and support structured question supply.
- Used Power Query, data modelling and Excel; presented insights to cross-functional stakeholders.