Loan Phung, Mba Email and Phone Number

- Identify revenue opportunities by conducting variance analysis from the billed fees with the pricing in the contract.- Ensure pricing and hierarchies correctly set up in the system.- Work closely with Residual and Billing teams to reconcile the total processing revenues for each client.- Gather and analyze billing and sales data from different databases by using different software: SQL, Access and Toad.- Provide reports covering analysis on cost, revenue, discounts and the adjustment to clients.- Develop pricing grids for products and services sold and/or leased.- Recommend business policies and conduct special financial and business related studies.- Respond pricing requests and communicating pricing to Sales management.- Present recommendation to management.- Coordinate with teammates to automate the process.- Provide training and support to lower level Financial Analysts.- Deliver some financial and business related analysis and research in such areas as financial and expenses performance, costing and budgeting.

- Generated financial and operational performance reports - Provided analysis on product margin, revenue, pricing, and mark shares addressing key issues and explaining causes.- Analyzed financial variances of actual vs. forecast.- Gathered and compiled data to create different type of charts, graphs and dashboard for profitability analysis and operational efficiency analysis.- Built and maintained essential reports for end user to support other departments including Sales, Transportation, Manufacturing and HR.- Prepared monthly and annual budget and forecast for purchases and sales volumes.- Worked closely with Direct of FP&A to develop annual Cash Flow projection model and financial statements.- Created other special analytical reports to support business decisions.Accomplishment:- Built effective and critical reports from scratch by using Excel, Access, SQL, Tableau and Alteryx (Key reports includes Profit model, Margin Analysis Model, Production Dashboard, Financial Statement, Inventory Model, etc.).- Provided necessary support to track key metrics for business, improve the business performance and facilitate business decision making.

- Provided tutorial and academic support to undergrad and graduate students in Finance, Accounting, Math and Statistics. - Assisted professor in lecturing Math.- Assisted students to improve study skills.

- Responsible for key clients such as Coca-Cola, Western Union, Strepsils, Cartier.- Worked closely with clients and marketing agency to develop the media strategies in accordance with clients' marketing campaigns.- Proposed budgeting models to clients.- Gathered and analyzed data to make decisions on the best media vehicles.- Created media plans to maximize the reach of potential/target customers and to minimize costs.- Built detailed media plans on TV, Press, Digital and Outdoor.- Developed variance analysis on the plan and actual performance.- Worked and maintained a good contact and relationship with Media Owners.- Presented results to upper managers and clients.

- Allocated budgets and proposed marketing strategies to increase revenue and margin.- Handled purchase, sales and inventory control.- Compared actual to budgeted results of each reporting period, and report on significant variances.- Provided analysis reports on sales, purchases and market shares.