Rodney Gitonga

About Me

I am a Data & IT Specialist specializing in transforming complex financial and operational data into actionable business insights to enhance operational efficiency. My expertise is focused on the intersection of data visualization, SQL optimization, and business process automation within the financial sector. My core mission is to drive data-informed decision-making by architecting robust SQL views and developing dynamic Power BI dashboards.

Download CV

Beyond Code

  • Mentorship

    I actively mentor junior developers, helping them bridge the gap between theory and real-world application.

  • Photography

    Capturing moments helps me appreciate composition and detail—skills I translate into UI design.

Professional Experience

March 2026 – Present

Data & IT Support

GULF AFRICAN BANK
  • Translated complex business requirements into functional technical specifications, delivering high-impact Power BI reports and dashboards for finance and business stakeholders.
  • Conducted advanced exploratory data analysis (EDA) using SQL (aggregations, joins, transformations) to extract actionable insights for executive decision-making.
  • Deployed statistical models on large-scale datasets to drive predictive analytics and enhance business intelligence capabilities.
  • Architected and maintained Canvas and Model-Driven applications within the Microsoft Power Platform to automate critical internal workflows.
  • Engineered seamless Power Automate flows to integrate data sources, apps, and services, significantly improving internal operational efficiency.
  • Troubleshot and resolved complex issues related to report performance, data refresh latency, and app functionality, including weekly analysis of remote query execution times.
  • Collaborated directly with the Data Engineer and ICT teams to design robust analytics architectures, ensuring daily data loads were complete, accurate, and consistent.
  • Enforced strict data governance, maintaining compliance with internal banking policies and regulatory standards across all data pipelines.
  • Authored comprehensive technical documentation (data dictionaries, user guides, solution designs) and provided hands-on training to upskill end-users on Power BI and Power Apps.
September 2025 – March 2026

Data Analytics Officer

GULF AFRICAN BANK
  • Managed and optimized ETL (Extract, Transform, Load) processes to ensure the timely and accurate delivery of data for reporting and analysis.
  • Designed and built Power Apps solutions to streamline operations and automate workflows across different bank departments.
  • Performed comprehensive data analysis to identify trends, forecast performance, and support strategic planning.
  • Translated raw banking data into actionable visualizations, supporting executive decisions on P&L and risk.
  • Developed and maintained the foundational data layer (views) used for major Power BI dashboards across the bank.
  • Partnered with business units to define requirements and deliver custom Power BI solutions for performance tracking.
  • Led the end-to-end data visualization process, from requirement gathering to dashboard creation, ensuring reports were tailored to meet the strategic needs of various business units.
July 2025 – September 2025

Data Analytics Engineer

GULF AFRICAN BANK
  • Built Microsoft PowerApps solutions to streamline branch-level processes, improving efficiency and user experience across bank operations.
  • Designed and developed interactive Power BI dashboards to visualize key financial and operational metrics, enabling data-driven decision-making.
  • Gained hands-on experience in integrating Power BI dashboards with MySQL servers, ensuring seamless data connectivity and real-time reporting.
January 2025 – July 2025

IT Support Specialist

GULF AFRICAN BANK
  • Provided responsive end-user support and resolved technical issues to ensure smooth day-to-day operations across banking systems.
  • Delivered on-site and remote technical support for hardware, software, and peripheral devices across multiple departments.
  • Assisted in the maintenance, configuration, and monitoring of enterprise systems including core banking applications and business information systems.
  • Contributed to network troubleshooting and supported RESTful services in the organization’s internal applications.
  • Supported the IT Service Desk by handling incident reports, logging issues, and escalating where necessary to improve resolution times.
  • Participated in routine system updates, patching, and maintenance tasks, improving system performance and uptime.
May 2024 – January 2025

Office Accountant & IT Assistant

VOI WINNERS HOUSING COOPERATIVE SOCIETY LIMITED
  • Managed daily financial operations, including ledger reconciliation, billing, and budgeting processes.
  • Oversaw real estate property management tasks, coordinating tenant interactions and lease documentation.
  • Handled client liaison and customer service, addressing inquiries and providing administrative support to senior management.
  • Led the IT infrastructure management for the cooperative, including network setup, administration, and hardware/software support.
  • Designed and implemented digital communication strategies to improve engagement and streamline internal operations.
  • Proactively troubleshot and resolved IT issues, ensuring minimal downtime and enhancing system reliability for daily business functions.
June 2022 – October 2022

Junior Software Developer Intern

NUMERAL IOT LIMITED
  • Developed web applications using AngularJS, ensuring responsive and user-friendly interfaces.
  • Installed, configured, and maintained Windows Server environments to support business operations.
  • Managed web hosting environments using cPanel, including domain and email configurations.
  • Provided ongoing website maintenance and technical support to ensure optimal performance and uptime.
  • Performed hardware diagnostics, repairs, and general computer maintenance.
  • Supported system-level troubleshooting, configuration, and optimization for enhanced reliability and performance.

Technical Arsenal

analytics

Power BI (Advanced Dashboarding & DAX)Data Analysis & Data ModelingFinancial Analysis & ForecastingData Storytelling & VisualizationETL & Data Warehouse ConceptsMicrosoft Excel (Advanced)

databases

SQL (Query Optimization, Views, Stored Procedures)MySQLMongoDBDatabase Administration (Basic)Data Integrity & ValidationData Engineering Principles

programming

Python (Pandas, NumPy, Scikit-learn)JavaScript / AngularJSREST APIs & IntegrationProcess Automation (Power Apps, Python)

cloud

Oracle Cloud Infrastructure (OCI)Amazon Web Services (AWS)Git & Version ControlDocker & Containerization

systems

Windows Server & Active DirectoryNetwork Troubleshooting (TCP/IP, DNS)ITIL Principles & Service DeskSystem Hardening & Security

softSkills

Clear CommunicationProblem ResolutionCross-functional CollaborationAdaptability & Learning