Dinesh Manger

• Effectively handled recruitment and staffing data, alongside financial data, to produce a variety of reports and insights tailored to meet the needs of diverse stakeholders.
• Collaborated extensively with diverse stakeholders across various business units (BUs) and senior management teams to comprehensively grasp their specific requirements. Leveraging available data sources, I delivered tailored reports and actionable insights, contributing to data-driven decision-making processes within the organization.
• Projects:
  
  MongoDB Integration to Power BI:
  Successfully integrated app data from a MongoDB database into Power BI through the utilization of an ODBC connection and dataflows. Proficiently parsed multiple JSON formatted records/lists into organized columns, enhancing data accessibility and analysis.
  
  Dataset Unification:
  Led efforts to consolidate disparate data sources into a single unified dataset, fortifying data governance and streamlining reporting processes. This initiative not only mitigated data discrepancies and mismatches across reports but also significantly reduced data refresh times from minutes to mere seconds. It established a robust Row-Level Security (RLS) framework consistent across all related reports.
  
  PIP Process Automation:
  Spearheaded the automation of the Performance Improvement Plan (PIP) process within Power BI. Developed a system where Power BI autonomously identifies individuals with low performance based on predefined metrics and initiates email notifications to managers and HR for necessary actions, improving efficiency and accountability.

• Utilized Business Intelligence tool (SAP BO) to develop, modify, schedule, and analyze Web Intelligence and Desktop Intelligence reports, crafting SQL Queries for derived tables aligned with Functional Specifications.
• Leveraged Power BI to construct reports, dashboards, and data visualizations.
• Employed SQL as a data source for SAP BO, MSBI, and Power BI reports.
• Utilized MSBI to create SQL Server Reporting Services (SSRS) reports, including matrix, tabular, drill-down, drill-through, and parameterized reports, deploying them using Visual Studio.
• Demonstrated proficiency in Excel, leveraging automation to streamline manual tasks.
• Implemented Microsoft Power tools (Power Automate & Power Apps) for automating reporting and analytics processes.
• Possessed adeptness in working with Service Now report and Performance Analytics (PA) modules.
• Ensured the delivery of high-quality and accurate data, prioritizing data accuracy for clients and stakeholders.
• Collaborated closely with multiple account stakeholders, cultivating strong relationships while providing quick data insights.
• Collaborated with various technology teams, including Application Packaging, Patching, Cyber Security, Database, Service Desk, and Operations, to deliver desired insights.
• Presented weekly and monthly service reviews, sharing data-driven insights with internal stakeholders and clients.
• Successfully managed multiple critical accounts by automating manual reporting processes, enhancing efficiency, and ensuring stability.

Reporting BPS Metrics for HP Client:
In this role, I was responsible for creating comprehensive reports that tracked and analyzed various Business Process Services (BPS) metrics for our HP client. These reports were primarily Excel-based and drew data from ServiceNow, ensuring that the client had access to accurate and up-to-date information regarding their key performance indicators.

Collaboration with Team Leads and Managers:
I actively collaborated with team leads and managers to provide valuable insights derived from our IT Service Management (ITSM) ticket data and call records. By analyzing these datasets, I helped the team leaders and managers make informed decisions, optimize processes, and enhance the overall performance of the IT service desk.

Forecasting Models for Resource Planning:
A significant part of my role involved developing forecasting models. These models allowed us to predict staffing and effort requirements accurately. By leveraging historical data and trends, I provided insights into the resources needed to meet future demands, ensuring that our team remained adequately staffed and prepared for the challenges ahead.