Rishav Raj Email & Phone Number

Bengaluru, Karnataka, India

Maintain Database Management and DataMart Design for Regular Reporting● Prepare data model design from source file Origination data to Account Management and Collection Strategy.● Prepare DataMart for 1. Origination Data, 2. Account Performance Data 3. Collection strategy Data.● Design data model to capture information mapped from Account Origination and booked account to account performance.● Prepare delinquent, charged off account datasets on a periodic basis for collection strategy reporting.Automation and Streamlining Projects● Prepare regular reporting and automate the redundant reporting process in SAS Macro / SQL and Excel.● Prepare data manipulation and analysis using SAS Base / SQL Server and Advanced Programming (Python).● Design complete data flow design to the reporting process and prepare ETL various check points for analysis and ad hoc request support Data management.● Design data visualization to drill down analysis on Tableau , Microsoft Power BI Portfolio Insight Generation and Reporting● Prepare a data driven complete solution from origination to account management for partners.● Prepare origination DataMart from EDW to Production folder for making it dynamic access for variousMIS based on application to customer and associated account level information.● Prepare more data driven MIS reports based on origination with product specific and region-specific market trend analysis.● Prepare Retail Loan analysis funnel for the application received to approved, cancelled, declined, booked and funded. Compare received to approve rate and approve to booked rate and overall booked rate.● Prepare application with approval based on score, exceptions (TDSR, GDSR, INCOME, SCORE, LTV) andcustomer type (Premier, Advanced and Retail).Data Visualization● Prepare Origination and Performance reporting to create multiple dashboards for drill down analysis and specific KPI metrics for both secured and unsecured products.

Bengaluru, Karnataka, India

Optimizing business performance and enhance data-driven decision processes. Committed to delivering strategic solutions.Collect daily usage data from the source file from subscriber recharge to usage information and append the source file to history for creating advanced Data marts..● Prepare daily and weekly MIS reports on activation summary to the customer performance tracking over time. Make ad hoc support for quick insight presentation. regular lead management interaction for ongoing business snapshots and recommendation● Develop strategy meeting analysis and PPT ready for monthly and QTRLY review with circle head and regional product and management heads.● Segment customers based on usage and revenue to track their performance over time. timely trigger the behaviors and work on customer retention strategy● Develop strategy using advanced analytics techniques like regression, segmentation model to predict the future behavioral pattern and recommendation to competitive strategy offers.● Migrate excel based reporting and visualization to advanced data visualization applications like Tableau / Power BI. Develop associative data model to KPI metrics and signoff charts and dashboard to the business for regular reporting and process migration● Modified tool’s to entirely automate individual customer level product pricing and discount offer tasks of the Thailand Banking Client which increase its efficiency by more than 25+ %.● Lead the Credit Risk Analysis Team in Loan Department for Mortgage Loan Section for better understanding of the loan & Product behaviors with continuous monitoring and comparative behaviors of Bank Product’s (Loan)● Assessed and determined change in customer buying behaviors after interaction with the Design department and proposed recommendations to the senior management and cross-functional teams for better approach.

Bengaluru, Karnataka, India

Transforming raw data into actionable insights. Data visualization, statistical analysis, and strategic decision-making. Driving business intelligence. Translating complex findings into understandable strategies for organizational growth.

Bengaluru, Karnataka, India

Worked Here as A Junior Data analyst Learning a lot about this filed getting exposure to real life scenario.

Bengaluru, Karnataka, India

Building a SQl Server Database from scratch in IBM db2 for storing and manipulation DATA Prioritizing Financial analysis by developing strategic filters using SQL and SAS queries on opensource datasets. Identified 1000+ distressed transaction in different Account by using Excel & SQL and representing (Visual) them using Microsoft Power BI.

Delhi, India

Traced GDP , GNI, ADDHAR Card , Population Metrices of India, with 200 countries in the past 30 years and estimated missing value through historical and geographical similarities from open-source databases using Python. Detected trend anomalies and outliers by building data visualization dashboards using Tableau.

Master'S Degree, Environmental Engineering Technology/Environmental Technology

Associate'S Degree, Data Processing And Data Processing Technology/Technician, A

Activities and Societies: Big Data, Apache Spark. Harnessing the power of distributed computing for large-scale data processing. Efficient.

Science College, Honour Geology