We provide IT Staff Augmentation Services!

Business Intelligence Architect Resume

Houston, TexaS

TECHNICAL SKILLS:

Database - specific Skills: OLAP and OLTP design and implementation, ETL, VLDB, XML, data migration, data validation, clustering, high-availability solutions, backup design and implementation, dynamic stored procedures, ODBC interface, data migration, insert, update, and delete triggers, transaction and locking optimization, hardware specification and acquisition.

Server-specific Skills: DHCP, DNS, DDNS, RAS, RRAS, FTP, WINS, LDAP/Active Directory, hardware RAID, SAN, fiber LAN, UPS, as well as system backup utilities and hardware.

Extensive knowledge: Microsoft Windows operating systems 95, 98, ME, NT 4.0 (Workstation, Server & Enterprise Server), 2000 (Professional, Server, & Advanced Server), 7, XP, and 2003 Server, as well as IBM operating system OS/2 Warp, substantial UNIX (Solaris, HP-UX, and AIX), Linux (Slackware 8.1 & 9.0).

Software and Language repertoire includes: TOAD, SQL*Plus, Access, Visio, ERWin, WinHex, and Exceed, in addition to T/SQL, PL/SQL, Visual Basic, VBA, VB Script, Hummingbird Basic, HTML, VML, as well as Java Script, perl, and C++.

Server specific utilities and applications: VMWare, HP Openview Suite, MOM, MS SQL Server 6.5 - 2005, Sybase 11, IIS 4, 5, 6, Oracle (8-11g), PostgreSQL 7.3.2, IBM DB2 8.1, 9.1, PeopleSoft 8, ADP HR Perspective, Business Objects 5.1, Siebel Analytics 7.5 - 7.8, Oracle Business Intelligence 10g-11g, Siebel 7.8, 8.1, Brio 8, Informatica 5.1 - 8.6.6, Oracle Essbase 11g, Oracle Planning 11g, Business Objects Planning, Omniback, Veritas, Crystal Server, Great Plains, Samba, Apache (including mod perl & mod ssl), and Mason.

BUSINESS KNOWLEDGE:

  • Talent acquisition, employee development, knowledge transfer, and retention.
  • Vendor management, project management, cost/benefit analysis, and consulting.
  • Direct mail and telemarketing lead generation, call routing infrastructure, logic and reporting, and data-mining.
  • Compensation planning, reporting, and payment, GAAP accounting standards, and financial statement generation and analysis.

IMPLEMENTATION EXPERIENCE:

Confidential, Houston, Texas

Business Intelligence Architect

Responsibilities:

  • Responsible for functional and technical strategic direction of OBIA 7.9.6.3 to 7.9.6.4 upgrade, in support of a multi-source PeopleSoft ERP 9.1 to 9.2 upgrade.
  • Acted as functional lead with business executives in the following departments:
  • Research Grants
  • Finance
  • Human Resources
  • Led production troubleshooting and resolution efforts, including:
  • DAC and Informatica nightly ETL failures
  • WebLogic (J2EE) Application Deployment crashes
  • OBIEE Presentation Services crashes
  • Infrastructure memory and processor bottlenecks
  • Responsible for the following project management tasks:
  • Deliverables scoping
  • Project timelines and milestones
  • Resource allocation
  • Infrastructure capacity planning
  • Oversaw and documented installation, patching, and configuration of:
  • OBIEE 11.1.1.7
  • Informatica 9.5.1
  • DAC 11.1.1.6.4
  • WebLogic 10.3.6

Confidential, Memphis, Tennessee

Business Intelligence Architect

Responsibilities:

  • Led the OBIEE 11.1.1.7.1 and OBIA 7.9.6.3 (Human Resources Analytics) customization effort sourced from the following systems:
  • PeopleSoft 9.1
  • PRSIM (legacy mainframe HR system)
  • Designed and oversaw development of Fedex-specific managerial hierarchy to support current, historical, and trend reporting rollups.
  • Designed and developed Fedex-specific HR Organization Dimension to support current, historical, and trend reporting rollups.
  • Designed and developed ETL processes to merge Fedex-specifc HR Organization workforce events into existing OBIA workforce event and workforce event snapshot data without adverse effects on existing headcount reporting and dashboards.
  • Designed and developed ETL processes to support one-time load of historical Fedex-specifc HR Organization workforce events into existing PeopleSoft OBIA workforce event and workforce event snapshot data without adverse effects on existing headcount reporting and dashboards.

