Lead Architect OBIEE Resume

OBJECTIVE:

To obtain a contracting role that will utilize my in - depth technical and business / functional skills regarding Oracle Business Intelligence Enterprise Edition, ETL, Business Intelligence and Data warehousing.

PROFESSIONAL EXPERIENCE

Confidential

Lead Architect OBIEE

Responsibilities:

Worked often with business stakeholders to help define requirements, estimation, risks and perform gap analysis.
Devised a cacheing strategy that would prevent 60% of all report SQLs from hitting the database.
Extremely hands-on with working with users, design, development, and testing of all areas of OBIEE, from Data Model to Web to Server to Infrastructure.
Lead development on-site and off-shore to manage processes going through the five stages of SDLC.
Designed around on Teradata-database specific constraints and restraints, such as redistribution, skewing, spool space, revolving mega million records of transactions.
Developed robust, yet flexible data model based on business requirements in a way that divided up the data into different tables without duplication based on visibility to achieve peak performance on the reporting platform.
Created an automated regression testing program that would run prior to deploying any RPD code changes for System Testing.

Confidential

Lead Architect OBIEE

Responsibilities:

Performed massive performance parallel data loading onto HDFS.
Created Complex Map - Reduce libraries in Java overcome the inefficiencies of Hadoop Hive s update and delete operations for our multi-billion record data sets.
Developed a java program that converted Oracle packages and Oracle SQLs into Vertica syntax.
Also developed a java program that converted Teradata BTEQ scripts into Vertica syntax.
Converted Oracle Store Procedures into Python scripts such that the functionality would run in Vertica.
Created a C++ Vertica User Defined Library to more efficiently transpose data from a horizontal stored recordset to a more flexible vertical recordset.