• SME Oracle DW/BI Solutions Architect OBIEE SME DBA Design/ Modeler
• Highly accomplished technology architect with an excellent professional track
• record directing all aspects of IT systems, operations, and programs. Proven ability to train,
• evaluate, and lead cross functional teams of technical employees completing enterprise-wide projects
• within plan, schedule, and budget guidelines, using a wide array of project management methodologies and IT strategies. Recognized as a creative and effective strategic planner, decision maker, and technical trouble shooter skilled in process development, improvement, and application support.
• Collection and organization of business requirements for Analysis and decomposition of new
• and existing Oracle RDBMS designs and application systems. Business Requirements, process
• modeling, dataflow diagramming, relational database modeling, design, maintenance and
• administration of database and application technologies. Transformation ,Integration ,design of Data
• Warehouse's. Project Leader and Management experience with both employee and contractor
• teams. Oracle Certified Professional. For the past ten years, he has worked with BI Competency
• Centers, and clients around the country, as a Design/Solution Team Leader, and Oracle Subject
• Matter expert for Oracle Corp. Jeffrey has undertaken and configured numerous environments for
• Siebel, OBIEE, ERP,Hadoop on Unix, Linux, Windows. Excellent communication skills.

Skills Profile

Business Intelligence EPM Database Performance and Design Systems Development Life Cycle SDLC

Project Management Dimensional and Database Modeling Solutions Architect System / Database Design Business Process Outsourcing ETL Proof of Concepts MDM Big Data Hadoop 1.x,2x,NoSQL DB

Application Development Tools:

OBIEE 10.1.3x OBIEE 11G Informatica 9.x8.x,7.x Pre-built Analytics 7.9.6 EBS 11.x ,R12 Hadoop1.x WebLogic 10 Erwin ER Studio ArcSDE Oracle Suite Data Hub Toad 6-10, OEM , SQL Loader Hyperion Briosuit 6-11 PeopleTools Clearcase/Cleartools MS Office Suite 2000x Oracle SOA 10x BPEL Global ID's Siperion IBM QualityStage JBuilder 2008 EPM/BI 11x

Application Packages:

OBIEE 10.1.3x 11.1.1.5 Analytics 7.x-8 Oracle ERP 11i , R12.1.x GL, AP,AR, Siebel 8x CRM, Marketing HR ASCP-Supply Chain OTM/FTI EPM 11x

Database Technology:

Oracle DB 7.3.4-11g EM Console - Grid RAC Implementations Data Guard MSSQL Server 2000-2005 Visual Studio DTS Quest Shareplex Replication EMC Timefinder BCV, ArcSDE OEM 10g Grid ASM Partitioning Spatial Streams Physical Logical Standby DR

Program Languages:

HTML, XML,JAVA, PL/SQL,SQL, Unix Shell Korn,Bourne Programming

Platforms and Storage:

WebLogic 10g 11 Weblogic UNIX Solaris 8-10 HP-UX 10-11 LINUX Suse 8 -11 Red Hat 4 -6 AIX 4-6 Windows NT Server 2003 Network Appliance RAC Implementations

Other:

Current

Confidential

Senior Director -DW Architect/Modeler Oracle/OBIEE SME

Hyperion Planning and EDW redesign and consolidation

Design and deployed a new EDW consolidating 3 datamarts used for EBS and Planning reporting. Oversee all phases of project.Secret Clearance.

Result: In progress of consolidating data warehouses as well as MOLAP cubes from Essbase to comply with Department of Navy's annual Budget submittals to Congress

• Perform assessment and fit gap analysis to ensure requirements can be met.
• Source to target mappings from OeB GL and HRMS, Projects and other systems such as Kronos timekeeping to Hyperion
• DRM as a central point of budget data.
• Essbase integration of historical budgets for warehouse reporting.
• Alignment of hierarchies from Hyperion and EDW for creation of CIM-common informational model.
• Mentor ELT developers and client on best practices
• Presentations to client teams and steering commitees for decisions on project direction
• POC of OBIFS capabilities such as trellis views,prompting
• Exalytics box setup for in caching response times with backend exadata on linux enterprise RH 6
• Build,Model and map of existing DW structures using Erwin.
• Customizations of containers from OeB for modules mentioned to meet functional specifications.
• ODI mappings for Hyperion Planning Suite Knowledge modules

Confidential

DW/ MDM /OBIEE SME /Admin- Solutions Consultant

Enterprise Information Management and Governance Design

Designed and deployed a holistic set of enterprise information management and governance processes and software.

