Lori Simmons
Kansas City,MO
Summary
Intrinsically, I am an artist. I graduated with a degree from the School of Fine Arts after accelerating my interests in painting and statistical mathematics. While working as an art teacher and art entrepreneur for several years, I found my passion for data analytics when it meant calculating art supplies costs, developing lesson plans, and measuring student comprehension. Finding correlations between costs, planning, and results has led me to this journey in data analytics & corporate technology. I have worked in 3 different industries as a Business Intelligence Analyst: Healthcare EMR software, collections, and insurance. My knowledge with business intelligence tools, particularly Power BI, has been transferrable amoung each industry. My experience in different industries has also broadened my understanding of various business models and metrics.
Overview
6
6
years of professional experience
Work History
Business Intelligence Analyst
IAT Corp
Kansas City, MO
02.2023 - 10.2023
- Created a Power BI Service app for all commercial transportation businesses, including 4 dashboards complete with row-level security for each business unit.
- Reported insurance industry standard KPIs for quotes, rate changes, bound vs. issued premiums, & predictive retention percentages.
- Streamlined 30% of operational work for the insurance audits department by designing a dashboard to combine multiple audit related data sources into one.
- Communicated directly with CEO, Bill Cunningham, to introduce AI technology within the new Microsoft stack co-pilot feature. This opened the discussion on how the company will leverage AI resources to enhance business support and revenue.
Business Intelligence Analyst
NeuAnalytics
Overland Park, KS
03.2022 - 02.2023
- NeuAnalytics is a SaaS company in the collections field, where I provided analytical insights to our clients (primarily banks).
- Maintained a datamart that combined vendor performance and risk related data points to form benchmarks and detect industry patterns.
- Developed metrics and visuals using Power BI Desktop and Excel.
- Created quarterly PowerPoint decks for clients, highlighting vendor trends: call efforts, regulatory violations, vendor workload, portfolio size biases, etc.
- By presenting my business insights to our clients, I helped the company sell software compliance packages to roughly 40% of our clients within 2 business quarters.
Business Intelligence Analyst
Cerner Corporation
Kansas City, MO
03.2021 - 03.2022
- Designed and maintained dashboards for internal stakeholders who manage Cerner/Oracle software support in the cost center.
- Wrote and published data dictionaries to Cerner's intranet, to inform dashboard users of metric calculations and data sources.
- Utilized Jira 3 methodology for deliverables.
- Migrated database tables from Microsoft SSMS over to Snowflake's data warehousing service; which required a learning curve of JSON code translation.
- Formulated a complex SQL query for a triage report: Since we had one table of new clients and one table of support teams that were not related, I designed a cartesian product with a subquery to decipher which team each new client should be assigned to.
Change Implementation Analyst
Cerner Corporation
Kansas City, MO
09.2017 - 03.2021
- Conducted the implementation, testing, and validation of electronic medical record (EMR) solution changes for a popular medical software known as PowerChart.
- Administered troubleshooting processes and system updates.
- Applied backend Cerner Command Language skills for uploading and retaining provider information in the cloud.
- I was required to input solution change data and client correspondence data into a kanban board system that tracked resolution and request turnover time and client satisfaction reports. This knowledge allowed me to progress into a business role since I was familiar with the data I was analyzing.
Education
Bachelor of Arts - Fine Arts, Painting
University of Kansas
Lawrence12-2008
Continuing Education - Data Analytics
Johnson County Community College
Overland ParkSkills
- Data Visualization
- Data Warehousing
- Dashboard Creation
- Business Analysis
- KPI Monitoring
- Data Quality Management
- BI Tools Expertise
- SQL - DDL, DML, DCL
Timeline
Business Intelligence Analyst
IAT Corp
02.2023 - 10.2023
Business Intelligence Analyst
NeuAnalytics
03.2022 - 02.2023
Business Intelligence Analyst
Cerner Corporation
03.2021 - 03.2022
Change Implementation Analyst
Cerner Corporation
09.2017 - 03.2021
Bachelor of Arts - Fine Arts, Painting
University of Kansas
Continuing Education - Data Analytics
Johnson County Community College
Educational Conferences
- Microsoft Power Platform Annual Conference, Las Vegas, October 2023
References
References available upon request.
Educational Conferences
- Microsoft Power Platform Annual Conference, Las Vegas, October 2023
References
References available upon request.