Customer Service Sales

L

U

C

Y

R

U

T

H

Z

I

M

B

A

-

H

I

N

T

Z

E

N

***** ***** ** #****

D

a

l

l

a

s,

T

X

7

5

2

5

4

.

**********@*****.***

Cell: 214-***-****

OBIEE DEVELOPER

Executive Summary

. Over 3 years of experience in Oracle Business Intelligence Enterprise

Edition 11g

. Expertise in OIEE 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, BMM, applying business logic, dimensional hierarch modeling,

time series modeling, aggregation, creating logical column, and

calculation wizards

. Identified facts, dimension, KPIs for different business models

. BI answers- developed many reports/dashboards in different subject

areas with different analytical views (narrative, chart view, graphs,

pivot table, column selector, view selector with drill down capacity)

. Performance tuning experience includes setting user log variables to

diagnose performance issues, cache management, aggregation, event

polling tables, usage tracking tables

. OBIEE Tools used: Oracle BI Administration, Presentation Services, Bi

Delivers

. Configured security, creating users and groups, assigning permissions

to them

Mortgage Contracting Services 04/2011 To date

OBIEE Developer

. Meet with business representatives, business analysts and end users to

understand the business models and functionality.

. Built the Physical, Business Model and Mapping and Presentation Layer

of the repository.

. Used BI answers to run queries, test, and reports and validated the

repository.

. Created dimension hierarchies and level based measures, built time and

calculated measures of a fact table.

. Customized Data modeling of score cards using departmental metrics and

KPIs

. Worked on various reports /Dashboards in BI Answers with different

analytics views (drill-down, dynamic, Narrative views, charts, pivot

tables, column selector, and local filters

. Created groups in the repository and added user to the groups and

granted privileges explicitly through group inheritance.

. Worked on performance tuning including creating aggregate tables,

caching and event polling tables.

. Created iBots for job-critical levels and auditable differences

delivered to dashboards, email and cell phones to assist process

owners with timely decision making

. Tested and modified OBIEE security for the internal controls

environment

Mortgage Contracting Services

Systems Reporting Analyst 04/2008 to 04/2011

. Created Adhoc reports for management on daily production of client

ordered

. Supported and analyzed billing process to ensure deadlines were met to

avoid chargebacks.

. Created reports for different process to monitor vendor compliance.

. Created pivot table reports supporting employee production

. Liaised between client and company in billing discrepancies and

provided supporting documents.

. Managed special accounts to ensure revenue goals were reported timely

and recommended follow up measures

. Audited Vendor invoices to reduce billing discrepancies and reported

to vendor management the inconsistencies

Capital One Auto Finance (Contractor) 02/07 -02/08

Reporting Analyst

. Analyzed Auto Loan contracts for dealerships and customers

. Worked on Risk Assessment Financing of each loan to mitigate company

losses

. Reported and analyzed Account management of contract prior to funding

. Created reports capturing company's Loans origination to increase

customer base revenue.

Verizon Wireless 08/03- 05/06

Support Specialist

. Consulted on wireless solutions to business and consumer clientele and

added value through delivery of products and services

. Analyze sale increased consumer clientele by new activations and

contract renewal increasing company's revenue

. Created customer service reports for servicing department to follow up

on churn process

. Created report on customer turn over that aided customer product

knowledge training

. Developed reports tracking sales department sales

Stewart Enterprise 11/02-07/03

Family Counselor Sales consultant

. Counseled grief families at need of property arrangements

. Assisted families in selection of burial properties and options based

on financial capability

. Proactively consulted and educated clients on plan-pre-need

arrangements

. Generated revenue through sales burial properties, policies

Environmental Council 02/99 - 10/00

Industrial & Environmental Inspector

. Responsible inspecting Industries for occupation health compliance.

. Educated public on environmental health issues.

. Identified areas of research pertaining to health issues resulting

from pollution.

. Participated in reviewing of environmental Acts to eliminate legal

overlaps.

. Assisted in advising the government on environmental health policy

formulation.

. Resolved domestic and industrial pollution complaints.

. Responsible for writing reports and planning monthly activities for

the department.

. Coordinated multi-disciplinary industrial inspections.

. Assisted in developing a three-year strategic planning for the

Country's Pollution problems.

. Assisted reviews of the country's Environmental Impact Assessment

project reports.

. Contributed to Local and International training and Conferences on

Environmental affairs.

Wayne State University Detroit, Michigan 06/97 - 08/97

Industrial Health and Systems Internship

. Assisted in laboratory safety consultations and training services.

. Initiated implementation health effects of Methylene Chloride survey

for Wayne State University.

. Collected and analyzed Environmental Health field data.

. Attended and assisted in training seminars on environmental health and

safety issues for Staff of Wayne County Health Institutions.

Ferris State University (Summer Block Group Projects)

RICHARDSON'S OIL PROJECT

. Performed Phase I and Phase II Environmental Impact Analyses

. Assisted in the physical collection of data for the project

. Assisted in the interpretation of Lab results for the client and

Department of Natural Resources (DNR)

. Assisted writing and editing final report for publication

. Prepared recommendations and provided technical advice to the client.

WEE-Gen natural Resource Evaluation (PHASE I & II)

Responsible for gathering data on the project findings in the Phase II

Environmental Analysis

Assisted in recommendations and technical advice to the residents of area

on natural resource sustainability based on data analysis

As part of editing committee assisted in finalizing report publication to

the Department of Natural resources(DNR)

EDUCATION

Bachelor of Science Degree (Honors): Industrial and Environmental Health

Management at Ferris State University Big Rapids, Michigan 49307

Certifications

Oracle Business Intelligence Enterprise Edition 11g.

Contact this candidate