We provide IT Staff Augmentation Services!

Oracle Business Intelligence Architect Resume

SUMMARY:

  • Senior - level business intelligence (BI) architect with expertise in Oracle database design, data modeling, mathematical modeling, statistical analysis, econometrics, business intelligence, reporting, data management, and administration.
  • Extensive experience in working with relational databases, primarily in the Oracle Technology space.
  • Experience also includes designing Extract, Transformation, and Load processes, and consolidating, cleansing, and filtering data.
  • Also designed and built a number of Decision Support and Business Intelligence Systems and supporting data marts.
  • Focused on Oracle Business Intelligence (11g and 10g) for the past 7 years serving as administrator, developer, and as Lead Architect.
  • Also standardized the Confidential approach to OBIEE development, providing guidelines for RPD development as well standards to be enforced in any and all OBIEE development projects.
  • Experience in both SQL and PL/SQL programming, and managed several large database and decision support-related implementations spanning a number of high-profile clients, from industries including: health care, finance, manufacturing, and the Federal Government.
  • During this time, I gained considerable experience in client-facing situations at the senior management level.
  • Subject matter expert in market evolution, particularly as it impacts information technology and IT organizational roles, and has assisted numerous organizations in managing IT changes and adapting themselves to new ways of doing business.
  • I managed and coordinated the work of small and medium size teams.

SKILL:

Software / Products: Oracle Databases from 6.x to 11g, Oracle Developer and Designer, Erwin, Oracle Business Intelligence Enterprise Edition 10g, Oracle Business Intelligence Enterprise Edition 11g, All other Oracle tools, such as SQL*Loader, SQL*Plus, etc., Microsoft Suite of Products

Hardware / Operating Systems: MS-DOS, Windows, Windows XP, Windows Vista, Windows 7, Oracle Linux, Unix, Solaris, Digital Unix, AIX, and others, Linux

General Tools: Microsoft Excel, Word, Power Point, Access, Visio - expert, Microsoft Project - project experience

EXPERIENCE:

Confidential

Oracle Business Intelligence Architect

Responsibilities:

  • Responsible for converting PeopleSoft nVision to OBIEE analysis and BI Publisher
  • Worked extensively with Oracle BI Applications for PeopleSoft
  • Have worked extensively with BI Publisher
  • Responsible for gather user requirements
  • Responsible for building Proof of Concepts
  • Responsible for OBIEE report and data model creation

Confidential

Oracle Business Intelligence Architect

Responsibilities:

  • Responsible for Business Objects reports migration to OBIEE
  • Some reports were completed using Answers and other BI Publisher
  • Edited the CSS style sheets to provide a custom interface for GSA/PBS
  • Used HTML and XML to build out reports and refine report queries
  • Responsible for modifying RPD to meet Business Objects Reports requirements
  • Responsible for Answers reports creation
  • Responsible for Dashboard design and development

Confidential

Oracle Business Intelligence Architect & Tech Lead

Responsibilities:

  • Provided Administrative oversight to OBIEE custom development project in support of DETR intelligence imitative
  • Develop and extend RPD to provide custom solution for DETR
  • Deployed RPD in a Windows Server environment—2003 and 2008
  • Design and develop BI Publisher reports to satisfy batch reporting requirements
  • Design and developed custom answers and dashboard solutions to meet DETR reporting requirements
  • Supported a variety data warehousing and OBIEE development efforts
  • 250 BIRT reports were rewritten in BI Publisher and I was personally responsible for over 70 of them
  • Worked closely with the data architects and even served as data architect in an effort to implement a rational data warehouse architecture
  • Supported the data modeling effort, both logical and physical data models
  • Worked with Oracle Data Integrator
  • Configured the OBIEE Weblogic Server and applied security appropriately
  • Administered the OBIEE 11g environment, RPD Development and security setup
  • Designed the business mapping and model layer for this effort
  • Provided Administrative and Development oversight in providing solutions to meet DETR business intelligence requirements.

Confidential, Tysons Corner, VA

Oracle Business Intelligence Specialist

