We provide IT Staff Augmentation Services!

Obiee /odi Developer Resume

Cranston, RI

SUMMARY:

  • 8+ years of experience in the IT industry with 6+ years of experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence (OBIEE), including 3 full life cycle implementations
  • Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE 11g
  • Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool
  • Good at understanding business requirements and translating them into data warehouse dimensional modeling
  • Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), Delivers/iBots (alerts) and administered Web Catalog Objects (pages, folders)
  • Expertise in providing end-to-end user training and support and provided detail documentation
  • Experience in implementing Out of the Box OBIEE (OBIA) and RPD and Dashboard customizations
  • Strong experience in Extraction, Transformation, Loading (ETL) of data from various sources into target Data Warehouse and Data Marts using Informatica Power Center 7.1
  • Experience in working with BI Publisher
  • Created Tableau workbooks for weekly reporting by establishing connections to Teradata, Sales force and excel worksheets
  • Worked on OBIEE features like Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, Variables/Initialization Blocks configuration etc.,
  • Well versed with Dimensional Modeling (Star and Snow flake) to build the Data warehouse by developing and integrating the database, Client/Server applications using Informatica and Oracle 10g/11g
  • Extensive experience in design, development, testing and production support for Data Warehouse Applications
  • Knowledge on working with Hyperion Cubes
  • Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUDE)
  • Strong experience in working with Oracle, MS SQL Server and Teradata
  • Experience in performance tuning efforts by fragmentation, indexes and partitions
  • Experience managing and coordinating onsite/offshore
  • Expertise in Financial, Sales/Marketing, Telecom, Retail and Pharmaceutical domains
  • Involved in development of Test Plans, Test Cases and Executing Test Cases in quality center
  • Hands on experience with COBOL, DB2, JCL, CICS, VSAM and MQ Series
  • Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments

TECHNICAL SKILLS:

Languages: C, C++, SQL, PL/SQL

Tools: Oracle BI Enterprise Edition 11.1.1.6, 11.1.1.5, 10.1.3.x, Siebel Analytics 7.8.5.3/7.8.4, Oracle BI Applications 7.9.5(DAC, OBIEE Platform), Informatica 6.0/ 7.x/ 8.0/ 8.6 (Power Center), SQL/SQL*Plus, MS Access, TOAD and Tableau 9.0

Platform: Windows NT / 2000, Windows XP, Unix, LINUX

Databases: Oracle 7i, 8, 9i, 10g, 11g, MS SQL Server 2000/2005

PROFESSIONAL EXPERIENCE:

Confidential, Cranston, RI

OBIEE /ODI Developer

