Aaron Mitchell
Business Analyst
Des Moines, IA 路 (515) 555-0152 路 aaron.mitchell@example.com 路 linkedin.com/in/example
Summary
Business analyst with two years in banking and healthcare, after a business administration degree and a business analysis internship. Leads requirements gathering, maps business processes, writes functional requirements, user stories and test cases, and backs data driven decisions with SQL, Python, Microsoft Excel and Power BI. Works comfortably with finance, engineering and information technology teams alike.
Education
B.S. in Business Administration, minor in Computer Science (coursework in mathematics and statistics), Prairie View College, 2024
Skills
- Business analysis
- Business requirements, Business process mapping, User stories, Use cases, User acceptance testing
- Data
- SQL, Python, Microsoft Excel, Power BI, Tableau, Data analysis
- Tools
- Jira, Visio, Agile (Scrum), Microsoft Office Suite
Experience
Business Analyst I, Lakeside Credit Union
Des Moines, IA 路 Sep 2024 to present
- Ran requirements gathering workshops with lending, finance and information technology for a new loan intake system, and wrote 60 user stories with acceptance criteria in Jira.
- Mapped business processes in Visio and removed duplicate approval steps from loan approvals.
- Helped plan test cases and ran user acceptance testing with quality assurance and the software development team.
- Built Power BI dashboarding and data visualization of 10 loan KPIs from SQL database queries, replacing a weekly Excel model for the business operations team.
- Wrote the functional requirements for automation of member statements, and the change saved the accounting team 30 hours a month.
- Built loan volume forecasting for the marketing team with Python coding and quantitative methods, and the business strategy that followed lifted applications by 9%.
Business Analysis Intern, Summit Health Partners
Cedar Rapids, IA 路 Summer 2024
- Documented 12 use cases and process flows for a healthcare scheduling project with the technical team, and kept the project planning, project documentation and business case in PowerPoint.
- Analyzed patient wait-time records with data analytics in Excel and Tableau.
- Wrote the proposal comparing 4 scheduling software vendors from market research and business analytics across 3 information systems, and the project manager chose the lowest-cost option.
- Handled client service and customer service tickets about the old system, turning common complaints into requirements.