PROFESSIONAL SUMMARY:

• 8 years of hands-on experience in Design, Development and Implementation of state of the art Data warehouse applications.
• Extensive experience in providing end-to-end business intelligence solution by configuring Metadata building Analytics Repository, Dimensional Modeling, building business models, generating Reports, and creating Interactive Business Intelligence Dashboards using OBIEE 10g/11g
• Experience in administering permissions, privileges to users based on their groups and responsibilities
• Implemented the new 11g Security architecture using Weblogic Administration console and Oracle Enterprise Manager Fusion Middleware Control
• Expertise in customizing default OBIEE dashboard presentations
• Expertise in configuration and integration of BI publisher with BI Answers and render the same via BI Dashboards
• Expertise in creating Business Requirement Documents BRD and Functional Design Documents FDD
• Actively involved in recruiting process and also trained resources for OBIEE skillset
• Conceptualized Sandwich Layer Model, one of its new kind to integrate external content in OBIEE
• Experienced in Architecting and Designing OBIEE projects
• Conceptualized a statistical tool in OBIEE and same got recognized in PARASPARAM 2011 Highest technical recognition event in HP INDIA
• ICON AWARD winner for the year 2009 under Creative Category in Scope International Pvt Ltd..
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs

TECHNICAL SKILLS:

Roles and Responsibilities:

• Interact with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.
• Provided extensive BI solution, which enhanced decision making
• Coordinating changes and testing with business users and other IT groups
• Identifying system deficiencies and recommending solutions
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and the presentation layer of the repository
• Extensively used OBIEE 11g's new feature Request Variable
• Developed different kinds of Reports Pivots, View Selectors, Column Selectors, and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts

Environment: OBIEE 11.1.1.7, Oracle 11g, Windows 2003 server, Unix

Confidential

Role : Senior OBIEE Developer

Roles and Responsibilities:

• Analyzing Cognos Business Reports and transform the gaps into business requirements and implementing the same in OBIEE
• Collaborate with clients and data owners to successfully implement and maintain an enterprise level Business Analytics and Data Warehousing Solution
• Worked closely with the Business Planning team in understanding the Analytics Requirements and created Business Requirement Documents BRDs
• Performed data modeling tasks to identify and create facts and dimension tables.
• Conducted Architecture analysis of requirements and Design Walk-throughs with the designers, developers and management staff
• Designed and customized the OBIEE repository three layers physical, BMM, and presentation layer based on the customer requirements
• Developed and supported the creation of new Adhoc Answers requests and Dashboards in OBIEE
• Implemented the Star Schema, Snowflake Schema models as per the project requirements

• Design and development of various charts, graphs, table, pivot table views as part of Web catalog development.

Environment: OBIEE 11.1.1.7, BI Publisher, Oracle 11g,SQL Developer, Windows 2003 server, Unix

Confidential

Role : Lead OBIEE Developer

Roles and Responsibilities:

• Deployment of complete OBIEE solution from setting up the environment to the deployment of Dashboards
• Eliciting and documenting customer business requirements
• Guiding other consultants and client personnel on best-practice techniques
• Communicating technical solutions to client and consulting staff in a clear and concise manner
• Customized OBIEE default presentation views based on customer requirements
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and the presentation layer of the repository based on the customer requirements
• Merging Repositories by using Multi User Development of Repositories MUD
• Involved in creating Style sheets for the Report Catalog
• Managed a 4 member team and guided and trained the team for development related task based on the business requirement

Environment: OBIEE 11.1.1.6, Oracle 11g, Toad, Windows 2003 server, Unix

Confidential

Role : OBIEE Developer

Roles and Responsibilities:

• Requirements gathering and interaction with the client SME's to draft business requirements
• Responsible for converting business requirements into Functional and technical requirements
• Design Data model for Repository development
• Responsible for Administration of Oracle BI Publisher
• OBIEE server, web administration Customized analytics web user interface
• Design users groups and maintain authentication of user groups
• Responsible for formulating the OBIEE development standards, best practices and guidelines
• Design and development of various charts, graphs, table, pivot table views as part of Web catalog development
• Design and Development of RPD and Security as part of RPD Development

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle 10g, Toad, Windows 2000 server, Unix

Confidential

Role : OBIEE Developer

Roles and Responsibilities:

• Involved in research activities for creating the Graphical Charts for out of the box scenarios
• Designing and Development of RPD and Web Catalog

Environment: OBIEE 10.1.3.3, Oracle 10g, Windows 2000 server

Confidential

Role : BI Developer

Roles and Responsibilities:

• Coordination with the business users in gathering and analyzing the reporting requirements
• Design and Development of RPD BMM layer logical tables, columns, dimension hierarchies, security as part of RPD Development
• Responsible for creation of measures and level Based measures in Business Model
• Configuration and development of the Oracle BI Reports as per the business rules and requirements which includes development of various types of report formats i.e. tables, various types of charts, pivot tables, narratives.
• Responsible for New Id creation, Account modification of existing users, Password reset and Deletion of accounts

• Developed reports/dashboards Analytic views Pivot Tables, Charts, Column Selector, and View Selector

Environment: OBIEE 10.1.3.3, Oracle 10g, SQL Server 2000, Toad, Windows Server 2003