Reporting, Financial Analysis, Sales Analysis, budget plan and prep

SIVA VINAY CPA, CGA

**** ********* *****, ***********, *******, L5M 3R4

E-mail: *******@*****.***, Phone: 647-***-****

STRENGTH

- All aspects of reporting, financial analysis, reconciliation, variance and trend analysis MOM/YTD

- Financial statements, consolidation, budgets and forecasts/quarterly forecast revision

- Mid month dashboard/Pre-Flash and weekly cash flow and sales/core acquisition analysis

- Compliance with federal, provincial and organizational policies and controls related to accounting

- Excel model with pivot tables, vlookup and formulas

- Building Costing Models with bottom line contribution

- Audit support/schedule preparation

- Inventory management and inventory module implementation

- Payment/overviewing statute and monthly government payments

- Lead in system transition/ Organizational merger * supervised AP/AR * Intercompany reconciliation * Foreign exchange *Transfer Pricing

- Assisted with system implementation for Peoplesoft and Galaxy

EXPERIENCE

Paramount Pallet LP – Manager Finance – March 2015 – Mar 2016 (Contract)

Manufacturing – Solomon, Kmat and BRACs.

Prepared FY 2016/2017 budget, Forecast, 5Y Plan with units/revenue for national and consolidation.

Download actuals, collections of data from departments, national depots, coordination with sales (strategic planning) for budget preparation and lost/new business annualized data

Monthly budget/Forecast analysis of MOM and YTD results, business explanation and financial results presentation

Support and reports to national entities, sales teams, budget tracking for entities and sales teams

Analysis of FY2016 and FY2017 budget based on market analysis and change of product category

Quarterly forecast revision and based on actuals and new capex requirements analysis vs actual

Bi-month (Pre-Flash) financial reporting and monthly financial statements, reporting and national analysis of variances vs budget and forecast

Performance reporting weekly basis and monthly cost/gross margin /net profit monitoring

Monthly reporting of YTD anticipated net profit based on market, risk analysis and new capital expenses

Cost matrix for direct cost, gross margin and transfer cost per unit

Analysis for product category contribution for ULP and strategical analysis

Monthly Financial Statements per depots/consolidation and analysis

Monthly risk and opportunity analysis and reporting with impact on underlying profit

Implemented process improvement, financial controls in place, guidelines for reporting and sales reports

Month end reporting to head office (US currency) and upload

Process improvement for inventory valuation and capitalization of ending balance

Pricing analysis for sales and purchases of core products

Inventory module implementation, inventory balance accuracy.

Weekly sales reports, sales analysis and coordinate with sales rep for business updates

Streit Manufacturing Inc. Controller – April 2011 – Feb 2015 (Contract)

Manufacturing – Software – Navision – Excel 2010 with pivot table and Lookups

Preparation of management report (production projections vs actual, sales analysis) and financial reporting / presentation and general accounting.

Weekly cash flow and monthly reporting of sales and month, closing and month end accounting.

All accounting activities, costing activities, inventory control, month end close and reconciliation

Reporting manufacturing/operations, COGS, subcontractors salary and back up payroll

Preparation of year-end schedules to facilitate the completion of an effective and efficient year-end audit

Inventory support/control and Navision administrator

Supervised Accounts Payable and Receivables

Monthly remittance of WSIB, HST, Ministry of health dues, payroll tax and dues

Off-shore Entities including preparing journal entries, settling accounts, wiring funds and reconciling intercompany account

Preparing journal entries, settling accounts, wiring funds and reconciling

Receivable accounts.

Actuate Corporation -Financial Analyst- Nov.2006 – April 2011.

Software Business - Software used: Solomon, Sales Team, Heat and PeopleSoft- Excel 2007 with pivot table and Lookups

Revenue recognition and analysis and reporting

Variance analysis with sales forecast and expense analysis

IFRS transition

Consolidations and financial statements for quarterly reporting and audit schedules

Month end close, general accounting functions, calculation of tax provision and reconciliation of Balance Sheet accounts

Annual budget preparation and variance analysis vs actual sales and expenses

Supervised Accounts Payable and Receivables

Process software maintenance renewals and US Sales tax analysis

Prepare weekly Consolidated Cash position from Canada, U.S and UK accounts

Month end process, reconciliations, royalty reports and commissions

Monthly intercompany transfers, Fixed Assets, Prepaid, bank reconciliation and preparation and reconciliation of Trial Balance

Belvedere International Inc. / Senior Financial and Sales Analyst (May 2001 – Oct. 2006)

Manufacturing Business - Software used: Oracle, Navision, Visual, Auditpro and PeopleSoft

Reporting and analyzing revenues, sales forecast and cost allocation

Annual Budget preparation and variance analysis vs actual results

Preparing account plan-o-grams, promotional planning based on 3 years analysis

Analyzing the Promotions (sales) estimate vs. actual, reporting the variance

Sales claims verification and rejection with supportive documents

Creating, maintaining and reporting cost for inventory, aged and new products

Coordination with marketing and sales team to implement distribution for an overseas manufacturer

University Health Network / Staff Accountant Feb. 1995 – April 2001

Software used: Nomad, Galaxy, Infinium and Smartstream - Excel and Access for queries

Analysis and reporting of the research accounts and grants

Month end procedure, reconciliations and ministry submissions, general accounting functions, preparation and reconciliation of Trial Balance

Bank reconciliations and monthly tax remittances

Fixed assets and prepaid schedules

Budgets and forecasts for the new hospital projects, analyzing with actual vs. estimate

Audited invoices regarding PST exemption for healthcare and research

Reconciled of General Ledger Accounts, upload journals and month end close

Withheld taxes for non-resident companies, paid taxes to the Receiver General of Canada, did all the relevant summary sheets

Month end procedure, reconciliations and ministry submissions, general accounting functions, preparation and reconciliation of Trial Balance

COMPUTER SKILL

Excel – Excel models, Pivot Tables and VLookup and formulas – Advance Level

Access and PowerPoint – Ability to do queries and presentation

EDUCATION

CPA Certified Professional Accountants

CGA (Certified General Accountant)

H.B.Com through Laurentian University

Special offer to do MBA based on performance ( all grades B / above and GPA: 7.69)

Certified Management Accountants (ICMA) _ UK

Bachelor of Science

Contact this candidate