Sr. Financial Analyst
CurrentPreparing annual budget, quarterly forecast for sales, purchase, production cost and production spending, gross margin and net profit income; conducting actual vs. budget variance analysis, price analysis and product cost analysis, sales by customer, profit margin by customer/program etc. working on monthly closing by making accrual, adjustment journal entries; loading financial data from SAP to Hyperion financial management and Hyperion planning; generating financial reports and other ad hoc reports from Hyperion Essbase; setting up templates for budget and other financial reports, etc. Maintaint sales and cost database, labor utilization database by using Access and SQL report, generate needed data for annual budget, quarterly forecast and monthly current view.
