We provide IT Staff Augmentation Services!

Obiee Senior Developer Resume

El, SegundO

SUMMARY

  • Over 12+ of Industrial Experience as IT professional with expertise in analysis, design, testing, development and implementation of BI applications.
  • With around 9 years of experience as BI Consultant having experience in gathering Business Requirements, performing GAP Analysis, Data Modeling, Design & Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse and Business Intelligence.
  • Expertise in providing end - to-end business intelligence solutions using OBIEE.
  • Experience in gathering the business requirements, analyzing the technical feasibility and providing best possible solutions.
  • Good experience in converting the business requirements into technical specifications and design specifications.
  • Experience in interacting with users, gathering requirements, and drawing up Business Case Scenarios.
  • Strong experience in RPD Development (physical, Business Mapping & Modelling, presentation Layers).
  • Developing Dimensional hierarchies, Expression builder, Time series wizard and Calculation wizard and repository views.
  • Experience in creating and using repository variables, session variables and presentation variables.
  • Experience in developing Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
  • Expertise in creating different report views like Table, Pivot, Charts, View/Column selector, Narrative and Union reports.
  • Experience in setting up Multiuser development (MUDE), Merging and Importing Objects from different repositories.
  • Experience in migrating metadata and web catalogue between different environments.
  • Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
  • Expertise in Clustering, Load Balancing, Configuring delivers & iBots.
  • Expertise in Cache management, performance tuning at report level & database level.
  • Experience in Installation, development, administration & production Support of OBIEE.
  • Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).
  • Expertise in configuration of Oracle BI Analytics Repository (Execution Plans, Subject Areas, Containers, Design, Setup, Execute etc.,), Create/Manage Intelligent dashboards.
  • Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box(Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided data warehouse BAW,OBIEE RPD development, OBIEE reports and dashboards.
  • Expertise in converting and using Oracle pre-built RPDs according to business requirements.
  • Detail understanding of OLTP and OLAP Data models to create and manage the repository with the available metadata OBIEE.
  • Experience in Data Analysis and Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data Modeling using Erwin.
  • Experience in Interface design with the source systems to capture the data required to meet the MIS requirements.
  • Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
  • Worked with different SDLC Environments Agile, Iterative, and Water Fall Methodologies.
  • Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms and Ability to learn and adapt to new technologies.

TECHNICAL SKILLS

BI Tools: OBIEE 11.x, 10.x, Siebel Analytics 7.x, Oracle BI Apps 9.x, Hyperion 9.x, BO 6.x

ETL Tools: Informatica Power Center, Oracle Warehouse Builder

Databases: Oracle, Teradata, SQL Server, Netezza

Languages: SQL, PL/SQL

Operating Systems: Windows, UNIX, Linux

Tools: TOAD, SQL Assistant, Aginity, Putty, Erwin

Other Special S/W: StarTeam, VSS, HP Quality Center, HPSM, Serena, Autosys

Packages: MS Office Suite, MS Project, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, El Segundo

OBIEE Senior Developer

Responsibilities:

  • Involved in gathering business requirements and data analysis.
  • Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
  • Created/Modified Metadata repository (.rpd), Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
  • Created Repository variables to achieve dynamic reports and dashboards and also implemented initialization blocks to pass values to the variables.
  • Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
  • Created DB Usage Tracking Subject Area with federated data, data coming from DB Metadata tables and OBIEE Usage Metadata tables.
  • Implementation of criteria filters to narrow-down the result set from the analytics requests.
  • Overhauled the OBIEE Subject Areas to improve the report performance.
  • Involved in performance tuning of many reports.
  • Involved in resolving complex user requirements in OBIEE where tables cannot be altered from the database side.
  • Created BTEQ scripts to extract data and schedule them as per the business requirements.
  • Actively participated and scheduled Automated OBIEE iBOT Reports.
  • Involved in modifying AOM scripts that load data for day to day reporting.
  • Involved in complex SQL Coding and BTEQ scripting to create and load reporting tables.

Environment: OBIEE 11.1.1.7, OBIEE 10.1.3.4, Teradata 13.0.0.15, SQL Assistant, Linux, Windows Server 2003

Confidential

OBIEE Administrator, Designer and Developer

Responsibilities:

  • Involved in gathering business requirements and analysis. Meeting with business users to gather user requirements and did thorough Data Analysis. Based on the requirements identified the scope of new data, confirming dimensions between new and existing Warehouse tables, Drill Downs and developed the business requirement document.
  • Translation of the business requirements to technical requirements.
  • Created/Modified Metadata repository (.rpd), Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
  • Created Repository variables to achieve dynamic reports and dashboards and also implemented initialization blocks to pass values to the variables.
  • Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
  • Designed and built OBIEE data level security based on external database model to deliver an intelligent authentication mechanism with Row-Level security.
  • Development of interactive flash-based drillable charts such as bar-charts, pie-charts, radars, bubble-charts, etc using BI Server.
  • Implementation of criteria filters to narrow-down the result set from the analytics requests.
  • Implemented Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones.
  • Involved in Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
  • Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
  • Involved in resolving complex user requirements in OBIEE where tables cannot be altered from the data side.
  • Performed Unit testing, Integration testing, and Regression testing to validate deployment.
  • Involved in migration of OBIEE repository, web catalog from Development environment to testing and then to UAT and Production.
  • Providing day to day support for Stars iQ application which involves monitoring the ETL Processes, handling data fixes, resolving the problems reported by the call center analysts and ad-hoc reporting.

Environment: OBIEE 10.1.3.4, Siebel Analytics 7.8.4, Informatica Power Center 8.1.1, Autosys, Oracle 10g, TOAD

Confidential

OBI Consultant

Responsibilities:

  • Participated in discover/design phase of business requirements by meeting various business users.
  • Prepared Fit/Gap Analysis documents between requirements in necessary customizations and out-of-the-box Oracle BIA functionality.
  • Analyzed the business requirement gatherings and translated the functional specifications into technical specifications.
  • Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP systems.
  • Extracted the pre-built BI solutions of tables by using Oracle BI Apps, OBI Admin tool to configure and create repository (.rpd) and prepared a detail design document.
  • Developed the repository model based on different requirements, with the necessary logic that involved customizing the OOTB Physical, Business Model Mapping and the Presentation layer.
  • Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
  • Created hierarchies, variables, time series measures and event poll strategies in the repository.
  • Developed and customized HR Analytics OOTB reports and new Reports, performed look-good changes to OOTB Dashboards with different subject matter Views (Drill-Down/Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBI Presentation Services for the various work streams.
  • Developed calculated measures and assigned Aggregation levels based on dimension hierarchies.
  • Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
  • Designed and implemented the Bulletproof Single Sign on (SSO) process so that users can navigate from the portal to the OBIEE dashboard.
  • Responsible for creating the Complex Crystal Reports(On demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports).
  • Implemented guided navigation within reports.
  • Worked with ETL Team on Informatica Power Center tools - Source Analyzer, Data warehousing designer, Mapping Designer and Mapplets, Transformations, Work Flow Manager (Task Developer, Worklets and Work Flow Designer) and Work Flow Monitor.
  • Involved in creating custom Mappings, Mapplets to load the new tables and the new information into the warehouse.
  • Used DAC Client to customize and execute out-of-the box DAC execution plans to run all ETL mappings at specified interval.
  • Customized DAC tasks, tables, table groups and indexes as per requirements.
  • Performed nightly incremental loads using DAC.
  • Customized the change capture process of DAC to load data incrementally.
  • Involved in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.
  • Successfully conducted pre-launch and post launch demos to end users.

Environment: OBIEE 10.1.3.2, Oracle BI Apps 7.9.5, Oracle 10g, Oracle EBS R12, Informatica 8.1, DAC 10.1.3.2, Windows 2003.

Confidential

OBI Consultant

Responsibilities:

  • Involved in initial technical and functional discussions to understand and define the scope and objectives of POC.
  • Involved in identification of key business measures.
  • Involved in ETL coding using PL/SQL packages and OWB mappings for populating source data into the target EDW in a three stage process.
  • Involved in setting up Siebel Analytics 7.8.5 environment both development and production using clustering to facilitate failover on Windows.
  • Design & development of multiple reports using various templates like tabular reports, pivot reports and chart reports.
  • Performance tuning by analyzing and comparing the turnaround times between SQL and Siebel Analytics.
  • Design and development of OBI dashboard reports.
  • Involved in Siebel Analytics Security set up using external table authentication.
  • Co-ordinating with Functional users, Database Architect and offshore team to deliver the code intact with agreed timelines.
  • Maintaining the process compliance in all Milestones of project.
  • Involved in preparation of user manual and other technical documentations
  • Conducted Web based trainings for Functional IT Owners to make them understand how to use the reporting system.
  • Using admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
  • Worked on layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
  • Implemented various Repository Variables and System Variables depending up on user requirements.
  • Created transformations like Expression builder, joiner, and router.
  • Designed various reports i.e. Pivot, Narrative and Chart reports in Answers and Configured Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and Charts.
  • Giving security permission / privileges as per the role of each user.
  • Scheduling the Developed reports according to Client requirements.
  • Tested and validated the repository, reports and dashboards.

Environment: Siebel Analytics 7.8.5, Business Objects 6.5, Windows XP, Oracle10gSQL Server 2000, TOAD.

Confidential

BO Developer

Responsibilities:

  • Requirement Gathering, functional and technical specifications and writing requirements and interface with end users.
  • Identified the GAP’s by analyzing the Data mart instance and provided alternative solutions as well recommended changes to database.
  • Involved in gathering business requirements, data transformation, data loading, SQL and performance tuning.
  • Designed and developed Universes for report generation.
  • Created Ad-hoc reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae etc.
  • Responsible for creating a test plan for all the reports for QA.
  • Performed Unit testing and Integration testing to validate Dashboards/Reports.
  • Worked on tuning the longest running mappings by turning them to SQL procedures for quicker run times.
  • Designed and developed Technical User Documentation and involved in training the end users.

Environment: BusinessObjects 5.1.3, Web Intelligence 2.6, Informatica Power Center 7.1.2, Oracle 9g, Toad, Windows 2000

Confidential

BO Developer

Responsibilities:

  • Created Mock Up Reports for the new business requirements
  • Created reporting metrics and transfer key performance indicators to a process and database design.
  • Used Universes as source for the Business Objects reporting and analysis.
  • Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail and Formulae, Slice and Dice, Drill Down, @Functions, etc.
  • Involved in Executive Reporting for each Business Area like FTM, DM and MIS.
  • Created and customized reports based on the client requirements following the best practices and methodologies.
  • Prepared Test Plan, Test Strategy and Test Case.Involved in end to end testing.
  • Used Broadcast Agent for Scheduling Metrics and Document refresh periodically.

Environment: Business Objects 5.1.6, BroadcastAgentPublisher, Web Intelligence 2.7SQL Server, Windows NT

Hire Now