Ansh Mahajan

Associate Consultant

Pune, Maharashtra, India3 yrs 7 mos experience

AI EnabledAI ML Practitioner

Key Highlights

Expert in data analytics with a focus on finance.
Proven track record in automating reporting processes.
Strong leadership experience managing high-performing teams.

Stackforce AI infers this person is a data analytics professional with a strong focus on financial services.

Contact

Skills

Core Skills

Data AnalysisFinancial Modeling

Other Skills

AlteryxAlteryx BI + Visualization SolutionsAnalytical SkillsArtificial IntelligenceArtificial Intelligence (AI)Business Intelligence (BI)Client ServicesDashboard BuildingDeadline ManagementDeep LearningExcelFundamental AnalysisGCPJavaMachine Learning

About

Dedicated profession with strong skills in the fields of data analytics and finance. Completed Bachelors of Business Administration degree with dual specialization in Finance and International Business from Symbiosis Centre for Management Studies, Pune. Completed another Bachelors in Science in Data Science from Indian Institute of Technology, Madras. 3 years of experience as a 'Portfolio Analyst' with high proficiency in Excel, SQL, Power Query, Power BI, Tableau, Alteryx, Python (Numpy, Pandas, Sci-kit, PyTorch, PySpark) and GCP along with strong fundamental knowledge of Machine Learning and Artificial Intelligence (NLP and LLMs)

Experience

Deloitte

Audit & Assurance Consultant

Jun 2025 – Present · 9 mos · Bengaluru, Karnataka, India · Hybrid

Bny mellon

Portfolio Analyst (CLO - Collateralized Loan Obligation)

Aug 2022 – Jun 2025 · 2 yrs 10 mos · Pune, Maharashtra, India

Provided collateral, administrative and fiduciary services to CLO Managers to manage and maintain their portfolio.
Utilized Solvas, SSRS, GCM, IMMS, Deal Manager and Nexen to deliver accurate reports and CF for the CLO.
Responsible for successfully handling 25+ Warehouse closings. Efficiently communicating with CLO Manager, Internal Teams and other stakeholders to get the final WH docs agreed (Flow of Funds, Carry, etc).
Interpreting Indentures, WH Deeds and other legal documents to ensure correct procedures are followed on the deal.
Daily reconciliation of Portfolio Tests such as Interest Coverage, Over-Collateralization, Industry Classification, Rating Factors and Recovery Rates
Reduced data processing time by 83% by developing an automated Excel-based reconciliation tool, significantly enhancing reporting efficiency and timeliness. - Led a high-performing 10-member team, managing workflow, mentoring new hires, and ensuring seamless project execution.
Strengthened client relationships as the primary BNY representative, facilitating smooth communication and query resolution.
Ensured timely deliverables by coordinating daily with cross-functional teams across Dublin, Wexford, and London, optimizing collaboration and turnaround time.