Rajat Kapoor
Senior Manager, Data Scientist
Gurugram
Summary
Manage 4 broad roles at RattanIndia & Droom i.e., Data Engineering, Data Science, Strategy & Program Management
Currently at RattanIndia, managing a 6 people team and successfully executed various projects involving the use of AWS, Python, Pyspark , SQL, Power BI
In Data Engineering, performed ETL activities from S3/RDS to Redshift using GLUE. Leveraged AWS EMR / EC2 for large-scale data processing, Lambda function to daily monitor transaction discrepancy. Usage of Kinesis and Flink to gain insights on the telematics data
In Data Science, automated daily & monthly transaction data trackers through PYTHON by establishing connections with various databases (SQL,RDS) and visualizing the reports in POWER BI.Processed large Financial Data through PYSPARK (Big Data) & automated various workflow through SELENIUM (Browser
Automation) and through UI PATH (UI Automation) and other workflow automation tools such as POWER AUTOMATE & INTEGROMAT and actively tracked KPIs & key business developments of Competitors
In Strategy, prepared Benchmarked reports (Presentation/Excel) that helped in better understanding of Market & Competition, identify gap between current Product Offering & Seller's & Buyer's expectation
In Program Management, worked closely with the Product, Tech & Category team for the issues faced by the Buyer facing & Seller facing teams and got it resolved within strict timelines
Overview
8
8
years of professional experience
7
7
years of post-secondary education
3
3
Certifications
Work History
AWS Data Engineer / Data Scientist
RattanIndia Enterprises
12.2022 - Current
- Managed a 5 people team and successfully executed various projects involving the use of Python, Pyspark, SQL, Power BI
- Performed Incremental Data Load for Production data from AWS S3 to AWS Redshift Using AWS Glue and performed visualization in Power BI
- Performed join operations on large text files (financial data) and custom transformation using AWS Glue and stored the same back in S3
- Lambda functions triggered daily to monitor faulty transaction data and stored the same in S3 to the backend team
- Analysis of Bike's telematics data through usage of Kinesis and Flink
- Leveraged the Glue Data Catalog to seamlessly query S3 data in Amazon Athena
- Deployed and managed Relational Database Service (RDS) instances on AWS, i.e. MySQL, ensuring scalable and highly available database solutions during peak hours
- Optimized queries by implementing indexes on frequently used columns, improving performance in WHERE, JOIN, and ORDER BY operations
- Developed stored procedures, triggers, and events for automating tasks, ensuring data consistency, and enhancing database functionality
- Functional Knowledge of AWS CDK to provision cloud infrastructure resources
- Prepared Strategy Documents for Marketing by analyzing data from Google Analytics, Search Console, Google Adwords
- Performed Data Cleaning & Data Transformation on large amount of financial data through Python/Pyspark using REGEX
- Leveraged AWS EMR / EC2 for large-scale data processing using Pyspark (Spark-Submit), extracting meaningful insights from massive public information Experian datasets stored in Amazon S3
- Developed and implemented efficient ETL processes using EMR and PySpark to cleanse, transform, and load data from Amazon S3 into a structured format for analytics
Strategy
Droom Technology
04.2019 - Current
- Prepared numerous Benchmarked & Adhoc Reports that helped Droom in developing a strong grip over Competitors and India Auto Industry and shortlisting appropriate automation tools for Sales, Marketing & Category
- Performed due diligence on Products & Services offered by Droom and created Actionable Reports suggesting the required changes and outlining why those changes were required
- Created an exhaustive list of Youtubers/ Influencers engaged in Creating videos related to Vehicle Discovery / Automobile Industry in India & reached out to them to strengthen Droom’s presence in Vehicle Discovery
Data Scientist
Droom Technology
04.2016 - Current
- Automated Call Centre Metrics & Cohort Analysis for Buyer & Seller through POWERBI , R & SQL
- Conducted Regression Analysis (Logistic Regression) to identify the key attributes considered by consumers for purchasing a vehicle based on Droom's Annual Buyer Survey Data
- Generated Segmentation Model using K-Means Clustering in order to discover new segments of customers
- Developed Python Scripts to extract Tweets from Twitter
- Cleaned, Parsed and Segmented Tweets content, counted most frequented words in R
- Prepared and implemented a model to Predict Vehicle Sales Data using Time Series Analysis in R
- Tracked Key Performance Metrics of Competitors i.e., Transaction, Traffic, Product Features, Financials etc. and suggested steps to stay ahead of competitors
- Proactively monitored & maintained Market Sales Data of 4Ws/2Ws/EVs by various dimensions i.e., Make, Model, Body Type, Transmission etc
- Used Workflow Automation tools such as INTEGROMAT, POWER AUTOMATE to enable end-to-end automation of Monthly Reporting wherever possible
Program Management
Droom Technology
04.2020 - Current
- Worked closely with the Product & Tech Team for the issues faced by the Buyer Facing & Seller Facing Teams and got it resolved within strict timelines
Education
MBA - Finance, General Management
Indian Institute of Management, Shillong
Shillong 07.2014 - 04.2016
BBA - Management Science
Lucknow University
Lucknow 06.2011 - 05.2014
CBSE Class 12th -
Cathedral Sr. Sec. School
Lucknow 04.2010 - 03.2011
CBSE Class 10th -
Cathedral Sr. Sec. School
Lucknow 04.2008 - 03.2009
Skills
Python Libraries Used : Pandas, Numpy, Pymongo,mysqlconnector,requests,datetime,Selenium,json, smtplib
PySpark
SQL / Flink
Power BI
Microsoft Excel / Presentation
Integromat / Power Automate
VBA
Regex
Stored Procedure, Indexes, Trigger & Events
Accomplishments
- Awarded Top Gear Spot Award at Droom for outstanding performance in Analytics Team
- Awarded First Position at Tek-Quest organized by Backwaters Committee, IIM Kozhikode
- Awarded First Position at High-Low competition organized by Operations Club, IIM Raipur
Certification
Mastering EMR for Data Engineers
Custom
- Collection of Commemorative Coins of India issued by the Government of India Mint
- Playing Cricket, Table Tennis
Languages
Hindi
Very Good
English
Very Good
Timeline
Mastering EMR for Data Engineers
08-2024
Glue : The Complete Masterclass
01-2024
AWS Data Engineer / Data Scientist
RattanIndia Enterprises
12.2022 - Current
Program Management
Droom Technology
04.2020 - Current
Strategy
Droom Technology
04.2019 - Current
Data Scientist
Droom Technology
04.2016 - Current
MBA - Finance, General Management
Indian Institute of Management, Shillong
07.2014 - 04.2016
BBA - Management Science
Lucknow University
06.2011 - 05.2014
CBSE Class 12th -
Cathedral Sr. Sec. School
04.2010 - 03.2011
CBSE Class 10th -
Cathedral Sr. Sec. School
04.2008 - 03.2009
Similar Profiles
Harendra ChandraHarendra Chandra
Senior Manager Internal Audit at RattanIndia Power LimitedSenior Manager Internal Audit at RattanIndia Power Limited
Lewis McCanceLewis McCance
CDL A OTR Truck Driver at US XPRESS ENTERPRISES, INC, Werner EnterprisesCDL A OTR Truck Driver at US XPRESS ENTERPRISES, INC, Werner Enterprises
Kayode DamolaKayode Damola
Warehouse Operative, Production Operative-Packer and loader at I&S Global Enterprises, Gama Glass EnterprisesWarehouse Operative, Production Operative-Packer and loader at I&S Global Enterprises, Gama Glass Enterprises
Megha TanwarMegha Tanwar
HR Manager at Varank Tech Private Limited (Formerly Verchaska Infotech)HR Manager at Varank Tech Private Limited (Formerly Verchaska Infotech)
Rohit YadavRohit Yadav
Technical Support Specialist at FoetronTechnical Support Specialist at Foetron