Customer Service Oracle

Cesar A. Parra

57-318-******* / ********@*****.***; **************@*******.***

Cali, Colombia, South America

I have seven years of strong experience in decision support systems and

management, Strategy Planning, Management Project, data warehousing, and

data modeling. I have extensive experience in designing, developing web-

enabled OLAP and MOLAP applications within financial, Insurance and

beverage industry. Background includes requirements analysis, system

design, prototyping, coding, implementation, maintenance, documentation,

planning and scoping of applications at all client sites. I am implemented

applications using Hyperion Essbase, Hyperion Integration Services, Oracle

10g OLAP, Analytical Workspace Manager, Oracle Discoverer 10g

Administrator/Plus, some knowledge in Hyperion Planning and Hyperion

Financial Management and another principal skill is project management live

cycle. Additional skills include Oracle Warehouse Builder, PL/ SQL,

MicroStrategy SQL*Loader, PL/SQL,, system administration of Oracle 8i/9i

in Windows NT Platforms, my last implementation technology was DBI (Daily

Business Intelligence for BackOfice and SCM and CRM) in Version 7.2 and 7.3

in Oracle, I did all the training and Quick reference for all that module

DBI have. I did 20 full international implementation in BI Solution and

OBIEE.

I was working in Sales tools with my success.

Professional Experience

Project Project Management Life Cycle

Hyperion Essabase

Planning

Perfomance ScoreCard

Web Analysis and Report Financial

Shared Services

Integration Services

Design and Implementation Security model in Planning

Oracle 10 & 11 Analyze Dimensions, Hierarchies and Levels for reporting

R2 and Business Process creation.

EPB & EPF Create database schema In OWB.

Design and create Business Process in OWB.

Identify GL segments and Create OGL link to export data

from GL

Oracle ERP Oracle Business Intelligence Enterprise Edition Plus.

Business Oracle Balance ScoreCard

Intelligence Created Hierarchies, Attributes, Financial Data Items, Data

Intregation Access Controls, Distribution objects, setting up of users.

EDW, BIS and

DBI Did data acquisition, transformations, production migration

and support activities.

Generated and published web reports using Web Agent.

Validated report results against Oracle.

Completed, updated and documented reports.

Configured database performance tools viz. Oracle

Enterprise Manager, SQL Navigator and used them for tuning

of applications.

Applied patches to production and development database

servers.

Provided 24 X 7 on call support.

Inventory Intelligence

Manufacturig Intelligence

Product Cost Intelligence

Fullfitment Intelligence

Backlog and Booking

Customer Service Intelligence

Contract Intelligence

Marketing Intelligence

Sales Intelligence

Account Payables Intelligence

Purchasing Intelligence

Revenue Intelligence

Discoverer 10g Mapped source data to target database Oracle 8i.

and Prepared document for source to target mapping.

MicroStrategy Create multi dimensional data modeling for Front End

Reports.

Designed front-end reports using Discoverer and

MicroStrategy

Designed cubes for browsing using Discoverer and

MicroStrategy

Wrote menu using Discoverer and MicroStrategy Script

Editor.

Wrote PL/SQL scripts for data population Warehouse Builder

10g

Tested and debugged scripts.

Prepared user manual.

CRM Marketing Intelligence

Sales Intelligence

Contract Intelligence

Customer Service Intelligence

SCM Manufacturing Intelligence

Inventory Intelligence

Product Cost Intelligence

Fulfillment Intelligence

Back Office Financial Intelligence

Revenue

Purchasing

Account Payables

Skills Summary

Oracle Platform Oracle 10g Release 2 Oracle Financial Analyzer

and Oracle 9i OLAP EPB (Less 6 Month Knowledge)

Architecture Analytic Workspace Manager Hyperion Essabase

10g Hyperion Shared Services

Discoverer 10g Hyperion Integration Services

Oracle Warehouse Builder

(ETL) Hyperion Planning

Hyperion Financial Managment

Hardware & Windows NT

Operating Windows 2000 Red Hat Linux (Less 6 Month

Systems Knowledge)

Programming OLAP PL/ SQL

Languages ROLAP SQL*Loader

MOLAP HTML

C++

Engagement Applications Development End User Training

Experience Data Conversion Technical Architecture and

Unit, Integration, System Configuration

Testing Project Management

Tuning

Methods Data Warehouse Development Ralph Kimball DW Methodology

Life Cycle

Industry Banking Insurance

Finance Communication

Baverage

Other Accomplishments

Education San Buenaventura University, Cali, Colombia, South America

URL: http://usb.edu.co

MBA Heriot Watt University Edinbugh Business School -

Studing

Training Hyperion essbase, Shared Services, Report, Web analyzer,

Planning

Oracle Business Intelligence Enterprise Edition Plus.

Joomla

Oracle Discoverer 10g Admin/Plus

Oracle Enterprise Planning and Budgeting (EPB)

Oracle Enterprise Performance Foundtaion (EPF)

Oracle 10g OLAP

Oracle Express Suit

Oracle PL/SQL

Oracle 9i DBA & 10g

Oracle Portal

Certifications & Oracle Member

Associations

Recognition & Honor Grade Finally Project at University San Buenaventura

Awards

Most Valuable Employee

Languages Spanish, English and Portuguese

Contact this candidate