We provide IT Staff Augmentation Services!

Senior Obiee Administrator/architect Resume

Temple Terrace, FL

TECHNICAL SKILLS:

Extensive knowledge with: OBIEE (Answers, BI Publisher, Essbase) ver 11.1.1.8, Cognos ver 8, Hyperion (EPM) ver 11, Business Objects, Crystal Reports, SQR Server Analysis (SSAS), SAP BW, Oracle Database, Sybase Database, SQR Server Database, Data Stage ver 8, Informatica (ver 9.1), Cognos Data Manager ver 8, Embarcadero,Toad,UNIX, LINUX, VMware,Windows, PLSQL, SQL, JAVA, Oracle Enterprise Manager, Putty, SSH, Erwin,ODI (Oracle Data Integrator), Xcelsius, OBIEE Administration Tool (ver 11.1.1.8), Oracle DAC, Oracle EBS (Financial (AP,AR,GL), Supply Chain, Procurement, HR)

PROFESSIONAL EXPERIENCE:

Confidential, Temple Terrace, FL

Senior OBIEE Administrator/Architect

Responsibilities:

  • Provided detailed technical specifications for OBIEE implementation used to build project plan.
  • Assigned tasks to team members and tracked progress of tasks and provided updates to overall project plan.
  • Tracked time expenditures of tasks and identified possible issues. Provided assistance/solutions to resolve the issues identified.
  • Installed/configured and tuned OBIEE portal (11.1.1.1.7 ). (LINUX)(Installed within VMware)
  • Applied security patches/fixes to OBIEE servers.
  • Installed/configured BI Publisher.
  • Implemented SSL on OBIEE servers.
  • Manage OBIEE cache (seeded cache via ETL Informatica 9.1)
  • Implemented OBIEE usage tracking.
  • Developed and integrated security design for OBIEE.
  • Integrated Single Sign - on (SSO) and created direct connections to Confidential LDAP within OBIEE (Weblogic 10.3.5.1).
  • Assisted in the Modeled Warehouse design of reporting tables (Using Start Schema design).
  • Developed/configured repository file (RPD) used for creating content within OBIEE.
  • Migrated OBIEE dashboards/web catalogs (including supporting files) between environments during development process.(DEV, UAT, PROD)
  • Modeled database in Star Schema design, Operational data stores, and data marts.
  • Branded OBIEE portal to reflect organizations colors and logos.
  • Trained employees on reporting tools and how to manage OBIEE application.
  • Operated as a Subject Matter Expert for all things within Business Intelligence environment.
  • Contacted to address any functionality concerns within OBIEE and provide solutions for those issues.

Confidential, Fort Knox, KY

Senior OBIEE Administrator/Architect - Hyperion (EPM) Administrator/Architect

