PERSONAL SUMMARY:

To obtain a more challenging, OBIEE Developer career opportunity. Fully utilize my experience and background with my Certified OBIEE Developer with 6 years of software development experience in the Information Technology, specifically in OBIEE 11g/12c, BI Publisher, and other reporting tools. Experienced in providing end - to-end business intelligence solutions by configuring metadata, Analysis/Answers, creating reports / Dashboards, cache monitor, and building Repository using OBIEE 11g/ 12c.Problem solver, detail-oriented, decision maker capable of working in a team or independently.

PROFESSIONAL SUMMARY:

• Plus 6 years of experience in Oracle Business Intelligence Enterprise Edition (OBIEE).
• Excellent understanding of Software Development Life Cycle (SDLC) and applications.
• Emphasis on understanding business process & gathering requirements through research, formal-informal sessions with business users and technical groups.
• Experience in Installing, upgrading, and configuring business intelligence and OBIEE 11g & 12c.
• Proven experience in Oracle Business Intelligence (OBIEE 11g/12c) for creating Business Data Models, Dashboards & Interactive Reports, KPI & Scorecard and BI Publisher.
• Experience in designing and constructing the OBIEE Metadata 11g/12c.
• Experience in BI Fusion Middleware, BI Analytics & BI Publisher.
• Involved in data modeling using concepts like Dimensional Data Modeling, Star Schema modeling etc.
• 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.
• 21 years overall on Information TECHNOLOGY
• Fluently speak and write English and French.

TECHNICAL SKILLS:

Business Intelligence tools: Oracle DBMS, OBIEE 11g & 12c

Data Management: Oracle 11g/12c, Hyperion Financial, SharePoint

Data Modeling tool: BI Publisher, Tableau 10.2

Data Integration / ETL tools: Informatica 9.6.1, Oracle Data Integrator (ODI) 12c

Programming Languages: SQL, PostgreSQL, Microsoft SQL Server

Microsoft Office: Word, Power point, Excel, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Fredericksburg, VA

OBIEE Developer

Responsibilities:

• Developed metadata repository using OBIEE 12c Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Create connection pool properties to integrate data into the physical layer to model it into the RPD.
• Create Alias table in the physical layer to maintain entity integrity in dimension table in the database.
• Create logical columns, dimensional hierarchies, calculated measures in the BMM layer as per business requirements.
• Build Hierarchy between similar (parent-child) and data sets (level based) in the BMM layer and defined level-based hierarchy at the lowest granularity level.
• Define time series functions using facts column as AGO, TO DATE & PERIODROLLING for analysis efficiency.
• Conducting relevant research, data analysis, and creating reports and dashboards with different views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local filters).
• Designing and developing reporting semantic layers (OBIEE Metadata Repository) by importing metadata from a database and applying multidimensional data modeling techniques ( star and snowflake schemas) for enhanced reporting efficiency.
• Defined the Primary, Foreign Keys and Created simple and complex joins between various Dimensions and Fact Tables.
• Set cache mechanism strategy for query optimization and performance tuning.
• Use ibots to schedule jobs to be delivered based on preset criteria.

Confidential, Silver Spring, MD

OBIEE Developer

Responsibilities:

• Create new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Develop Time Series Objects using Ago and ToDate functions for time series comparisons.
• Validating business data models by performing consistency check, validating logical tables’ structures, and validating repository level calculation done in the business model layer.
• Implementing Time comparison and calculation measures in the business models using Time Series Wizard.
• Using repository session variables and initialization blocks for configuring the data and users security.
• Configured OBIEE 11g Agents/Alerts to deliver Analytics content based on schedule, automated Alert queries to obtain daily and weekly reports.
• Install, upgrade, and configure business intelligence, OBIEE 11g, Informatica 9.4.1 server and client.

Confidential, Herndon, VA

OBIEE Developer

Responsibilities:

• Collaborated with business users and IT staff throughout the requirements gathering, design, development, testing,, implementation, and monitoring of BI systems and technology (OBIEE 11g ).
• Created repository and session variables .
• Worked with LOB partners on multiple occasions to create requirements for OBIEE reporting solutions.
• Create security settings, set up groups, access privileges and query privileges and also managed security for groups in Answers with OBIEE Administration Tool.
• BI Publisher to build reports in word, excel and doc format in OBIEE 11g .
• Create various templates, reports, and prompts in BI Publisher.
• Develop test cases and performed Unit Testing and Integration Testing of the Repository.