Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shiv Kumar

Hyderabad

Summary

Results-driven Senior Service Charge Analyst at CBRE with expertise in budget management and process automation. In Depth Accounting Knowledge with Proven ability to enhance financial reporting through advanced Excel and Tableau skills. Adept at data analysis and team leadership, consistently achieving KPIs while streamlining operations and resolving complex issues efficiently.

Overview

7
7
years of professional experience

Work History

Senior Service Charge Analyst

CBRE
Hyderabad
04.2024 - Current
  • Implemented strategies for automating organizational budget and reporting processes.
  • Utilized advanced technical skills and expertise to troubleshoot complex problems and implement solutions in Yardi and Tramps.
  • Assigning tasks to team members and following the deadline to keep KPIs in line.
  • Provide automation through Excel and Tableau to enhance the budget process and client reporting service.
  • Processing budgets through analysis of estimates, actuals, and variance to maintain commercial and residential properties.
  • Preparing and sharing the Tableau data report for the status update on budgets and team progress, along with KPIs.

Accounting Analyst

Drink Logistics
Vancouver
07.2022 - 04.2023
  • Preparing month end financial documents and report such as distribution, revenue, expense classification, Re-classify, inventory, Debts, bank margin, Amortization Schedule.
  • Assist AR & AP posting Pmts Invoices, responding vendors emails, clients due notify, chq validation & billbacks.
  • Managing Subscription fees, Commissions, Credits & Discounts.
  • Audit Cashflow transactions, Inventory, CR DR note & payroll.
  • Transforming data to graphical presentation for Bad Debt reports, revenue pattern, categories, Overflow, expense reclassify, Invoices and Report, Inventory flow, predictive model for month/Quarters.
  • Communicating, analyzing for variance & errors & rectifying the books of accounts, posting Journal entries.
  • Perform monthly Bank reconciliation and keeping files audit ready.
  • Preparing adjusting and filling monthly GST at month end.

Accounting Technician

Dwell Property Management
Richmond
09.2020 - 06.2022
  • Management of Invoices posting, Payments posting, Rental reports, regular charges, Income statements and Balance sheet.
  • Daily tasks to update General ledgers, enquiries reply, follow-up, PAP setup, edit charges, tenants, owners transfers, strata notices.
  • Coordinate vendors, PM, Lawyers, occupants for clarification, missing NOS, process data to audit GL in accurate Periods.
  • Updating AGM budgets & posting Journal entries, monthly financial summary & reporting to controller.
  • Reconciliation duties of Bank, Rentals, reimbursements & costs.
  • Presentation of Ad-hoc projects to graphs, charts as desired.

Assistant Manager

Circle K
Vancouver
04.2018 - 09.2020
  • Handling complaints & requests from customers to resolving issues.
  • Preparing daily financials, sales report, ensuring its accuracy and completeness to date, updating system.
  • Hiring, training, developing new employees and assisting.
  • Audit to rectify the variance between cash & AC balance, merchandise & stock counts with bills, bank bal & financial docs.
  • Prepare weekly Forecast, Place Purchase order & list inventory.
  • Planning to targets, working through budgets & action plans.
  • Preparing, assigning time schedule, supplies & payroll.

Education

PDD-Business Admin -

Langara College
Vancouver, Canada
04.2018

B.COM -

Bhavans College
Sec-Bad, India
07.2015

Skills

  • Budget management
  • Data analysis
  • Financial reporting
  • Process automation
  • Yardi
  • Tramps
  • QuickBooks
  • Xero
  • Tableau
  • Excel proficiency
  • Bank reconciliation
  • SQL
  • BI dashboards

Timeline

Senior Service Charge Analyst

CBRE
04.2024 - Current

Accounting Analyst

Drink Logistics
07.2022 - 04.2023

Accounting Technician

Dwell Property Management
09.2020 - 06.2022

Assistant Manager

Circle K
04.2018 - 09.2020

PDD-Business Admin -

Langara College

B.COM -

Bhavans College

Similar Profiles

CREATE PROFILE
Shiv Kumar