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)