ERP
Experienced Financial Analyst with over 15 years of experience in Manufacturing and Service Industries. Excellent reputation for resolving problems and ERP Implementation.Established SOPs and KPIs for various departments.
- Preparation and Maintenance of highly complex Consolidated Financial Dashboard consisting of 6 group of companies including Production and Sales Dashboard with real time data, which increased PAT from 10 million to 141 million annually.
- Analysis of Financial Statements of 6 Group of companies.
- Preparation of Various Ad-hoc reports for CEO.
- Implementation of Online QuickBooks software independently for 3 companies with support from 1 data entry operator and 1 accountant only.
- Coordination with CFO for rectification of errors found in monthly Financials, if any.
- Consolidation of Financials received and report to CEO.
- Highlights to CEO/CFO if variances are found between ERP data and Financials received.
- Audit of Financials received with Bank Statements to verify Financial Accuracy.
- Preparation of various power point presentations for CEO.
- Expenses Analysis of various sister companies and Key Performance Indicators (KPIs) establishment.
- Preparation of Daily P&L for CEO with forecasted/estimated cost of Sales, GP, Admin and selling, etc figures.
- Heading Finance Department for all receivables, payables and taxation matters
- Coordination with Auditors regarding annual audits of financials statements.
- Coordination with International customers regarding receivables and payables matters.
- Payroll Verification and Disbursement of 350 plus employees.
- Bank Reconciliation and other correspondences.
- Preparation of various analytical reports for Directors.
- Quick books 2009 upgradation to QuickBooks 2018
- Supervised customized Payroll Software development and implementation.
- Managing Credit for 4 companies at 5 geographically dispersed locations.
- Managing 10 recovery officers and credit controllers for prompt collection.
- Managing 12 accountants including branch accountants and branch managers.
- Presents Monthly Financial Statements to Directors, VC and GM.
- Sales Analysis, Collections Analysis and Financial Statements Analysis.
- Budget Preparation for FY 2016-2017.
- Costing/Commission calculations for maximum profitability.
- Dispute Resolution and Reconciliation with Customers.
- Information Systems Audit including Catalyst, Power Suite and Oracle systems.
- KPIs Creation for Receivables Department.
- Supervised ERP implementation at Afeef Group of Companies.
- Financial Statements & Sales Analysis.
- Trend and Break Even & Cost Analysis.
- Presentations to the Directors pertaining to the Financial Performance of the company from ERP.
- Customizations, Development, Troubleshooting, Support Provision and Training to end users on ERP usage.
- SharePoint maintenance, customization and development.
- Heading and verifying smooth functioning of all the modules at Afeef Group of companies namely Finance, Warehouse, Sales, Procurement, Production, CSR and Retail Modules.
- Traceability of items from ERP during various quality audits.
- One Click Financial Statements mapping, preparation and presentation to directors of the company from ERP.
- On/Off Turf Reporting and Analysis pertaining to CPA market sales on a daily and weekly basis.
- Mapping of Leads for 40+ sales agents on MapPoint Software.
- Preliminary Payrolls rollout to the Reps and to their managers on a weekly basis.
- Break up of invoices according to the markets and invoicing periods on a weekly basis.
- Preparation of various ad hoc analytical reports.
- Reconciliation of sales books with infoquest reports.
- Preparation of a Comprehensive weekly recruitment summary report of ‘Global Recruitment Division’ for all the stakeholders of the company.
- Pareto Analysis of Daily Sales.
- Normalization of Sales Database
- Comcast Pre and Post Cancel analysis.
- Looked after the receivables matters of 9 subsidiary companies simultaneously at Constellation Software Inc.
- Prepared Maintenance Contracts and Invoices in MS Dynamics GP 2010.
- Shortlisted and enhanced Resumes for the staffing division of one of the IT and Consulting Division.
- Prepared Maintenance Revenue Trend reports on a monthly basis for different subsidiary companies.
- Research and Analysis for the preparation of Mergers and Acquisitions database including identification of Key personnel’s.
- Performed Migration of websites on WordPress 3.0.
- Legal documentation and maintenance on Sharepoint portal 2007.
- Prepared Revenue forecasting and analysis reports for 5 subsidiary companies’ GMs and VPs.
- Used Tableau, Qlikview and developer tools to prepare analytical reports for VPs, GMs and Directors.
- Supervision of the Financial Audit Process for Fiscal Year 2007.
-Assisted the External Auditor in the Audit Process.
-Reconciled and updated the manual stock position with the QuickBooks data.
-Entered General Journal entries in the QuickBooks.
-Explained, Extracted and Provided all the QuickBooks Reports and Entries to the Auditor and GM Finance.
-Prepared Invoices, Payment Vouchers, Receipt Vouchers, etc.
-Preparation and Disbursement of Checks to the clients of Sysnet.
-Microsoft Dynamics AX implementation consultancy.
-To call Sysnet clients for Receivable purposes and follow-ups
-Reconciliation of Banks Statements with Company’s Books of Accounts.
- Resolved Non Conformities pertaining to ISO Internal Audit 9001 : 2008.
Financial analysis
· Successfully managed the implementation of five fully ‘Customized ERP Modules’ namely Billing, Accounting, Time Information System(TIS), Academics and Human Resource Management (HRM) module at an Educational Institution.
· Successfully plunged down Accounts Receivables of 6 separate companies from approximately 48% to 16%.
· Successfully configured 4 Retail POS machines for 4 Retail stores in just one month.
Successfully managed the implementation of two ERP systems consisting of Finance, A/R, A/P, Production, Sales, HR, Costing, etc. at two Group of Companies
ERP
PowerBI
Tableau
Advanced Excel
Oracle
Microsoft Dynamics
MS Office
QuickBooks
Wordpress
Dashboard Creation
Cost Analysis
Capital Budgeting
Building Dashboards
Online Certifications
ISO 9001: 2008-Internal Auditor (16 Credit hours)
Microsoft Dynamics GP 10.0 Using SQL Server Reporting Services: Report Models and Report Builder
Capital Budgeting
Microsoft Dynamics AX 2012: Financials II - Cash Flow Management