Fernando Cabrera Email & Phone Number

• . Developed and designed customer segmentation and satisfaction dashboards to analyze and monitor customer activity based on revenue, profit, response time and surveys.. Developed and designed market map data mart to.
• Technical Lead and data modeler of dashboard and data warehouse projects.
• Data modeling using Erwin and E/R Studio.
• Designer and developer of the Business Objects Universe for general reporting and dashboard applications. Dashboard was developed using Business Objects Application Foundation versions 6.5 and XI
• Developed extraction and transformation of data from various sources using Ascential DataStage. Sources of data were Oracle Applications, Sales Force and Vantive.
• Databases used include Oracle 9i/10g and MS SQL Server.

I have been the CEO and Principal Consultant of this practice which specializes in Business Intelligence projects since its inception in 2002. Satisfy customers include Hewlett Packard, Fleetwood Enterprises, The Doctors Company and Beckman Coulter.

• Developed dashboard and data mart to analyze cost variances in manufacturing recreational vehicles and mobile homes.
• Data modeler of dashboard, including ODS and data mart.
• Implemented infrastructure that include Oracle 9i OEM, Oracle Warehouse Builder, Business Objects Web Intelligence and Business Objects Application Foundation.
• Developed extraction and transformation of data using Oracle Warehouse Builder, sources included JD Edwards application. Model used was star schema in both relational and OLAP versions.
• Databases used include Oracle 9i, Oracle OLAP and MS SQL Server

• Implemented Business Objects worldwide infrastructure.
• Architect for worldwide deployment of Business Objects for HP Services organization.
• Business Objects designer of the High Level Metrics project. ETL used: Informatica PowerCenter and MS DTS. Data sources: Oracle, MS SQL Server, MS OLAP and Informix.
• Business Objects universe designer and developer for multiple other projects.
• Mentor for other Business Objects designers within the HP Services organization.
• Technical support for worldwide Business Objects infrastructure.

• Provided technical expertise to deploy remote administration of Oracle and SQL Server databases for FusionStorm customers.
• Implementation team member of a system to remotely manage Oracle DBMS and MS SQL Server for at least 20 different locations.
• Technologies that were used included: HP OpenView, Oracle DBMS, MS SQL Server, NT and Solaris
• Over 100 hundred Oracle metrics were implemented according to the degree of severity.
• Metrics in general areas included: Archive, Rollback Segments, Space Management, MTS, Performance, Parallel Query Option, Errors and Limits.
• Management and support was a 24 x 7 operation, some instances were set up in stand by configurations.

• . Worldwide data warehouse project to track customer support order costs.
• Designed and set up data warehouse architecture, including Oracle Database instance, extraction, transformation and loading tool Informatica PowerMart and metadata layer with Business Objects.
• Gather of data from seven different worldwide systems, from different RDBMS including Red Brick, MS SQL Server, Oracle and MPE Turbo Image.
• Conversion of Oracle PL/SQL code containing business rules to Informatica PowerMart

• Standardized operational procedures to managed data warehouse.
• Launched marketing campaign to sell data warehouse to similar healthcare companies.
• Conducted software demonstrations to data warehouse potential customers.
• Created, developed, led, designed and managed enterprise data warehouse project, for all lines of business including HMO and PPO. Project budget up to 1 million dollars and a staff of 15
• Managed data warehouse project, organized and built a team of business analysts.
• Architect for data warehouse, including network design, and system integration with internal and external data sources. Erwin was used for data modeling.