Jason Mackey Email & Phone Number

Land O' Lakes, Fl, Us

United States

• Prepares and oversees a 160 Million dollar Function Budget.• Reviews all global expenses posted to the functional budget on a monthly basis to ensure expenses are in line with budget. • Utilizes experience in Excel VBA coding to create macro tools to streamline manual processes.

United States

• Prepares and oversees a 150 Million dollar Global Benefits and Compensation Budget.• Utilizes experience in Excel VBA coding to create macro tools to streamline manual processes.• Reviews all global expenses posted to the Global Benefits & Compensation budget on a monthly basis to ensure expenses are in line with budget. • Supervises the Manila HRIS staff and ensures all journal entries and expected expenses/credits are accounted for in GL accounts as well as Xcelerate budget system.• Utilize PeopleSoft Query Manager, ADP Reporting, Benefits Analytics Manager, Empyrean report writer and numerous other systems to capture data for Budget, renewals, RFP’s, auditing and ad hoc reporting purposes.• Acts as the department liaison with both outsourced vendors and internal departments such as HRIS, HRSS, Finance, Payroll and GTS.• Project manages all projects that pertain to Global Benefits department.• Provides various benefits ad hoc reports to outside benefits consultancies for use in analyzing retiree health liabilities and year-over-year utilization and cost trends for analysis into recommended plan design changes for actives and retirees put forth by benefits consultancies.• Conduct analyses using Optum Health’s, Benefit Analytics Manager Application (outsourced medical data warehousing solution).

United States

• Prepares and oversees a 78 Million dollar Global Benefits and Compensation Budget.• Utilizes experience in Excel VBA coding to create macro tools to streamline manual processes.• Reviews all global expenses posted to the Global Benefits & Compensation budget on a monthly basis to ensure expenses are in line with budget. • Supervises the Manila HRIS staff and ensures all journal entries and expected expenses/credits are accounted for in GL accounts as well as Xcelerate budget system.• Utilize PeopleSoft Query Manager, ADP Reporting, Benefits Analytics Manager, Empyrean report writer and numerous other systems to capture data for Budget, renewals, RFP’s, auditing and ad hoc reporting purposes.• Acts as the department liaison with both outsourced vendors and internal departments such as HRIS, HRSS, Finance, Payroll and GTS.• Project manages all projects that pertain to Global Benefits department.• Provides various benefits ad hoc reports to outside benefits consultancies for use in analyzing retiree health liabilities and year-over-year utilization and cost trends for analysis into recommended plan design changes for actives and retirees put forth by benefits consultancies.• Conduct analyses using Optum Health’s, Benefit Analytics Manager Application (outsourced medical data warehousing solution).

Tampa, Florida

• Prepares and oversees a 62 Million dollar Global Benefits and Compensation Budget.• Utilizes experience in Excel VBA coding to create macro tools to streamline manual processes.• Reviews all global expenses posted to the Global Benefits & Compensation budget on a monthly basis to ensure expenses are in line with budget. • Supervises the Manila HRIS staff and ensures all journal entries and expected expenses/credits are accounted for in GL accounts as well as Xcelerate budget system.• Utilize PeopleSoft Query Manager, ADP Reporting, Benefits Analytics Manager, Empyrean report writer and numerous other systems to capture data for Budget, renewals, RFP’s, auditing and ad hoc reporting purposes.• Acts as the department liaison with both outsourced vendors and internal departments such as HRIS, HRSS, Finance, Payroll and GTS.• Project manages all projects that pertain to Global Benefits department.• Provides various benefits ad hoc reports to outside benefits consultancies for use in analyzing retiree health liabilities and year-over-year utilization and cost trends for analysis into recommended plan design changes for actives and retirees put forth by benefits consultancies.• Conduct analyses using Optum Health’s, Benefit Analytics Manager Application (outsourced medical data warehousing solution).

• Responsible for all Capital Expenditure related activity and review for accuracy and feasibility.• Prepares Ad hoc analyses for upper management.• Maintains systems applications, including managing users, profiles, account access, security, and troubleshooting issues.• Manages Quarterly Financial Certifications for Tech Data worldwide.• Compiles and loads data received from other departments utilizing spreadsheet and database applications.• Prepares and analyzes daily Europe and Worldwide Flash (Snapshot) reporting.• Maintain, update, and sends 50 reports on a monthly basis. • Validates accuracy of reported numbers.• Prepares daily reconciliation reports for actual and forecasted spending on a daily basis. Accomplishments:• Awarded the Quality Recognition Award in January 2012.• Successfully created an Ad Hoc comparison analysis report using VBA.

• Administers subscription revenue related activities for several magazines in accordance with GAAP as directed by Corporate Accounting Policy. Currently responsible for booking approx 39 million in revenue each month/468 million each year.• Analyzes financial reports for accuracy in reporting deferred income, cash/receipts, and agency and subscription revenue. • Resolves discrepancies by working with various departments (e.g. Applications Development, Marketing Services, and Agency).• Ensures that magazine subscription revenue is reported into the PeopleSoft general ledger system, in accordance with GAAP and Corporate Accounting Policy, on an accurate and timely basis.• Performs monthly reconciliations to of key general ledger accounts (e.g. refunds, cash, account receivables), proposes adjustments, identifies errors, and resolves errors with appropriate parties.• Evaluates the processing of all magazine transactions into the fulfillment systems and recommends financial controls so system reporting can be relied upon and/or enhanced.Accomplishments:• Created EOM (End of Month) template that is currently used to consolidate and provide up-to-date information on all reconciliations within the finance department. • Successfully provided a full training class on the uses, advantages, & understanding of COGNOS Cubes. • Provided a small training session on how to create and use a Pivot Table in Excel.• Chosen as the “go to” guy for all PeopleSoft related questions within the group. • Asked to conduct an Excel training class on items such as VLOOKUPS, IF Statements, HLOOKUPS, SUMIF, SUMIFS, COUNTIF & various keyboard shortcuts. • Project lead and developer on a re-vamp automation process on 250 reconciliations sent to Time Inc Corporate. • Promoted Jan 1st, 2011 from Financial Analyst to Sr. Financial Analyst.• Received Star Award for automation of a large reconciliation process. Reduced efforts from 6 hours to 30 minutes.

• Used PeopleSoft Financials for Purchasing, Queries, and Reports to help monitor and report actual spending and budget forecasting.• Provide product development and departmental support by compiling information for budgets, issues and cash flow to reflect up to date information on programs and costs totaling in 30 Million dollars.• Gather updated forecasted spending from Digital Media for all programs in development. • Provide cost analysis and detail of vendor spending to project managers to assess forecasted spending.• Process forty invoices equivalent to $25K on a weekly basis using PeopleSoft FinancialsAccomplishments:• Developed MS Excel timesheet for temporary employees to record Direct Labor costs for all program budgets.• Created detailed cash projection spreadsheet for the Digital Media Department to reflect budget, actual spending, current forecast, and projected forecast for the next 2 years.

Bachelor Of Science (Bs), Business Administration And Management, General

Minor - Computer Science

Associate Of Arts (Aa), General Education