Alok Ranjan Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

Bengaluru Area, India

As Chief Data Scientist Oct 2020-Present  Worked on building a Customer Lifetime Value system for the organization which helped them to retain customers and reduce their churn rate by 20% used SQL, Python and tableau Worked closely with Retail clients in identifying the target market segment and highlighting difference between client and market gap used Power BI and Excel, helped them in bringing the change in the product as per the new market, and guided clients with the launch of the new product Directed and guided a team of Data Scientist on various analytical projects of different industry like Retail, Insurance, Lending, Pharma, Manufacturing and others used Python, R, SAS, Power BI and Tableau As Senior Data Scientist Apr 2016-Sep 2019  Worked on various projects related to data analytics and data Science from different domains such as Retail, Health Care, automobile, E-Commerce, and BFSI using Python, R, or SAS depending upon client preference Used different Machine Learning Algorithms such random forest, GBM, XG Boosting, KNN to Predict Metabolic Rate of a car driver in three different tasks in one of the research projects of an automobile company Provide customized reports to corporate clients based on the data provided and their needs.As Senior Data Analyst Feb 2014-Mar 2016  Worked with the organizations to identify their KPIs and prepare a dashboard for effective decision-making used Power BI, Excel and Tableau Provide analytical solutions to corporate clients and resolve their issues using statistical methods such as correlation, Chi-Square test, Anova, Significance test, Regression. As SAS Consultant Sep 2012-Jan 2014  Working on Insurance claim amount settlement for a UK-based insurance used SAS SQL, SAS MACRO and SAS Graph module. Coached managers and mid-level managers in SAS, Advanced Excel, statistics, and reporting for decision-making.

Key Deliverables:Involved in corporate training for base SAS as well as advance SAS.Provided support to prepare study material related to SAS.Provide SAS related solution to the corporate clients and resolve their issues.Key Highlights: Handled a group of 25 students and trained for base SAS certification. Completed SAS base and advance training for approximately 6 batches each of min 5 students successfully. Awarded as best trainer award in the organization.

Project Title: - Loan Appraisal and NPA (Non Performing assets) ManagementDescription: - • Prepared flow chart and documented the current procedure of loan appraisal followed by BOM and critically examine it and suggested some effective way to improve it further. • Analyse the financial statement of borrower and forecast it. • Developed a risk calculation model specifically for SME Borrower.• Explored key financial ratios to look before sanction of any loans• Recommendations to management to reduces its NPA like Effective Loan Appraisal Process Collection of stock data and financial statements on half years bases

• Involved in development of front end page and corresponding action classes using Struts Framework.• Involved in development of error page and handling different types of error that end user can face using our software.• Worked on peers codes review and testing. • Provided support to Client on Database Maintains in Cincinnati.• Resolved Technical Issues related to centralization of database.

Certificate Program, Analytics Data Science & Machine Learning

Mba, Finance

Management Research Project Project title: - A Study on Merger n Acquisition in Indian Scenario during 2000-2010 Description.

Be, Computer Science And Engineering