Arun Kumar A Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

Integral part of Derivatives Centre ofExcellence Team, worked extensively onRegulatory Reports, Accounting and FX datastrategy automation project.1. Reported FR 2436 - Semi annual report onderivatives activity for Q42023, Semi-annualforeign exchange volume survey for April &Oct 2023 , TFC1 and TFC 2 for Q2 2023, TIC BCand TIC BQ (nostro balances) on monthly and quarterly basisrespectively.2. Developed automated reports for Semi-annualsurvey and Triennial survey reports working with cross functional team providing them with thelogic and performing UAT before it went live.3.Spearheaded Power query and SQL decodingproject to decode automated files for betterunderstanding and audit compliance.4.Performed MAE's, GL reconciliation on weekly basis and monitored dashboard to bring DNRA database in line with GL.

Bengaluru, Karnataka, India

1.FR Y14 (CCAR, 14Q, 14A) "Capital Assessment and Stress Testing" Report. Worked on 14Q Schedule G (Pre Provision Net Revenue) specifically and served inputs for Comprehensive Capital Analysis and Review, Dodd Frank and Stress Testing projections on a quarterly basis to the Federal Reserve Board via Axiom.2. Managed the Tableau analytics dashboard for 14Q Report and also spearheaded the transition of Axiom database for Tableau data to the web version via GOS connectivity implementation.3. Awards and Recognition - Step up award for 2nd quarter. Spotlight award from US management for owning Tableau dashboard for Q3 data analytical review of all schedules of 14Q Report.

Bengaluru, Karnataka

Financial Planning & Analysis| Financial System Re engineering( Global Employee Exchange Management and Contract Compliance)1.Spearheaded and streamlined GST inputrecovery process on Airfare tickets, workingwith external vendors, GIP team and Indirecttax team towards $127K recovery for FY 18-19and 19-20.2.. Recovered $255K of US sales tax wronglyaccrued and paid to the CA and Texas Salestax authorities for FY 20-21.3. Developed and Implemented Data Analyticsand Reporting for Global Employee ExpenseManagement Team using Power BI.4. Performed complex reconciliations in businesstravel account to resolve late payment levyfrom supplier.5. Created collaborative workspace for team using tools from Microsoft environment to facilitate hassle free remote working

Bengaluru, Karnataka, India

Financial Systems Re-engineering.1. Data analytics and reporting using Power BI - Worked in the 'Global Employee Expense Management Team' and made available worldwide data analytics and reporting to the team and its users using Power BI thus automating the report generation for quarterly reviews and also enabled them keep a watch on the metrics with unusual patterns/trends and raise a flag appropriately with the ease of data visualizations.2. Worked on Projects: US BTA reconciliation and Indian GST claim on Airfare. The projects involved application of analytical and problem-solving skills for effective data analysis, comprehension and reporting with detailed workings using Microsoft Excel. Recovered $86K of GST input on Airfare not claimed for over a year at once.

Bengaluru Area, India

1. Managed United States, Australian and IndianClients using various software such as Tally ERP,SAP, Quickbooks, Zoho Books and other cloudbased accounting software.2. Developed and implemented FinancialModels for several clients for Budgeting,Variance analysis, Cash forecasting, Financialforecasting, KPI dashboards, thus streamliningand automating entire process using MS Excel,Power BI, Microsoft Power Automate, andother tools.3. Finalization of Financial Statements fordomestic clients in compliance with AS andIND AS.

Bengaluru Area, India

1. Integral part of Statutory Audit team includingTax Audit clients across various industries.2. Accounting and Finalization of Financialstatements for domestic clients.

Certified Public Accountant, Accounting And Finance

US CPA

Ca Inter, Finance, Accounting, Auditing, Strategic Management

Bachelor Of Commerce - Bcom, Accounting And Finance