SHIVANI BODDINAGULA

Results-driven underwriter with expertise in Advanced Excel, Power BI, and SQL. Proven ability to automate reporting and optimize workflows, enhancing compliance monitoring and risk assessment across BFSI portfolios.

• Business Analyst Certification
• Advanced Excel – Udemy
• Power BI, SQL – Udemy
• Agile & Scrum – Udemy
• Six Sigma – Udemy
• PMI-ACP (in progress)

Crowdfunding Data Analysis, Excel, Power BI, Built a data model and calendar table to track campaign performance., Transformed epoch dates, created KPIs (funding success rate, campaign duration, backer growth)., Designed dashboards in Excel/Power BI for project performance insights. Insurance Analytics, Tableau, MySQL, Excel, Analyzed insurance policy data (premium growth, claim status, payment trends)., Developed dashboards with KPIs such as Premium Growth Rate, Total Policies, Claim Amounts., Helped identify cross-sell opportunities and payment compliance issues. Credit Risk Management (College Project – HDFC Loan Defaults), Predicted likelihood of loan default using dataset with borrower details., Performed exploratory data analysis, grouped by risk category, and built reporting KPIs., Recommended risk-mitigation measures to improve portfolio quality.

• Assessed risk and analyzed client profiles for policy underwriting across BFSI portfolios.
• Utilized Advanced Excel (Pivot Tables, Power Query, SUMIFS, COUNTIFS) to automate reporting and improve accuracy.
• Built Excel dashboards to monitor policy renewals, premium growth, claim status, and payment trends.
• Created Power BI reports to visualize policy performance and premium growth trends.
• Designed trackers for compliance monitoring, reducing manual errors and ensuring regulatory adherence.
• Collaborated with cross-functional teams applying Agile methodologies for process improvements.
• Supported process improvement initiatives by optimizing policy workflows and data validation.

• volunteer in YFS HYDEERABD Organization