Rodney Gitonga

About Me

I am a Data Analytics Officer 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

September 2025 – Present

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 Intern

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 Intern

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