Luis Hidalgo Email & Phone Number

Orlando, Fl, Us

Orlando, Florida, United States

Orlando, Florida, United States

● Provide senior leadership with monthly reporting on $1.3B mortgage portfolio across a variety of metrics that are essential for judging the health of the business● Direct loans to various lenders and securitizations for cash flow while maximizing return and minimizing risk● Oversee duties of a team of five that provide routine and ad hoc reporting for business partners across the organization while promoting collaboration to increase the teams growth in a scalable fashion● Continually improve processes through the use of automation and tools that reduce error and provide consistent results through heavy use of SQL and Tableau

Orlando, Florida

● Monthly reporting of Developer Obligation budget of $250M ● Identified areas of opportunity to mitigate expenses through optimized use of developer inventory for reduced expense of $25M annually beyond current $115M efforts● Developed KPIs to measure operational efficiency and highlight areas that could be improved using new data sources● Created and suggested forecast adjustments to senior leadership to better reflect the business and critical to meeting quarterly financial goals and investor expectations

Lake Mary, Fl

● Analysis of payment channel costs leading to development of team focused on reduction of costs through shifting of consumers to lower cost payment options in addition to soft savings in reduced credit card chargeback fees and printed paper bill reduction● Saved 5-10 days per month by automating recurring duties, freeing up that time for increased analytics. ● Provide deep dive analysis for various operational functions such as bad debt, workforce planning, cost of operations, and improved customer experience using data mining techniques in EDW and data visualization models● Coach teammates and assist management with complex analyses, including automation of models, improved operational context, and new scalable modeling focused on decision making e.g. Bill Printing, Headcount

United States

● Created workflow templates to improve processes across departments● Created comprehensive Board of Directors presentations, including budgeting and forecasting across various subsidiaries and consolidation of financials ● Created of all new KPIs with a focus on margin driving factors, e.g. sales expenses vs. revenue growth● Managed team meetings to track and review, all PRBs (Permanent Room Blocks) which accounted for a disproportionately large portion of income to revenue

Orlando, Florida Area

● Go-to individual for data mining from ICOMS billing system and Hyperion financials via Essbase and SQL querying.● Budgeting, forecasting, planning, and variance analysis of revenues, expenses, capital, and customer growth for multiple divisions nationally. Additional work on P&L, KPI, IRR, and ad hoc reporting.● Designed retention and promotions models to increase projected revenue per customer by approximately 20% across 60-80% of customers and decrease turnover.● Redesigned cable box and construction tracking and modeling to improve turnaround time weekly from 12+ hours to 30 minutes while reducing potential for human error significantly; net savings $12k/year● Designed GUI friendly Access databases to digitize formerly paper process of capital spending approval and approvals for special customer pricing which each saved 5-10 hours of labor weekly and freed up two employees; net savings $20k+/year

Sanford, Fl

● Designed various models and processes to automate the entering of journal entries and reduce human error for payroll, supply inventory, and other miscellaneous assets saving up to 5 hours/week● Aided Sr. Accountant with various ad hoc work such as: payroll, tax preparation, cash flow reports, and P&L● Reconciled all balance sheet accounts monthly and performed month-end close in accordance with GAAP● Acted as liaison through three independent audits, gathering data and generating new reports while continually meeting accounting deadlines

Bachelor Of Science, Finance & Management, 3.0

Relevant Courses: Corporate Accounting; Financial Accounting; Corporate Finance; Business & Trend Analysis, Risk Analysis; Business Strategy

Bachelor'S Degree, Finance And Management