Avi Kumar Email & Phone Number

Melbourne, VIC, AU

• Experienced Senior Power BI Developer with a track record of driving impactful transformations through cutting-edge technology:
• Pioneer in automating Budget & Forecasting reporting solutions using Power BI.
• DAX expert with a focus on data modeling for robust and efficient data analysis.
• Spearheading the successful migration of reporting systems from Excel to cloud-based Microsoft Power BI, harnessing the power of SQL views and queries as primary data sources.
• Committed to ensuring security and access compliance by proficiently managing Power BI tenancy.
• Collaborating directly with cross-functional teams, including Operations, Sales, and Finance, to create tailor-made reporting solutions in Power BI.

Australia

• Providing business users with insightful and dynamic reporting including month end reports
• Development and ongoing maintenance of reporting templates in Excel and data models
• Partnering with the Commercial Finance and Executive Leadership Teams on evaluating business opportunities
• Regular analysis of business performance identifying trends and opportunities for Operational stakeholders to consider

Australia

• Transitioned excel customer DIFOT and volume forecasting reports to Power BI based on current business rules as per the customer who was at risk at that point but has now agreed to contract extension
• Setting up templates (Excel & Power BI) at customers’ sites for internal weekly reporting. This will allows the customer to identify issues relating to their despatch sites and remediating them before peak
• Automating internal operations reports, eliminating time consuming manual tasks (Using Power BI, Excel & SQL) (saving the team 3 – 6 hours a week per report
• Adding value and insights via analysis and financial modelling in Power BI and optimising usage of current systems
• Provide accounting and analytical support to the Commercial Division for day-to-day operational tasks and projects.
• Building and maintaining operational and customer analysis and reporting templates

Melbourne, Australia

• Scope, develop, automate, implement and maintain various internal reports including; Revenue, Line haul Costs, PUD Costs, Container Movements & Costs, Site Operating Costs, Fuel, Wages & Agency Staff, R & F / DFS and.
• Conduct detailed analysis of operational and customer relationships impacting directly on the financial performance of the company
• Audit of the timeliness and accuracy of information with the intention of driving accountability and implementing change for further improvement
• Assist with the financial forecasting and financial budgeting process of Operating plans and Capital plans
• Work with the business users and IT to proactively resolve reporting and system issues of the past and new issues as they arise.
• Project managing / assisting with various business improvement projects

Melbourne, Australia

• Analysing variances between standard costs and actual costs (via invoices) relating to logistics providers
• Planning and managing offshore pick and pack (PNP) projects to reduce congestion at local warehouses and destination ports
• Monitoring and analysing all modes of shipments (sea, road, inbound, outbound)
• Freight estimations for Sales & Retail teams
• Management and financial representation of the supply chain cost centre
• Work closely with 3PL providers to ensure maximization of space and processes

Auckland, New Zealand

• All accounts payable (NZ & overseas, credit cards, expense claims, ad hoc payments that are presented for payment be coded, certified and authorised for payment in accordance with company and policy and procedures
• Management of Purchase Orders and new suppliers in Jira (in house sharepoint) and ensure proper internal controls are followed
• Ensure costs are correctly allocated to appropriate cost centres and business units
• Responsible for ensuring Oracle system is up to date in order to have accurate financial information available
• Communicating with suppliers including negotiation of payment dates to assist with managing Orion’s cash position
• Planning cash flow by pro-active communication with Accounting Manager for preparation of payment runs

Auckland, New Zealand

• Explaining variances through the reconciliation of expected and actual revenue from Telecom.
• Build Deposits and Bank Reconciliation
• Forecasting payments based on current and historical trends
• Investigating and resolving unpaid transactions
• Processing payments received from Telecom
• Sending out weekly query report to all stores and following up with branches on pending unpaid invoices

Auckland, New Zealand

• Planned inventory orders, (balancing supply and demand) – minimize shortages
• Processed incoming and outgoing goods on a computerized system
• Stock transfers between stores (Following procedures)
• Ensured the stock take was carried out smoothly
• Recorded inventory inwards (booking in, ensuring stock ordered is in line with the physical receipt of goods)
• Investigated variance in stock

Bachelor Of Business, Accounting

Diploma In Business, Business/Commerce, General