Gautam Dey

Sr. Executive SCM & Logistic Coordinator

Mobile: +91-916*******

Email Id: adm01e@r.postjobfree.com

Professional Summary

A result oriented Executive as Supply Chain & Logistic Coordinator MIS, Sales & Product Coordinator,, EDP Department in FMCG, Automobile, Shipping, Steel & Chemical Sector.

Analyzing supply chain data & performance, managing company's supply chain & logistics strategy & operations in order to maximize the process efficiency & productivity, maintaining good relationship with vendors & distributors. Collecting Secondary Sales Data from DSE/TL/ASM& AM, Secondary sales data generate accumulate & update at ERP Online, Enquiry/Lead distribute to Respective dept. updated at ERP

Planning, organizing, directing, controlling and evaluating the operations of production and Responsible for preparing various MIS reports as per management and auditors. Co ordinations among different divisions.

DailyBusiness activity report preparation such as Primary & Secondary sales target vs achievement preparation Zone & SKU wise value volume both and coordinate with HO managers for their inputs with graphs . Weekly various report preparation with Graph for VCasper requirement.

Developing reports for top management. Stock Reconciliation -System Vs Physical, order vs. dispatch

Updating on-portal status report on daily &weekly monthly basis

Closely monitoring MTD, LYTD, YTD, H1 & H2 report buyer wise, analyzing the variances & related documents. Quotation as per requirement .Launch Tracker & IP productivity report Preparation for every new product launch area wise Responsible for preparing Executive Summary / team oriented Office highlights for management Review. Generating reports, Various entry at online ERP, (Enquiry, / product,WD,Zone,Area master updating at on line ERP, quotation, presentation through power point, Excel from Crystal report (VLOOKUP,HLOOKUP, FILTER,PIVOT TABLE,CONDITIONAL FORMATING AVERAGE,MACRO,FORMULA IF USE, AVERAGE CHART,GRAPH,POWER POINT Etc. )generating reports on demand E-Mailing .data management of receivables along with all support & coordination activity. Secondary Sales Analysis

Industry Reports comparison of same product with other co. to get information on daily business activities.

Summary report for Management. Book-keeping. Various report generate at ERPonline&email writing as per requirement.

Co-ordination with the different functions of the organization

Preparing Vendor reconciliation statements Daily involvement in operations (Incoming &out going Register raw & finish product)software installation,Software related various updation, Various Reports Finalization from Various Dept,-MIS. ).

Professional Experience

● Himadri Speciality Chemical Ltd. (Singur Plant)

Constriction/Paint Chemical Processing Division

Sr. Executive SCM & Logistics-Coordinator

Reporting to: Vice President Business

From Apr -2019 to Still Now

Key Responsibility Areas:

Weekly report preparation with Graph, PPT presentations for weekly & monthly MIS meeting. Coordinate with process team about finish product status. Collaborate with Process/Lab team for samples send to customer end along with COA & MSDS, stock reconciliation with physical stock Vs SAP stock, coordinate with transporter, tanker & truck arrangement as per loading schedule, coordinate with lab, weighment, invoice dept. up to Invoice & out Gate pass, FIFO basis raw material stock maintain at warehouse (ageing) & arrangement of stock transfer from Warehouse to plant as per requirement .Daily raw material status monitoring at plant. Maintaining inventory.

Sales related various report preparation exporting data from SAP, Product type wise .

Tanker & truck arrangement at plant daily basis asper loading schedule & rate comparison/negotiations with transporters, track of vehicles until reported to customer end to ensure timely delivery . Monitoring loading & unloading.On Aspect of Sales order, DO, various report preparation - PPT on demand E-Mailing & management, along with all support & coordination activity. YTD, LTD,H1 & H2 report Product wise, analyzing the variances & related documents.

Co-ordinate with Accounts Dept as Debtors Ledger maintainon due date of Payment collection/reminder as

schedule & correspondence by mail.

Daily involvement in operations & Production to ensure and effective execution of daily activity ( Various Reports inalization by collect data from various Dept, MIS. ). Analyzing supply chain data & performance.managing company's supply chain & logistics strategy & operations in order to maximize the process efficiency & productivity,

● Amrit Group ( Panagarh Plant )

Food Processing Division.- VAP

Product & Sales Coordinator MIS & SCM

Reporting to:Plant Head,G.M. FPD Head

From Feb -2015 to March 2019

Key Responsibility Areas:

Collecting Secondary Sales Datafrom DSE/TL/ASM& AM ( Bihar,Jharkhand,Odisha& WB ), Secondary sales data generate accumulate& update at ERPOnline, Enquiry/Lead distribute to Respective dept. updated at ERP

Planning, organizing, directing, controlling and evaluating the operations of production and Responsible for preparing various MIS reports as per management and auditors. Co ordinations among different divisions.

DailyBusiness activity report preparation such as Primary & Secondarysales target vs achievementpreparation Zone & SKU wise value volume both and coordinate with HO managers for their inputs with graphs . Weekly various report preparation with Graph for VCasperrequirement.

Developing reports for top management. Stock Reconciliation WD Points ERP vsPhysical, order vs. dispatch.

Updating on-portal status report on daily &weekly monthly basis Raw Items GRN, STN, KPI, SPA,

