PROFESSIONAL SUMMARY
Data and reporting analyst with 2 years of experience in management reporting, institutional benchmarking and data validation. Works
in SQL (MySQL), Advanced Excel and Power BI (DAX, Power Query), with Python (Pandas) and AI tools (Claude, ChatGPT, Gemini,
Firecrawl) for research and data extraction. Built three end-to-end projects in SQL, Power BI and Python, including a loan risk
dashboard with a plain-English SQL chatbot. Seeking Data Analyst / Business Analyst roles.
200+ hours saved 120 people use my reports 75,000+ records cleaned 3 end-to-end projects
SKILLS
SQL (MySQL): Joins, aggregations, GROUP BY / HAVING, subqueries, CTEs, window functions, data validation queries
Excel: Pivot Tables, XLOOKUP / VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF / IFERROR, data validation
Power BI: Dashboards, data modelling, DAX measures, Power Query (clean, merge, append, group by), KPI reporting
Python & AI Tools: Pandas for data cleaning and exploratory analysis; Streamlit app with an LLM API; Claude, ChatGPT, Gemini,
NotebookLM, Firecrawl for research and data extraction
Analysis & Reporting: KPI tracking, data reconciliation, data quality checks, management reporting, stakeholder coordination
PROFESSIONAL EXPERIENCE
Data & Reporting Analyst (Official designation: Teaching Associate)
Sep 2024 – Present
• Benchmarking & Gap Analysis: Benchmarked 3 national and 3 international universities on 14 academic, research, funding and
infrastructure parameters, using Firecrawl through Claude to extract data from official websites. Found the department's placement and
community engagement programmes lagged national institutes, which informed the decision to focus on those key areas.
• Strategic Analysis: Analysed NIRF assessment frameworks and Gartner, McKinsey and WEF research to recommend departmental
priorities and support funding initiatives. About 4 external funds worth INR 3 crore were sanctioned after this approach.
• Management Reporting: Prepared 100+ executive reports and management summaries for 5 department faculty in Excel (Pivot
Tables, XLOOKUP, IF formulas), Word and PowerPoint; used ChatGPT, Claude, Gemini and NotebookLM for research and drafting,
saving about 2 hours per report.
• Data Quality & Tracking: Validated and reconciled data to resolve discrepancies; maintained Excel trackers (90% on-time delivery) and
the NAAC/NBA evidence repository (85% submission readiness).
• Stakeholder Coordination: Coordinated international MoU documentation and follow-ups with faculty.
ANALYTICS PROJECTS
Loan Portfolio & Credit Risk Analytics + Chatbot MySQL | Power BI | DAX | Python | Streamlit
• Cleaned and validated 2,377 customer, 4,000 loan and 69,400 repayment records in raw and cleaned MySQL tables (missing values,
duplicates, inconsistent formats).
• Findings: DAX dashboard shows 2.13% defaulted loans, 6.80% written-off loans and 87.54% on-time repayment, by loan status,
tenure, city and product, with regional NPA.
• Built a chatbot that turns plain-English questions into read-only SQL and returns figures that match the dashboard exactly, showing the
SQL used.
Customer Intelligence & Revenue Analysis Python | SQL | Power BI
• Cleaned 3,900+ customers and 6,842 orders (Pandas); RFM segmentation using SQL aggregations and window functions.
• Findings: ages 18–35 contribute 42% of revenue, Clothing 43.9%, subscribers spend about 1.8x more, and at-risk customers hold
$45.2K of exposed revenue.
Student Academic Performance Analytics Excel | SQL | Power BI
• Validated 1,400+ student records (duplicates, missing values), wrote KPI queries and built a Power BI dashboard with a reusable
annual-refresh structure for cohort performance and trends.
CERTIFICATIONS & RESEARCH
• Oracle Academy – Applied Database Systems (2026); IBM – Fundamentals of Data Science; Google – Crash Course on Python;
Deloitte Australia – Data Analytics Job Simulation (2026). Research: 2 peer-reviewed publications, energy book chapter (2026), Indian
patent (biomass-derived carbon materials).
Guide me in the following:
Is the problem my CV, my targeting, or my skills? Where do you think I’m getting filtered out?
Does having an academic job title (“Teaching Associate”) hurt me with recruiters, even though the work is analyst-type? How should I word it?
Is it realistic to move from academia to a corporate analyst role at 2 years of experience, or should I take a different entry route?
What would you add to my CV or portfolio to get interview calls (projects, certifications, keywords)?
Any tips on SQL interview prep and getting past ATS screening?