Farai Chirawu

310-***-**** adef7l@r.postjobfree.com

Experience

Mazda USA, Irvine, CA

Business Intelligence Consultant March 2019 - Present

• Lead developer responsible for converting desktop dashboards into responsive mobile friendly dashboards

• Created department standards for future dashboard and ad hoc reports

• Developed a customized calendar with customized time series functions based on MazdaUSA sales calendar

• Designed a constellation schema and modified a date dimension table with custom date attributes

• Translated SAP business object reports into OBIEE reports

• Perform RPD cleanup and environment migration in conjunction with the OBIEE support team

• Responsible for developing, debugging and optimizing RPD/ Dashboards / ad-hoc Reports

• Collaborate with database and OBIEE support teams to improve data infrastructure and reporting data Xenofy Inc, Los Angeles, CA

Co-Founder July 2018 – March 2019

• Developed Xenofy.com using PHP Laravel 5.7 Framework

• Developed testing strategy for MVP and consolidated information to develop a newer version of the platform

• Integrated PayPal, Stripe and Mailchimp to the Xenofy platform

• Onboarded part-time developers to help assist in the development of the platform BioClinica, Princeton NJ

Business Intelligence Consultant Jan 2017 – June 2018

• Modeled aggregate tables to speed up query processing, partitions and fragments to improve application performance Worked on OBIEE Answers to build Interactive Dashboards and Reports with drill-down capabilities.

• Defined KPIs on dashboards and reports to monitor analyzed clinical trial projects

• Developed a framework for automating and scheduling reports on clinical trial project

• Created aggregated database tables to improve loading performance on dashboards and ad hoc reports

• Created interactive and customized ad hoc reports for various clinical trial project managers and department heads

• Implemented data level security based on user roles and privileges to assigned clinical trial projects Oracle, Morrisville NC

OBIEE BI Developer Oct 2015 - Dec 2016

• Developed interactive dashboards that measured Oracle’s performance related to ISO TL 9000 industry certification

• Wrote and debugged SQL queries to improve report and dashboard performance

• Designed dimensional hierarchical business models for hierarchical dashboards and reports.

• Created and modified Metadata repository (.rpd) using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers

EDUCATION

Northern Kentucky University Highland Heights, KY

Bachelor of Computer Science December 2006

University of Maryland, University College Largo, MD Master of Business of Administration May 2012

Software/IT Skills

Windows, MacOS, OBIEE 11G, Power BI, SQL, Java, PHP, JavaScript, D3.JS HTML, CSS

Contact this candidate