khuram hanif

Over 15 years of UAE/Pakistan/Qatar experience in Finance, Accounting and Data Analytics with excellent problem-solving skills. Working knowledge of SAP and various other ERP environments the latest being Oracle Fusion Cloud Implementation.8+ years experienced Business Intelligence Analyst adept at using Power BI, Google Data Studio and SQL for data collection & analysis to provide analytical solutions to the company .

Data Specialist

MILAHA (Qatar Navigation Q.P.S.C.)

Process Optimization

Replaced and eliminated time-consuming manual process with memory-efficient Data Models using Python and MS Excel Power Query functions saving strategic procurement team hours on daily basis by providing the team with the data at their clicks.

Increasing reporting capabilities by developing and rolling out new visualizations that helped automating the vendor contract evaluation process.

Data Visualization

Prepared a Financial Model for two internal business units addressing QAR 1 billion each, with Bottom to Top approach taking as granular level data as journal entry and preparing financial statements which served the purposes such as:

Maintain data integrity in assigned corporate master data sets in the areas of Vendors, Items, Assets, Users, Contacts, Business Units, Addresses, Locations, etc.

Using data profiling and data management techniques, documents and describes data in terms of meaning, constraints and relationships Maintaining the data dictionary for master data. Through data profiling and data cleansing, ensuring master data is defect free, conforming to specifications, and meeting business needs and expectations.

Item Master Data Cleansing

Existing master data of 400k items related to 43 vessels and 100k items for MHE (Material Handling Equipment) Challenges addressed;

Defined a standardized nomenclature for items description.

Designed a Categorization structure of a vastly diversified business units with 170 last level categories.

Inconsistency in Entries: consolidation of individual items entered in multiple ways.

Implemented a Validation Methodology for the Item Master list.

Extensive data mining, scrubbing and cleansing of raw datasets, Multiple algorithms were applied for data standardization and consistency.

Trend Analysis

Implemented Spend Management based upon best in class methodologies to enable Business Units to optimize the cost, quality and performance.

Employed Power BI, and Python for data collection and analysis to provide solutions in a timely fashion

Process Planning & Test Plan Development

Coordinated with the Procurement Management team in performing Spend Management analysis.

Managing organizational expenditure through Demand Identification, Spend Analysis, Sourcing and Order Management, for both direct and indirect spend categories.

Implemented Spend Management reporting to provide the required visibility to the sourcing team in moving from Tactical sourcing to Strategic sourcing.

Pakistan Institute of Public Finance Accountants

Public Finance Accountant