Vipin Dhingra Email & Phone Number

United States

• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.• Improved decision-making processes with accurate data analysis and visualization techniques.• Participated in requirements meetings to understand business needs.• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.• Identified, analyzed and interpreted trends or patterns in complex data sets.• Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.• Managed large-scale databases to ensure timely access to critical information for key stakeholders.• Updated and developed scripts and queries to extract and analyze data from multiple sources.• Used database to research, gather, analyze and present data.• Organized information by studying, analyzing, interpreting and classifying data.• Introduced time-saving techniques like keyboard shortcuts and custom macros for increased efficiency in daily tasks.• Enhanced Excel proficiency by providing tailored mentoring sessions for individuals and groups.• Used SQL Agent to schedule and monitor SQL jobs.• Leveraged advanced features of SQL.• Managed SQL queries and data transport.• Increased productivity by automating repetitive tasks using Python scripting.• Developed tools like PDPM CMI (Patient-driven payment model case mix index) trackers, and QIPP trackers (Quality Incentive Payment Program) for states of Texas and California by partnering with key stakeholders.• Assist Cost reporting team by enhancing and streamlining various Excel models.• Assisting Presidents and CFO on ad-hoc basis.

Australia

• Expert knowledge of all main data sources for the data used within the business unit and ability to effectively utilize these data sources for reporting purposes.• Provide in-depth reporting to internal stakeholders. Manage the implementation and embedding of new processes and tools to improve reporting efficiency. Have controls in place to make sure the data accuracy is preserved.• Supported sales team by providing timely information on customer needs, preferences, and behaviors through detailed market analysis efforts.• Created and maintained precise and accurate models, charts, and reports.• Generated comprehensive reports on portfolio performance and risk assessment for COVID-19 crisis.• Work closely with senior stakeholders to identify drivers of sales and labor and assist with action plans where necessary.• Streamlined data analysis processes for enhanced decision-making capabilities in the company.• Improved forecast accuracy through rigorous data analysis and scenario modeling efforts.• Led a diverse team of professionals in successfully completing complex implementations.• Implemented continuous improvement initiatives that resulted in increased efficiency across various stages of the implementation process.

Sydney, Australia

Angus Knight fully owns three subsidiaries (Jobfind Centre, Varsity Training and Sumtotal Australia) and jointly own four ventures (Real Futures, Jobfind LWB, Rise Ngurratjuta and Nyirrunggulung-Rise).• Oversaw all aspects of the month-end close process, ensuring timely completion of accurate financial statements for executive review.• Maintained accurate balance sheet accounts by performing thorough general ledger reviews and adjustments as necessary.• Prepared balance sheets, cash flow reports and income statements.• Provided valuable insights into financial performance with regular variance analysis reports for upper management.• Participated in system upgrades or implementations projects, ensuring a seamless transition and minimal disruption to daily operations.• Reduced manual workload for the finance team by automating key processes and implementing time-saving tools.• Mentored junior staff members effectively, fostering professional growth within the finance team.• Lead budget preparation and forecasting, leading to more effective financial planning.• Contributed to the successful completion of annual audits through meticulous record-keeping, organization, and collaboration with external auditors.• Provided journal entries and performed accounting on an accrual basis.• Maintained integrity of general ledger and chart of accounts.• Trained new employees on accounting principles and company procedures.• Reviewed accounts, resolved coding areas, and tracked recurring expenses for accrual entry.• Administrator of Calumo; Calumo is a powerful BI and corporate performance management platform.

Sydney, Australia

• Assisted in annual audit preparations, ensuring a smooth process with no major discrepancies found.• Reconciled account information and reported figures in general ledger by comparing to bank account statement each month.• Tracked business revenue and expenditures and reconciled accounts to maintain high accuracy.• Input financial data and produced reports using Calumo and FRx.• Analyzed financial data to identify trends and provided actionable insights for management, leading to improved business performance.• Managed relationships with external auditors effectively ensuring positive outcomes during annual audits.• Leveraged advanced Excel skills to automate routine tasks, freeing up time for more value-added activities such as variance analysis and strategic planning support.• Facilitated timely vendor payments by maintaining an organized accounts payable process flow and tracking system.• Streamlined the month-end closing process by implementing a more efficient system for preparing journal entries.• Increased efficiency in financial reporting by automating routine tasks using advanced Excel functions.

Sydney, Australia

• Supported month-end closing procedures by reconciling accounts receivable ledgers and preparing aging reports for management review.• Improved invoice accuracy by thoroughly reviewing billing data before issuing final statements.• Partnered with cross-functional departments to resolve discrepancies in customer accounts, promoting a cohesive work environment.• Expedited payment collection with timely submission of invoices and proactive communication with clients.• Strengthened relationships with key clients by providing exceptional service in addressing inquiries regarding account balances or payment issues.• Reduced outstanding debts through consistent follow-up on overdue invoices and negotiating payment plans.• Facilitated timely account updates by promptly processing adjustments for credits, discounts, and write-offs.• Provided training to new employees on company-specific accounts receivable processes, fostering team cohesion and knowledge sharing.• Posted customer payments by recording cash, checks, and credit card transactions.• Verified discrepancies and resolved clients' billing issues• Reduced overdue debt by closely monitoring customer accounts and taking prompt action on outstanding payments.• Collaborated with other departments to resolve billing errors, ensuring timely payment from clients.• Improved cash flow by implementing efficient credit control policies and procedures.

Sydney, Australia

The 5-star luxury hotel with 563 rooms and 72 hotels around the world. Estimated room inventory of over 30,000 group wide.• Audit and verify all revenue transactions, record them and prepare daily and monthly sales and other reports for management according to hotel policies and procedures• Control and reconcile the daily sales in the outlets• Audit F&B and all other hotel revenue generate and ensure the accuracy• Audit the credit card transactions for accuracy• Ensure the POS details summary reports agree with Opera• Audit the banquet functions and ensure the charges are as per banquet event orders• Perform month end closing and ensure that the trial balance agree with general ledger• Prepare daily and monthly reports for the management• Make spot checks in the outlets• Verify and audit daily General Cashier deposit and envelope• Check Micros and Opera reports for accuracy and unusual transactions• Verify and audit all adjustments and corrections.• Assisted in maintaining a strong internal control environment, conducting regular audits and reviews of operational procedures.• Maintained thorough documentation of all income audit findings, contributing to the transparency and accountability within the finance department.

Sydney, Australia

• Transfer City Ledger and Credit Cards daily from Guest Ledger to City Ledger• Check Credit Card documentation on completeness• Deal with Credit Card complaint• Check PM and open folio accounts daily• Send Group and Transient invoices with respective back up information on a daily basis• Responsible to post NoShow and Late Cancellation when requested through Reservation or Event• Post all charges, rebates, etc• Verify Banquet Summary, including auditing and checking for missing or un-posted checks• Completion of the Daily Bank Ticket• Collection efforts in any possible way (credit information (D&B), reminder letters, collection calls)• Print daily statements, copy all related back-up and mail with statements as necessary• Deal with any write offs.

Certified Practising Accountants, Accounting And Finance

Master’S Degree, Accountancy

Bachelor’S Degree, Business/Commerce, General

High School, Junior High/Intermediate/Middle School Education