DINESH KUMAR YALAGANDULA Email: adeghz@r.postjobfree.com

Associate Data Analyst HSBC Financial Services – Hyderabad Mobile: +91-998*******

LinkedIn: https://www.linkedin.com/in/dinesh-kumar-yalgandula-25662a8b

Having 5+years of experience in corporate environment with 3+ Years of experience in analytics with applying machine learning and data mining techniques to real-world problems.

M.Tech in Embedded systems with 76% from Jawaharlal Nehru Technological University Hyderabad (May 2011 – January 2014)

Good scripting and programming skills in Python, R and MySQL.

Proficient experience in Exploratory Data Analysis (Data Extraction, Transformation, Loading, Data Wrangling, Data Exploration and Data Mining).

Experience in probability distribution Random Variable, Probability Distribution Function.

Experience in statistical methods Descriptive Statistic, Inferential Statistic, Hypothesis Testing, Analysis Of Variance (ANOVA) etc.

Predictive Modelling, Machine Learning, R Programming, Text Mining & Analytics, Sentiment Analysis, Data Driven Strategy Development through Visualization Tools, Customer Segmentation, Risk Analytics.

Virtuous knowledge in machine learning techniques and algorithms, such as Linear Regression, Logistic Regression, K-NN, k-mean Clustering, Naive Bayes, SVM and Decision tree, Random Forest etc.

Data Visualization using Matplotlib, Seaborn, Pandas built in Visualization, Plotly, and ggplot2.

Familiarity with Data Visualization tools, Tableau.

DATA SCIENCE FOR ENGINEERING from IIT MADRAS (through nptel program).

Advance Certification in Artificial Intelligence & Machine Learning From IIIT Hyderabad.

PySpark and Hadoop certification from intellipaat

Organization

Designation

Duration

HSBC Financial Services

Associate Data Scientist

July 2017 to Till Date

Skilled in developing data science concepts with two testing in current process (internal)

Hands on knowledge in Data gathering, Reporting and Visualizing using Python and Excel.

Relevant technical and deliver experience in Financial Service Organization.

Experienced in stake holders/business partners management in effective communication and negotiation with Local, National & Global Regulators within the financial sector.

Enhanced researching with strong ability to provide reports with future forecasts on managing for growth.

Project 1: HSBC France Retail Banking Basel Rating System

Role: Associate Data Scientist

Description: HSBC France (HBFR) wants to redesign the Basel Rating System for Retail Banking Wealth Management (RBWM) global market, as number of gaps are identified with the current set of models which were deployed earlier. The rating system was redeveloped in 2016, but the models were never deployed as several issues were identified by the regulatory authorities and internal testing. In addition to the issues raised with the previously developed rating systems, a number of new regulations were published in the last 2 years which the Basel models will need to comply. This project aims to provide the details of the Data Quality Analysis (DQA) to assess usability and fit for purpose of the available data for PD/EAD model building.

Responsibilities:

Collecting data from data sources and portfolio data bases.

Filtering the data based on guidelines provided the management team.

Data understanding, cleaning, preparation and EDA.

Applying statistical method on discreet/continuous variables based on the standard metrics.

Analysing the data with respect to distribution of each of the valid values, total count and percentage of it in the data.

Grid chart for validation of data and Outlier treatment and handling blank values.

The most crucial variables based on WOE. Used WOE method to identify the important variables and impute missing values from the data.

Handling data imbalance.

Fitted logistic regression model on master data (with woe, balanced data).

Fitted random forests model on master data (with woe, balanced data).

Fitted decision tree model on master data (with woe, balanced data).

Final model selection based on highest values of accuracy, sensitivity and specificity.

Environment/Tools: Jupiter notebook, Python (SkLearn, Pandas, NumPy&SciPy, Seaborn, matplotlib)

Project 2: HSBC France (HBFR) - CROSS SELLING& UPSELLING

Role: Associate Data Scientist

Business Objective: Business objective is to identify the customers who are most likely to buy the investment plan and cross-sell to them. We will build a supervised learning model and use EDA (exploratory data analytics) to design a cross-selling strategy. The process of designing a cross-selling strategy involves EDA, modeling, creating and analyzing a cross-sell grid, and assessing the financial benefits of the project.

Responsibilities:

Data understanding, cleaning, preparation.

Identifying important predictors: Conduct EDA to understand and compare the response rate of the groups in each variable (e.g. marital status, number of children).

Analysing the existing products using a cross-sell grid: Determine which customers are displaying a high likelihood to buy an investment plan based on past data.

Model evaluation/validation using k-cross validation techniques. Outlier treatment and handling blank values.

Fitted and predicted the response using a classification model using Logistic regression, Random forests, Decision tree model on master data.

Final model selection based on highest values of accuracy, sensitivity and specificity.

Environment/Tools: Jupiter notebook, Python (SkLearn, Pandas, NumPy&SciPy, Seaborn, matplotlib).

Date of Birth: 28th October 1987

Languages known: English, Telugu, Hindi

Address: Plot no: 54, Motinagar, Hyderabad, Telangana.

PROFILE SUMMARY

Organization

Designation

Duration

HSBC Financial Services

Associate Data Scientist

July 2017 to Till Date

ACADEMIC CREDENTIALS

KEY EXPERIENCES AND PROJECT DRIVEN

CERTIFICATIONS:

PROFESSIONAL EXPERIENCE

SKILLS:

Organization

Designation

Duration

HSBC Financial Services

Associate Data Scientist

July 2017 to Till Date

WORK EXPERIENCE:

Organization

Designation

Duration

HSBC Financial Services

Associate Data Scientist

July 2017 to Till Date

PERSONAL INFORMATION

Organization

Designation

Duration

HSBC Financial Services

Associate Data Scientist

July 2017 to Till Date

Contact this candidate