Yahit Dahiya

Business Analyst at WB Consulting (2025-11 – Present)

• Analyze business and operational data using SQL and Excel, supporting decision-making across client projects.
• Develop dashboards and reports to track KPIs, improving visibility into performance metrics.
• Partner with cross-functional teams to translate business requirements into technical solutions.
• Identify process inefficiencies and recommend improvements, enhancing workflow efficiency.

Data Analyst Intern at Loudoun Hospitality Management (2025-07 – 2025-09)

• Analyzed 10k+ booking and revenue records using Python (pandas, NumPy, matplotlib) and Excel to identify trends in occupancy and pricing.
• Performed trend analysis on occupancy rates, ADR, and guest demographics to inform pricing and marketing strategies.
• Developed automated Python scripts to consolidate large datasets, reducing manual reporting time by 40%.
• Designed Power BI dashboards integrating Python outputs to track key performance metrics for executive leadership.
• Wrote and optimized SQL queries to extract and analyze customer feedback and transactional data.

Business Analyst Intern at Shiv I.T (2024-05 – 2024-07)

• Used SQL to extract user behavior data from internal databases and generate weekly performance reports.
• Conducted in-depth analysis using Python (pandas and matplotlib) to uncover usage patterns and identify system bottlenecks.
• Designed interactive dashboards to visualize KPIs and sprint progress.
• Collaborated with data engineers to optimize SQL queries, improving report generation speed by 30%.
• Created JIRA epics and user stories to capture evolving business requirements for product launches.
• Built and maintained project trackers using Smartsheet and supported daily agile standups.
• Mapped and analyzed 'As-Is' workflows using Visio to recommend process improvements.
• Supported Confluence documentation and completed in-house training on JIRA/Agile best practices.

JR. Business Analyst at WB Solutions (2020-08 – 2022-07)

• Delivered requirements and functional documentation supporting IT and web development projects.
• Developed SQL queries and scripts to automate reporting for digital marketing analytics.
• Applied Python (NumPy, pandas, seaborn) to conduct correlation and cohort analyses on customer engagement data.
• Built reusable Python scripts for data cleaning and preprocessing, streamlining analytics workflows.
• Collaborated with cross-functional teams to translate data insights into business and product strategies.

Economics Tutor at Coherence Learning (2018 – 2023)

• Taught foundational economics topics (GDP, inflation, credit) to students aged 11-17.
• Designed personalized learning plans and interactive activities to improve comprehension.
• Collected feedback from parents to tailor instruction and improve learning outcomes.

Bachelor of Science in Management Information Systems – George Mason University (2025-05)