John Rolzhausen
Finance Systems Analyst | Power Platform Solutions Developer
Pipersville, PA | john.rolzhausen@live.com | LinkedIn | GitHub
Professional Summary
Business systems professional with 20 years of operational experience in educational services. Proven track record building and maintaining enrollment tracking systems that served CFO-level executives for 8 years.
Combine deep operational knowledge with hands-on Power Platform development across model-driven and canvas apps, Power Automate, Dataverse, and Copilot Studio, validated by PL-300, AB-730, and four Microsoft Applied Skills. Excel at translating business problems into working solutions through requirements analysis, data modeling, application development, automation, and AI integration.
Currently seeking opportunities to pair 20 years of business process understanding with modern, AI-integrated Power Platform development to deliver high-impact solutions.
Technical Skills
Power Platform Development:
✓ Power Apps: Canvas and model-driven apps, delegation-aware formulas, PCF components, design-token systems
✓ Copilot Studio: Conversational AI agents, knowledge sources, Adaptive Cards, app embedding with Entra single sign-on
✓ Power Automate: Workflow automation, approval processes, SLA enforcement, error handling
✓ Dataverse & SharePoint: Relational data modeling, security roles, account-scoped access
✓ Power BI: DirectQuery, star schema design, advanced DAX, Azure Maps
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 Design & Delivery:
✓ 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
2024 - Present | Portfolio Projects
Arcova Engage (2026): Designed and built a multi-surface client engagement management solution, a model-driven Agent Hub, a canvas Client Portal, seven Power Automate flows, and a Copilot Studio agent embedded with single sign-on, all on a shared Dataverse model.
✓ Embedded an AI agent in a canvas app via a PCF control with Microsoft Entra single sign-on
✓ Built cross-phase automation where one conversation triggers routing, SLA assignment, and lifecycle tracking
✓ Implemented account-scoped security across all four surfaces, verified through end-to-end testing
✓ Documented the full build with architecture diagram, personas, and phase write-ups
Global Training Enrollment System (2025): Designed a Power Platform solution replacing fragmented email-based enrollment with a standardized, automated workflow.
✓ Normalized data model across 9 SharePoint lists with referential integrity
✓ Three Power Apps (12 screens) and a 4-page Power BI dashboard with Azure Maps
✓ Automated notification and integration workflows
✓ Enterprise-grade documentation throughout
Technologies: Power Apps (canvas + model-driven), Copilot Studio, Power Automate, Dataverse, Power BI, SharePoint, DAX, Microsoft Entra ID, PCF, 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)
✓ AI Business Professional (AB-730)
✓ Power Platform Fundamentals (PL-900)
✓ Microsoft Office Specialist: Excel Expert
Plus additional Microsoft certifications and Applied Skills across Power Platform, AI, and data
Education
Bachelor of Science in Accounting
St. Peter's University (formerly St. Peter's College)
Jersey City, NJ
Download Full Resume
Download a PDF version of my resume for your records or to share with hiring teams.