Aaryan Kumar

CSR Reporting and Analysis :

• Analyzed CSR reports of 250 top Indian publicly listed companies using SQL for structured data extraction and aggregation, covering 1,000+ sustainability initiatives.
• Designed and maintained a CSR database of 1,00,000+ entries in SQL, enabling efficient trend analysis and rapid queries for reporting needs.
• Developed 25 detailed Tableau dashboards visualizing key CSR trends, best practices, and actionable insights, boosting stakeholder understanding and decision-making.
• Identified 50 unique sector-specific CSR contributions by applying data segmentation and clustering techniques, influencing policy decisions across 10 industries.
• Benchmarked CSR activities against 100 industry peers, generating 30 data-driven recommendations for performance improvement through comparative Tableau analysis.

• Conducted comprehensive secondary research across multiple government portals, gathering data on over 1500+ major infrastructure projects including refineries, hospitals, and educational institutions.
• Analyzed tender documents using advanced Excel functions and SQL queries to identify 38 product categories with the highest consumption potential, directly supporting strategic business development.
• Assessed approved brand lists for these projects, using SQL to filter and rank vendors, identifying 25+ key brands with strong market opportunities.
• Developed detailed reports for 13 major clients, highlighting business potential and insights, improving strategic decision-making and increasing market penetration by 12%.

• Financial Reporting and Analysis:
• Analyzed financial reports of over 28 Indian publicly listed companies
• Prepared 10+ detailed market analysis reports, delivering actionable insights to stakeholders.
• Developed financial models and conducted scenario analyses, optimizing portfolio strategies and improving returns by 15%
• Monitored market trends and analyzed over 50 financial instruments, including stocks and bonds, to identify investment opportunities.
• Utilized statistical tools like Excel and SQL to perform risk assessments on portfolios valued at $1M+