Daniel Rodriguez
Finance Manager, FP&A
Page * of 2
Miami, FL 33130
**************@*****.***
PROFESSIONAL EXPERIENCE
Boxy Charm Inc, Miami, FL Jan 2018 Current
Finance Manager, FP&A
Lead financial modeling of $280M in Revenue, Operating Expense, and Cash Flow forecast in accordance with future growth/projections and historical trends based on Business Financial Model
Establish Budget, Monthly Financial Package, sets KPI to identify trends to generate revenue reduce cost
Development of what if scenarios on strategic long term decision making and new initiatives such as new product lines, new product mix, proposed sale discounts, and their impact on the margin
Implementation of accounting ERP system (Great Plains), SAP Concur corporate credit cards & travel
Oversee State Sales Tax registration, computation, filing, and nexus audits in 41 states. Provide supporting schedules to RSM Tax division for Income Tax filing
Oversee 3 year Financial Audit, prepare revenue & expense schedules/roll forwards, and recommend system input changes to current process to automate month end process and financials reporting
Maintain banking relationships with Capital One, Chase, and Amex on all corporate credit card rebate program GroupM, Miami, FL July 2017 – Jan 2018
Finance Manager, FP&A Reporting & Consolidation
Consolidation of Financial Reporting of advertising agencies MindShare, Mediacom, Maxus, MEC, Xaxis, and GroupM with operations in 8 different Latin American Markets totaling $800M annual revenue
Maintain and support updated financial models, schedules, and templates for forecasting/actual reporting through BFC/Tableau/Metapraxis/BW for a total of 100 reporting units
Develop Business Intelligence initiatives to increase financial visibility Latam CEO & CFO
Oversee P&L, Balance Sheet, and Cash Flow reporting for month end, quarter end, budget, and 5 year plan
SOX compliance on reporting Databases
NBC Universal International Networks, Coral Gables, FL Dec 2015 – July 2017 Financial Planning Analyst
Develop and maintain revenue/expense forecasting models for television networks such as Universal Channel, Studio Universal, Syfy, E! Entertainment, and Telemundo International for Latin America
Support, analyze, and assist in the preparation of financial results against plan/forecasts in local currency and reporting currency (USD). KPI’s.
Financial and operational process standardization from a three channel operation to a five channel JV
Preparation of monthly forecast, 5 year plans, and ad hoc business cases reported to London HQ.
Develop BPC load template for revenue, expense forecasting, and special projects/new initiatives
SAP super user in creation of WBS codes to track marketing projects United States Sugar Corporation, Clewiston, FL May 2015 Dec 2015 Financial Analyst
Coordinate, develop, and assist operation management in preparation of annual operating, capital budgets, and quarterly forecasts for 200,000 acres of sugarcane/corn operation.
Tracks actuals against forecast/budget and pursues bases for explanations on variance to CFO
Prepare various SAP and SQL reports and financial analysis related to unit cost and cost center performance
Advise and assist operations management on determination of expense vs. capital expenditure Daniel Rodriguez
Finance Manager, FP&A
Page 2 of 2
145 SW 13th Street
Miami, FL 33130
**************@*****.***
Florida Crystals Corporation, Palm Beach, FL Jan 2010 – May 2015 Business Analyst – Agriculture (2014 – 2015)
$21 million dollar annual purchase order management, budget control, and cost analysis of Agricultural supplies and services
SAP analytic support and database administrator of 180,000 acres of sugar cane and rice farm operation
Data analysis of good/services and mill production costs to evaluate and optimize current trends
Develops and maintains relationship between vendors, operations, and procurement Operations Analyst (2010 – 2014)
SAP material supply planning and logistics following accounting practices, consolidated consumption and inventory stocks to assess expenditure and cost allocations
Performed actual ordering of agricultural supplies and compares invoice consolidation
Prepared and maintained document files in compliance with Environmental Protection Agency (EPA), South Florida Water Management District (SFWMD), and U.S. Department of Agriculture (USDA) EDUCATION
Harvard Business School Online
Certificate in Business Analytics, March 2019 – May 2019 Bachelor of Business Administration, Florida Atlantic University, Boca Raton, FL
Majors: International Business and Trade; Management Information Systems
Minor: Business Intelligence
TECHNOLOGY EXPERIENCE
BEx, BFC, BPC, BW, Excel, Finance, Microsoft Office, MS Access Database Mining, Project Management, SAP, SAP MM, Quickbooks, SQL, Tableau, Visio, Looker, Concur Administrator, and Microsoft Dynamics GP. LANGUAGE SKILLS
Bilingual – Fluent English & Spanish read and write