MOHD SHAHRIL MOHD RUSLY

Accountable & Responsible for project requirement, data analyst, data modeling & data engineering design operationalisation and support PETRONAS Enterprise Data Hub (EDH) & Project Management of Future (PMoF) Data Hub integration. Project Collaboration by department :

• Pertronas Group Project Delivery (GPD)
• Nerve Center (NC)
• Project Management of Future (PMoF)
• Petronas Engineering Document System (P-EDMS)
• Project Planning & Cost Control (PP&C)

Bridged communication gaps between technical and non-technical stakeholders by translating complex data concepts into easily understood terms, fostering a shared understanding of project goals and objectives.

Responsibility :

• Design Architecture & Data Model to deliberate on the project requirement
  To deliver solution designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional and databases.These solutions support enterprise information management, business intelligence and other business interest.
• The deliverables are Conceptual, Logical & Physical Data Model Design, source to target mapping document for ETL purpose and detail design document for the project.
• Design Data pipeline, data ingest approach, data engineering & cloud solution such as AWS S3, Azure Data Lake Services (ADLS), AWS AURORA and Synapse (Azure Analytics Services).To build Data Integrity at Source & SSOT (single source of truth) as part of Petronas Enterprise Data Hub (EDH).

Project Involvement : Petronas Digital

• i- Petronas Dagangan Berhad (PDB) - Data Survivorship Solution
• Ii- Alpha Oil – Terminal Cargo Planning (TCP)
• iii- Alpha Oil – Integrated Resource Planning (IRP)
• iv- Alpha Oil – Drive Optimization Value for Enterprise (DOVE)
• v- Integrated Value Change Insight (IVCI) – Data On-Boarding
• vi- Petronas Dagangan Berhad (PDB)- Automated Wet Stock Management (AWSM)
• vii- DEMAND – Downstream Manufacturing Data

Project Involement :

• Drone Data Acquisition for GIS Data Mapping
• Training Facilitator – Survey Equipment (Trimble, Leica) & DJI / Mavic Drones.
• Responsibility :-
• Responsible for the successful initiation, planning, design, execution, monitoring, controlling and closure of a project implementation
• Supervise ICT Project Management & Support - Provide monthly analytical report for strategic planning
• Conduct Pre-Sales technical assessment.
• Tender & Procurement Management for Government and GLC
• Identified plans and resources required to meet project goals and objectives.
• Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.

• Project Involvement :
  -Bank Negara Malaysia :
  i.Customer Credit Reporting Information System (CCRIS)
  ii.Integrated Statistical System (ISS)
  iii.Financial Information Statistical System (FISS)
  iv.External Asset & Liabilities Information System (EAL)
  v.Cash Balance Of Payment Statistical Reporting (CBOP)
• Perbadanan Insurans Deposit Malaysia (PIDM)
• Financial Reporting to Central Bank of Kuwait (CBK)
• Goods & Service Tax Reporting (GST)
  
• Responsibilities :
  -Perform daily ETL – Core Banking job and data completeness check.
  -Perform preventive health check and maintenance on all BI infrastructures to ensure service up-time according to service standards optimal system performances.
  -Subject Matter Expert for Data Services System Application & Data Services Management Console Administrator.
  -Manage and maintain the EDW data model.
  -Develop, test and maintain BI system applications for the enterprise.
  -Design and integrate the corporate data stores (Finance DM, FISS DM, GST DM,Treasury DM, Risk DM)
  -BI DBA (maintain & admin role) manage and administer in database security.
  -Participate in scheduled DR activities.
  -Business / Technical Analyst for BI DW Project implementation of data management framework to ensure data integrity.
  -Provide analytical reports for Business Performance & Analytical purposes. Assist users in extraction and analytic request.
  -Deliver technical solution to support the business analyst in delivering bank-wide users request through information management.
  -Provide technical solutions on user’s requirements; and perform qualit yassurance on the technical solutions before delivering to end-users.
  -Provide consultation to users on information provided.
  -Ensure the relevancy of the data dictionary and meta data documentation.
  -Manage and ensure data quality issue in EDW is minimized.

• Project Involvement :

- Project Quantum Leap (PQL) - SAP R3 migration to SAP ECC6 for Material Management (MM) & Service Distribution (SD)

• Responsibility :

- Design best practise ETL architecture for SAP data migration

- Install, configure and train project team member with SAP BODS tools and establish connection from multiple data sources, BW, ECC6, SQL Server & LSMW.

- Act as DBA and storage management and BODS repository administrator.

eg. MSSQL Server 2008 and other SAP system.
- Propose best practice on Database Architecture and Universe Design (semantic layer)

- Manage Provide storage SQL Server 2008 and database report for projects that used Data Services Server.

• Maintained proficiency with latest database technologies.

• Project Involvement :

i- Decision (Banking, Project with Tyco Flow Control (Manufacturing) - Collate Product Group / Lead Time data, Customer data, Shipping data and standard part numbers data from 10 different data sources

Responsibility :

- Develop a dashboard with drill down feature - Develop the Lead Time Scorecard for Americas region - Create ad-hoc reporting as per requirements
ii- Project with Kuwait Airline (Airline)

Responsibility :

- His main role is to discover how to do the installation, setup the client/central repository and how to develop an ETL job, including source files extraction, and loading records from staging area to data warehouse, based on the mapping document given. Developed extract, transform and load (ETL) processes based on design mapping documents to populate data from source to data mart and from data mart to fact using Business Object Data Integrator 11.5 Developed workflows.