Huzaifa Rehan

Automated portfolio analytics for 250+ Pakistan Investment Bonds (PKR 1.2T) by developing a Python ETL pipeline that generates cashflow projections and mark-to-market valuations. Reduced reporting time by 60% through Excel dashboard with smart filters and real-time maturity tracking across 2,600+ payment schedules, enabling real-time risk assessment and yield calculations for bonds with varying purchase dates.

Investment Intern at State Life Insurance (2025-06 – 2025-07)

• Automated portfolio analytics for 250+ Pakistan Investment Bonds (PKR 1.2T) by developing a Python ETL pipeline that generates cashflow projections and mark-to-market valuations.
• Reduced reporting time by 60% through Excel dashboard with smart filters and real-time maturity tracking across 2,600+ payment schedules, enabling real-time risk assessment and yield calculations for bonds with varying purchase dates.

Risk Management Specialist at ibex (2023-06 – 2023-08)

• Identified 15 fraudulent claims from 250+ flagged accounts by analyzing previous claims and customer behavior patterns using Salesforce CRM for Allstate Insurance.
• Executed cross-departmental verification with US-based teams to validate sales receipts and policy documentation, ensuring compliance across high-risk accounts as part of 20-member risk operations team.

Operations Strategy Intern at Mazalon Fancy Yarn (2021-07 – 2021-09)

• Optimized operational efficiency by proposing cost-reduction initiatives and streamlined cross-departmental communication for 50+ employees across 5 production units using intercom systems and shift management protocols.
• Digitized labor management for 50+ machine operators by building Excel-based attendance and wage calculation system, reducing administrative processing time by 25%.

BS in Economics & Mathematics – Institute of Business Administration, Karachi (2022 – 2026)