University of St. Thomas - Opus College of Business

Courses included Spreadsheet Modeling, Data Visualization, Database Management Systems, Statistics, Storytelling, Healthcare Analytics, Marketing Analytics, and Python.

MS in Business Analytics Student

Lindquist & Vennum

Accounting Manager

Accounting Supervisor

Managed and trained team members on various accounting processes and procedures. Reviewed financial reporting package, journal entries, and account reconciliations monthly for accuracy. Assisted with annual budget process. Performed various ad hoc reporting and analysis.
•	Wrote procedure manuals for payroll processing, trust accounting, and fixed assets to ensure standardized procedures. 
•	Performed fixed asset accounting for Minneapolis office move with over 1,000 assets disposed and added accurately.
•	Analyzed retirement plan contribution data to confirm complex calculations were accurate and in compliance with plan governing documents. Point person for annual retirement plan audit by external accounting firm. Assisted in building database populated by information from payroll system used in calculations.
•	Compiled data for sales tax audits in 3 states and was point person for auditors. Identified and resolved issues with sales tax processes to ensure compliance with sales tax regulations and minimize potential for future penalties. Amended sales tax filings as needed.

Accountant

Allianz Life

Member of team responsible for consolidating information from various business units for internal and external financial reporting. Provided reports and filings to management and to parent company in Germany as well as various insurance regulatory agencies.
•	Undertook lead role in reporting project which helped parent company in Germany better understand organization’s results and also increased efficiency of team. This involved reformatting the monthly financial analysis report and creating a new monthly report to present results by line of business in parent company’s format.
•	Implemented new high-level actual-to-plan variance analysis for use by senior management.

Senior Accountant, Consolidated Reporting

UnitedHealthcare

Collaborated with various functions including finance, operations, actuarial, and underwriting. Conducted audits to identify process breakdowns and worked with other functions to resolve issues.
•	Documented and enhanced Excel-based revenue projection models, adding controls to increase accuracy.
•	Prepared revenue forecasts and budgets for over 20 markets.
•	Performed ad hoc analysis of actual results versus forecast and budget in order to explain variances.
•	Analyzed revenue and membership retroactivity data to determine key drivers.

Senior Financial Analyst, Operations Risk Management

Member of Health Plan Accounting Claims Team 2002-2004 and Revenue Team 2001-2002. Analyzed claims, revenue, and membership data for assigned health plans and products to identify and resolve issues.
•	Represented UnitedHealthcare Finance on cross-functional and cross-segment project team to improve process efficiency and data accuracy for stop loss accounting and reporting.
•	Developed and maintained various tools used for analysis and reporting of stop loss claims data.
•	Analyzed actual and forecast data to set medical claims payable reserves for assigned products and markets.
•	Created Access database used by multiple teams to research revenue and membership issues.

Senior Accountant, Health Plan Accounting

In Home Health, Inc.

•Directed month-end close process, consistently meeting deadlines while also ensuring accuracy and integrity of financial statements.
•Compiled monthly financial report for management and board of directors.
•Prepared SEC filings and coordinated quarterly review by external auditors.

General Accounting Supervisor

•Assisted with SEC filings, year-end audit and annual shareholder meeting.
•Streamlined investor database in Access and performed other investor relations duties including distribution of press releases and various mailings.
•Reviewed leases for corporate office and over 20 branch offices to understand obligations and rights.
•Organized office lease information into useful schedules for management and maintained lease files.
•Wrote procedures for various accounting duties.

Winmark Corporation

•Researched variances between actual results and budget.
•Produced financial statements and other management reporting.

Staff Accountant

👋Hi, I’m Christy! I am a Data Analyst with an extensive background in Accounting and Finance. 

📈I am taking a new step in my career to focus on data. I have always enjoyed analyzing and interpreting data to gain insights. I love learning new things – there is never a shortage of things to learn about with data!

💻I am currently doing the Data Analytics Accelerator program through Data Career Jumpstart. In this program, I will be doing hands-on real projects using tools including Excel, SQL, Tableau, and Python.

🎓I completed my Master’s in Business Analytics at the University of St. Thomas as well as a Master's in Business Administration.

🐱I volunteer at my local humane society helping cats find their new homes.

📚I also enjoy reading and spending time in nature.

💥Send me a personalized request if you would like to connect. Thank you for visiting my profile!

Taplio

Christy Ehlert-Mackie, MBA, MSBA's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Christy Ehlert-Mackie, MBA, MSBA's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Christy Ehlert-Mackie, MBA, MSBA's Linkedin Analytics