$ whoami — Accounting · ERP · Analytics

Clear data.
Better decisions.

I work where accounting, ERP data, and analytics meet. I build reconciliation workflows, automate reporting, and turn operational data into analysis that's easier to trust and act on. My foundation is accounting and commerce; my direction is data and business analytics.

View my work → Download resume ↓

Role · Accounting Assistant Domain · Accounting + ERP Direction · Data & Business Analytics Since · May 2025

500K+ERP records processed

300K+ERP records reconciled

9.59/10MBA SGPA · Semester 1

3+Years professional experience

// selected work

from operational data to business insight

One professional system and two analytical case studies. Different problems, same approach: understand the data, make it reliable, and make it useful.

Click a card to explore the work.

01+

ERP Exam Data Reconciliation

A Python and Pandas workflow for reconciling large exam-data exports from two ERP platforms, validating records at student and subject level and isolating discrepancies for review.

Python / Pandas / Excel

Professional work

ScaleTwo ERP data dumps containing approximately 500K and 300K records were processed to compare exam records across platforms.

ReconciliationRecords were matched using roll numbers and subject codes, then classified into missing records, mismatched marks, and fully matched records before exporting clean outputs for verification and review.

reconcile.py · simplifiedimport pandas as pd
 
def reconcile(erp_a, erp_b):
  matches = match_records(
    erp_a, erp_b)
  flag_mismatches(matches)
  generate_report(matches)
  return matches

Discuss this work →

02+

Financial Collections & Receivables Analytics

An analytical workflow bringing invoice and payment data together to understand collections, aging, overdue exposure, and payment behavior.

SQL / Python / Excel / Power BI

Portfolio case study

ProblemInvoice and payment data needed validation and reconciliation before collections, aging, and overdue exposure could be analyzed consistently.

OutputA Power BI dashboard tracking collection rate, aging buckets, overdue exposure, recovery performance, and payment trends across customer segments.

01Validate

02Reconcile

03Classify aging

04Model KPIs

05Visualize

Discuss this project →

03+

Retail Sales & Profitability Analytics

A sales analytics workflow turning transactional data into product, regional, customer, and profitability analysis.

SQL / Power Query / Power BI

Portfolio case study

ProblemRaw transactions show what was sold, but not necessarily where revenue and profit are coming from. The analysis needed consistent product, regional, and customer-level metrics.

OutputAn interactive Power BI dashboard with KPI measures, time trends, drill-down analysis, and profitability segmentation.

01Transactions

02Clean & transform

03Product · Region · Customer

04Revenue · Profit · KPIs

05Power BI

Discuss this project →

// experience

professional experience

May 2025 — Present

Accounting Assistant

K.R. Mangalam University · Gurugram, Haryana

Build Python and Pandas reconciliation workflows across 500K+ and 300K-record ERP datasets, identifying missing and mismatched records and generating structured discrepancy reports.
Perform weekly cross-ERP reconciliation of student fee records, matching transactions where shared identifiers are unavailable, preventing duplicates, and applying fee-head priorities and scholarship adjustments.
Build a formula-driven Excel workflow that converts daily ERP exports from both systems into recurring fee, hostel, transport, declaration, and counter-visit reports.
Develop Python and Selenium automation to retrieve and archive student ledgers from a legacy ERP, handling session limits, re-authentication, file renaming, and document organization.
Maintain fee reports and dashboards for hostel, transport, and semester fees, with analysis by student status, gender, payment status, and outstanding balances.

Aug 2023 — Apr 2025

Legal Document Assistant

Advocate Parminder Yadav & Associates · Sohna, Gurugram

Prepared and managed legal and client documentation for property transactions, agreements, affidavits, and administrative filings, coordinating drafting, verification, record management, and submission.

// capabilities

what i work with

Data analysis

SQLPythonPandasNumPyAdvanced Excel

Business intelligence

Power BIPower QueryDAXData VisualizationKPI Reporting

Data preparation

Data CleaningData TransformationETLRelational DatabasesPostgreSQL

Data quality & automation

Data ValidationData ReconciliationAutomationStatisticsGitGitHub

Working styleI prefer traceable workflows, clear definitions, reproducible calculations, and dashboards that answer a question rather than decorate a screen.

Business contextMy accounting and commerce background gives me a practical understanding of financial processes, transactions, and the business questions behind the data.

// 2023 — 2027

education & certification

01 / Degree

MBA in Business Analytics

Amity University Online

9.59 / 10Semester 1Expected 2027

02 / Degree

B.Com (Hons)

Gurugram University

2023

03 / Certificate

Google IT Automation with Python

Google · Professional Certificate

Python / Automation

// get in touch

have a data or reporting problem to solve? let's make it clearer.

Email me ↗

LinkedIn ↗ GitHub ↗

Clear data.Better decisions.