We provide IT Staff Augmentation Services!

Sr. Obiee Consultant Resume

San Francisco, CA

PROFESSIONAL SUMMARY:

  • Certified BI professional with over 7 years of experience in Analysis, RPD development, implementation and maintenance of Business Intelligence Solutions using Oracle Business Intelligence Enterprise Edition (OBIEE) 11G/12C. 3 years’ experience in Tableau.
  • Experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE).
  • Expert in working with OBIEE administration tool, developing metadata repository and strong experience in working with OBIEE Answers & OBIEE Dashboards.
  • Experienced in gathering reporting requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping and Presentation layer.
  • Experienced in designing and developing Data Modeling and Analysis using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool
  • Expertise in designing and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
  • Used actions, local and global filters according to the business/client requirement.
  • Extensive experience in Tableau Administration Tool for Configuration, adding users, data connections, scheduling tasks.
  • Experience includes technical support, troubleshooting, report design and monitoring of system usage. In-depth knowledge on Tableau Desktop and Tableau Server.
  • Experience in creating Sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Expert in working with OBIEE administration tool, developing metadata repository and strong experience in working with OBIEE Answers & OBIEE Dashboards
  • Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database designs Methodologies.
  • Expert in building repositories using star schema , developing Subject Areas and applying security (group, access / query privileges) at object and data level in Administration Tool.
  • Experienced in translating business requirements into a business dimensional model , key subject areas , dimensions , hierarchies , attributes and measures .
  • Expert ability to troubleshoot and prioritize issues.
  • Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS:

BI Development Tools: OBIEE 11g/12c, Tableau 8.1

Databases: Oracle 12c/11g/10g/9i/8i RAC, SQL Server

Programming Languages: SQL, PL/SQL, XML, UNIX Shell Scripting

ETL: Informatica Power Center 9.1

Operating Systems: Microsoft Windows 7/Vista/XP/2000/NT/2012, RHEL

Tools: and Utilities TOAD, SQL Developer, Microsoft Visio

Functional Areas: OBIEE 10g/11g/ 12.2.1.0/12.2.1.2, BI Publisher 10g/11g/12c

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. OBIEE Consultant

Responsibilities:

  • Prepared detailed design documentation and program specifications from which systems are developed and coded
  • Designing RPD with Physical Layer, Business Model and Mapping Layer and Presentation Layers
  • Worked on hierarchies, level-based measures, aggregation navigation and time series calculations in the repository (RPD)
  • Setting up Session Variables and Repository Variables using various Initialization Blocks
  • Configuration of log level and usage tracking
  • Build Dashboard using Answers including drilldown objects, union-based Dashboard, formatting and functions within the Dashboard
  • Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users
  • Managing the OBIEE Admin Tool, Catalog Manager
  • Implemented Oracle BI security setup (users, groups, and data access/query privileges), metadata objects, dashboards, pages, folders, reports
  • Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Oracle, Xml, csv, Delimited files transformed based on business requirements and loaded to Data Warehouse
  • Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters
  • Coordinated with multiple teams in Onsite-Offshore model during implementation and transition phases
  • Develop and execute plans for deploying the applications into production environment
  • Preparation of test scripts, validating and supporting dry run, SIT & UAT sessions

Environment: OBIEE 11g, Informatica, SQL, PL/SQL, UNIX Shell Scripting, TOAD, Oracle AIM, HP QCand Windows 2003 Server

Confidential, Salt Lake City, Utah

BI Consultant

Responsibilities:

  • Understand requirements from business analysts and build reports and dashboards.
  • Identify where the business logic should be implemented.
  • Build RPD metadata for all 3 layers Physical/BMM/Presentation layers.
  • Implement different dimensional models Star schemas & Snowflake schemas.
  • Build summary and detail reports and make sure BI numbers match with source data.
  • Implement data level security and testing.
  • Setup cache management in various environments.
  • Create report templates and place it on a dashboard as links.
  • Add users to various app roles to provide object level security on dashboards and reports.
  • Involved in creating dashboards and reports in Tableau 8.1.
  • Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
  • Setup Tableau Schedules and assign dashboards to schedules based on users/group security.

