Soumyajit Dutta
University of Calcutta
Skills
0 - 1 yrs
Hive
PostgreSQL
Python
R
SQL
Career Journey
Senior Executive
ANI Tecnologies
Mar 2019 - Mar 2019
Description: 
1. Preparing and analyzing different types of reports to increase the supply of Cars and food orders.
2. Analyzing data to retain the P1 customers and increase the AOV.
3. Maintaining and segmenting the restaurant bases to increase overall GMV of the city.
4. Segmenting the present customer base to analyze customer loyalty and stickability to the platform.
5. Deep down car level analysis to gauge the performance of cars on the basis of different metrics.
6. Segmenting the present supply on the basis of their earnings and providing appropriate schemes to get the maximum login hours from them.
7. Designing schemes to retain the existing cab base and also to reactivate the dormant cabs.
8. Have done car wise performance and scheme level comparative analysis for own schemes as well schemes rolled out by the competition to leech cars from the competition and increase the overall bookings for the city.
9. Analyzing different data points to increase the overall GMV and reduce ENTR for the city.
10. Automation of daily trackers and dumps extraction using R and Hive.
11. Writing Queries to download dumps from Database server.
12. Preparing presentations for monthly and weekly review meetings based on different reports.
13. Checking different parameters and providing Bonus to the operators.
14. Have worked closely with the sales team to maintain their targets and coordinating with the central team for smooth launch of different campaigns.
15. Have handled projects spanning across many departments as the single point of contact for all data related matters.
16. Have mentored the new MIS and imparted training to other department personnel on Excel and SQL.

Have been instrumental in overall pricing change for Prime category cabs
Skills
Hive
SQL
PostgreSQL
R
Python
Company Location
Kolkata, West Bengal, India
... See More
University of Calcutta
Graduation
Jun 2003 - May 2006
2 yrs 11 mos

Specialization
Degree: Graduation
Category: English
... See More
More
Others (2)
SkillsSoftware Knowledge
Personality
Nothing specified