Responsibilities:

  • Internal projects using OBIEE
  • Installed and configured OBIEE in a Windows 2008 server environment
  • Provided consultancy support for an OBIEE project at Methodist Hospital in Houston, Texas. The role specifically addressed BI Architecture requirements.
  • Installed OBI Applications for PeopleSoft
  • Customized OBI Application per Customer Ps
  • Worked with BI Apps data models to accommodate user requirements
  • Used Informatica to move data from source to target. Basic transformations and data profiling also were part of this effort
  • Designed BI Publisher reports as Proof of Concept to demonstrate the breath of OBIEE

Confidential, Arlington, VA

Oracle Specialist Senior

Responsibilities:

  • Provided direction and leadership in building out an OBIEE solution for the Confidential
  • Installed OBIEE on a Windows 2008 server
  • Used Custom Style Sheets (CSS) to create a unique user interface and experience
  • Performed DBA admin work on Oracle 11 as it pertained to OBIEE implementation¸ including installs, setup, user security, etc
  • Provided Data Modeling expertise to support the Oracle Business Intelligence using Erwin
  • Designed the ETL processes for Oracle Data Integrator 9.1 to populate the Data Marts with source data
  • Provided dashboard design solutions
  • Provided administrative support for the OBIEE repository and OBIEE web-catalog
  • Provided support for ad-hoc query and report development

Confidential

Oracle 11g R2 DBA & Data Architect

Responsibilities:

  • Provided Confidential with Oracle 11g R2 DBA services as well as Oracle Form and Oracle Designer expertise
  • Developed a General Ledger Data Warehouse Model based solely on PeopleSoft documentation (no specifications or requirements)
  • Provided expertise in data architecture and data modeling using Erwin
  • Designed and constructed a Data Mart which was received with compliments from the client

Confidential

Compliance Monitoring Contractor

Responsibilities:

  • Prepared Loss Share program documentation to resolve bank closures for the Confidential, enabling the Confidential to absorb up to 80% of a failed bank’s assets, while the other 20% was absorbed by the acquiring institution
  • Automated the process via Excel macros
  • Installed and configure a SQL server instance
  • Managed the SQL Server environment

Confidential

Hyperion Business Intelligence Specialist & Data Architect

Responsibilities:

  • Built Proof of Concept to showcase Confidential ’s capabilities in Business Intelligence to the Department of Defense
  • Provided Data Modeling expertise to support this environment using Erwin
  • Rolled out the Hyperion Enterprise Performance Management System
  • Stood up the Hyperion Profitability and Cost Management Module

Confidential

Oracle Business Intelligence Architect/Developer & Data Architect

Responsibilities:

  • The DHS was using spreadsheets to report on 6 different geographical areas with over 150 input sources. This consumed the time of 2-3 people for 2-3 weeks each month
  • Created an Oracle Database and imported into it 143 dimension tables and one fact table. This resulted in a real-time solution that shared the same look and feel as the spreadsheets DHS was accustomed to using
  • Worked as DBA on Oracle 10g as relevant for an OBIEE implementation, including install, setup, security, etc…
  • Imported these results in OBIEE and created a repository
  • Built a supporting data model using Erwin
  • Built a dashboard that had the same look and feel as the spreadsheet. This was no easy task and took subsidiary answers reports embedded as links in primary reports. In the end, the dashboard had exactly the same look and feel as the spreadsheet

Confidential

Oracle Business Intelligence Specialist & Data Architect

Responsibilities:

  • Provided expertise in Oracle Business Intelligence requirements analysis with regard to sizing up the environment to support 1,300+ users
  • Performed DBA admin work on Oracle 10g as it pertained to OBIEE implementation¸ including installs, setup, user security, etc
  • Worked with Toad and SQL Plus
  • Built Data Model to support this environment
  • Designed the ETL processes for Oracle Data Integrator 9.1 to populate the Data Marts with source data
  • Built a data model and created software and hardware development plans to support the data warehouse and business intelligence environment

Confidential, Roanoke, VA

Oracle Business Intelligence Specialist & Data Architect

