Summary
Overview
Work History
Education
Skills
Accomplishments
Training Qualifications
Place
Personal Information
Languages
Hobbies and Interests
Disclaimer
Skill Sets
Key Skills
Languages
Timeline
Generic
Ranjani D

Ranjani D

Chennai

Summary

An enthusiastic young individual seeking an opportunity to play a challenging role with a commitment to company excellence and management is a long-term goal.

More than 10 years of experience in various facets of procuring materials from national and international markets. Experienced in inviting and allotting customer orders. Expertise in developing local vendors, reducing the cost of procurement of materials. Experienced in implementing inventory management systems, avoiding overstocking, or wastage. Working knowledge of ERP, ZOHO, and SAP.

Overview

15
15
years of professional experience

Work History

SENIOR EXECUTIVE - BUYER

INNOVATIVE RETAIL CONCEPTS PRIVATE LIMITED(BIG BASKET)
CHENNAI
10.2022 - Current
  • Own end-to-end responsibility for category management across beverages, baby care, cleaning household, beauty, and hygiene categories.
  • Handling 8,000 SKUs in beverages, baby care, cleaning household products, beauty, and hygiene categories.
  • 200 vendors are handling operations within Chennai, including top companies like HUL, P&G, Colgate, Marico, and Jyothi Labs,etc., as well as interstate direct buying brands Honasa (Mama Earth), Biotique, Swiss Beauty, and Colorbar Cosmetics,etc.
  • Handling the Direct Depot supplier's fixed schedule supply and Interstate vendors' courier supplies coordination to ensure timely availability.
  • Ensuring fill rate with the brands to maintain the target sales rank-wise: Top 1k, 3k, 3k-5k, above 5k.
  • Develop and own the monthly category analysis report.
  • Overall responsibility is to optimize sales, along with accountability for pricing, promotion, margin, and inventory control.
  • Analyzing OOS SKUs' RCA overall data and initiating sales trend SKUs' MBQ increase to avoid stockouts.
  • Dark store availability and initiating the internal indent with the concern department.

Vendor Management:

  • Vendor evaluation, selection, and commercial negotiations for price, margins, credit terms, delivery lead time, returns, stock management, product quality, and overall service.
  • Initiating vendor code creation with HO for the vendor code and mapping the SKUs to the respective SKUs.
  • Coordinating with vendors for timely supplies, promo finalization, and SKU deactivation coordination, if any, from the brand side.

MASTER UPDATION

  • Vendor master updating and maintenance, along with the details of the software vendor code, vendor name, KAM contact person's contact number, and email IDs, as well as the supply depot person's contact details. GST Number, Depot, and Warehouse Location.
  • SKU's Master Updation - SKU Code, SKU Name, Vendor Name, MRP, CP, Case qty correction.

AUTO PO PROCESS:

  • Ensuring mandatory parameters, like correct vendor name mapping, ICM (Indent Category Master), MBQ (minimum order qty), and rack location. Initiate the update wherever the gaps are found.
  • Ensuring the concerned persons' email IDs are updated for the respective vendors to make sure the vendors receive the alerts on time.
  • Manual POs creation for necessary and MOQ vendors.
  • Weekly conference calls and Google Meets initiating with the brands for fill rate and availability.

Data maintaining:

  • Monthly GRN Report (day-wise) - SKU-wise along with GRN quantity and GRN value for the Chennai region.
  • Monthly Sales Report (day-wise), SKU-wise, along with GRN quantity, and GRN value for the Chennai region.
  • Monthly GRN Register - Vendors' GRN Number Against Inv No & Date.
  • Return to vendor / Goods discrepancy report.

Inventory Management.

  • Monthly Ageing Report - Food > 30 Days (GRN Date) / Non-Food > 90 Days and circulating to the team for initiating PRNs for zero sales slow-moving SKUs (only RTV vendor) and planning the liquidation deep discounts to liquidate the stocks.
  • Aging SKU's tracker and monitoring the SKU's liquidation status.

Purchase and Vendor Development Manager

Visnukumar Traders Pvt Ltd
06.2022 - 10.2022
  • More than 10 years of experience in various facets of procuring materials from national and international markets.
  • Experienced in inviting and allotting customer orders.
  • Expertise in developing local vendors, reducing the cost of procurement of material
  • Experienced in implementing systems of inventory management, avoiding overstocking, or wastage.
  • Working knowledge of ERP, ZOHO, and SAP.
  • Setting up the weekly, monthly procurement plan according to the customer orders.
  • Procurement of FMCG from the domestic market and from the national and international markets.
  • Development of alternative local sources for imported FMCG, which helps in cost saving.
  • Planning and budgeting of purchase functions, involving cost estimation, and payment terms.
  • Liaison with the production department to maintain optimum inventory.
  • Implementing systems to avoid situations like overstocking or out of stock, which cause production and financial losses.
  • Liaison with the finance department for timely payment of bills.
  • Developing reports on the procurement and usage of materials for top management.
  • Effective management of the vendor database.
  • Vendors score on the basis of criteria like cost, quality, timely delivery, etc.
  • Development of new vendors
  • Conducting training for vendors to educate them about the company's requirements and help them improve their performance.
  • Evaluating vendors, negotiating the price, delivery schedule, and terms and conditions with them.
  • Timely clearance of payments and handling vendor inquiries.
  • Developing reports on various programs run for vendor development for top management.
  • Maintaining the stock of materials without any variance by conducting stock verification and documentation.
  • Implementing Standard Operating Procedures within the warehouse.
  • Regularizing material receipts and ensuring the fluidity of stocks from the warehouse to the stores.
  • Saved over 3-4% of the purchase value by introducing direct company supply, such as HUL, MTR, and Godrej Consumer Products.
  • Introduced B2B supplies like Big Basket, Jio, Udaan, and Walmart for bulk supplies and best prices.

