Treasury/ALM Analyst
Profile Code: AL-BFS-07
- ₹7 LPA (Median Salary)
- Lecture Duration 2hrs
- Course Duration 12 Weeks
Skills You Learn: Asset Liability Management (ALM) | Treasury Operations | Liquidity Risk Management | Interest Rate Risk Analysis | Balance Sheet Management | Cash Flow Forecasting | Gap Analysis | Duration Analysis | Stress Testing | Scenario Analysis | Regulatory Liquidity Ratios (LCR & NSFR) | Financial Risk Management | Advanced Excel | SQL | Power BI | MIS Reporting | Data Visualization | Financial Modeling | Banking Regulations | Analytical Thinking
Overview Video
About This Course
A Treasury/ALM Analyst in the BFSI industry focuses on managing liquidity, interest rate risk, and balance sheet optimization through data-driven analysis. This course equips learners with the skills to monitor cash flows, analyze asset-liability mismatches, and track key metrics such as liquidity ratios, funding costs, and interest rate exposures. Participants gain hands-on experience with tools like Excel, along with exposure to SQL and BI dashboards for financial analysis and reporting. The program emphasizes asset-liability management (ALM), risk assessment, and financial planning in banking and financial services. Learners will understand how to support treasury operations, optimize funding strategies, and ensure regulatory compliance. By the end of the course, they are prepared for roles in treasury and financial analytics, with career progression into risk management, treasury leadership, and financial strategy positions.
Course Content
4 modules · 12 weeks · 2hrs/dayExcel Course
The **Excel Course** covers basic to advanced concepts for Treasury and ALM (Asset Liability Management) Analysts in the BFSI industry, including workbook management, formulas, functions, data validation, sorting, filtering, conditional formatting, Pivot Tables, Pivot Charts, XLOOKUP, INDEX-MATCH, Power Query, Power Pivot, cash flow analysis, liquidity management, interest rate analysis, maturity gap analysis, balance sheet reporting, scenario analysis, What-If Analysis, Solver, dashboards, VBA automation, KPI reporting, financial forecasting, regulatory reporting, and interactive dashboards to optimize treasury operations, manage liquidity risk, and support strategic financial decision-making.
Treasury Systems Course
The **Treasury Systems Course** covers basic to advanced concepts for Treasury and ALM Analysts in the BFSI industry, including treasury operations, cash and liquidity management, fund transfers, payment processing, investment portfolio management, money market operations, foreign exchange transactions, securities management, interest rate risk management, Asset Liability Management (ALM), cash flow forecasting, balance sheet management, regulatory compliance, limit management, deal capture, settlement processing, reconciliation, workflow automation, reporting, audit trails, system integration, and treasury analytics to improve financial control, operational efficiency, and enterprise-wide treasury management.
Power BI Course
The **Power BI Course** covers basic to advanced business intelligence concepts for Treasury and ALM Analysts in the BFSI industry, including data integration, data transformation, data modeling, DAX calculations, KPI development, dashboard creation, interactive visualizations, liquidity dashboards, cash flow reporting, ALM analysis, interest rate risk monitoring, investment portfolio dashboards, forecasting visualization, drill-through reports, automated reporting, executive dashboards, compliance reporting, performance monitoring, scenario analysis, financial analytics, and business intelligence techniques to transform treasury and financial data into actionable insights for strategic planning, risk management, and informed decision-making.
SQL Course
The **SQL Course** covers basic to advanced concepts for Treasury and ALM Analysts in the BFSI industry, including database fundamentals, SELECT queries, filtering, sorting, joins, aggregate functions, GROUP BY, HAVING, subqueries, Common Table Expressions (CTEs), window functions, CASE statements, views, stored procedures, indexing, query optimization, transaction management, treasury data extraction, liquidity reporting, cash flow analysis, investment portfolio analytics, ALM reporting, financial reconciliation, data validation, and large dataset management to retrieve, transform, and analyze treasury and banking data for effective liquidity management and strategic financial decision-making.
Key Responsibilities
- Monitor liquidity and funding positions
- Analyze asset-liability mismatches
- Manage interest rate and liquidity risk
- Prepare ALM reports and dashboards
- Forecast cash flows and funding requirements
- Support balance sheet management
- Analyze investment and borrowing strategies
- Monitor regulatory liquidity ratios
- Perform gap analysis and duration analysis
- Conduct stress testing and scenario analysis
- Ensure compliance with treasury and regulatory guidelines
- Collaborate with finance, risk, and treasury teams
- Optimize funding costs and profitability
- Support capital planning initiatives
- Recommend data-driven treasury strategies.
Growth Path
Tools Used
Perfect For
Fresh Graduates | B.Com Graduates | BBA Students | MBA Finance Students | M.Com Graduates | Banking & Finance Aspirants | Treasury Professionals | Risk Management Professionals | Financial Analysts | Corporate Finance Executives | Operations Professionals | Career Switchers | Anyone Interested in Treasury & ALM Careers in BFSI
Fee Structure
Mentor
Analytics Learners
Professional Analyst & Mentor
Explore Various Career Paths in BFSI
Related analyst roles inside the same industry.
