Project Sales

John F. Fairhurst

*** ** ***** ******, ********* 15C

Kansas City, MO 64155

Mobile: 816-***-****

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

SUMMARY

Analyst with corporate and government budgeting, forecasting, and

performance analysis experience. Creative designer and developer of

systems and processes for budgeting, forecasting, analyzing and reporting

financial and operational information with the ability to assimilate and

synthesize information. Self motivated performer capable of working to

achieve organizational goals.

PROFESSIONAL EXPERIENCE

STATE STREET, Kansas City, MO 2008-2009

1 Financial Analyst/Officer

Responsible for the budgeting, forecasting and reporting of monthly

headcounts for Kansas City operations, the analysis of cost saving

initiatives and the development of monthly P&L statements for client

groups.

. Audited and reconciled multiple headcount reports to assist upper

level management in understanding variances and discrepancies.

. Developed processes to budget, forecast and report monthly

headcount expense and revenue information on a continuous basis.

. Prepared monthly client profit and loss statements using various

mainframe and windows based software packages.

. Mapped the information and logic string for the monthly P&L

Statement process.

. Wrote detailed instructions for the monthly P&L Statement process.

. Outlined a redevelopment of the Monthly P&L Statement process from

a vertical to horizontal structure. (The change would have made it

easier for restatements to be performed.)

. Worked on various business models to assist in cost leadership

initiatives.

. Coordinated building new systems to report cost saving initiatives.

Sprint, Overland Park, KS 2000 - 2007

2 Financial Analyst II

Responsible for data mining information for the budgeting, forecasting and

monthly variance analysis for wireless access expense ($45M) and dedicated

wire-line access expense ($75M) using SQL, MS Access and MS Excel.

. Built reporting and analysis systems for emerging business

segments.

. Developed and standardized the monthly variance reports used to

communicate the month to month expense and actual to budget

variances in a rate/volume/mix context to managers, directors and

vice-presidents.

(Continued)

Sprint Financial Analyst II (continued)

. Participated in writing proposals and specifications for various

types of IT projents.

. Automated various aspects of the analysis and reporting processes

that saved an estimated 100 hours of report development time a

month. (Ad hoc versus database system)

. Detailed monthly variance instruction from two pages of highly

generalized instructions to forty-seven pages of desktop process

manual.

. Led two IT contractors to enhance current processes and to develop

more effective costing systems.

. Participated in various cross functional meetings including

representatives from sales/sales support. marketing, IT,

engineering, planning and accounting.

. Assisted in the development of business models for various sales

and sales support groups.

. Performed trend analysis to assess risk and opportunities to the

budget.

. Developed budgets and forecasts using a variety of methods;

including regression, top-down, bottoms-up methodologies.

. Provided ad hoc reporting to assist Sprint managers in financial

decision making.

1 City of Kansas City, Aviation Department, Kansas City, MO 1985 - 1999

1 Engineering Aide III/Project Coordinator

Responsible for all facets of project management including, assisted in

project design and development, contract administration, on-site quality

assurance, documented all project progress, field conditions, problems and

resolutions. Coordinated all material testing. prepared and reviewed all

pay estimates and change orders to ensure accuracy and conducted all

project closeout processes. Developed budgets, cost estimations and project

scheduling processes. Monitored certified payrolls, MBE and WBE activities

to make sure wages and contract participation goals were being met.

. Scratch built various project cost estimation systems producing an

overall accuracy of +/- 5%.

. Developed and maintained various custom costing systems and project

management schedules.

. Combined several division schedules and reports into a single data

source that reduce redundancy and records maintenance time by 20%.

. Built budgets and projects costs for various types of construction

projects.

. Assisted in contract administration by preparing and reviewing various

types of contracts, purchase orders, RFP's, RFQ's, pay estimates and

change orders.

. Administered project business meetings with tenants, contractors and

other divisions to ensure airport facilities and operations were

maintained.

. Simultaneously administered up to eight renovation and expansion

projects at various KCAD facilities.

Education

Bachelor of Science, Business Administration, William Jewell College,

Liberty, MO, 1999

Contact this candidate