harsimran singh dhillon

Business Analyst

Amritsar, Punjab, India 1+ yrs exp 84 · Excellent

About

Results-driven Business Analyst with 1.5+ years of experience in B2B financial services, specializing in data analysis, dashboard development, and KPI reporting. Proven ability to automate reporting workflows (85%+ automation achieved), conduct deep-dive portfolio analysis, and translate complex data findings into actionable business insights for C-suite stakeholders. Proficient in SQL, Python, and Advanced Excel; experienced in stakeholder management, BRD/FRD documentation, and cross-functional collaboration across tech, AI/ML, and operations teams. Strong foundation in credit lifecycle analytics, customer segmentation, and behavioral insight generation. SSB-recommended (Indian Army) — demonstrating leadership, strategic thinking, and performance under pressure.

Skills & Expertise (30)

Python Intermediate

7.3/10

1.5

Years Exp

Advanced Excel Intermediate

7.0/10

1.5

Years Exp

SQL Intermediate

7.0/10

1.5

Years Exp

Pandas Intermediate

6.8/10

1.5

Years Exp

NumPy Intermediate

6.5/10

1.5

Years Exp

Customer Segmentation Django Behavioral Analytics Jira UAT Testing Workflow Automation Agile Methodology Cross-Functional Collaboration Fast Learning Communication HTML CSS Financial Services PowerPoint Presentations Data Storytelling Dashboard Development KPI Tracking Root Cause Analysis Process Mapping Stakeholder Management Requirements Gathering Power Query SUMIFS VLOOKUP Pivot Tables

Work Experience

Junior Business Analyst

AdvaRisk SLO Technologies Pvt Ltd

Aug 2024 - Present

Built and maintained real-time dashboards and decomposition frameworks to track credit lifecycle KPIs — onboarding metrics, monitoring indicators, and revenue performance — across Haryana & Punjab, enabling leadership to identify trends and take data-driven decisions. Automated 85%+ of product reporting workflows using Gen-AI tools and Python scripting, achieving a 3× increase in quarterly order delivery volume (3L+ orders) while maintaining data accuracy and 100% on-time reporting. Created detailed Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs) to capture analytical requirements and support feature development — ensuring alignment between business needs and platform capabilities.

Web Development Intern

Maven Info Solution OPC Pvt Ltd

Jan 2024 - Mar 2024

Contributed to full-stack web development projects integrating front-end (HTML/CSS) and back-end technologies; collaborated within an Agile team to deliver project milestones on schedule.