WorkExperience

COFORGE

  Senior Power BI Developer/Senior Data Analyst                                                                                                                               Aug’21–Present

Banking & Financial Services

§ Built a forecast engine for customer to predict monthly advances using various regression algorithms in RStudio and designed a comparative analysis dashboard in Power BI between actual and predicted advances for a blue-chip project.

§ Outlined and designed financial statement summary Power BI dashboards to be used in the year-end review and annual reports of the client.

§ Developed forbearance delinquency and inventory tracker dashboards to identify month-on-month forbearance movement of a borrower based on various delinquency categories and forbearance exits breakdown.

§ Built a monthly payment monitor to track on-time consecutive payments and identify a redefault date for spotty pay and redefaults.

§ Designed and built an early buy-outs tracker for the customer to identify various factors such as Fees, SWAPS, redeliveries, etc.

§ Built a churn prediction model to reduce the customer churn by 15% using Kaplan-Meier and Cox-Proportional Hazards Model.

§ Conceptualized and built Customer 360 dashboard to calculate and optimize customer’s lifetime value with the bank based on their churn prediction.

§ Successfully refactored and migrated existing tableau dashboards to Power BI dashboards.

Team Management

§ Managed stakeholder communication for the customer with daily, weekly updates and red flags if any.

Power BI Developer/Data Analyst                                                                                                                                                         Aug’19 –July’21

Business

Continuity Plan

§ Designed Power BI dashboards to derive macro and microeconomics from global, US view by state and county and India view by state and district.

§ Conceptualized and created Power BI dashboard for Business Continuity Plan amid Covid crisis, where employees can start working based on their department and location.

§ Developed a time series forecasting algorithm to predict Covid outbreak and how it affects the Business Continuity Plan.

HR Analytics –Workforce Attrition

§ Implemented system to minimize workforce attrition with an accuracy of 90% using various classification algorithms

§ Designed and developed HR Analytics dashboard for the senior management to reflect the main reasons of employee churn and prescriptive strategies based on an employee 360 dashboard.