• Developed and led implementation of new accounting system for an auto manufacturer, harmonizing previously incompatible systems across 52 dealer groups, improving OEM client with standardized reference for operational analyses.• Led team of 10 to complete off-site audit for leading American Luxury auto brand’s 160+ dealer and perform sampling testing, identifying 20% overall reporting errors and rectifying overall, ensuring the accuracy of the reviewed financial data for issuing network profitability report, group profile and dealer operational report, etc.• Conducted network ESB research and interviewed with 15+ selected sales managers from well-performed and underperformed dealers about ESB product types, sales strategy and performance management to find out ESB sales pain points.• Created and optimized reviewing procedures from traditional format to compounding one, helping team and dealers identifying basic business problems and data issues ranging from NV business, Aftersales business to expenses efficiently and having more smooth and targeted connection with financial managers, saving 20% of time in monthly audit period without increasing staff.• Conducted data analysis and assisted MIC issuing network profitability report, regional profitability report and group profile, creating new analysis tools for team and increasing analyses efficiency by 15%+.

• Traced and updated ferrous market data on daily and weekly basis, such as operation rate, inventory.• Calculated the implied sales and traced the actual sales to assist analysts with fundamental analysis.• Updated the steel price and calculated the spread between ferrous metals’ products and billets to guide analysts and traders.• Consolidated the ferrous supply and demand data and price data and developed Tableau analytics dashboards for specific reporting to support the steel team.• Utilized Tableau to maintain the steel dashboard.

• Advised customers about how to use the learning system to customers via e-mail or phone;• Managed Ford DW learning system database and analyzed the data with Excel Pivot table;• Gathered and filtered weekly research reports from the database and designed the weekly report with graphs and charts to illustrate findings to consultants.

• Provided financial products and suggestions for clients’ loan needs• Reviewed clients’ financial statements and credit history;• Guided customers prepare regulatory supporting documents and analyzed their performance;• Helped managers prepare facility letter and security documents.