D Deepali

Advanced Analyst

Bengaluru, India 1+ yrs exp 83 · Excellent

About

Finance and Data professional at Ernst & Young (EY), managing tax compliance, global payroll, and financial reporting across 14 countries for 850+ international assignees. 1.5+ years' experience handling high-volume financial data, standardizing processes, and delivering accurate year-end reporting for multinational payroll operations. Skilled in Advanced Microsoft Excel, ERP systems, and RPA-enabled workflows, with a strong focus on operational efficiency, data integrity, and stakeholder satisfaction.

Skills & Expertise (22)

Advanced Microsoft Excel Advanced

8.5/10

Years Exp

Pivot Tables Advanced

8.5/10

Years Exp

Index-match Advanced

8.0/10

Years Exp

VLOOKUP Advanced

8.0/10

Years Exp

XLOOKUP Advanced

8.0/10

Years Exp

Tax Compliance Intermediate

7.5/10

Years Exp

Power Query Intermediate

7.5/10

Years Exp

Conditional Formatting Intermediate

7.5/10

Years Exp

Financial data analysis Intermediate

7.5/10

Years Exp

Financial Reporting Intermediate

7.0/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

ERP Systems Intermediate

7.0/10

Years Exp

Stakeholder Management Intermediate

7.0/10

Years Exp

Process Improvement Intermediate

7.0/10

Years Exp

Regulatory Compliance Intermediate

6.5/10

Years Exp

Internal Audit Intermediate

6.5/10

Years Exp

Variance Analysis Intermediate

6.5/10

Years Exp

Microsoft Dynamics 365 Intermediate

6.5/10

Years Exp

Quality assurance Intermediate

6.0/10

Years Exp

Process validation Intermediate

6.0/10

Years Exp

RPA Intermediate

6.0/10

Years Exp

Tally ERP 9 Intermediate

5.5/10

Years Exp

Work Experience

Advanced Analyst

Ernst & Young (EY)

Dec 2024 - Jun 2026

Modernized shadow payroll operations, transitioning from manual spreadsheets to an automated Compensation Shadow Payroll system; onboarded 850+ international assignees and configured ERP data imports to improve reporting accuracy and scalability. Managed end-to-end expatriate and inpatriate tax compliance across 14 countries, validating compensation, taxable income, and payroll data to ensure timely, accurate, and compliant reporting. Executed year-end payroll audits and reconciliations for 550+ assignees, prepared W-2 summaries, and validated gross-up calculations. Transitioned shadow payroll from quarterly to monthly processing, streamlining data collection, authorization reconciliations, and country-specific reporting workflows. Collaborated with Automation (RPA) teams to optimize payroll reporting workflows and reduce report preparation time by 25%. Managed a newly transitioned global client portfolio, coordinating with clients, offshore teams, and tax teams to resolve data discrepancies and deliver requirements on time. Analysed high-volume payroll data using Advanced Excel (Pivot Tables, XLOOKUP, Power Query) to identify variances and support financial controllers with data-driven insights. Mentored new team members through standardized process documentation and payroll training, ensuring consistent service delivery.

Accounting Intern

Hi-Tech Projects

Jan 2023 - Feb 2023

Supported Accounts Payable, Accounts Receivable, bank reconciliations, and invoice verification; used Excel to organize and reconcile accounting data.