Business Intelligence Specialist

Description

**Deliverables for Sr. BI Specialist**:
A Senior Business Intelligence Specialist FFS resource is needed for the IFIS in Cloud Project for the below deliverables:

- Validate business requirements and update functional and technical design documents.
- Retrofit custom ETL scripts and optimize OBIEE solution based on business requirements.
- Prepare impact assessment documentations and recommended approach for meeting client requirements.
- Prepare Implementation plan and effort estimates.
- Work with other team members to execute recommended/approved approach.
- Complete fit/gap and solution options for Oracle business intelligence solutions including OBIEE, and Oracle Analytics Cloud.
- Complete prototypes, set-up DEV environments and document optimal deployment solutions
- Complete design documents.
- Document and complete testing of OBIEE BAR files, data, reports, and visualizations.
- Identify the PII (Personally identifiable information) in databases, develop scripts, perform Data Masking of PII, and validate the same.
- Complete knowledge transfer to OPS team.

Other deliverables include:

- Update semantic layer, modify, or build new reports and dashboards and underlying data structures and related components.
- Build, test, and migrate reports and related objects.
- Provide knowledge training to OPS resources that will maintain the solution post go-live.
- Complete work and achieve milestones within the assigned deadlines.
- Notify the Ministry Client/OPS Organization project manager in writing of any issues or other material concerns related to the Assignment Deliverables as soon as he/she becomes aware of them.
- Submit Deliverables for the Ministry Client/OPS Organization approval as they are completed.
- Comply with the Ontario Government and the Ministry Client/OPS Organization security procedures and practices.
- Comply with the Ontario Government and the Ministry Client/OPS Organization architecture/technology standards and best practices.
- Comply with the Ontario Government and the Ministry Client/OPS Organization Conflict of Interest and Confidentiality Guidelines.
- Provide knowledge and skill transfer to a designated Ministry Client/OPS Organization staff; and
- Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures
- SKILLS**EXPERIENCE REQUIREMENTS**
ORACLE
BUSINESS INTELLIGENCE ENTERPRISE EDITION 12 EXPERTISE (75%)
- EXPERIENCE
WITH OBIEE, OAC, ODI, SQL, APEX AND RELATED OBJECT DESIGN, BUILD AND
IMPLEMENTATION.
- EXPERIENCE
IN BUILDING BI AND ANALYTICS APPLICATIONS OPTIMIZED FOR
HIGH-PERFORMANCE, HIGH-VOLUME REPORTING AND ANALYTICS FUNCTIONS.
- EXPERIENCE
WITH DATA INTEGRATION, DATA CLEANSING, AND INTEGRATION WITH OBIEE, AND
OAC.
- SKILLED
IN SOFTWARE DEVELOPMENT LIFE CYCLE AND CAN APPLY IN UNDERSTANDING,
BUILDING AND MAINTAINING CUSTOM SOLUTIONS.
- 5+ YEAR OF PRIMARY FOCUS ON DEVELOPING
CUSTOMER SOLUTIONS USING ORACLE’S ANALYTICS OFFERINGS: ORACLE ANALYTICS
CLOUD, DATA VISUALIZATION, FUSION ANALYTICS FOR WAREHOUSE, OBIEE, OBIA,
MACHINE LEARNING AND AUTONOMOUS DATA WAREHOUSE (ADW)
- 5+ YEAR OF EXTENSIVE, HANDS ON, END TO END
IMPLEMENTATION/OPERATE EXPERIENCE USING OAC/OBIEE INTEGRATION/REPORTING
TOOLS - ANALYSIS & DASHBOARDS, ORACLE DATA INTEGRATOR
- GOOD KNOWLEDGE OF OBIA PRE-BUILT CONTENT AND
EXPERIENCE WITH CUSTOMIZING/EXTENDING OBIA PRE-BUILT CONTENT OF
DIFFERENT MODULES
- SOLID UNDERSTANDING OF BUSINESS INTELLIGENCE
(BI) TOOLS, DATA WAREHOUSE (DW), ORACLE DATA INTEGRATOR (ODI), DATA
MODELLING CONCEPTS AND SQL/PLSQL.
- GOOD KNOWLEDGE OF ORACLE APPLICATIONS - ORACLE
E-BUSINESS SUITE OR ORACLE ERP, ORACLE HCM (THE ORACLE CLOUD SAAS
OFFERING) IS PREFERABLE.
- GOOD KNOWLEDGE OF DATABASE, CLOUD CONCEPTS,
AUTONOMOUS DATA WAREHOUSE (ADW), DATA INTEGRATION IS AN ADDED ADVANTAGE.
- HANDS-ON EXPERIENCE IN DATA MASKING OF PII (PERSONALLY
IDENTIFIABLE INFORMATION)
- GOOD UNDERSTANDING OF ITIL BASED
OPERATE/MANAGED SERVICES PROCESSES AND METHODOLOGIES INCLUDING
EXPERIENCE IN INCIDENT MANAGEMENT, MINOR ENHANCEMENTS, SERVICE REQUEST
MANAGEMENT, APPLICATION UPGRADES, ETC. HANDS ON EXPERIENCE IN HYPERCARE
SUPPORT WOULD ALSO BE BENEFICIAL.
ORACLE E-BUSINESS SUITE R12 EXPERTISE (15%)
- IN-DEPTH
EXPERIENCE IN PROVIDING AND DOCUMENTING IMPACT ASSESSMENT FOR
APPLICATION CHANGES, UPGRADES, AND PATCHES.
- EXPERIENCE
IN ELICITING, DOCUMENTING, AND VALIDATING BUSINESS REQUIREMENTS.
- EXPERIENCE
IN SOFTWARE TESTING, QUALITY ASSURANCE AND DOCUMENTATION.
- EXPERIENCE
IN BUILDING CUSTOM EXTENSIONS AND RETROFIT OF CODE.
- EXPERIENCE
IN TECHNICAL GUIDANCE ON ORACLE E-BUSINESS SUITE CUSTOM DEVELOPMENT.
CHANGE MANAGEMENT, TRAINING AND TRANSITION (5%)
- DEMONSTRATED
EXPERIENCE WITH DATA RECONCILIATION.
- EXPERIENCE
IN TRAINING, TRANSITION AND CHANGE MANAGEMENT ACTIVITIES.
SOFT SKILLS (5%)
- EXCELLENT
COMMUNICATIONS SKILLS, BOTH WRITTEN AND VERBAL: CLEAR, CONCISE, AND
JARGON-FREE.
- ABILITY
TO