Ayush Pundir

Ayush Pundir

+•• ••••• •••••••••••@•••••.com

1.2 yrs

  • Dehradun
  • Open to Delhi · Gurgaon · Noida
  • On-site, Hybrid, Remote

Ask about Ayush

Skills

Claimed

Hackathon ParticipationTime ManagementTeamworkRapid Technology OnboardingOn-time DeliveryDoubt ClarificationBusiness Value RealizationRequirements AnalysisGoal UnderstandingReceiving and Incorporating FeedbackConcise CommunicationCritical Thinking

Proof of Experience

Data Analyst

Holmium Technologies Pvt. Ltd. · Dec 2025 – Jul 2026

  • Tracked efficiency, availability, and energy-generation KPIs across 100+ solar power plants, publishing monthly performance reports that flagged underperforming sites for the operations team to act on.
  • Ran daily live monitoring of ground-mounted and rooftop solar sites in Power BI, catching performance deviations and downtime patterns early enough to reduce avoidable energy loss.
  • Partnered with finance to build site-wise O&M expense reports in Power BI and Advanced Excel (XLOOKUP, VLOOKUP, Pivot Tables), surfacing cost-saving opportunities used in budget reviews.
  • Delivered KPI dashboards and written reports to senior stakeholders, translating raw plant data into operational and financial recommendations.
  • Documented data definitions and reporting logic so cross-functional teams could self-serve from the dashboards without repeat clarification requests.
Brillica Services Pvt. Ltd.

Data Analyst Intern

Brillica Services Pvt. Ltd. · Jul 2024 – Feb 2025

  • Automated recurring reporting processes using Excel Macros and Power BI reducing reporting time from 2 days to 4 hours, demonstrating strong process improvement and analytical efficiency.
  • Developed 5+ interactive dashboards in Power BI and Tableau enabling stakeholders to monitor KPIs, track business performance, and make informed, data-driven decisions.
  • Analysed datasets of 100K+ records using SQL (joins, aggregations, subqueries, window functions) identifying key KPIs and business patterns through exploratory and hypothesis-driven analysis.
  • Applied Advanced Excel functions (XLOOKUP, VLOOKUP, HLOOKUP, INDEX-MATCH, Pivot Tables, Power Query, Conditional Formatting) for data cleaning, transformation, and analysis across multiple business datasets.
  • Collaborated with cross-functional teams to present insights that guided project strategies communicating analytical findings clearly to both technical and non-technical stakeholders.

Proof-of-Work

No completed sessions yet. Anything Ayush finishes shows up here with the evidence behind it.

Proof of Education

Master of Business Administration, Business Analytics

University of Petroleum and Energy Studies, Dehradun · 2026

Bachelor of Arts, Mathematics

Sri Dev Suman Uttarakhand University, Tehri Garhwal, Uttarakhand · 2019 — 2022

A Proof CV — one profile, kept current, with the proof attached. Back to the portal