Post Job Free
Sign in

finance/accounting

Location:
Mississauga, ON, Canada
Posted:
September 18, 2013

Contact this candidate

Resume:

CAREER PROFILE

. Masters of Business Administration (MBA)from Southern New Hampshire

University, Manchester, NH,USA

. Subjects covered Financial Management, Quantitative Analysis, Cost

/Operations Management, Managerial Accounting, Management and

Administration

. Key participation in more than a few business processes and operations

that assisted the Organization to attain increased efficiency, and KPIs

. Achieved the Certified General Accountants of Ontario- Level 3 - with

Honors

. Completed Accounting Specialist Certificate-with Honors from Sheridan

College, gained thorough knowledge of GAAP

. Completed Oracle Business Developer Certificate SQL and PLSQL

. Attained in depth experience and knowledge of ERP System -Catalyst SAP

(FICO) R3, SP2, SP7, BP2, BP7 explorer analyzers BW, BI. People Soft,

Siebel, and Cognos Computerized Accounting Certificate, Excel, Access,

PowerPoint

. 7+ years of experience in the business industry within international

corporate environment

PROFESSIONAL EXPERIENCE

EXPERIENCE OVERVIEW IN CANADA

Canadian Tire-Head Office

Senior Financial Analyst

June2013-

Recent

. Responsible for testing JDE Financial System for Merchandise management

and adjustments, develop transactional models in excel, set formulas

with variety of scenarios for validation in the General Ledger and Sub

Ledgers

. Utilized advanced accounting and Excel in developing, Corporate and

Franchise Stores transactions Covering calculation of Price, Weighted

Average Cost, Freight, tax, and Imports

. Analyzed accounting process and transaction for accurate accounting

impact, monitored RCA (Receipt Cost Adjustment for pricing impacts on

inventory),RQA (Receipt Quantity Adjustment), and

PCA(Purchase cost, Price, Quantity) impact on Cost of goods sold/ Net

Income

Owens Corning-Toronto Plant

Financial Analyst - Cost Accounting

Feb2013-June

. Monitored the Cost Budgets, comparing Forecasted, Planned with the

Actuals, Utilized SAP down load to extract data in financial models and

used Manufacturing Results to develop the KPIs to analyze & Report

(Scorecard), compared Period cost, and Direct cost with Planned,

Forecasted, Actuals and YTD

. Monitored and Reported Operations, Covering Operating Efficiency, Piece

Job Efficiency, Conversion Efficiency and Density Efficiency.

. Calculated the Volumes trends and performed comparative analysis within

different product Categories

. Monitored the Cost drivers by utilizing advanced Excel covering Macros, V-

lookups, Pivot tables and Access to develop reports for the unit cost,

Departments Expense Analysis, Labor Budget, Raw Material Usage and

Warehouse Cost

. Assisted Controller in SOX compliance with Stock Valuation & Cost

Control, Monitoring & Controlling Capital Cost, the Labor Cost and

Finished Goods Validation

. Developed Manufacturing Variances Report Comparing Volume Variance VS

Plan, Volume Variance VS Forecast, Cost Volume VS Plan and Cost Volume VS

Forecast

Kraft Foods

Business Process Management Aug2011-

Jan2013

Master Data Analyst

. Managed the setup of business data and its processing via system controls

to flow and interface within the MDM, GMD ECC SAP, and P101, ensured

that data flows has integrity, its relationship accepted and Published

in GS1

. Solid understanding of Master Data that enable discrete manufacturing and

supply chain management operational business processes including Material

Master, Price Master, and Customer Master

. Investigated and identified root causes of major data problems, and

potential remediation or process solutions.

. Demonstrated understanding of SAP data structures and the extraction of

SAP data records and field values using various SAP provided techniques

. Business Data setups some required parameters, include assign

classification, relationship Parent /child calculation specification

Each, Inner, Orderable, Pallet hierarchy, distribution channels, Storage

locations, Plants, warehouses extension Cost and Profit centers,

Calculation/ validation regional pricing for SKUS and data linkages

. Supervised train/cross train, assist and monitor KPIs for the team

Master Data 's work flow and efficiencies

