Cesar Parra BI Consultant

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.

I was working in Sales tools with my success.

Professional Experience

Project • Project Management Life Cycle

Hyperion • Essabase

• Web Analysis and Report

• Shared Services

• Integration Services

• Design and Implementation Security model in Planning

Oracle 10 & 11 R2

EPB & EPF

• Analyze Dimensions, Hierarchies and Levels for reporting and Business Process creation.

• 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 Business Intelligence Intregation EDW, BIS and DBI

• Oracle Business Intelligence Enterprise Edition Plus.

• Created Hierarchies, Attributes, Financial Data Items, Data Access Controls, Distribution objects, setting up of users.

• 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 and MicroStrategy

• Mapped source data to target database Oracle 8i.

• Prepared document for source to target mapping.

• 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 and Architecture • Oracle 10g Release 2

• Oracle 9i OLAP

• Analytic Workspace Manager 10g

• Discoverer 10g

• Oracle Warehouse Builder (ETL) • Oracle Financial Analyzer

• EPB (Less 6 Month Knowledge)

• Hyperion Essabase

• Hyperion Shared Services

• Hyperion Integration Services

• Hyperion Planning

• Hyperion Financial Managment

Hardware & Operating Systems

• Windows NT

• Windows 2000

• Red Hat Linux (Less 6 Month Knowledge)

Programming Languages • OLAP

• ROLAP

• MOLAP

• PL/ SQL

• SQL*Loader

• HTML

• C++

Engagement Experience

• Applications Development

• Data Conversion

• Unit, Integration, System Testing

• Tuning • End User Training

• Technical Architecture and Configuration

• Project Management

Methods • Data Warehouse Development Life Cycle

• Ralph Kimball DW Methodology

Industry • Banking

• Finance

• Baverage • Insurance

• Communication

Other Accomplishments

Education • San Buenaventura University, Cali, Colombia, South America

URL: http://usb.edu.co

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 & Associations • Oracle Member

Recognition & Awards

* Honor Grade Finally Project at University San Buenaventura

• Most Valuable Employee

Languages • Spanish, English and Portuguese

Contact this candidate