John Rolzhausen
Business Systems Analyst | Power Platform Solutions Architect
Pipersville, PA | john.rolzhausen@live.com | LinkedIn | GitHub
Professional Summary
Business systems professional with 20 years of operational experience in educational services, transitioning into Business Systems Analyst and Solutions Architect roles at consulting firms. Proven track record building and maintaining enrollment tracking systems that served CFO-level executives for 8 years.
Combine deep operational knowledge with technical Power Platform expertise demonstrated through PL-300 certification and comprehensive portfolio project. Excel at translating business problems into technical solutions through requirements gathering, data modeling, application development, and executive analytics. Bring consultant-ready capabilities in solution architecture, stakeholder communication, and end-to-end project delivery.
Currently seeking opportunities to leverage 20 years of business process understanding alongside modern Power Platform development skills to deliver high-impact solutions for consulting clients.
Technical Skills
Power Platform Development:
✓ Power Apps: Canvas apps, delegation-aware formulas, modern controls, component architecture
✓ Power BI: DirectQuery, star schema design, advanced DAX measures, Azure Maps integration
✓ Power Automate: Workflow automation, approval processes, error handling patterns
✓ SharePoint: Data modeling, list design, validation rules, referential integrity
Data & Analytics:
✓ Data Modeling: Normalized schemas (3NF), star schemas, temporal data patterns
✓ SQL: Query writing, database design, performance optimization
✓ Excel: Advanced formulas, pivot tables, data analysis, automation (VBA)
✓ Business Intelligence: Dashboard design, KPI development, executive reporting
Solution Architecture:
✓ Requirements Analysis: Translating business problems into technical solutions
✓ System Design: Architecture decisions, scalability planning, integration patterns
✓ Documentation: Enterprise-grade technical specifications, user stories, data models
✓ Project Management: Structured development approach, deliverable tracking
Business Domain Expertise:
✓ Financial Systems: Budget tracking, forecast analysis, variance reporting
✓ Data Quality: Validation workflows, anomaly detection, audit trail design
✓ Stakeholder Management: CFO-level communication, executive dashboard delivery
✓ Process Improvement: Identifying inefficiencies, designing automation solutions
Professional Experience
Self-Directed Power Platform Portfolio Development
November 2024 - Present | Portfolio Project
Designed and developed comprehensive Global Training Enrollment System demonstrating consultant-level solution architecture capabilities from requirements through implementation.
Key Contributions:
✓ Requirements analysis translating real-world business problems into technical specifications
✓ Normalized data model design with 9 SharePoint lists, 100+ columns, referential integrity
✓ Power Apps development: 3 applications with 12 screens demonstrating modern UI/UX patterns
✓ Power BI analytics: 4-page dashboard with 17 visualizations including Azure Maps integration
✓ Power Automate workflows: Automated notifications and system integration
✓ Professional documentation: 15+ markdown files following enterprise standards
✓ Problem-solving: Systematic troubleshooting of Azure Maps migration and theme system constraints
Technologies: Power Apps, Power BI, Power Automate, SharePoint, DAX, Azure Maps, Git/GitHub
Educational Services - Finance & Systems
2005 - 2024 | 19 Years
Built and maintained enrollment tracking systems serving executive leadership for 8 years, demonstrating ability to deliver reliable, business-critical solutions.
Key Achievements:
✓ Designed SQL-based enrollment dashboard used daily by CFO and finance team for 8 years
✓ Automated nightly data refresh eliminating manual consolidation work
✓ Created star schema data model enabling multidimensional analysis
✓ Maintained single source of truth for enrollment volumes across three major test programs
✓ Enabled quick decision-making on capacity planning and resource allocation
✓ Successfully managed data quality and system reliability with zero downtime
Technologies: SQL Server, Excel (advanced formulas, VBA), Financial reporting systems
Certifications
Microsoft Certified:
✓ Power BI Data Analyst Associate (PL-300)
✓ Microsoft Office Specialist: Excel Expert
✓ Power Platform Fundamentals (PL-900)
Plus 11 additional Microsoft certifications across Power Platform, Data Analytics, and Microsoft 365
Education
Bachelor of Science in Accounting
St. Peter's College
Jersey City, NJ
Relevant Coursework:
✓ Database Management Systems
✓ Business Process Analysis
✓ Financial Information Systems
✓ Data Analytics
Download Full Resume
Download a PDF version of my resume for your records or to share with hiring teams.