Hector R. Pena, M.A. Email and Phone Number

 Designed, developed, and implemented robust People Analytics and Data Visualizations to drive critical business decisions and operational excellence.  Supported and lead automation process improvement initiatives that leverage data and technology to increase efficiency in Talent Management, DE&I, Succession Planning and HR data.  Performed industry benchmarking and market trends analysis to help inform HR strategies. Developed and prepare standard and ad hoc reports for varied and specific audiences to support enterprise initiatives, process reviews, governance and other needs as identified Conducted data manipulation (ETL) and moderately complex analyses using advanced skills and functionality of tools applying relatively complicated calculations and formulas, semi-automating activities wherever possible to ensure accuracy and efficiency, making recommendations as appropriate Developed a system within Microsoft Suite that initiated with customer interface to high level output dashboards -Created forms/surveys using FORMS which used Sharepoint as data repository for Power BI dashboards

 Ensured that O&M, Clearing, and Capital budgets were maintained within appropriate funding.  Created monthly reports for management dealing with employee overtime, clearing, a summary of hours, and org—headcount for the SVP. Created and reported to leadership on financial performance, historical comparison, expense reports, and annual expenditure projections Created visual dashboards that drilled down into the costs of key drivers. Monitored actual financial performance and attainment of KPIs against monthly targets.  Created a 5-year budget plan for multiple organizations. Developed, managed, and presented key performance metrics (KPIs) and analysis to help improve company targets, including Dashboards for Headcount, T&A, and Overtime.

• Improve financial status by analyzing results, monitoring variances, identifying trends, and recommending actions to management for all clients.• Mitigate unnecessary costs by developing debt reduction plan using DTF5 (Offering in Compromise) or consolidating accounts.• Create and maintain monthly P&L, balance sheet and cash flow forecasting reports for each client.• Analyze financial information obtained from clients’ accounts to develop strategies and meet objectives.• Recommend actions by analyzing and interpreting data and making comparative analyses.

• Analyzed sales, pricing trends, and financial performance for all panels (digital & bulletins) throughout the US to more effectively respond to market trends and opportunities. • Enhanced the quality of pricing decisions and actions by providing information and insights into sales, customers, markets and performance trends.• Optimized panel inventory through both pricing and occupancy management by creating a financial model that tracked multiple KPIs. • Participated in creating/implementing a budget template for 56 markets in the US. Worked with GMs to meet budget objectives in the $1B mark. • Designed an algorithm to generate price discounting on panels based on terms, contract to post, quantity, quality, price sensitivity and occupancy.• Leveraged programming skills using VBA code to automate processes and maximize accuracy. This improved accuracy and efficiency.• Participated in creating a dashboard on Oracle cloud that drilled down to all advertisers on a month over month basis. • Created a dashboard for president of digitals to monitor the performance and trends of all digital billboards in the US.

- Created weekly revenue reports for CEO, President of Sales, CFO, and other management, used in making financial decisions for $200M. Prepared financial reports on given schedules (monthly, quarterly, or more frequently), which included outdoor metrics (occupancy), pipeline, and revenue to Outdoor Advertising Association of America.- Constructed financial dashboards for sales, budget, and cash flow analysis using advanced Excel skills. Designed dashboards that monitored sales performance for sales representative, agencies, and advertisers, helping higher management implement necessary actions that increased revenue and minimized costs.- Increased profitability by creating queries that show revenue versus budget and occupancy rate of each panel.- Served as liaison between sales and accounting department, successfully managing financial reporting for sales.- Assisted sales representatives with measuring and managing objectives by joining annual budgeting processes.- Developed / improved sales representative commission processes by creating commission-generating template.- Created financial models used in forecasting individualized panel performance.

- Prepared detailed budget and forecast reports, making necessary modifications and thereby increasing profits.- Increased retail sales 57% over a year span by implementing business practices that entailed analysis of ROI, focus on new customer acquisition, market penetration, and financial and operational re-engineering.- Ensured all products and services were thoroughly presented via professionally executed sales cycle by consistently analyzing business opportunities within region.- Negotiated contract terms with manufacturers where marginal cost was decreased due to cost cutting and profit increasing efforts.

- Handled day-to-day financial planning and management of $3M+ business with flag store location in NYC and product line distribution in US.- Consolidated and developed monthly, quarterly, and yearly operational plans, measuring productivity and applying modifications as needed. Prepared and analyzed month-end P&L statements and balance sheet.- Implemented administrative software (ERP), making business operations more efficient. Managed database, schedules, purchase orders, A/P, A/R, inventory controls, and payroll, as well as tracking marketing information.- Increased overall revenue 192% by effectively marketing and branding company products and services, including creating and maintaining-commerce website.- Increased profits by analyzing, collecting, and summarizing data and trends.- Decreased costs and improved profitability related to cost reduction by aggressively negotiating contracts for purchases of equipment, publications, and products, thereby contributing to additional large-scale cost savings throughout tenure.- Increased visibility and financial control by handling all cash management and reconciliation of bank accounts.- Assisted employees with tracking improvements towards attaining company performance goals by creating weekly, monthly, and yearly sales forecasts for products and services.- Recruited, trained, and produced performance matrices for more than 55 employees / managers, creating an environment that fostered low turnover. Authored and implemented company’s business rules and regulations manual, and created a detailed sales plan, promoting development, improving morale, and increasing profits.- Managed accounts payable / receivable and all sales activities from major department stores, including Bloomingdales, Saks Fifth Avenue, JCPenney, Loehmann’s, and Nordstrom.- Ensured 100% compliance with NYS Department of Health Codes and Regulations, renewing business license when needed.