SUMMARY:

• Dynamic professional with experience in Data Analytics and Oracle Business Intelligence reporting stack. Currently seeking a position as an OBIEE developer/consultant in an organization, where analytical, technical efficiency and commitment will contribute towards the organizational goals as well as Professional growth.
• Fast learner with excellent oral and written communication skills with an unending appetite to learn and adopt new technologies for business and professional growth. Finished an 8 month project in less than 6 months and converted 200 legacy reports to 20 OBIEE Analysis and Dashboards. Result Oriented
• Emphasis on understanding business process & gathering requirements through research, formal - informal sessions with business users and technical groups using waterfall methodologies.
• Liaison between business user and IT delivery team for effective transfer of technical and non-technical communications.
• Experience in Installing, upgrading, and configuring business intelligence and OBIEE 11g &12c
• Proven experience in Oracle Business Intelligence (OBIEE) for creating Business Data Models, Dashboards & Interactive Reports, KPI & Scorecard.
• Experience creating reports and pdf customized forms using BI publisher.
• Data warehousing methodologies from data marts creations to Datawarehouse modifications.
• Experience in designing and constructing the OBIEE Repository using the Semantic Model.
• Experience using Informatica Power center repository tools
• Workflow Monitor, Workflow Manager & Designer
• Monitor daily weekly and monthly scheduled workflow
• Design ETL Mappings from source to target using various transformations based on requirement.
• Active and Passive ETL transformations from source to target.
• Workflow Sessions (Reusable and Non-reusable). User defined parameters in UNIX/LINUX Environment for truncate or bulk load operations.
• Create new table in the DB using SP to create a source and target table within the database.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

OBIEE Developer | BI Publisher

• Design and develop front end dashboards to manage and support multiple LOBs within Middle Market Banking Products
• Identify critical reports and dashboards with high query count using usage tracking reports to identify critical and the most impacted users as per upgrade.
• Edit and troubleshoot BI reports and reformatted views to create more interactivity among data.
• Gather business requirement needs for new dashboard creation and perform and document as is analysis for that specific line of business.
• Create session and repository variables to invoke permission privileges to users
• Use the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
• Extract and Reformat dashboard queries for performance tuning purposes.
• Build bridge tables within the in the rpd to address a series of many to many relationships
• Create BI publisher reports using Pdf templates and add one or more reports to form a dashboard
• Define Repository and Session variables using initialization blocks to control user access.
• Work in MUDE Environment to independently work on a subset of the repository for changes as per user requirements.
• Designing and developing reporting semantic layers (OBIEE Metadata Repository) by importing metadata from a relational database or XML files and applying multidimensional data modeling techniques (OLAP/MOLAP, star and snowflake schemas) for enhanced reporting efficiency.
• Build hierarchy between similar (parent-child) and non-similar data sets (level based) in the BMM layer and defined level-based hierarchy at the lowest granularity level.
• Develop many Reports and Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Analytics.
• Follow Service Request requirement via BRD to deliver scheduled BI publisher reports templates and Data Model.
• Write SQL script used to populate columns presents within tables in the database based on the BRD which will be used in building the data model.
• Generate an RTF template used to save sample XML files used to populate the scheduled report in excel, PDF, text file e.t.c
• Create Pixel perfect reports and use the bursting feature to deliver reports to different users

Confidential, Los Angeles, CA

OBIEE Developer | BI Publisher

• Participate in setting agenda for OBIEE Upgrade with BI reporting, BI Admins, PM to set timelines to follow for the upgrade from OBIEE 11G - 12C
• Act as a liaison for the BI Reporting team in communicating changes and system impact of OBIEE upgrade (11g - 12C) to report and dashboard users.
• Identify critical reports and dashboards with high query count using usage tracking reports to identify critical and the most impacted users as per upgrade.
• Work closely with the BI Admin to identify key report issues and production issues to be resolved before upgrade to allow for a smooth transition between upgrades.
• Create session variables to invoke permission privileges to users
• Use the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
• Define time series functions using facts table column as AGO, TO DATE & Period for analysis efficiency.
• Define Repository and Session variables using initialization blocks to control user access.
• Work in MUDE Environment to independently work on a subset of the repository for changes as per user requirements.
• Designing and developing reporting semantic layers (OBIEE Metadata Repository) by importing metadata from a relational database or XML files and applying multidimensional data modeling techniques (OLAP/MOLAP, star and snowflake schemas) for enhanced reporting efficiency.
• Build hierarchy between similar (parent-child) and non-similar data sets (level based) in the BMM layer and defined level-based hierarchy at the lowest granularity level.
• Develop many Reports and Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Analytics.
• Follow Service Request requirement via BRD to deliver scheduled BI publisher reports templates and Data Model.
• Write SQL script used to populate columns presents within tables in the database based on the BRD which will be used in building the data model.
• Generate an RTF template used to save sample XML files used to populate the scheduled report in excel, PDF, text file e.t.c
• Create Pixel perfect reports and use the bursting feature to deliver reports to different users

Confidential, Atlanta, GA

Junior OBIEE Developer

• Created aliases table in the physical layer, joins and connection pool.
• Created fact table and dimension tables.
• Understood the core relationships between primary keys and foreign in relations to joins.
• Created logical table and logical table source mappings from the physical layer
• Created level-based measures and created measures on the fly.
• Developed level based and parent child hierarchies in the BMM layer of the RPD.
• Core understanding of star and snowflake schemas.
• Constructed bridge tables to extract and merge tables with common columns.
• Migrated the business logic from the BMM layer to the presentation.
• Independently Designed and developed subject areas in the RPD.
• Defined appropriate joins, calculations, dimensions and measures in the repository.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Analytics.
• Configured OBIEE Agents/Alerts to deliver Analytics content based on schedule, automated Alert queries to obtain daily and weekly reports.
• Developed Data Model & Reporting Layouts to build interactive reports in OBIEE Publisher.
• Designed Intelligent Dashboards for different user groups to view updated KPIs using variables.