Experienced developer with diverse industry experience in banking, healthcare, insurance and government. Professional expertise includes systems applications, disaster recovery planning and information protection analysis. OBIEE Developer well-versed in structuring, developing and implementing interactive solutions. Core Qualifications Certified Oracle Business Intelligence Well versed with Data Enterprise Edition(OBIEE) 11g Expert Modelling(Dimensional and Relational) Understands Structured query language concepts (SQL) Experience in Data Analysis, Strong analytical skills Dimensional modelling and Level Based Metrics Excellent problem solving skills Warehouse Data -level and Object level security Implementing metadata layers MUDE, Variables/Initialization Blocks Extensive experience in OBIEE Experienced in RPD and Catalog Presentation Services migration BI Publisher expert Business Model development expert Excellent aptitude in interpreting business requirement into logical business dimensional models
Certified Oracle Business Intelligence Developer 5+ Foundation Suite 11g Specialist |
SQL, HTML, XML, Oracle 11g, MUDE, |
Excellent technical knowledge in OBIEE
Created and populated the Repository with data from the database.
Well versed with the Physical Layer, BMM Layer and Presentation Layer
Developed reports, and interactive dashboards with drill-down capabilities using BI Answers.
Used rename wizard to rename tables
Fine-tuned the BI Presentation interface to meet user demands
Ability to designing the Repository, import tables, make aliases, dimensional hierarchies, define keys, define fact table aggregation, level based measures, multiple source tables.
Performance tuning using SQL Developer, Toad, and NQSConfig.ini file and cache at system and table level.
Used BI Answers to run queries
Integrated Bi publisher and OBIEE to build reports in excel and doc format.
Defined security in WebLogic console.
Created prompts, action links and agents in BI Answers
Created Level Based metrics, defined aggregates on logical columns in the RPD and BI Answers
Knowledge of the system development life cycle from initiation to post implementation support
Ability to work alone and under pressure
Excellent communication skills
Built star and snowflake schemas in the repository. In the BMM- Created logical tables, whole diagrams using complex joins, dimensional modelling design and building business models. Defined drill-down time series and other dimension hierarchies. Environment: OBIEE11g, Reports, Dashboards, BI Analytics, SQL, MUDE, HTML, XML.
Create reports using OBIEE Answers and empowered users to navigate OBIEE Dashboards. Create d Pivot tables allowing managers to analyze the business from different perspectives and in an orderly summarized manner. Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local filters. Developed Reports and Dashboards with different Analytic views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local filters using Oracle BI Presentation Services. Integrated BI Publisher with OBIEE to build reports in word, excel, and doc format. Developer templates and reports in Oracle BI Publisher in rtf format. Met with business representatives, business analysts, and end users to understand the business models and functionality. Gathered Business requirements, interacted with the business users, defined subject areas for analytical data requirements. Perfomed administrative tasks related to the development and configuration of Interactive Dashboards. Created agents for job-critical levels and audit-able differences delivered to dashboards, email, and cell phones to assist process onwers with timely decision making. Helped create connection pools, imported physical tables and defined joins in the physical layer of the repository. Assisted with Building the Physical, Business Model and Mapping and Presentation Layer of the repository. Created dimension hierarchies and level based measures, built time and calculated measures of a fact table. Used the rename wizard to rename fields and tables. Modified Presentation Layer to add presentation tables and columns to meet the business user needs. Created repository and session variables. Created groups and added users to the groups and granted priviledges. Worked in a Multi User Development Environment (MUDE) to check out repository, make changes, and complete merge process. Customized the Oracle BI Presentation Services user interface. Customized and developed OBIEE Analytics Reports and integrated them in dashboards. Used BI analytics to run queries, test, and reports and validated the repository. Performance tuning experience included modeling aggregate tables to speed query processing and partitions and fragments to improve application performance, usability and caching. Enhanced performance tuning using the SQL developer. Participated in designing, coordination and execution of User Acceptance Testing (UAT) with QA, BA and selected business users. Tested and modified OBIEE security for the internal controls environment. Environment: OBIEE 11g, Reports, Dashboards, BI Analytics, SQL, MUDE, HTML, XML. Developed Interactive dashboards with drill-down capabilities and dynamic dashboard prompts to zoom into particular segments of the business. Used Filters and provided customized prompts to appropriately avoid excessive data showing up on reports. Created reports using OBIEE Answers and empowered users to navigate OBIEE Dashboards. Created various templates, reports, and prompts in BI Publisher. Creatively used OBIEE to set up conditional formatting to develop pricing models. Created agents to send pre-processed reports. Created group level security for intelligence dashboards and assigned users to groups based on Business Requirements. Assisted in developing Metadata Repository. Used Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements Used Rename Wizard to rename fields and tables. Created repository and session variables. Met with Business representatives, Buseness analysts and end users too understand the business models and functionality. Customized the OBIEE repository (Physical, BMM, and Presentation layers). Built star and snowflake schemas in the repository. In the BMM- Created logical tables, whole diagrams using complex joins, dimensional modelling design and building business models. Defined drill-down time series and other dimension hierarchies. Environment: OBIEE11g, Reports, Dashboards, BI Analytics, SQL, MUDE, HTML, XML.
Oracle Foundation Suite 11g Specialist
Bi, Business Intelligence, Business Requirements, Html, Publisher, Security, Sql, Xml, Acceptance Testing, Administrative Tasks, Application Performance, Audit, Excel, Fact, Fact Erp, Internal Controls, Mapping, Oracle, Oracle Bi Publisher, Oracle Business Intelligence Publisher, Performance Tuning, Pivot Tables, Qa, Testing, Topo, Uat, Usability, User Acceptance, User Acceptance Testing, User Interface, Word, Metadata, Pricing, Pricing Models, Data Analysis, Disaster Recovery, Disaster Recovery Planning, Healthcare, Marketing Analysis, Problem Solving, Recovery Planning, Solutions, Biostatistics, Laboratory Medicine
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
resume Strength
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy