We provide IT Staff Augmentation Services!

Obiee Developer Resume

Colorado Springs, CO

SUMMARY:

  • 8 years’ of software experience in OBIEE and Data Warehousing. Dealt with analyzing business requirements, functional studies, design, development, implementation, quality reviews, data modeling, customization, testing and maintenance of databases, business applications.
  • Extensive experience as an OBIEE developer, team lead, system admin. Dealt with repository development, creation of reports, dashboards, KPI’s, delivers and configuring security.
  • Expertise in the full - cycle software development (SDLC) including requirements gathering, Analysis, design, proof of concept, development, testing, implementation, documentation, maintenance and production support.
  • Good Knowledge on Installation and configuration of Financials Analytics, HR Analytics, Procurement and Spend Analytics, Supply Chain Analytics.
  • Proficiency in OBIEE, creation of schemas (star schema modeling, snowflake schema modeling), cross-reporting, various performance tuning techniques such as horizontal and vertical federation, content level settings.
  • Implemented data-level security and object level security in OBIEE using External Table Authentication, LDAP in-order to ensure that all users are provided with right data.
  • Well experienced in the OBIEE repository and application support which constitutes modifying the existing settings, tables, repository model, reports, dashboards, customization of business applications etc.
  • Expertise in managing security settings in OBIEE in-order to ensure that users are assigned with right permissions and can access only the relevant data.
  • Implemented Multi User Development (MUD) which almost reduced half of the efforts and time.
  • Implemented interesting features of OBIEE 11G like geospatial feature, KPI's etc. and also worked on event-polling in-order to purge cache as soon as the respective table is updated.
  • Implemented Clustering Environment in OBIEE in-order to balance load and improve application performance and avoid any services failure.
  • Good knowledge in BI Apps 11g with ODI, configuration of BI Application configuration manager (BIACM) and Oracle Functional set up manager (FSM).
  • Strong knowledge in Web focus, code development, creation of reports in different formats, styling the reports, rendering the reports to the end users using Web focus portal and other features such as drill down, customization of charts etc.
  • Good knowledge in PL/SQL, managed scripts and code for creating, populating, updating and truncating tables which are stored in database such as Oracle, Teradata, SQL Server etc.
  • Worked on managing UNIX scripts which include modifying and updating the code as per the changing business requirements.
  • Good knowledge in creation of reports with BI Publisher using several templates and render them to the end users as per their requirements.
  • Proficient knowledge on database systems like Oracle , SQL Server , Teradata , MS Access . Worked with Teradata admin team to get the necessary views created in order to meet the business requirements.
  • Good experience in SQL Performance Tuning techniques in order to reduce the query time.
  • Good experience in backup and disaster recovery procedures i.e. Business Continuity Planning ( BCP ) in regard to OBIEE business applications, servers, repository, catalog, configuration files, log files etc.
  • Worked with Informatica and have good experience with Repository manager, Mapping Designer, Workflow Monitor, Workflow Manager.
  • Well experienced in creating Informatica Mappings, Mapplets and tasks using several Transformations for unifying data from Multiple Sources.
  • Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly learn new technologies.
  • Well experienced in conflict management techniques and motivational approaches such as cross-cultural issues, political issues, work-life balance methods etc.
  • Have strong interpersonal and excellent communication skills. Possesses ability and have strong willingness to work in different work environments (individual, teams, collaboration etc.) and handle varied work requirements.

TECHNICAL SKILLS:

Data Warehousing: Informatica 8.x, 9.01, SSIS, Oracle Data Integrator (ODI)Reporting Tools OBIEE 11g/10g, Web Focus, BI Apps, BI Publisher, Brio

ERP: Oracle EBS, PeopleSoft, JD (General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets Purchasing, Inventory, Order Management, HR, Project Costing)

Testing/Query Tools: qProbe, Quality Center, HP Load Runner, TOAD, PLSQL Developer

Databases: Oracle 10g/11g, SQL Server 2008, DB2, Teradata, MS Access

Programming: UNIX Shell Scripting, SQL, SQL*Plus, PL/SQL, HTML, XML, Java, C+

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

OBIEE Lead

