We provide IT Staff Augmentation Services!

Bi Consultant (obiee) Resume

EXPERIENCE SUMMARY:

  • IT Professional with nearly 2.6 Years of experience in Bussiness Intelligence(OBIA and BIP), Enterprise resourece planning Application & Oracle Data Intergrator .
  • Proficient with the Business Intelligence techniques and its applications.
  • Proficient in OBIA (Analytics/ Answers)
  • Proficient in development of Dashboard and analysis in OBIA
  • Proficient in BI Publisher and OBIEE.
  • Migration of OBIEE 10g to OBIEE 11g
  • Created connection pools, schemas in Physical layer of the repository.
  • Worked with OBIA rpd, making use of the existing physical/logical objects, creating reports based on pre - built rpd.
  • Created major and important dashboards like Customer Profitability from the scratch including
  • Proficient with Oracle Data Integrator (ODI 11g).
  • Develop M11 and M12 (finance Report) Report with the help of OBIEE which play big role in finance reporting.
  • Configure OBIEE 11g RPD including data sources (physical, local and presentation layer) In charge of creating predefined reports and dashboards for different user profile.
  • Ability to configure variables and security Ability to do performance tuning in RPD
  • Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports)
  • Experience of working crystal reports.
  • Excellent in Analyzing the Database Tables Used for Crystal Report .
  • Excellent knowledge of Oracle11g environment with expertise in Stored Procedures, Packages using SQL and PL/SQL.
  • Excellent ability to develop complex reports using custom sqls, use of unions, creating subquery sections etc .
  • Extensive working Experience in XML Reports and Workflows.
  • Experience of working onsite ( Confidential, Noida) in BI
  • Experience of working onsite ( Confidential, Delhi) in BI
  • Familiar with the common business practices and performance standards
  • Effective communication skills that help deliver clear instructions
  • Skilled at striking right balance between the needs and available resources
  • Ability to work in fast paced and stressful environment

PROFICIENCY:

Tools: SQL Developer, Toad, PL/SQL Developer

Reporting Tool: OBIEE 11g, OBIEE 10g, OBIA, ODI 11g, Business Intelligence Publisher (BIP), SBO eCube, SAP B1, XML Publisher, Siebel analytics .

Languages: PL/SQL and SQL

RDBMS: Oracle 10/11g, SQL R12, SQL server 2008

Operating Systems: Windows 98/ XP/ 2000/ 2003/Vista

PROFESSIONAL EXPERIENCE:

Confidential

BI Consultant (OBIEE)

Responsibilities:

  • Customized Purchase Orders, GL, Account Receivables, Account Payables, Inventory reports using OBIEE 11g.
  • Develop all the template of proposal report in RTF format.
  • Develop Top sheet report for the MAGMA which play a very important role in credit and opps module
  • Develop and maintain BI related all documents.
  • Provide BI user on tool usage and reporting.
  • Analyze, plan, develop and configure architecture solutions are commensurate to business requirement
  • Requriedment gathering from business user
  • Maintain reporting system and business intelligence solutions.
  • Translated Business requirements into technical requirements.
  • Designed and developed complicated/complex reports.
  • Followed best practices to make sure there was good performance.

Confidential

Technical Consultant (OBIEE)

Responsibilities:

  • Requriedment gathering from business user
  • Maintain reporting system and business intelligence solutions.
  • Develop all the template of proposal report in RTF format.
  • Develop Proposal Report For Confidential
  • Develop and maintain BI related all documents.
  • Provide BI user on tool usage and reporting.
  • Analyze, plan, develop and configure architecture solutions are commensurate to business requirement

Confidential

Software Developer

Responsibilities:

  • Migration of OBIA 10g to OBIA 11g .
  • Configure all the connection pools in BI administrator.
  • Migarte the RPD from OBIEE 10g to OBIEE 11g on BI administrator tool.
  • Created connection pools, schemas in Physical layer of the repository.
  • Worked with OBIA rpd, making use of the existing physical/logical objects, creating reports based on pre- built rpd.
  • Created Dashboard prompts and advanced filter criteria.
  • Created new connection pools for different data sources and designed from the scratch (physical, business model and presentation).
  • Customized reports from BI Apps (OOB-prebuilt) seeded reports.
  • Has enabled cache to improve performance of the reports
  • Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
  • Migrate all the reports from OBIEE 10g to OBIEE 11g.
  • Migartion of all the Dashboard from OBIEE 10g to OBIEE 11g.
  • Migarte all the users and their role .
  • Develop M11 and M12 report on OBIEE 11g .
  • Develop and maintain BI related all documents.
  • Provide BI user on tool usage and reporting.
  • Analyze, plan, develop and configure architecture solutions are commensurate to business requirement
  • Maintain reporting system and business intelligence solutions.

Confidential

Software Developer

Responsibilities:

  • Maintain reporting system and business intelligence solutions.
  • Develop Order Summary Report For Sudhir which play big role to start there ERP journey
  • Developed the top priority reports like Monthly Net Sales, Customer Profitability, Funds Details, order Summary.
  • Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.
  • Develop and maintain BI related all documents.
  • Provide BI user on tool usage and reporting.
  • Analyze, plan, develop and configure architecture solutions are commensurate to business requirement
  • Provide BI user on tool usage and reporting.
  • Analyze, plan, develop and configure architecture solutions are commensurate to business requirement
  • Maintain reporting system and business intelligence solutions.

Confidential

Software Developer

Responsibilities:

  • Support the organization to manage their functions and business data in a systematic and easy-to-understand manner.
  • Reports were Develop for Production department
  • Develop reports in PL/SQL Server Reporting Services
  • Assist the organization in analyzing the compiled data and sorting the requisite information from the complete data
  • Guide the organization in inculcating business software and streamlining the present flow of work
  • Extensively used Variables (repository and presentation) in the process of making the reports.
  • Implement cache management for repository, Dash board level security
  • Creating the Dashboard and Report level prompts.

Confidential

Software Developer

Responsibilities:

  • Responsible to provide suitable technical solutions to business requirements and facilitate quick and smooth functions.
  • Publish crystal reports on SBOeCube BI.
  • Excellent in Analyzing the Database Tables Used for Crystal Report .
  • Excellent Knowledge in Creating Crystal Reports & adding to SAP B1 Menu .
  • Responsible for creating and modifying crystal reports.
  • Reports were developed using SQL Developer
  • Provide BI user on tool usage and reporting.
  • Analyze, plan, develop and configure architecture solutions are commensurate to business requirement
  • Maintain reporting system and business intelligence solutions.
  • Publish store procedures in SBOeCube BI
  • Building Dashboards for Higher Management .

Hire Now