Manager Sales

John.Gallo.CPA.Resume.Current

John J. Gallo, CPA

Lakewood, CO 80226 abqoyu@r.postjobfree.com 303.330.7350m 303.989.9169h

Accounting and Finance Professional with over 20 years of diverse industry experience. Demonstrated excellence in small entrepreneurial companies as well as Fortune 500 companies. Values innovative solutions to increase effectiveness. Cross functional team player supporting accounting, finance, management reporting, and system utilization. Creative, accurate, efficient, system oriented report generation. Development of exceptional database manipulation and report writing skills. Monitoring organization controls, policies, and procedures for effectiveness. Proven aptitude for contract administration and contract negotiation. Outstanding at coaching, motivating and training. Excellent software skills. Proven ability to learn and master new software packages and report writing tools.

Areas of Expertise

GAAP & IFRS AccountingBudgeting & ForecastingBusiness Case AnalysisFinancial Planning & AnalysisProject ManagementProcess ImprovementsFinancial & Management ReportingFinancial ModelingPolicy Redesign & Development

Highlighted Contributions:

Participated in presentations which secured $35 million in equity funding for Startup Company.

Mechanized all accounting, including hiring and training personnel of Start-up Company while moving the headquarters and growing the company from 25 employees to 500.

Secured bank financing for international sales enabling $1 million in sales to Australia and India

Implemented enterprise wide time reporting system increasing reporting efficiency and analysis of actual time worked.

Implemented creative system to efficiently and accurately update financial reporting and drill-down capability replacing inefficient complex workbooks with links which often caused errors.

Ace Award received for BPM team participation increasing subscription revenue $700 thousand per year and improving controls over revenue generated by third party vendors.

Career History & Performance

Standard and Poor s, Denver, Colorado 2001-2011

Senior Finance Manager (2009-2011)

Persuaded Executive Management to obtain budget authorization for 10 additional product development headcount, contributing to increased revenue of $8 million.

Influenced product development priorities highlighting financial implications, reducing cost & increasing revenue.

Participated in team migrating CRM to salesforce.com including interface of client development order entry, approvals, new product code setup and interface with entitlement personnel and systems, to ensure entitlement changes correspond to billing changes.

Participated in team successfully migrating all accounts receivable/billing/revenue recognition to new partition modifying processes, creating new product codes, and testing results.

Retained all responsibilities of former positions as finance manager and Financial Planning Analyst.

Finance Manager (2004-2008)

Supervised and coached accounting staff. Nominated employee who became Gold ACE award winner.

Reviewed all account reconciliations improving process with lookup functions to improve accuracy & timeliness.

Created SOX process documentation & provided quarterly confirmations Evaluated/improved processes/controls.

Retained all responsibilities of former position: Financial Planning Analyst.

Financial Planning Analyst (2001-2003)

Developed effective method of updating financial results by pulling, then validating data from GL system, & summarizing results with pivot tables using lookup functions to control summary levels.

Created complex Budget & Estimate models, uploading them into corporate rollups.

Designed analysis and trend projections.

Provided functional and regional summaries for operational directors.

John J. Gallo, CPA

Page 2

Qwest/US West, Denver, Colorado 1992-2001

Senior Financial Analyst - Communications and Wireless (1995-2001)

Refined skills of: complex modeling, budgeting, variance analysis and projections both at detailed levels to

benefit operations and at high summary levels for executive review.

Designed and implemented innovative process of data extraction, validation and summarization. Published flexible

reports, utilized by all Wireless finance, providing drill down capability, reducing time needed for research, and

increasing precision of projected results.

Uploaded monthly Current Estimate and Annual budgets into Corporate rollups with Hyperion

Assembled operational budgets and transfers, produced variance analysis and trend forecasts for operational

directors. Designed executive vice president presentations.

Developed ability to work with large amounts of data including extraction, validation, summarization, and

Report generation including analysis, drill down, what ifs, trend forecasts, sensitivity analysis, and diagnosis.

General Ledger Accountant/Analyst - Federal Services (1992-1995)

Utilized UDMS to pull data for drill down research of account activity. This improved the speed, accuracy and timeliness of our financial statements.

Worked on teams pricing Federal Government and private company contract proposals, modifications and changes.

Provided finance documentation and contract administration for DOE contract change orders in Oakridge and Hanford.

Negotiated changes to supply contracts. Produced monthly affiliate billing.

Presidents Club Awarded for leadership displayed directing a team to create an RFP response to a major customer.

Computer Applications

IBM Cognos TM1

Oracle OFA

Hyperion

Salesforce.com

Lawson

PIMS A/R - Revenue

Crystal Reports

Captura

Concur

PMP

Microsoft Office Suite

MS Excel (advanced)

Pivot Tables

Vlookups

Data validation-analysis

Education/Certificates/Licenses

Bachelor of Science Business Administration/Accounting

Graduated with Departmental Honors in top 10% of class, University of San Diego

Masters Level Certificate in Government Contract Management, University of Phoenix

Licensed Certified Public Accountant CPA Colorado

Colorado Society of Certified Public Accountants

Contact this candidate