Initializing Analytics...

Business Analyst | Process Improvement, Systems & Decision Support

I'm

Business Analyst focused on diagnosing execution gaps, improving processes, and structuring operational and financial data into actionable decisions.

"Making systems easier to use, processes smoother to run, and information easier to act on."

Business Analysis Requirements & Insights Data Analysis Power BI SQL Six Sigma Green Belt Project Management
1.5+Years

Business Analysis Experience

0+

Weekly MIS Reports Delivered

2

Systems ERP & CRM Supported

69.1%
Completion Rate
Revenue
$2.34M
+12.5%
Avg. DSO
29 days
Target: <35 days
Jobs Done
1,037
+8.3%
Unbilled
$563K
73 jobs
Completion Rate69.1%
On-Time94.2%
Overdue290

What I Solve

Problems I Eliminate

Business Visibility

When leadership can't see real-time operational status, decisions get delayed. I design reporting and workflows that give leadership clear operational visibility.

  • Daily operational status reports
  • Workforce planning visibility
  • Project tracking frameworks
  • Milestone monitoring systems

Broken & Inefficient Processes

Manual processes waste hours. I automate repetitive workflows and eliminate bottlenecks in operations.

  • VBA & Power Automate workflows
  • Report generation automation
  • ERP workflow optimization
  • Manual reconciliation reduction

Cross-Functional Disconnects

When operations and finance don't talk, revenue leaks. I bridge the gap with unified reporting.

  • Operations-to-Cash tracking
  • Unbilled revenue exposure
  • Payment reconciliation
  • Cost variance analysis

Core Capabilities

What I Bring to the Table

01

Business Analysis & Reporting

Delivering daily and weekly reports used by leadership uses for workforce planning, project tracking, and risk monitoring.

Outcomes Delivered

  • 5-7 weekly reports for leadership
  • Daily operational status tracking
  • Improved turnaround time & accuracy
02

Workflow & Reporting Automation

Automating recurring reports and workflows using Advanced Excel, VBA, and Power Automate to reduce manual effort.

Outcomes Delivered

  • Automated Excel-based tracking systems
  • Power Automate workflow integration
  • Significant reduction in manual effort
03

Systems Implementation
& Process Alignment

Managing CRM administration and supporting ERP workflows for seamless operations-finance integration.

Outcomes Delivered

  • Aspire CRM system administration
  • Acumatica ERP workflow support
  • Cross-functional stakeholder alignment

Featured Work

Projects That Demonstrate Impact

Analytics Case Study

ServiceFlow Analytics

PostgreSQLPower BISQLBusiness Analysis

Operations-to-Cash Performance Intelligence — An end-to-end Business Analysis project focused on diagnosing execution gaps across operations and finance across the Operations-to-Cash lifecycle.

The project demonstrates how operational data and financial data can be unified to identify invoicing delays, revenue exposure, collections risk, and cost overruns.

Key Problems Addressed

  • Completed jobs not invoiced on time
  • Revenue exposure from unbilled work
  • Late identification of overdue invoices
  • Job cost overruns discovered too late
  • Manual reconciliation between systems
  • Delayed and unreliable leadership reporting
1,500
Total Jobs
$563K
Unbilled Revenue
73
Jobs At Risk
29
Avg DSO Days
290
Overdue Invoices
817
Cost Overruns

Dashboard Views

Executive Summary
Executive Summary
High-level snapshot for leadership.
Operations
Operational Performance
Job completion trends.
Finance
Finance & Collections
DSO tracking and AR aging.
Exceptions
Reconciliation & Exceptions
Ops-to-financial gaps.
ExecutiveExecutive
OperationsOperations
FinanceFinance
ExceptionsExceptions
344 days - Oldest unbilled job pending
$23.6K — Highest job cost variance
DSO 29 days — Within target (<35)
View Full Project on GitHub
Core Entities
  • Jobs / Work Orders
  • Customers
  • Invoices
  • Payments
  • Job Costs
Key Insights
  • 1,037 jobs completed
  • Oldest unbilled: 344 days
  • $2.34M outstanding receivables
  • Max cost variance: $23.6K
Recommendations
  • Automated unbilled alerts
  • Priority aged invoicing
  • Cost overrun early warnings
  • Weekly DSO monitoring
Documentation
  • Business Requirements (BRD)
  • Functional Requirements (FRD)
  • KPI Definitions
  • Data Dictionary

Analytics in Action

Simulated Data Flow
+12%
1,037
Jobs Completed
-3 days
29
DSO (Days Sales Outstanding)
Risk
$563K
Unbilled Revenue Exposure
Alert
290
Overdue Invoices

Professional Experience

Where I've Made Impact

DhanInfo
Business Analyst
September 2024 - Present
Nagpur, Maharashtra