Confidential, Grand Rapids, Michigan

Business Intelligence Architect

Responsibilities:

  • Led the OBIEE repository (RPD) 11.1.1.6 creation effort for the following Oracle eBusiness Suite (EBS) modules:
  • Financials (GL, AP, AR, Fixed Assets)
  • Inventory Management
  • Purchasing
  • Project Accounting
  • Led the development effort for reporting delivery (Balance Sheet, Income Statement, Project Spend, Open Purchase Orders, etc.) across a global enterprise with local and global charts of accounts.
  • Created OBIEE project efficiencies to reduce the OBIEE RPD development time by a month.
  • Implemented and managed OBIEE RPD parallel development and merge processes.
  • Provided budgetary, timeline, and resource management for the entire OBIEE-EBS development initiative.
  • Upgraded EBS OBIEE implementation from 11.1.1.6.6 to 11.1.1.7.1 .
  • Documented test cases, migration plans and technical specs for over EBS 40 reports.
  • Defined OBIEE security to mimic EBS security across a global implementation

Confidential, Grand Rapids, Michigan

Business Intelligence Architect

Responsibilities:

  • Oversaw OBIEE repository (RPD) 11.1.1.6 in-place upgrade to support JD Edwards (JDE) 8.1.2 to 9.1 source system and RapidDecision 5.5 to 6.2 data mart upgrade.
  • Ensured the automated, seamless cutover of more than 2000 reports General Ledger, Accounts Payable, Accounts Receivable, Expense Management, and Fixed Assets.
  • Designed indexing strategy to reduce the runtimes of more than 450 high-usage General Ledger transactions reports.
  • Designed materialization and OBIEE aggregate awareness approach to increase performance for more than 70 high-usage General Ledger Balances reports.
  • Provided budgetary, timeline, and resource management for the OBIEE JDE Finance upgrade project.
  • Oversaw upgrade of JDE implementation OBIEE from 11.1.1.6.6 to 11.1.1.7.1
  • Planned, developed test cases for, and oversaw regression testing of over 2000 JDE-specific OBIEE reports.

Confidential, Washington, DC

Business Intelligence Architect

Responsibilities:

  • Directly responsible for the diagnosis, solution, and closure of 21 of the highest priority OBIEE 10.1.3.4.1 end-user issues, facilitating insight into Siebel 8.1.1 Call Center.
  • Troubleshot and optimized Segmentation (for list campaign list generation) for integration with Siebel Marketing 8.1.1 for automation of campaign list load.
  • Led the stabilization effort for the following Oracle Business Intelligence Applications (OBIA) 7.8.5:
  • Service
  • Marketing
  • Call Center
  • Reduced Informatica 8.6.1 and DAC 10.1.3.4.1 nightly ETL load from 15 hours to 4 hours.
  • Led a mixed on-site off-site team of seven resources.
  • Standardized OBIEE RPD development process and coordinated development resources, project managers, Oracle On Demand support staff, and end-users.
  • Provided managerial and technical direction to Oracle On Demand support, as leading a team of off-site OBIEE resources.

Confidential, Billerica, Massachusetts

Business Intelligence Architect

Responsibilities:

  • Identified solutions for client global currency enhancement requests for ETL extensions to the General Ledger mart functionality.
  • Designed and oversaw development of customized Accounts Receivable and General Ledger reporting.
  • Worked with internal IT staff and consulting resources to identify and rank reporting requirements.
  • Responsible for OBIEE project management as well as on-site and off-site OBIEE consulting resources.
  • Conducted knowledge transfer with Confidential resources on performance tuning and indexing strategies.
  • Led effort to configure OBIEE Presentation Catalog as per client enhancement requests.
  • Designed and oversaw implementation of OBIEE-centric solution to simply prompting for balance and net positing measures.

