Mahendra Dhatarwal Microsoft Excel
No reviews yet

I am a working professional with a 17 years of experience in different domain of Supply Chain Management.

In all honesty, Excel has been my best friend at work. It's helped me organize and analyze data like a pro, and I can't imagine doing my job without it. My expertise includes but not limited to like:

Advanced Formulas and Functions: I am adapt at crafting complex formulas and utilizing functions to manipulate data efficiently, Whether it's VLOOKUP, Index-Match, or nested IF statements, I can leverage Excel's formula capabilities to solve intricate problems.

Data Analysis and Visualization: I excel transforming raw data into insights through Pivot tables, data validation, and conditional formatting. I have a keen eye for data visualization techniques, leveraging charts, graphs, and dashboards to communicate findings effectively.

Automation and Macros: Over the years I have developed proficiency in automotive repetitive tasks and creating macros to streamline workflows.

Data Cleaning and Manipulation: With extensive experience in data cleansing and manipulation techniques, I can effectively prepare data sets for analysis, whether it involves merging, spitting, or transforming data. I ensure accuracy and consistency throughout.

Collaboration and Integration: I am proficient in collaborating colleague by sharing workbooks, tracking changes, and integrating excel with other Microsoft applications, This enables seamless collaboration and enhances workflow efficiency.

My proficiency in excel extents beyond formalities, it is cornerstone of my professional toolkit. enabling me to drive results and add value in various capacities. I am committed to staying abreast of the latest excel advancements and contineously refining my skills to meet evolving business needs.

Subjects

  • Microsoft Excel Beginner-Expert

  • Microsoft Excel Dashboard Beginner-Expert


