Titus Karanja

Titus Karanja

$35/hr
Proven Analyst: BI, Databases, Metrics, Mining, Analysis, Insights
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Versoix, Geneva, Switzerland
Experience:
15 years
T I T U S KA R A N JA DATA ANALYST / BUSINESS INTELLIGENCE / DATA ENGINEER CONTACT-+41 - Geneva, Switzerland EDUCATION BSc. Computer Science Jomo Kenyatta University of Agriculture and Technology 2004 - 2008 SKILLS Tableau SQL/MySQL/SQL-Server Python Salesforce Power BI SSRS/SSAS/SSIS Looker Google Analytics/GA4 Google Tag Manager HTML/Javascript/CSS Google Cloud Platform (GCP) Amazon Web Services (AWS) Apache CouchDB SharePoint Problem solving Result oriented Teamwork Pragmatic CERTIFICATIONS Tableau Desktop Specialist Project Management Professional (PMP) LANGUAGES English (C2) French (A2-B1) Swahili CAREER SUMMARY Proven analyst (BI, Databases, Metrics, Mining, Analysis, Insights) with over 15 years of experience in International Organizations and Consulting. Successfully injected analytical rigor to build solutions that add value to cross-functional business teams. Maximized performance by implementing sound project management. WORK EXPERIENCE IT Specialist Consultant Permanent Mission of Kenya to United Nations March 2024 - September 2024 / Geneva, CH Responsible for planning and coordinating the implementation of Master Data Management (MDM) projects and ensuring that they are completed on time and within budget. Working with business units and process experts to resolve master data issues ensuring data quality, compliance and consistency across business systems. Revamping of the Mission's website using Drupal framework including implementation of Search Engine Optimization (SEO) Maintaining database security, integrity, reliability, and availability; monitor performance and capacity requirements. Data Analytics Consultant Credent Partners Oct 2023 - Feb 2024 / Geneva, CH Leveraged Tableau to create dynamic data visualizations, which improved datadriven decision making accuracy by 75% among Health portfolio clients. Developed and maintained the master data management system, including data integration, data modeling and data migration. Conducted in-depth data visualizations user trainings, leading to over 50% increase in usage and understandability of data reports and forecasts Participated in projects and initiatives across multiple functional areas and regions e.g. reporting /visualizations for clinical trial studies IT Specialist Consultant Permanent Mission of Kenya to United Nations Jul 2022 - Sep 2023 / Geneva, CH Worked with business stakeholders to give a 360-degree view of their data requirements and ensure that the MDM solution meets their needs. Collaborated with cross-functional teams on process improvement initiatives and achieved over 30% increase in Mission's portfolios delivery time. Defined and enforced policies and procedures for managing data assets, including product data quality, data stewardship, and reference data security including development of Business Continuity and Data Recovery Plan Diagnosed and repaired network malfunctions including file deletion, failed account entry, slow computer speed, and 3rd party software compatibility issues Database Coordinator Michelangelo Foundation Oct 2021 - Jun 2022 / Geneva, CH Led data mapping efforts for over 45 Axiell data tables and collection of user requirements for 14 new business processes in readiness for Salesforce migration. Assisted in the migration of on-premises applications to Salesforce, ensuring seamless transitions and minimizing disruption to end-users. Conducted regular security audits and vulnerability assessments of Axiell system, resulting in a 50% reduction in unavailability or security incidents. Ensured the accuracy, completeness and consistency of master data across the organization, from customer master data to data standards and customer records. Wrote Python scripts for automating routine tasks, saving an average of 10 hours per week for the team. Data Analyst Panorama Global Apr 2020 - Jun 2021 / Geneva, CH Received, cleaned, and prepped supply chain data using Python, SQL, and Excel to ensure that all available supply chain data is collected for joint usage and joint decision making across the donor partners Built out the data and reporting infrastructure from the ground up using Python, Power BI and SQL to provide real-time insights into in-country supply chain KPIs Analyzed master data and data sources and identified trends and patterns that could be used to improve business processes and operational efficiency, including data-driven decision-making. Data and Analytics Specialist World Economic Forum Jan 2019 - Mar 2020 / Geneva, CH Collaborated with the Public Engagement and Foundation teams to create interactive data dashboards in Sisense, enhancing data accessibility by 65%. Leveraged expertise in Amazon Redshift and SQL to optimize data storage and retrieval processes, resulting in a 40% reduction in data retrieval times. Developed Centre for Cyber Security leadership web platform scenarios in Qualtrics, improving data accuracy by 75% Supported the development of collaboration and planning tools, and data journalism products, resulting in over 15% increase in user engagement. Database Specialist Aga Khan Development Network Feb 2014 - Jun 2018 / Geneva, CH Conceptualized and developed databases and specific guidelines on good research data practices, ensuring that Research Data Management (RDM) is integrated with existing research information management and publications systems Spearheaded the adoption of Cloud Infrastructure and innovative technologies, reducing manual tasks by 71% and enhancing consistency. Ingested data from disparate data sources using SQL, Google Analytics API, and Salesforce API using Python to be used in BI tools like Tableau
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.