Responsibilities:

  • Interact with Chief Data Officer and understand Business Requirements
  • Coordinate with data modelling team in setting deliverables at various stages of data mart release
  • Currently assisting in creating a data model to accommodate data inflow from 14 data sources
  • Working on laying down foundations for design and development of Customer Related Profitability Reporting at three different levels by creating aggregate tables considering the greening process
  • Responsible for decoding the existing RORC, ROARC and ROEC calculations and establish the lineage from source data to the target tables facilitating the ETL mapping exercise
  • Suggested with a final set of four canned reports for the POC and received user acceptance in an attempt to gain user confidence regarding the data sanity
  • Assisting the power user group in replicating the business logic behind the excel macros in Tableau by establishing connection to various data sources mainly sales force
  • Responsible for creating and documenting the security rules around three different hierarchical structures and have them approved from business
  • Trained an off shore team of 6 on Data Warehousing Concepts, basic SQL and majority of the OBIEE interface in a span of 2 months with 2 hour sessions a week.
  • Worked with the admin team on setting up a dedicated OBIEE platform for the Risk Adjusted Revenue Reporting/ Customer Relationship Profitability Reporting
  • Currently working towards identifying the logic and creating a skeleton around a much sophisticated CoBRA model reporting used for predictive analysis
  • Mock up a relational database around the HPSM OLTP database to create a poor man’s datamart
  • Created Published reports for Aging and SLA requirements against the created datamart
  • Created updated Confidential Rates and Riders as needed for MISO Business Service and requirement documentation
  • Wrote PL/SQL and VB.NET code to reconcile data between LODESTAR Billing Expert and PCI GenManager
  • Provided Application Production Support concurrently with development
  • Imported Supply chain data into Tableau to perform data manipulations, data analytics by creating calculated fields, parameters and generated reports.
  • Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, Variables and other various features to meet the business requirements.
  • Created Opaque views on RPD to meet certain reporting requirements.
  • Extensive experience in creating the conditional logical columns and customizing the logical table sources.
  • Created lookup columns in RPD to display CLOBS on BI Answers.
  • Customized default skins and styles for the organization according to the business needs.
  • Created Repository, Session variables and initialization blocks for various reporting needs.
  • Configured Action links to and Go URL's to drilldown to same and different dashboards.
  • Created Presentation variables on front end to meet certain business requirement such as case insensitive filters on dashboard prompts.
  • Created role based dashboards, pages, reports with various views and prompts associated with Security for User Authentication.
  • Used Filters and provided customized dashboard prompts appropriately to avoid excessive data showing up Reports and Maintained effectiveness in creating the dashboards.
  • Managed Security privileges for each subject area and dashboards according to user requirements and Setup the role based visibility of Dashboards to users and business analysts.
  • Involved in merging two different OBIEE Instances by comparing configuration files, merging RPD and merging catalog for both shared and user folders.
  • Involved in Cache management by purging programmatically and Server Cache management.
  • Involved in Production support and Deployment, Upgrading of OBIEE reports from older version to OBIEE newer version.
  • Configured the hive tables to load the profitability system in Talend ETL Repository and create the Hadoop connection for HDFS cluster in Talend ETL repository.
  • Validated Hadoop data against source files using Hive SQL queries.
  • Queried Hadoop table structure and list of partitions using hive SQL queries.
  • Used Teradata fast Load and Multi Load for copying Hadoop data into Teradata temporary tables.
  • Validated dimensions and facts in Teradata using Hadoop base data.
  • Conducted Usage Tracking Auditing to remove unused catalog from the Instance.
  • Conducted Performance Testing on dashboards for 1000 users using Load runner based on number of hits on the dashboard.
  • Involved in Creation of 3-way merging and 2-way merging of RPD and working in MUD environment.
  • Performed data analysis on multiple sources coming from Data marts.
  • Created Testing scripts for Testing Team and giving directions to test the reports with necessary SQL queries and analyzing the data.

Environment: OBIEE 11.1.1.7.1 3 /12 C, BI Publisher 11.X, Informatica 9.0.1, Oracle 11g/12c, Toad 11.5.1.2, SQL Developer 4.1.3.20, PL/SQL Developer 10.0.2, UNIX, Putty, Hadoop, Windows 7, Toad

Confidential, NC

Sr. OBIEE/ ODI Developer

