Post Job Free

Resume

Sign in

Sales Management

Location:
Corte Madera, CA, 94901
Salary:
110000
Posted:
July 27, 2013

Contact this candidate

Resume:

** ***** ******, *** ******, CA *****

Guillermo Montes 202-***-**** ab2s56@r.postjobfree.com

* * * * *

Guillermo Montes: http://www.linkedin.com/in/montesguillermo

PROFESSIONAL EXPERIENCE

Financial Consultant – Contractor San Francisco Bay Area December 2009 – July 2013

Kaiser Permanente, Stanford Hospital & Clinics, Pacific Gas & Electric (PG&E), Architect of the Capitol

(AOC)

Financial, accounting and technical consulting services at two major healthcare organizations, a public utility

and a governmental agency. Specialized in revenue cycle and financial management, accounts receivables

analysis, contractual allowance calculation and reserve requirements.

Responsible for dashboard development and identifying Key Performance Indicators (KPI’s) in order to

drive results and improve revenue cycle processes.

Developed staffing analysis for production departments to track and manage unfavorable variances due to

rate, volume and efficiency.

Responsible for FP&A activities, budgets, forecast and monthly expense analysis.

Responsible for mapping and reconciling outpatient revenues ($900 million dollars annually) from medical

billing system (EPIC) into the company’s general ledger (Lawson).

Ownership and responsible for the analysis of the physician base accounts receivable ($100 million

balance), contractual allowance calculation ($30 million monthly), bad debt expense and reserve

requirements.

Prepared by client (PBC) annual audit requirements for balance sheet and income statement accounts.

Full cycle accounting, bookkeeping functions and month-end close responsibilities for 14 out-patient clinics.

Preparation of the corporate tax return for 501(c)3 tax exempt organization.

Technical lead for data validation and reconciliation of Architect of the Capitol’s vendor database with the

U.S. government’s Central Contractor Repository (CCR) database.

Hands on role utilizing Microsoft Access and SQL to extract and validate data for identification of

anomalies and discrepancies in the record sets.

Established business rules and recommendations to ensure data integrity as well as consistency for data

storage and retrieval.

EFE News Service Washington, DC June 2008 – October 2009

Leading Spanish language news agency and the fourth largest news agency in the world. EFE has a presence in

over 181 cities and 120 countries.

Regional Controller

Hired by CFO to streamline operations in North America and Central America to drive financial performance

and to strengthen internal control. Oversight of financial analysis, financial audits, G/L chart of accounts, A/R,

A/P, fixed assets, payroll and month end close processes. Managed a team of 10 accounting professionals.

Restructured the region from a decentralized to a centralized unit, eliminated redundancies and reducing

operating expenses.

Spearheaded process improvement and redesign by training the staff on accounting fundamentals in

accordance with GAAP.

Simplified FP&A processes and created financial dashboards and a management reporting package for

consolidated results to include statements of financial position, earnings, and cash flows.

2 P a g e

Guillermo Montes: http://www.linkedin.com/in/montesguillermo

In-depth analysis of the A/R balances led to a re-assessment of the credit granting policies previously

authorized by the sales team. This resulted in a 100% increase in the accounts receivable turnover ratio.

Strengthened internal control by instituting a lock-box system and bonding employees with cash handling

responsibilities. Ensured adequate segregation of duties throughout the region (authorization, recordkeeping

and custody of assets).

Responsible for the payroll in North America, Central America and the Caribbean, utilized ADP Pay eXpert.

Partnered with sales team and identify the right product mix and pricing strategies for each market segment

in order to maximize sales and profits.

Ensured reporting compliance with International Financial Reporting Standards (IFRS).

Managed and documented accounting and operations procedure manual with emphasis on process

improvement.

United Way of America Alexandria, VA May 2007 – May 2008

Non-profit leadership and support organization for the network of nearly 1,800 community-based United Ways

in 45 countries and territories.

Finance Manager

Hired by the Chief of Staff to assist in the creation of a global entity, (United Way Worldwide). Responsible for

