Crystal Mckenzie Email and Phone Number

• Provide data and analysis in support of all aspects of the Human Resources function; including creating and producing regularly scheduled and ad-hoc reports using data from various systems and other sources to identify possible issues and trends• Perform data analysis on various HR data and create meaningful metrics and analysis reports• Process and monitor all requests to ensure timely processing, collaborating with departments/campuses to get required information to complete request in timely fashion• Ensure quality data collection techniques are established for reporting• Provide analysis and make recommendations based upon the data to be utilized in decision making and presentations• Ensure accurate and clean data that is validated for all reporting and core processes, including creating, maintaining and refining multiple categorizations• Helps resolve data audit issues and systems issues causing incorrect data• Serve as liaison with IT Department to collect and review data• Recommend solutions to ensure data improvements over time• Audit and provide additional data checks with overall team• Analyze data in order to identify areas of concern or best practices for human resources business partners to review in more detail.• Combine data from all HR systems to produce a holistic view workforce and HR programs that affect them• Tracks HR data, including employee compliance documents• May serve as backup for other HR employees as needed

• Led compensation projects and market studies from inception to implementation, including analysis of data, salary recommendations, cost projections, presentations, and communication plans• Oversaw the implementation of a paperless HR personnel file project; development of protocol and systems to maintain proper paperless operations; led the training of all district supervisor staff regarding the use of the paperless HR file system• Responsible for moderate to complex projects covering key areas of compensation including changes to regulatory provisions, employee communications regarding compensation, analyzing effectiveness of current pay plans, ad-hoc report and analysis requests• Performed analytical functions with a high degree of accuracy• Maintained the position management system; reviewed data entry of personnel and position management information• Monitored and enforced staffing ratios in accordance with board approved staffing allocations• Provided forecasting information and salary projection simulations; developed reports for finance, personnel, payroll, campuses and monitored reports for the employee data sheet application through Employee Access• Developed and disseminated approved employee calendars and salary/stipend schedules• Oversaw the guest educator payroll

• Provided guidance and direction to a team of 6, which included 3 direct reports• Completed, reviewed, and presented comprehensive liability analysis for multiple markets, products, and levels of care, for a continuous 3-year period• Developed staffing models and pricing for new business; worked in conjunction with implementation team and various impacted departments• Facilitated communication between parent company Centene, Cenpatico, and Health Plans• Conducted monthly meetings between Clinical, Network, Contracting, and Finance departments, to discuss market trends, and other anticipated impacts to utilization and expense trends• Oversaw re-procurement pricing analysis in conjunction with corporate actuaries and independent actuarial consultants• Conducted ad hoc analysis on as needed basis• Responsible for annual budgeting and continuous forecasting of medical expenses for current and future years

Projecting and analyzing reserves for markets, products, and lines of care; general and administrative expense forecasting and analysis; staffing modelsCenpatico became Envolve Health

• Completed journal entries, financial information, reports and reconciliations accurately and fully referenced• Gained and maintained a thorough understanding of entries and schedules to be able to communicate the numbers to others, and address questions knowledgeably• Provided objective analysis that ensured the company’s financial statements were materially correct• Provided peer/tech reviews and assistance to team members• Prepared, reviewed, and distributed daily premium reports• Maintained company records in an organized manner and adhered to the company’s record retention policy• Researched and documented assigned accounting guidance• Assisted with ad hoc reporting requests as well as the preparation and filing of regulatory reports/contractual agreements (NAIC, NCCI, TDI, DOL, etc.)• Supported internal audits related to the financial reporting process• Performed quality assurance in the Financial Reporting department to ensure journal entries, packages, calendar, and regulatory filings had the appropriate support and approvals

• Provided routine and ad-hoc analysis and information to internal and external customers that were timely, accurate and contributed to the maintenance of sound business operations• Presented objective analysis that helped ensure the company’s assets were either protected or being used efficiently and effectively• Assisted business units and the planning area with the development, maintenance and monthly reporting of business plans and budgets• Prepared and validated staffing models• Maintained operating and contractor expense tracking and projection reports as well as the financial quadrant of the CIO dashboard• Oversaw monthly analysis of capital expenditures• Provided guidance to customers on year-end accruals and ensured compliance with Financial Services guidelines for submission• Assisted business units as needed with workflow analysis and documentation• Assisted department or other analysts with the planning, measurement, and implementation of special projects• Prepared cost benefit analyses for internal projects and capital expenditures• Analyzed and assisted in the analysis of performance measures and budget variances in support for senior management reviews

• Managed accounts receivable and accounts payable• Reconciled monthly bank and credit card statements• Performed end-of-month closing journal entries• Researched and reviewed information in order to make recommendations on company purchasing decisions• Calculated payroll hours for each pay period• Computed monthly sales tax amounts and submitted sales tax reports to the State Comptroller• Managed company’s checking accounts and petty cash