Akshada Pimpariya

Data Analyst with hands-on experience in SQL (joins, CTEs, window functions, aggregations), Advanced Excel, and Power BI, gained through data analyst internships and MIS reporting work. Skilled in translating business questions into KPIs, metrics, and analytical views; performing data validation, reconciliation, and quality checks across operational datasets; and partnering with cross-functional stakeholders to align reporting definitions. Experienced in delivering dashboards, ad-hoc analysis, and clear documentation of assumptions and business logic to support fact-driven decision-making.

Data Analyst Intern - NMD Infotech Solutions - Remote

(2025-10 - 2026-06)

• Designed a normalized SQL database of 6,00,000+ records and wrote advanced SQL queries (joins, CTEs, subqueries, window functions) to define KPIs and analytical views, including month-over-month revenue growth
• Performed data validation and quality checks across a multi-table dataset in Python (Pandas, NumPy), documenting cleaning logic and analysis assumptions for transparency and reusability
• Conducted ad-hoc time-series and RFM analysis to translate business questions into actionable customer retention insights across 9,000+ customers
• Built a Power BI dashboard with 25+ DAX measures, partnering findings with stakeholder-ready reporting on revenue, margin, and retention metrics across region and category
• Documented business rules and metric definitions for reporting consistency, supporting a capstone deliverable analyzing ∼Rs 2,716 Cr in revenue

MIS Analyst (Data and Reporting) - Credila Financial Services Ltd. (via PersolKelly) - Nashik

(2025-05 - 2025-09)

• Reduced reporting turnaround time by automating 3 weekly MIS reports using Advanced Excel (Pivot Tables, Power Query, XLOOKUP), saving ∼4 hours of analyst effort per week
• Analyzed 500+ real loan application records, performing data validation and reconciliation to identify approval and rejection trends; findings flagged a recurring eligibility gap that informed process improvement discussions with the operations team
• Defined and maintained KPIs and reporting metrics tracking applications received, approvals, rejection rates, and disbursement trends across weekly stakeholder dashboards
• Conducted ad-hoc rejection trend analysis, identifying top 3 recurring eligibility failure reasons and documenting findings to enable targeted corrective action
• Performed structured data cleaning, validation, and quality checks across operational datasets, reducing reporting errors and improving cross-team data consistency
• Collaborated with cross-functional teams (operations, credit, compliance) to align reporting definitions and business rules, delivering accurate, stakeholder-ready dashboards

Master of Business Administration (MBA) - Business Analytics - Ashoka Business School (2023 - 2025)

Bachelor of Science (B.Sc.) - Chemistry - K. V. N. Naik College (2020 - 2023)