Business Intelligence and Reporting Manager
Parsons Corporation
Total des années d'expérience :23 years, 6 Mois
WORK ACHIEVEMENTS
• Defined, recommended and delivered Business Intelligence strategy and evolution road maps for Parsons and Ministry of Housing.
• Led the preparation and review of project proposals and business cases in the area of BI solution design and alternatives.
• Managed BI projects through gathering requirements from various MOH business units (Executives, Design, Quality…etc.), analysis of business automation processes supported by Oracle Primavera, PCM, Excel Sheets and BI applications, translation of business process requirements and functional knowledge into
technically sophisticated products and solutions.
• Led BI solution implementation, delivered and managed BI for enterprise data and reporting architectures within scope and schedule including resolving issues and managing risk.
• Created complex conceptual designs, customized BI Dashboards for a large (105 Project Sites) and
architected high quality modifications or enhancements to meet functional requirements.
• Built and maintained strong relationships with MOH stakeholders.
WORK DUTIES
• Lead teams across broad technical, financial, and business disciplines to ensure BI project milestones
completed on time, on budget and with the desired results.
• Identify business issues through analytics, provide actionable insights and influence business leaders to take action based on analytical and modeling insights.
• Provide leadership, direction and guidance to senior and executive level MOH stakeholders to ensure the alignment between the solution and the requirements.
• Provide direction, oversight and participate in the overall design of the data and technical architecture of the data warehouse including the development of logical and physical data models, ETL scripts, metadata definitions and models, queries and reports, work processes, and maintenance procedures.
• Provide the technical direction required to resolve complex issues to ensure the on-time delivery of solutions that meet customer expectations.
• Manage on-site and off-site consultants working on the projects to ensure timeliness and quality of service delivery.
• Ensure all standards for documentation, version control, production control and security had followed by the implementation teams.
• Continue to evaluate tool selection and emerging technologies in the area of Business Intelligence.
WORK ACHIEVEMENTS
• Provided Business Intelligence architectural framework.
• Led designs within specific BI and DWH solutions (in the areas of: ETL, DWH, OLAP Analysis, Mapping
& Integration).
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Implemented Informatica & DAC for ETL and Mapping processes of BI Application Analytics.
• Implemented and provided end-to-end OBIEE solution for (HR, Finance, Procurement and POS) by
configuring metadata and building business application analytics repository, dimensional modeling design, building business models and mapping layer that may include hierarchies, dimensions and aggregates, generating reports and creating dashboards.
• Assessed BI related IT architecture components that was added to the existing landscape to ensure
compliance with regulations, policies and standards.
• Deployed Oracle's BI Application Implementation Methodology (OUM).
• Conducted CRP sessions and UAT Training.
• Collaborated with business and technology resources to identify key business requirements for the OBIEE product suite implementation.
WORK DUTIES
• Defined product strategy and road map for BI/Analytics tools.
• Worked with functional teams to ensure alignment on goals and tactics.
• Designed and developed BI Metadata Repository for oracle EBS modules and identify areas of optimization.
• Responsible for the OBIA deployment and maintenance of the Physical Layer, Business Model & Mapping and Presentation layers in OBIEE repository.
• Worked with cross-functional teams to ensure alignment on goals and tactics.
• Provided high-quality consulting services and deliverables.
• Conducted research and made recommendations on BI products, services, and standards in support of
procurement and development efforts
WORK ACHIEVEMENTS
• Implemented the IT strategies and plans related to oracle database administration consistent with the group overall business strategies and objectives.
• Led oracle database migration to make sure it runs smoothly and successfully deployed from 10g to 11g.
• Installed and configured relevant network components to ensure database access as well as database consistency and integrity.
• Designed and implemented redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data.
• Participated in the design and implementation of new Almajdouie systems and applications including:
gathering user requirements, meetings and workshops, preparation of design specifications, definition of Process flows, data modeling and design (logical and physical), impact analysis, development of SQL queries, scripts and procedures and development of system and UAT test plans.
WORK DUTIES
• Provided consultation on database to Oracle and Microsoft SQL development team.
• Responded to and resolved database access and performance issues.
• Monitored database system details and implemented the improvements.
• Ensured availability of databases at all times and maintained backups using RMAN of all available data.
• Monitored, optimized and allocated physical data storage for database systems.
• Conducted research and made recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
The projects that were handled are:
• Oracle Business Intelligence 11g for (HR, Finance, Procurement and POS)
• Data Cleansing Project (HR, Finance and Procurement)
• Saudi Credit Bureau (Simah) Data Mapping
• Almajdouie ERP System selection
• Document Managment System DMS
• Enterprise Content Management System ECM
• Warehouse Management System - Infor WMS
• Helpdesk System
• Implemented and managed Oracle / SQL Databases.
• Planned and executed Backup & Recovery.
• Upgraded and migrated oracle databases to latest version.
• Configured the database over oracle clustered.
• Installed latest patches for oracle cluster and Database.
• Supported team of application developers to develop and implement new solutions.
• Regulations Reviewed of database integrity and security.
• Executed and monitored DR procedures.
• Generated reports regarding performance, space utilization, identify problems & errors, security, data integrity and availability, running scripts, backup status for developing and production sites.
Collected Client requirements, articulated functional requirements and system specifications.
Designed, developed, and implemented customized application packages.
Tested, fine-tuned, documented, and administrated the application packages.
Interfaced with users, performed enhancements, fixed bugs and resolved coding issues.
Wrote programs in C#, VB, ASP.Net.
Bachelor's degree in Computer and Information Sciences Information System Department with grade Very Good. Graduation Project Grade: Excellent.
Graduation Grade: Very Good