SUMMARY
- 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 (UFLEX,Noida) in BI
- Experience of working onsite (C.I InfoTech, 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
TECHNICAL SKILLS
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
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 training 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
BI Consultant
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 Spectranet
- Develop and maintain BI related all documents.
- Provide BI user training on tool usage and reporting.
- Analyze, plan, develop and configure architecture solutions are commensurate to business requirement
Confidential
BI Consultant
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 training on tool usage and reporting.
- Analyze, plan, develop and configure architecture solutions are commensurate to business requirement
- Maintain reporting system and business intelligence solutions.