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)