Data Ingestion: Batch Processing and Real-Time Streaming jobs
> Managing ETL Pipelines of all backed data from (MySQL, MongoDB, Kafka), info, events, logs, and 3rd
party (Facebook, Google, Trivago, Ta, Branch, etc.) into a Data Warehouse using Sqoop Jobs, Python and
Spark Script.
> Creating of Data Mart for various requirements like Booking Master for all lobs, Marketing Spend,
Customer Data, APP Data, etc.
Automation and Analytics: I have also worked for various automation projects which include the following:
> Hotels Booking Tracking for DH and IH.
> Flight Revenue and Category Reports.
> Customer Repeat Rate Report on Company Level.
> Marketing All Spend and Tracking Report for Sem, Display, Meta, Affiliate for all lobs, and channels.
> Have automated the reconciliation of invoices, payout generation, and auto mailer.
> Have automated the various marketing manual work such as SEM Ads/Ad Copy/ Keywords/Sitelink
addition and update.
Real-Time Price: Managing Real-Time Price Sync API for various Ads Partner, which help them to fetch the
price for date wise cheapest price fare Hotels, Flight, Cabs, etc. which helps the teams to show the nearly
cheapest and latest price on ads.
Ads Performance: Working on various performance strategy which optimizes bid, on various ads channels,
automatically disable ads, add new products, managing product catalog/ feed for various ads network. Also, I
have created Web UI for teams to check their daily performance and customization for various automatic
work.
I have also worked on some ML projects for Clustering, Predicative, and Text Analytics work.

Data Analytics Panel: Have created data warehouses for reporting and analytics:
> ETL/Migration of data from Live MySQL, MongoDB, and 3rd party data to reporting DB.
> Have Created Web UI for Query the data from reporting DB using SQL and UI based condition.
> Developed an application so that different can create a query, generate a report, scheduled for auto-
delivery over email, FTP, etc.
Reporting System: Have worked on a various day to day reports and alert system some of the report listed
below:
> Hourly, Daily, Weekly, Monthly Order level report which helps various teams to work on it.
> Shipment Report which includes: Shipment, Rto, Ndr and Returns Information of every packed with the
summary, which helps various teams to work on this on a daily basis.
> Have also worked on Various Vendor Level, Customer Level, Product/Category level reports.
Have also worked on some backed development some of them listed below:
1. Kraftly Ads Network: Creating ads plans (Silver, Gold, and Diamond) for the seller to perform ads on
various ads platform, can also subscribe to the plan again payout and have a dashboard to view analytics
and invoices and plans.
2. Shipment Module: have worked on daily monitoring of shipment and update the latest status with various
events fire, creation of shipment, and manifest in bulk.
3. I have also worked on seller payout, customizable product, marketing tools integration, etc.

Real-Time Price: Managing Real-Time Price Sync API for various Ads Partner, which help them to fetch the
price for date wise cheapest price fare Hotels, Flight, Cabs, etc. which helps the teams to show the nearly
cheapest and latest price on ads.
Ads Performance: Working on various performance strategy which optimizes bid, on various ads channels,
automatically disable ads, add new products, managing product catalog/ feed for various ads network. Also, I
have created Web UI for teams to check their daily performance and customization for various automatic
work.