Ranjan Pandey

Ranjan Pandey

Sales Executive

Followers of Ranjan Pandey377 followers
location of Ranjan PandeyPune, Maharashtra, India

Connect with Ranjan Pandey to Send Message

Connect

Connect with Ranjan Pandey to Send Message

Connect
  • Timeline

  • About me

    Data Scientist/ Data Analyst | Corporate Procurement | Tableau | MS-SQL-Server | Python (Pandas, NumPy , Matplotlib, Selenium-driver) | ML(SKLearn)| Neural Network (TensorFlow 2.17.1)| NLP

  • Education

    • Guru Nanak Dev University, Amritsar

      2009 - 2011
      MASTER OF BUSINESS ECONOMICS Business/Managerial Economics

      Activities and Societies: Team activities like Debate Competition Completed MBE (Master in Business Economics) with specialization in Economic Analysis and did projects on Utility Analysis in Economics

    • CCS (Chaudhary Charan Singh)University

      2002 - 2005
      Bachelor of Business Administration - BBA Business Administration and Management, General
  • Experience

    • Ashiana Housing Limited

      Aug 2011 - Jun 2013
      Sales Executive
    • India Resources Limited Jharkhand

      Jul 2013 - Aug 2014
      Procurement Project Officer
    • Genpact India

      Oct 2014 - Sept 2018
      Process Developer (Procurement & Sourcing)
    • WNS Procurement

      Sept 2018 - now
      Data Scientist / Data Analyst (Corporate IT Procurement)

      Strategic Sourcing (Category : IT Hardware, IT Services, Hotel Technology, Telecom)Data Collection : Collecting the spend data from SIEVO & GEP as per business requirement and perform EDA (Exploratory Data Analysis) using advance excel.Machine Learning Models : Linear Regression , Classification and Price prediction models using SKLEARN.Exploratory Data Analysis : Performed EDA using Correlation.Statistical Evaluation : Implemented confusion matrix, ROC curve, AUC to evaluate the machine learning model.Data Visualization : Developed & design visually compelling dashboards using Tableau as per business needs. * Collect, clean, and preprocess large datasets from various sources to ensure data quality and integrity forprocurement domain - strategic sourcing..• Developed and implemented Time-series and Linear Regression machine learning models for price prediction * Classifications models using SKLEARN.* Worked closely with stakeholders to come-up with solutions to resolve the business issues/ problem using Data analysis and communicating technical terms in easy way to understand for non-tech stakeholders.* Evaluate machine learning model performance using appropriate metrics and techniques like Grid Search CV & Randomized Search CV to iterate on model improvements.* Implemented python y-ticker to extract stock financials information for strategic Supplier to analyze supplier market performance. Show less

  • Licenses & Certifications

    • AWS Certified Cloud Practitioner (CLF-C02) Cert Prep: 1 Cloud Concepts

      LinkedIn
      Jan 2025
      View certificate certificate
    • Exam Tips: PMI Agile Certified Practitioner (PMI-ACP)®

      LinkedIn
      Mar 2022
      View certificate certificate