Employment History

Confidential

Senior OBIEE Administrator/Architect

• 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 Verizon 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

Senior OBIEE Administrator/Architect Hyperion EPM Administrator/Architect

• 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.

Other Experience

• 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.
• 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

Confidential

BI Specialist/Technical Lead

• 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

Project Manager /Senior Technical Consultant

• 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

Senior Technical Consultant

• 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.

Confidential

Project Manager, Senior Application/Technical Consultant

• Application/technical support for the Geac SmartStream Payables, Purchasing, Supplies Inventory, General
• Ledger, Budget, Allocations, Consolidations, Assets, and Projects modules.
• Project manager for the SmartStream Payables, Purchasing, Supplies Inventory, General Ledger, Consolidations and Budget applications.
• Created SQL scripts for moving, manipulating data to incorporate into applications.
• Troubleshot software issues occurring within software.
• Performed migrations and installations on all of the SmartStream platforms. UNIX, Sybase NT , Microsoft SQL server .