Lead Business Intelligence Consultant
Fakeeh Care Group
Total years of experience :15 years, 9 Months
• Lead the strategic design, delivery, and maintenance of the business intelligence solutions that will the company priorities.
• Provide vision and leadership to ensure maturation of business intelligence solutions.
• Utilize my technical and functional experiences of Oracle E-Business Suite in BI solutions.
• Develop healthcare BI solutions include (Healthcare stander indicators, Outpatient, Inpatient, Procedures, Pharmacies, Laboratory, Radiology, ER, revenue analysis), to enable management levels to make better performance and revenue.
• Build up a centralized data warehouse and map out and integrate it with all healthcare applications & Oracle ERP modules.
• Develop analytical Oracle ERP e-Business suite (Finance, SCM, HR) indicators dashboards, and reports.
• Build and maintain reports, Scorecards, Dashboards, and KPI’s tools (SSRS, Power BI (cloud or on-premises), Oracle Admin Tool, Oracle Analytics)
• Develop and maintain Extract, Transform, Load (ETL) processes tools (SSIS - Oracle ODI)
• Build and maintain multidimensional cubes, Online Analytical Processing (OLAP) tools (SSAS).
• Fresh new implementation of Oracle BI Apps (OBIA 11.1.1.10.1):
Source: Oracle EBS 12.1.3
BI Target: OBIA 11.1.1.10.1 HCM / Financials / Supply Chain Management.
Tools used:
OBIEE 11.1.1.9.1 (Build Analysis and Dashboards)
Oracle BI Administration Tool 11.1.1.9.1 (Build/Modify Repositories)
ODI (Oracle Data Integrator 11g).
Work includes:
• Gathering business requirements.
• Implementing requirements on OBIA ready-made dashboards/analysis.
• Implement new customizations (BI Answers / Repository / ODI)
• Troubleshoot & Fix ETL run issues
• Examine the performance of Incremental & Full ETL runs
• Maintaining GL Account Mapping
• Maintaining HR Mappings
• Conduct top management Demos / User training, Training Manuals.
• Support day-to-day business requirements.
• Designed and developed various critical business processes.
• Participate in business analysis activities to gather the required reporting and dashboard requirements.
• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources using an ETL tool.
• Translate business requirements and knowledge of data warehouse to model the Physical Layer, BMM Layer, and Presentation Layers in Oracle BI Administration Tool.
• Develop Oracle BI Analyses and Dashboard.
• Provide expertise to the business with reporting, analytics, and dashboards and provide insights into data that will drive business growth and performance.
• Work closely with other departments, ensuring their data, reporting, and analytics needs are met either by producing top-quality dashboards and insights or by training and providing them with what they need to produce those same dashboards.
Key Responsibilities:
• Develop Oracle BI Analyses and Dashboard.
• Provide expertise to the business with reporting, analytics and dashboards and provide insights into data that will drive business growth and performance
• Develop OBIEE metadata repository (.rpd), configuring metadata, Business Model Layer, Physical Data and Presentation Layer by using Oracle BI Admin tool.
• Develop and designing Oracle BI Analyses and Dashboards tool.
• Build and extend OAF pages.
• Analysis, design and develop different solutions using Oracle application development tools.
• Develop SQL, tables, views, function, procedure, package objects under Oracle E-Business suite environment.
• Provide technical training and support for customers team.
• Personalize Oracle Forms and OAF pages.
• Develop and customizing AME, Workflow.
• Creating custom Alerts to notify users based on various business events.
• Develop integration solution.
• Load data by used APIs and Interface tables tools.
• Apply technical scripts.
• Prepare technical documentation.
• Supporting several standard and custom modules.
• Create a custom solution by using ADF tools.
• Building and maintaining Data Warehouse databases.
Key Responsibilities:
• Developed and customized Workflow process by using Oracle Workflow builder and Oracle AME tools.
• Developed Oracle application integration solution between SMS provider and Employees Self Service module.
• Created custom application Alerts.
• Data Load tasks using APIs and Interface tables.
• Developed PL/SQL Objects, Forms, Menus and Reports.
• Interacted with users to resolve any issues during the production, development and enhancement phases.
• Designed and developed various critical business processes.
• Developed Data migrating process.
• Create custom solution by using ADF Business Components, Threads, and JSF & Web Logic tools.
• Using Oracle OAF tool to developed new extension solution into iProcurement module.
• Supporting several standard and custom modules.
Key Responsibilities:
• Responsible for NCCI Reimbursement System, Fax Software & Integration using Waseel Portal.
• Responsible for WebLogic, Reimbursements Systems using ADF Technology.
• Using Oracle ADF Business Components to Upgrade Reimbursement Module (Oracle Forms Technology) to be (Oracle ADF Technology) using ADF Business Components, Threads, JSF & Web Logic Using Same PL SQL Packages using Same Oracle Report.
• Using Java Technology to build SDS (Scan Document System) to Control scanners & Cams (JTwain Java Lib) to capture images of MDB Claims Synchronized with File Net Project.
• Responsible For NCCI Oracle Workflow for Reimbursement Payments.
• Finding new design in Oracle Workflow for a new processes such as referral process for Reimbursement Claims Module and control in hierarchal tree of users & Managers with limit of Settlement.
• DB Analysis, Design, developing DB objects.
• Key Users Training
• Developing, enhancing, testing, deploying, maintaining, and preparing document applications using Oracle forms and reports builder according to the business requirements and time schedule requirements.
• Responsible for the modifications and develop new process which is requests from QA team, fix any bugs in the system and work with in below modules:
o Oracle General Ledger.
o Oracle Accounts Payable.
o Oracle Accounts Receivable.
ACADEMIC CERTIFICATES