Robert Peng
North York,Canada
Summary
Build up data driven decision model to support business decision and operation efficiency, develop input data quality control software to control input risk
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr Manager in Commercial Finance
Bavarian Nordic Inc.
01.2023 - Current
- Forecasting company annual sales and gross to net expense and conduct actual vs. budget vs. last year actual analysis
- Managing AR aging and gross to net expense control
- Lead and manage a team responsible for financial reporting, including supervision of month and year-end close processes, and financial management.
- Develop and implement streamlined procedures for month and year-end close to enhance efficiency, accuracy, and compliance.
- Lead the annual audit process alongside external auditors, supplying the necessary documentation and addressing any inquiries.
- Manage and enhance internal controls and strategies aimed at preventing financial misstatements, mitigating unnecessary risks, and minimizing the risk of fraud.
- Provide leadership and guidance in the development of financial reporting systems and tools to support informed decision-making by senior management.
- Conduct in-depth analyses of financial data, identifying trends, and presenting findings to the leadership team, offering insights that drive strategic business decisions.
- Lead financial analysis efforts for any new product initiatives, including cost assessments, revenue forecasts, and assessing overall lifetime profitability.
- Participate actively in strategic planning discussions, leveraging your financial expertise to support the company's growth initiatives.
Budgeting Manager
Amgen Inc.
05.2021 - 12.2022
- Develop Improved Budget Process to increase accuracy and efficiency to meet management and stakeholders’ needs and ensure the budget control utilizing SAP and Hyperion system
- Leading Amgen supply chain consolidation activities relating FP&A and reporting by collaborating with 9 department directors
- Develop Dash Board Reporting on Budgeting and KPI reporting using Sportfire presentation in front Supply Chain Group Management Team
- Manage the budget reporting including Amgen Long range strategic planning for Amgen supply chain group including dash board reporting, variance analysis , KPI and drivers and trending analysis
- Collaborate with controllers to ensure accurate reporting of Revenues, COGS, and SG&A; provide P&L analysis by products, markets, and customers by setting up separate integrated database using SQL for reporting
Sr. Financial Analyst and in the capacity of Finance Manager
PFIZER INC, New York, NY
03.2011 - 01.2021
- Expert level at SAP and Hyperion System, using SQL to upgrade the accounting consolidation data system for collaboration business to ensure financial reporting integrity.
- Develop a market/product seasonality analysis method to support budgeting and monthly forecasting.
- Develop Argentina Hyperinflation automation model to save millions cost for the company
- Analyze sales actual vs. budget vs. last year, and explain the variance using Hyperion(PBCS,SmartView etc.)and SAP System utilizing SQL to consolidate data from different sources.
- Prepare budget, rolling forecast models, and trend analysis report as well as dashboard & KPI reporting
- Working with commercial divisions on supporting commercial decision including ROI analysis
- Conduct Industrial and competitive analysis to support variance analysis and forecast and support strategic planning using SQL and Python to integrate data from relevant sources.
- Assist in preparation of corporate external financial statement on a quarterly and annual basis (10 Q and 10 K Disclosure) including Balance Sheeting account reconciliation using SQL to integrate data from different sources for analysis
- Take the lead of Pfizer Collaboration Business Section with alliance revenue around 8 billion USD on consolidation reporting of which 80% collaboration business is under R&D area.
- Develop Dashboard Reporting using SQL and Sportfire based on detailed and complex analytical gaccounting models and database to support business decision
- Involve Domestic contract management and government pricing calculation to ensure our pricing meet government regulation and requirement.
- Demonstrate the ability to build up strong relationships with various functions within the corporate level and across colleagues in different countries on external reporting information consolidation.
Senior Financial Analyst
SABRA DIPPING COMPANY (Subsidiary of PepsiCo Group), NYC
08.2008 - 03.2011
- Successfully design company finance/sales data system to support budgeting and sales growth management. Achievement in budgeting with the variance between budget vs. actual is under 2% for consecutive 3 years.
- Develop a new cost driver for cost allocation recognized and applied by the company.
- Conduct sales and P&L annual budgeting and rolling forecast and develop KPI system
- Update financial forecast and analyze variances/trend on actual vs. budget monthly
- Analyze gross sales to net sales including fixed discount, variable discount, sales return, stales, and bad debt expense to increase promotion/trade spend efficiency and drive sales growth.
- Utilize SAP BOM to develop SKU product P&L and conduct COGs analysis
- Analyze business unit economic value measurement including ROI, NPV, and IRR analysis
- Perform corporate business and financial risk control and analysis including market risk, business risk, operating risk, financial risk including liquidity risk as well solvency risk analysis
- Handle multiple projects with a tight deadline
Education
Master of Science - Data Science
Stevens Institute of Technology
NJ, USA04-2021
MBA - Finance
Fudan University
Bachelor of Civil Engineering - undefined
Tongji University
Skills
- Customer Focus, Team Player, Analytical Mindset, Detail Oriented, and Quick Learner
- Proficient in Microsoft Excel (Expert level), Visual Basic, Word, PowerPoint, ACCPAC, SAP, SQL, R and Python, Tableau, Spotfire, PowerBI
Accomplishments
1. Develop Input Quality Control Program to support Data Driven Decision Model and avoid GIGO
2. Develop Data Driven Decision Model to support business growth and strategic decision
3. Develop Operation Simulation Program to act as alert as car side mirror alert to support operation efficiency and reduce operation risk
Languages
English
Full Professional
Certification
- Certified Professional Accountant
- Certified Management Accountant/Certified Cost Accountant
- Chartered Financial Analyst, CFA Institute
- PMP( Project Management Professional) PMI
Timeline
Sr Manager in Commercial Finance
Bavarian Nordic Inc.
01.2023 - Current
Budgeting Manager
Amgen Inc.
05.2021 - 12.2022
Sr. Financial Analyst and in the capacity of Finance Manager
PFIZER INC, New York, NY
03.2011 - 01.2021
Senior Financial Analyst
SABRA DIPPING COMPANY (Subsidiary of PepsiCo Group), NYC
08.2008 - 03.2011
MBA - Finance
Fudan University
Bachelor of Civil Engineering - undefined
Tongji University
Master of Science - Data Science
Stevens Institute of Technology