Data Analyst
Resume:
DINESH KUMAR YALAGANDULA Email: ******.****@*****.***
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