Nishant Dhir

India

@nishantdhir2

Business Intelligence Analyst

Badges

Sql

Certifications

nishantdhir2 has not earned any certificates yet.

Work Experience

  • Business Expert Reporting

    Lufthansa Airplus International GmbH•  December 2023 - March 2024•  Frankfurt

    • Collaborated with multiple product owners, 4 business experts, and 6 developers to align project goals. • Utilized SQL (Impala) on Azure Cloud to structure and clean data from 4 sources, including SAP, processing over 100,000 records to enhance data quality and integrity, which improved financial reporting efficiency by 30% • Processed 1,000 daily transactions to facilitate Power BI reporting, cutting report generation time for financial analysis. • Recovered and synchronized historical records (2000-2008) with the SAP team, enhancing data integrity by 6%. • Assisted product owners in decision-making by identifying pipeline flow issues and providing data-driven recommendations for improvement. • Resolved an average of 10 tickets daily, reducing resolution time by 8%, and ensured proper ticket allocation in weekly sprints, improving sprint success rate. • Created user stories and defined acceptance criteria in Jira and Confluence, facilitating clear communication and alignment among project stakeholders. • Actively Participated in Compliance and Fraud Training, demonstrating a commitment to industry standards and continuous improvement.

  • Business Analyst Intern

    Careerbee GmbH•  September 2022 - May 2023•  Mannheim

    • Cleaned and structured over 2,000 records in Excel from the company's first year of operations (2022), ensuring accurate and reliable data for analysis. • Analyzed data to uncover insights on service breakdowns, profession segmentation, and acquisition sources, supporting strategic decision-making. • Conducted trend forecasting for cost, revenue, and profit, including seasonal analysis, to aid in financial planning and strategy development. • Collaborated with the co-founder to create user personas, identifying potential clients and target audiences to refine marketing strategies. • Developed and maintained dynamic Power BI KPI reports and dashboards, enabling stakeholders to access real-time insights to make informed decisions, contributing to a 20% increase in strategic planning efficiency.

Education

  • Hochschule Der Wirtschaft Fur Management

    Business Management, M.A•  April 2021 - September 2022

    • Specialization in IT Management: Digital Business, Data Science, Business Analytics & Business Intelligence. • Research Paper: Role of Cloud Computing In Electricity Management. • Master Thesis: Optimizing the Infrastructure of Electric Vehicles and Developing Business Models for Sustainability.

  • Brandenburg University of Applied Sciences

    Vocational Training•  June 2022 - August 2022

    Comprehensive theoretical and practical knowledge of the SAP S/4 HANA system. Developed skills and knowledge of the following functions and their integration within complex business processes: • Logistics (SAP LO) • Procurement (MM-PUR) • Inventory Management (MM-IM) • Warehouse Management (MM-WM) • Production Control (PP) • Sales and Distribution (SD) • Plant Maintenance (PM) • Project Management (PS) • Accounting (AC) • Financial Accounting (FI) • Controlling (CO) • Human Capital Management (HCM)

  • Universität Mannheim

    English, Vocational•  February 2022 - May 2022

    • Refreshing and deepening of vocabulary and language practice in 24 units. • Development of word fields in the areas of presentations, correspondence, job applications, Business Organization and Company Structure. • Focus: Written communication (emails, business letters, reports), conversation.

  • Panjab University

    Business Administration, B.B.A•  June 2014 - July 2018

    • Specialization in Finance: Business Policy & Strategy, Cost Analysis, and Control. • Bachelor Thesis: Comparison of Electric Vehicles and Fuel Vehicles with reference to Tesla Motors.

Skills

SQL