FARAI CHIRAWU

AI Solutions Architect • Business Intelligence Developer • Digital Transformation Strategist

Email: faraichirawu@gmail.com  •  Tel: +1 (310) 948-7673  •  www.linkedin.com/in/faraichirawu  

↓ Download PDF Resume

PROFESSIONAL SUMMARY

Results-driven Business Intelligence Developer and Data Analyst with 16+ years of experience in the U.S. and international markets, delivering end-to-end data solutions across sales, supply chain, finance, and operations. Specialized in Oracle Analytics Server (OAS), Power BI, AI-assisted development, and enterprise data transformation. Proven ability to design impactful dashboards, lead technology adoption initiatives, optimize complex SQL queries, and extract actionable insights that improve business performance. Adept at mentoring teams, delivering training programs, and fostering a culture of self-service analytics. Passionate about data democratization and using analytics to drive digital transformation in emerging markets.

TECHNICAL SKILLS

AI & GENERATIVE AI ChatGPT, Claude, Perplexity, Gemini, DeepSeek, Cursor, AI-assisted coding, prompt engineering
REPORTING & BI TOOLS Power BI, Oracle Analytics Server (OAS), OBIEE 11g/12c, Tableau, SSRS
DATABASES Oracle 10g/11g/12c, MS SQL Server, MySQL, Firestore, SQLCipher
DATA INTEGRATION & ETL MS SSIS, Oracle Data Integrator (ODI), SQLCipher-to-Firestore pipelines
PROGRAMMING LANGUAGES SQL, Python, JavaScript, Java, PHP (Laravel), Dart/Flutter, DAX, D3.js, HTML/CSS
CLOUD & PLATFORMS Azure, Firebase, Django, WordPress/Elementor

PROFESSIONAL EXPERIENCE

Lead AI-Assisted Application Developer
Biomedical Research and Training Institute (BRTI) — Contract
May 2025 – Present  •  Harare, Zimbabwe (Remote)
  • Lead end-to-end development of Tsime Care, a cross-platform mobile health education app (iOS/Android) using Flutter, enabling testing across 5+ district community clinics and providing nurses with offline access to training materials.
  • Accelerate software development speed by 70% through strategic use of AI coding assistants (ChatGPT, Claude) while upholding strict standards for code quality and system architecture.
  • Build backend infrastructure using Django/Python, integrating Firestore (cloud NoSQL) and SQLCipher (encrypted mobile database) for secure data processing and validation.
  • Design comprehensive data architecture and embedded analytics for health research data collection, applying 16+ years of BI expertise to ensure high data integrity and user-centric reporting.
  • Implement role-based access control (RBAC), data classification protocols, and row-level security to ensure authorized access only.
  • Design and implement ETL pipelines synchronizing offline mobile data (SQLCipher) with cloud data warehouse (Firestore), handling validation, transformation, and conflict resolution.
  • Collaborate with health researchers and program managers to align technical outputs with research objectives, managing timelines and deliverables throughout the full lifecycle.
Senior AI & Data Strategy Consultant
Fronteras Advisory — Contract
Jan 2024 – Feb 2025  •  Harare, Zimbabwe (On-site)
  • Provided strategic advisory services to African investment portfolio companies on AI adoption, data-driven decision-making frameworks, and digital transformation roadmaps.
  • Led AI transformation initiatives, evaluating and implementing AI-assisted development tools and ML capabilities to accelerate software delivery cycles.
  • Conducted comprehensive feasibility assessments for integrating AI/ML capabilities into enterprise applications, advising executive leadership on leveraging AI for operational efficiency.
  • Designed data architecture and analytics strategies for portfolio companies transitioning to AI-enabled business models.
  • Developed business value use cases for data analytics, AI, and ML, demonstrating measurable business outcomes.
  • Established data governance policies, implementing data stewardship roles, metadata management, and data cataloging initiatives.
Senior Business Intelligence Developer
Mazda North American Operations — Contract
Mar 2019 – Nov 2023 • Irvine, CA (Remote)
  • Led enterprise-wide analytics platform migration from Oracle OBIEE/OAS to Azure and Power BI, managing change across multiple business units with zero business disruption.
  • Designed and delivered a comprehensive training program for 50+ business users across sales, finance, and operations, achieving a 40% reduction in report development turnaround time.
  • Collaborated with cross-functional teams to enhance and maintain 27+ dashboards across key departments, aligning analytics with evolving KPIs.
  • Developed complex data models in Oracle Analytics Server for drill-down insights and custom performance metrics across sales, supply chain, and financial operations.
  • Implemented comprehensive data governance framework including 200+ user access management, row-level security, and GDPR/CCPA compliance measures.
  • Architected and maintained ETL workflows using ODI to process millions of records daily across sales, finance, and supply chain operations.
Co-Founder
Xenofy Inc
Jan 2019 – Mar 2019  •  Los Angeles, CA
  • Co-developed a two-sided e-commerce marketplace connecting international travelers with clients seeking cross-border product delivery.
  • Oversaw a multidisciplinary team of 5 using Agile/Scrum to launch an MVP quickly.
  • Developed a full-stack web application using PHP Laravel and MySQL with secure authentication, payment integration, and order tracking.
  • Conducted primary market research via in-person surveys to validate feasibility and achieve product-market fit.
Business Intelligence Consultant
Bioclinica — Full-time
May 2017 – Jan 2019  •  Princeton, NJ (On-site)
  • Developed SQL Server data infrastructure using star schema design patterns, improving reporting capabilities and query performance across clinical trial analytics platforms.
  • Built ETL processes using SSIS packages to move clinical trial data from source systems into centralized data warehouses.
  • Defined KPIs and metrics on SSRS dashboards to monitor patient enrollment, site performance, and milestone tracking across multiple clinical trials.
  • Created indexed aggregation tables, summary views, and OLAP cubes in SQL Server, improving dashboard load performance by 50%+.
  • Implemented row-level data security using SQL Server security policies for HIPAA compliance and data segregation.
Oracle BI Developer (Business Analyst)
Oracle — Contract
Oct 2014 – Dec 2016  •  Morrisville, NC (On-site)
  • Developed interactive OBIEE dashboards and scorecards measuring telecommunications network performance metrics and ISO/IEC TL 9000 quality management KPIs.
  • Designed dimensional data models using star and snowflake schemas, creating hierarchical business models in OBIEE repository.
  • Created and maintained OBIEE metadata repository (.rpd) files, configuring Physical Layer, Business Model, and Presentation Layer subject areas.
  • Implemented object-level security using OBIEE application roles and LDAP integration to control dashboard and report access.
  • Established multi-user development environment (MUDE) using version control and repository merge strategies for parallel development workflows.

EDUCATION

Master of Business Administration (MBA)

University of Maryland Global Campus — Adelphi, MD  •  May 2012

Bachelor of Science in Computer Science (BSc)

Northern Kentucky University — Highland Heights, KY  •  Dec 2006