We provide IT Staff Augmentation Services!

Obiee/odi Developer Resume

SUMMARY

  • 8 years of expertise in OBIEE 12c, OBIEE 11G/10G, BI Publisher and BI administrator Repository tools.
  • Played major role in upgrading fromOBIEE 11.1.1.6.12 to OBIEE 12C, OBIA 11.1.1.10.1 , and ODI11g.
  • Installed OBIA 11.1.1.10.1 , OBIEE 11.1.1.9.0 and ODI 11.1.19.0 on one sever and applied platform patches and installed OBIEE 12 C on the second server.
  • Involved in the configuration by running the Configapps.sh and Config.sh for the OBIEE and ODI.
  • Experience with Weblogic server and Enterprise manager in OBIEE 11g.
  • Performed Three - Way-Merge to embedding the new functionally of RPD which comes with OBIA 11.1.1.10.1 with our custom RPD (OBIEE 11.1.1.6.12 ).
  • Good knowledge on Data Warehousing concepts like star and Snowflake Schema Methodologies along with the Strong Banking domain skills and experienced IT project lifecycle in a banking environment as the OBIEE Report Developer and ODI Developer.
  • Responsibility includes involvement in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
  • Actively involved setting up OBIEE and BI Publisher across multiple server locations
  • Integrated the BI Publisher with Oracle EBS, BI Answers, Reports, and Dashboards, to generate standardized reports.
  • Designed and developed the OBIEE/ Metadata Repository using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer.
  • Created the star schemas, dimensional hierarchies, Aggregations, Fragmentation in Business Model layer in OBIEE Admin tool based on the requirements for these Subject Areas.
  • Experience in configuringSecurity Settings(groups, roles, access/query/report privileges) and schedulingiBots/Agents for OBIEE 10g and OBIEE 11g.
  • Configured LDAP security in Console for the newly created provider as per as the business rules.
  • Involved in creating Master Repository and Work Repository for ODI 11.1.1.9.0 .
  • In Topology layer involved in creating the Data Servers, physical server the Physical architecture, Logical architecture schema and Context in ODI 11.1.1.9.0 .
  • Setup the Model for the source database and target database and loading the required Data Store by using Reverse Engineering Modules in ODI 11.1.1.9.0 .
  • Developed Informatica Mappings/Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources and Creating Workflows & Tasks, and Scheduling using Workflow Manager.
  • Excellent knowledge on the ODI Knowledge Modules such as LKM, IKM, CKM, JKM, RKM, SKM.
  • Expertise with developing dynamic and interactive Dashboards with drill-down drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
  • Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series & Caching.
  • Worked with BI Publisher to report real time data to the users.
  • Interacted with Business Analyst to understand the business requirements and also designed the ETL Mapping specifications for ETL Mappings of Data warehouse.
  • Experience with Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapping Designer, Repository manager.
  • Experienced with designing ETL execution plan and scheduling task using DAC.
  • Performed the Performance tuning to the ETL code at the Database, Mapping, Session and workflow levels.
  • Performed coordination with the offshore team for all OBIEE andETL Informaticadeliverables with daily status calls and follow up on gap items on daily basis.

TECHNICAL SKILLS

ETL Tools: ODI (Oracle Data Integrator) 11g/12c.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer, MS Visio.

DBMS: Oracle 12c/11g/10g/9i/8i, DB2, MS SQL Server 2005/2000, MS Access, Excel, Teradata (Fast-Load, Multi-Load, Fast Export, BTEQ), ODBC

Programming Languages: SQL, PL/SQL

OLAP/Reporting Tools: OBIEE 11x/10.1.3.x, BI Admin tools 11.1.1.9, BI Publisher, Crystal Reports XI R2,Business Objects11.1.1.5, OBIA 7.9.x, Scheduler (Agents/iBots)

Operating Systems: Windows XP/ 2008/2003/2000/ NT/98/95

Other tools: VISIO, SQL *Loader, Putty, SQL Navigator 5.5.