. Generated and Analyzed Sales Price reports, Reviewed and Run Data

Dialysis Reports business specified standard reports to perform financial

data and Product / Customer specification review utilized Excel and

Access for validation Coordinated cross-functional process development

and identified opportunities and improve process.

. Developed and presented SOP to validate pricing calculations for SBOM

setups resulting in systemic improvement and efficiency in accuracy &

workflow.

Canada Dry Motts Inc. Dr Pepper Snapple Group

Financial Analyst - Commercial Finance (Contract)

Feb2011-July2011

. Developed and Analyzed Sales Volume Reports for Beverage Concentrate, and

Packaged Beverage Comparing the Annual Operating Plan for the period with

the Actual Sales and Forecasted Sales Volume . Used PowerPoint for

presentation to the stakeholders

. Developed and Reported the Daily, and Weekly Volume Shipment Reports

using Cognos and SAP.

. Coordinated and assist in forecasting volume, SG&A expenses, P&L, and

Balance Sheet reporting utilized SAP SP2 Analyzer.

. Performed Trade promotion management in Siebel, Generated reports,

Allocated Budget, Transferred and Adjusted Funds to PPG's with respect

Customer's Account. Maintained PCL relationship and valid price rates in

Siebel

. Developed Statistics Canada Report utilizing the Hyperion Excel add in

Essbase analyzer

. Down loaded Data from SAP BP7 and Analyzed the Brokers Sales Volumes and

Commission rates for payments Utilized Explorer Analyzer, V-lookups,

Formulas and Pivot tables in Excel

. Managed and maintained the Pricing profile pertaining to changes in rates

affecting the price with reference to Base (I.O), Flex accrual and Fixed

Rates according to the Trade spend.

Validated and Reconciled the Data Integrity pertaining to price rates in

Seibel, SAP and Pricing profile

. Identified the requirements and documented the business process in

addition to responsible for finding the system requirements, Designed

forms and SOP for Pricing efficiency

Kraft Foods Canada

Customer Supply Chain Analyst (Contract)

Feb 2010-Feb2011

. Monitored the Blocked Orders Reports, Sales Order Reports,& Sales Audit

Report(N/R-ZCUR) for key metrics reporting and analysis on all aspects of

the on-going business to facilitate the Customer Supply Chain management

. Support the Sales in customer supply chain management pertaining to

Orders, Delivery, Invoicing and A/R

. Build effective working relationships with Customer/Distributor Manager,

Logistics Operations, Product Supply, Sales and Customers

. Analyzed and Researched the Trade Promotions, Deductions, Shortages,

Overages, and Pricing issues by monitoring the audit trail and gathered

backup to produced accurate reporting packages with supporting

documentation for Kraft Canada's claim or Customer Credit.

. Down loaded Data from Kraft Accounts Receivable System (Oracle People

Soft) in to Excel effectively analyze Data based on Clients, Amounts, and

aging of Account receivable, Conducted investigation of deductions based

on KARS Categories, Promotional deductions, Shipping and Invalid

deductions to minimize financial exposure, utilized Audit check list

for SAP credits and Write Offs.

. Researched and analyzed in Coordination with Trade Coordinator and senior

Financial Analyst for financial accuracy

. Of price/cost allocations and allowances pertaining to trade promotions

made adjustments to account for accuracy

Data Group of Companies

Senior Accounting Analyst (Contract)

Aug2009-Feb2010

. Involved with the creation and maintenance of Consolidated Income

Statement and Balance Sheet.

. Analyzed and developed Sales Trend Report for Financial Statements,

Utilized PowerPoint for Monthly presentation

. Developed Expense report covering different regions of Data Group

. Consolidated Finished Goods Inventory Report for Corporate Management

. Performed Inter Divisional Reconciliation and Revenue Allocations of

different divisions

. Performed Sales Audit by monitoring the Audit Trails of Orders and

Invoices for accuracy

. Supervised A/R billing and performed month end Journal entries

. Performed audit, evaluation,tagging and coding of Fixed Assets(plant

assets & equipment)

Maersk Logistics Canada Inc

Analyst/Accountant (Contract) Dec2008-June2009

. Performed analysis of the customer billing by monitoring pricing/costing

