Amit Kolwankar

Led the Data Analytics team, delivering end to end analytical support across multiple business areas by developing data driven solutions, streamlining reporting processes, and producing actionable insights for strategic decision making.

• Loan Trading Desk Support (Buy Side): Delivered mortgage portfolio analytics across Agency, Non QM, DSCR, Performing, Re Performing, and Non Performing loans; identified risk flags and data gaps; produced reports for risk models (Loan Performance, Fitch DV01, S&P).
• Trade Settlement & Onboarding: Validated due diligence, servicer feeds, valuation reports, cash flow, and delinquency records to ensure integrity of purchased loans, preventing repricing risks and ensuring accurate pool tagging.
• Secondary Market & Loan Sales: Supported loan sales and securitizations with detailed risk model reports, enabling accurate pricing, investor transparency, and effective risk assessment.
• Secured Lending Analysis: Conducted portfolio reviews, identified data gaps, and loaded accurate datasets to ensure funded loans aligned with advance rates.
• CCAR Regulatory Reporting: Managed monthly CCAR submissions of loan exposure data under strict deadlines; coordinated teams, facilitated risk communication, and ensured compliance with FRB updates.
• Portfolio Surveillance: Compiled monthly surveillance reports tracking Prepayment Rate, Default Rate, Coupon Drift, Seller Concentration, Loss Modifications, Bankruptcy/Foreclosure/REO activity, Shortfalls/Write offs, and Rating Changes.
• Risk Weighted Asset Analysis: Conducted PD, LGD, EL, and EAD assessments across diverse loan portfolios, applying quantitative models to measure and mitigate credit risk.
• Automation & Efficiency: Drove automation initiatives to streamline data sourcing, reporting, and tracking, reducing manual work and improving accuracy.
• Managerial Leadership: Directed daily operations including task delegation, project reviews, stakeholder communication, and performance management; oversaw hiring, cross training, resilience planning, and training programs.
• Critical Projects: Led database transition, reporting framework development, analytics workflow optimization, and UAT/PROD testing; established efficient desk request tracking and proactive team notifications.

• Payment Clearance & Settlement Regulatory Reporting: Managed end‑to‑end reporting processes, ensuring compliance with regulatory standards and internal controls. Coordinated with cross‑functional teams to provide accurate clearance and settlement data, reconcile discrepancies, and investigate significant variances. Engaged governance groups for updates, and secured senior management sign‑offs through detailed decks and presentations.
• MIS Reporting & Analysis (Client Onboarding): Designed and delivered MIS reports including Past Due, Aging, and Client Compliance. Consolidated data from multiple sources, validated accuracy, and created dashboards/decks for management review. Implemented automation solutions using Tableau and Alteryx, reducing manual effort and improving efficiency.
• Automation & Efficiency: Identified processes suitable for automation, recommended tools (Alteryx, Tableau, Xceptor), and managed weekly status calls. Coordinated training sessions to enable teams to self‑build automation solutions, streamlining workflows and strengthening governance.

• Mortgage Portfolio Analytics: Delivered comprehensive analytics across Agency, Non Agency, Performing, Re Performing, and Non Performing loan portfolios, providing end to end support for trading and risk assessment. Identified risk flags and data gaps, ensuring clean datasets for downstream models. Produced summary and loan level reports serving as inputs to performance and pricing models including Loan Performance, Fitch DV01, and S&P, enabling accurate valuation, trading strategies, and investor transparency. Collaborated with stakeholders to translate analytical findings into actionable insights for strategic decision making.
• Secured Lending Analysis: Conducted in-depth reviews of mortgage portfolios to assess collateral quality and lending risk. Identified and remediated data gaps by validating inputs from servicer feeds, valuation reports, and delinquency records. Loaded accurate datasets into internal systems to ensure funded loans aligned with advance rate requirements, reducing repricing risk and strengthening operational integrity. Partnered with risk and operations teams to enhance data governance and improve the reliability of secured lending decisions

• Loan Application Review: Conducted comprehensive borrower eligibility assessments by reviewing Form 1003 applications, income documents (Paystubs, W2, 1099, 1040), credit histories, and property valuation reports to ensure strict compliance with underwriting standards and regulatory guidelines. Verified authenticity and accuracy of documentation, identified discrepancies or risk factors, and recommended approval, suspension, or decline decisions based on creditworthiness and debt to income ratios. Collaborated with applicants and cross functional teams to obtain missing information or clarifications, ensuring timely and accurate loan processing while mitigating potential risks.
• Queue Management & Managerial Oversight: Directed daily underwriting operations by overseeing loan queues to meet SLAs, delegating tasks, and guiding team members to achieve performance goals. Collaborated with cross functional teams to resolve loan discrepancies, implemented process improvements that enhanced efficiency and reduced operational risks. Provided leadership in recruitment, training, and cross training initiatives, fostering a collaborative, compliant, and resilient work environment.

• Client Engagement & Sales Planning: Played a key role in product sales and planning for hydraulic and pneumatic cylinders, including client visits, cost negotiations, and billing discussions and strengthened customer relationships.
• Prepared and delivered weekly and monthly sales reports to management, offering insights into sales performance and pipeline status to inform strategic decisions.