Peter Kariuki

About Peter Kariuki

With over eight years of experience and certifications in MS SQL Server and Data Analyst, I am a Database and Reporting Analyst at Innovative Risk Management, a leading provider of risk management solutions. I design, test, implement, and administer complex T-SQL queries, SSIS packages, and strategic business level reports using MS SQL Server, SSIS, SSAS, and SSRS technologies.I collaborate with internal and external stakeholders to understand their requirements, troubleshoot and resolve production issues, and provide data analytics and data visualization solutions. I use best practices and performance optimization techniques to ensure the quality, accuracy, and efficiency of the data and reports. I am a team player, a strategic thinker, and a problem-solver who enjoys learning from new challenges. I am passionate about data and how it can help businesses make better decisions and achieve their goals.

Experience

1. Power Bi Developer

   Innovative Risk Management

   Oct 2019 — Present · Coppell, TX, US

   Designed, developed, and maintained strategic business-level reports using Power BI, incorporating DAX expressions for advanced analytics.•Implemented security and access management within Power BI to ensure correct user visibility and data protection.•Interfaced with internal and external stakeholders to gather requirements and understand business needs, translating them into technical specifications for data visualizations.•Revamped existing reports in Power BI to enhance usability and effectiveness, providing key individuals with actionable insights for decision-making.•Collaborated with cross-functional teams to optimize operational functions within Power BI and streamline data workflows.•Used Power BI service to schedule automatic refresh•Worked on every kind of transformation that can be done with the Power Query editor•Developed SSIS packages to automate existing reporting and business processes.•Created ad-hoc reports using moderate to complex T-SQL scripts.•Developed data capture and navigation desktop and mobile apps in Microsoft Power apps that connect to distribution center solutions design analytics•Used DAX function to create measure and calculated fields to analyze data for logical visualization and used power queries to transform data.

Education

• Jomo Kenyatta University of Agriculture and Technology (JKUAT)

  Information Technology