We provide IT Staff Augmentation Services!

Obiee Lead/developer Resume

Foster City, CA

SUMMARY:

  • Over 9 years of experience in Software Development, Business Analysis, Production Support with OBIEE 11g/10g, BI Publisher, ODI 11g, TIBCO Spotfire 7.0, Tableau 9.2
  • Certified Oracle Business Intelligence Foundation Suite 11g Implementation Specialist
  • Certified Oracle Date Integrator 11g Implementation Specialist
  • Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher, Catalog Manager, Delivers and iBots (Agents) within the OBIEE suite
  • Experience in administering permissions, privileges to users based on their groups and responsibilities
  • Implemented the 11g Security architecture using Weblogic Administration console and Oracle Enterprise Manager - Fusion Middleware Control
  • Expertise in creating Business Requirement Documents (BRD) and Functional Design Documents (FDD)
  • Experience handling concurrent RPD development using Merging Repositories and Multi User Development of Repositories (MUDE)
  • Working knowledge of recent BI technologies like Tableau, Qlikview and TIBCO Spotfire.
  • Expert in the creation of dashboards, filters, Spotfire information links, calculated columns, and ability to in corporate document property controls to interact with the appropriate visualizations.
  • Extensively used BI Admin tool for RPD Modeling which includes building star schema as per the business requirements and configuration of Physical, Business Model and Mapping and Presentation layers
  • Worked extensively on various Cache Management techniques to increase the performance of both Real-Time and Non Real-Time reports
  • Expertise in ETL methodology for supporting data extraction, loading and transformation processing using ODI/Informatica Power Center
  • Expertise in debugging and optimizing the Oracle BI/OBIEE Dashboards/Reports and ODI Mappings/Workflows
  • Excellent problem solving, troubleshooting and decision-making skills.
  • Good database experience using Oracle 9i/8i/8.0, SQL, PL/SQL, SQL*Loader, Stored Procedures, DBMS Packages, TOAD & ODBC interfaces to Oracle, Explain Plan, Cursors, Constraints, Partitions, Triggers, Indexes, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities.

TECHNICAL SKILLS:

OLAP Tools: OBIEE 11g/10g, OBIA/BI APPS 7.9.5/7.9.6.3/11 g, BI/XML Publisher, TIBCO Spotfire 7.0, Tableau 9.2, Siebel Analytics 7.8.2

ETL Tools: Oracle Data Integrator 11.1.1.6 (Formerly Sunopsis), Informatica Powercenter

RDBMS: Oracle 11g/10g/9i/8i