Category Buyer

Future Value Retail Limited
Chennai
03.2010 - 03.2012
  • Handling 8000 articles in overall food
  • VRF (Vendor Registration Form) filling and check the parameters like (Payment method, Bank details, Brand offered, Tin no, Pan NO checking, brand Details and Margin Etc
  • Follow up with the zonal team and get the article code mapped for respective Vendor code
  • Article master creating, also update the MRP & ongoing changes updating in the master, keeping the master clear
  • VAT & CST calculation and making the Purchase order
  • Co-ordinate with vendors and get the stocks
  • Responsible for Fill rates: Take the fill rate in system and check the low fill rates reason
  • SALES UPDATION: MC Wise, Brand wise, Department wise sales YOY
  • Responsible for daily stock value, sales value and calculate the stock day cover
  • Responsible for Promo updating in purchase and sale for weekly promos, monthly promos and release the Promo PO's in correct promo price, also check the on invoice promo while arriving the stocks
  • Responsible for to take daily stock Value and Excess stocks details
  • Daily sales updating Reports and Sales Value Details
  • Negative margin details and negative sales report for Entire category
  • Responsible for to take YOY growth for Department wise skus

Education

B. Sc - mathematics With Computer Application

TNOU
01.2010

Higher Secondary -

SKDJ Hr Sec School
Thiruverkadu
01.2008

S.S.L.C -

SKDJ Hr Sec School
Thiruverkadu
01.2005

Skills

  • Purchase management
  • Procurement of FMCG
  • Cost-saving
  • Planning and budgeting
  • Inventory management
  • Vendor development
  • Vendor database management
  • Vendor evaluation
  • Negotiation
  • Payment handling
  • Stock verification
  • Standard operating procedures
  • Mis data analysis
  • Excel (Pivot, VLOOKUP, HLOOKUP, CONCATENATE functions, SUM functions)
  • erp
  • sap
  • Keyboard shortcuts
  • Mis data analysis
  • Excel (Pivot, VLOOKUP, HLOOKUP, CONCATENATE functions, SUM functions)
  • erp
  • sap
  • Keyboard shortcuts

Accomplishments

  • Saved over all 3-4% purchase value to introduced Direct company supply like HUL, MTR, Godrej consumer products, etc.
  • Introduced B2B supplies like Big Basket, Jio, Udaan, Walmart for Bulk supplies and Best prices.
  • Introduced B2B supplies like Big Basket, Jio, Udaan, Walmart for Bulk supplies and Best prices.
  • Introduced B2B supplies like Big Basket, Jio, Udaan, Walmart for Bulk supplies and Best prices.
  • Introduced B2B supplies like Big Basket, Jio, Udaan, Walmart for Bulk supplies and Best prices.
  • Introduced B2B supplies like Big Basket, Jio, Udaan, Walmart for Bulk supplies and Best prices.

Training Qualifications

  • DCA
  • SAP - Procurement flow
  • Tally
  • Typing Lower

Place

Chennai, Tamil Nadu, 600077

Personal Information

  • Date of Birth: 04/02/91
  • Nationality: Indian
  • Marital Status: Married

Languages

  • English (Read, write & Speech)
  • Telugu (Speech)
  • Tamil (Read, write & Speech)

Hobbies and Interests

  • Reading Books
  • Listening Music

Disclaimer

I hereby declare that all the details furnished above are true and correct to the best of my knowledge and belief.

Skill Sets

  • Exposure to MIS data using excel (Pivot, Vlookup, Hlookup, Concatenate Functions, sum functions)
  • Hands of Experience in ERP & SAP.
  • Using more Keyboard shortcuts to do works simplify.

Key Skills

Setting up the weekly, monthly procurement plan according to the customer Orders., Procurement of FMCG from Domestic market from national and international market., Development of alternative local sources for imported FMCG which helps in cost saving., Planning and budgeting of purchase functions, involving cost estimation, Payment terms., Liaison with the production department to maintain optimum inventory., Implementing systems to avoid situations like over-stocking or out-of-stock which cause production and financial losses., Liaison with finance department for timely payment of bills., Developing reports on procurement and usage of material for top management., Effective management of vendor database., Vendors score on the basis of criteria like cost, quality, timely delivery etc., Development of new vendors., Conducting trainings for vendors to educate them about company's requirements and help them in improving their performance., Evaluating vendors & negotiating the price, delivery schedule and terms and conditions with them., Timely clearance of payments & handling vendor inquiries., Developing reports on various programmes run for vendor development for top management., Maintaining the stock of material without any variance by conducting stock verification and documentation., Implementing Standard Operating Procedures within the warehouse., Regularizing material receipts and ensuring the fluidity of stocks from warehouse to stores.

Languages

Telugu
First Language
English
Advanced (C1)
C1
Tamil
Proficient (C2)
C2

Timeline

SENIOR EXECUTIVE - BUYER

INNOVATIVE RETAIL CONCEPTS PRIVATE LIMITED(BIG BASKET)
10.2022 - Current

Purchase and Vendor Development Manager

Visnukumar Traders Pvt Ltd
06.2022 - 10.2022

Category Buyer

Future Value Retail Limited
03.2010 - 03.2012

B. Sc - mathematics With Computer Application

TNOU

Higher Secondary -

SKDJ Hr Sec School

S.S.L.C -

SKDJ Hr Sec School
Ranjani D