Senior Business Intelligence Specialist Resume
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
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
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.