Sales Financial

FELIPE SANTILLAN

Glenview, IL *****

Tel: 224-***-**** Email: ********@*******.***

SUMMARY

Results-oriented finance professional with over 9 years of diverse business

experience in the Financial Services, Distribution and Manufacturing

Industries. Degreed Accountant with proven ability to streamline workflows

and business processes. Expertise in calling global operations.

. Financial Reporting & Strategic Planning

. Controllership

. General Accounting & External Audit

. Budgeting and Financial Modeling

. SAP, Oracle, Hyperion, Essbase, AS400

PROFESSIONAL EXPERIENCE

W.W. GRAINGER October 2007 -

present

Sr. Financial Analyst II - International Finance Dept

Lead financial reporting, forecasting and month end close activities

including income statement, balance sheet and cash flow statements

generation for Mexico Border Exports and Puerto Rico entities with

approximately $130M in sales.

. Actively involved in new business opportunities process. Provided make

vs. buy financial analysis, capital investment modeling and other

pertinent financial data for business leadership to reduce preparation

time by 80%. Responsible for ~$7.0M operating budget and ~$1.5 M

capital investment budget.

. Streamlined workflow by developing monthly scorecards that meet

management information needs in a concise manner for sales and

operation results. Reducing month end Operational Result concisely.

. Identified and implemented efficiencies on the streamline of inventory

redeployment, liquidation and donation of product resulting in savings

of ~$150K of Excess and Obsolete Product.

. Redesigned tools for international business units that improved

measure and analysis of financial information (Sales forecasting

platform, integrated budget and product pricing models) that

facilitated sales and operation managers with the analysis and tools

to aid them with strategies and decision making.

. Responsible for external audits and support International Tax.

GE CAPITAL BANK January 2005 - October

2007

Sr. Financial Analyst - Mortgage, Controllership/ Finance Dept

. Controllership analyst supporting integration functions for a recently

acquired business of $1.5B serving as the primary liaison between the

Controller and the different areas including Loan Administration,

Underwriting, FP&A, and New Business Development.

. Led team efforts to define and implement operational policies and

practices for acquired local company (including removing one layer of

management) resulting in improved processes and contained costs of

~$300K.

. Active player for the Implementation of the new SAP system (System

testing, customization, and implementation of new general ledger

system).

. Coordinated monthly closings in terms of capital amortization,

interest earned, insurance and all commission income, volume and

collection accruals, past-due loans portfolio.

. Prepared and reviewed financial information requested by National

Banking and Securities Commission (CNBV) of Mexico, such as financial

statements and integration of capital reserves for portfolio loans

coverage. Improved capital amortization model for prepaid Mortgage

Insurance.

. Reviewed and approved $600M insurance payments calculation and

institutional payments to government agencies (FOVI & INFONAVIT) for

founded credit loans.

. Created NPV, IRR, discount cash flow, and ROI models for evaluating

financial implications of new products and investments, and provided

recommendations to senior management.

. Performed general ledger account reconciliations and coordinated Year

end Audit.

KRAFT FOODS, INC. July 2002 - January 2005

Financial Analyst (Mexico City) - FP&A. (February 2004 - January 2005)

. Participated in monthly/quarterly closings and preparation of

financial statement closing packages.

. Led monthly forecast and variance analyses for expense budget for

Original Budget and revised forecasts to ensure compliance with

budget.

. Prepared Weekly Posting company performance report for Latin America

Headquarters Category Managers.

. Reviewed monthly performance reports with leadership team to identify

risks and opportunities each quarter. Assisted team in executing

strategies to mitigate and capitalize these, respectively.

. Interpreted and prepared customized reports and analyses (Volume

drivers, EVA's, P&L's, income trends, etc.) to financially analyze

budget data utilizing Hyperion, Oracle Financial Analyzer (OFA), and

Essbase retrieve and Add-in for Excel.

. Coordinated Advertising, Consumer and Trade Spending liaison between

Marketing and FP&A Departments.

Finance and Systems Analyst (New York) - FP&A /Systems. (July 2002 -

February 2004)

. Processed quarterly and annual budget submissions from 17 affiliates

throughout Latin America into HQ budget systems. Consolidated

financial data: created restatement categories for various budget

scenarios to facilitate comparability analysis for senior management

(i.e. constant currency / acquisitions / divestitures / adjustments

for one-timers). HQ budget systems included Hyperion Enterprise, OFA

and Essbase Administrator.

. Created customized reports (volume drivers, P&L's, Overheads, income

trends, etc.) to perform financial analysis of budget data utilizing

Hyperion, OFA and Essbase retrieve and Add-in for Excel.

. Assisted in reviewing affiliate budget submissions and presentations

to ensure consistency with predetermined financial targets and Latin

America Region strategies.

DELOITTE & TOUCHE TOHMATSU May 2001 - July 2002

Consultant - Transfer Pricing Dept.

. Formulated comprehensive industry and company analyses to determine

fair market value of transactions of multinational companies in order

to prepare and establish global tax policies within the group.

. Reviewed financial statements, product sales information, inter-

company and third party agreements, contracts and other relevant

information.

. Analyzed and reviewed potential comparable companies using three

principal databases (Compustat, Mergent FIS and Disclosure) which

contained information from more than 12,500 publicly traded U.S.

companies for analyzing the tested party.

. Evaluated and conducted accounting, capital and geographic market

adjustments to financial statements of the tested party and comparable

companies to obtain a profitability inter-quartile range that could be

suitable for Mexican tax authorities.

CREDIT SUISSE FIRST BOSTON April 2000 - January

2001

Intern - Latin America Equity Research Dept.

. Engaged in ongoing equity research and financial analyses of Mexican

construction, real estate and cement industries.

. Used financial modeling to evaluate Mexican companies.

. Wrote overview reports for the covered industries in Mexico.

. Utilized economic and finance databases such as Bloomberg, Reuters,

Infosel-Plus and Economatica (Latin American database for technical

analysis).

PROFESSIONAL EDUCATION

. Inst. Tecnologico Autonomo de Mexico (ITAM) (ranked #1 in Mexico)

November 2001

B.A. in Accounting

. Oracle University & ITAM January 2001

116-hr. Training course, Oracle General Ledger 11i & Receivables 11-i

. Vienna University of Business and Economics June

1999 - January 2000

Finance Specializing Program. Full scholarship granted by the European

Economic Community and ITAM.

TECHNOLOGY

i) SAP Business Warehouse & Strategic Planning, Financial Control

(R/3).

ii) Oracle Financial Analyzer (OFA), General Ledger & Receivable,

Discoverer.

iii) Hyperion Enterprise, Essbase Administrator, IBF WEB, JDEdwards

AS400, Siebel.

iv) Bloomberg, Reuters, Infosel Plus, Economatica, Office

applications.

Contact this candidate