Junho Yi
Financial Planning and Analysis Manager at MAFCO Worldwide LLC- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Korean Native or bilingual proficiency
-
English Native or bilingual proficiency
Topline Score
Bio
Experience
-
MAFCO Worldwide LLC
-
United States
-
Food and Beverage Services
-
1 - 100 Employee
-
Financial Planning and Analysis Manager
-
Jan 2022 - Present
• Prepare financial and operational forecasts, models, and analysis to perform short-term and long-range strategic plans and operating budgets• Analyze trends pertaining to sales, operations, manufacturing, and other business areas to compare to budgets and forecasts to explain variances ($120M of annual budget)• Prepare analysis and presentation for the President and the VP of Finance to report business reporting to the parent company and to preside quarterly internal management meetings • Generate consolidated financial statements monthly and quarterly basis• Prepare cash management reports for internal and parent company needs and requests• Prepare footnote information for 10Q report regarding business analysis including sales Show less
-
-
Senior Accounting Manager
-
Apr 2021 - Jan 2022
• Reduced intercompany transactions balance by 98% by creating matching matrices for 7 legal entities and providing feedback to subsidiaries in China and France• Improved reporting sets by integrating and separating financial and managerial data generated by F9 (a financial reporting tool such as Hyperion Retrieve)• Reviewed and updated product formulas to update the standard costs of finished goods• Improved the visibility of production results by developing Excel functions and formulas, including macros• Acted as the Contact Point for annual and quarterly external audits (E&Y)• Participated in building internal control (SOX) process with outsourced consultants (PwC) Show less
-
-
Senior Accountant
-
Apr 2018 - Mar 2021
• Reconciled inventory accounts by reconciling manufacturing results, purchase receipts, and shipments• Reviewed and updated standard costs of raw materials and makes necessary journal entries according to the change in purchase prices by calculating weighted average costs• Performed month/quarter/year-end closing by making journal entries such as accruals and reclassification between general ledger accounts• Collaborated accounting closing and financial reporting with colleagues in subsidiaries located in China and France• Performed accounting closing for the subsidiary in Germany including adjusting balance sheet balances according to the FX rate of the month• Performed transfer pricing analysis bi-annually Show less
-
-
-
-
Financial Planning and Analysis Manager
-
Sep 2017 - Apr 2018
• Oversaw expense accounts by developing and maintaining a financial dashboard • Participated in ERP transition from SAP to Intacct as the owner of accounting and finance modules • Performed annual mid/long term consolidated financial planning to secure budget (60M of annual budget) by creating a budget model spreadsheet• Supervised accounting analyst on the accounting closing including external audit supports
-
-
Financial Planning Analyst
-
Sep 2016 - Aug 2017
• Performed Consolidated budgeting for US, UK, and Korea Entities• Handled US entity accounting closing with share finance service center• Participated in government (DOE) funding project as a finance part owner• Handled financial reporting to shareholders in Korea
-
-
-
Stern & Eisenberg
-
United States
-
Law Practice
-
1 - 100 Employee
-
Financial Analyst
-
Oct 2015 - Sep 2016
• Developed management reports such as client analysis report by using MySQL Workbench• Improved accounting process by combining AP function of the parent and AR of the subsidiary• Audited invoices from service providers and confirmed the validity of AP by processing a large amount of data • Improved and modified the automatic triggers of the charges of CaseAware (an operational system for law firms) as the system administrator of accounting and billing modules
-
-
Billing Analyst
-
Oct 2014 - Sep 2015
• Created matching reports to detect unsuccessful invoicing by matching the data extracted from clients’ portals to monitor the status of the billed invoice• Performed billings to mortgage banks to get the reimbursement for legal services
-
-
-
TE Connectivity
-
Switzerland
-
Appliances, Electrical, and Electronics Manufacturing
-
700 & Above Employee
-
Financial Reporting Intern
-
Sep 2012 - Aug 2014
• Collaborated with Tax Systems team on developing Access Transfer Pricing model • Validated inputs and outputs between Excel Transfer Pricing model • Assisted in creating quarterly Transfer Pricing adjustment entries • Created a draft level of Transfer Pricing (TP) reports with monitoring the TP requirement status for 130 subsidiaries worldwide • Collaborated with Tax Systems team on developing Access Transfer Pricing model • Validated inputs and outputs between Excel Transfer Pricing model • Assisted in creating quarterly Transfer Pricing adjustment entries • Created a draft level of Transfer Pricing (TP) reports with monitoring the TP requirement status for 130 subsidiaries worldwide
-
-
-
Rider University
-
United States
-
Higher Education
-
700 & Above Employee
-
Graduate Research Assistant
-
Jan 2009 - May 2014
• Gathered, sorted, and analyzed academic and administrative research data for business school finance department • Graded homework assignment and quizzes for international finance, portfolio management, and investment classes • Gathered, sorted, and analyzed academic and administrative research data for business school finance department • Graded homework assignment and quizzes for international finance, portfolio management, and investment classes
-
-
-
AIG
-
United States
-
Insurance
-
700 & Above Employee
-
Accounting Clerk
-
Sep 2011 - Aug 2012
• Reconciled intercompany exposure analysis to original data including streamlining Access model to get intercompany comparison report • Integrated and customized Underwriting Statements (income statements) for management decision making • Reconciled intercompany exposure analysis to original data including streamlining Access model to get intercompany comparison report • Integrated and customized Underwriting Statements (income statements) for management decision making
-
-
-
LG Credit Card
-
Gangnam-gu, Seoul, Korea
-
Business Analyst
-
Jun 2000 - May 2002
• Performed customer complaints analysis by using Oracle database containing 10M membership of data • Mediated conflicts between the company and government agencies regarding financial security issues • Performed customer complaints analysis by using Oracle database containing 10M membership of data • Mediated conflicts between the company and government agencies regarding financial security issues
-
-
Education
-
Udacity
Nanodegree, Business Analytics -
Rider University
Master of Business Administration (MBA), Finance -
Rider University
Bachelor’s Degree, Accounting -
Ocean County College
Associate’s Degree, Business Administration and Management, General -
Hanyang University
Bachelor’s Degree, Law