Confidential, New York

Pre-Sales Business Intelligence Architect

Responsibilities:

  • Worked with business users and internal IT staff to identify and rank reporting requirements.
  • Designed and documented multiple solutions for client enhancement requests for Accounts Payable mart functionality.
  • Conducted knowledge transfer with client resources on Work Order mart.
  • Presented OBIEE-centric options to support client requests for cross-mart reporting functionality.

Confidential, Northridge, California

Business Intelligence Architect

Responsibilities:

  • Architected, installed, and configured three Weblogic/OBIEE 11g environments on 64-bit Linux, two of which were clustered.
  • Developed procedures and best practices for OBIEE metadata multi-user development and change control.
  • Integrated OBIEE 11.1.1.5 with Oracle Hyperion Planning 11.1.2.
  • Implemented OBIEE reporting based on Demantra demand forecasts, Hyperion financial plans, and JDE actuals.
  • Leveraged Active Directory (LDAP) security model for OBIEE 11g authentication and authorization.
  • Conformed transactions from Hyperion Planning (Plan) Demantra (Forecast) and JDEdwards (Actual) across product, customer, geography and time hierarchies.

Confidential, Fairfield, Connecticut

Business Intelligence Architect

Responsibilities:

  • Architected strategy to coalesce multiple Confidential Corporate Finance OBIEE instances into a single footprint for director-level executives.
  • Installed and configured OBIEE 11g and Oracle Weblogic 11g.
  • Integrated OBIEE 11.1.1.3 with Oracle Essbase 11.1.2.
  • Designed “stoplight” dashboard combining General Ledger, ETL process, and Essbase multi-dimensional statistics.
  • Integrated OBIEE with conversion of Business Objects Planning application to Oracle Planning.
  • Liaised with internal and offshore resources to coordinate tactical delivery.

Confidential, Rockland, Massachusetts

Business Intelligence Architect

Responsibilities:

  • Liaised with internal resources to ensure system compliance with FDA-mandated regulations for new drug rollout.
  • Documented current state of the Siebel Analytics Business Intelligence Service 7.8.5 Application sourced from a Siebel 7.8.4 ePharma Call Center.
  • Architected short-term technical strategy to meet current project requirements.
  • Conducted a successful upgrade, in the midst of the project cycle, from Siebel Analytics 7.8.5 to OBIEE 10.1.3.4.1 , including DAC 10.1.3.4.1 and Informatica 8.6.1.
  • Defined long-term technical roadmap for a "green field" system re-implementation to support current and future business processes.
  • Conducted training, knowledge transfer, and mentoring sessions with technical resources.
  • Designed custom execution plans, ETL mappings, and data warehouse tables to support training, enrollment, marketing, medical history, and order fulfillment business processes.
  • Designed custom dashboards combining prescription, sales, service request, adverse event, and vendor service level agreement metrics.
  • Responsible for all OBIEE-related project deliverables.

Confidential, Raleigh, North Carolina

Business Intelligence Architect

Responsibilities:

  • Provided guidance on strategy and risk mitigation to director-level executives.
  • Architected a custom OBIEE 10.1.3.4.1 application sourced from Siebel 8.1.1 eClinical.
  • Customized Informatica 8.6.6 mappings and workflows to support client-specific customizations, including an additional source system.
  • Integrated OBIEE and Siebel User Interfaces, as well as the Authentication (SSO), Privilege, Authorization, and Row-Level Security topology.
  • Designed a custom data store based on real-time feeds from Siebel Enterprise Business Components.
  • Conducted knowledge transfer on report and dashboard design and development best practices.
  • Acted as Subject Matter Expert for design and configuration of highly-available and scalable enterprise Test and Production OBIEE 10.1.3.4.1 environments.

Confidential, Dallas, Texas

Business Intelligence Architect

