Kevin Ihama

Provide insights based on the business needs and presented findings and recommendations to the business
• Reporting: Integrate different data sources and create data sets within Power BI, Salesforce, Cube, SharePoint etc to produce reports for key metrics that align with the business goal and objective.
• Maintain and improve reports and metrics provided to key stakeholders.
• Use power Bi to extract data from the various data sources, merge them together, transform
the data, create dashboards and report the findings to the strategic decision maker.
• Identify trends in data that indicates changes in services being delivered or changes in sales
demand and communicate this to the appropriate region lead.
• Work in line with other reporting and analysis teams within the professional services as
required.
• Help with ad-hoc request from the stakeholder across the business as well as taking
ownership of gathering data needed for different reporting.

Provide insights based on the business needs and presented findings and recommendations to the business.
Integrate different data sources and create data sets within Power BI, Salesforce, Cube, SharePoint etc to produce reports for key metrics that align with the business goal and objective.
Maintain and improve reports and metrics provided to key stakeholders.
Use Power BI to extract data from the various data sources, merge them together, transform the data, create dashboards and report the findings to the strategic decision maker.
Identify trends in data that indicates changes in services being delivered or changes in sales demand and communicate this to the appropriate region lead.
Work in line with other reporting and analysis teams within the professional services as required.
Help with ad-hoc request from the stakeholder across the business as well as taking ownership of gathering data needed for different reporting.

Worked closely with the entire migration team.
Extract and interrogate the data to answer the business ad-hoc queries.
Cleanse the data in systems.
Identify gaps in the new system and proposed solution to address the gaps.
Present the data to the different stakeholders to demonstrate issue and solutions.
Monitored the quality and integrity of the data that is migrated to the new system Agora.
Work with the Central Administration Team to prepare and understand relevant information.
Work with internal teams to review data in Agora and reconcile in system.
Provide quarterly in-depth analysis (QBR) to the business.

Worked as part of a team in supporting and enabling transformation across Lincolnshire CCG.
Worked with a range of analysts across health and local authority partners, with a dedicated focus on driving the analytics and data component of the Lincolnshire ICS.
Responsible for providing data analysis to enable decision making that leads to the development of effective strategic workforce plans.
Worked with work streams and business users to understand business needs and translate those needs into actionable reports and monitory KPIs in Power BI.
Responsible for combining data from various sources and designing effective data models.
Responsible for evaluating the existing data collection, manipulation and analysis and performing the required transformations using SQL, Excel, and Power BI.
Developed complex calculated measures using Data Analysis Expression (DAX).

Collaborate with business and IT stakeholders to formulate and assess ideas for enhancements to BI and input into prioritisation, impact analysis, estimates and scheduling.
Extract and optimise data from disparate data sources using SQL.
Develop Power BI dashboard.
Acquire data from primary or secondary data sources and maintain databases/data systems.
Create advanced SQL queries to retrieve, update, insert and delete data.
Work closely with internal and external clients to prioritize business and information needs.
Monitored customers experience analysis.
Creating new analytical reports and dashboards using Power BI to show achievement of critical KPIs for requested projects.
Responsible for presenting information in a compelling and visually pleasing manner.