September 21, 2016

OBIEE Developer

Cynet Systems - Atlanta, GA

View Job Summary View Job Summary
  • Company
    Cynet Systems Cynet Systems
  • Location
    Atlanta, GA
  • Job Type
  • Job Classification
    Full Time
  • Company Ref #
  • AJE Ref #
  • Number of Positions

Job Description

We are looking for OBIEE DEVELOPER for our client in ATLANTA, GA





The client is seeking an OracleBusiness Intelligence Enterprise Edition (OBIEE) Developer with solid experience and knowledge in implementing enterprise level RPD's, reports (BI Publisher, Answers/Dashboard), and analytics. Candidate must be able to develop RPD's, reports, and dashboards. Candidate will be expected to migrate legacy reporting business logic from SAP (BO/WI, Crystal Reports) and Microsoft (SSRS). Candidate must demonstrate ability to be productive and effective in report conversion. Candidate must be capable and committed to delivering results on-time/on-schedule. The Enterprise Reporting and Analytics Team is composed of 5 report developers and a team leader. The team is migrating Microsoft SSRS reports and SAP Business Objects (v. 4)/Crystal Reports to OBIEE (with Exalytics) BI Publisher and Answers/Dashboards. Over 1000+ SAP reports are currently supported and will be assessed for retirement/replacement using OBIEE. Approximately 30 SSRS reports also will be converted. Development will be focused on providing ad hoc analysis to specific business authors and rolling out reports to business consumers. Current reports utilize the enterprise data warehouse (Oracle Exadata) and connections to SQL Server 2008/2012 and Oracle 11g/12c databases. The team develops enterprise reports within IT applications (internal/external) and on the web. Reports serve all facets of the transportation enterprise from financials, programs/projects, human resources, to federally required reporting. The team coordinates with client, server, network, and database/data warehouse personnel to integrate supporting IT architecture. Moving forward, ad hoc analytics/dashboards, geospatial (Esri) integration, and Microsoft Office add-in integration will also be implemented. RESPONSIBILITIES:

* Ability to design reports in a logical, user friendly, and easy to understand format
* Assists in OBIEE administration, system maintenance, and upgrades
* Assists in the administration and implementation of BI system/system security
* Building geospatial reports/dashboards
* Builds OBIEE reports and dashboards using BI Publisher, Answers and Dashboards
* Close engagement with Enterprise Architects, Data Warehousing, Database, and Server Administration teams in collaborative design
* Configures Ad Hoc query and Reporting environments
* Deliver solid, scalable, robust BI reporting/analytic solutions
* Design, develop, and document OBIEE repository/metadata
* Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques
* Developing MS Office based content using Oracle Office tools
* Manage capacity and performance requirements
* Models, configures and optimizes the RPD/Universes from Data Warehouse (OLAP) and databases (OLTP)
* Perform unit, system and integration testing
* Prepare estimates of time for design and development
* Provide design and development mentorship/cross-training with fellow team members
* Troubleshooting and resolving technical issues with minimal user disruption
* Working in a team environment to develop reports and/or dashboards while working as a team member on an assigned project
* Works with business users to gather reporting/analytics requirements


* 2+ years of experience with OBIEE Answers, Dashboards, and BI Publisher
* 2+ years of experience with star-schema, snowflake, FACT, and dimensional data modeling
* 4 yearBachelor's degree with preferred concentration in IT, data science, or business
* 5+ years of experience as an Oracle BI development using OBIEE with deep expertise in RDP design/development
* 5+ years of experience in writing PL/SQL, SQL*Plus, etc.
* 8+ years of IT development experience
* Ability to extrapolate business requirements, practices, and procedures
* Ability to meet deadlines and deliver high quality work products
* Ability to meet deadlines, results oriented
* Able to use complex expressions to calculate, group, filter, parameterize, optimize and format contents of reports/analytics
* Accountable for actions within OBIEE production environment
* Committed to ensuring data accuracy and quality within reports
* Complete working knowledge of OBIEE user, object and data security and caching capabilities.
* Demonstrated experience in designing, building, implementing, and deploying data universes/data models against Oracle and SQL Server databases
* Excellent communication skills
* Experience in data analysis, data profiling and validation
* Experience in producing test cases/scenarios
* Experience with Business Objects, Crystal Reports, and Reporting Services
* Experience with creating dashboards and performance metric based reporting
* Experience with deploying/upgrading BI systems
* High level of customer service
* Highly organized with the ability to multi-task
* Must be able to write technical documentation
* Must be skilled and experienced with graphical elements and filtered/layered reporting with drill down capabilities
* Understand how to use XML, and XSL for advanced report features and formatting
* Demonstrated experience in designing, building, implementing, and deploying enterprise reports, analytics, and dashboards
* Strong knowledge of RDBMS - MS SQL Server 2008/2012, Oracle 11g/12c


* Experience customizing BI reports using JSP, ASP, SDK
* Experience in BI security and server administration
* Experience with Crystal Reports and sub-reports
* Experience with Microsoft SharePoint
* Experience with Microsoft SSRS
* Knowledge of Oracle Financials (PeopleSoft), and Primavera/P6 Analytics, Human Resources (Time and Labor), and Learning Management