We provide IT Staff Augmentation Services!

Oracle Business Intelligence Developer Resume

2.00/5 (Submit Your Rating)

offering the following qualifications

  • Over 6 years of accomplished experience in the field of information technology.
  • 3+ years of experience in Oracle Business Intelligence Applications including-analysis, design, development, configuration, customization, and deployment in the areas of Sales and Marketing.
  • Experience with repository development (.rpd), configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, and Reports)
  • Strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), Analytics Metadata objects configuration experience (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Experience with complete Lifecycle (gathering Business Users Requirements, Analysis, Design & Modeling, Development and Testing) of Business Intelligence, plus Conference Room Pilots
  • Communicates with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data
  • Proficient in Data Analysis, Gap Analysis, Identification of dimensions, Facts & aggregate tables, Measures and Hierarchies.
  • Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, and Reports) using OBIEE Admin Tool.
  • Experience in Installation, Configuration, and Administration of Oracle BI, OBIEE 10g standalone
  • Experience training end users in accessing, and building dashboard reports
  • Ability to transform raw data into actionable information
  • Proven ability to work collaboratively in a team environment
  • Strong verbal and written communication skills

OBIEE Stand Alone

  • Experience in building and deploying an OBI repository (Physical, Business and presentation model) to create Dashboards, answers, and iBots
  • Proficient in using the time-series functions to support historical time comparison analysis
  • Creating requests, adding filters, creating prompts, and creating pivot tables using OBI
  • Experience in setting up a Multi-User Development Environment
  • Skilled in adding disparate sources to business model objects
  • Experience in modeling aggregate tables to speed processing
  • Creating dimension hierarchies and level-based measures

TECHNICAL SKILLS:

  • Reporting Tools: OBIEE 10.1.3.3 & 10.1.3.4, and BI Publisher
  • Language: SQL
  • Database: Oracle 10g (familiar with oracle 11g)
  • Platform: Windows XP/Vista, 2003 and windows 7
  • Oracle BI: Web, Dashboards, Delivers, iBots

Professional Experience

Confidential,TX Dec 2010 –Present
Oracle Business Intelligence Developer

  • Worked closely with Business Analysts in understanding the analytics requirements and created the business model for generating reports per the business requirements.
  • Involved in meetings/interviews with users, data analysts, and examined the business, functional and technical requirement documentation
  • Participated in laying out a strategy with senior management and technical team for building the metadata that presents the business model to support the business requirements.
  • Developed Metadata repository (.rpd), configured Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements using OBIEE Analytics Admin and Web tool
  • Modeling activities including building star schemas and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer. Established the logical joins/keys required to support drill-down aggregation.
  • Designed and Configured Dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager.
  • Set up security to authenticate users and assign appropriate permissions and privileges.
  • Created dimension hierarchies and assigned levels for each level.
  • Responsible for Unit and System Testing and Performed Data Validation for all the reports that are generated from OBIEE.
  • Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues and to analyze the financial service center statistics for different campaigns, Customized pre-built dashboards.
  • Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
  • Configured the NQSCONFIG.INI file for Usage Tracking using direct insertion
  • Developed custom reports/Ad-hoc queries using OBI Answers and Filters.

Confidential,Irving, TX Jul 2009 –Nov 2010
Oracle Business Intelligence Developer

  • Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in BI Analytics Administration Tool
  • Participated in complete life cycle of the project from Project Initiation, Development and Maintenance
  • OBIEE configurations: Multi User Development (MUD), Usage tracking, iBot(scheduling) and security modeling
  • Analysis, Design, Implementation, documentations and BI specifications that incorporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse
  • Develop and implementation of OBIEE user interface objects such as queries, reports, and dashboards
  • Design, Analysis, Implementation and documentation of various projects for reporting aspect i.e. OBIEE metadata/logical/physical data models
  • Gathered functional business requirements to the design and development of the Oracle BI solution and its components
  • Developed Physical layer ,Business Model and Mapping Layer, and Presentation Layer of OBIEE
  • Customized reporting with OBIEE Answers and integrated them into the Dashboards
  • Assisted in performance tuning for various OBIEE Reports/Dashboard
  • Developed reports using features like tables, charts, and pivot tables
  • Supported the iBots scheduled reports
  • Assumed various roles –OBIEE Developer/Administrator worked
  • This involved multiple projects

Confidential,Irving, TX Jul 2006–Jul 2009
Oracle Business Analyst (GL, AP, AR, CM)

  • Requirements gathering, analyzed business needs, requirements and specifications, and mapped to Oracle functionality.
  • Consulted with management and reviewed project proposals to determine goals, period, funding limitations procedures for accomplishing project, staffing requirements and allotment of resources.
  • Worked closely with the end users, business technologies, and others to understand and prioritize business goals and information needs related to the project.
  • Experience with performance tuning, environment reliability and availability, and system recoverability.
  • Trouble shooting and resolved application bottlenecks and performance issues
  • Experience in chart of accounts, set of books design, ledgers and ledger sets, and sub ledger accounting design.
  • Investigated trouble tickets by contacting end user for problem clarification, diagnosis and solution. Resolution included training users, modifying system/project implementation setup, writing reports/running queries, designing new programs, documentation, and working with IT to test applications
  • Assisted development with standardizations, mappings, and data cleansing in preparation for data conversions and integrations.
  • Provided written analysis of changes or new requirements and report forecasted times to implement the changes, reason for, and purpose of the change.
  • Suggested and built working business processes to improve productivity within company and Sarbanes-Oxley guidelines.
  • Managed Oracle Service Requests (SR) for resolution of problems and managed help desk tickets

Education
Master of Business Administration (MBA)

We'd love your feedback!