We provide IT Staff Augmentation Services!

Senior Business Intelligence Specialist Resume

2.00/5 (Submit Your Rating)

Mclean, VA

  • Over 7 years of IT Experience and 4+ years of experience in Business Intelligence (OBIEE/Siebel Analytics), and in designing & developing Business Intelligence solutions.
  • Strong experience in providing end-to-end business intelligence solution by configuring metadata and building OBIEE/Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
  • Proficient in developing OBIEE/Siebel Analytics Time Series Objects, InteractiveDashboards
  • with Drill-down capabilities using global and local Filters, OBIEE/Siebel Security setup
  • (users/group, access/query privileges), configuring OBIEE/Analytics Metadata objects (Subject Area, Table, Column), Presentation Services/Web Catalog objects (Dashboards, Pages, Folders, Reports) and Scheduling iBots with Oracle BI Delivers
  • Developed many Reports / Dashboards with different analytics view (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE/Siebel Analytics Web).
  • Configured the NQSCONFIG.INI file for usage tracking using direct insertion.
  • Expertise in debugging and optimizing the OBIEE Dashboards /Reports.
  • Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema
  • to Star Schema, Dim Hierarchies, DimExtensions, Physical & Logical Data Modeling
  • Created Table partitions, Materialized views with query rewriting.
  • Administration of OBIEE and the OBIEE Web Catalog.
  • Performance tuning using Cache management techniques
  • Created, Enhanced and troubleshoot reports on BI Publisher.
  • Experience in RDBMS like DB2, Oracle 9 & 10g, MySQL and SQL Server
  • Extensively Worked on OBI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
  • Very strong analytical and presentation skills and problem-solving techniques with emphasis on individual and team effort backed by excellent communication skills.

Education and Credentials:

  • Oracle Corporation- Certificate OBIEE 11g Reston, VA
  • Matherpoint Inc. Certificate OBIEE Core
  • CISCO Systems Certificate Interconnecting Cisco
Applications and Systems Knowledge

BI Tools: OBIEE 10.1.3.X, Siebel Analytics 7.8/7.7/7.5, BI Publisher 10.1.X
ETL Tools: SSIS, Informatica
Databases: Oracle9i/10g, MS SQL Server 05/00, MS Access.

Operating Systems: Windows 98/2000/NT/XP/Vista, Sun Solaris, Unix, Linux
Web Technologies: HTML, DHTML, XML
Applications: MS Word, MS Excel, Outlook, FrontPage, PowerPoint, Photoshop Application

Project Profiles and Employment History

Confidential, November 2010 – February 2011
Senior Business Intelligence Specialist
McLean, VA

  • Customized reporting with OBIEE Answers and integrated them into the Dashboards.
  • Created Dashboards with Dashboard prompts, Charts, Pivot tables.
  • Worked with administrator in adding new columns to existing tables or adding new tables in order to meet the needs.
  • Involved in Collecting and analyzing technical requirements for upgrading OBIEE 10g enviroment to 11g.
  • Completed the Technical Specifications Document for the upgrade to OBIEE 11g.
  • Worked with administrator in running Upgrade Assistant to upgrade Oracle BI EE RPD and Web Catalog.
  • Involved in post-upgrade tasks and verification of Upgraded Enviroment.

Confidential, June 2006 – June 2010
OBIEE Developer
Falls Church, VA

  • Gathered the business requirements, understanding business objectives and analysis
  • Connected the database and designed the Physical Layer, Business model, Mapping layer and the presentation layer in the repository (.rpd).
  • Created reports and published them in the dashboards using answers.
  • Customized and developed repository, configured metadata objects (Subject area table column) and web catalog Objects (Dashboards, Pages, Folders, Reports.)
  • Added users to the new group and applied the data level security and object level security at the rpd and Web cat.
  • Involved in the analysis of the existing system reports and modification of the reports.
  • Created new reports based on the user requirements.
  • Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics
  • Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
  • Defined iBots / Delivers for various requests if needed.
  • Created reports in BI Publisher using PDF, RTF templates.
  • Created Dimensional Hierarchy from Date, Facility and Location Dimensions, Level based Measures and Aggregate navigation in BMW layer
  • Merged Catalogs folders to master catalog using Catalog Manager.
  • Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
  • Configured Repository and session variables to get dynamic reports and dashboards

Environment: OBIEE 10.1.3.3/10.1.3.4 Oracle 10g/11g, SQL, Windows 2003 Server, Windows, Services, UNIX, Oracle SQL Developer

Confidential, August 2003 – February 2006
Network Technician
Laurel, MD

  • Provided web, application and enterprise managed hosting services for businesses worldwide.
  • Monitored client networks with Spectrum.
  • Created and send trouble tickets to engineers and clients.
  • Troubleshot HTTP and CPU\'s with sitescope.

We'd love your feedback!