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

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

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

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

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

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 .