Roles & Responsibilities:

  • Effective interaction with the client and other business people in order to understand business requirements and necessary changes as required.
  • Involved in the installation, configuration, customization and extension of OBIEE and ODI.
  • Collaboration and interaction with Oracle Support team in order to solve tickets, issues and bugs after installation and up gradation.
  • Knowledge in setting up ODI connection with Oracle, MS SQL Server and flat files.
  • Worked on debugging the ODI connection with oracle by fixing the respective file, TNS listener and DNS entries.
  • Good knowledge in ODI, creation of mappings, procedures, packages and scenarios to extract the data from disparate sources, and load into target.
  • Creation of reports, dashboards, KPI’s and customization of business applications in OBIEE such as to provide company logo, banner, default navigation on sign-on etc.
  • Worked on creating new dashboards and developed reports in FA, AR, AP, GL etc.
  • Conducted bi-weekly knowledge transfer sessions and team meetings in accordance to OBIEE project requirements.
  • Worked on SCD mechanism for Currency Conversion part of financial module (Custom table).
  • Flexible and effective interaction with the OBIEE offshore team and other counter parts in order to ensure that the work is aligned and everyone is working towards a common and shared goal.
  • Implemented write-back utility in OBIEE to update the database with the end users input such as comments etc.
  • Implemented performance tuning techniques such as cache seeding using delivers in OBIEE and creation of indexes on required tables in order to fetch reports and dashboards very fast in a flash and accurately.
  • Implemented data level security and object level security in OBIEE by means of external table authentication, LDAP, catalog groups, repository settings etc.
  • Complete implementation of OBIEE projects starting from development phase all the way to production.
  • Daily interaction with the offshore team in order to get the updates and provide updates on OBIEE projects.
  • Strong knowledge in Web focus, creation of reports in different formats and styling them, sourcing data from more than one database, code development and management of users.
  • Worked on implementing SCD mechanism for currency conversion part in financial module.
  • Worked with Teradata admin team to get the approvals for Teradata objects creation.
  • Worked on implementing pivot mechanism for list line dimension part of advanced pricing module.
  • Collaboration with the Teradata team to understand the existing 3NF tables and for the creation of respective service views in order to suffice the business requirements.
  • Managing and modifying database (Oracle, Teradata) related objects i.e. tables, views, triggers etc.
  • Effective testing before production and 24/7 post production support including holidays and weekends.
  • Proactively help other team members resolve issues in their work section and projects.

Environment: OBIEE 11.1.1.7x, PeopleSoft 9.1/9.0, Oracle BI Apps 11.1.1.9.1/8.1, TOAD, PLSQL, SQL Server, Windows Server, UNIX, Linux, BI Publisher, ODI 11.1.1.7, Web Focus, Teradata, Oracle, Putty.

Confidential, San Diego, CA

OBIEE Lead

Roles & Responsibilities:

  • Creation of functional and technical specifications based on business requirements.
  • Dealt with OBIEE repository development, creation of reports and dashboards.
  • Up gradation of OBIEE from 10.1.3.4.1 to 11.1.1.7.1 version and patch application as required.
  • Post-upgrade configuration and testing using Quality Center (QC).
  • Worked closely with Oracle Support Team to debug the issues after up gradation and capture several bugs in the newer versions of OBIEE.
  • Worked with external teams to understand the already existing OBIEE repository model and other relationships.
  • Designed and kept track of Requirement Traceability Matrix.
  • Worked on modifying OBIEE repository to adjust connection pool settings, include content filtering and complex joins in order to meet the new business requirements.
  • Developed unit test cases, configured environments and prepared test data for testing.
  • Worked on implementing several features in OBIEE such as combined reports, guided navigation, aggregation rules, action links, CSS properties, briefing books etc.
  • Created Key Performance Indicators (KPI’s) using OBIEE in order to alert the HR team about business changes.
  • Distribution of issues raised in the quality center among the team members.
  • Creation of delivers in OBIEE in order to schedule the reports, dashboards.
  • Worked on re-modeling the repository in order to meet the user requirements and creation, modification of reports in FA, GL, AP, AR, and HR.
  • Worked on customization of dashboards, Accrual, Compensation, Payroll, Retention, Time and Labor, Workforce Deployment and Workforce Effectiveness dashboards.
  • Implemented Multi User Development (MUD) in order to check out projects, merge changes, publish changes to network, and create migration plan to move repository to respective environments.
  • Worked on BI Apps 11g with ODI and customized finance module dashboards and reports with PeopleSoft data.
  • Implemented performance tuning techniques in OBIEE by analyzing SQL queries, modifying repository model and hence resulted in the improved query execution time.
  • Responsible for backup recovery methods and migration of the OBIEE web catalog and repository from DEV, SIT, UAT and PROD environments.