all aspects of the budgeting and financial planning ($38 Million) of United Way Worldwide.

Responsible for the development and preparation of the business plans, financial budgets and FP&A

activities.

Worked with operational and functional groups in formulating forecasts, zero-based budgets, financial

reports and overall strategic plans.

Preparation of the United Way of America corporate tax return, a 501(c)3 tax exempt organization.

Utilized Open Database Connectivity (ODBC) for accessing information from the legacy system (Great

Plains) to extract/compile financial data in order to facilitate and automate financial analysis and report

creation in Crystal Reports (SAP).

Produced weekly/monthly/quarterly revenue and expense and ad hoc reports and dashboards for senior

management.

Norwegian Cruise Line Miami, FL May 2006 – May 2007

Founded in 1966 and headquartered in Miami, Florida Norwegian Cruise Line has a fleet of eleven ships.

Financial Systems Analyst

Maintained the financial and property management systems on each of Norwegian Cruise Line’s (NCL) vessels.

Instituted accounting best practices and voyage closing procedures.

Created, modified and maintained financial and management reports for onboard accountants and personnel,

utilized Crystal Reports, Microsoft Access and Excel.

Served as a project lead in a financial system implementation onboard a newly commissioned NCL vessel;

managing projects including business requirements gathering and solution design and support.

Mercy Hospital Miami, FL April 2005 - April 2006

A 473-bed acute care facility affiliated with over 700 physicians representing 27 medical specialties. As Miami-

Dade county’s only Catholic hospital, Mercy is part of Catholic Health East.

Senior Financial Analyst (Contract)

3 P a g e

Guillermo Montes: http://www.linkedin.com/in/montesguillermo

Responsible for the hospital’s accounts receivables and contractual allowance model, ensuring valuation and

accuracy in the presentation of the accounts receivable balance and balance sheet reporting.

Managed the account receivables ($100 million), calculating the contractual allowance, and bad debt

expense to ensure accuracy and valuation of the hospital’s accounts receivables and reserves.

Performed monthly financial analysis of revenues, charges, payments, adjustments and write-offs.

Validated all transactions from point of origin in the medical billing system (Medipac) to their respective

subsidiary accounts in the general ledger system (Lawson).

Developed custom reports using Open Database Connectivity (ODBC) with various applications including

Crystal Reports, Microsoft Access, ACL and Excel.

Royal Caribbean International Miami, FL March 2003 - April 2005

Royal Caribbean Cruises Ltd. Is the world’s second largest cruise company. The company is publicly traded on

the New York Stock Exchange (NYSE:RCL) and on the Oslo Stock Exchange (OSSE:RCL).

Operations Specialist/Staff Accountant II

Promoted to Operations Specialist from Staff Accountant II. Responsible for project management, operational

planning and logistics, as well as embark and debark procedures at various cruising ports. As a Staff

Accountant II, responsible for account reconciliation and variance analysis.

Maintained financial budgets and operational plans for the ports of Vancouver, B.C., Seward, Alaska, New

Orleans, Louisiana, and San Juan, Puerto Rico.

Responsible for the reconciliation of the company’s bank accounts, balance sheet accounts and inter-

company accounts.

Variance analysis of SG&A expenses.

Month-end closing responsibilities.

EDUCATION

Bachelor of Arts Double Major Accounting and Certified Public Accountant (Expected – Q4 2013)

Finance California State Board of Accountancy

Florida International University Graduated March

2003

United States Marine Corps (1990-1994)

E-4 Corporal

TECHNICAL SKILLS

Microsoft Access, Excel, Power Point, Visio, Word Lawson

Crystal Reports (SAP) Microsoft Dynamics, Solomon/Great Plains

ACL Audit Exchange Oracle JD Edwards

ADP Pay eXpert Intuit Quickbooks

EPIC/Medipac

4 P a g e

Guillermo Montes: http://www.linkedin.com/in/montesguillermo



Contact this candidate