structure based on country,tariff rates of TRL,

. CMF,CY,CFS,quantities utilizing SAP, MORE,Access

. Developed and applied macros / pivot table in Excel for advance analysis

and monitoring, Utilized PowerPoint presentation for KPIs rates

destinations in logistics

. Conducted deductions/correction and development of complex customer

invoicing, utilizing SAP system

. Monitored and analyzed Cash Application in AS400 and IES systems

. Assisted with bank reconciliations, month end, and financial reporting

. Identified the requirements and documented the business process

responsible for finding the system requirements in A/R billing developed

Excel Macros and pivot table systems and processes to facilitate complex

billing developed SOPs

Cadbury Adams Canada

Customer Investment and Deductions Analyst (Contract) June2008-Nov2008

. Performed financial analysis of trade promotion investment for customers

Metro, Wal-Mart, and LCL

. Produced timely, accurate and insightful reporting pack highlighting main

drivers on trade spend to summarize key issues and recommendations for

required action by Finance and Sales Managers.

. Effectively analyzed deductions to ascertain validity, timely

investigation of deductions to minimize financial exposure and

reduce/eliminate repetitive invalid deductions

. Analyzed, researched, reconciled customer claims and Composed clear and

complete documentation

of research steps and outcomes

. Prepared deduction packages to support issuance of credit memo,

collection process or trade reconciliation

. Coordinated with the Customers and senior management to achieve the

operational objectives

. Generated reports to measure performance, Utilize SAP, Get Paid, Excel,Access and Siebel

Novartis Consumer Health Canada

Financial Analyst-Financial Reporting and Analysis (Contract)

Feb2008-May2008

. Generated Income Statements and Balance Sheets from Trial Balance,

support budget holders to plan and track

. Utilized the data from SAP and BW system, performed analysis in Excel by

applying V-Lookup,filters, formulas and tables to monitor and analyze

the KBI's and KPI's ratio Analysis profit margins Net Income/Sales, Net

Working Capital current assets-current liability, Return on Assets (ROA)

Net Income /Average Total Assets, and DSO

. Supported finance group with maintenance of general ledger, prepare,

analyze the account reconciliations and develop supporting backup

utilizing Account Receivable and General Ledger modules of SAP

. Assisted with month end Integrated Cost Environment ICE Mapping /

Inventory Analysis and NPMR

Novartis Product Margin Report uploads, prepared monthly reports,

analyzing trends and making PowerPoint presentations to management for

improvement

. Assisted in the month end and year end process, for maintenance of

accounts and to ensure accuracy prepare, review/post Journal Entries for

approval utilized various menus in SAP

General Mills Corporation Canada

Financial Analyst Nov2006-Jan2008

. Developed Financial Models to generate Income Statement, from Trial

balance for profit and loss analysis, formulated total operating revenue

and total operating expenses resulting in Net Income

. Performed Quarterly Financial statement analysis to be submitted to

Government under Statistics Canada reporting

Conducted analysis in Excel by applying V-Lookup, filters, formulas and

tables to monitor and analyze the KBI's and KPI's ratio analysis profit

margins Net income/Sales, Net Working Capital Current Assets-Current

Liability, Return On Assets (ROA) Net Income /Average Total Assets, and

DSO

. Performed month end General Ledger reconciliations of all the accounts,

utilized key functions in generating and viewing Financial Statements,

Chart of Accounts, Balance displays, Cost Centers, Display Documents, and

G/L Accounts in the SAP system

. Performed Business process analysis for controls under SOX testing for

the Income Tax, Account Payable, and GST/PST operation of the company

submitted the audit results to Minneapolis, USA

. Coordinated with Controller, Director Tax, Corporate Accountant Tax,

Supervisor General Ledger and Supervisor Accounts Payable to facilitate

the operations

Senior Business Analyst

Toyota Motors, Pakistan

Jan1996-2004

EDUCATION AND TRAINING

Master of Business Administration (MBA)

Southern New Hampshire University, Manchester, New Hampshire, USA

Sheridan College, Oakville, Ontario, Canada

CGA Level 3/Accounting Specialist Certificate (Honors)



Contact this candidate