PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

OBIEE Developer

Responsibilities:

• Knowledge in converting legacy reports (originally written in Cognos) to BI Publisher.
• Ensured BI reports met Section 508 (ADA) Compliance Requirements.
• Build report using BI Publisher 11.1.1.9.
• Created Catalogs and report templates for clinical applications.
• Created Oracle BI Data Models using Oracle SQL queries and Parameters.
• Created on creating oracle BI reports using MS word BI Plug - In that included sub-templates.
• Provide a means for users to use the system while supporting the highest level of security and privacy.
• Worked with business community in understanding the functional requirements on how to create OQR/IQR reports.
• Provide users with accurate data from which they can make decisions.
• Provide users with dashboard that is easy to use.
• Attending and participate in daily stand-up meetings.

Confidential, Washington, DC

OBIEE Developer

Responsibilities:

• Worked with different groups in organization to understand their business requirement and give valuable suggestions for reports and dashboards.
• Worked in MUD (Multiple user Development) environment.
• Created Pivot Tables and manipulated Initialization Blocks for report analysis.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling
• Created measures and level Based measures in Business Model.
• Created logical Tables and logical columns, Physical Columns.
• Created measure with Logical Columns and Physical Columns.
• Created Dimension hierarchy in Business model layer.
• Developed Global prompts, Filters, Customized Reports and Dashboards using OBI presentation services.
• Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Extensively used Oracle Delivers and iBots so as to provide alerts.
• Generated various Analytics Reports using global and local filters.
• Involved in LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
• Actively Participated in Team meetings and discussions to propose solutions to problems.
• Implemented data level and object level securities and dashboards.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Knowledge of ETL/data Integration using Oracle Data Integrator(ODI)
• Proficient in the analysis of OLTP System and identification of required dimensions and facts from the Database
• Create and Customize the OBIEE Repository (Physical, Business and Presentation Layer).
• Expert in Cache Management, Repository Migration, creating Connection Pools, imported physical tables and defined joins in the Physical Layer of the Repository.
• Knowledge of data modeling, meta data and user interface
• Ability to work on complex data structures, dashboards and ad hoc reporting
• Self-driven and passionate performer with the yearn to learn new technologies and techniques
• Handle multiple projects at one time and deliver quality work.
• An extrovert with strong command over spoken and written language.

Confidential, Washington, DC

OBIEE Developer

Responsibilities:

• Provide support in the development of OBIEE components and solutions
• Understand project requirements and work towards design and development of the plan layout
• Develop and deploy dashboards, analytics and reports properly
• Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling
• Design and place data in layers varying to physical, business and presentation
• Work with administrators, users and analysts to maintain exchange of reporting requirements
• Use the best practices of business intelligence to meet project and company objective.
• Prepare monthly reports and present it to the management
• Develop, implement and deploy data warehousing and business analytical solutions
• Install, upgrade and configure database solutions through OBIEE tools
• Develop data access queries through Oracle BI tools
• Develop and design dashboards, reports, ad hoc queries and analysis
• Work in collaboration with data analysts, business analysts, other technical teams and business teams.
• Prepare documentation and give project performance feedback to the clients and the senior management.
• Develop and design data modeling concepts using OBIEE tools.
• Identify critical issues and processing faults to optimize BI dashboards and reports
• Perform testing sessions for reports and dashboards and resolve process issues
• Interact with the client and end user to collect the list of requirements
• Prepare project layout and provide technical guidance to the development team
• Install and configure OBIEE tools across multiple tools and versions
• Develop data across layers - physical, business models and mapping
• Develop and design data modeling concepts using OBIEE tools