Sanjaykumar Enakarla Mohan

• Built a team using collaborative strategies, which generated an additional 22% profit over the previous 13%. Developed financial forecasting and cost models handling over 1 million freight records and analysed issues to understand cost-driving factors.
• Created Power BI interactive dashboards and automated ETL pipelines with triggers which reduced data quality issues and processing hours by 35%.
• Worked cost-to-revenue ratios and ROI for freight lanes, leveraged financial KPIs (budget pacing, variance) to manage spend and performance.
• Built Machine Learning algorithms (PKL) to predict the logistics costs which aids in decision-making and reduces overheads.

Tech Stack

• Built boards of regulatory, finance, and compliance for 65+ branches using Power BI and Tableau visualization tools, which improved board reviews and saving the team over 40 hours per month by eliminating manual reporting.
• Migrated over 400K records from legacy FoxPro and Excel systems into a consolidated SQL Data Warehouse. By automating reporting and improving accuracy, the error rate dropped from 5% to zero, increasing data trust for the business.
• Reduced Non-Performing Loans from 1.7% to 0.9% ($2.3 million risk reduction) by creating early-warning reports, credit-risk analyses, and querying risk details in SQL and performed root-cause analysis before problems arose.
• Analyzed loan acquisition cost, loan-to-value ratios(LTV), and revenue data, discovering a potential $700,000 in annual cost recovery, which helped optimized product ROI and recommended measures to portfolio growth for shareholder satisfaction.
• Collaborated with business, IT, and compliance teams to interpret their requirements into clear user stories and acceptance criteria for Agile projects aimed at improving reporting and system upgrades.

Tech Stack

• Analysed loan segments using Finacle core banking data and advanced Excel models to identify untapped retail portfolios and cross-sell opportunities, leading to a 15% increase in retail loan sales over two quarters of FY 2020-21.
• Compiled Corporate financial and operating statistics into an easy-to-read format with checks to prevent errors and ensure that decision-makers were looking at the right data. Automated repetitive Excel operations with Power Query and macros, which saved 30-40% of time for creating a new report.
• Worked with teams of sources to resolve data quality issues, documented problems, resulting in 15% reduction in audit related errors.
• Aided the project manager with interdepartmental coordination, and led stakeholder workshops and documentation sessions, ensuring alignment with technical teams and branch operations.

Tech Stack