Key Responsibilities & Achievements

  • Owned end-to-end business and functional requirements (BRD / FRD) for operational and finance-related reporting, working with US-based clients across operations, finance, and IT to translate business needs into implementable solutions.
  • Conducted stakeholder discussions, process walkthroughs, and gap analysis to identify execution gaps and define practical process and reporting improvements.
  • Designed process maps, SOPs, and operational workflows that improved execution clarity and standardized reporting and operational activities.
  • Led implementation and reporting enhancements across CRM and ERP environments, ensuring business requirements were accurately reflected in system workflows.
  • Delivered daily and weekly management MIS used by leadership for workforce planning, project tracking, and financial monitoring.
  • Worked closely with finance teams to validate data and strengthen reconciliation between CRM and ERP systems, improving billing accuracy and reporting reliability.
  • Automated and standardized reporting using Advanced Excel (VBA), Power Automate, and Power BI, reducing manual effort by ~75% while improving reporting accuracy and consistency.
  • Acted as functional owner for Aspire CRM and supported Acumatica ERP workflows related to invoicing, payments, and reconciliation across operational and financial processes.

Skills Matrix

Technical & Business Arsenal

Technical Skills

SQLAdvanced
Excel & VBAExpert
Power BI ReportingAdvanced
Workflow AutomationIntermediate
Python (Analysis)Intermediate

Systems & Tools

CRM AdministrationAdvanced
ERP Workflow SupportIntermediate
Financial & Operational ReportingAdvanced
Reporting AutomationExpert
Process ImprovementAdvanced

Business Skills

Business AnalysisAdvanced
Requirements GatheringAdvanced
Cross-Functional CoordinationAdvanced
Six Sigma (DMAIC)Certified
Project ManagementAdvanced
Decision SupportExpert

Credentials & Learning

Certifications That Back the Work

Six Sigma Green Belt

Process Excellence & Data-Driven Improvement Certified
1
The Context
Recurring execution gaps — reports rebuilt weekly, reconciliation errors undetected, manual workflows consuming hours.
2
What I Learned
The DMAIC framework gave me a structured way to define problems precisely, measure impact with data, and implement solutions that stick.
3
How I Apply It
Every process improvement I deliver now follows this methodology — not guesswork, but systematic, measurable, repeatable improvement.
D Define
M Measure
A Analyze
I Improve
C Control

Measurable Impact

  • Reduced manual reporting effort by ~75% through structured process redesign
  • Identified and eliminated reconciliation gaps between CRM and ERP
  • Standardized SOPs that reduced execution ambiguity
  • Built control mechanisms — automated alerts and validation checks

Excel Skills Job Simulation

JPMorgan Chase & Co. — Forage Completed
1
Key Conclusion
Shifting sales focus toward online retailer accounts would drive significantly greater sales growth.
2
The Data
Analyzed 5 years of account performance. Overall unit sales CAGR of 21% — but growth was unevenly distributed.
3
The Problem
Identified 5 accounts declining up to -73%. These underperformers consumed resources without return.
4
The Action
Recommended discontinuing underperformers and reallocating to high-potential online retailer accounts.
21%
5-Year CAGR
-73%
Worst Account
27.6%
Online Retail Share

What I Demonstrated

  • Data-driven storytelling — presenting conclusions supported by data
  • Account performance analysis using advanced Excel
  • Strategic recommendations backed by quantitative evidence
  • Executive-level presentation and communication skills

My Approach

How I Work

Structured Execution

Every report, every workflow, every analysis follows a clear structure. Reducing ambiguity improves execution. I focus on clarity in requirements, precision in execution, and consistency in delivery.

Ownership Mindset

When I take on a task, I own it end-to-end. From understanding the requirement to delivering the output to handling follow-ups, I ensure nothing falls through the cracks.

Systems Thinking

I don't just fix symptoms—I look for root causes. Understanding how operations, finance, and IT systems connect helps me design solutions that work across the organization.

Stakeholder Alignment

Good analysis is useless if stakeholders can't act on it. I focus on presenting information in ways that different audiences can understand and use immediately.

"Making systems easier to use, decisions clearer to make, and outcomes easier to achieve."
— My professional mission

Community Involvement

Volunteering & Social Impact

UPAY NGO

Outreach Secretary (Volunteer) — Nagpur Region
  • Coordinated outreach and operational activities across multiple NGO centers in the Nagpur region
  • Led volunteer communication and alignment efforts to reduce coordination gaps
  • Helped structure outreach initiatives into actionable steps
  • Supported monitoring of ongoing activities and escalated issues
Outreach CoordinationEducation InitiativesVolunteer ManagementOperations

Rotaract Club of Nagpur

Community Service Director

Led and participated in various community service and social impact initiatives.

Celebrating joy with orphans & underprivileged children
Donation drives for children & needy families
Tree plantation drives
"Clean India with Natural Pride" — Flag respect drives
Community ServiceSocial ImpactEnvironmentNational Pride
2Organizations
ActiveContributor
MultipleInitiatives Led
LeadershipRoles Held

Let's Connect

Turning Complex Business Problems into Clear, Actionable Decisions

I work at the intersection of processes, systems, and data to bring clarity where execution breaks down.

GitHub LinkedIn Email WhatsApp Resume
Dashboard Preview

Contact via Email