LAILA S. ALCONTIN

CONTACT DETAILS

1

Mobile: +61 421755988

Email:

Home : +61 3 99439005

Address: 1 Amber Way, Melton South, VIC 3338, Australia

1

PROFILE

1

  • 12+ years intensive work experience in various Finance Functions – management accounting, financial accounting, financial forecasting and budgeting/planning, corporate taxation and internal audit.
  • Strong knowledge of business, finance and accounting fundamentals.
  • Maintain focus on achieving bottom-line results while implementing advance technology to meet a firm’s financial diversity of needs.
  • Possess high sense of team building spirit.
  • Possess strong analytical and problem solving skills, with ability to make well thought out decisions.
  • Excellent interpersonal/communication skills.
  • Started CPA Australia membership
  • Australian Citizen

1

TECHNICAL SKILLS

  • SAP Super User - SAP ECC6, SAP 4.7 and SAP 4.5, TM1, BI – Business Intelligence, Data/Business Warehouse
  • Aztec or Temple User
  • Proficient in other financial systems – Ironbark, BI(Phocas) , Solomon, Databasics, AS400 and RS6000
  • Advanced in Excel Applications (macro, pivot, vlookup, hlookup, if, true, false, hyperlink, sumif, dget, dsum, concatenate etc.)
  • With work experience in FMCG – (Fast Moving Consumer Goods) and supply chain.
  • With work experience in Commercial accounting support
  • With work experience to system migration – from SAP 4.5 and SAP 4.7 to SAP ECC6 One Platform and from Solomon system to SAP ECC6
  • Solution oriented with strong commitment to continuous improvement leadership
  • Financial Management and ability to influence
  • Microsoft Office 2013/365 User

EXPERIENCE

Metcash Limited

Supplies all the goods sold by IGA stores

Jul 30, 2012 – Present

Senior Analyst – Australian Liquor Marketers & Independent Brands Australia

Financial System: Aztec or Temple, SAP ECC6, Business Intelligence, Data Warehouse and Mainframe

Work and Responsibilities:

  • Provide the Merchandise team valuable category and consumer insights through analyzing data at hand
  • Manage and present performance trends and growth opportunities to the IBA Merchandise team fortnightly
  • Monthly analysing of IBA promotions
  • Develop a performance dashboard to share promotional summaries with retailer committees
  • Prepare monthly VIC and NSW IGA State Board presentations
  • Prepare monthly IBA committee meeting presentations
  • Provide summary and recommendations of promotional effectiveness to the IBA Merchandise team
  • Provide accurate reports to the IBA merchandise team that includes summaries and recommendations on total performance
  • Provide leadership in 'scan queries' from wider ALM team
  • Weekly scan data management of IBA scan stores
  • Run auto scan reports weekly and identify any glitches with data
  • Provide the ALM VIC leadership team with a weekly snapshot on performance
  • Analyze performance data with a summary on why performance is growing or declining
  • Champion all external banner and Ownership groups reporting requirements

Commercial Analyst – IGA Food and Grocery Distribution

Financial System: SAP ECC6, Business Intelligence, Data Warehouse and Mainframe

Work and Responsibilities:

  • Managed to prepare the marketing department status quo and analysis without handover from the manager who was made redundant. This report detailed the budget, forecast against actual in different groups (Supermarket, IGA and IGA Xpress)
  • Created a Retailers Assistance/Development Report which monitors expenses, store funding with budget comparison, there was no reporting on this before, the costs for retailers assistance were scattered in different GL accounts and documentation is not properly filed
  • Created an Early Warning report which shows movement in % of retail sales and warehouse sales, the ratio of total debt against its retail sales and total debt overdue, this report helped the credit manager and the commercial manager to address the customer related risks ahead of time
  • Created a Monthly reporting for Sales and teamscore which shows retail sales against warehouse and teamscore per Channel, Banner, Category, Department and Customer
  • Created analysis on store owner’s financial status and cash flow, this is used by the commercial manager whether to lend a loan to a store and whether they can still keep up the payment based on financial status and assumptions
  • Created Debtors reporting which shows detailed debt and overdue per Channel, Banner, Category, Department and Customer
  • Audited internal operations and recommended actions and control
  • Prepared FY13-14 Budget and FY12-13 Monthly forecast on P &L for all IGA Distribution (SUPA, IGA, XPRESS, Foodworks etc)
  • Created and implemented a weekly pack for Executive Management group which shows

-P & L Budget, Forecast and Actual with up to date issues on or actions or plans. This helps the management in their operation and decision making. (Direct sales, rebateable sales, purchases, coops, subsidies and cost reduction in labor, packaging, advertising).

-Aged Stock report showing inventory age ad comparison to last week and average weekly inventory, this report give the management an overview of stocks in the warehouse and the movement of stocks

