Summary
Overview
Work History
Education
Skills
Timeline
Generic

Bommana Vansi Krishna

Hyderabad

Summary

Accomplished Senior Data Analyst with a proven track record at Proclink Consulting Services LLP, adept in leveraging SQL and Python for advanced analytics and business intelligence. Streamlined data workflows, enhancing decision-making efficiency by 30%. Expert in data modeling and credit risk analysis, with a knack for transforming complex data into actionable insights.

Overview

3
3
years of professional experience

Work History

Senior Data Analyst

Proclink Consulting Services LLP
12.2022 - Current
  • Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
  • Streamlined data analysis workflows for increased efficiency and faster decision-making processes.
  • Leveraged text, charts and graphs to communicate findings in understandable format.
  • Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
  • Spearheaded the implementation of dashboard visualization tools, providing actionable insights for stakeholders and decision-makers.
  • Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
  • Created and automated data visualizations to present insights and tell compelling stories.
  • Provided guidance on data governance policies to ensure compliance with industry regulations.
  • Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Executed overall data integration, cleansing, manipulation, aggregation, data model designing and process improvement for reporting and visualization within credit risk analytics platform from application (origination) facility file to decision file and account performance in SQL, SAS and Python
  • Develop KPI metrics for ad-hoc support and insightful reporting on the application funnel to provide business snapshots on the number of applications received, approved, booked, canceled and declined on daily, weekly and monthly reporting in Excel and Power BI visualization.
  • Design a data model on account performance to prepare a report on delinquent vs non-delinquent accounts and further classify the delinquency by buckets and the customer move by roll rate analysis and loss rate calculation by accounts and dollars. Create a collection strategy for delinquent accounts before they go into Charge OFF and try to track the performance by risk segment.
  • Prepare Performance MI reporting comparing default vs non-default based on

o Active vs Inactive base

o Delinquent vs non-delinquent (# and $)

o Delinquency (Roll Rate, Flow Rate, Cure vs improved Rate)

o Balance Control Ratio (Good Loan Per Account/Bad Loan Per Account).

  • Conducted credit risk analysis by analyzing risk parameters such as the probability of default, value-at-risk, risk-weighted and activity ratios.
  • Strong DBMS Programming, MIS reporting, KPI Metric design and drill down dashboard making, Automation, Customer Analytics, Churn and Retention Analysis, Credit Risk Analysis and Strategy Building, Product Marketing Cross sell – Up sell Analysis.
  • interpreting and analyzing data to drive successful business solutions. Experienced in data analysis and creating deliver insights and implementing action-oriented with complex data management, reporting and visualization.









Data Analyst

Transol Systems PVT LTD
02.2021 - 12.2022
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Utilized data visualization tools to effectively communicate business insights.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Participated in requirements meetings to understand business needs.
  • Used statistical methods to analyze data and generate useful business reports.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Enhanced business efficiency by identifying trends and patterns in complex datasets.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Analyzed transactions to build logical business intelligence model for real-time reporting needs.
  • Developed customized reports, summarizing and presenting data in visually appealing format.
  • Created data models to support decision-making processes.
  • Created dashboards to monitor and track key performance indicators.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Assisted with creating data cubes and OLAP models to improve data analysis.
  • Executed overall data integration, cleansing, manipulation, aggregation, data model designing and process improvement for reporting and visualization within credit risk analytics platform from application (origination) facility file to decision file and account performance in SQL, SAS and Python.
  • Streamlines Excel-based reporting to advanced data visualization applications like Power BI within more insightful and storytelling KPI dashboards. Overall business impact 30%-man hours reduced.
  • Develop KPI metrics for ad-hoc support and insightful reporting on the application funnel to provide business snapshots on the number of applications received, approved, booked, canceled and declined on daily, weekly and monthly reporting in Excel and Power BI Visualization.

Education

B.Tech - Civil Engineering

C. V. Raman College of Engineering
Bhubaneswar
2018

Diploma - Civil Engineering

Utkal Gourav Madhusudan Institute of Technology
Rayagada
2015

Skills

  • SQL
  • SAS
  • Power BI
  • Advanced Excel
  • Python Programming
  • Business Intelligence
  • Advanced analytics
  • Data and Analytics
  • Data Modeling
  • Business Analysis
  • Tableau
  • Data Mapping
  • Financial Data Analysis
  • Credit Risk Analysis

Timeline

Senior Data Analyst

Proclink Consulting Services LLP
12.2022 - Current

Data Analyst

Transol Systems PVT LTD
02.2021 - 12.2022

B.Tech - Civil Engineering

C. V. Raman College of Engineering

Diploma - Civil Engineering

Utkal Gourav Madhusudan Institute of Technology
Bommana Vansi Krishna