Bhaskar M.

Bhaskar M.

BI Lead Consultant

Hyderabad , India

Experience: 12 Years

Bhaskar

Hyderabad , India

BI Lead Consultant

36000 USD / Year

  • Immediate: Available

12 Years

Now you can Instantly Chat with Bhaskar!

About Me

  • Working as BI Lead Consultant with good experience in Collecting Analysis, Designing, Developing, Maintaining, Documenting, Testing, Deploying and ..., Maintaining, Documenting, Testing, Deploying and Supporting various business systems.
  • Holding 10 years of IT experience in various Data Warehousing Tools like OBI, Informatica, DAC & Oracle (SQL/PLSQL) Database.
  • Worked Extensively on Oracle BI Administration Tool, Presentation Services, Answers & Interactive Dashboards.
  • Experience in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series Functions and Cache Management.
  • Expertise in implementing Oracle BI  Security like Groups and Data Access, Metadata Objects and Web Catalog Objects like Dashboard, Pages, Folders and Reports
  • Experienced in Deploying of Web Catalog in various Dev/Test environments.
  • Experienced in designing customized Interactive Dashboards in OBI using Drill down, Guided Navigation, Prompts, Filters and Variables.
  • Experienced in using OBI Answers to create Reports, Views & Charts to enhance the user experience.
  • Expertise in Creating and Scheduling iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
  • Expertise in configuring Usage Tracking and Multiuser Development Environment (MUDE).
  • Worked with DBA’s in improving the Performance Tuning in OBI using Cache Management, Aggregate Tables, and Indexes.
  • Expertise in Developing Reports with BI Publisher integrated with OBI.
  • Knowledge in working with ETL Tools such as Informatica Power Center/ Power Mart 8.x/7.x in creating Source/ Target definitions
  • Knowledge in creating Sessions, Workflows, Mappings and Mapplets using various available transformations in Informatica like Router, Aggregator and Lookup.
  • Expertise in DWH and OLAP Technology – Star Schema, Snowflake Schema, Fact and Dimension Tables
  • Motivated the Team to High Standards Analysed the assigned projects and distributed in the team accordingly and offered solutions to the Top Management regarding Project related queries.   
  • Worked in Co-ordination with various stake holders and ensured all tickets get closed as per SLA.
  • Worked closely with Senior Management Team in prioritizing projects for existing and future needs, identifying resources and estimating the effort needed.
  • Possess Good knowledge on Toad & XML Publisher
  • Possess Good Knowledge on Oracle Modules (CRM, HRMS, Financials etc)                                        
  • Possess Good Expertise in BICS and OACS.
  • Have given Corporate Trainings.

Show More

Portfolio Projects

GILEAD

Company

GILEAD

Description

 

Description:

Gilead Sciences, Headquartered and founded in Foster City, California, is an American biotechnology company that researches, develops and commercializes drugs. The company focuses primarily on antiviral drugs used in the treatment of HIV, hepatitis B, hepatitis C, and influenza, including Harvoni and Sovaldi.

 

Responsibilities:

  • Acted as a liaison between business users and BI team to facilitate understanding of business requirements.
  • Implemented security based on LDAP Authentication.
  • Created security settings in OBI Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
  • Interacted with Dev Team, Testing Team on day to day activities on daily basis.
  • Updating the status to Project Manager and keeping the Production Environment up and running.
  • Closely involved with everyone to achieve miles stones and during deliverables.
  • Created Requirements Mapping Document to trace requirements in BI implementation.
  • Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
  • Provided guidance and support to end users during the implementation and in production.
  • Address system failures, incidents, tasks and change requests.
  • User administration such as adding or removing users, modifying group membership or validating user settings.
  • Handling BIAR requests and process on time to give project access and folder for users
  • Subscribing the reports for users mail Id’s and scheduling the reports for user requests
  • Monitoring the narrowcast services and delivering the schedules to user emails on time

Show More Show Less

Skills

