Kevin Osioma

KEVIN MOCHAMA OSIOMA -| - 📍 Nairobi, Kenya |LinkedIn Profile - Kevin Osioma Portfolio: github.com/KMochama Availability | Immediate | Location: Remote (Anywhere) PROFILE SUMMARY I am a data analyst with expertise in leveraging SQL, Power BI, Excel, Python, and R to extract meaningful insights and drive data-driven decision-making. I specialize in remote roles in data analytics and on-site positions, with experience in building interactive dashboards, optimizing business processes, and transforming complex datasets into actionable insights, I help organizations enhance efficiency and performance. My background includes designing database systems, analyzing financial and operational data, and implementing real-time reporting solutions to improve industry decision-making. KEY COMPETENCIES Technical Skills SQL & Database Management (SQL Server Management Studio, MySQL) Data Visualization & Business Intelligence (Power BI, Microsoft Excel) Python & Data Analysis (Pandas, NumPy, Matplotlib) Microsoft Azure & Cloud Computing (Azure Data Warehouse, Azure Data Studio) R & Statistical Analysis (R Studio) Excel & Data Automation (VLOOKUP, Pivot Tables, Conditional Formatting) Core Skills Data-Driven Decision-Making & Business Insights Remote Team Collaboration & Stakeholder Communication Data Cleaning, Preprocessing, & Transformation Dashboard Development & Interactive Reporting Database Design & Optimization MAJOR ACCOMPLISHMENTS In my Employee Performance and Productivity Analysis project, I developed interactive Power BI dashboards that provided real-time insights, enabling managers to optimize team productivity and improve efficiency. While analyzing financial consumer complaints, I created a Power BI data model to track complaint trends, which helped financial service providers address customer pain points and resolve complaints faster through interactive reporting. While working on a supply chain management database, I designed and implemented an SQL-based inventory tracking system, streamlining supply chain reporting and improving decision-making with real-time insights. For a hospital operations database system, I developed an SQL-based solution that improved administrative workflows by automating data retrieval and reporting, reducing administrative overhead, and enhancing operational efficiency. In an airline data analysis project, I provided key financial and operational insights that helped a startup airline optimize route planning and profitability, contributing to better business operations and increased revenue. CAREER HIGHLIGHTS/ PROJECTS Employee Performance and Productivity Analysis Analyzed employee performance metrics to identify trends, optimize productivity, and enhance operational efficiency through data-driven decision-making. Designed and implemented interactive dashboards to provide managers with real-time insights. Performance Metrics & Data Analysis – Evaluated employee KPIs, attendance, and efficiency, leading to a 20% improvement in workforce productivity. Dashboard Development & Business Intelligence – Created interactive Power BI dashboards, enabling real-time monitoring and data-driven decision-making. Data Processing & Integrity Management – Cleaned and processed employee performance data using SQL, ensuring accuracy and consistency in analysis. Stakeholder Collaboration & Process Optimization – Worked with business leaders to gather and document key requirements, streamlining reporting processes and enhancing strategic planning. Financial Consumer Complaint Analysis Analyzed consumer complaints to identify root causes, improve service delivery, and enhance customer satisfaction through data-driven insights. Designed and implemented interactive dashboards to track complaint trends and resolution efficiency. Complaint Data Analysis & Trend Identification – Evaluated consumer complaints across regions and financial products, leading to a 25% improvement in resolution time. Dashboard Development & Business Intelligence – Built interactive Power BI dashboards to provide real-time tracking of complaint trends and service performance. Data Cleaning & Standardization – Processed and categorized complaint data using SQL, ensuring consistency and accuracy in reporting. Service Optimization & Stakeholder Collaboration – Provided actionable insights to financial service providers, enabling targeted improvements and faster complaint resolution. Supply Chain Management Database Design Designed and implemented an SQL-based supply chain management database to optimize inventory tracking, order processing, and supplier management. Enhanced decision-making through real-time reporting and data insights. Database Design & Optimization – Developed a normalized SQL database in 3NF, reducing data redundancy and improving query efficiency. Inventory & Order Management – Created SQL queries and reports to track inventory levels, supplier performance, and order processing, streamlining supply chain operations. Performance Optimization & Real-Time Reporting – Enhanced database performance to support real-time insights, leading to a 25% improvement in supply chain efficiency. Data Integrity & Process Automation – Ensured data accuracy and consistency while automating reporting workflows, minimizing manual errors, and improving operational transparency. Healthcare Database System for Hospital Operations Developed a SQL-based healthcare database system to optimize hospital operations, including patient scheduling, medical records management, and administrative workflows. Improved efficiency through real-time data insights and automation. Database Design & Optimization – Designed a normalized SQL database to enhance query performance, ensuring fast and accurate retrieval of patient and medical data. Patient Scheduling & Medical Records Management – Created reports to track patient appointments, doctor availability, and treatment histories, improving hospital coordination. Operational Efficiency & Automation – Automated data retrieval and reporting processes, reducing administrative workload by 30% and enhancing service delivery. Data Integrity & Compliance – Ensured secure and consistent data storage, adhering to healthcare data standards and improving patient record accuracy. Airline Data Analysis for Startup Airline Analyzed financial and operational data for a startup airline to optimize route performance, enhance profitability, and support strategic decision-making. Delivered data-driven insights to improve operational efficiency and cost management. Financial & Operational Data Analysis – Evaluated key metrics such as revenue, fuel costs, and profitability, identifying cost-saving opportunities that improved margins by 15%. Route Performance & Optimization – Assessed flight route efficiency, passenger load factors, and operational costs, enabling data-backed route planning. Data Structuring & Reporting – Organized and structured airline data to create detailed reports, enhancing visibility into financial performance and operational trends. Strategic Decision Support – Provided actionable insights that guided executive decisions, optimizing profitability and resource allocation for sustainable growth. ACADEMIC QUALIFICATIONS 2017: Kisii University - Bachelor's Degree in Business and Information Management. 2015: Kisii University - Diploma in Business Information Technology. PROFESSIONAL TRAINING & CERTIFICATIONS MySQL for Data Analytics | Analyst builder | 2024 Advanced MySQL for Data Analysis | Analyst builder | 2024 Pandas for Data Analysis | Analyst builder | 2024 R for Data Analytics | Analyst builder | 2024 Excel for Data Analytics | Analyst builder | 2024 Advanced Excel for Automation | Analyst builder | 2024 Microsoft Power BI Desktop | Analyst builder | 2024 Foundations of Data Pipelines | Analyst builder | 2025 Cloud Computing Essentials with Azure and AWS | Analyst builder | 2025 Good Clinical Practice (NIDA) REFEREES Available upon request