Please send resume at [email protected] or reach me at 609-447-3341
*Looking Oracle Business Intelligence Enterprise Edition (OBIEE) Developer* Duration: 05/16/2016- 06/30/2017 Location: Atlanta , Georgia Rate: $50 hr on c2c *Note: Need full SSN number and current address for submission * The Georgia Department of Transportation is seeking an Oracle Business 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. The position end date is set for the end of the Georgia DOT fiscal year. Georgia DOT may exercise the option to renew contracts in one year increments. Several successful developers have continued working for several years with contract extensions. However, Georgia DOT is under no obligation to extend contracts and may terminate employment at any time. *Responsibilities:* 1. Assists in OBIEE administration, system maintenance, and upgrades 2. Assists in the administration and implementation of BI system/system security 3. Building geospatial reports/dashboards 4. Builds OBIEE reports and dashboards using BI Publisher, Answers and Dashboards 5. Close engagement with Enterprise Architects, Data Warehousing, Database, and Server Administration teams in collaborative design 6. Configures Ad Hoc query and Reporting environments 7. Deliver solid, scalable, robust BI reporting/analytic solutions 8. Design, develop, and document OBIEE repository/metadata 9. Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques 10. Developing MS Office based content using Oracle Office tools 11. Manage capacity and performance requirements 12. Models, configures and optimizes the RPD/Universes from Data Warehouse (OLAP) and databases (OLTP) 13. Perform unit, system and integration testing 14. Prepare estimates of time for design and development 15. Provide design and development mentorship/cross-training with fellow team members 16. Troubleshooting and resolving technical issues with minimal user disruption 17. Working in a team environment to develop reports and/or dashboards while working as a team member on an assigned project 18. Works with business users to gather reporting/analytics requirements *Required Skills:* 1. 2+ years of experience with OBIEE Answers, Dashboards, and BI Publisher 2. 2+ years of experience with star-schema, snowflake, FACT, and dimensional data modeling 3. 4 year Bachelor’s degree with preferred concentration in IT, data science, or business 4. 5+ years of experience as an Oracle BI development using OBIEE with deep expertise in RDP design/development 5. 5+ years of experience in writing PL/SQL, SQL*Plus, etc. 6. 8+ years of IT development experience 7. Ability to design reports in a logical, user friendly, and easy to understand format 8. Ability to extrapolate business requirements, practices, and procedures 9. Ability to meet deadlines and deliver high quality work products 10. Ability to meet deadlines, results oriented 11. Able to use complex expressions to calculate, group, filter, parameterize, optimize and format contents of reports/analytics 12. Accountable for actions within OBIEE production environment 13. Committed to ensuring data accuracy and quality within reports 14. Complete working knowledge of OBIEE user, object and data security and caching capabilities. 15. Demonstrated experience in designing, building, implementing, and deploying data universes/data models against Oracle and SQL Server databases 16. Excellent communication skills 17. Experience in data analysis, data profiling and validation 18. Experience in producing test cases/scenarios 19. Experience with Business Objects, Crystal Reports, and Reporting Services 20. Experience with creating dashboards and performance metric based reporting 21. Experience with deploying/upgrading BI systems 22. High level of customer service 23. Highly organized with the ability to multi-task 24. Must be able to write technical documentation 25. Must be skilled and experienced with graphical elements and filtered/layered reporting with drill down capabilities 26. Understand how to use XML, and XSL for advanced report features and formatting 27. •Demonstrated experience in designing, building, implementing, and deploying enterprise reports, analytics, and dashboards 28. •Strong knowledge of RDBMS – MS SQL Server 2008/2012, Oracle 11g/12c *Desired Skills:* 1. Experience customizing BI reports using JSP, ASP, SDK 2. Experience in BI security and server administration 3. Experience with Crystal Reports and sub-reports 4. Experience with Microsoft SharePoint 5. Experience with Microsoft SSRS 6. Knowledge of Oracle Financials (PeopleSoft), and Primavera/P6 Analytics, Human Resources (Time and Labor), and Learning Management *If interested please fill the below details and send me ASAP.* ∙ Full name: ∙ Gender: ∙ Email id: ∙ Phone number: ∙ Nationality: ∙ Current location(Address): ∙ DOB: ∙ Relocation: .Available for F2F? : ∙ Location Preferences: ∙ Visa status: ∙ Skype ID: ∙ Linked in ID: ∙ Notice period to join: ∙ Full S.s.no : ∙ Total IT exp: ∙ Best time to reach: ∙ Highest Education Details: University: MM/YR: *Please share the 2 professional references:* Reference 1) Name: Number: Email id: Designation: Reference 2) Name: Number: Email id: Designation
