Viresh Devgan Email & Phone Number

New Delhi, Dl, In

New Delhi, Delhi, India

Work has done so far in the Caastle 1. Develop statistical and financial chargeback predictive Models for assessing probability of chargeback risk using R• The purpose here is to reduce the chargeback, So when the probability is more in future then we ask the customer about their satisfaction level & if she does not satisfied then we refund her. 2. Build finance automation project & Save 5 hrs in a week.(Using Python & deploy on bamboo)• Build an automated project to download the csv files from tableau & put the data in google sheet in different tabs and shared with recipients. The job is scheduled on Bamboo for every Monday3. Automated many monitoring & re-conciliation processes to cut down man hours on repetitive processes using Python• Write code on Macros to compute the metrics in Excel• Implement many scripts in Python using API & credentials to give $$ incentives/ Trial days/Loyalty points/ Account cancellation/ Email change etc which was initially done by visiting different sites. It saves many man hours.4. Develop a system to provide information all in one place regarding CCPA ( California Consumer Privacy Act )• Build a 15 chunk of queries in Impala to get the customer's all relevant information as per CCPA• Put all the queries in Jupyter notebook and run the script to download the data in CSV in separated tabs and Zip the file with Password5. Develop End to End Project of Garment Recovery system and charge “$25000” every month” those keep the garments after completion the subscription period o Make the MYSQL query to fetch the customer whose subscription has been cancelledo Send them notification mail from mailchimp if they will not return we will chargeo Charge the customers (who did not respond/return) from Braintree API by making Python Script and it runs on local machineo We recorded that we are charging $25000 or more every month.

New Delhi Area, India

1. Develop a system to tract the fraudulent customer who use one month free subscription with many different Account.• To build a system where we compare the customer’s information like geographical location, Credit Card and name after removing the symbol & special character by using Python, Impala, Google analytics. 2. Develop End to end project to track the performance dashboard of Garment Matching Algorithm for Shipment.• To track the performance of Matching Algorithm did the various thing.o Write a code to get the data from Json file from Amazon server and insert into the table using pythono Schedule the Job on Hadoop workbox to run hourly using Cron jobo Build a Dashboards & Presentation to track the performance of Matching Algorithm using Tableau3. Extracting historical & behavioural data and analyzing by writing complex SQL queries• Executing many adhoc request on daily basis on customers behaviour using Impala• Daily, Weekly business performance tracking of KPIs using Excel, Tableau• Analyzing and monitoring the business impact of new features post-launch in Matching Algorithm & Loyalty Points

This company has updated its name as CAASTLE INDIA PVT LTDOversee Conversion and retention analytics for a subscription-based rental eCommerce businessBuild customer fraud detections models by BI and Google Analytics.Expertise in Statistical modeling Developed a comprehensive interactive forecasting model to improve lost shipment(by courier), Garment recovery, Retention.Build data driven applications and advanced models for acquisition, segmentation and retentionSet-up and managed an automated reporting framework for tracking the key business metrics and KPIs and performance of various marketing channels and overall businessExtremely personable, organized, and data-driven.Working with very talented analysts and data scientist around the world.

In Business Aanalyst

Bachelor In Human Resources, Master In Computer Application