Experience

  • Senior Manager - Stores & Logistics (Jan, 2024Present) at PI Industries, Ankleshwar
    Key Responsibilities Strategic -
     Responsible for coordination with HO for procurement activities & follow ups of all RM, PM & MRO items to avoid stock outs
     Implement cost effective practices in warehouse and logistics management
     Implement best practices of supply chain management
     Ensure effective management of inventory
     Approve supplier selection through robust qualification processes
     Develop and execute roadmap to improve domestic logistics framework at site
    Operational & Financial Inventory and Stores Management
     Define inventory levels of engineering and general items and avoid stock out position
     Minimize Inventory carrying cost by ensuring timely disposal of off-spec RM and PM
     Maximize creditors day by higher credits on inputs and low inventories
     Assist in identifying non-moving items as per norms and propose NPA in consultation with Engineering, Packaging Lab & Quality Control department
     Ensure material reconciliation with sub-contractors as per defined frequency and maintenance of proper records for
     Outsourcing
     Plan RM & PM availability at plant as per production planning & review it
     Ensure effective utilization of available facilities / resources
    Logistics Management
     Handling the entire logistics, payments, deliveries for site
     Provide guidance in domestic logistics management to ensure efficient and effective transportation of products
     Assess value and contribution of existing logistic partnerships and make changes when necessary
     Keep track of recent market developments in domestic logistics management and implement best practices of logistics
    management
     Ensure optimization of overall logistics troubleshooting cost
    People - Co-ordinate with
     Production Department for issue of RM / PM and receipt of FG
     QC related to quality of RM / PM / FG
     F&A Department related to bills / invoice
     User departments related to material
     Inform & discuss quality related matters with suppliers, QC & internal customer
     Facilitate initiatives for training need identification and building requisite skills & competencies through systematic training & skill-upgradation initiatives for the team
     Recognize & reward excellent performers & affirm key contributions of employees toward the achievement of goals &
     objectives of the team
     Inspire & motivate employees through demonstrated commitment to PI’s values, vision & mission and active participation in various team engagement activities.
  • Senior Manager - Techno Commercial (Jul, 2022Jan, 2024) at Adani Kutch Copper Limited, Mundra
     Implement best practices of supply chain management
     Implement cost effective practices in warehouse and logistics management
     Ensure that quality, quantity, customer satisfaction, and financial commitments are met
     Strategically manage stores in compliance with company’s policies and vision
     Setup layout and ensure efficient space utilization
     Initiate, coordinate and enforce optimal operational policies and procedures
     Adhere to all warehousing, handling and shipping legislation requirements
     Maintain standards of health and safety, hygiene and security
     Prepare annual budget
     Define inventory levels of engineering and general items and avoid stock out position
     Minimize Inventory carrying cost by ensuring timely disposal of non-moving items
     Ensure effective management of inventory
     Develop and execute roadmap to improve domestic logistics framework at site
     Ensure Assessment of DTA as well as Export documents in time and coordination of Transporters
     Ensure timely issuance of RODTEP License and also its immediate disposal in coordination with the stake holders.
     Ensure smooth functioning on account of material availability RM/Spares. Zero Breakdown/Stoppage incidents on account of delay due to Customs and Logistics team.
     Ensure cost effectiveness of the Service providers along with better service and minimize manual entries through automation in Ensure proper negotiation with Freight forwarders / Transporters for Export / Domestic movements.
     C & L Transactions. Development of stores & implementation of best practices in Stores.
     Dashboards development of Supply Chain (Stores, Logistics & other SCM) through MS office & Power BI
     Daily, Weekly & Monthly circulation of all the reports to Senior Management.
     Monthly reconciliation of FIM (Free Issue Materials) with all the contracts
     Ensure GST & SEZ rules and regulations are implemented & complied.
     Ensure accuracy of filing of Shipping Bill, Bill of Export, Bill of Entries for all the export & Import shipments.
     Ensure timely clearance of export & import shipments.
     Necessary arrangement of LSPs (Logistics Service Providers) for all the DTA/Import/Export cargos including containerized & break-bulk cargo.
     Performing route surveys for all the ODC cargo for DTA procurement & Imports
     Control detention/ demurrage and ground rent to the minimum level for all O&M consignments
    a. Ensure all Import documents ( Sea / Air ) are filed in time and minimize extra expenses due to delay in clearance and forwarding.
    b. To ensure timely custom formalities of imported consignment without any demurrages/detension charges and will ensure all invoice endorsement within time frame for getting SEZ benefit.
  • Manager - Stores & Logistics (Feb, 2021Jul, 2022) at PI Industries, Ankleshwar
    Key Responsibilities Strategic -
     Responsible for coordination with HO for procurement activities & follow ups of all RM, PM & MRO items to avoid stock outs
     Implement cost effective practices in warehouse and logistics management
     Implement best practices of supply chain management
     Ensure effective management of inventory
     Approve supplier selection through robust qualification processes
     Develop and execute roadmap to improve domestic logistics framework at site
    Operational & Financial Inventory and Stores Management
     Define inventory levels of engineering and general items and avoid stock out position
     Minimize Inventory carrying cost by ensuring timely disposal of off-spec RM and PM
     Maximize creditors day by higher credits on inputs and low inventories
     Assist in identifying non-moving items as per norms and propose NPA in consultation with Engineering, Packaging Lab & Quality Control department
     Ensure material reconciliation with sub-contractors as per defined frequency and maintenance of proper records for
     Outsourcing
     Plan RM & PM availability at plant as per production planning & review it
     Ensure effective utilization of available facilities / resources
    Logistics Management
     Handling the entire logistics, payments, deliveries for site
     Provide guidance in domestic logistics management to ensure efficient and effective transportation of products
     Assess value and contribution of existing logistic partnerships and make changes when necessary
     Keep track of recent market developments in domestic logistics management and implement best practices of logistics
    management
     Ensure optimization of overall logistics troubleshooting cost
    People - Co-ordinate with
     Production Department for issue of RM / PM and receipt of FG
     QC related to quality of RM / PM / FG
     F&A Department related to bills / invoice
     User departments related to material
     Inform & discuss quality related matters with suppliers, QC & internal customer
     Facilitate initiatives for training need identification and building requisite skills & competencies through systematic training & skill-upgradation initiatives for the team
     Recognize & reward excellent performers & affirm key contributions of employees toward the achievement of goals &
     objectives of the team
     Inspire & motivate employees through demonstrated commitment to PI’s values, vision & mission and active participation in various team engagement activities.
  • Manager - Commercial (Oct, 2020Jan, 2021) at Intech Organics Limited, Beawar, Ajmer
     Responsible for coordination with HO for procurement activities & follow ups of all RM, PM & MRO items to avoid stock outs
     Tracking of materials till it reaches at plant, suppliers, transporters and domestic courier etc.
     Handling logistics and organizing export shipments as per schedule
     To keep track of vehicles of Raw materials & finished goods
     Exposure of entire store activities, proper storage as per MSDS, inventory control and timely stock verification as per SOP
     Internal plant transfer & tracking of materials movement
     Maintaining all MRO items and matching physical vs ERP system
     Analysing movement of spare parts and maintaining ROL
     Co-ordination with all concerned departments to understand day to day production & procurement planning.
     Tracking of all AMC contracts of various equipments, services, & their timely renewal.
     Maintaining monthly & weekly MIS submission as per management requirement
     Enforce compliance with statutory and legal obligations wrt DGFT, GST under relevant legislation
     To strengthen team and organization with good team spirit.
  • Deputy Manager (Jun, 2010Oct, 2020) at Johnson Matthey Chemicals India Private Limited, Mundra & Kanpur
     Provide strategic leadership in setting KPIs to review the supply chain, logistics, store, inventory, import and export processes periodically to identify key risk and improvement areas
     Regularly communicate with internal / external stakeholders, and senior management regarding issues, decisions and actions that arise during operations, including providing status reports to all levels of management
     Establish, harmonise and maintain appropriate commercial policies, compliance and procedures across the organisation, ensuring compliance with applicable regulations
     Lead the team efforts for managing day-to-day operations for multiple departments including:
     Store Management and Inventory:
     Stock maintenance
     Design and implement warehousing SoPs
     Quality packaging
     Minimize stock holding and maximize stock system
     Production forecast planning
     Prepare inventory analysis report for management  Perpetual stock verification and documentation
     Ensure procedures as per compliance
     Prevent inventory loss
     Cyclic stock checks in store
     Audits and stock reconciliation
     Logistic operations:
     Sea freights & inland transportation
     Timely clearances of shipment
     Negotiating with transporters and shippers
     Carrier compliance with organizational policies
     Inbound-outbound operations  Coordination with internal and external agencies
     Cost-effective and optimal transport solutions
     Improve logistics policies and procedures
     Maintain metrics, reports and documentation
     Import and Export operations:
     Ensure operations in compliance with customs and RBI guidelines
     Import permit and export license processes
     Pre-shipment and post-shipment formalities  Attend GST, Customs, Excise and DGFT litigations
     Vendors and stakeholders contractual obligations
     Maintaining excellent Turnaround Time (TAT)
     Prepare and analyze import-export documentation
  • Senior Executive (Jul, 2008May, 2010) at Aadhaar Retailing Limited, Pune
     Led and managed teams across Maharashtra to handle logistics and supply chain management functions for 15 stores. Managed multiple product categories: apparels, food & grocery, consumer durables, general merchandise, and FMCG
     Efficiently handled complete procurement cycle from receipt of requisitions, definition of procurement strategy, selection of vendors, issue of enquiries, negotiation and placement of orders
     Successfully tracked the movement of the stocks available, perform stock audit, maintain stock ledger, forecast production/demand and controlled the inventory of multiple locations for proper available of resources
     Developed warehouse operations systems by determining storage requirements, implementing warehousing policies, developing inbound/outbound processes, quality control and cost analysis
     Monitored strong and reliable MIS reports to streamline material management, cost savings, vendor quality assurance operations for facilitating the decision making process and liaison with management
     Formulated and defined cost effective short/long term budgets and supply and logistic strategies for effective delivery of material while achieving desired results
  • Management Trainee (Jul, 2007Apr, 2008) at Pantaloon Food Products India Pvt Ltd
     Responsible for handling Back-end operations of staples & Groceries for all stores in Mumbai. Analysed materials requirement in terms of quality and quantity for Food Bazaar and KB's Fair Price while creating production and procurement plans as per requirement
     Handled management of slow moving stock at the store / warehouse and prepare budget, inter warehouse stock transfer details, stock valuation report, material return details, money receipt details and collection reports

Education

  • Lean Six Sigma Green Belt (Dec, 2021Dec, 2021) from KPMG
  • Certification in Supply Chain Management & Logistics (Oct, 2012Dec, 2012) from Indian Institute of Technology (IIT), Delhi
  • Certification in Export Management (Jun, 2012Dec, 2012) from Indian Institute of Export Management, Bangalore
  • Certification in Central Excise and Customs (Jun, 2012Dec, 2012) from Indian Institute of Export Management, Bangalore
  • Graduate Diploma in Materials Management (Apr, 2012Jul, 2014) from Indian Institute of Materials Management,Bombay
  • MBA (Jul, 2005May, 2007) from IABM, Bikanerscored 7.5

Fee details

    8002,500/hour (US$9.4329.48/hour)

    Simple to Complex Projects


Reviews

No reviews yet. Be the first one to review this tutor.