Raju P

I used to take application from customer who need vehicle loan and send details for approval,Finally at week end and month end i used to prepare origination report like Applied%, Approved%, Booked%, Cancelled% etc and display the analysis in excel charts for visualization to my manager.

• Analyzed sales data regularly to monitor progress towards goals and make necessary adjustments to strategy as needed.
• Created and implemented successful sales campaigns to drive leads and increase sales.
• Boosted sales revenue by cultivating strong client relationships and implementing effective sales strategies.

I have done analysis part in Civil Engineering.I was responsible for data visualization part in excel for the count of man power working in my company by day wise & weekly wise report .i have also done analysis for quantity of concrete ,steel,sand are utilizing in monthly and weekly reports are been taken accordingly .Total cost analysis are been done once in a month ,i also used Pivot tables for this process.

• Identified trends and patterns in complex datasets, driving strategic recommendations for process improvements.
• Leveraged advanced statistical techniques to uncover hidden opportunities for cost savings or revenue generation.
• Conducted ad-hoc analyses for specific business needs, providing valuable insights on demand.
• Improved data accuracy by conducting thorough data cleansing and validation processes.

• Support world-leading bank from North America, in terms of providing data management and business intelligence reporting support for product portfolio monitoring and insight generation on a periodic reporting and visualization to the client support system (CSS)
• Maintain database management and DataModel design for regular reporting
• Prepare data model design from source file Origination data to Account Management and Collection Strategy
• Connect data from citrix (Transactional data) to SAS using Unix platform and prepare period dataset and combine data into meaning full pattern for regular reporting
• 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 data manipulation and analysis using SAS Base and Advanced Programming
• Design complete data flow design to reporting process and prepare various check points for analysis and adhoc request support
• Design complete data visualization support to demise excel regular MIS reporting to excel dashboards
• Portfolio Insight generation and reporting
• Prepare data driven complete solution from origination to account management for partners
• Prepare origination Data and analysis to Production folder for making it dynamic access for various MIS based on application to customer and associated account level information
• Prepare more data driven MIS report based on origination with product specific and region-specific market trend analysis
• Prepare Retail credit 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) and customer type (Premier, Advanced and Retail)
• Prepare reports on associated customer from relationship type to customer type as sole and joint
• Prepare periodic performance for each product category number of active customer and balances, Risk weights assets, Delinquency by (#) and ($) group by (0-29,30-59,60-90,90+, CO), new origination and new balance, average loan per account from history to current, roll rate analysis for current to x and x+2, prepare good vs bad rate customer
• Review loans in portfolio to ensure the credit union remains adequately secured by the collateral and that the borrower continues to have the ability to repay the loan
• Also responsible for identifying potential problem loans and making recommendations to Loan Committee
• Prepare life time value analysis for product specific
• 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
• Design multiple excel pivot reporting and automation of excel reporting process.