Management Analyst

Christopher D. Agnew

**-** **** ******, *********, NY 11104 ? Mobile: 203-***-**** ?

*****.*****@*****.***

SKILLS SUMMARY

. Achieved six figure cost savings as lead analyst on audit of internal

accounting systems.

. Delivered improved policies and processes to optimize department

efficiency and transparency.

. Team leader on multiple projects that led to successful transformations

in quality of service and analytical support.

. Ability to perform advanced dataset analyses on high volume of data in

multiple industries.

. Advanced MS Office expertise (Excel, PowerPoint, Access, etc.) as well

as database systems proficiency (SPSS, Oracle, Magic).

PROFESSIONAL EXPERIENCE

Canon Business Solutions Feb. 2008 - Present

Reporting Analyst - Providing customized reporting metrics as well as

capturing data pertaining to reprographics equipment and services to

deliver demonstrable gains in organization's fleet management operations by

initiating continuous workflow process improvements.

. Designing automated reporting processes utilizing complex criteria

built into nested, lookup, array and conditional formulas, with auto-

correcting and error checking functions, to manipulate source data and

transform it into meaningful charts in PowerPoint.

. Creating customized client reporting using an automated synthesis of

data inputs in an interactive, user friendly format to provide new data

analysis and viewpoints enabling identification of trends and informed

decision making for client service management.

. Developed standardized reporting template for largest client, including

automated reports within invoices, that produced demonstrable gains in

business through acquisition of analysis and reporting responsibilities

from competitors.

. Establishing and maintaining reporting metrics for nineteen clients as

well as managing ad hoc reporting such as utilization metrics, cost

analysis, database management in Access and automated service tracking

systems.

. Providing project management support by meeting with clients to

customize reporting to their needs, discuss monthly and quarterly

performance metrics and ensure compliance with contract standards

through on-site assessments.

. Executed detailed audit of internal financial systems that uncovered

inconsistencies as well as helped to develop improvement approach and

implementation roadmap that led to immediate cost savings.

Ipsos-ASI Dec. 2006 - Jul. 2007

Database Analyst - Provided relational database management system support

for advertising research firm by creating metadata from numeric and string

data as well as designing data entry platforms.

. Cleaned and filtered open-ended responses within forms and surveys

using complex error finding techniques to ensure accuracy of analysis

assumptions as well as easy integration of information into data

warehouse.

. Standardized video and print advertisement content as well as survey

content and responses using complex coding criteria and also created

and revised coding categories to help better capture attitudes,

opinions and perceptions.

. Helped build SPSS data entry forms as team member on market research

project by creating codebooks, classifying data and designing

validation procedures using command syntax language to program pull-

down menus and alerts.

First Reserve Corporation Jul. 2006 - Oct. 2006

Assistant Analyst - Provided support for Financial Analysts at Private

Equity firm specializing in the Energy Industry by analyzing comparative

performance, financial statements and capital budgeting to enable financial

modeling for prospective investment opportunities.

. Executed detailed financial statement analysis by employing activity,

profitability, debt and liquidity ratios as well as cash flow

forecasting to accurately estimate internal rates of return.

. Researched industry competitors, provided risk assessment and common

size analysis in order to determine market multiples and forecast

industry as well as competitor discount rates.

. Developed complex conditional statements in Microsoft Excel in order to

create probability distributions and statistical analysis for

clarifying the assumptions of financial models.

FORMAL EDUCATION

Pitzer College - Claremont, CA

Bachelor of Arts with a Major in Economics - 2006

ACTIVITIES

California Youth Correctional Facility

2006

Volunteer Teacher - Designed course on English and written expression,

created detailed lesson plans and taught the course to a group of ten

juvenile delinquents as part of a program focusing on outreach to

underprivileged youths.

. Helped students research and apply to college's as well as prepare and

deliver a sample of their work to an audience at Pitzer College.

Pitzer Student Investment Committee 2004-2006

Technology Analyst - Managed a portion of Pitzer's endowment as a member of

student-run investment portfolio whose profits were used to help fund

scholarship programs.

. Discussed and analyzed financial statements, stock reports and

portfolio combinations using Microsoft Excel and Portfolio Theory as

well as presented security analysis reports to club members and met

annually with College Board to discuss portfolio's performance.

Contact this candidate