We provide IT Staff Augmentation Services!

Obiee Architect/lead Obiee Developer Resume

Phoenix, AZ

SUMMARY:

  • Over 9 years of IT experience in Oracle Business Intelligence Enterprise Edition, Business Objects, Tableau, SQL, PLSQL, Informatica (ETL).
  • Certified Professional Oracle Business Intelligence (OBI) Foundation Suite 11g.
  • Expertise in Requirement gathering, design, development, testing, implementations and documentation in various Business Intelligence environments.
  • Expertise in building the Data warehousing Models by planning, design, development, testing and deployment in various methodologies.
  • Strong experience in Installation and configuration of OBIEE, Business Objects.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
  • Strong Data Warehousing ETL experience of using Informatica Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
  • Experience in Performance tuning and Optimization of Cache in OBIEE.
  • Expertise in design, development and maintenance of OBIEE repository (RPD) using Admin tool physical layer, BMM layer and presentation layer.
  • Experience in using session variables and repository variables in admin tool. Experience in RPD security, session logs, object level security.
  • Experience in Identifying and debugging the errors in RPD before deploying and moving RPD from Development to testing and testing to Production.
  • Expertise in OBIEE interactive Dashboards with drill-down capability by making use of Filters.
  • Experience in OBIEE security setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboards, Folders, Reports). Expertise in developing reports in OBIEE analytics and BI Publisher.
  • Experience in moving web catalog from Dev to testing and testing to production. Expertise in OBIEE server maintenance, application roles. Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series and Caching.
  • Extensively implemented security privileges by creating Users, Groups and Application Roles and assigning access to the users and folders.
  • Expertise in writing complex SQL queries for reporting needs. Strong knowledge on PLSQL functions, procedures, packages, triggers etc. Expertise in designing SAP BO universe and complex BO reports.
  • Involved in OBIEE administrative tasks like upgrade, deployment, patches, security, users, groups, applications roles, Authentication and scheduler activities.
  • Very Good experience in interacting with business users, business owners for requirements, analyzing business process and making necessary changes to the reports and query's to fulfill reporting needs.
  • Designed Functional Documents, Technical Specification documents and Test Cases in development and testing phases.
  • Strong Data Warehousing ETL experience of using Informatica Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
  • Used ODI for Extract, Load and Transform data from source systems into target systems.

WORK EXPERIENCE:

OBIEE Architect/Lead OBIEE Developer

Confidential , Phoenix, AZ

Responsibilities:

  • Involved in Requirement gathering from business and interacting with Business users and functional team for getting business logic for the reports.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Installed OBIEE 11g suite includes BI administration tool, Oracle BI Enterprise Manager, Oracle BI Administration Console, Web logic server etc on windows and Linux environments.
  • Involved in business requirement analysis and data analysis for developing the repository (RPD).
  • Designed OBIEE RPD bringing tables and joins in Physical layer, defining business logics in Business Model and Mapping layer and providing presentation layers for analytics. Created Logical table sources, logical columns to meet the business needs.
  • Worked on Opaque views and table aliases to meet the complex business requirements. Used hierarchies for report drilling and enabled drilling for users in OBIEE Analytics.
  • Implemented security at RPD (object level and data level in OBIEE repository) and enabled cache information and logging levels.
  • Created repository variables, session variables and Initialization blocks for analytics purpose.
  • Developed OBIEE interactive dash boards which are user friendly, easy data visualization and used data filters and dash board level to restrict the data.
  • Developed OBIEE dashboards based on product sales, region sales etc.
  • Specified dimensional levels for hierarchies and performed web catalog and cache management. Developed BIP reports, using complex SQL queries as per the business requirement.
  • Worked on OBIEE analytical reports using pivot table, and various types of graphs. Created PLSQL procedures to meet the requirement for the historical data to collect in reports.
  • Worked PLSQL functions and used the available functions in packages. Prepared Report design documents for future reference and test case documents for testing.
  • Involved in UAT Support in defect fixing and providing the reports on time. Performed OBIEE Administrative tasks like access privileges to the users, groups and folders.
  • Maintained OBIEE servers start and stop issues, web logic servers and web catalogs. Involved in performance tuning of the OBIEE reports at query level and report level.
  • Scheduled BIP reports into folders, Email and FTP servers. Used oracle data integrator for data integration from various source databases.
  • Developed report for region sales, department sales, and product based. Designed OBIEE dashboards for based products and region sales and years.

Environment: Oracle 12c/11g, Oracle Business Intelligence Enterprise Edition 11g, BI Dashboards, Analytics, BI Publisher, OBIEE Administration Tool, ODI, PLSQL, PLSQL developer, Toad, Informatica.

Lead OBIEE Developer/Sr. OBIEE Consultant

Confidential , Chandler, AZ