Oracle Applications: Oracle E-Business Suite R12/11i ((Order Management, Inventory, Purchase Order, General Ledger, Accounts Receivables, Accounts Payables, Bill of Materials), Oracle Discoverer, Oracle Forms

Web Technologies: XML, HTML

Languages: SQL, PL/SQL, C, C++, Python, Java Script

Data Modeling: MS Visio, Erwin

Operating Systems: Windows XP/00/NT/98/95, Linux, UNIX (Solaris), IBM AIX

Fusion Middleware: Weblogic Administration Console (WLS), Enterprise Manager (EM)

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

OBIEE Lead/Developer

Responsibilities:

  • Worked on HR Analytics using the data from Workday, Field Glass and Peoplesoft systems.
  • Worked closely with the Business to gather the requirements, document and establish the scope of the deliverables, deployment and testing.
  • Created advanced OBIEE views like Trellis Charts, Water fall Charts, Pie Charts with explode wedge formatting etc. Custom view example: Created a 9-Box view in OBIEE using the Trellis chart view.
  • Implemented the ‘Hierarchial Prompts’ using ‘Selection Steps’ instead of using all the levels as prompts for the Hierarchies.
  • Created complex Reports by combining multiple views which can be toggled by a ‘View Selector’ which can be viewed by different set of columns using the ‘Column Selectors’.
  • Created many views with dynamic rolling Year/Quarter/Month reports where a user can select the time period and the # of rolling periods.
  • Implemented both the the object level and data level securities to restrict confidential information from the dashboards.
  • Created an innovative dashboard by name ‘Market Pricing Tool’ using the salary information from Salary.com and Glassdoor.com which helps the managers make competitive and market standard salary offers to new positions.
  • Served as a liason between the Business and the multiple development teams like ETL/DW/Workday/OBIEE to triage the defects and maintain proper SLAs as per the defect severities.
  • Served as a subject matter expert (SME) for Financial Analytics OBIEE and the pre-packaged BI Analytic Applications with hands on expertise in RPD Development, Reports/Dashboards development.
  • Developed Reports/Dashboards with different analytics views like Pivot table, Graph, Column Selector, and View Selector, Action links by using drill down, master detail linking, slider navigation, global and local filters and prompts.
  • Designed and developed the OBIEE/Metadata Repository (RPD) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer
  • Developed multiple Dimensions with Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer
  • Configured iBots (Agents) to deliver analytics content based on schedule to obtain weekly reports sent to the Business users on time.

Environment: OBIEE/ODI 11.1.1.9.1, Workday HR, Field Glass, Informatica Power Center 10.0, SQL Developer, PL/SQL, Windows XP/2007 server, Weblogic Server (WLS), Enterprise Manager

Confidential, Overland Park, KS

OBIEE/Hyperion Architect/Lead

Responsibilities:

  • Served as the SME to help the development teams to overcome any technical difficulties pertaining to OBIEE.
  • Worked extensively on OBIEE Dashboards to create the reports as per the client requirements.
  • Developed and supported the creation of new Adhoc Answers requests and Dashboards in OBIEE
  • Implemented Level-based, Parent-child Hierarchies in the Logical layer.
  • Extensively used OBIEE 11g’s new features like Action Links to facilitate drill-downs from aggregate reports to detailed reports.
  • Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and the presentation layers of the repository
  • Conducted user training workshops and trained the users to effectively utilize OBIEE’s reporting features.
  • Developed project plans, tasks, time-lines. Worked with business users to developed and formalize functional design for multiple OBIEE enhancements.
  • Developed application design and technical design documents for the technical team.
  • Developed numerous Business Rules (Calc Manager and Calc scripts) for driver and rate based calculations.
  • Developed and designed an ASO reporting cube to store Budget, Actual and Forecast Data for reporting needs.
  • Assisted client with upgrading from Hyperion 11.1.2.2 to Hyperion 11.1.2.4.
  • Worked with Oracle on Hyperion hot fixes and multiple issues.
  • Maintained Hyperion Financial Management system and assisted in administration consolidation of monthly financial information.
  • Interacted with the business users directly for the requirements, to understand the current system process, created business requirement documents and prepared the effort estimates.
  • Implemented the new 11g Security architecture using Weblogic Administration console and Oracle Enterprise Manager - Fusion Middleware Control
  • Conducted Architecture analysis of requirements and Design Walk-throughs with the developers and the management staff
  • Involved in RPD Modeling which includes building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in the BMM layer.
  • Involved in extensive QA testing and data validation support.
  • As a support lead, always maintained a 100% SLA in supporting OBIEE and Hyperion issues and bugs.

Environment: OBIEE 11.1.1.7, BI Publisher, ODI 11.1.1.6, Hyperion 11.1.2.4, SQL Developer, PL/SQL, Windows XP / 2007 server, Weblogic Server (WLS), Enterprise Manager

Confidential, Mountain View, CA

Sr. OBIEE/Spotfire Lead/Developer

Responsibilities:

  • Understand and provide solutions to the requirements that business requests for Spotfire and OBIEE Dashboards creation.
  • Designed and implemented high quality reports using Spotfire and reporting processes to meet defined user needs and work with the business to ensure that the reports are appropriately interpreted.
  • Work with the Spotfire CoE to support the Spotfire and by seeking best practice and sharing it within and across the team.
  • Expert in the creation of dashboards, filters, Spotfire information links, calculated columns, and Ability to in corporate document property controls to interact with the appropriate visualizations or calculated fields.
  • Performed complete RPD Modeling which includes building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer.
  • Developed and supported the creation of new Adhoc Answers requests and Dashboards in OBIEE
  • Configured iBots (Agents) to deliver analytics content as *.xls and *.csv to multiple FTP locations using the ‘Invoke a Java Method’ functionality.
  • Merging Repositories by using Multi User Development of Repositories (MUDE)
  • Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
  • Worked extensively on various Cache Management techniques to increase the performance of both Real-Time and Non Real-Time reports
  • Performed Knowledge Transfer to HCL support team which includes Developers, DBA and Business Analysts after successful completion of the project.

Environment: OBIEE/ODI 11.1.1.7.1, TIBCO Spotfire 7.0, Oracle 11g (11.2.0.3), SQL Developer, PL/SQL, Windows XP/2007 server, Weblogic Server (WLS), Enterprise Manager

Confidential, Long Beach, CA

Sr. OBIEE/OBIA Lead/Developer

Responsibilities:

  • Involved in Analysis, Requirements gathering, functional/technical specifications, development, deployment and testing.
  • Served as a subject matter expert (SME) for OBIEE and the pre-packaged BI Analytic Applications with hands on expertise in RPD Development, Oracle Answers, Oracle Delivers and BI publisher.
  • Designed and developed interactive navigational drill down reports in OBIEE Answers, requests and Intelligence Dashboards using various reporting features such as formulas, filters, charts, pivot tables.
  • Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
  • Developed Reports/Dashboards with different analytics views like Pivot table, Graph, Column Selector, and View Selector, Action links by using drill down, master detail linking, slider navigation, global and local filters and prompts.
  • Worked on HR Analytics in a PeopleSoft environment.
  • Designed and developed the OBIEE/Metadata Repository (RPD) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer
  • Developed multiple Dimensions with Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer
  • Configured more than 90 measures in the Business Model Layer that are not critical to performance and mapped them to multiple logical source tables (multiple LTS).
  • Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures and other functions like ToDate and Period Rolling.
  • Created Fragmentation content for few fact tables having 6-8 years of historical data
  • Implemented Security by creating roles, responsibilities, and web catalog groups using LDAP Authentication
  • Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
  • Actively participated in meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIA/OBIEE/ODI 11.1.1.7.1, BI Publisher 11g, Oracle 11g (11.2.0.3), SQL Developer, PL/SQL, Windows XP / 2007 server, Weblogic Server (WLS), Enterprise Manager

Confidential, Redwood Shores, CA

Sr. OBIEE/OBIA Developer

Responsibilities:

  • Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and the presentation layers of the repository
  • Worked extensively on OBIEE Dashboards to create the reports as per the client requirements.
  • Worked closely with the Business Planning team in understanding the Analytics Requirements and created Business Requirement Documents (BRDs)
  • Designed the project flow and created Functional Design Documents (FDD)
  • Performed data modeling tasks to identify and create facts and dimension tables.
  • Implemented the Star Schema, Snowflake Schema models as per the project requirements.
  • Developed and supported the creation of new Adhoc Analytics requests and Dashboards in OBIEE
  • Implemented Level-based, Parent-child Hierarchies in the Logical layer.
  • Conducted Architecture analysis of requirements and Design Walk-throughs with the designers, developers and management staff
  • Extensively used OBIEE 11g’s new features like Action Links to facilitate drill-downs from aggregate reports to detailed reports.
  • Implemented the new 11g Security architecture using Weblogic Administration console and Oracle Enterprise Manager - Fusion Middleware Control
  • Enforced criteria based navigation to achieve better SLA on Ad hoc queries based on customer origination and industries.
  • Utilized Catalog Manager to deploy the catalogs, dashboard objects from Dev to Stage and then later on to Prod environments
  • Configured Agents to deliver analytics content based on schedule to obtain weekly reports sent to the Business users on time
  • Involved in extensive QA testing and data validation support.
  • Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using LDAP Authentication to setup groups, access and query privileges

Environment: OBIEE 11.1.1.7, BI Publisher, ODI 11.1.1.6, SQL Developer, PL/SQL, Windows XP / 2007 server, Weblogic Server (WLS), Enterprise Manager

Confidential, Kansas City, MO

Sr . OBIEE/ODI Developer

Responsibilities:

  • Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
  • Produced UML Diagrams, Business Requirements, Report Specifications, Workflows and other documentations as required for Project Analysis, Planning and Design
  • Coordinated the installion of 11g version on 64 bit windows, upgraded 10g RPD, Webcat and Weblogic Server 11g.
  • Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
  • Worked Closely with ODI developers in creating new metrics for the Reports.
  • Also participated in analyzing ETL mappings using ODI 11g
  • Implemented the logic of Change Data Capture (CDC) for incremental changes using Oracle Data Integrator (ODI).
  • Involved in creating Style sheets for the Report Catalog
  • Worked Extensively on RPD in creating the presentation variables and repository variables
  • Worked Extensively in the RPD level security and Repository Level security
  • Configured BI Publisher and Integrated with OBIEE server
  • Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and the presentation layer of the repository.
  • Created different types of Customized Reports (Drill down, and Aggregation) to meet client requirements.
  • Integrated BI Server and BI Publisher, with LDAP security model, folder access management within BI Publisher for those LDAP roles and groups
  • Scheduled the reports to run dynamically using BI publisher.
  • Involved in developing the testing documents like Estimates, Test Strategy, Test Plan, Use cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications.
  • Documented all the information about the performance tuning employed, such as Identifying long running sessions, Performance Bottlenecks for those sessions, Actions taken etc.

Environment: OBIEE 11.1.1.6, BI Publisher, ODI 11.1.1.6, Windows XP / 2003 server

Confidential, Baltimore, MD

Sr . O BIEE/OBIA D e v e lo p e r

Responsibilities:

  • Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing.
  • Created prototype of the project and received sign off on POC from business users
  • Conducted Architecture analysis of requirements and Design Walk-throughs with the designers, developers and management staff
  • Designed and developed the OBIEE/Metadata Repository (RPD) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer
  • Worked on HR Analytics in a PeopleSoft environment.
  • Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures. Also created Fragmentation content for few fact tables having 6-8 years of historical data
  • Created pixel perfect reporting for strategic business teams using BI Publisher
  • Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
  • Implemented Security by creating roles, responsibilities, and web catalog groups using LDAP Authentication
  • Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
  • Customized requests and modified the OBIEE Dashboard using cascading style sheets
  • Performed Unit, Integration, and Regression testing to validate report and mapping functionality
  • Designed ETL mappings for bringing in data from various data sources such as Lotus Notes, SAP FICO, SAP HCM, Sales Logix and Project Management databases
  • Used ODI Export-Import tools to deploy scenarios from Dev to TEST, UAT & Prod environment.
  • Develop packages for the ODI objects and scheduled them as scenarios.
  • Actively participated in weekly Project status meetings and communicated effectively with Project Managers
  • Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.

Environment: OBIEE 11g, Siebel CRM 8.1, BI Publisher, ODI 11.1.1.3, Windows XP / 2003 server

Confidential, New York, NY

OBIEE/ODI Developer

Responsibilities:

  • Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing.
  • Prepared, Integrated and Configured Siebel CRM 8.1 with BI publisher 10.1.3.4.1.
  • Configured outbound web services for BI Publisher server and created report responsibilities in Siebel Application.
  • Configured Security and Authentication with Siebel security model and LDAP security model.
  • Embedded BI Publisher scheduled reports view in Siebel and Configured BIP Data Service WSDL for BI Publisher server.
  • Manages the BIP servers perform Administration, Migration and Update responsibilities.
  • Experience with ODI integration between OBIEE and Hyperion Planning.
  • Experience with customizing ODI knowledge modules
  • Prepared and uploaded new / modified / preconfigured report layout templates to the BI Publisher server and multiple Siebel server environments.
  • Involved in administering automatic purging of reports in the Siebel file system and purging of schedule reports from the BI Publisher server.
  • Created custom reports, created new Integration objects and involved in the process of registering and scheduling of reports in BIP and Siebel servers.
  • Involved in packaging and Migrating of reports from Source to Target environments using Application Deployment Manager.
  • Configured BI Publisher and Integrated with OBIEE server
  • Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and the presentation layer of the repository.
  • Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
  • Involved in developing the testing documents like Estimates, Test Strategy, Test Plan, Use cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications. Experience in preparing the Test Execution Report.
  • Utilized Oracle provided migration utility to migrate Discoverer EUL (metadata) over to OBIEE RPD
  • Participated in migrating Oracle Discoverer End-User-Layer (EUL) over to OBIEE platform

Environment: Siebel CRM 8.1, BI Publisher, Windows XP / 2003 server, Oracle RDBMS 10g, Oracle Business Intelligence Enterprise Edition 10.1.3.3

Confidential, New Jersey

Oracle PL/SQL Developer

Responsibilities:

  • Custom tables and new custom objects were designed as per business requirements.
  • Created Database Triggers to maintain, validate Data Integrity.
  • PL/SQL Procedures, functions, cursors, triggers and packages were created using TOAD.
  • Developed and maintained Oracle Forms and Reports for various applications using SQL*Plus and PL/SQL.
  • Developed PL/SQL procedures to support Forms and perform standalone functions
  • Developed complex SQL Queries and used in creating Reports and Forms.
  • Performed unit testing and Integration testing for the scenarios mentioned in the test scripts.
  • Writing cursors according to specifications.
  • Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.
  • Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and loaded the data into warehouse Schemas.
  • Worked on improving the Performance of SQL queries by extensive use of Explain plan and various hints and indexes.
  • Combined data from heterogeneous data sources such as flat files and Oracle database tables. Used UNIX Shell (Korn) Scripts and Scheduled cron jobs to automate the process of Extraction, Transformation and Loading the data into the Data Warehouse.
  • Responsible to load various table data, flat file data to populate and processed on a daily basis from legacy to the online production environment using SQL*LOADER.

Environment: Oracle 8i, Solaris, TOAD, SQL Developer, SQL*Loader, PL/SQL, SQL*Plus.

Hire Now