Responsibilities:

  • Provided guidance on approach and timelines to director-level executives.
  • Implemented Oracle Business Intelligence Applications 7.9.6 for Service and Marketing.
  • Customized Informatica 8.6.6 mappings and workflows to support client-specific customizations, including an additional source system.
  • Configured Data Warehouse Administration Console (DAC) 10.1.3.4.1 to support Informatica customizations.
  • Upgraded and merged both a Siebel Analytics 7.0 Repository and Web Catalog with an OBIEE 10.1.3.4.1 Repository and Presentation catalog to support legacy reporting and campaign list generation.
  • Configured Marketing Target Levels, Qualified List Items, Segmentation (for list campaign list generation), and integration with Siebel Marketing 8.1.1 for automation of campaign list load.

Confidential, Salem, Oregon

Business Intelligence Architect

Responsibilities:

  • Interacted with c-level executives to determine project vision and strategy.
  • Implemented RapidDecision (JDE Enterprise One sourced) GL, AR, AP, FA, and Property Management Marts.
  • Designed and built Balance Sheet, Income Statement, and P&L financial statements.
  • Installed and configured 2 OBIEE 10.1.3.4 environments on Windows Server 2003 virtual machines.
  • Designed and built custom Narrative Views, metadata, and database objects to enable prompt display in excel.
  • Integrated OBIEE security (user authentication and authorization) with JDE Enterprise One.

Confidential, Los Angeles, California

Business Intelligence Architect

Responsibilities:

  • Conducted knowledge transfer on OBIEE systems administration best practices for client resources.
  • Load testing and monitoring of OBIEE environment to determine performance bottlenecks.
  • Designed enterprise architecture to support high-availability, scalability, and concurrent development cycles.
  • Installation and configuration of 7 separate OBIEE 10.1.3.4 environments on AIX 6.1.
  • Installation and configuration of 7Oracle Application Server 10.1.3.3 environments on AIX 6.1.
  • Integration between Oracle Single-Sign-On, OBIEE, Oracle Application Server, and BI Publisher.

Confidential, Austin, Texas

Business Intelligence Architect

Responsibilities:

  • Designed and implemented custom ETL to load and telephony reporting elements into Call Center Analytics.
  • Modification of Informatica ETL routines to include extension public sector reporting fields.
  • Development of state and county portal dashboards and reports.
  • Implementation Single-Sign-On via two authentication methods across multiple firewalls and disparate application topologies.
  • Sole OBIEE liaison for end-user requirements gathering and technical resource knowledge transfer.

Confidential, Dayton, Ohio

Business Intelligence Architect

Responsibilities:

  • Repository customization to facilitate Confidential -specific sales pipeline forecasting indicators.
  • Modification of Informatica ETL routines to include extension CRM sales forecasting columns.
  • Development of custom dashboards and reports for enterprise sales pipeline analysis.
  • Implementation of multi-user development and change control processes.

Confidential, Grand Rapids, Michigan

Business Intelligence Architect

Responsibilities:

  • Improved report performance from 5+ minutes to less than 20 seconds using aggregation strategies.
  • Instruction and documentation on governance best practices.
  • Change control instruction and documentation, including Presentation Catalog migration, Repository merge and multi-user development.
  • Tuned custom dashboard and reports filters using repository variables.
  • Customized Impact source-to-target mapping application to support multiple repositories (RapidDecision, OBIEE Applications, and custom-developed).

Confidential, Libertyville, Illinois

Business Intelligence Architect

Responsibilities:

  • Custom report and dashboard development to support decommissioning of in-house custom java reporting application.
  • Custom Repository development to join heterogeneous data sources.
  • Custom data warehouse tuning to conform financial and manufacturing transactions.
  • Configuration and installation of Linux high availability infrastructure.
  • Configuration of load balanced WebLogic application servers.

Confidential

Business Intelligence Architect

Responsibilities:

  • Installation and configuration of Ubuntu OBIEE VMWare image.
  • BI Server and Presentation Services tuning.
  • Instruction and documentation on change control best practices.
  • Re-configured custom dashboard and reports to conform to best practices.
  • Tuned custom OBIEE Repository to enhance performance.

Confidential, Grand Rapids, Michigan

Business Intelligence Architect