Environment: OBIEE 11.1.1.7.x, Oracle BI Apps 11.1.1.7.1, Oracle 11g, SQL, PLSQL, TOAD, PLSQL, SQL Server, ODI, FSM, BIACM, BI Publisher, HP Quality Center, Windows Server.

Confidential, Colorado Springs, CO

OBIEE Developer

Roles & Responsibilities:

  • Interacted with client in order to finalize on the up gradation of OBIEE and BI Publisher from 10G to 11G which includes migration of reports, dashboards, subject areas, users, scheduler jobs and security configuration.
  • Worked on studying the existing OBIEE repository model and documenting the business requirements which involved interaction with external teams, business people.
  • Modification of connection pools, joins and authorizations in OBIEE after up gradation in accordance with business requirements.
  • Up gradation of OBIEE from 10.1.3.4.1 to 11.1.1.6.8 version and patch application as required.
  • Designed and kept track of Requirement Traceability Matrix.
  • Developed various test cases and test scripts for testing of web pages.
  • Post-upgrade configuration and testing using Quality Center (QC) in order to capture issues or bugs in OBIEE.
  • Worked on customizing dashboard pages in Account Receivables (AR), Customized Payments Due, Payment Performance, and Customer Report.
  • Worked closely with Oracle Support team to debug the issues in OBIEE after up gradation and capture several bugs in the newer versions.
  • Worked on customizing dashboard pages in General Ledger Dashboard (GL), Overview, Asset usage, Financial Structure, GL Balance, Cash Flow, Liquidity, Budget vs. Actual, Balance Sheet.
  • Worked with external teams to understand the already existing OBIEE repository model and other relationships.
  • Worked on modifying OBIEE repository to adjust connection pool settings, include content filtering and complex joins in order to meet the new business requirements.
  • Worked on implementing several OBIEE features such as combined reports, aggregation rules, CSS properties etc.
  • Distribution of issues raised in the quality checker among the OBIEE team members.
  • Creation of delivers in OBIEE in order to schedule and deliver the reports, dashboards.
  • Implemented Object Level security for the objects like reports, dashboards, presentation tables, columns and Data Level security in OBIEE using LDAP authentication.
  • Implemented performance tuning techniques by analyzing SQL queries, modifying repository model in OBIEE and hence resulted in correct output and improved query execution time.
  • Responsible for backup recovery methods (BCP) and migration of the OBIEE web catalog and repository from DEV, UAT and PROD environments.

Environment: Oracle EBS, PeopleSoft 9.0 HR, BI Apps 7.9.6.3, DAC, Informatica, OBIEE 11.1.1.6.x, Oracle 11g, BI Publisher, SQL, PLSQL, Unix shell scripts, TOAD, ODI, HP Quality Center, Windows Server.

Confidential

OBIEE Developer

