We provide IT Staff Augmentation Services!

Senior Bi Consultant Resume

Houston, TX

SUMMARY

  • Over 11+ years of experience in IT industry wif Oracle BI Applications, OBIEE and Informatica. Extensive experience wif Tableau, Microsoft Power BI and Hyperion Interactive Reporting Studio.
  • Experience in Business Intelligence and Transactional applications, Design and implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling
  • Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Data Modelling and Business Intelligence solutions
  • Expertise in implementing like implementing Out of Box prebuilt mappings, Designing ETL INFORMATICA & DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards, Upgrading teh versions and implementing security.
  • Implemented modules for BIAPPS are Financials, PROC, SCOM, Projects, Marketing HR Analytics and Manufacturing
  • Strong experience in Installation, Configuration and Administration of OBIEE.
  • Expertise in complete lifecycle Implementation of Business Intelligence wif Star and Snow Flake Schemas
  • Very strong experience in developing OBIEE Repository (.rpd)
  • 3 layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards wif drill - down capabilities using global & local Filters,
  • Expertise in implementing Security Models for Dashboards, Row level, objects Level, Role Level, and Dashboard Level; Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling me-Bots
  • Hands on experience in Authentication and Authorization of OBIEE by using External Authentication, LDAP Authentication
  • Experience in creating Aggregate tables
  • Implemented MUD Environment and worked on three and two-way merging
  • Having good noledge on Parent-Child, Ragged and Time dimension hierarchies in OBIEE 11g
  • Strong experience in developing and customizing Reports using OBIEE 10.X, 11.x and 12c versions
  • Expert in converting Functional specs to Technical Specs and implementing OBIEE wif Best practices
  • Expertise in implementing Hyperion ESSBASE wif OBIEE.
  • Extensive experience in extraction, transformation and loading of data directly from various data sources like flat files, Excel, SQL Server, Oracle.
  • Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
  • Experienced wif complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations
  • Expertise in creating mappings, mapplets, task and workflows in INFORMATICA wif proper standards of BIAPPS
  • Configuring BIApps, Informatica/DAC to integration of OBIEE wif EBS
  • Extensively worked wif BIAPPS OOB mappings in INFORMATICA and also worked on Customizations
  • Good experience in performance tuning of Reports generated using OBIEE as well as ETL
  • Expertise in designing data model and developing reports in Oracle Hyperion Interactive Reporting.
  • Extensive expertise in designing and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization
  • Experience in ODI Repository, designer, Topology, Operator, packages, scenarios and ODI Tools
  • Worked wif noledge modules like LKM, IKM and CKM.
  • Involved in monitoring teh loads/replication lags and coordinating wif system’s team for any performance issues wif environment.
  • Involved in end-end testing (Unit testing, System testing and Business Users Acceptance testing); have customer face time to hand over reports to enable teh users wif teh no-how on teh reports
  • Conducted Trainings to Train teh Trainer (to train business users on UI) on Architecture, Answers and Reports
  • Ca handle team wif proper spec understand and delivering it professionally wif all standards

TECHNICAL SKILLS

Business Intelligence Tools: Oracle Business Intelligence (OBIEE) 10g/11g/12c, BI Publisher, OBIA 7.9.6.x, Informatica 9.x, Tableau, Hyperion Interactive Reporting Studio, Microsoft Power BI

Operating Systems: Windows Family, Linux

Languages: SQL, PL/SQL, C, Scala

RDBMS: Oracle 9i/10g/11g/12c, MS SQL Server 2000/2005

Migration Tools: Winscp, Putty

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior BI Consultant

