Sales Management
Resume:
ANDREW SCHMITT, MBA
Canton, GA 30114
770-***-**** Home 678-***-**** Cell
******.*******@****.***
[pic]
SUMMARY
Business analyst with >10 years of individual contributor experience
primarily in a Fortune 20 company, providing comprehensive financial
management reports with detailed analysis for executive review. Broad-
based background includes accounting and staff management oversight.
Committed team player and strong communicator, with proven ability to meet
and exceed goals and deadlines and to build collaborative working
relationships with all employee levels. Areas of expertise include:
Strategic Planning, Budgeting, and Process Improvement
Forecasting
Project Management Financial Reporting Supervision
Quantitative/Qualitative Reporting Operational and Financial
including Variance to Budget and Forecast Performance Tracking and
Explanations Trending Metrics
TECHNICAL EXPERTISE
Software: Microsoft Office Suite including Excel, Access, PowerPoint,
Word, Project, and Visio
Data manipulation techniques: Linking, pivot tables, advanced macros, SPSS,
and SQL
Systems: PeopleSoft, Oracle, SAP, Crystal Reports, SAS, Essbase, and
Hyperion
PROFESSIONAL EXPERIENCE
VERIZON BUSINESS, INC., Atlanta, GA
9/2007 - Present
Senior Financial Analyst, Enterprise Sales Finance
Developed executive level sales and revenue forecasts and sales funnel
reporting for worldwide operations with annual sales of >$300M and annual
revenue of >$4B. Developed complex Excel models and Access databases
utilizing advanced macros to both improve the efficiency of the process and
to track key performance indicators including plan attainment, product mix,
customer mix, and variance to plan.
. Managed the monthly revenue forecast for the top 200 enterprise worldwide
customers with annual revenue >$1M (Premier Segment) and reduced by 50%
preparation time of an executive summary package highlighting key
forecast metrics.
. Prepared monthly contract write down analysis for the Premier Segment
Sales President that combined feedback from field contacts and contract
management group and highlighted >$100M of revenue exposure.
. Developed a comprehensive monthly sales stratification presentation to
identify revenue and industry focus areas for sales teams and utilized an
Access database to reduce report preparation time by 75%.
. Partnered with international contacts in EMEA and Asia Pac to normalize
reporting inputs and drive more timely updates to sales and revenue
forecasts.
. Collaborated with worldwide regional contacts and FP&A to manage annual
sales plan alignment at all levels of the organization.
ARBY'S RESTAURANT GROUP, LLC, Atlanta, GA
9/2006 - 9/2007
Senior Financial Analyst, Planning & Analysis
Consolidated weekly comparative sales results for the CEO and external
reporting requirements, comprising company owned and franchise locations
worldwide with annual revenues of $1.2B. Developed models for over 90 cost
centers in support of annual budget process. Prepared monthly G&A risks
and opportunity reporting.
. Streamlined the production of weekly and monthly sales reports by 75% by
utilizing online reporting inputs and improving existing Excel report
templates.
. Researched and budgeted relevant costs for a public company cost center
in anticipation of a planned tax free spin off of Arby's from TRIARC in
2007.
VERIZON BUSINESS, INC. / MCI, Atlanta, GA
9/2003 - 9/2006
Senior Business Analyst, Sales Planning & Analysis, 10/2004 - 9/2006
Prepared sales, install, and disconnect results weekly for worldwide
segments for dashboard reporting. Supported contest and compensation
reporting requests. Supported one junior analyst dotted line report.
. Developed a contest database that increased reporting efficiency by 50%
and supported multiple successful contest programs in 2006.
. Collaborated with Verizon counterparts to project manage combined MCI and
Verizon sales, install, and disconnect reporting for Verizon Business
President within 10 business days of legal merger completion.
Revenue Assurance Analyst, Accounting Systems Management, 9/2003 - 10/2004
Led a comprehensive review of billing system reconciliations to drive
process improvements and increase audit efficiency, ensure SOX compliance,
and meet accelerated month end close date.
. Developed an automated method to reconcile 13 billing system platforms
and reduce reconciliation time by more than 60%.
. Project managed Sarbanes-Oxley documentation for billing, accounts
receivable, and call traffic reconciliations and worked with the external
auditor on quarterly review deliverables.
FIRST NORTH AMERICAN NATIONAL BANK (subsidiary of Circuit City), Kennesaw,
GA 9/2002 - 8/2003
Risk Analyst, Bankcard Credit Operations
Prepared monthly credit card portfolio and strategy tracking for senior
management that incorporated data mining of transactional data and credit
bureau detail.
. Developed credit line, reissue, and over limit authorization management
strategies for the FNANB Visa card to help minimize portfolio risk and
maximize portfolio return.
. Implemented a new credit line increase strategy built on statistical
analysis that identified more profitable accounts and reduced account
charge off rates by 16%.
WORLDCOM, INC. (currently known as Verizon Business), Atlanta, GA
6/2000 - 9/2002
Financial Analyst, Sales Planning & Analysis
Analyzed sales data for Asia Pacific, European, and North American regions
to provide reporting and variance analysis commentary for senior
management.
. Implemented an automated method to reconcile Asia Pacific region sales
data that streamlined the commissions submission process by 50%.
. Provided reporting to the contest marketing department to support
incentive programs that accelerated the majority of sales team order
entry from the final 3 days of the month to the final 2 weeks of the
month.
CIRCUIT CITY STORES, INC., Richmond, VA
8/1997 - 5/2000
Corporate Financial Trainee management fast track program member
Rotated into key finance and accounting positions every 6 to 9 months in
both individual contributor and supervisory roles for company with sales >
$10B, supervising both hourly and salaried employees.
Supervisor, Treasury Cash Management
1. Supervised a staff of 5 responsible for daily wire and automated
clearing house (ACH) transactions, overseeing investment and borrowing
activity.
2. Negotiated an $80K annual decrease in fees with a key relationship bank
after a thorough analysis.
Supervisor, Financial Reporting
3. Supervised a staff of 5 responsible for internal financial reporting for
company wide cost center owners.
4. Reduced the month end close cycle time by 50% with the implementation of
PeopleSoft Financials.
Financial Analyst, Accounting
5. Analyzed profit and loss statements monthly to develop variance analysis
for senior management.
6. Developed an automated method to reconcile 25 balance sheet accounts and
a method to book accruals that reduced the time required from 1 day to 1
hour.
Supervisor, Payroll Department
7. Supervised a staff of 7 responsible for wage attachment to ensure all
legal obligations were satisfied.
8. Managed the year-end bonus project for the entire company in cooperation
with systems and compensation.
EDUCATION
MBA, Finance, Robinson College of Business, Georgia State University,
Atlanta, GA, 2005
BS, Business Administration, Finance, University at Buffalo, Buffalo, NY,
Summa Cum Laude
Contact this candidate