Result: An operational system Oracle 11gR2 which included information definition, inventory, on-boarding, audit, policy-compliance and reporting capabilities using OBIEE 11.1.1.6. The ability now exists to track lineage of data purchased from global securities exchanges, data vendors, or government. Aggregations through synthesis of 'atomic data points' into 'value-added knowledge'. Primary components of the solution included:

• A web-enabled, fully operational metadata repository, configuration management database CMDB and business rules management, and workflow auditing application using PHP to maintain transactional aspects and OBIEE to compare usage from disparate systems utilizing Global ID's data profiling,Hadoop cluster on Red Hat 5.
• Formalized, ITIL-based service design, service transition and service operation framework for managing the lifecycles of the information-based products sold to clients, information lifecycle management of the inputs
• and outputs to those products and how their software application development activities are managed.
• Workflow management, role-based entitlements and task-level audit capabilities for logging customer
• relationship management and employee task-level performance observations to be used as an input to the
• new data stewardship activities and Hadoop process for MapReduce jobs
• Deployment of OBIEE on Windows 2012 Server, Weblogic, PHP/Apache, Hadoop 1.0.3 ,Oracle 11gR2 Database.
• Metadata model semantic layer, conversion of data into facetized taxonomy.
• Setup of Hadoop cluster on Redhat 5, Job Scheduling FIFO, Fair Scheduler, Capacity Scheduler
• Writing Partitions for Better Load Balancing
• Installation of Hive and PIG, Import/Export data from RDBMS to HDFS
• Integration of Businness Folksonomy of 17 systems 4 main to reduce sourcing costs and provide standard messaging.
• OBIEE security implemented using weblogic.
• KPI's ,Dashboard reports developed as per business requirements gathered through JAD
• Installation of Global ID's profiling tool to determine redundancy across systems,
• Create xml message using OBIEE formally BI publisher to feed permissions to companies home grown message bus.

Confidential

OBIEE 10.1.3.x 11.1.1.5/DW Admin, OBIEE SME, Solutions Consultant/Performance Tuner

Provided Roadmap and training for both Accenture and USS employees to better develop code. Tune Oracle 11gR2 databases on AIX, ETL/DAC issues running against EBS R12 all modules , to meet SLA's for release dates. Model review for design issues to minimize IO, and indexes. Interface with multiple project groups throughout the organization. Analyze issues and resolve both OLTP and warehouse side queries on both source transformations and target loading. Environments consist of both 10g and 11G OBIEE and BIP reporting environments. Installation of OTM/ FTI 6.2.4 OOB

• Performance Tune complete Informatica and OBIEE reports using indexing, hints, stored procedures, materialized views.
• Modeling and mapping of existing DW structures using Toad Data Modeler
• Identify issues to upgrade RPD to 11.1.1.5 version via repository redesign aka no more bridge structures, etc
• BI tools10.3.1.4 ,11.1.1.5, architecture, CA Erwin 7x, Toad 10x, Informatica 8x, R12 EBS/7.9.6 OBIA, DAC 10x, Oracle 11gR2
• Configuration of Powercenter/Dac version 8/10.
• Informatica tuning using session log statistics to determine lookup cache, bulk loads verses insert/update routines for both SDE and SIL mappings.
• Both Spatial Google and non spatial data used to create US Maps by block groups.
• Improve direct client reports from hours to minutes through sql rewrites and indexing.
• Worked with Oracle Obiee consultants to guide them through best practices related to OS, and DB.
• Informatica, DAC,OBI Repository backup and restore
• Troubleshoot file system issues related to NFS mounts.

Confidential

OBIEE 11G/DW Architect, Healthcare Sector

Provided assessments and engagement management of EBS data related to costs of discharges and admissions of patients to multiple hospital systems.Scope included, configuration for an OBIEE POC using OBIEE 11g implementing weblogic security layer for access and visability requirements. Participate in writing SDD,FRD,TDD. Dimensionalized entities. Branded Tool to give look and feel of companies CSS style sheets. Governance for hub architecture assessments

• BI tools 11G , architecture, CA Erwin 7x, Toad 10x, Informatica 8x
• Preliminary design for ASCP EBS R12 rollout to over 300 hospitals using ASCP Collections,Cost Management,Pricing,Transporters Customers and distributors.
• Complete configuration and implementation of Oracle OBIEE 11G on Linux and windows environments
• Administer security via weblogic 10x, authorization and authentication documentation and implementation using new security moved out of Oracle EBS into application layer.
• Configuration of local and global caching for HA environments.
• Develop governance and best practices for COE.
• Complete build of all feature functionality exploiting the tools strengths, as well as custom UI for prompts and custom deployment of interface using firebug to facilitate locating backend objects.
• Developed many Reports / Dashboards with different Analytics Views and new features of OBIEE including KPI's for on-time delivery and inventory turns.
• Architect/Development and pre sales activities.
• Complete documentation of BRD, TDD for reporting and architecture.
• Modules used Procure to pay,Order to Cash,Suppliers, and Purchasing

