Demand Planner
THE SULTAN CENTER
Total years of experience :18 years, 6 Months
• Responsible for assortment selection and range development, maintaining planograms, setting RSP’s and margins for Diy, Automotive departments.
• Negotiating the best prices with suppliers in order to apply an aggressive retail price to attain optimal profit margins.
• Have successfully finalized deals with suppliers in foreign countries even with the presence of a local distributor to get price advantages for my company Turtle Wax and Meguiars.
• Managing Inventory (keeping inventory as much as possible in a way it does not affect the cash flow and proper demand for items).
• Coordinated with foreign suppliers in respective countries (China, Spain, USA etc) to make sure shipments arrive according to plans, including consolidation of shipments, re-export to other geographies, in addition to making sure items are received and delivered at the right time, in the right quantity, with the right quality level.
• Responsible for internal communication between Finance and traffic department to ensure that the products received do not have any legal issues.
• Constant communication with marketing department for flyer items and items needed to be put on promotion.
• Visiting our service stores in Salmiya and Sharq and having face to face conversations with the store supervisors and managers and getting to know about the supplies and how well the stocks get replenished by us.
• Creating replenishment and shrinkage reports in Excel in advanced levels and providing useful presentations depicting the supplier service levels and the demands affected as a result.
• Handling the Feasibility study, negotiating, tracking, shipping, demand Forecasting, and inventory management of Foreign imported Home Center lines ( Automotive, Household, Kitchenware’s etc ) across TSC’s major outlets (Kuwait, Jordan, Oman and Lebanon).
• Maintaining the parameters of the replenishment model and making sure it is accurately managed into the system, including lead times, re-order point, economic order quantities, and suppliers minimum order quantities among others.
• Prepared reports and analyzed inventory KPI’s such as availability and overstocked items.
• Finalising Order quantity to be placed, releasing orders to suppliers, tracking orders, following documents and shipments with logistic department, follow up costing of shipments with finance, follow up claims.
• MIS reports Supplier reports & Product reports (expiry wise, stock wise, supplier wise, service level wise (supplier wise n order wise) depends on organizational requirements.
• Forecasts and Order tracking include all countries that TSC have their Business’s at (Kuwait, Jordan, Oman, Lebanon).
• Need to do a constant follow up and communication with our Freight Forwarder Kuehne & Nagel who assist in shipping goods from various suppliers to the respective destinations.
• Constant communication with our many suppliers globally to provide us with the necessary shipping documents and HTS codes needed by the port authorities and our retail management, and keep them updated on the rules and regulations at the ports of each countries, so that they can abide by them.
• Analyzing and forecasting the sales for all the items in Home centre and supermarket divisions.
• Processing True Value account statements on time so that there is no delay in payment.
• Responsible for creating Letter of Credit’s for our foreign suppliers.
• Ability to analyze that there is a problem in the orders and shipment and even more so how to counteract it is highly necessary. Hence the demand forecasted must involve even these factors.
• Providing the best balanced demand by not ordering too much resulting into shrinkage and affecting the cash flow of the company and at the same time not ordering too low resulting into lack of items at the store level and hence causing general customer dissatisfaction.
• Making continuous sales calls independently, generating prospects and converting them to clients.
• Collect local business requirements for hospitals and clinics and share with Oracle Developers to ensure these requirements are incorporated into the system.
• Meeting with clients and understanding their requirements and making sure to implement them into the system.
• As a result of this I have good knowledge in Oracle ERP and Business Intelligence also.
• Made a lot of presentations to the decision makers.
• Prepared technical and commercial proposals and make follow up with our clients.
• Managed accounts right from initiating a prospect till the payment collection.
• Responsible for problem escalation to Oracle Development team and third parties.
• Responsible for improvement and maintenance of the databases to include rollout and upgrades.
• Responsible for implementation and release of database changes as submitted by the development team.
• Providing onsite and web based training for customers.
Operations Risk Management
• Carried out risk assessment for general and medical Insurance Proposals by scrutinizing thoroughly a client’s profile(Underwriting), his lifestyle, occupation and health conditions are all verified.
• Responsible for applying the correct premium and terms for the clients in a policy depending on his age, income and choice of asset allocation.
• Preparing the policy documents and ensuring timely issuance.
• Servicing and retention of existing customers by way of providing special/privilege customer service.
• Prepared Monthly financial statements and management reports.
• Budget analysis and preparation.
• Maintain accounting software system( Life Asia). Produce weekly, monthly, quarterly, and audit preparation schedules and management reports.
• Carried out Technical medical Audit on clients to confirm their health status.
General Operations Management
• Insurance policies administration and review.
• Responsible for achieving the branch’s monthly targets in view of premiums.
• Ensured premium collection by contacting customers and providing reminders constantly.
• Rejecting policies that pose a threat to the investment in business by scrutinizing the customer profile thoroughly.
• Training Junior Underwriters, data entry team and Management Trainee’s on new product details.
• Perform end of day reconciliation daily.
• Achieved local sales targets by motivating and encouraging the Branch sales team.
• Developed very good rapport with the sales team and gave them a lot of encouragement.
• Responsible for general office appearance & security
• Performed on a big Database translation project for India Infoline, 2nd biggest share broking Company in India.
• Participated in designing SMS data model for SMS tools record and administration system.
• Developed difficult PL/SQL script to perform data migration, error managing and reporting.
• Skilled in measuring object-oriented applications to the relational model.
• Understanding of disk hardware architecture, RAID implementation, cache controllers, and disk load balancing.
• Adequate experience in monitoring and tuning a database to provide a high availability service.
• Administering and implementing strict security integrity controls.
• Proactively monitoring the database systems to ensure secure services with minimum downtime.
• Experience of managing multiple RDBMS on large systems.
• Wrote several SQL scripts to take out BLOB info both from VERSANT and database of ORACLE RDBMS and extended and inserted objects into the relational tables using SQL*Loader for treatment.
• Performed designing and developed programs to regain files / messages from SQL-Server and transferred them to associated nodes across Internet securely.
• Changed databases designs for many purposes such as data migration, data warehouse, and online transactions.
Masters in Business administration done at a full time Business School. With this I have been able to get management related job roles and further enhance my skills both professionally and personally.
Bachelor of Engineering in Information Technology. Highly skilled and strong analytically. With this knowledge I was able to create and manage a personal website.