Philip Robert Wandetie

Statistician, Data Scientist and Analyst - BSc Statistics |TABLEAU|SPSS|STATA|ADVANCED EXCEL|SQL|R STUDIO|POWER BI|PYTHON|BI ANALYST

Nairobi County, Kenya

About

I am a skilled professional with a unique quantitative background in Statistics and I am focused and geared towards excellence. My expertise in statistics/mathematics equips me with deep understanding of Statistical analysis,Statistical data modelling and excellent problem solving skills. I bring a holistic approach to projects combining analytical thinking and practical analytics tools. I excel at transforming data into actionable insights and implementing innovative solutions which are key drivers to business and organizational success as I leverage technology to solve complex problems and drive a positive change. My versatile skill set allows me to thrive in various dynamic environment, collaborating with multidisciplinary teams to deliver impactful results. I am a self motivated , hardworking and result oriented person and I give a keen eye to details and competent work.

Experience

  • Statistician Data analyst and Data Scientist at Self employed
    Jan 2024 - Present · 2 yrs 6 mos

  • Financial Advisor at Corporate Insurance Company ( CIC Group )
    Jul 2024 - Feb 2025 · 8 mos

    Selling of insurance products and policies Identifying new customer base and prospective clients Being a good ambassador of the company Creating financial literacy on the customer base. Marketing the company Doing financial need analysis with clients and advising them accordingly. Assessment of Clients financial needs and helping them plan for short-term and long-term goals.

  • Junior Data Analyst at Ona
    Apr 2023 - Dec 2023 · 9 mos

    Conducted comprehensive data analysis using python and Excel to support decisionmaking processes • Developed and maintained dashboards using Tableau and Power BI for various business units • Collaborated with stakeholders to identify data requirements and deliver actionable insights • Performed data Cleaning and transformation to ensure data quality and integrity • Implemented new data collection and analysis processes resulting in 20% increase in data accuracy

  • Data Clerk at Emergency Operations Centre Busia
    Oct 2022 - Mar 2023 · 6 mos

    Introduced data analysis and entry with SPSS in the EOC to complement excel. • Performed data entry and verification. Biodata and geographical data. • Analyzed data with Excel then generated situation reports to guide intervention measures. • Managed inquiries, complains and recommendations and making follow ups on data. • Conducted defaulter tracing and generated heatmaps of Covid 19 for affected persons and regions identification. • Conducted Disease mapping using Quantum Geographic Information systems and also did event capture in the KHIS and DHIS portals. • Offered ICT Suppor

  • Busia County Refferal Hospital (3 mos)
    • Attache
      Jul 2022 - Sep 2022 · 3 mos

      perfomed Revenue Collection Using the automated revenue system. Bank receipts Reconcilliation and Revenue monitoring, generation of weekly revenue reports. Generation of epidemiology reports and data analysis, data visualization using Excel pivot tables and graphs. Non pharmaceuticals data entry and filling Comprehensive reporting tools. Taking daily statistics of Non pharms and raising of S11 and S13 vouchers. Issuing commodities following FIFO rule and updating the stock control cards. Taking statistics of working and defective equipment. Inspection of supplied goods. Registering patients in NHIF portal and generating NHIF payments claims for treated patients. Signing and approval of hospital invoices and monitoring the invoice management system. Compilation of revenue reports. Bioverification of patients and admitting them in NHIF system Making claims in the HICS portal. Perfomed registration and queing of patients at the OPD using the automated queing and registering system. Balancing and filling of Daily Bed returns Perfomed ICD 11 coding of pqtients files Conducted daily ward round to collect patient statistics. Admission and dischargingbof patients from the hospital system. Filling of patients demographic information and diagnosis in the Kenya Health Information System portal Conducted Civil registration which involved issuing of Birth and death notifications( B1 and D1) Queing of patients at MCH Calculation of hospital statistics which involved: OBD,ABD,TOB,ALS, POC then generated monthly reports.

    • University Attachment
      Jul 2022 - Sep 2022 · 3 mos

      Implemented data entry and data analysis using excel in the procurement and supply chain department to help track stock consumption. • Managed patient’s data entry and registration • Cleaned and compiled health records to main accurate patients’ database. • Collected and monitored revenue using automated revenue system for revenue tracking. • Performed installation and upgrade of computer operating systems and network connectivity. • Performed hospital statistics and analysis later gave out reports to be used for planning. • Performed bio verification, registration and updating of patients details in NHIF and KHIS portals. • performed admission and queuing of patients in the hospital system. • Updated the stock control cards and approved hospital invoices. • Performed ICD 11 Coding of patient file.