Manager Sales
Resume:
Las Arredondo, CPA
Prosper, TX 75078
Home: 972-***-**** Cell: 214-***-****
************@*********.***
Summary of Experience:
CPA with over 15 years experience in finance, auditing, compliance, accounting,
internal and external reporting.
Accomplished leader and coordinator of forecasts and budgets ranging from $20
Million to over $10 Billion.
Extensive knowledge of BI Tools - Hyperion Essbase, EAS, Application Manager,
and Business Objects.
People-friendly, effective communicator, team player and department leader.
Professional Experience:
Fannie Mae; Dallas, TX (12/07 to Present)
Manager - Real Estate Owned (REO) Sales Business Analysis & Compliance
Direct the real estate investment reporting for over $25 Billion in Assets.
Direct the sales reporting and analysis for over 200 Asset Managers, Sales
Managers and Sales Directors.
Direct completion of monthly performance presentations, forecasts and annual
budget.
Led company in saving over $5 Million per year in fee payments to Outsourcers.
Improved Asset Manager productivity by enhancing Property Listing process.
Improved various other processes through scripts.
Built Compliance Function and Team to ensure 16 outsourcing companies follow
REO Sales policies.
Responsible for risk assessment, planning and reporting of 16 outsourcing
companies.
Liaison for auditors and have written formal responses to congressional
inquiries.
Power user of Hyperion Essbase, Excel, and Business Objects.
Direct Staff of 2 professionals. Manage and monitor workflow. Conduct
Performance Reviews.
Self-Employed; Dallas, TX (8/06 to 12/07)
Consultant
Provided accounting, internal audit and treasury services for clients of
various firms.
Designed and Implemented Hyperion Essbase solutions that enhanced client
processes and reporting.
Alamosa PCS (Sprint); Lubbock, TX (6/05 to 5/06)
Manager - Financial Planning & Analysis
Produced Dashboards, Scorecards and other reports for Senior Management and
Board of Directors.
Executed the forecasting and budgeting process of Alamosa Holdings with Total
Revenues over $1 Billion.
Timely completed all monthly reporting, quarterly forecasts, annual budget and
special projects.
In charge of financial modeling using Excel and Essbase. Developed Pricing and
NPV analysis calculations.
Essbase Administrator. Developed and maintained outlines, calc scripts,
partitions, and security access.
Gathered business requirements, designed, tested and implemented business
solutions that improved processes.
Improved completion time of Market Profitability and Board Reports from 2-3
days to 30 minutes.
Provided Merger and Acquisition support. Assisted with SEC Reporting.
Directed staff of 3 professionals. Managed workflow and conducted performance
appraisals.
Power user of Hyperion Essbase, EAS, Application Manager and Excel. Used JD
Edwards, PowerPoint and SQL.
USAA Financial Services; San Antonio, TX (1/00 to 5/05)
Financial Advisor (10/02 to 5/05)
Reported directly to the Corporate Director of Forecasting and Financial
Modeling.
Managed the Financial Reporting Database of USAA Consolidated with Total
Revenues over $10 Billion.
Directed 7 Essbase Administrators to ensure accurate GAAP and Statutory
Reporting.
Essbase Administrator. Developed and maintained outlines, calc scripts,
partitions and SQL data loads.
Gathered business requirements, designed, tested and implemented business
solutions that improved processes.
Led process reengineering initiatives. Improved Debt forecast time from 7
hours to less than 5 minutes.
Assisted with consolidations of Actuals, Budget and Forecast. Completed
reports for Board of Directors.
Provided research and guidance on accounting issues and reporting.
In charge of budgeting and forecasting over $550 Million for various USAA
companies.
Oversaw financial modeling of USAA's Financial Planning Services Company a $25
Million Company.
Essbase consultant in PeopleSoft EPM implementation and other projects.
Power user of Hyperion Essbase, Application Manager, Q2L and Excel. Used VBA
for Essbase and PeopleSoft.
Las Arredondo, CPA
Page 2
Professional Experience (Cont'd):
USAA Investment Management Company
Senior Financial Analyst (8/01 to 10/02)
Reported directly to Senior Financial Officer and Executive Director of
Finance.
Reviewed and managed over $50 Million in Third Party Billings and Intercompany
transactions.
Responsible for accounting and the Financial Reporting of USAA's Financial
Planning Services Company.
Forecasted, analyzed and budgeted over $120 Million for USAA's Investment
Management Company.
Presented monthly Financial and Product Profitability results to Executive
Management.
Managed the Financial Reporting Databases and Activity Based Costing Systems
for 2 USAA companies.
Essbase administrator. Developed and maintained outlines, calc scripts,
partitions, and data replication process.
Gathered business requirements, designed, tested and implemented business
solutions that improved processes.
Led process reengineering initiatives. Improved completion time of Mutual
Funds Profitability Reports from over 40 hours to less than 2 hours.
Worked with PeopleSoft, Hyperion Enterprise, Essbase, Application Manager, Q2L,
OROS, Excel, Access and PowerPoint.
USAA Financial Planning Services
Financial Business Analyst (1/00 to 8/01)
Reported directly to the Senior Financial Officer.
Controller of $25 Million Company. Responsible for Financial and Performance
Reporting, Reviewing Journal Entries, Fixed Asset Accounting, Payroll
Accounting, Tax Reporting, Process Improvements and Call Center Reporting.
Partnered with Executives in producing Strategic and Operational Plans, goals
and new products.
Managed Credit Card and Banking Relationships.
Produced reconciliations, variance and product sales analysis, forecasts and
budgets.
Led company in Essbase implementation and developing a centralized and
standardized reporting process.
Managed the Activity Based Costing System and Reporting.
Worked with PeopleSoft, NVision, Hyperion Enterprise and Essbase, OROS, Excel,
Word and PowerPoint.
AccounTemps; San Antonio, TX (3/99 to 1/00)
Consultant
Provided accounting and auditing services to Manufacturing, Healthcare and
Telecommunications clients.
Fannie Mae; Dallas, TX (8/93 to 2/99)
Senior Financial Analyst
Responsible for variance analysis, forecasting, coordinating $23 Million
regional budget, Fixed Asset and Payroll Accounting, Cash Management, and
Qualifying Mortgage Lenders as Underwriters and Servicers.
Process improvements and ideas reduced expenses over a 3-year period, improved
the monthly close by 3 days, enhanced invoice tracking and conducted audits of
REO and Multi-Family Operations.
Presented financial results to management and led seminars on Lender Financial
Statement Reviews.
Assisted in supervising Accounting staff of 6. Worked with PeopleSoft, Crystal
Reports, Excel and Access.
Education:
Bachelor of Business Administration with major in Accounting.
Texas Tech University; Lubbock, TX
Contact this candidate