Power Bi Business Analyst

Aundra Marcel Cook

Huntersville, NC ***** 973-***-**** ****************@*****.*** LinkedIn

SUMMARY

Results-driven Business Analyst with a Master’s Information Systems and three years of experience in data analysis, process improvement, and IT service management. Skilled in gathering and analyzing requirements, optimizing workflows, and delivering actionable insights using SQL, Power BI, and Excel. Adept at collaborating with stakeholders, documenting business needs, and leveraging Agile methodologies to enhance operational efficiency. Strong background in IT systems, reporting, and dashboard creation, with a passion for driving data-informed decision-making. CORE COMPETENCIES

Business & Data Analysis Requirements Gathering Workflow Optimization

Stakeholder Communication Agile & Scrum Process Improvement

SQL Power BI ServiceNow Jira Reporting & Data Visualization

Documentation UAT Testing Change Management Project Coordination TECHNICAL SKILLS

• Data Analysis & Visualization: Power BI, Excel, SQL

• Project & Workflow Management: Jira, ServiceNow, Kanban

• Reporting & Documentation: SharePoint, Word, Confluence PROFESSIONAL EXPERIENCE

Business Analyst Project Highlights

• Analyze user engagement data using Power BI to identify high-value customer segments and recommend strategic service expansions that drive user retention and subscription growth. Evaluate property performance and market trends using Excel PivotTables and Power BI to support real estate investment decisions and identify top-performing areas.

• Build cohort-based analyses in Excel to track user behavior by age group and purchase month, enabling data-driven refinements in marketing strategies and customer lifecycle planning. Design interactive dashboards in Tableau and conduct detailed profitability assessments using Excel to uncover operational inefficiencies and provide actionable recovery recommendations for struggling businesses.

• Segment customers using Tableau to identify high-revenue user groups, and develop targeted, personalized marketing campaigns that increase engagement and boost revenue. Wells Fargo Business Analyst Engineering Associate 08/2022 – 09/2024

• Collaborated closely with stakeholders to investigate and resolve mainframe performance issues, translating complex technical root causes (e.g., CPU contention, memory bottlenecks) into clear business language to support decision-making.

• Facilitated cross-functional meetings and walkthroughs to gather requirements, align on expectations, and track progress using JIRA and ServiceNow.

• Created and maintained Standard Operating Procedures (SOPs) and job aids for critical workflows; ensured accuracy through reproducibility testing and defined acceptance criteria for validation.

• Acted as a liaison between engineering and business teams, converting performance metrics into actionable insights for capacity planning and strategic planning efforts.

• Designed and maintained dashboards in Power BI and Excel, monitoring key system metrics such as MIPS and MSU usage, helping guide infrastructure optimization initiatives.

• Documented and refined evolving requirements in an Agile (Kanban) environment, ensuring flexibility while maintaining traceability and version control.

• Supported engineers in defining UAT test scenarios and validating results, contributing to performance tuning and system reliability improvements. Atrium Behavioral Health Security Officer

10/2020 – 09/2021

• Ensured compliance with policies and procedures to maintain a safe environment for staff and patients.

• Documented security incidents and observations, improving communication and response times. North Carolina Department of Public Safety Probation Parole Officer II 06/2015 – 05/2020

• Conducted risk assessments and developed intervention strategies to reduce recidivism rates.

• Assisted clients with job applications and program eligibility, contributing to a 20% improvement in successful supervision completion.

• Coordinated with law enforcement and social services to ensure client compliance with court- ordered programs.

EDUCATION & CERTIFICATIONS

• Master’s Information Systems (MIS) University of Phoenix - 2021

• Graduate Certificate in Cybersecurity

• Certified Scrum Master (CSM) – Scrum Alliance (Exp. 01/2025)

• Certified Scrum Product Owner (CSPO) – Scrum Alliance (Exp. 02/2025)

• SQL Essential Training – LinkedIn

• IBM Cybersecurity Analyst – Coursera

• Business Intelligence boot camp – TripleTen (Completion 06/2025)

Contact this candidate