Marc Welc Email & Phone Number

-Developed and managed monthly KPI package that provided key insights into the performances of 19 branch locations, combining reports on profitability analysis, academic performance, employee retention, and sales metrics to provide a comprehensive analysis of the franchise.-Prepared and delivered quarterly presentations to CEO and CFO of year-to-date and year-over-year financials, including customer demographics, sales trends, expense analysis, and budgeting and explanations of… Show more -Developed and managed monthly KPI package that provided key insights into the performances of 19 branch locations, combining reports on profitability analysis, academic performance, employee retention, and sales metrics to provide a comprehensive analysis of the franchise.-Prepared and delivered quarterly presentations to CEO and CFO of year-to-date and year-over-year financials, including customer demographics, sales trends, expense analysis, and budgeting and explanations of variances.-Worked in constant collaboration with other departments to improve operational efficiency and increase data integrity and connectivity by designing and implementing user-friendly tools (Excel and Microsoft VBA) to automate various processes.-Developed scheduling Excel tool enabling campuses to manipulate schedules in a custom test environment, adding additional filters and conditions not allowed by scheduling software, while keeping the user interface simple with all formulas and background processes hidden.-Developed and maintained custom forms in Google Suite that triggered VBA code to automatically duplicate and organize essential documents for academics while tracking the information stored in shared spreadsheets to allow for campus monitoring of student progress.-Created Excel auditing tools to enable branches to check for duplicates and inaccuracies in billing to minimize risk and keep forecasted revenue accurate.-Responsible for monthly accruals and cash reconciliations of all bank accounts. Show less

-Designed numerous reporting procedures (Renewal Tracker, Bucket Report, Transcript Tracker) that incorporated multiple fragmented systems to capture pivotal data, including customer renewal rates, annual demographics, and records tracking.-Developed and implemented new student ID and services tracking that increased data fidelity and enabled report linkage between systems (ASSIST student information system, Teachworks scheduler, custom department-based spreadsheets).-Lead multiple… Show more -Designed numerous reporting procedures (Renewal Tracker, Bucket Report, Transcript Tracker) that incorporated multiple fragmented systems to capture pivotal data, including customer renewal rates, annual demographics, and records tracking.-Developed and implemented new student ID and services tracking that increased data fidelity and enabled report linkage between systems (ASSIST student information system, Teachworks scheduler, custom department-based spreadsheets).-Lead multiple projects to research and acquire new support software (Dropbox Sign, ASSIST, scheduling software), working with finance, admissions, vendors, and leadership teams to meet budget and functionality constraints, and then lead the implementation, training, and integration into existing systems.-Responsible for design and continual audit of program requirements in adherence to state, federal, accreditation and college admission standards across multiple states.-Worked with academics department to ensure compliance with all Cognia standards (accreditation) .-Developed biannual audits of state legislation to ensure program requirements met all state laws.-Continually researched contemporary institutions and college admissions requirements to keep campus programs competitive. Show less

Schaumburg, Il

Schaumburg, Il

-Oversaw team goals and service level agreements while allocating daily tasks to staff (21 employees) to strategically meet departmental metrics on document acquisition and customer inquiry resolution.-Designed weekly reports and analytical summaries of document retrieval for university leadership in order to aid in projections of student population/customer retention.-Utilized Excel VBA Macros to create workbook templates that automated previously time-consuming data collection and… Show more -Oversaw team goals and service level agreements while allocating daily tasks to staff (21 employees) to strategically meet departmental metrics on document acquisition and customer inquiry resolution.-Designed weekly reports and analytical summaries of document retrieval for university leadership in order to aid in projections of student population/customer retention.-Utilized Excel VBA Macros to create workbook templates that automated previously time-consuming data collection and work distribution procedures.-Developed new auditing techniques and procedures that introduced quantitative accountability metrics and lead to a measured increase in both staff work output and compliance with documentation requirements regarding customer interactions.-Designed and implemented new documentation requirements for employee activities, which resulted in more effective interdepartmental communication and more knowledgeable and prompt customer assistance.-Lead special project that successfully decreased processing time of transcript evaluation by 80 percent to meet new university goals by reorganizing team structure, altering task distributions across the department, and training staff to use new Excel tools.-Reviewed and coached individual staff performance, assigning monthly goals and strategic improvement plans. Show less

Belvidere, Il

Responsible for organizing, managing, and coordinating shift functions within the restaurant.Performed such duties as scheduling, interviewing, training, coaching, and monitoring inventory.