L.M. Sharma

Gurgaon · Haryana · India · LMSharma4011@gmail.com

Startup Enthusiast | Problem Solver | Data Analyst | Programmer | Designer

Always a learner who follows Learning-by-doing concept. Mixing concepts as chemical and making something new is what I love.

Experience

Business Analyst

OYO : Gurgaon

Currently working as Business Analyst in the OVH Supply Team.

Jun 2022 - Present

Business Analyst

Zetwerk : Bangalore

Worked as Business Analyst in the Operational Excellence Team.

  • CCC Measurement : In depth implementation and analysis of DPO, DSO and DIO offline and further taking it to automated system This helps in reducing the CCC, taking suitable action on Procurement, In- ventory liquidation, Interest charges on supply deals.
  • Centralized Ticket system for all OMS activities on google sheet and taking it further on freshdesk
  • Cash Margin Dashboards and analysis at different stages of the project, used to control the margin leakages across the org.
  • ERP implementation support on analytical side.
Feb 2021 - Jun 2022

Freelancer

CodroidHub : Edtech Startup

Geard-Up the codroidhub as Developer & Intructor

  • Project Management & Client Handling
  • Backend Development using Django
  • Python, SQL, Data Analysis Instructor
Oct 2019 - Jan 2020

Data Analyst

OYO · Gurgaon
  • Revenue,GrossTake forecast and Ploting for PAN India and International Hotels using Regression Models.
  • Automation for major KPIs and P&L Reports.
  • Web based Dashboard using Plotly , Flask, PostgreSQL , Hive
  • Data Pipelines for several Tableau Dashboards
  • Booking Fraud Detection : Detecting Fradulent Bookings using Logistic Regression.
  • Automated Toxic Review Classifier and Amenities Analyzer which helps in Hotel Auditing
  • Tagging-Revenue Analysis , Room Blocking Analysis
October 2018 - Sep 2019

Intern - Data Analyst

Medimojo : Health Care Startup · New-Delhi
  • Backend API's using Django.
  • Recommendation Project : Patient Visit Analysis from LAB test data. LTV suggestor , Foot-fall change , Retention time.
  • Medicine Suggestor : Suggest common disease medicines based on the symptoms.
June 2017 - July 2017

Personal Projects

Projects which helps me to keep learning and keep doing.
Cuss-Inspect
  • A basic and simple yet powerful Python library to detect toxicity/profanity of a review or list of reveiws.
    Cuss-Inspect is a logistic regression based Machine Learning model trained on 180K+ reviews and tested on 24K+ reviews.
    You may find it at pypi https://pypi.org/project/cuss-inspect/

Customer Segmentation

Predict the Criminal
  • HackerEarth ML Challenge. Based on answers to various questions concerning the professional and private lives of several people we have to predict whether someone is going to commit a crime in the future or not. Secured 177/1500 rank.
    Python Code at Github : Predict the Criminal

Sentiment Analysis
  • HackerEarth ML Challenge. Based on the hotel reviews by customers, their happiness have to be predict. Secured 98/1500 rank.
    Python Code at Github : Sentiment Analysis

Bulk Mail Sender
  • A python windows application to send mails in bulk, being used to send Assesment results, digital promotional activities.

Education

Krukshetra University · Haryana

Bachelor of Technology
Computer Science & Engineering

Percentange: 69.14%

2014 - 2018

CBSE · Haryana

Higher Secondary

Percentange: 82.8%

2012 - 2013


RBSE · Rajasthan

Secondary

Percentange: 86%

2010 - 2011

Awards & Certifications

  • Introduction to Neo4j @Neo4j
  • Certificate of Appreciation Conducted Faculty Development Programon DataScience using Python @TMU
  • Privacy and Security in Online Social Media @NPTEL IIIT Delhi
  • AIR 6 with 96% in Programming, DataStructures and Algorithms in Python Test on NPTEL IIT Madras
  • Best Project Award, Bulk Mail Sender 2016-17 @ACE&AR