Closely monitoring MTD, LYTD, YTD, H1 & H2 report Zone & SKU wise, analyzing the variances & related documents. Merchandising/rental proposal preparation.Launch Tracker & IP productivity report Preparation for every new product launch area wise Responsible for preparing Executive Summary / team oriented Office highlights for management Review. Generating reports, Various entry at online ERP, (Enquiry, / product,WD,Zone,Area masterupdating at on line ERP, quotation, presentation through power point, Excel from Crystal report (VLOOKUP,HLOOKUP, FILTER,PIVOT TABLE,CONDITIONAL FORMATING AVERAGE,FORMULA IF USE, AVERAGE CHART,GRAPH,POWER POINT Etc. )generating reports on demand E-Mailing .data management of receivables along with all support & coordination activity. Secondary Sales Analysis

Industry Reports comparison of same product with other co. to get information on daily business activities.

Summary report for Management. Book-keeping. Various report generate at ERP online &email writing as per requirement.

Co-ordination with the different functions of the organization.

Preparing Vendor reconciliation statements

Daily involvement in operations (Incoming &out going Register raw & finish product) to ensure and effective execution of daily activity ( Various Reports Finalization from Various Dept, MIS. ).

●Vikrant Forge Ltd.

Company is the Forging &Steel manufacturing Co.

Inventory Controller & Operations

From May 2011 to Jan-2015

Reporting to: A.S.M., SM,

Key Responsibility Areas:

Generating miscellaneous reports,stock reconciliation, GRN, STN, report, mechanic wise labor maintain .WIP, grade generate, P.O, W.O,weekly Monthly daily basis report various report generate / entry through ERP ( IC Soft ) .DMS (IDMS)

Planning, organizing, directing, controlling and evaluating the operations of information systems and EDP department. Coordinating with the present package provider in case of modification in the existing system. Co ordinations among difference department.

Updating on-portal status report on daily & weekly monthly basis Raw Items GRN, STN, KPI, SPA,

Closely monitoring MTD, LYTD, YTD, H1 & H2 report Zone & SKU wise, analyzing the variances & related

documents. Merchandising/rental proposal preparation

Launch Tracker & IP productivity report Preparation for every new product launch area wise Responsible for preparing Executive Summary / team oriented Office highlights for management Review. Generating reports, Various entry at online ERP, (Enquiry, / product,WD,Zone,Area master updating at on line ERP, quotation, presentation through power point, Excel from Crystal report (VLOOKUP,HLOOKUP, FILTER,PIVOT TABLE,CONDITIONAL FORMATING AVERAGE,MACRO,FORMULA IF USE, AVERAGE CHART,GRAPH,POWER POINT Etc. )

Generating reports, Various entry in ERP, (Enquiry, part / product master, quotation, process sheet General Crystal report,, presentation through power point, Excel (VLOOKUP,HLOOKUP,FILTER,PIVOT TABLE,FORMULA USE, CHART,GRAPH Etc), generating reports on demand E-Mailing / G.M. Users various problem solve computer related,

Every day data backup.,

Daily involvement in operations to ensure and effective execution of office activity( Various Reports Finalization from Various Dept,MIS. ).

● Jalan Group, Kolkata

EDP Incharge

From Apr2001 to Apr 2011

Reporting to: Works Manager –MD-GM

Company is the authorized dealer of Maruti Udyog Ltd.

Key Responsibility Areas:

Opening job cards, bill preparation, ( LAN, DMS Online )”Foxpro/Oracle base,ine, generating miscellaneous reports,repeat job, warranty, revisit, stock reconciliation, GRN, STN, etc.

Monitoring the system to ensure consistent performance in terms of Software and Network ( LAN ).

Maintaining backups of the system in case of hardware failure or other disasters.

Supporting the network, including assisting in upgrades and distribution of the application, and performing troubleshooting regarding the workstations or network.

Installs and upgrades operating system software, Anti Virus and other supporting Application Softwares

Monitors and tunes system / network to ensure acceptable levels of performance

Ensures connectivity and communication among networks, servers, and clients inside and outside the department.

● Diamond Shipping Company Ltd, Kolkata

Asst. Inventory Controller

From February 1998 to March 2001

Reporting to: Managing Director

Company is a shipping agency -Diamond Line.

Key Responsibility Areas:

Managing entire warehouse functions.

Controlling movements of equipments in India & abroad.

Handling all the necessary books and documents like inward, outward and stock registers.

Maintaining all the necessary reports related to container movement, container stock reconciliation etc.

Maintain all records of goods financed and warehouse loan accounts.

Education Qualifications

Bachelor of Commerce, 1996

Universityof Burdwan, Durgapur

ØDiploma in Computer Application,

WEBEL, Durgapur.

ØComplete Hardware

Pronobananda Computer Training Institute. Howrah

Switch Details

Present Salary : (P/M)

Other Perks (if Any) : NA

Other Incentives (if Any) : NA

Present Notice Period : 15 Days

Expected Salary : Negotiable

Preferred Contact Time : Any Time

Open for Relocation - : Yes

Open for Relocation to : West Bengal

References

Available on request

Personal Details

Date of Birth : 2nd January, 1976

Gender : Male

Marital Status : Married

Nationality : Indian

Address :Village : South Kamrangue,

P.O. : Jhorehat,

P.S. : Sankrail,

Dist. : Howrah – 711302,

West Bengal, India

Date : S I G N A T U R E

Contact this candidate