Ekta Aggarwal Data Science
No reviews yet

I am professional data scientist with 3 years of experience. Currently I am pursuing Masters in Data Science from prestigious University of Leeds (Work Ranking: 91) . I am a Senior Data Scientist at McKinsey & Company. I possess experience in training multiple professionals and students in data science in R, SAS, Python SQL, MS-Excel and Alteryx.

During my tenure I got the opportunity to work on several industry problems about clustering, regression and classification. My expertise is in healthcare and retail domain.
I have completed my Masters and Bachelors in Statistics from University of Delhi, India in 2018 and 2016 respectively.

I am to disseminate my knowledge with like minded folks and help them in diving deeper into this ocean of analytics. So what are you waiting for? Book a session and I assure you that you won't regret your decision of interacting with me! :)

Subjects

  • Python Beginner-Intermediate

  • SQL Beginner-Intermediate

  • SAS Beginner-Expert

  • Data Science Beginner-Expert

  • R programming Beginner-Expert


Experience

  • Founder (Jan, 2021Present) at Analytics is normal
    Researching on latest data science techniques and publishing articles on R, SAS, Python and SQL to disseminate knowledge to people who are eager to dive deeper into this ocean.
  • Senior Capabilities & Insights Analyst (May, 2019Jan, 2021) at McKinsey & Co
    o Leveraging analytical and problem-solving skills to develop a formula to forecast weekly regular volume after eliminating the effect of promotions.
    o Developing Bayesian Mixed effects model using R, SAS, Alteryx and SQL in order to ascertain price elasticities and monthly effective promotions.
    o Determining out of sample accuracy of the models and providing insights and reasoning for various business queries.
    o Problem Solving with McKinsey consultants and leadership to deliver optimal solutions to clients using visualization tools like Tableau.
  • Business Analyst (Aug, 2018May, 2019) at Evalueserve
    Project Title: Segmentation of employees in order to recommend suitable insurance plan.
    o Deployment of clustering techniques like K-Means and Hierarchical Clustering.
    o Cost Prediction per employee using ML techniques like Linear Regression, Logistic Regression and Random Forests.
    o Drawing insights from the data using SAS, R and MS-Excel.
  • Intern – Data Scientist (Dec, 2017Jan, 2018) at Listendata
    Researching on statistical and machine learning techniques in R and Python and contributed providing several high demand articles.
  • Intern (Jun, 2017Jul, 2017) at Government of India, Ministry of Tourism
    Project Title: State wise comparison of characteristics of domestic trips in India.
    o Calculation for population estimates and state wise comparison in R, SPSS and MS-Excel.
    o Identification of various characteristics like preferable accommodation, purpose of visit, mode of conveyance etc. for different states of India.

Education

  • M.Sc. Data Science & Analytics (Jan, 2021now) from University of Leeds, UK
  • M.Sc. Statistics (Aug, 2016May, 2018) from University of Delhi
  • B.Sc (H) Statistics (Jul, 2013May, 2016) from University of Delhi

Fee details

    £40/hour (US$50/hour)

    40 gbp per hour


Reviews

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