FASAHAT ABDI

DATA ANNALIST

Contact Me

Mobile

030********

E-mail

ady3jd@r.postjobfree.com

Address

R 128, Pink Residency,

Gulestan E Johar, Block 8A

Karachi,Pakistan

Birth Date

Date: 5/Mar/1979

Languages

English,Urdu

Skills

Ms Excel based analyst

Interest

Music, Travelling

Others

Design and Development

Awards

Recognized by Regional Sales

Manager South for

outstanding efforts to deliver

MF & LUBE TGT in 2013 of

QTA Territory

Recognized by Transport

Manager ME/PAK/IND for

outstanding efforts to timely

deliver product to HSD IPP

customers Ex- MCH

Recognized by MESA OTC

Performance Lead

UAE/Oman/PAK), for

Customer 1st behavior

Recognized by GM

Distribution & Director Shell

Pakistan Limited for the

outstanding commitment to

achieving our end target of

zero overdue invoices

Education

1998 - 2000

Karachi University

Bcom

Experience

Dec 2014 - till yet

Lubricant - Business Support

Date Analyst

Generate & Analyze sale report data–exporting, compiling and manipulating data and summarizing results in various formats, as well as providing recommendations based on data analysis. Follow up with credit team in releasing the Credit holds on lube orders. Generate consolidated MILO pack for B2B and B2C channel, regularly on a monthly Basis, helping the sales teams in robust reviews of their patch. Comprehensive management of marketing and trade promotion claims of Distributors. Conduct a very complex reconciliation of all the claims against invoice discounts and credit notes.

June 2014 - Dec

2014

Retail South

KEY Accounts Officer, Sindh & Balochistan

Generate & Analyze sale report data–exporting, compiling and manipulating data and summarizing results in various formats, as

well as providing recommendations based on data analysis. Follow up with credit team in releasing the Credit holds on MF & lube orders. Resolution of supply related issues at Installation/Depots. Liaise on with HBL HO & local branches to sort out payment issues as and when required. Maintain and edit (CS&A) Customer Setup and Amend form of customers whenever required. Supporting the KAM in achieving mont Aug 2012 - May

2014

Retail South

Contracts and Admin Assistant, Sindh & Balochistan Focal point for streamline data for entire south region Provide support to the Territory Managers and District Managers for sales reports. Preparation of all lease documents in consultation with District Manager, also liaison with Head office on matters related to

rentals. Preparation of sales data and appreciation for Shell network as well as tabulating competitor data [estimated]. Analysis of credit and sales data for onward submission to territory managers on daily b

Maintaining database of sales, network development, and site wise data. Maintaining record of all types of petrol pump / CNG development documents (NOCs, Explosives Approvals and all type of

government approvals). Correspondence with HO through e- mail / Inter office memos on matters related to rentals, leases, credit and franchise fee. Responsible for issuing templated letters/yellow warning red cards to the retailer and maintain files for each site. Compile reports of Network Control, Quality, Quantity and Sales certificates. Arranging meetings, seminars, Dealer’s Club function etc on regional level. Handling Imprest of Regional office. Handling all type of customer issues related to retail outlets as well as Local Administration. Responsible for support and supervising contractual staff at regional office. Mar 2009 - July

2012

Supply & Distribution - OTD

Distribution Scheduling Support

Made proactive amendments in scheduling plan (in case of unexpected/unplanned issues such as: close stock outs, diverted

loads, crossovers, truck failures, traffic congestions, delay of loading/discharging operations) Coordinated with depots / Transport Relations for smooth plan execution. Register Customer’s wishes/needs to change/amend/cancel order and, once assessed the real need and the feasibility in HSSE terms, create emergency trips and/or re-route planned trips Take customers on board proactively regarding product delivery constraints Take Fuels’ urgent orders and liaised with the schedulers as required

Handled invoice disputes relating to incorrect quantities and processing adjustments where necessary to correct

Investigated customer complaints, provided corrective and preventive action to the customer. Updated 'Customer Issue & Feedback" action taken so that the case can be closed July 2005 - Feb

2009

Supply & Distribution - OTD

Road Transport Department

eloped & analyzed monthly, quarterly reports related to HSSE KPIs D – (Road Transport & Depot) HSSE KPIs Collection, Monitor and Upload

Develop presentation/slides for various meetings/conferences like CLT & Board meetings. Provided support in preparation of annual budgets Initiated Cost based negotiation by developing Cost break-ups with suppliers/contractors Prepared tender and contract documents leading to negotiations with

suppliers/contractors.

June 2003 - July

2005

Supply & Distribution - OTD

Road Transport Department

Conducted DDC (Defense driving Course) monthly basis Conducted ROADD Course (Realization of attitude of defense driving) early basis Looked after routine transport activities like daily Road checks; conducted toolbox meetings, Preloading TL inspections, Record

management, & Training (Staff & Drivers) Looked after depot operations - Received Product through T/Ls. Measuring of the product received through T/Ls Worked at Gantry with 100% PPE compliance, checking of filled T/Ls with the petroleum products, scheduling of T/L s inside the

Depot behind the Filling Gantry for filling and keeping the point of (HSSE) Health Safety & Security Environment in view. Projects

2010 - 2011

Shell Pakistan LTD

Fule Shortages Price Calculation Tool

Took the Initiative to prepare an excel based shortages Reconciliation Tool and carried out reconciliation for all shortages from

2011 till Dec 2012, satisfying the requirements of the external A. F. FERGUSON & CO audit team.

Took the initiative to prepare an excel based shortages price calculation tool internally which saved Rs 0.12 million for SPL 2018 - 2019

Shell Pakistan Ltd

upfront discount mechanism

Played a pivotal role in developing and launching the upfront discount mechanism for B2C Distributors, resulting in hefty savings for Shell Pakistan.

2014 - 2015

Shell Pakistan Ltd

All Volume Report

Invented the All Volume Report for the Lubricant Sales team, resulting in massive improvement in visibility of Sales Orders and historical volumes, from Brand/Product/SKU standpoint. Improved the new GC LSC Report, for the entire lubricant facebook.com/fasahat.abdi twitter.com/fasahat.abdi linkedin.com/fasahat.abdi

Contact this candidate