Financial Analyst with strong Excel, MS Access and VBA skills

ZIMING (JIMMY) WU

***** ******** *** *****: ******@*****.***

Northville, MI 48168 Mobile Phone: 408-***-****

SUMMARY

Experienced financial analyst in the area of financial analysis, budgeting, and forecasting with a Fortune 10 company. Demonstrated ability to complete multiple tasks simultaneously, meet deadlines and business requirements. Highly motivated, analytical and detail-oriented. Multilingual in English, Mandarin Chinese and Japanese.

PROFESSIONAL EXPERIENCE

Senior Financial Analyst Accretive Solutions, Troy, MI 2009-present

A national consulting firm with over 1000 consultants nationwide

 Developed a revenue management cost model in MS Access to support ad-hoc financial analysis.

 Developed a personnel management database in MS Access for budget and projection support.

 Automated data download and upload processes, and validated data integrity and quality using Hyperion Essbase, Access Database, Excel and VBA programming.

 Customized financial reports to support various analytical and presentation needs using Access Database, Excel and VBA programming.

 Conducted ad hoc analysis to fix account gaps and supported planning and budgeting process.

Senior Financial Analyst FORD MOTOR COMPANY, Dearborn, MI 2007-2009

 Consolidated month-end accounting close of manufacturing inventories for 20 plants. Coordinated plants to reduce monthly manufacturing inventories from $1.2 billion in 2007 to $0.65 billion in 2008.

 Conducted budgeting and forecasting for plants’ manufacturing inventories.

 Performed ad-hoc financial analysis and provided key financial performance reporting for marketing and sales department.

 Reconciled accounting data in Business Object, PeopleSoft General Ledger and Hyperion Essbase, and made recommendations to management. This improved the reliability and usability of new data marts in Business Intelligence System.

 Managed the process of gathering, validating and uploading key financial data from various data sources. Conducted data analysis using MS Access database, Excel Macros, pivot table and VBA programming. Improved unit vehicle cost data uploading process from 7 days to 3 days.

 Performed do vs. buy cost analysis for selected vehicle components and made strategic recommendations to management. This saved $180 millions annually for the transmission division.

Software Engineer NANOMETRICS INC., Milpitas, CA 2000-2005

A leading semiconductor equipment manufacturer.

 Analyzed and translated engineering requirements into software specifications. Designed, developed and tested multi-threaded real-time application programs for semiconductor measurement tools using VC++, STL and SQL.

 Led development and integration of a close-loop control software module in a diverse engineering team. This new product increased the company’s revenue by 30% in 2003 and 2004.

 Managed development of a networking software module, significantly increasing yield and reliability of thin film measurement tools. This software product increased the company’s market share by 15% in Asian market.

Software Engineer SELECTQUOTE INSURANCE, San Francisco, CA 1999-2000

A large life insurance brokerage firm

 Developed a client-server database application program using Visual Basic 5 and SQL Server.

 Supported accounting department to improve data transfer and data validation processes.

Process Engineer APPLIED MATERIALS, Santa Clara, CA 1997-1999

A Fortune 500 semiconductor equipment company with $10 billion annual sales.

Division Manager SPG INDUSTRY LIMITED, Guangdong, China 1991-1994

Mechanical Engineer SPG INDUSTRY LIMITED, Guangdong, China 1988-1991

A joint venture between Japan and China

EDUCATION

M.B.A., Finance, Indiana University, Bloomington, IN GPA 3.5/4.0 2007

M.S., Electrical Engineering, Rensselaer Polytechnic Institute, Troy, NY GPA 3.7/4.0 1996

B.S., Materials Engineering, Shanghai Jiao Tong University, China GPA 3.8/4.0 1988

PROFESSIONAL SKILLS

 Adept at Excel spreadsheet modeling, SQL, VBA programming, and database management.

 Proficient with Business Intelligence Tools, PeopleSoft General Ledger and Hyperion Essbase.

 Solid data mining skills with MS Access and MS SQL Server.

 Extensive knowledge of derivatives, bonds and equities.

Contact this candidate