Joyce Utoh
PH: 704-***-****
Columbia, SC 29210 *********@*****.***
Profile
Accomplished IT and Oracle Business Intelligence Professional with a history of responsibility and innovative roles in performance-based technology organizations. Analytical hands-on team contributor who is focused on providing viable solutions to exceed organizational goals and expectations. Experienced in areas of application design, data modeling, development, testing and Implementations of Oracle Business Intelligence. Open to challenges in area of site management and related career disciplines with avenues for continued learning and growth.
Technical Skills/Proficiencies
SQL Oracle SDLC SQL Server 2000 Windows 2000 XP Microsoft Word Power Point Excel OBIEE Versions: 11.1.1.6.0 Seibel Analytics OBIEE 11g BI Publisher 11g Certification – Oracle 11g
Professional Experience
Amazon, Inc, Columbia Sc 2015 -
Analysis of how orders ae related to regions and products
Correlate order information with sales revenue, fulfillment performance and customer loyalty.
Measure how effective raw materials and finished goods inventories across multiple location are being managed
Maximize revenues by ensuring supply of goods while keeping inventory levels low.
Experience in OBIEE repository (Physical, Business and presentation layer).
Performed data validation of data in report and dashboard.
Experience in data and object level security in OBIEE
Created dimension hierarchy, level based measures, and derived column of business metrics in the BMM layer.
Acquired data model experience in star schema design, fact and dimensional tables.
Generated reports and dashboard by using Pivot table, charts and column selector, and view selector features.
Comfortable with OBIEE end design & development and ETL process for deploying OBIEE reporting solutions.
Pacific System, Inc., McDonough, GA 2012 – 2015
OBIEE Developer
Responsible for working closely with the business users and producers to ensure that business requirements were correctly translated into database schema and ultimately into application. Built, organized and maintained software applications and services for customers.
Created and customized OBIEE repository (Physical, Business, and Presentation).
Created dimension hierarchy, level based measures, and derived column of business metrics in the BMM layer.
Acquired data model experience in star schema design, fact and dimensional tables.
Generated reports and dashboard by using Pivot table, harts and column selector, and view selector features.
Comfortable with OBIEE end design & development and ETL process for deploying OBIEE reporting solutions.
Created master detail reports with year and revenue columns.
Acquired data level and object level security in OBIEE Analysis.
Performed data validation of data in report and dashboard.
Customized reporting with OBIEE Analysis and integrated results into the Dashboards.
Cendant Corp., Chicago, IL 2011 – 2012
OBIEE Developer
Responsible for gathering business requirements and interacting with business users. Defined subject area for analytical requirement.
Customized the repository, physical, BMM, and presentation layer. Performed data validation of data in report and dashboard.
Created dimension hierarchy, level based measures, and derived column of business metrics in the BMM layer.
Created dashboard with column selector navigation. Created dashboard with dashboard prompts, charts, and pivot tables.
Modified Presentation Layer to add presentation tables and columns to meet business user needs.
Customized reporting with Siebel Answers and integrated results into the Dashboards.
Generated Reports and Dashboards with Pivot tables, charts and View Selector Report features.
Joyce Utoh
Quality Certain, Inc., Atlanta, GA 2010 -2011
Quality Assurance Analyst
Responsible for verifying business requirements and functional specifications.
Conducted system functionality and performance testing. Developed and executed test cases.
Performed end to end and smoke testing on application to mimic real world use and to ensure requirements were met.
Performed regression testing. Executed test cases to test the application and evaluated the results.
Analyzed and reported the defect to developers using Mercury Quality Center.
Strayer University, Charlotte, NC 2007 – 2009
New Mexico Institute 2004 – 2006
Exxon Mobile, Lagos, Nigeria 1999 – 2003
Contract Staff/Coordinator
Responsible for analyzing contractor documents and data entry. Extensive experience in warehouse systems and information presentations to upper management. Engaged in public relations between company affiliates and local communities.
Education
Strayer University, Charlotte, NC 2007 – 2009
MBA
New Mexico Institute of Mining and Technology 2004 – 2006
Masters in Engineering Management (MEM)
University of Nigeria Nsuka (Statistic/ Economics) 1994 – 1998
Minor in Economics
Core Competencies
Goal Oriented Multi-Task Ability Negotiation and Management Skills Communication Skills Planning/Organizational Skills Enthusiastic,Team Contributor Strong Work Ethic Decision Making Time Management