Roles & Responsibilities:

  • Effectively interacted with the OBIEE offshore team to discuss business requirements.
  • Meeting UI requirements like removal of few icons from the OBIEE application and changing the logo, banner etc.
  • Re-modeling repository which constitutes correcting the joins, creating correct variables and initialization blocks etc. in order to make sure that the consistency checks will not result in any errors in OBIEE.
  • Creation of aggregate tables in order to optimize query time and management of databases and OBIEE applications.
  • Creation/modification of several objects in OBIEE such as Reports & Interactive Dashboards, BIP reports, Narrative view, Guided navigation, Filters, Pivot, Dashboard Prompts and Presentation, session Variables.
  • Worked on Supplier Performance Dashboard, designed and developed dashboard pages such as Trends, Exceptions, Supplier Payables, Quality Performance, Delivery Performance and Price Performance.
  • Creation of Catalog Groups in OBIEE in order to set permissions for items in the presentation catalog and privileges and rights to users and groups.
  • Knowledge in setting up ODI connection with Oracle, MS SQL Server and flat files.
  • Worked on debugging the ODI connection with oracle by fixing the, TNS listener and DNS entries.
  • Knowledge in creation of packages in ODI for carrying out the ELT process.
  • Implementation of new features in OBIEE 11g like Geospatial Feature, KPIs, chart zooming functionality etc. and Event-polling in-order to purge cache as soon as the respective table is updated.
  • Provided mentoring and training for the OBIEE offshore team.
  • Actively participated in the knowledge sharing sessions and other OBIEE trainings.
  • Preparation of FSD (Functional System Design Document) based on BRD (Business Requirements Document).
  • Implemented cross-reporting, various performance tuning techniques like horizontal and vertical federation, content level settings, cache-seeding etc., data-level security in OBIEE in-order to ensure that all users are provided with right data.
  • Creation of trending reports yearly-wise, monthly-wise, weekly-wise and daily-wise in OBIEE in different views for volume and revenue data.
  • Implemented Multi User Development (MUD) in OBIEE which almost reduced the efforts and work-time to half.
  • Implemented clustering environment in OBIEE in-order to balance load and improve application performance and avoid any services failure.
  • Creating and designing reports using BI Publisher based on the requirement in order to provide customized reports to the users.
  • Integration of MS Office with OBIEE by means of BI Plugin.
  • Daily coordination with the onsite team in order to discuss the progress and resolve issues.
  • Provided production support and interacted with Oracle Support team in order to resolve product issues.

Environment: OBIEE 11g, BI Publisher, SQL Server, PeopleSoft, HP Load Runner, Informatica, DAC, Unix, ODI 10g, WebLogic 10.3.5/10.3.4, Oracle10g, BI Apps 7.9.6.1, Windows Server, PL/SQL, TOAD.

Confidential

OBIEE Developer

Roles & Responsibilities:

  • Consolidation of two banks data i.e. east (Wachovia) and west ( Confidential ) data stored in two different databases i.e. Oracle and SQL Server.
  • Creation of separate OBIEE reports for two banks with respect to the changing data and assign appropriate permissions to the users in-order to ensure that users can access only the relevant data.
  • Management of database objects (Oracle, SQL Server) such as tables, tablespace, aggregate tables, views etc.
  • Deliver the critical data to users by means of e-mail, mobile etc. using OBIEE iBots/Agents.
  • Management of scripts and code written in SQL for creating, populating, updating and truncating tables which are stored in Oracle and SQL Server database.
  • Provide the client with comprehensive analysis using OBIEE on volume of the products sold and the respective revenue achieved on yearly, quarterly, monthly, weekly and daily basis.
  • Worked on ODI designer in order to develop processes for extracting, cleansing, transforming, integrating, and loading data into target database.
  • Worked on Supplier Performance Dashboard, designed and developed dashboard pages such as Trends, Exceptions, Supplier Payables, Quality Performance, Delivery Performance and Price Performance.
  • Designed and developed reports, dashboard pages for BI Apps Financials module and other modules Like Supply Chain and Spend Dashboard.
  • Preparation of analysis documents (ex: document with categorized Presentation tables etc.) based on the OBIEE requirements.
  • Created and designed reports using BI Publisher based on the requirement in order to provide the customized reports to the users.
  • Creation and usage of several feature in OBIEE such as Reports, Dashboards, BIP reports, Chart, Narrative view, Guided navigation, Filters, Pivot, Dashboard Prompts, Presentation, session Variables, ODBC connections.
  • Installation and Up gradation of OBIEE from 10.1.3.4.1 to 11.1.1.5.
  • Provided support for the consolidation of data from two banks by managing scripts, databases etc.
  • Creation of several metrics like YAGO Actual Price, YAGO Budget Price, YTD Budget Price, YTD Actual Price, YTD YAGO Actual Price, % Variance with Year Ago Actual Price, % Variance with Year Ago Budget Price.
  • Creation of OBIEE prompts, defaulted, in order to avoid excessive data showing up in the reports and hence reduce query time.
  • Implementation of Business Continuity Planning techniques such as backing up OBIEE repository, catalog etc.
  • Provided production support and interacted with Oracle Support Team in order to resolve OBIEE issues.

Environment: EBS 11.5.10(AP, AR, GL, FA, PO), OBIEE 10g, 11g, BI Publisher, SQL Server, HP Load Runner, Unix, ODI, Oracle10g, BI Apps 7.9.6.1, DAC, Informatica 8.1.1, Windows Server, PL/SQL, TOAD.

Hire Now