Polycap Orina Mageto

POLYCAP ORINA MAGETO - |-https://www.linkedin.com/in/polycap-orina-24b2ab18a/ DATA ANALYST | BUSINESS INTELLIGENCE Expert in data analytics, visualization, and business intelligence, with proficiency in Python, R, SQL, Power BI, and Excel. Skilled in building dashboards, creating ETL pipelines, and automating workflows to transform raw data into actionable insights. Passionate about leveraging data storytelling and predictive analytics to drive informed business decisions. SKILLS Data Visualization : Power BI, Tableau, Excel, Seaborn, Matplotlib,GGplot2. Data Wrangling : Excel, Power Querry, DAX,Python, SQL, R studio. Statistical Modelling/ Hypothesis Testing : IBM SPSS, JASP,JMP. MS Fabric Data Engineering :Semantic Models, OneLake, ETL pipelines. Data Storytelling UI/ IX : Mockup AI, FIGMA, Canva Power Apps, CRM / Azure Devops / Dataverse. Statistical Modelling Techniques : Hypothesis Testing, Linear Regression & Multivariate Analysis MS Purview: Data Governance, Data Map, Compliance Manager, Data Lifecycle management PROFESSIONAL EXPERIENCE Digital Qatalyst (UAE) Data Analyst September 2024 - Present Designed and deployed 50+ interactive dashboards using Power BI and MS Fabric, delivering real-time insights for reputable clients such as; MoI UAE, STC Bank, ADIB, NEOM, DFSA, and Khalifa Fund, improving decision-making efficiency by 30%. Built and optimized ETL pipelines with PySpark and Apache, reducing data processing time by 35% for large datasets and ensuring seamless integration across platforms. Led data intelligence initiatives, bridging analytics, data science, and data engineering to enhance predictive analytics, forecasting, and automation for key clients. Integrated Dataverse, Power Apps, and Azure Data Factory, automating data ingestion and reducing manual reporting efforts by 60%. Supported data-driven asset performance management with ABB Genix, leveraging analytics to predict failures and optimize operations, reducing downtime by 20%. Implemented data governance and compliance using Microsoft Purview, ensuring regulatory alignment and improving data cataloging efficiency by 25% Adrians Passion Tech Business Intelligence Analyst August 2022 - September 2024 Leveraged Python, R, and SQL to identify trends and built Power BI & Tableau dashboards, enhancing decision-making speed by 30%. Developed real-time reporting systems, reducing reporting lag by 30% and uncovering key cost-saving opportunities. Forecasted sales and customer churn with 15% higher accuracy, optimizing resource allocation and risk management. Integrated data analytics into marketing, finance, and operations, increasing campaign effectiveness by 25% and improving financial forecasting accuracy. Built and deployed advanced statistical models in Python and R, improving predictive analytics accuracy by 35% over 12 months. Ramsa Tech Business Analyst July 2021 - May 2022 Leveraged Python, R, and SQL to identify trends and built Power BI & Tableau dashboards, enhancing decision-making speed by 30%. Developed real-time reporting systems, reducing reporting lag by 30% and uncovering key cost-saving opportunities. Forecasted sales and customer churn with 15% higher accuracy, optimizing resource allocation and risk management. Integrated data analytics into marketing, finance, and operations, increasing campaign effectiveness by 25% and improving financial forecasting accuracy. Built and deployed advanced statistical models in Python and R, improving predictive analytics accuracy by 35% over 12 months. Kenya Wildlife Service (KWS) April 2019 - September 2019 Statistician Intern Improved population estimates by 15% using linear & logistic regression, enhancing conservation resource allocation. Built predictive models with time series & machine learning, reducing poaching incidents by 25%. Applied PCA & cluster analysis to assess habitat health, driving a 20% improvement in restoration efforts. Mapped wildlife migration patterns with GIS & spatial analysis, reducing human-wildlife conflicts by 30%. Automated data processing in R & Python, cutting data entry errors by 40% and accelerating reporting. Designed and executed field studies, using ANOVA & mixed-effects models to support conservation policies. EDUCATION Multimedia University Bsc Electrical & Telecomunication Engineering(2020) Kisii High School Kenya Certificate Secondary Education (2014) CERTIFICATIONS Microsoft Certified: Power BI Data Analyst Associate (2024) – Power BI, DAX, data visualization, reporting. IBM Data Science Professional Certificate (2023) – Python, machine learning, SQL, predictive modeling.