-Elephant report showing status of strategies and plans against actual (New Stores, Refurbished Stores, Competitiveness, etc)

-Sales report showing Net Sales compared to Net Cases and the impact of deflation, rate and sales mix

-Teamscore per Channel, Category and Customer

  • Prepared and Improved other weekly reporting on Labour to Sales Analysis and Shrinkage Analysis
  • Executed monthly responsibilities which include

-Monthly P &L forecast preparation and analysis of the variance, drivers, opportunities and risks

-Margin Analysis and Packaging Analysis

- Capital Expenditure report and Balance Sheet Reconciliation

-Leave Report, Retail Development report, and Marketing report

-Community Chest Program report and Purchase order report

-Month end Accruals on maintenance, freight, freight recoveries, admin and other accruals/journals

Contract roles below due to visa restrictions - previously held a dependent working visa (Year 2008 – 2012)

Georgiou Group

Regional Management Accountant – VIC and QLD Infrastructure

Jan 3, 2012 – July 27, 2012

Financial System: Timberline, Powerolap and Anterra BI

Work and Responsibilities:

  • Provided support to projects by communicating and regularly (once a month) visiting project sites in conjunction with the Risk department’s audit process to improve Project Management Capability.
  • Compliance onException reporting on the 3rd working day of each month for monthly progress claims to clients and follow to ensure compliance.
  • Reviewed monthly Valuation Reports , monthly Forecasting and exception reports
  • Trained and converted operations personnel to ensue efficient use of PowerOlap reporting and AnterraBI dashboards and reporting.
  • Monthly profit margin reports, cash flow, Balance Sheet, Overhaeds, Manning, Plant, Debtors and Creditors Ageing, Bank Covenants, WIP, Capex and company work in hand reports by the 7th working day of each month
  • Responsible for maintaining and ensuring credibility and accuracy of PowerOlap and AnterraBI systems for company reporting and dashboards.
  • Ensured Internal controls and procedures are maintained and monitored
  • Implemented physical KPI reporting in monthly job P & Ls.
  • Implemented continuous improvement using BI technology for project and board reporting capability
  • Implemented continuous improvement in project capability

Powercor Australia Ltd

Management Accountant – Corporate Regulatory Accounting

December 20, 2010 – December 22, 2011

Financial System: SAP and BI (Business Intelligence)

Work and Responsibilities:

  • Recommended an automated reporting format for Intercompany transactions to help with the analysis onbudget or forecast;
  • Recommended a new process and model in preparing eliminations and intercompany forecast/budget;
  • Recommended a new process and model in preparing GST movement calculations;
  • Recommended a new process in the preparation of CAPEX and CAPITAL reporting as well as its reconciliation;
  • Prepared the commentary and analysis of Consolidated 2012 budget for 36 entities and various business units (submitted to the Head of Accounting and Taxation who reports directly to the CFO);
  • Responsible for the preparation and presentation of the ‘Support’ business unit (Finance, HR, Legal Services, CEO, Regulatory) results, with analysis of major variance and any anomalies to be rectified during the monthly ‘flash’ meeting;
  • Prepares monthly Corporate Business reports for CAPEX and Balance Sheet as well as the financial graphs, dashboards, appendix and KPI;
  • Ensures the monthly ‘Flash Report’ prepared by the Co-op student is accurate by running month-end reports and general ledger queries;
  • Undertake investigations and analysis of data validation in SAP, and provide support to the rest of the business where necessary;
  • Prepares analysis and consolidation of the Annual Consolidated Budgets / Forecasts for both the Powercor and CitiPower Groups
  • Provides advice and accurate information to Management
  • Assist in the preparation of the yearly KPI results as designated by the Financial Controller
  • Monitor and update required changes to Business Intelligence Reports
  • Maintain the Business Consolidation System (BCSand running eliminations during the budget/forecast)

National Foods Limited (now Lion Nathan)- Finance

Commercial Analyst – Dated and Damaged and International/Domestic Logistics

January 15, 2010 – December 1, 2010

Financial System: SAP ECC6 and SAP 4.5, BI (Business Intelligence)

Work and Responsibilities:

Dated and Damaged task:

  • Prepared timely and meaningful Dated and Damaged report on a weekly basis for all Product Division (Milk, Cheese, Dairy and Juice).
  • Prepared Budget for FY 2011
  • Provided cost analysis to facilitate the weekly estimates and forecasting process.
  • Provided analysis for Dated and Damaged report to senior executives. (Actual vs. Budget).
  • Prepared National Dated and Damaged – Inventory report.
  • Prepared report and analysis relating to products sold under promotion.
  • Responsible in posting journals relating to inventory adjustment, pricing adjustment, accruals and provisions with supporting documents
  • Prepared National Dated and Damaged – Customer Claims report.
  • Prepared special reports requested by senior executives.

