Gregory Fairchild

*** ********** **** • Maumelle, Arkansas 72113 • Home: 501-***-****

QUALIFICATIONS SUMMARY

Experienced Financial Analyst with exceptional background utilizing data from diverse financial

and information systems to build tools and forecasting models. Demonstrated track record

providing comprehensive financial forecasting, budgeting, and analysis to management at large

organizations. Strong technical skills including database development and querying/scripting using

PL/SQL.

BUSINESS EXPERIENCE

Situs Little Rock,

Arkansas

Business Analyst Apr. 2011 - Sep.

2012

• Develop and maintain MS Access insurance compliance and financial tracking databases

• Query and script Oracle data for the loan servicing operations

• Troubleshoot system issues and work help desk tickets

AT&T Little Rock,

Arkansas

Lead Financial Analyst Mar. 2005 -

Feb. 2011

• Produced annual budgets exceeding $2 billion and forecast models on a departmental, business

segment and consolidated basis working with functional department heads and corporate

leadership

• Analyzed and interpreted monthly variances and trends between budgets, actual and prior

results in developing projections and forecast

• Tracked and reviewed gross and net sales including activity by sales channel in producing

forecasts and trend analysis on an on-going basis

• Provided financial support and analysis to Operations and Marketing areas for strategic

business decisions and cost savings initiatives

• Analyzed customer level profitability

MortgageRamp, Inc. Little Rock,

Arkansas

Analyst Mar. 2003 - Mar.

2005

• Developed UNIX based databases to capture commercial real estate insurance data

• Analyzed the needs of the client and the integrity of the data collected

• Maintained databases, created reports and produced data tapes

Acxiom Corporation Little Rock,

Arkansas

Financial Analyst IV Mar. 2001 -

Mar. 2003

• Developed the company budget and the targets for each organization

• Developed the company level forecast

• Analyzed trends in the financial statements

• Prepared monthly/quarterly financial reports/analysis for executive management as well as for

the

quarterly earnings release and analyst conference call

Alltel Communications, Inc. Little Rock,

Arkansas

Manager II – Financial Reporting/Performance Analysis (Jan. 1999 - Mar. 2001) Mar.

1994 - Mar. 2001

• Developed dynamic performance analysis tools/reports for the analysis of business operations

• Responsible for all reporting and data integrity aspects of the JD Edwards accounting system

• Administrator for the Hyperion Enterprise financial information system

Manager I – Financial Planning (Jul. 1997 - Jan. 1999)

• Designed and implemented the Hyperion Enterprise financial information system

• Coordinated the financial planning for the merger of two companies

• Coordinated and designed the budget process

Senior Financial Analyst (Nov. 1996 - Jun. 1997)

• Developed the BTA financial valuation model for the Personal Communications Services

auctions

• Developed new wireless forecasting model that was used to develop the five-year business

plan

financial/key indicator projections as well as the monthly forecasts

Financial Analyst II (Dec. 1995 - Nov. 1996)

• Developed and used an acquisition model that calculated free cash flow and IRR information

that was used to guide management in cellular property investment decisions

• Designed and coordinated all budgeting and forecasting activities

• Designed and coordinated the Five Year Business Plan

Financial Analyst I (Mar. 1994 - Dec. 1995)

• Developed and implemented ALLTEL’s Cash Capital Model

• Developed the Retail Store Feasibility Model that determined if a new retail store would be

built

• Performed various financial and operational analyses to assist all corporate department

directors

in daily decisions

Univest Financial Group Little Rock,

Arkansas

Commercial Analyst Mar. 1993 -

Feb. 1994

• Developed the Derived Investment Valuation Model which valued large portfolios of

commercial

and residential properties

• Assisted in the operations of several multi-million dollar portfolio securitization deals

AVCOM Computers Little Rock,

Arkansas

Business Manager Aug. 1992 - Mar.

1993

• Purchased hardware/software, managed accounts receivable/payable, assembled computer

systems

IDS Financial Services Little Rock,

Arkansas

Personal Financial Planner Oct. 1991 - Mar.

1992

• Series7/63 licensed personal financial planner

Tyson Foods, Inc. Springdale,

Arkansas

Senior Account/Analyst (Aug. 1990 - Aug. 1991) Feb.

1990 - Aug. 1991

Staff Accountant (Feb. 1990 - Aug. 1990)

• Managed an office staff of six people

• Reconciled accounts and prepared the weekly statistical report

TECHNICAL SKILLS

• Generated financial models and templates utilizing Excel, including pivot tables and macros

• Designed and implemented relational databases utilizing MS Access

• Prepared presentations utilizing PowerPoint and other Microsoft Office applications

• Developed scripts/queries using PL/SQL

EDUCATION

__

University of Arkansas Fayetteville,

Arkansas

B.S.B.A. Finance Aug. 1985 -

May 1989

Overall GPA 3.56; Major 3.75

Contact this candidate