Responsibilities:

  • Worked extensively on performance tuning including creating caching and event polling tables
  • Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers
  • Delivered dashboards like Specific Risk, ICPNL, Generic Recon, Workflow Efficiency, CCAR, Notional, Derivatives report by entity and several SEC Disclosure reports
  • Experience in dimensional modeling, designing and building business models, designing metadata consisting of three layers (Physical Layer, Business Model & Presentation Layer) using OBIEE admin tool
  • Performed Unit Testing and Functional Testing for the various reports and dashboards
  • Involved in production support and fixing any issues
  • Very good knowledge and familiarity with the financial nomenclature besides the report development skills
  • Created dashboards with show/hide feature and customized html scripts to invoke export to excel functionality
  • Structured a highly sophisticated ICPNL Break report used to expose firms intercompany breaks involving all the consolidated entities
  • Created Published reports for Aging and SLA requirements against the created datamart
  • Created updated Confidential Rates and Riders as needed for MISO Business Service and requirement documentation
  • Wrote PL/SQL and VB.NET code to reconcile data between LODESTAR Billing Expert and PCI GenManager
  • Provided Application Production Support concurrently with development
  • Imported Supply chain data into Tableau to perform data manipulations, data analytics by creating calculated fields, parameters and generated reports.
  • Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, Variables and other various features to meet the business requirements.
  • Created Opaque views on RPD to meet certain reporting requirements.
  • Extensive experience in creating the conditional logical columns and customizing the logical table sources.
  • Created lookup columns in RPD to display CLOBS on BI Answers.
  • Customized default skins and styles for the organization according to the business needs.
  • Created Repository, Session variables and initialization blocks for various reporting needs.
  • Configured Action links to and Go URL's to drilldown to same and different dashboards.
  • Created Presentation variables on front end to meet certain business requirement such as case insensitive filters on dashboard prompts.
  • Created role based dashboards, pages, reports with various views and prompts associated with Security for User Authentication.
  • Used Filters and provided customized dashboard prompts appropriately to avoid excessive data showing up Reports and Maintained effectiveness in creating the dashboards.
  • Managed Security privileges for each subject area and dashboards according to user requirements and Setup the role based visibility of Dashboards to users and business analysts.
  • Involved in merging two different OBIEE Instances by comparing configuration files, merging RPD and merging catalog for both shared and user folders.
  • Involved in Cache management by purging programmatically and Server Cache management.
  • Involved in Production support and Deployment, Upgrading of OBIEE reports from older version to OBIEE newer version.
  • Configured the hive tables to load the profitability system in Talend ETL Repository and create the Hadoop connection for HDFS cluster in Talend ETL repository.
  • Validated Hadoop data against source files using Hive SQL queries.
  • Queried Hadoop table structure and list of partitions using hive SQL queries.
  • Used Teradata fast Load and Multi Load for copying Hadoop data into Teradata temporary tables.
  • Validated dimensions and facts in Teradata using Hadoop base data.
  • Conducted Usage Tracking Auditing to remove unused catalog from the Instance.
  • Conducted Performance Testing on dashboards for 1000 users using Load runner based on number of hits on the dashboard.
  • Involved in Creation of 3-way merging and 2-way merging of RPD and working in MUD environment.
  • Performed data analysis on multiple sources coming from Data marts.
  • Created Testing scripts for Testing Team and giving directions to test the reports with necessary SQL queries and analyzing the data.
  • Experience in configuring Interactive Dashboards with drill-down and drill-through capabilities, using go url
  • Responsible for migrating the web catalog and RPD from DEV, UAT and Production environments
  • Involved in gathering Functional requirements and building dashboards accordingly
  • Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, analyzing data sources, creating interface documents etc.
  • Worked on BI Publisher reporting to create structured reports using Microsoft word for SEC fed filings
  • Responsible for integrating the OBIEE code with the front end interface FRAME, Inset/Modify necessary data on the custom tables and migrate them to UAT and to PROD environments
  • Upgraded and migrated the OBIEE Environment/ Code from 11.1.1.5 to 11.1.1.7
  • Used 3 way merge concept to merge RPDs and then migrate
  • Periodically installed the standalone/bundle patches as and when needed

Environment:: OBIEE 11.1.1.7.1 3, 11.1.1.7.1, BI Publisher 11.X, Informatica 9.0.1, Oracle 11g/12c, Toad 11.5.1.2, SQL Developer 4.1.3.20, PL/SQL Developer 10.0.2, UNIX, Putty, Hadoop, Windows 7, Toad, Linux, Aqua Data Studio

Confidential, St. Louis, MO

OBIEE/ODI Developer

Responsibilities:

  • Involved in requirements gathering, designing functional and technical specifications for reporting needs
  • Created and maintained the dashboards like RRB, Confidential , Management Analyst, Core and Cycle Time
  • Configured physical, business model and presentation layers of the Analytics Repository Customized/Modified Metadata repository (.rpd) suiting to the organization’s data
  • Created and granted privileges for the users using OBIEE repository as well as Presentation Services
  • Worked on cache management to enhance query performance
  • Developed cut over mappings and maintained the SDE and Silos workflows.
  • Modified the existing mappings by introducing new sources and customized logic to meet the requirements
  • Configured the informatica jobs in the DAC server based on the dependency
  • Configured automated email setup to alert the team of any unsuccessful jobs from the daily load
  • Created iBots and Delivers to send Alert messages to subscribed users
  • Involved in Root Cause Analysis of issues and day-to-day production support

Environment:: OBIEE 10.1.3.4, OBIA 7.9.6.2, Informatica Power Center 7.x, Oracle 11GR2, DAC 10.1.3.4.1, Siebel CRM, UNIX, Windows XP

Confidential, Boston, MA

OBIA/OBIEE Developer

