Resume

Projects

Bank Loan AnalysisTools – Excel, Power BI, SQL

• This project gives an overview of key loan metrics such as total applications, funded amounts, received amounts, average interest rates, and debt-to-income (DTI) ratios, enabling the bank to monitor their lending performance.

•It breaks down loan data by various factors like purpose, employee tenure, home ownership status, and geographic location, helping the bank identify trends and target segments for lending.

• The dashboard visualizes the distribution of good and bad loans, allowing the bank to assess risk and potentially adjust lending criteria or collection strategies.

​

"Banking Data Insights: SQL Analysis and Power BI Visualization"

  SQL Data Analysis:

• Executed complex SQL queries on banking datasets to extract customer insights, assess loan distributions, and evaluate banker performance, supporting targeted business strategies and operational efficiency

• Power BI Development:

• Designed and implemented a comprehensive Power BI dashboard that visualizes loan data, demographic insights, and market trends. Utilized advanced features like DAX formulas, dynamic visuals, and interactive filters to deliver actionable business insights and facilitate data-driven decisions.

• Technical Skills:

• Demonstrated expertise in SQL, Power BI, data modeling, and statistical analysis. Skilled in transforming raw data into clear, informative visual reports that aid in risk assessment and strategic planning.

•  

HR Analysis project Tools – Excel, Power BI

•Designed an interactive dashboard that provides insights into employee attendance, work from home percentages, and sick leave trends over time, enabling data-driven decision-making for workforce management.

• Incorporated tabular data displays to showcase employee-level details such as attendance percentage, work-from-home percentage, and sick leave records, providing granular insights into individual performance.

•The key highlights are the visualizations tracking attendance metrics, the ability to view data at different levels, and the presentation of actionable insights for workforce planning and management.