PROFESSIONAL EXPERIENCE

Confidential

OBIEE/ODI developer

Responsibilities:

  • Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details. Installed configured and administrated OBIEE 11G.
  • Installation of Siebel Analytics/OBIEE and related components for development, QA and production environments.
  • Worked on Key Performance Indicators (KPI) within the BI environment which can be used as the catalyst toward driving more responsive interaction between users and data.
  • Worked on Configuration & Application Deployment Management.
  • Designed and developed Performance Measurement Dashboards/ Reports that are Dynamic & Interactive with drilldown, drill across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
  • Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
  • Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions and managing Cache.
  • Worked on Metadata Repository objects and also Web catalog Objects which include Dashboards, Reports, Pages and Folders.
  • Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
  • Implemented data level security (Location Managers, Sales Executives etc.) using Session.
  • Variables by creating content filter in dimension table in rpd.
  • Installed ODI. Set up the ODI connection with Oracle, oracle SQL Server and flat files.
  • Troubleshoot the ODI connection with oracle by fixing the tnsnames.ora file.
  • Implemented object level security for both repository objects and web objects by creating users and groups in repository and web catalog groups in the Presentation Services.
  • Created Dimensional Hierarchies and Level Based measures, worked on Expression Builders and Calculation Wizards to generate certain expressions.
  • Created ODI packages, scenarios using interfaces, variables, procedure
  • Performance tuned the OBIEE11.1.1.9interfaces.
  • Extensively worked on developingData modelbased onSTARschema concept usingOBIEE 11g Administration Toolfor current and future reporting requirement.
  • Customized Oracle BIEEMetadata Repository using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
  • Performed implementation from OBIEE11g to OBIEE12C.
  • Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
  • Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIEE 11.1.1.9,OBIEE 12C, ODI 12.2.1,BI Publisher, BI Admin tools 11.1.1.9.0 , SQL, PL/SQL, Oracle 10g, Windows, Web Logic Server 11gR1 PS3, Financial Analytics, HR ( Human Resources) Analytics.

Confidential - Westlake, TX

ODI/OBIEE developer

Responsibilities:

  • Created and developed the ODI Interface metadata mappings to extract the data from Exhibition Event Master and EBS Apps to consolidate the data into Enterprise data warehouse.
  • Involved in system performancetuningto improve the performance from OBIEE report/dashboard wise and RPD.
  • Designed Aggregate Tables modeled the repository for improving performance of reports.
  • Identified Gaps by analyzing the Datamart instance and provision of alternative solutions as well as recommendation of changes to databases.
  • Designed ETL mappings for bringing in data from various data sources using ODI.
  • Identified the fact and dimension tables, designed the Kimball Matrix, created the data mapping field matrix
  • Developed multiple Dimensions with multiple 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
  • Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures. Also created Fragmentation content for few fact tables
  • Involved in data model designs and assisted in ETL design mappings using Oracle Data Integrator (ODI) to extract the data.
  • Modify existing ETL jobs in Oracle Data Integrator(ODI).
  • Develop data extracts from the data warehouse environment using ODI.
  • Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
  • Developed OBIEE dashboards using JavaScript and Cascading style sheets.
  • Created Roles/Groups in OBIEE to provide the access to multiple departments without relying on the responsibilities.
  • Integrated LDAP server in order to authenticate the users along with Native authentication. Maintained the groups in LDAP and applied the security on user level.
  • Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
  • Extensively worked on complex Interfaces which involved slowly changing dimensions.
  • Created Complex procedures and used them in the interfaces to load the data to simplify the interface design. Automated the schema name using ODI interface function in procedures.
  • Customized requests and modified the OBIEE Dashboard using cascading style sheets
  • Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements
  • Performed Unit, Integration, and Regression testing to validate report and mapping
  • Respectively participated in weekly Project status meetings and communicated effectively with Project Managers

Environment: OBIEE 11.1.1.5.x, BI Publisher, Oracle 11g, ODI 11.1.1.9, SQL, PL/SQL.

Hire Now