Deepak Jain Email & Phone Number

Mumbai, Maharashtra, India

Building Products @ TU

Mumbai, Maharashtra, India

Tools & Technology: Microsoft SQL Server, Tableau, Python, Excel, Pandas, Scikit-learn, NumpyProject Experience and Details:Client: Aditya Birla Sun Life InsuranceSome of the key projects delivered and currently working on includes:• Persistency Model: Tagging probability scores, using logistic regression and xgboost, on customer profiles who have a different level of propensity to lapse on their policy payment (13th month, 25th month, 37th month, 49th month, and 61st month)• Tracking: Tracking of paid/unpaid policies at the end of every month and validating the data with the persistency models• Analytics project on terminated agent rehiring: Analyzing the data for terminated agents who could be re-hired after studying various profiles and would lead to an increase in the revenue stream by 3.7%* • Analytics project on New business leakage: Analyzing data to find the causes of leakage in new business and plugging them (specifically the causes which fall under the company`s control). Building a logistic regression model on the same to predict the probability of customers likely to be rejected• Lapsed and surrender policy that has been re-invested in the company in the last 5 years: Analyzing the lapsed and the surrender policies which the customer re-invests into the system for short term gains and identifying the trends and pockets where its most active• Child product plan for cross-sell/up-sell: Identifying customers from the existing base where new products for children can be pitched for upsell/cross-sell

Mumbai Area, India

Tools & Technology: MySQL, Tableau, Python, Excel, Pandas, Scikit-learnProject Experience and Details:Client: Trent Pvt Ltd (Onsite)Brand Name: Westside – A TATA EnterpriseWorking as an analytics consultant, my role and responsibilities included:• Analyzing & improving SPSF (Sale Per Square Foot) of Westside stores. SPSF is one of the key metrics to measure sales output in the retail segment.• Identifying data points relevant to the outcome and extracting them from various data sources• Cleaning data using MySQL/Python/Excel and analyzing it to find insights• Using Tableau to create amazing visualizations and dashboards• Using various machine learning techniques like k-means clustering – to create clusters of stores, customer segmentation• Creating stories around the findings and communicating the same to the management team• Working in a multi-stakeholder environment that needed interaction with various teams like operations, space range display (SRD), marketing, visual merchandisers (VM), merchandisers• For the selected stores, the recommendations, would shoot up the revenue by at least 14%• Calculating the threshold value of space for each brand to be allocated based on store size which would be very helpful in designing the future stores and having a re-look at the existing stores where certain brands are over spaced

Mumbai Area, India

With no background in apparel industry, self-started business in the field of manufacturing of garments for women intraditional and casual wear.My roles and responsibilities, as the founder of the company, included: Defining the vision, culture and objective of the company Handling the complete production pipeline Getting Sales – travelling to various locations across India Sampling and sourcing raw materials Managing a team of 15+ people Managing everyday accounts Handling customer relationship Solving dynamic problems that arise on day to day basis Maintaining the quality and standard of the products Feedback system – employee engagement – grievance handling

Working as Application Consultant in Vistaar, which is a product based company that providescomprehensive price management functionality for all pricing processes –analytics, pricesetting, promotions planning, deal management and optimization. Have closely worked withvarious teams during my tenure to deliver efficient pricing solutions.My core responsibilities include:* Providing support for pricing software that is built into Vistaar`s platform* Environment handling for local, QA and production environments* Data Management using ETL Processes* The above also requires us to work closely and extensively with javascript and LinuxShell scripting* Automation of processes using jobs schedulers etc* Unification of technical foundation for analytics, workflow, and entity services* Also worked with databases like Oracle , SQL developer* Worked closely with testing teams which helps me better understand the software indepth as well as management of various change requests for successful deployment* Close Interaction with clients to debug issues and environment deployment