Environment: OBIEE 12.2.1.0, Tabwareleau 8.1, Windows 2012 R2 and Oracle 12.1.0.2

Confidential, Houston TX

Tableau Consultant

Responsibilities:

  • Understand analytics requirements from users and build design specifications.
  • Create worksheets and dashboards.
  • Develop rich data visualizations on Tableau using crosstabs, heat maps, pie charts & bar charts etc.
  • Designed multiple dashboards for operational and executive users.
  • Postproduction support to Tableau users and wrote custom sql to support business requirements.
  • Strong dashboard design experience.
  • Provide regular status of the project to the management.
  • Build advanced analytics by building complex reports and dashboards.
  • Prepare test scenarios, test cases and execution of test cases.

Environment: Tableau 7/8.1, Windows Server 2008 & Oracle 11g/12c, MS Access database, SQL Server and MS Excel.

Confidential, Fort Worth, TX

OBIEE Developer

Responsibilities:

  • Analysis, design and develop reports in Answers and develop dashboards.
  • Work with ETL team to bring in the required tables into the data warehouse.
  • Provide drill down functionality with detail reports.
  • Work on enhancements of multiple subject areas in RPD.
  • Maintain object level security by adding/removing users from application roles through Enterprise Manager.
  • Build dashboards that query multiple subject areas and multiple databases.
  • Create ibots and schedule to deliver to users.
  • Performance tuning in OBIEE configuration files like nqsconfig.ini & instanceconfig.ini. Work with DBAs to improve the performance at database level
  • Application administration start/stop BI component services.
  • Work with oracle on OBIEE product defects and arrive at proper resolution.
  • Implement data level and object level security in RPD, Enterprise Manager and catalog level
  • Generate reports from catalog manager
  • Review RPD changes/reports developed by team
  • Develop a common landing page for all the users and provide links to navigate to various dashboards as per user’s access

Environment: OBIEE 11.1.1.7/12.2.1.0, RHEL 6, Oracle 12c/11g, SQL, PLSQL, Toad 10.x, SQL Developer 4.x

Confidential, Mountain View, CA

Business Intelligence Developer

Responsibilities:

  • Analyze user requirements and translated them into front end Tableau visualizations and reporting solutions.
  • Involved in interaction with business users in the process of discussing the overall Reporting requirements.
  • Designed and developed operational dashboards with parameters, calculated fields, groups and hierarchies.
  • Developed workbooks (with over 12 worksheets) with various functionalities and deployed them on server.
  • Used functionalities like groups, sets, Actions (hyperlinks), context filters wherever required.
  • Managed and maintained Tableau Server, Desktop, users and user groups.
  • Responsible for Tableau Infrastructure including Server Security, Troubleshooting and overall system maintenance.
  • Scheduling and maintaining the workbooks to synchronize dynamically with run time data.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau

Environment: Tableau 5.0, Oracle 10.2 & Windows

Confidential, Manassas, VA

Software Developer

Responsibilities:

  • Involved in the Requirement Study phase of the NHIF system.
  • Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
  • Built new subject areas as per the data sources and requirements using Presentation/BMM/Physical layers of RPD.
  • Built various measures as per the requests using RPD.
  • Built various reports/dashboards as per the requirement.
  • Follow best practices in designing reports, dashboard and while building metadata in RPD.
  • Create dashboard scope prompt and have one prompt work for all the pages on the dashboard.
  • Add/remove users from web catalog groups and data level security.
  • Create ibots and setup email deliveries to users as per the specified schedule.

Environment: Siebel Analytics 7.8.2, OBIEE 10.1.3.2, SQL Developer & Oracle 9i/10g

Hire Now