Shivi Jalan

Shivi Jalan

Accounting Analyst

Gurugram, HaryanaAccounting and Accounts Receivable
7roles
55skills
2education
3credentials

About

Accounting Analyst with around 1 year of experience in Order to Cash, Cash Application, Accounts Receivable, payment posting, reconciliation, balance adjustments, and financial reporting.

Experience

Accounting Analyst

Optum Global Solutions

Jul 2025 - Present · Gurugram, Haryana, India

Managed Workers’ Compensation AR files from Regions Bank, updated client account payment balances, and supported day-end reporting. Reviewed payment history, aging items, bad debt balances, open account balances, and supporting records for AR resolution. Prepared balance adjustments, write-offs, debit memos, and credit memos. Applied payments in Oracle to correct client accounts, invoices, and balances. Performed bank statement and account reconciliation and reviewed discrepancies involving unapplied cash, short payments, overpayments, and open items. Coordinated with onshore partners and account managers to resolve balance issues and payment discrepancies. Automated daily status reporting using Advanced Excel, Power Query, PivotTables, and formulas, saving approximately 5 hours per week per resource, and trained peers on process and reporting steps.

Student union member

Janki Devi Memorial College

10 mos · Delhi, India

Media and marketing associate

Enactus JDMC

11 mos · Delhi, India

Project coordinator

Pehchaan The Street School (Trust)

2 mos · Delhi, India

Project Management Intern

Pehchaan The Street School (Trust)

3 mos · Delhi, India

Member

Anubhuti

1 yr · Delhi, India

Dramatics society of JDMC, DU

Sponsorship team member

AAMDANI - Finance and Investment Cell, JDMC

10 mos · Delhi, India

Education

Delhi University, Delhi

Bachelor of Commerce (Honours), Commerce

Nov 2022 - Jul 2025

CGPA: 6.4/10

B.B.L Public School, Bareilly, UP

Senior Secondary School, Commerce

Apr 2022

82%

Skills

Order to Cash (O2C)Cash ApplicationPayment PostingOracleBank Statement ReconciliationAccount ReconciliationUnapplied CashShort PaymentsOverpaymentsWorkers’ Compensation AREOB ProcessingInvoice ReviewClient Balance ReviewCredit Adjustment SupportDebit/Credit MemosWrite-OffsAdvanced ExcelPower QueryPivotTablesXLOOKUP/VLOOKUPCOUNTIFS/SUMIFSData CleaningMIS ReportingReport AutomationProcess ImprovementAudit AccuracyDocumentationStakeholder Follow-UpOnshore CoordinationTeam TrainingGenerative AITally ERPMicrosoft ExcelAdobe PhotoshopCanvaFigma (Software)Adobe XDAdobe IllustratorTeamworkTeam BuildingAccountingFinancial AccountingCost AccountingFinanceSocial Media Optimization (SMO)Social Media MarketingProject PlanningSponsorshipProject ManagementMarketingSponsorship RelationsEvent ManagementGraphic DesignUser Interface DesignDramatic Literature

Volunteering

Social Work Volunteer

Pehchaan - The Street School

College Administration and Event Support

College Administration & Event Support, JDMC