Horacio Cook Email & Phone Number

Purchase, Ny, Us

White Plains, New York, Us

Miramar, Fl, Us

 Prepared and consolidated Budget and Forecast, performing variance analysis versus Actual data. Improved P&L model with breakdown by division and detailed expenses report by Cost Center. Generated automatic monthly Forecast scenario by sales division and cost center.  Supported Global Finance team by extracting, processing, and reporting data using T-SQL and PL/SQL. Acted as a liaison between Finance department and other Business Units and divisions throughout Global Organization.  Administered reporting tools, designing and developing reports using Prophix and SQL Reporting Services (SRSS). Saved 2 days of manual work creating on line reports for a P&L by division.

 Served as consultant leading BI projects using Oracle Hyperion (HFM) and ETL tools (FDMEE). Completed projects on time and on budget.

México, Mx

 Analyzed business requirements; designed and developed analytical models for Commercial and Profitability divisions using Hyperion Essbase, Teradata, and Smart View. Completed project on time and on budget.

 Hyperion Planning. Led project and managed a team of five analysts and developers. Oversaw business requirement gathering, documentation, construction, testing, quality assurance (QA), and project closing.

Mx

 Supported and led analytical projects based on Oracle Hyperion technology (Hyperion Financial Management, Hyperion Planning, Oracle Data Integrator, Hyperion Financial Reporting and Hyperion Financial Data Quality Management and Hyperion Profitability Cost Management). Performed analysis of business requirements; developed and planned BI solutions using OBIEE and Hyperion Financial Reporting.  Implemented HFM to consolidate all 26 companies of Aeromexico Group and Hyperion Profitability models with breakdown by route and flight. Reduced 2 days the time to consolidate and control financial consolidated statements.

México, Distrito Federal, Mx

Leadership of EPM and data integration projects based in Mexico DF, for clients from Mexico, Colombia and Panamá, using Hyperion Financial Management, Hyperion Planning, Oracle Data Integrator, Hyperion Financial Reporting and Hyperion Financial Data Quality Management.Clients: Nintendo (Panamá), Sodimac (Colombia), Grupo Industrial Saltillo, Metalsa.

Las Condes, Santiago Metropolitan Region, Cl

Responsible for generation and analysis of business and financial information for all companies in the holding. Leadership of Business Intelligence projects for all business units (department stores, bank, financial services and supermarket), in Argentina, Chile, Colombia and Perú.

Analysis and control of P&L, balance sheet accounts and variances between actual, budget and forecast.

Greater Chicago Area, Il, Us

Analysis and control of P&L, balance sheet accounts and variances between actual, budget and forecast, for Southern Cone business units (Argentina, Uruguay, Paraguay and Chile)

Greater Chicago Area, Il, Us

Management of incentive programs oriented to sales force and resellers. Design of KPI’s and reports for measuring performance.

Greater Chicago Area, Il, Us

Analysis and control of P&L, balance sheet accounts and variances between actual, budget and forecast, for Southern Cone business units (Argentina, Uruguay, Paraguay and Chile).

Amsterdam Zuidoost, Nl

Control of consistency of information in transactional and reporting systems.

Ciudad Autónoma De Buenos Aires, Buenos Aires, Ar

Administrative support to securitization and loans trust Project.

Data Mining & Knowledge Discovery

Bachelor Of Science (Bs), Information Systems

Bachelor Of Science (Bs), Business Administration

High School