Business Analyst

Randall Brian Smith **** Whitfield Street

678-***-**** Smyrna, GA 30080

Summary Statement

Eight years of experience in an analytical role with progressive

responsibilities in economic analysis and budgetary policies. I utilized

advanced techniques in Excel such as, VLOOKUP, Pivot Tables and advanced

formulas. Working as a research analyst and business analyst I have gained

valuable analytical skills that have allowed me to perform in many

different roles such as, finance, economics and business. Advancing

through a Master's degree in economics gave me solid analytical, technical

and problem solving skills as well as a firm background in economic theory

and statistical concepts.

Relevant Experience and Accomplishments

Amdocs March 2014 -

Current

Contract Ends July, 2014

Senior Business Analyst

. Build predictive models in Excel to show the change(s) in Willingness to

Recommend Scores (WTR) based on reduced call volume and increases in

customer satisfaction

. Conduct telecommunications benchmark studies for AT&T and present the

results to senior executives.

. Use advanced Excel techniques such as Sparklines to show trends in

financial and survey data

. Run SQL queries to calculate WTR by month and levels

. Conduct presentations for Amdocs executives outlining consulting

strategies for AT&T projects and their new product lines

The Colography Group (Transportation Consulting Firm) March 2008 -

August 2008

December 2011 - June

2013

Business Analyst

. Sold comparison analytical rate reports to the United Postal Service

. Utilized Excel for comparing and cleaning data (Pivot Tables and VLOOKUP)

. Researched and present financial data on transportation firms

. Conducted various statistical analyses on industry data provided by

transportation firms such as FedEx and UPS

. Worked closely with the president on consulting strategies

. Wrote summaries on world macroeconomic environment for various

transportation firms such as TNT and Yamato Transport

Governor's Office of Planning and Budget August 2008 -

August 2009

Sept. 2007 - March 2008

Policy Analyst

. Played an integral role in creating a new $1.2 billion budget for the

Department of Transportation (DOT) and the budget for the Department of

Natural Resources

. Analyzed and approved state agency budget amendments and allotments

. Prepared recommendations on agency budgets within various programs

. Wrote and edited sections of the Governor's Budget report

. Trained new members of the Governor's policy analyst team

Kingsley Associates (Research Consulting Firm)

May 2007 - Sept. 2007

Associate Analyst

. Utilized SPSS and advanced Excel techniques (such as pivot tables) on

a regular basis

. Analyzed risk management programs for companies with assets in excess

of $4 billion

. Performed extensive statistical analysis on tenant and resident

satisfaction surveys

. Presented key findings and suggest improvements to increase tenant

retention

. Advised asset and property managers on industry best practices

. Provided management consulting to a variety of property management

firms

American Transportation Research Institute, Smyrna, GA May

2006 - May 2007

Research Analyst

. Performed regression analysis, both linear and non-linear using Excel and

SPSS

. Delivered presentations to industry leaders regarding research results

. Served as project manager for federal research projects

. Performed cost benefit analysis concerning new safety technologies

. Designed scenarios for freight mobility modeling software that allowed

for a company to predict trip times, pollution and other metrics

Education

Georgia State University, Atlanta, GA May 2006

Master of Arts in Economics

GPA: 3.3

Mercer University, Macon, GA December 1998

Bachelor of Arts in Philosophy and Political Science

Computer Skills

SPSS

SAS

Excel

Access

Word

Outlook

PowerPoint

SQL

Crystal Reports

PeopleSoft

Publications

Coauthor: "Economic Development and Reconstruction on the Gulf After

Katrina." Economic Development Quarterly. Summer 2006.

Coauthor: "Top Industry Issues for the Trucking Industry." American

Trucking Associations

Fall 2006. http://atri-online.org/CP34.PDF

Contact this candidate