Confidential OBIEE 10.1.3.x 11.1.1.5/DW Architect, OBIEE SME, Solutions Consultant DBA/Modeler/Developer

Provided assessments and engagement management for BICG's client to include scope complexity, configuration for an OBIEE POC, Datawarehouse and Datamart design of Financial Assets and Equities. Implementations include HA Linux, Weblogic, Architecture of server components BIS, PS, and Scheduler. Business logical modeling from disparate data sources across multiple environments, to jump start clients reporting capabilities. Achieved performance gains through OBIEE framework. Work within best practices for both BI and MDM using oracle strategies to consolidate information. Participate in writing SDD,FRD,TDD. Dimensionalized entities into star transformed models based on usage case documentation. Designed ETL for SCD Type II in order to meet batch windows and follow the oracle prepackaged analytics concepts using informatica 7.13. Mentor to staff and managers in order to facilitate a transition. Wear all hats on project. Agile development methodology for Rapid development. Migration procedures to 11.1.1.5 RPD and Catalog upgrade, security implemented in Weblogic Fusion layer.

• Performance Tune complete informatica and OBIEE reports using indexing,hints,stored procedures,materialized views.
• BI tools10.3.1.4 , architecture, CA Erwin 7x, Toad 10x, Informatica 7x
• Complete configuration and implementation of Oracle Datawarehouse Model, sourcing any and all legacy systems for conversion via Dimensional Star schema.
• POC of Portfolio analytics for fixed income and equity positions. Migration platform setup for 11G OBIEE
• Develop best practices for BICOE Team.
• Administer security via ldap, authorization and authentication documentation and implementation using Ldap ADSI.
• Configuration of local and global caching for HA environments.
• Complete build of all feature functionality exploiting the tools strengths, as well as custom UI for prompts and custom deployment of WAR/EAR file using firebug to facilitate locating backend objects.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters .
• Architect role in charge of 2 employees, 2 contractor team.
• Complete documentation of FRD, SDD, TDD for reporting, architecture and Informatica ETL.
• Other Financial Client includes : XL Capital- Stamford-tuning of Peoplesoft/EPM OBIEE DW , PNC Bank Pittsburg, PA, Liberty Mutual Dover, NH

Confidential

OBIEE 10.1.3.x/DW Architect, Configurator, DBA

Provide assessments and engagement management for Oracle Corporation clients consisting of government agencies including scope complexity, configuration for OBIEE projects throughout the Eastern U.S. Object and data level security. Implementations include HA Linux, SUN Solaris, Windows. Architecture of server components BIS, PS, and Scheduler. Business logical modeling from disparate data sources across multiple environments, to jump start clients reporting capabilities. Work within best practices for both BI and MDM using oracle strategies to consolidate information. All types of data sources including Hyperion, XCEL, SQL Server, and Oracle. In addition, Siebel Analytics, Pre-packaged Analytics, Fusion Intelligence Integration of Oracle products to OBIEE, EPM 11.1, security, Report and Dashboard Development. Oracle Middleware setup including other various components. Integration of external data, data mining, road map documentation for future alignment of customers with Oracle's future direction.

• BI tools, architecture, including full ETL using Informatica PowerCenter, DAC integration using EBS 11I, with Oracle 7.9.5 Applications Fusion Addition, pre built analytics with ODI.
• Complete configuration and implementation of Oracle Datawarehouse Model, sourcing any and all legacy systems for conversion.
• As a OBIEE Lead was involved in translating functional requirements into technical requirements
• Multiuser environment setup MUDE , and RPD merging and matching.
• Administer security via ldap, presentation catalog using Catalog Management for online changes.
• Configuration of local and global caching for HA environments.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Siebel Analytics Web.
• BI tools, architecture, functions, and features with strong technical background including relational databases, multi-dimensional databases, OLAP and/or reporting tools and metadata management. Develop answers, and dashboards using production data, and existing sql server datawarehouse using Star schema designs.
• Installation of OBIEE BI Server, HTTP, Presentation services, and SAW Scheduler.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Administer security of presentation catalog using groups.
• Performed data fixes in live production databases.
• Partition building, exchange and data archival routines to facilitate transportable tablespaces scheduled through crontab.
• Excellent Hierarchy development of all Type Dimensions.
• OBIEE application design and prototyping based on client design.
• Work with cross-functional user and technical teams.