Farai Dzangare
Rowlett, TX
Cell: 972-***-****
Email: ********@*****.***
Executive Summary
• 2+ years’ experience in Oracle Business Intelligence Enterprise Edition
• Expertise in OBIEE complete life cycle; business requirement gathering, analysis, design, data modeling
• Developed metadata repositories (Physical layer, BMM layer, & Presentation layer)
• Development included creation of connection pools, setting alias tables, identifying facts, dimensions & KPIs, building physical models both star & snowflake, applying business logic, dimensional hierarchy modeling, time series modeling, aggregations, creating logical columns, calculation wizards, filtering, & creating subject areas
• Deployed many RPDs using BI Enterprise Manager
• BI analytics – developed many reports/dashboards in different subject areas with different analytical views (pivot tables, graphs and gauges)
• Performance tuning experience, using cache management, aggregation & star schema modeling
• Experience with change management including User Acceptance Testing (UAT)
• OBIEE Tools used: Oracle BI Administration, Analytics, Console, Enterprise Manager
• Configured security, creating users and groups, assigning permissions to them
• Operated in Multi-User Development Environments (MUD)
Technical Summary
• Platform: Windows XP, Windows 7
• Business Intelligence: OBIEE 11.1.1.5
• Microsoft Excel, PowerPoint, Word
Work Experience
05/09 - 12/11 TAMU Honors Programs College Station, TX
Oracle Consultant
• Met with Subject Matter Experts (SME), president of department and other end users to understand
the business models and functionality
• Built the Physical, Business Model and Mapping & Presentation Layers of the repository
• Used BI answers to run queries, reports, & test and validate repository
• Created dimensional hierarchies and level based measures, created logical columns and calculated
measures of a fact table
• Customized data modeling using departmental metrics and KPIs
• Worked on various reports/Dashboards in BI analytics with different analytical views
• Created users and roles in the BI console and added them to the groups that were created in the EM
02/09 – 11/09 Dairy Queen Bryan, TX
Shift Manager
• Understood all areas of the daily running of business so that I could help were needed
• Handled any customer complaints in a prompt and courteous manner
• Decided when to let employees off early based on business need
• Handled daily earnings and reported them in the system
• Made sure that goods were kept stocked as needed
07/08 – 02/09 Pizza Hut Bryan, TX
Delivery Driver
• Delivered pizza’s in a prompt fashion
• Took customer orders courteously
• Helped in clean up at the end of the day
EDUCATION:
Hillcrest High School High School Diploma Dallas, TX
Texas A&M University Bachelor of Arts College Station,TX