Responsibilities:

  • Involved in development and support of reports and rpd
  • Designed a customized security model for a subset of users providing them with limited dashboard access
  • Delivered reports like Staffing, Demographics, Trends, Employee Roster and other HR reports
  • Involved in root cause analysis and troubleshooting the ETL mappings which were resulting several data issues
  • Optimized the runtime on DAC server by adjusting the precedence of jobs
  • Customized the out of box rpd to meet the functionality of business procedure.
  • Created the technical design documents, functional documents and BR documents
  • Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also helped creating hierarchies, variables, time comparison analysis and event poll strategies in the repository
  • Used different views in OBIEE like view selector, column selector, table, pivot, chart
  • Involved in developing JIL’s and setting the Autosys jobs.
  • Performed Unit Testing and Functional Testing for the various reports and dashboards
  • Created training manuals for the users, conducted training and presentations to the users to help drive user satisfaction
  • Re-designed the existing data run time procedure and delivered the dashboards to users improving the availability of product
  • Involved in Code migration and backup procedure between different environments from DEV to QA, QA to UAT and UAT to Pilot
  • Involved in setting the Clear case deployment by creating a base line and working closely with the support team

Environment:: OBIA 7.9.6.2, OBIEE 10.1.3.4.1, UNIX, Putty, SQL Developer, Win XP, Windows 7, Informatica 8.6.1, DAC 10.1.3.4.1 .

Confidential, Ramsey, NJ

OBIEE/ODI Developer

Responsibilities:

  • Involved in gathering the functional requirements and the process by meeting up with the end users.
  • Involved in migration of reports from Hyperion to 11g.
  • Delivered reports like Fair Value Reports, BS, Trail balance and HR reports
  • Designed, implemented the Metadata, Reports and Dashboards for the Views and Disclosures, PL&BS Analysis and Inventory subject areas using the OBIEE tool
  • Heavily customized the reports & Dashboards to meet the look, feel and services offered by Hyperion
  • Created the technical design documents and functional documents
  • Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also helped creating hierarchies, variables, time comparison analysis and event poll strategies in the repository
  • Used union reports, drilldown, presentation variables and prompts in the creation of answers and dashboard reports
  • Used different views in OBIEE like view selector, column selector, table, pivot, chart
  • Configured the Scheduler and created iBots, which were sent out to the users on a daily basis
  • Performed Unit Testing and Functional Testing for the various reports and dashboards
  • Created training manuals for the users, conducted training and presentations to the users to help drive user satisfaction
  • Used Unix as part of the migration procedure between different environments from Dev to QA, QA to UAT and UAT to Prod

Environment:: OBIEE 11.1.1.6, Hyperion, SQL Developer, Oracle 11g, Essbase 11.1.1.3, Windows XP

Confidential, Piscataway, NJ

OBIEE/ODI Developer

Responsibilities:

  • Involved in upgrading various projects from 10G to 11g and responsible for fixing various defects occurred during the upgrade of 10G catalogs.
  • Raised various service requests and worked closely with oracle in finding fixes and patches for the discrepancies of upgraded reports.
  • Analyzed the gathered business requirements and translated the functional specifications into technical specifications.
  • Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
  • Developed Oracle BI Metadata Model (Repository) based on different requirements, with the necessary logic that involved building the Physical, Business Model Mapping and the Presentation layer.
  • Developed various Measures/Metrics and defined dimensional hierarchies (Time, Locations, and Services etc).
  • Created different presentation catalogs/folders in the presentation layer for different groups depending on the business requirements.
  • Developed Financial reports (AR Aging by customer category, Customer Gross Margin etc) and also implemented guided navigation within reports.
  • Developed Dashboards with different subject matter Views (Drill-Down/Dynamic, Pivot Table, Graph, Tabular with global and local Filters) using Oracle Business Intelligence (OBI) Presentation Services for the various work streams.
  • Created Dashboard Prompts which are used as global filters at a Dashboard level.
  • Created and scheduled Agents to deliver Analytics content for subscribed users and also to seed the cache.

Environment:: OBIEE 11.1.1.6, SQL Developer, Oracle 11g, Essbase 11.1.1.3, Windows XP

Confidential

OBIEE Developer

Responsibilities:

  • Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (.rpd).
  • Worked with business analyst and users (Financial Advisors or FAs) to gather analytics requirements and created the physical and business model.
  • Depending on the requirement created Facts, Dimensions and Hierarchies of the business model.
  • Worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
  • Extensively used Transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator depending on the business requirements.
  • Extensively worked with Workflow manager to create tasks, workflows and execute the tasks and Workflow monitor to monitor the workflows.
  • Worked on performance tuning at various levels like Target, Source and Session to achieve high response times.
  • Identified errors and created error handling strategies and developed prompts for filtering the data.
  • Involved in Unit Testing and preparation of the test cases.

Environment:: OBIEE 10.1.3.2.1, Informatica, Oracle 10i, OBI Apps

Hire Now