Responsibilities:

  • Secondary responsibility for OBIEE administration including physical and logical data modeling
  • Served as SME with respect to Oracle Database Technology
  • Development of the OBIEE RPD, which included design of the physical mapping layer, business mapping layer, and presentation layer. It also included identifying users and their security levels
  • Built supporting data models with Erwin
  • Developed OBIEE answers report and incorporated these modules into custom dashboard
  • Built Data Model to support the OBIEE effort
  • Developed and delivered end-user materials

Confidential, Louisville, KY

Oracle Business Intelligence Specialist & Data Architect

Responsibilities:

  • Install OBIEE on Solaris.
  • Administered the environment for OBIEE 10g
  • Designed and Developed the RPD.
  • Built supporting data models using Erwin
  • Using a pre-existing data warehouse, built data models and data marts to support the different functional reporting needs
  • Built a custom OBIEE report development and dashboard environment to support analysis of the US Army’s Accession Command recruitment effectiveness by advertiser and by service line
  • Provided administrative support for the OBIEE repository and OBIEE web-catalog
  • Provided support for ad-hoc query and report development
  • Provided Project Lead expertise for other developers and administrators

Confidential, Louisville, KY

Oracle Designer Data Modeler

Responsibilities:

  • Designed and developed logical and physical data models using Oracle Designer and Erwin 7.1 for Oracle, DB2, and SQL Server Databases
  • Gathered end-user requirements for new system development
  • Designed and developed a crew scheduling application model
  • Designed a weather advisory web application model
  • Generated Oracle Forms from Oracle Designer
  • Reverse engineered the Aircraft Addressing and Reporting SQL Server Database system into an Oracle Designer model to provide a data dictionary for the DBAs
  • Maintained and provided periodic update to existing models
  • Designed naming conventions for new data elements in accordance with standards

Confidential, Irvine, CA

Oracle Business Intelligence Specialist

Responsibilities:

  • Designed and developed Oracle Discoverer environments (desktop and administrative)
  • Set up Siebel Analytics Administration Environment
  • Designed and developed Business Objects Universe
  • Generated BI reports with Business Objects.
  • Built an appropriate dimensional data model using Erwin to support the physical layer of Siebel Analytics, and then developed the physical layer in Siebel Analytics
  • Created a business map, including custom measures and hierarchies; renamed columns and entities in accordance with business standards; and mapped to the presentation layer
  • Worked with Siebel Sales Force Automation, customizing per Client p.
  • Worked with team members to implement those customizations
  • Developed the Logical and Physical Data Models to support the DBAs

Business Intelligence & Data Architect

Confidential

Responsibilities:

  • Designed and delivered Siebel Analytics Business Intelligence Implementations
  • Installed, managed, and maintained the Corporate Oracle Application Server
  • Designed and developed Business Objects Universe
  • Generated BI reports with Business Objects
  • Built data models using Erwin as required per customer engagements
  • Designed and developed the Oracle Discoverer environments (desktop and administrative)
  • Designed and developed of a series of Oracle reports
  • Taught Oracle Designer to the client as well as the art of data modeling
  • Trained firm consultants how to use and roll out Siebel Analytical solutions
  • Delivered Oracle Discoverer

Confidential, Green Bay, WI

Data Architect

Responsibilities:

  • Developed operational and transactional data models (logical and physical) using Erwin
  • Generated front-end Oracle forms to test the solvency of the data models
  • Designed and developed the logical and physical data model for shipment tracking

Senior Econometric Forecasting Consultant

Confidential

Responsibilities:

  • Provided consulting and services in the art of econometric model building and forecasting
  • Build econometric models to propose to client as an approach to economic forecasting
  • Developed new software components, such as covariance and correlation matrices algorithms
  • Consulted with clients in best practice forecast methodologies

Functional and Technical Specifications Analyst

Confidential, Milwaukee, WI

Responsibilities:

  • Gathered end-user requirements
  • Set up and implemented an Oracle database to support the ERP system and developed data models based on the functional and user specifications
  • Provided the technical specifications to migrate data from legacy OLTP systems to the Oracle IFS ERP system

Confidential

Web Developer and General IT Support

Responsibilities:

  • Developed various access applications to support the business
  • Built data models to support these applications
  • Developed a website to facilitate book sales over the Internet
  • Managed the corporate database environment

Environment: Windows 2003 Server, Windows XP

Hire Now