Obiee

Ansell

Company

Ansell

Description

  • Created Requirements Mapping Document to trace requirements in BI implementation.
  • Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
  • Implemented security based on LDAP Authentication.
  • Developed metadata repository using OBI Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
  • Created New Logical Columns, Dimensional Hierarchy, Calculated Measures, and aggregate mappings in the BMM layer as per the business requirements.
  • Developed Time Series Objects using Ago and To Date functions for time series comparisons.
  • Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
  • Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
  • Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Provided guidance and support to end users during the implementation and in production

Show More Show Less

Subaru Of America

Company

Subaru Of America

Description

Description:

Subaru Of America is the United States-based distributor of Subaru's brand vehicles, a subsidiary of Fuji Heavy Industries of Japan. The company markets and distributes Subaru Symmetrical All-Wheel Drive vehicles, parts and accessories through a network with approximately 600 dealers throughout the United States

Responsibilities:

  • Worked during the whole life cycle of the project from requirements gathering to deployment.
  • Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
  • Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
  • Implemented security based on LDAP Authentication.
  • Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
  • Created security settings in OBI Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
  • Integrated BI Publisher with OBI to build reports in word, excel and doc format.
  • Created various templates, reports, and prompts in BI Publisher.

 

Show More Show Less

Skills

Obiee

Tools

Excel sheets

POLYCOM

Company

POLYCOM

Description

Description:

Polycom is unarguably the number when it comes to Unified Communication. It is chosen ahead of others for solutions that enable their geographically dispersed workforces to communicate and collaborate more effectively and productively over distances. Using Polycom telepresence, video, and voice solutions and services, people connect and collaborate from their desktops, meeting rooms, class rooms and mobile settings. It is used to gain a fast return on their investment as their teams easily collaborate "face to face" wherever they are & also cut the time, cost, and carbon emissions associated with gathering the right people in one place to solve problems.

Responsibilities:

  • Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
  • Analysed the Reporting Requirements and participated in the documentation of Business Requirements.
  • Developed Oracle BI Metadata repository using BI Administration tool.
  • Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
  • Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
  • Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBI business model & mapping layer.
  • Developed measure for time comparison using time functions, To Date and Ago.
  • Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
  • Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
  • Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
  • Implemented security based on LDAP Authentication.
  • Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
  • Created schedulers and developed iBots to deliver reports and dashboards to the subscribers as per the schedules and alerts.
  • Created report prototypes and presented them to users to get approval.
  • Attended weekly meetings with BA and Stakeholders for project status updates.
  • Performed unit and integration testing of reports and dashboards.

Show More Show Less

Tools

Excel sheets

VERIZON

Company

VERIZON

Description

Description :

Verizon is an American telecommunications company which offers wireless products and services. It is a wholly owned subsidiary of Verizon Communications. Verizon Wireless is the largest wireless telecommunications provider in the United States.

Responsibilities:

  • Preparing the technical specification document for reports.
  • Customized activities as per user requirements
  • Worked on vanilla rpd and modified it according to requirements.
  • Created multiple interactive Dashboards and assigned respective security model.
  • Worked on presentation variables to work on TopN functions.
  • Build Repository at 3 layers Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) & Presentation layer level (create presentation catalogs).
  • Developing multiple Dimensions (Drill-Down Hierarchies) & Measure objects in Business Model Layer.
  • Created logical joins between fact and dimension tables in business model layer

 

Show More Show Less

Skills

Obiee

Tools

Excel sheets
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Conversational

  • Hindi - Basic

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Mountain Daylight [UTC -6]

  • Pacific Daylight [UTC -7]

  • Eastern European [UTC +2]

  • Eastern EST [UTC +3]

  • Greenwich Mean [UTC ±0]

  • Further EET [UTC +3]

  • Australian EDT [UTC +11]

  • Australian CDT [UTC +10:30]

  • Dubai [UTC +4]

  • China (West) [UTC +6]

  • New Delhi [UTC +5]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]