Responsibilities:

  • Participated in gathering and analyzing teh Business Requirements in collaboration wif teh Sales, Marketing and Service Business Analysts and Users.
  • Worked under Agile Methodology, delivering reports in each sprint
  • Developed and customized teh Oracle BIEE Metadata repository (.rpd) model by creating connection pools, physical / Alias Tables, defined joins and implemented authorizations in teh physical layer, aggregates, dimensions, hierarchies & time series functions in teh BMM Layer, catalogs & folders in Presentation Layer using Oracle BI Administration tool.
  • Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors, catering to provide insight into teh Sales / Marketing / Financial data.
  • Created BI publisher reports and templates wif output as (Excel, HTML, PDF format)
  • Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
  • Generated Adhoc Statements as per teh business user requirements into Production.
  • Debug teh OBIEE issues by checking logs
  • Implemented security by creating users & web groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associating catalog objects and Web modules wif teh created groups.
  • Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, Oracle materialized views and making changes to reports.
  • Code migration in different OBIEE environments like Dev, UAT and PROD.
  • Implemented Usage tracking reports which read statistics from teh usage tracking database. These reports halped identify performance bottlenecks for further tuning.
  • Experience in performance tuning at teh Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
  • Experienced in configuring ETL metadata, including Informatica Source Analyser, Designer, Mapplets, mappings, and workflows
  • Developed standard and reusable Informatica mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.

Environment: OBIEE 11G/12c, Informatica9.x, Oracle 11g/12c, Linux

Confidential, Milpitas, CA

BI Lead

Responsibilities:

  • Worked wif Business Groups to identify, analyze, and document Business Requirements.
  • Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close teh GAP.
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in teh preparation of Technical Design Documents.
  • Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
  • Migrated Analytics RPD and Webcat from one environment to another.
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security at teh repository level, Catalog level & teh Application level.
  • Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
  • Developed Ad-hoc and standard Reports/Dashboards wif different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular wif prompts, global and local Filters), contextual navigation, business rules wif user identity and roles wifin teh OBIEE suite.
  • Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
  • Customized Dashboard pages like Overview, AP Balance, Payments Due, TEMPEffectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
  • Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
  • Experience in performance tuning at teh Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
  • Created BI publisher reports and templates wif output as (Excel, HTML, PDF format)
  • Customized prebuilt Informatica SDE Mapping and SIL Mappings based on Client Requirements.
  • Developed new mappings in Informatica for custom modules CAPEX, OPEX and BBB.
  • Extended source columns are populated to OBIEE by using Informatica customized mappings

Environment: BIApps 7964, OBIEE 11G, EBSR12.1.3, Informatica9.x, Oracle 11g/12c, Linux

Confidential

Senior BI Consultant

Responsibilities:

  • Implementing HR Analytics OOTB reports and customization.
  • Worked wif Business Groups to identify, analyze, and document Business Requirements.
  • Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close teh GAP.
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in teh preparation of Technical Design Documents.
  • Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
  • Migrated Analytics RPD and Webcat from one environment to another.
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security at teh repository level, Catalog level & teh Application level.
  • Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
  • Developed Ad-hoc and standard Reports/Dashboards wif different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular wif prompts, global and local Filters), contextual navigation, business rules wif user identity and roles wifin teh OBIEE suite.
  • Customized prebuilt Informatica SDE Mapping and SIL Mappings based on Client Requirements.

Environment: BIApps 7964, OBIEE 11G, Peoplesoft 9.x, Informatica9.x, Oracle 11g, Linux

Confidential

Senior BI Consultant

Responsibilities:

  • Worked wif IT Business Analyst teams to gather and analyze business reporting requirements from end users and translate them into reporting designs
  • Worked on OBI Answers, OBI Dashboards, OBI Delivers and configuring Interactive Dashboards wif drill-down capabilities and using Dashboard and Page Level Prompts and Filters
  • Worked on hierarchies, level based measures and time series calculations in teh repository (RPD)
  • Worked on Configuring repository on all teh three layers (Physical Layer, Business Model and Mapping Layer and Presentation Layer)
  • Troubleshoot OBIEE and Data Warehouse application and system issues
  • Design and develop Data Warehouse schemas using ETL tools including Informatica
  • Assist in managing teh OBIEE Admin Tool, Catalog Manager
  • Prepare detailed design documentation and program specifications from which systems are developed and coded
  • Support project personnel, management and end users in resolving complex program and business issues
  • Coordinated wif multiple teams during implementation and transition phases
  • Develop and execute plans for deploying teh applications into production environment
  • Facilitated noledge transfer sessions for new team members

