VISHAAL PATEL

Using SQL, PowerBI, Power Query (M-Code), Python, VBA, Azure ADF & Logic Apps to provide automated solutions for data processing / consumption, analytics, debugging, validation, and process enhancement.

• Custom report generation using advanced SQL querying in both MS-SQL and Oracle based RDBMS.
• Finance Process improvement projects from design through to implementation and maintenance. Use of tools such as Python, PowerBI, Power Query and SQL.
• Use of ETL – Azure Data Factory pipelines and dataflows for data ingestion, cleansing, processing and delivery of reports in various formats to both internal and external parties through a variety of mediums such as SFTP, E-mail and PowerBI data factory.
• Design, development, testing and maintenance of a wide range of PowerBI reports and dashboards that support the enterprise in crucial processes including treasury, financial performance measurement, client performance monitoring, internal budget control monitoring and ad-hoc reporting.
• Adherence to version control principles for development of all code assets using Git and Azure DevOps.
• Documentation of processes developed in Confluence.

Focus on process automation of daily treasury tasks

Using SQL for data analysis and reporting

Development and maintenance of PowerBI dashboards for daily use, alerting and reporting.

• Tasks included treasury management operations including banking and complex reconciliations involving querying the database.
• Process improvements – use of Power Automate & Excel VBA to integrate systems and enhance the reconciliation process resulting in quicker daily reconciliations.
• Use of advanced SQL querying to support wider finance team with analytics in areas such as revenue, month end reporting, financial planning, and forecasting.
• Development and maintenance of a wide range of PowerBI reports to support management to make insights based on factual data presented in an easy-to-understand format. Extensive us of Power Query (M-Code), SQL, DAX in the development of PowerBI based solutions for data consumption.
• Assist with Month End Accounting Process including P&L analysis, Balance Sheet postings and reviews. Successfully setup system to enable data from Oracle Netsuite to flow through into PowerBI – allowing the generation of PowerBI reports based on Netsuite Accounting data.

Daily reconciliation of trust bank accounts and acquirer statements. Writing of VBA code for Robotic Process Automation. System and application testing. Data analysis using SQL querying.

• Complete daily reconciliation of bank statements and merchant settlements.
• Ensure that all exceptions are identified, reported, and investigated.
• Reporting and escalation of operational issues impacting processing to IT and Business Leaders.
• Ensure timely responses to enquiries related to processing and processing activities.
• Maintain procedures for daily processing, bank reconciliations, disputes, chargebacks & refunds.
• Document workarounds for known issues to minimize repeat service disruptions or delays.
• Collect and monitor data to measure processing performance.
• Design and development of a range of VBA Excel Macros to deliver Robotic Process Automation in previously manual processes. Enhanced efficiencies and accuracy by implementing this.
• Investigate, log, and manage testing defects through to resolution.
• Using SQL to query databases to fulfil data requirements.

Responsible for reconciliation of supplier statements with an annual value of $20M

• Accurate and timely reconciliation of supplier statements back to internal systems.
• Ensuring clearing accounts in the general ledger match with reconciliation file with nil variance. Effecting journal entries where require
• Following up on credit notes, liaising with travel managers on discrepancies.
• Development of VBA Excel code, User-forms, and custom ribbons to deliver enhanced efficiency and accuracy of the supplier statement reconciliation process
• Design, development, and implementation of Robotic Process Automation with Power Automate to enable efficiency where legacy systems are still in use.
• Working with large datasets and establishing relationships between datasets to further enhance the supplier account reconciliation process.
• Actioned process changes resulting in identification of supplier errors, ultimately leading to lower costs of supply.
• Ensuring KPI’s are met and weekly reporting to team leader.

Full operational oversight of supermarket employing 10 staff

• Reviewing daily store sales and reconciling banking records with POS figures.
• Oversight of the product purchases including gross margin verification, stock control and stock take, pricing, and promotions. Accounts Payable.
• Monthly meeting with the owners reviewing performance of the store vs historical performance – recommending new product lines where appropriate.
• Ensuring compliance with the store standards manual, Lotto standards, Health & Safety requirements, and city council regulations.

Accounts receivable function from Invoicing through to collections and maintaining debtor's ledger in accordance with credit and general policy.

• Periodic reviewing of aged trial balance. Communication with debtors, negotiating payment of overdue invoices.
• Accounts payable – coding, verification of purchase orders, approval, and dispatch for payment.
• Monthly Profit & Loss variance report preparation.
• Review of general ledger for discrepancies. Making necessary journal entry adjustments.
• Foreign exchange cash reconciliation and reporting.