Financial Planning Data Analytics
Resume:
Francisco Hans Alarco Page *
FRANCISCO HANS ALARCO
Miami, FL
**********.******@*****.***
Professional in the fields of Accounting, Finance, FP&A, and Data Analytics. Specialized in distressed companies, re-structuring, and operational performance turn around. Experienced in industries such as Retail, Financial Services, Direct Labor Services, & Investments. Areas of Expertise
Financial Planning & Analysis Financial Statements Evaluation Financial Modeling & Reporting Contract Model Valuation Budgeting & Forecast Private Equity Variance Analysis Operation Performance EXPERIENCE
The Genisus Group LLC, Miami, FL
Consultant - Financial Planning & Analysis 07/2023 – Present Clients Served in Miami, FL: CVS, Eulen Aviation & USSI Services
Overseeing operations performance and improving financial reporting at all levels from the front-line employees all the way to corporate.
Crafting comprehensive financial plans, operational budgets, forecasting revenues, expenses, and cash flows management while setting goals and performance metrics.
Reporting directly to CEO, CFO, board of directors, banks, and private equity investors.
Bridging gaps between finance and operations, by improving communication, and understanding of operations.
Developing financial models to evaluate diverse business scenarios, support strategic decisions, and present forecasts and relevant metrics to executives weekly.
Managing the budget process within all areas of the business, with an emphasis in sales and operations.
Creating KPIs, dashboards, using Power BI to evaluate & measure performance, and target areas of opportunities.
Utilizing and developing data analytics in order to have the most updated and real time information available
Aid in understanding and addressing variances between actual and projected figures, providing actionable recommendations. Support short/long-term forecasting, including cash flow management & working capital optimization. Assist in selecting and implementing financial software and tools.
Managing and maintenance of all contracts, including negotiation, bidding, pricing, valuation, and measurements. This includes licensing, royalties and service contracts.
Overseeing and ensuring proper procedures for billing and accounts payable.
Maintaining constant communication with operations in order to monitor the business closely and ensuring proper and sound reporting.
Keeping a close eye to the validation of all sources of financial data relevant to sales and direct costs, while reviewing the manner in which they are recorded and reconciled.
Identify cost reduction opportunities and enhance profitability through activity-based costing and analysis.
Create and enhance financial reports ensuring compliance with accounting standards.
Offer expertise in valuation techniques for mergers, acquisitions, partnerships, or exit planning.
Assess financial and operational risks and develop strategies to mitigate and reduce exposure. Payless ShoeSource Worldwide, Miami, FL
Director of FP&A 06/2021 – 07/2023
Supported the CFO, CEO, and all the department heads providing guidance in finance such as reporting, budgeting, forecast, processes and internal controls.
Provided analysis of the P&L, Balance Sheet, and Cash Flow to management and executives.
Collaborated closely with the sales team, offering support in the reporting of the sales figures, including budgets, forecasts, and actual sales at both the regional and country levels. Additionally, I provide the sales Francisco Hans Alarco Page 2
team with templates and guidance to assist with their monthly updates.
Conducted weekly meetings with executives to present forecasts, sales, inventory, units sold, week of inventory coverage, foot traffic, sales conversion, and other relevant metrics to executives.
Conducted project management for inventory, fixed assets, and other various companywide projects.
Developed & implemented a sales financial model (using power pivots and data queries) that captured both manually reported sales from the field and system-derived sales providing comparisons with forecasts and prior periods.
Built financial models for royalty contracts with vendors that calculated their monetary value based on the clauses, stipulations and agreed amounts, as well other models for executive reporting.
Collaborated directly with the head of IT Department and data engineers to build SQL queries from schemas, that extract data from the Snowflake data warehouse online portal, or SAP HANA. This processed allowed key information to flow from the main data bases, to Tableau, which enabled me to access large amounts of financial metadata (millions of rows by hundreds of columns), to build up and summarized them in Excel or PowerPoint presentations.
Participated and collaborated in the data migration from PeopleSoft to SAP HANA, along with IT Mapping of financial information.
Collaborated with the head of Product Development to manage the relationship with vendors and factories. Also, calculated the weekly Factory Payments and aging reports for management review and payment approval.
Business planning and analysis, providing expense planning and forecasting, as well as financial analysis on a project basis to support the companies’ long-term strategy and growth opportunities.
Coordinates the creation of financial plans, capital plans, financial and cash flow projections, and Long-Range Plans for Latin America & Caribbean.
Drive expense control, identify EBITDA savings opportunities, and drive EBITDA projects through to completion.
Assists the accounting department with bi-weekly payroll entries, month end payroll accruals, payroll benefit AP invoice coding, and payroll analysis on expense fluctuations.
Manages the weekly Cash Flow Liquidity Report for Board of Directors and Private Equity Investors.
Support major strategic projects with analysis, expense and benefit forecasting.
Communicate financial outcomes of operational plans to finance partners with an understanding of impact on company metrics.
Responsible for analysis and interpretation of the financial information in order to appraise operating results in terms of profitability, performance against plan, and other matters bearing on the fiscal soundness and operating effectiveness of the Company.
Support the Franchise Department with analysis for revenue, billing, AR, and AP to factories in Asia.
Creating financial models to support the business, such as store valuation models for opening up new locations.
Provided support to the Accounting Department by managing the payroll reporting and Journal Entries biweekly. VISA, Miami, FL 12/2018 – 04/2021
Senior Financial Analyst
Analyzed incentive contract terms to assess Visa's contractual obligations and determine appropriate accounting treatment.
Reviewed proforma and Accounting Treatment form to ensure accuracy of contract interpretation and application of Visa's accounting policy respectively.
Prepared monthly estimated amortization and payment schedules per contract terms and Visa's Accounting Policy.
Created excel models to determine contractual commitments per the terms of the contract, ensuring that all key obligations have been accurately addressed.
Reviewed and evaluated on-going contract performance and updated future performance /amortization schedules, as needed.
Reviewed contractual payments per terms of acceptance contracts. Liaison with stakeholders to determine the fulfillment of contractual obligations. Assist in the resolution of related issues and discrepancies.
Analyzed and explained the variances between forecasted and actual contractual commitments, and prepared the necessary adjustments.
Provided timely reporting to External Reporting and Accounting Operations departments, and assisted with Client Incentive projects.
Gathered and reported performance metrics for assigned contracts, as well as monthly manual accruals and commitment reports.
Provided timely reporting to External Reporting and Accounting Operations.
Managed CI projects to support Client Incentive Operations. Francisco Hans Alarco Page 3
DIMENSION CAPITAL MANAGEMENT, Miami, FL 02/2017 – 03/2018 Senior Fund Analyst
Assigned to manage 20 private equity funds of Funds, 6 onshore hedge funds, including 40 individual clients.
Prepared monthly financial statement packages for assigned funds, and reconciled client accounts.
Charged with preparing capital calls, distributions, subscriptions, and redemption for assigned funds and clients.
Oversaw monthly pricing of investments for onshore hedge funds, client holdings, and mark-to-market valuations for private equity funds.
Provided estimated and final valuations for hedge funds, along with cash flow, portfolio allocation, and performance reports.
Established management fee calculation for assigned funds, assisted in the audit process, and created wires for payments.
IB CPA, PUBLIC ACCOUNTING FIRM, Miami, FL 01/2016 – 01/2017 Accounting Manager
Cultivated relationships with assigned clients, including financial statements, bookkeeping, payroll, tax returns, and reports.
Performed monthly bookkeeping, bank account reconciliation, credit cards, and inter-company activity, using QuickBooks desktop and online.
Coordinated periodic payroll cycle runs, submitting salaries and payroll taxes to agencies, and preparing annual payroll tax returns.
Handled the Accounts Payable, bills, vendors payments, and employee expense reports, and prepared 1099s for contractors.
Produced necessary federal and state tax returns for businesses and individuals, and administered the filing registrations with the government.
Created the monthly, quarterly, and yearly financial statements, including balance sheet, P&L, journal entries, and GL maintenance.
CITIGROUP PRIVATE EQUITY ACCOUNTING SERVICES, New York, NY 01/2012 – 12/2015 Fund Analyst
Assigned to the Blackrock Diversified Private Equity Engagement (Client) -- 14 Funds, 67 underlying funds, and 27 direct investments.
Calculated the daily P&L and estimated NAVs for assigned funds, while maintaining investor allocations, including capital activity.
Prepared quarterly work papers, financial statements, and valuation adjustments, and reviewed investment and capital activity.
Analyzed daily bank reconciliation, created journal entries, and updated limited partner’s supporting schedules.
Developed cash reports and statement of investments reports, and created transmittals for investor’s capital calls and distributions.
Assisted in the calculation of quarterly management fee, and carried interest “waterfall” calculations, IRR, and footnotes.
Reconciled the partner capital statements, reviewed investment portfolio accounts, and calculated investment allocation breakdowns.
Maintained partner and class allocations, performing daily cash reconciliations for assigned funds. ADDITIONAL EXPERIENCE:
BERGEN LOGISTIC, North Bergen, NJ - Senior Accountant 05/2009 – 01/2012 MILITARY EXPERIENCE: UNITED STATES ARMY NATIONAL GUARD, 42ND Infantry Division EDUCATION: Bachelor of Science (BS) in Finance & Accounting - MONTCLAIR STATE UNIVERSITY, NJ CERTIFICATIONS / Licenses: Qualified CPA Candidate Registered with the State Board
Contact this candidate