Responsibilities:

  • Configured first comprehensive RapidDecision write-time finance data mart for OBIEE.
  • Performance tuned Oracle 10g General Ledger, Accounts Payable, Accounts Receivable, Expense Management, and Fixed Assets data marts.
  • Constructed first-ever link between JDE Confidential payables and receivables.
  • Conducted end-user discovery, requirements gathering, and training sessions.
  • Designed and developed custom operational reporting subject area for JDE chart of accounts.
  • Configured first comprehensive RapidDecision write-time finance data mart for OBIEE.

Confidential, Reston, Virginia

Business Intelligence Architect

Responsibilities:

  • Oversaw and conducted configuration of Oracle Financial Analytics.
  • Designed and developed custom ETL to support Oracle Financial Services Generator (FSG) reports in Oracle Financial Analytics.
  • Conducted Oracle Financial Analytics gap analysis, provided solutions, and level of effort estimates.
  • Developed custom ETL and metadata to display support Oracle Financials Accounts Receivable targets and budgets.
  • Led various end-user requirements sessions and produced requirements documents.
  • Acted in team project management role coordinating on-site, off-site, and client resources.
  • Trained two Confidential resources on Oracle Business Intelligence Applications.

Confidential, Mountain View, California

Business Intelligence Architect

Responsibilities:

  • Developed and conducted ETL proof-of-concept performance testing for out of the box and custom loads into Oracle Financial Analytics.
  • Developed and conducted dashboard proof-of-concept performance testing for out of the box Oracle Financial Analytics.
  • Oversaw installation of Oracle Business Intelligence 10.1.3.3 Platform and Financial Applications 7.9.4 on Solaris.
  • Developed custom Oracle Business Intelligence dashboards to display system performance information.
  • Conducted various end-user demonstrations of Oracle Business Intelligence to various executives.
  • Acted as proxy for Confidential System Resource Engineering team during proof-of-concept.

Confidential, Pittsburgh, Pennsylvania

Business Intelligence Architect

Responsibilities:

  • Designed 4 custom Dashboards and 40 custom reports to support 4 functional business units.
  • Installed and configured Oracle Business Intelligence Platform 10.1.3.2.1 on Linux with Oracle 10g on Linux custom data warehouse.
  • Integrated custom metadata with OID.
  • Integrated Platform with pre-existing Oracle Application Server.
  • Led Confidential effort to implement business intelligence application lifecycle implementation methodology.
  • Designed and built custom hierarchies in OID to enable user maintenance and Oracle Business Intelligence link.

Confidential, St. Louis, Missouri

Business Intelligence Architect

Responsibilities:

  • Installation of Oracle Business Intelligence Platform on Linux RedHat.
  • Configured and installed EBS Fusion Analytics.
  • Troubleshooting Oracle Daily Business Intelligence materialized view creation.
  • Integrated EBS Fusion Analytics with EBS security model.
  • Configured CUPS printing and integrated security BI Publisher.

Confidential, Tallahassee, Florida

Business Intelligence Architect

Responsibilities:

  • Installed Oracle Business Intelligence Platform 10.1.3.2 and EPM Fusion Financial Analytics on Windows Advanced Server 2003 with Oracle 10g on Linux source and target databases.
  • Configured PeopleSoft Human Resources and Financials Fusion Analytics integrated security model.
  • Configured LDAP authentication
  • Developed custom documentation on migration and change control best practices.
  • Compiled Statement of work, including financial models, deliverables, timetables, and resource allocation for second phase of implementation.

Confidential, Charlottesville, Virginia

Business Intelligence Architect

Responsibilities:

  • Migrated email response tracking from hosted reporting solution to internal Siebel 7.8 Marketing-sourced Marketing Analytics application.
  • Installed Oracle Business Intelligence Platform 10.1.3.2.1 and Marketing Analytics Applications 7.9.3 on Windows Advanced Server 2003 with SQL Server 2000 source and target databases.
  • Developed custom interface to mimic legacy reporting application.
  • Conducted gap analysis on extension source fields as well as custom metrics from legacy system.
  • Built fully integrated Confidential -branded Oracle Business Intelligence-Siebel Marketing prototype to achieve user sign-off.
  • Configured Siteminder SSO integration.
  • Led Confidential effort to implement business intelligence application lifecycle implementation methodology.

Hire Now