CURRICULUM-VITAE :
Sanjay Kumar Gupta
Email : sanjaygupta028 AT gmail.com
OBJECTIVE :
Contribute to the success and growth of my organization by using my innovative acumen, technical expertise and acquired managerial skills in the pursuit of the excellence.
EDUCATIONAL BACKGROUND :
ACADEMICS :
** B.Sc (Math). FromAPS University in 2008 with 58%.
** Intermediate, Math from M.P Board, in 2005 with 70%.
** High School from M.P Board,in 2003 with 70%.
PROFESSIONAL :
GNIIT Diploma, From NIIT, South Ex. Delhi in 2009 with 70%.
MBA (Marketing & Advertisement Management)from National Institute of Management in Oct 2013.
PROFESSIONAL SUMMARY :
Present : Jindal Stainless Steel Ltd. As an Executive (OSD-Marketing) March 2016 to till date.
Roles & Responsibilities :
MIS For OSD (Order to Service Dept.) :
** Regional Marketing Report, daily Corporate MIS Report, OSD MTS MIS Report,
** Outstanding report, Purchase details report, sales details, overdue outstanding report, own stock report, production report, dispatch report, stock ageing report, production and planning, Presentation for management analysis, stock analysis. (Follow up from all the four units & Hisar and Jajpur Plant). CRDD Analysis, Budget Vs Actual production
** Retrieving data from SAP like as stock, dispatches, overdue, POP.
Shipment Advice :
Taking out the daily shipment according to the customers dispatch Schedule.
SAP :
SO, Retrieving Stock(Service Centres, Yard, Plant),Dispatches, POP, Order Booking Details
Previous :
Associated with KJS CEMENT LTD. as Asst. Officer (Sales Promotion & Marketing Services Department) since May 2015 to March 2016.
Roles & Responsibilities :
Activity :
Dealer-Retailer Meet Data, New Product Launch Activity, Outdoor activity, Dlr. /Rtlr. Wall Shop Trolly Painting, Dealer/ Retailer Board, Periodical Printing, Shop Branding, Print Media, Dealer/Retailer Certificate& Trophy, Give awaysCO-ordination with the concerned Vendor. Processing all advertisement Bills.
Marketing Services :
i. Selection & Finalizing vendors for centralized procurement of various sales promotional items in consultation with Head - Marketing Services
ii. Preparation of Outdoor Media proposals for UP, MP and Bihar in consultation with Zonal Marketing Services Head (State Level)
iii. Ensuring timely processing of proposals, bills and disbursement of payment from CMO
MIS :
i. Budgeting of Sales Promotion (Zone Wise, Region Wise, Depot Wise and Activity Wise)
ii. Total number of Zones managed :
iii. Total number of Regions managed :
iv. Total number of Depots managed :
v. Preparing Budget Vs Actual Expenditure Report (Weekly & Monthly)
vi. Preparing weekly Marketing Services report
vii. Preparing monthly Marketing Services report
viii. Preparing Purchase Order & Bills Tracking Report (Monthly)
ix. Preparing proposals (vendor wise) for centralized procurement
x. Preparing Dealer/Retailer Meets and trade allied gathering's data, analysing it and generating insights for future meet planning & management
xi. Preparing periodicals' data i/c. Calendar-Diary Data (Zone, Region and Depot Wise)
xii. Preparing report on actual outstanding and bills,
xiii. Preparing detailed report on centralized procurements as well as zonal/regional purchases
xiv. Preparing Dispatch Report using SAP
xv. Assisting/Preparing corporate level presentations for Head - Marketing Services
SAP :
i. Preparation of Purchase Orders, SRN/GRN.
ii. Processing of service/product consumption bills in SAP
iii.Trade/Sales promotion stock consumption (Depot, Region and Zone Wise).
PREVIOUS :
Prism Cement Ltd.
As a Supervisor (Sales Promotion & Adv.Marketing DPT.) Since June 2012 to April 2015.
Roles & Responsibilities :
Activity : Dealer-Retailer Meet Data, New Product Launch Activity, Outdoor activity, Dlr. /Rtlr. Wall Shop Trolly Painting, Dealer/ Retailer Board, Periodical Printing, Shop Branding, Print Media, Dealer/Retailer Certificate& Trophy, Give awaysCO-ordination with the concerned Vendor. Processing all advertisement Bills.
MIS : Sales Promotion budget Report Zone-Region and Depot Wise and activity wise, Budget Vs Actual Report, Weekly Report, Monthly Report, PO Bills Tracking Report, Proposal vendor wise.
** Calendar-Diary Data Zone-Region and Depot Wise. Outstanding report of bill, Purchase details report, dispatch report, Presentation company label, Retrieving data from SAP like as stock, dispatches, overdue.
SAP : Preparation of work order, bills processing in SAP, sales promotion stock consumption depot, region and zone wise.
Previous : Jindal Stainless Steel Ltd. As a MIS Executive (Marketing) Nov 2011 to Jun 2012.
Roles & Responsibilities :
** MIS : Regional Marketing Report, daily Corporate MIS Report, CAM Status report, Customer Outstanding report, Purchase details report, sales details, overdue outstanding report, master processing advice, own stock report, Realization report, production report, dispatch report, making schedule, Presentation company label, VCMD (vice chairman managing director) report, stock analysis. (Follow up from all the four units). Retrieving data from SAP like as stock, dispatches, overdue.
** Shipment Advice : Taking out the daily shipment according to the customers dispatch Schedule.
** SAP : Making of SO & DO. And payment terms.
PROJECT UNERTAKEN :
Title : Internet Service Provider
Language : Front word - VB.Net
Back end database - SQL
IT SKILLS :
MS Office, SAP Basis, Power Point Presentation, VLOOKUP, HLOOKUP, Pivot Table, Formulas, Excel, MIS, MIS Reporting, Planning,,
Knowledge & Skills :
** Having strong problem-solving, analytical & Interpretation skills.
** Ability to process large volumes of data into meaningful summaries and presentations.
** Can manage time accurately and undertake complex tasks.
** Firm understanding and experience in Microsoft Office
** Advanced level of MS Office applications especially Excel.
** Well versed in all excel related applications.
** Knowledge of Pivot Table, Chart, Text column & Lookups, Logical functions, V&H Lookup functions, IF Statements, Nested If statement, Date Formula, Index, Match, String Function.
** Able to co-ordinate multiple tasks and meet deadlines under pressure.
** Work as a member of the operational team to achieve the business goals and objectives.
** Compilation and Flow of Data in Prescribed Time Limit
STRENGTHS :
Good leadership skill
Strong Adaptability
Good confidence level
PERSONAL DETAILS :
Father’s Name : Mr. Ram Prakash Gupta
Mother’s name : Mrs. RajKali
Date of birth : 25 July, 1988
Language : English, Hindi
Sex : Male
Marital status : Married
Nationality : Indian
DECLARATION :
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.
Date : 22-07-2016
Place : Gurgaon
SANJAY KUMAR GUPTA