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 empower executives to analyze competition for major line of business.. Developed and design Build To Install data mart to keep track of the Supply Chain process worldwide.• 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.• Market Map project was also migrated to OBIEE (Oracle Business Intelligence Enterprise Edition)

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.• Write Korn shell scripts and PL/SQL to support back up strategies

. 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.• Implemented and designed databases, using Oracle RDBMS and Oracle Transparent Gateway, in particular Gateway to HP3000 Turbo Image. • Oracle DBA, monitoring and tuning of Oracle instances, established back-up strategies.• Data modeling, logical and physical models.• Business Objects general designer (OLAP), developed metadata, universe and objects.• Developed extraction, data mapping and cleansing process.• Launched and led Business Objects End User Group to channel development efforts (JAD sessions)• Responsible for transferring ownership of IT Applications assets to parent company, including AMISYS and data warehouse.