Responsibilities:

  • OBIEE Administrator for a high volume/high availability portal used by over 19,000 users.
  • Installed/configured and tuned OBIEE portal. (UNIX/LINUX operating system. Latest installed version 11.1.1.7)(Installed within VMware)
  • Installed BI Publisher (11.1.1.7). Created transactional reports within BI Publisher.
  • Designed/developed data cubes within Essbase (OBIEE) and Cognos (Analysis Studio).
  • Manage OBIEE cache (seeded cache via ETL Informatica 9.1)
  • Installed/configured/modified OBIA (Financial, Supply Chain, Procurement, & HR) modules for Oracle. (DOD is a beta site for OBIEE). Processed delivered ETL (via Informatica, ver. 9.1), modified delivered collectors to reflect modifications, setup/updated RPD file, and modified delivered reports dashboards for DOD modifications.
  • Developed and integrated security design for OBIEE and EPM (Hyperion, EPM Shared Services).
  • Implemented OBIEE and EPM usage tracking.
  • Developed/configured repository file (RPD) used for creating content within OBIEE
  • Created sophisticated reports (Drill-through, graphical) within Hyperion Interactive Reporting (ver 9 & 11)
  • Modeled database in Star Schema design, Operational data stores, and data marts. (Over a 3 terabytes of data in warehouse)
  • Technical Lead for installation and management of the OBIEE environment. (UNIX Clustered Environment) Applied security patches/fixes to servers.
  • Tracked time expenditures of tasks and identified possible issues. Provided assistance/solutions to resolve the issues identified.
  • Technical lead for dashboard creation within OBIEE. Converted business requirements into technical specifications for projects. (Using the AGILE development approach)
  • Created dashboards using the graphical interface (Mapviewer) and published within OBIEE. Dashboards are used within all 50 states. Tracks key metrics displayed graphically that US Army uses during their day to day operations.
  • Designed/Developed reports using OBIEE Answers (drill-through reports), scorecards, and dashboards.
  • Implemented SSL on OBIEE servers (Using SiteMinder and Oracle LDAP).
  • Integrated Single Sign-on (SSO) and direct connections to LDAP within OBIEE and EPM (Hyperion).
  • Branded OBIEE portal to reflect organizations colors and logos.
  • Modeled Warehouse design of reporting tables (Using Start Schema design).
  • Assisted in ETL design for extraction of source information (AIX, UNIX, Oracle DB, SQR Server, Sybase, flat files) to be collected and loaded into warehouse reporting tables. (Informatica 9.1 and Data Stage 8.1)
  • Migrated OBIEE dashboards (including supporting files) between environments during development process.(DEV, UAT, PROD)
  • Developed and managed OBIEE web catalog. Migrated web catalog (and changes) to different environments.
  • 20 years SQL and PL/SQL. (writing scripts, query databases, ETL (Data Stage, Informatica, Data Manager, etc)
  • 19 total years of Business Intelligence and data warehousing experience.
  • 14 years technical experience with Cognos reporting and data cube development.
  • 9 years implementation of financial (ledger), payables, receivables and inventory control modules.
  • Extensive reporting experience within Cognos and OBIEE business intelligence tools. Graphical, drill- through, and the development of multidimensional data cubes.
  • Created reports that displayed information in multiple currencies and languages.
  • Worked in public accounting for 5 years.
  • Conducted training customer's employees using Business Intelligence tools. Created training documents and developed classes that were from one to five days in duration.

Confidential, Jacksonville, FL

BI Specialist/Technical Lead

Responsibilities:

  • Installed, configured and tuned Cognos Business Intelligence software (version 8.01) user -base was over 35,000 world-wide in six different countries. (UNIX based OS)
  • Created technical requirements based off business requirements gathered.
  • Designed warehouse tables used for reporting project.
  • Built multidimensional cubes that were published on BI portal. Developed reports off cubes.
  • Built manufacturing dashboard high-lighting key metrics followed by the operation staff.
  • Created security solution for BI portal.
  • Created batch processing scripts that activated ETL (Informatica) and triggers needed for reporting.

Confidential, Miami, FL

Project Manager /Senior Technical Consultant

Responsibilities:

  • Technical lead on data warehouse project which included implementing BI software and layout of the warehouse.
  • Implemented Cognos PowerPlay, Cognos Impromptu, and Cognos Web Server. (UNIX operating system)
  • Installed and maintained Cognos Upfront, PowerPlay Enterprise server, and Impromptu web reports.
  • Taught training classes for Cognos PowerPlay and Impromptu.
  • Created data cubes, financial and statistical reports using Cognos PowerPlay, Impromptu using Sybase and SQL server databases.
  • Designed/implemented reporting design, data cube refreshing process, and distribution of reports concept.
  • Used ETL tool (Informatica) to populate data warehouse from mainframe, relational databases, text files, and user defined data.

Confidential, Peoria, IL

Senior Technical Consultant

Responsibilities:

  • Created concept on to populate and refresh UNIX Sybase data warehouse.
  • Implemented Cognos PowerPlay and Cognos Impromptu.
  • Created data cubes, financial and statistical reports using Cognos PowerPlay and Impromptu.
  • Designed report development report refreshing process, and distribution of reports concept.

Hire Now