Power Bi Data Analysis

Karissa Herns

************@*****.*** https://www.linkedin.com/in/karissa-herns/ https://github.com/karissa-herns

Summary

High-energy and adaptable professional skilled in leveraging data to drive efficiency and decision-making. Proficient in Excel, Power BI, and data analysis, with experience transforming complex datasets into actionable insights. Adept at solving problems, collaborating across teams, and optimizing performance in fast-paced environments.

Professional Highlights

•Expertise in data analysis, cleaning, and reporting using Excel, Power BI, and DAX.

•Proven ability to collaborate across teams, manage projects, and communicate complex data insights effectively.

•Strong problem-solving skills with a focus on improving operational efficiency and accuracy via data-driven decisions.

•Highly detail-oriented, with experience in quality assurance, policy application, and technical issue resolution.

Education

Western Governors University BS, Data Analytics and Data Management, Aug 2023

•Data Analysis and Management: SQL, R, Power BI, Tableau

•Data Visualization: Power BI, Python (Matplotlib, Seaborn), R (ggplot2)

•Data Cleaning and Manipulation: Python (Pandas, NumPy), R

•Statistical Analysis: Python (SciPy, Statsmodels), R

•Machine Learning: Python (Scikit-learn)

University of Houston - Clear Lake BS, Psychology, Jan 2020

•Research Methods & Survey Design: Designed and conducted research using Qualtrics for survey development, data collection, and analysis.

•Statistical Analysis: Applied SPSS and Qualtrics for regression analysis, and descriptive statistics.

•Data Collection: Developed surveys in Qualtrics, collecting and ensuring the quality of data.

•Academic Writing: Wrote comprehensive research reports, including literature reviews, methodology, and conclusions.

Work Experience

SouthState Bank Technical Support Analyst, Jan 2024 – Present

•Created a DAX-powered distance matrix to optimize technician assignments to branch locations.

•Cleaned and cross-referenced employee data from multiple systems, including Active Directory (AD), Workday, and ServiceNow, ensuring data accuracy and consistency across reports.

•Played a key role in incident response during a cybersecurity breach, assisting in restoration of over 5,800 user accounts.

•Selected by leadership to head the chat support initiative, conducting agent-side demos for executives, highlighting my leadership and communication skills.

Northwestern Mutual Technical Support Analyst, Mar 2022 - Jan 2024

•Cleaned and transformed data to generate performance reports in Excel and Power BI, providing data-driven insights on chat efficiency to optimize workforce allocation and improve operational performance.

•Managed technical issues across 1,500+ diverse software systems, ensuring seamless operations for over 30,000 users.

•Promoted to training team support role within six months, assisting new analysts in developing technical and data analysis skills necessary for supporting complex financial systems.

•Monitored KPIs to maintain high user satisfaction and operational standards while delivering multi-tiered support for complex software systems a Fortune 100 company.

Brazosport College Supplemental Instruction, Jul 2019 - May 2023

•Collected, organized, and processed student data in compliance with FERPA regulations, ensuring data integrity and confidentiality in line with federal guidelines.

•Managed secure data environments for student records, applying quality assurance measures to safeguard the accuracy of reports and analysis.

•Supported decision-making through data-driven insights, preparing reports on student engagement and performance for program improvement.

•Facilitated cross-team collaboration to optimize the collection and communication of student data, enhancing data security and accessibility.

Lake Jackson Massage Therapy Owner/Administrator, Apr 2007 - Apr 2020

•Managed and organized payment processing for over 500 clients using credit card systems, ensuring timely and accurate processing of transactions.

•Processed confidential client data and ensured the security of payment information in compliance with industry standards, maintaining a high level of trust and transparency.

•Built and managed a client database, applying data analysis to track client behavior, improve retention, and streamline business operations.

•Conducted financial analyses and data-driven decision-making to refine service offerings, aligning client needs with business profitability.

•Developed procedures for ensuring data integrity and accuracy in financial records.

Projects

Analysis of Hold Times in Call Center Data Western Governors University, 2023

•Analyzed data using Python and Jupyter Notebook to explore correlation between call hold time and escalations.

•Applied Chi-square testing to demonstrate statistical significance between hold times and escalations.

•Created visualizations (heatmaps, bar charts) to communicate insights, influencing staffing recommendations to reduce escalations.

Analysis of Movie Data Western Governors University, 2023

•Cleaned and analyzed movie data using Python to identify trends in genre profitability, producing insights into how budget allocations affect revenue.

•Created visualizations, including bar graphs and scatterplots, to present data-driven findings that influenced recommendations on budget strategies for film projects.

•Cleaned data and calculated average budgets and revenues by genre and director.

Twitter Data Analysis Udacity, 2023

•Cleaned and prepared datasets using Python in Jupyter Notebook, including handling inconsistent data types and merging dataframes.

•Conducted data wrangling to clean and merge datasets in Python, analyzing trends in tweet content (dog names, sources, labels) and their impact on retweet frequency.

•Developed visualizations to effectively communicate patterns, providing insights on content that drives higher user engagement.

Bikeshare Data Analysis Udacity, 2023

•Cleaned and merged datasets using R and tidyverse, handling missing values and data conversions.

•Analyzed bikeshare data using R to identify peak usage times, popular stations, and demographic patterns, generating insights to inform decisions on station placement and service expansion.

•Created ggplot2 visualizations to clearly communicate trends, driving data-backed recommendations for service optimization.

A/B Test Results: Webpage Conversion Analysis Udacity, 2023

•Conducted an A/B test to evaluate the impact of a new webpage design on user conversion rates, using Z-tests and logistic regression to determine statistically significant differences.

•Provided conversion rate optimization recommendations based on data analysis, including the influence of webpage version and country on user behavior.

•Visualized the sampling distribution using Matplotlib, comparing actual vs. simulated conversion differences.

Association Between Conscientiousness and Working Memory Capacity University of Houston - Clear Lake, 2020

•Designed and conducted a study using Qualtrics, exploring the relationship between conscientiousness and working memory capacity, identifying a statistically significant relationship with potential applications in educational performance.

•Analyzed data using SPSS and presented findings to inform educational strategies for improving cognitive performance.

•Presented findings on the implications of conscientiousness in cognitive performance, with potential applications in educational contexts.

Perceived Fit of First-Generation College Graduates in Corporate Culture University of Houston - Clear Lake, 2020

•Designed and conducted a study using Qualtrics to explore the corporate culture fit, job satisfaction, and career advancement of first-generation graduates versus non-first-generation graduates.

•Analyzed survey data with SPSS, using t-tests and regression analysis to determine the relationship between corporate culture fit and job satisfaction (p < 0.01).

•Found that first-generation graduates reported significantly lower corporate culture fit but achieved comparable levels of job satisfaction and career success.

Certifications

•CIW Data Analyst (1D0-622): Data Wrangling, Data Modeling, Power BI, Excel, Data Visualization

•CompTIA A+, Network+, Security+: Networking Fundamentals, Information Security, Risk Management

•CompTIA Project+: Project Management, Agile Methodologies

•Microsoft Azure-900: Cloud Technologies, Azure Services

•ITIL Fundamentals: Service Management, IT Support Processes

•HDI Customer Service Representative: Customer Support, Incident Resolution

Contact this candidate