Responsibilities:

  • Involved in Requirement gathering from business and providing the understanding of the business logic to the team for report development.
  • Interacted with Business users and functional team for getting business logic for the reports. Involved in Leading and guiding the team in designing the OBIEE repository and reports.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Installed OBIEE 11g suite includes BI administration tool, Oracle BI Enterprise Manager, Oracle BI Administration Console, Web logic server etc on windows and Linux environments.
  • Worked on different layers of OBIEE RPD Physical layer, BMM layer and presentation layer. Created tables links and joins at physical layer moved them Business Model and Mapping layer for Implementing the business logics and presentation layer for report development process.
  • Created opaque views and aliases to tables at physical layer to meet complex business needs. Generated hierarchies level based and parent-child to enable the report drilling in BMM layer.
  • Created logical tables, Joins and logical table sources in Business Model and Mapping Layer. Used aggregated and logical columns, measures in BMM layer to meet business requirement.
  • Developed medium to complex reports using complex SQL queries in BI Publisher and Analytics. Used repository variables, session variables, log levels, cache management in OBIEE RPD.
  • Performed OBIEE security object level and data level and enabled cache for tables.
  • Created dimensional hierarchies, and multiple data sources to meet the business needs. Developed retail, transactional and balance sheet reports.
  • Implemented OBIEE administration for user, groups, application roles, reports. Maintained OBIEE servers start and stop issues, web logic servers and web catalogs. Scheduled BIP reports into folders, Email and FTP servers.
  • Developed Complex analytical reports using pivot table, and various types of graphs. Involved in initial level report testing and worked on change requests for few reports.
  • Prepared Report design documents for future reference and test case documents for second level of testing by the bank people.
  • Supporting in UAT defect fixing and providing the reports on time. Involved in providing the access privileges to the users, groups and folders.
  • Involved in performance tuning of the OBIEE reports at query level and report level.
  • Worked with Informatica to Extract, Transform and Load data from various source systems into target Data Warehouse and Data Mart using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger etc,.)

Environment: Oracle 12c, Oracle 11g, Oracle Business Intelligence Enterprise Edition 11g, BI Dashboards, Analytics, BI Publisher, OBIEE Administration Tool, Web logic server, Informatica.

Sr. OBIEE Developer

Confidential, Chicago, IL

Responsibilities:

  • Involved in requirement gathering, analysis, design, development of Repository, Reports. Interacted with Business users and functional team for business and functional logic of reports.
  • Discussed and provided the project design and admin process to the bank before development. Installed and configured OBIEE 10.1.3.2 for report development and involved in Administration.
  • Involved in ETL process of the project for database understanding for report development. Involved in Informatica designer, mappings, source and target column mapping, transformations.
  • Involved in leading the team and guiding them in Report and Dash board development process.
  • Created OBIEE repository using multiple databases and connection pools at physical layer. Created opaque views and aliases to tables at physical layer to meet complex business needs.
  • Used RPD repository variables, session variables and initialization blocks for business needs. Set the Joins as to meet the report needs, table cache and logging levels in RPD physical layer.
  • Performed parent-child relationship and level based hierarchies for drilling in BMM layer. Created logical tables, Joins and logical table sources in Business Model and Mapping Layer.
  • Used aggregated and logical columns, measures in BMM layer to meet business requirement. Analyzed the report requirement and created complex opaque Views in RPD physical layer.
  • Worked on medium to very complex reports BI Publisher using SQL queries and RPD. Developed reports in BI Publisher reports, analytics reports and dashboards.
  • Created reports using multiple subject areas by combining the queries in OBI Analytics. Used report navigation option to see detailed report as per the business requirement.
  • Created Filters, report prompts at report level and dashboard prompts at dashboard level. Developed complex reports in Analytics coming from different subject areas.
  • Designed oracle business intelligence interactive dashboards and used dash board prompts. Created Oracle business Intelligence Analytics reports and report drilling to the detailed level.
  • Involved in User administration, i.e user and group creation, providing the access levels to users.
  • Preparing and guiding team in Report design documents for future reference.
  • Preparing guiding team in test case documents for second level of testing by the bank people. Supporting in UAT defect fixing and providing the reports on time.

Environment: Oracle 11g, Oracle 9i, Oracle Business Intelligence Enterprise Edition 10.1.3.2, SQL, PLSQl, PLSQL developer, Toad.

OBIEE Developer

Confidential, Irving, TX

Responsibilities:

  • Analyzing the Report Requirements based on the Functional Specifications received. Developed OBIEE RPD using Administration tool.
  • Developed both Analytics reports and Dashboard Reports. Developed reports using Sorts, filters and Prompts etc.,
  • Developed high level reports for the senior management. Developed medium and complex OBIEE Reports.
  • Used various functions like combine queries, report navigation and dashboard prompts.
  • Created Repository Variables and session variables in OBIEE RPD. Involved in Users and Group level security Access.
  • Involved in scheduling the reports to the folders. Prepared report design documents and test case documents. Provided report fixes during the UAT phase.

Environment: OBIEE

Hire Now