P a g e * *

Jake Hug

ad3fnv@r.postjobfree.com • 630-***-****

Kemp, TX

Accomplished and results-focused professional with extensive experience in data management, analytics, strategic planning, budgeting, business, and objective achievement.

Instrumental in devising and implementing innovative strategies for spearheading the company’s growth in a positive direction by driving the company’s reporting capabilities to surpass management’s expectations and target goals. Proven expertise in data transformation, budget development, cost reduction, and change management. Stellar record of managing successful initiatives associated with finance, while delivering quality leadership as well as conducting strategic business planning. Adept at devising and executing innovative data strategies aimed at increasing visibility, budgeting, and reporting efficiency. Experienced in mentoring and leading teams to go above and beyond in the delivery of exceptional service. Collaborative communicator focused on building relationships and synergy across business lines to drive positive change. Areas of Expertise

Data Management

Change Management

Reporting & Documentation

Custom Solution Delivery

Quality & Best Practices

Process Improvement

Project Management

Training & Development

KPI & Reporting Suite

Operational Transformation

Strategic Planning & Execution

Cost-Savings / Expense Control

Career Experience

Globe Life, McKinney, TX 2020 – Present

Manager of Analytics & Reporting (Financial Planning and Analysis) Focus on data forward solutions and cost management recommendations. Update and streamline financial reporting, guidance, and accounting processes. Drive organizational success by developing and integrating Key Performance Indicators. Develop complete reporting suite of extensive drill-down dashboards to measure, monitor, and raise the monthly performance of the business team backed by robust SQL scripts.

Manage and optimize process for data intake, validation, mapping, and storage of Ledger (Lawson) and Anaplan planning data.

Map entire ledger, including balance sheet, to systematize reporting and planning capabilities.

Document the movement of data across systems and the business logic that occurs at each stage.

Design, develop, and maintain SQL Server database holding and combining financial and operational data.

Obtain and transform sourced data into SQL Server, resulting in an annual savings of 300+ hours.

Coordinate cross-departmental meetings to connect additional data sources to the database, allowing for automation of interdepartmental data transfers.

Construct reliable connected Excel workbooks used by FP&A to facilitate monthly, quarterly, and annual review of expenses.

Consulted with Globe Life's IT teams on mapping, building, and migrating all of data to new data warehouse. PSAV (Encore), Rosemont, IL 2016 – 2020

Senior Manager Financial Planning and Analysis 2019– 2020 Enhanced planning engagement experience for 300 hotels by emphasizing targeted operational reviews and reducing complexity and ambiguity in process. Worked with accounting to standardize and automate the accrual process.

Led in data integration of acquired companies through extensive data cleansing and collaboration between multiple accounting, finance, and I.T. departments.

Oversaw end-to-end data lineage project to audit and track data from legacy CRM through Oracle general ledger system resulting in standardization of sales and financial metrics across the company.

Managed and maintained the creation of monthly financial reporting packages and deck reporting for P&L owners. P a g e 2 2

Automated financial and sales report dashboards, saving the FP&A department over 96 hours a week, including month- end reporting for private equity owners.

Directed design of Tableau financial dashboards.

Mentored direct reporting analyst in writing SQL and model building. Manager Financial Planning and Analysis 2016– 2019 Collaborated with department heads across the company to document the drivers and processes used to develop quarterly projections. Generated models to automate the budgeting process. Designed forecasting system to use multiple inputs driving accuracy.

Developed a dynamic business intelligence tool for users to query data warehouse efficiently.

Created and presented “Best-In-Class” models highlighting $30M in potential savings from salary and wage reductions.

Built statistical models to measure and optimize variables affecting a location’s EBITDA.

Teamed up with IT department – acted as liaison for implementation of Tableau. Sears Holding Corporation, Hoffman Estates, IL 2015 – 2016 Inventory Manager

Oversaw inventory control and resource allocation for the beverage, breakfast, and cleaning product lines delivered to 400 Kmart stores and distribution centers.

Managed projects honing analytical techniques to deploy just in time inventory, preventing expiration of over $6M.

Designed statistical model to improve product placement and inventory levels of items purchased together at specific stores, increasing YoY sales on items 5%.

S.W. Anderson, Downers Grove, IL 2013 – 2015

Inventory Manager

Led the transformation project centralizing the companies purchasing and inventory management practices. Worked with branch offices to ensure seamless day-to-day procurement operations, while leading the inventory side of a new EPR implementation (NetSuite).

Automated procurement process for $32M annual direct spend. Education

Master of Business Administration (MBA): Concentration in Management Information Systems Elmhurst College, Elmhurst, IL

Bachelor of Science in International Business

Elmhurst College, Elmhurst, IL

Technical Proficiencies

SQL • Anaplan • Informatica • MS Excel (VBA, Solver, Power Pivot) • Tableau Suite • Power BI • Batch Script • Oracle • Visio

• Net Suite • SAP

Contact this candidate