Summary
Overview
Work History
Education
Skills
Scholastic Achievements
Timeline
Generic

SOHAN LAL

Kaithal

Summary

To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

3
3
years of professional experience

Work History

Business Analyst

Udaan
07.2021 - Current
  • Part of GTM team working on improving buyer experience and increasing business
  • Building and maintaining automated live dashboards to support day-to-day tracking of business
  • Planning analysis for GTM team manpower design, creating targets and tracking achievement against targets to hit team goals
  • RCA to understand deviations in trends of KPIs
  • Build model for classification of assistance needed for buyers
  • This helped GTM team to design buyer coverage model more efficiently and with lower cost
  • Owning all data requirements from multiple team. Extraction and processing of millions of rows from multiple data sources using SQL to provide structured data to business units
  • Impact analysis of projects and tracking of projects
  • Extraction and Analysis of historical data with help of SQL, Excel, Data Studio and Google sheets that translates data into actionable insights
  • Leading team of 3 MIS and 1 Analyst, making sure that each of them adds to their maximum in growing business and ensuring their personal growth.

Business Analyst

Udaan
08.2020 - 07.2021
  • Part of Returns team working on improving buyer experience and decreasing overall returns loss
  • Build dashboards to provide visibility on return metrics like return raised percentage, approval rate, RVP cancellation, return loss percentage, resolution time etc.
  • Tracking these numbers on weekly/monthly basis and provide RCAs for deviation observed in any of metrics
  • Buyer Flagging: Build model to flag buyers as RED based on relative behavior of buyer on various parameters like return rate, dispute rate, return reason, pick-up cancellation rate etc.
  • Impact analysis of projects and tracking of projects.
  • Collaborated with stakeholders to define project objectives and criteria
  • Identified patterns and trends in large data sets and provided actionable insights
  • Utilized data visualization techniques to present and explain complex data sets
  • Optimized data access and storage to improve performance of analytics systems

Education

M.Tech - Industrial Mathematics and Scientific Computing

IIT Madras
Chennai
2020

Master of Science - Mathematics

SLIET PUNJAB
Sangrur
2018

Bachelor of Science - PCM

KURUKSHETRA UNIVERSITY
Kurukshetra
2016

Skills

  • SQL
  • Microsoft Excel
  • Power BI
  • Python
  • Google Sheet
  • Data Studio
  • Process Optimization
  • Data and Analytics

Scholastic Achievements

  • Department Rank 1 in M.Sc. Mathematics at central funded technical institute SLIET PUNJAB. (2018)
  • GATE Exam: Secured All India Rank-225 in Mathematics among 8765 students. (2018)
  • JAM Exam: Secured All India Rank-964 in Mathematics among 9999 students. (2016)
  • 3rd position in Zonal Level Science Quiz Contest and participated in State Level Quiz Contest. (2015)
  • Awarded Central Sector Scheme of Scholarship for excellent percentage in 12th class. (2013)

Timeline

Business Analyst

Udaan
07.2021 - Current

Business Analyst

Udaan
08.2020 - 07.2021

M.Tech - Industrial Mathematics and Scientific Computing

IIT Madras

Master of Science - Mathematics

SLIET PUNJAB

Bachelor of Science - PCM

KURUKSHETRA UNIVERSITY

Similar Profiles

CREATE PROFILE
SOHAN LAL