Environment: OBIEE 11g, Informatica 9.x, Windows server 2008, SQL Server 2008.

Confidential

Senior BI Developer

Responsibilities:

  • Extract teh data from source system oracle EBS and load data by using Informatica, DAC and finally develop teh reports by OBIEE.
  • Installation of OBI-APPS (OBIEE, Informatica, DAC)
  • Configuration of OBI-APPS in Informatica and DAC
  • Worked in Full and Incremental data loads and fixed teh issues during data load
  • Developing Source Dependent Extract (SDE) and Source Independent Loading (SIL) mappings as per Technical Design. By customizing teh Siebel vanilla mappings.
  • Involved in monitoring teh Dailey & weekly incremental loads through DAC (Data Warehousing Application Console).
  • Installed OBIEE 11.1.1.5 and OBI Apps 7.9.6.3 in POC Server.
  • Configured and Deployed BI Apps RPD and Web catalog.
  • Worked on Security Implementation using LDAP Authentication and External Table Authorization.
  • Imported Apps pre-defined users and Application Roles through Admin console.
  • Involved in modelling RPD.
  • Preparing Low Level Design document for RPD, Reports and Dashboards
  • Worked on Interactive Dashboards and Pages.

Environment: OBIEE 11g, Informatica 9.x, BI Apps 7.9.6.3, DAC, Linux, Oracle 10g/11g.

Confidential

Senior BI Developer

Responsibilities:

  • Installed OBIEE 11.1.1.5 tool in DEV, SIT and UAT servers.
  • Deploying RPD through Enterprise Manager and Managing Web Catalog Migration across DEV, SIT and UAT Environments through Catalog Manager.
  • Worked on Security using LDAP and External Table Authentication.
  • Preparing Low Level Design document for RPD, Reports and Dashboards
  • Worked on Interactive Dashboards and Pages.
  • Developing Reports and Dashboards for different Confidential Departments.
  • Created Dynamic Session variables to handle Data filters.
  • Created session initialization blocks to provide row- level (data level) security and used teh session variable in OBIEE answers to build teh query.
  • Developed SQL queries for data level validation of reports.
  • Creating and Executing Functional Test Cases for verifying teh functionalities of teh reports.
  • Creating and Scheduling Agents.

Environment: OBIEE 11g, Informatica 9.x, Windows 2008, Oracle 10g/11g.

Confidential

BI Developer

Responsibilities:

  • Interacting wif Client for requirement gathering, status and update meetings.
  • Daily monitoring all teh Reports published in teh Dashboards.
  • Understanding High Level Design (HLD) and Detail Level Design (Low Level Design)
  • Maintained TEMPeffectiveness in creating teh dashboards by appropriately including guided navigational links and drilldowns. Setup teh visibility of dashboards to employees wif respect to their responsibilities.
  • Implemented Prompts to provide dynamic filter condition to End users.
  • Providing object level security for different web groups based on responsibilities.

Environment: OBIEE 10.1.3.3 Oracle 10g

Inchcape, DjiboutiOct 2006 - Mar 2010

Software Developer

  • Worked wif DDL, DML Commands.
  • Created Stored Procedures to perform insert, delete and update operations.
  • Worked wif views, indexes and User Defined Functions.
  • Understanding teh FRD, Source Data, Identifying Entities, Attributes and Measures.
  • Imported Dimensions and Facts into Physical Layer, Created teh Logical Model in teh BMM (Business Model and Mapping) Layer.
  • Created multiple drill down to support various business requirements andUser friendly Subject Areas in Presentation Layer.
  • Developed OBIEE Dashboards wif Dashboard Prompts, Answers.
  • Set up Users, Groups, access privileges and query privileges. Designed role-base Dashboards for managers and Business heads to review figures across regions, products wif teh family to drill down to individual customer relationship manager or customer support agents.

Environment: OBIEE 10.1.3.3 Oracle 10g, Windows 2000 Server

Hire Now