International Logistics Task:

  • Preparing International/Domestic Logistics manager a regular updates of expenditure, trends, and analysis of distribution cost so they understand the major issues in their operation.
  • Prepared Budget for FY 2011
  • Ensuring International Logistics manager is aware of business performance by providing reports of P & L activities and KPI’s which they control so that they can improve and maintain performance.
  • Providing cost analysis to facilitate the weekly estimates and forecasting process.
  • Assisting the senior management accountant – Logistics with forecasting and budget process in the distribution area.
  • Challenged business status quo and provide input to distribution strategy. Analyzed variance to ensure actions are implemented to I prove profitability of NFL business.

Verizon Business – CYBERTRUST ASIAPAC Finance

Project Accountant

August 4, 2008 – October 24, 2009

Financial System: SAP ECC6, TM1, Solomon, Databasics

Reason for Leaving: Finance team was moved to Hongkong

Work and Responsibilities:

  • Preparation on Project base analysis
  • Involved in the successful migration of Cybertrust APAC entities from Solomon accounting systems to nSAP. (data mapping, reconciliation, system testing)
  • Involved in the successful upgrade of Databasics system in line to the migration with nSAP accounting system (system testing)
  • Reconciled migrated Revenue accounts from Solomon Billing system to Arbor Billing system.
  • Developed and recommended reporting templates for efficient and accurate reporting.
  • Closing monthly Revenue books for Asia Pacific entity (Australia, HongKong, Singapore and Taiwan).
  • Preparing Weekly, Monthly and Quarterly Utilization report which is critical for Performance and Bonus computation
  • Preparing Work in Progress report in Professional Services to determine how we do in a certain project
  • Preparation and lodgment of Business Activity Statement, FBT, Levies and Royalties

Accenture

Financial Accounting Analyst – Controllers Group

Sep 07, 2002 – May. 30, 2008

Financial System: SAP ECC6

Work and Responsibilities:

US GAAP Task:

  • Performing monthly pre close and final close review and analysis of Balance Sheet and Profit and Loss statement in adherence to US GAAP.
  • Performing Balance Sheet Review with internal schedule and justifications/reconciliations.
  • Preparing financial forecast and budget.
  • Analyzing all GL accounts of financial statements for management reporting. (Balance Sheet, Income Statement and statement of Cash Flow)
  • Performing Internal and facilitating external Audit (with KPMG as external auditor)
  • Performing Bank Reconciliation for 13 Cash Accounts and advised proper adjustment
  • Preparing/posting month end adjustments

INTERCOMPANY Task:

  • Facilitating Inter-firm Billing- Payable and Receivable
  • Preparing/reviewing Inter-company billing
  • Reviewing inter-company invoices
  • Reviewing/reconciling inter-company transactions.
  • Posting of corresponding journal entries

TAX and STATUTORY Task:

  • Preparing/Computing Annual Corporate Income Tax under PEZA (tax benefit for Foreign investors) and regular tax regime.
  • Performing/computing Tax Roll forward
  • Performing/computing the Income Tax Package/Forecast
  • Performing the reconciliation, processing, filing and remittance of the following tax types:

-Creditable Income Taxes

-Final Income Taxes

-Input and Output VAT

-VAT Withholdings

-Fringe Benefit Tax

-Municipal Taxes

-Quarterly Alpha listings of Input and Output VAT

-Yearly Alpha listings of Creditable Income Tax, Final Income Tax and Fringe Benefit Tax

-Prepare 2307 Form to all Vendors on Quarterly basis

-Quarterly Alpha Listing of Regular Suppliers

  • Processing Local Business permit for all sites.
  • Preparing/computing of Income Tax Accrual Provision (Pre and Final Close Entries).

EDUCATION

  • University Of San Agustin, Bachelor of Science in Commerce Major in Management Accounting 2003

Gen. Luna St.Iloilo City, Philippines

CERTIFICATIONS/PROFESSIONAL ACTIVITIES

TRAINING/SEMINARS:

1

  • Received Champion Award from National Foods Ltd.
  • CPA Australia Masterclass – VBA in Excel 007
  • CPA Australia Masterclass – Dashboard and Charts in Excel 2007
  • SAP ECC6Training - SAP Super User
  • CPA Australia membership – 2 subjects enrolled
  • Excel Training – Advance 3
  • Writing a Composition in English
  • Communicative Approach in Learning English Focus on Speaking and Writing
  • 2006 Update on Philippine Financial Reporting Standards and New Regulatory Requirements
  • Philippine Withholding Tax and Special Topic on Value Added Tax
  • Philippine Withholding Tax (Yearend Adjustments) and Latest Revenue Issuances

1