Patrick Wambaugh
Business Analyst
Tacoma,Washington
Summary
Business Analyst skilled in data analysis and reporting, proficient in Power BI, Tableau, Snowflake, Excel, and SQL Server. Demonstrated ability to conduct gap analyses, optimize processes, and generate actionable insights leading to a 50% reduction in report generation time. Experienced in cross-functional collaboration and fostering strong stakeholder relationships. Committed to delivering high-quality documentation and strategic problem-solving to maximize organizational efficiency.
Overview
11
11
years of professional experience
Work History
Business Analyst
WatchGuard Technologies, Inc.
06.2021 - Current
- Recruited as Business Analyst by leadership due to exceptional skills and potential. Conducted gap analysis between existing systems and desired state, identifying improvement opportunities. Translated financial data from Snowflake, building comprehensive reports for business leaders. Developed dashboard metrics to showcase sales profitability and business effectiveness. Enhanced business processes by analyzing practices and implementing optimization strategies. Supported reporting system conversion from Tableau to Power BI.
- Supported and architectected a full system conversion from Tableau to PowerBI.
- Published 100+ ad-hoc reports to meet stakeholder needs efficiently.
- Single handedly ran and maintained entry for Point of Sale system and developed report based monitoring to ensure quality of data entered.
Account Specialist
WatchGuard Technologies, Inc.
11.2019 - 06.2021
- Promoted to Account Specialist after years of dedication and performance. Delivered high client satisfaction by resolving billing disputes and account concerns promptly. Fostered collaboration across departments to enhance profitability, embodying WatchGards core values of accountability, customer focus, and community contribution. Managed over 15 accounts, demonstrating strong organisational skills and attention to detail.
- Resolved complex billing and payment issues, ensuring accurate account balances.
- Reviewed account activity to assess financial status and identify discrepancies.
- Facilitated timely processing of purchase orders and discount rebates.
Quality Hardware Technician
WatchGuard Technologies, Inc.
09.2015 - 11.2019
- Hired for role based on exceptional contract performance. Collaborated with cross-functional teams on design reviews and validation testing for WatchGuard hardware. Managed dynamic workload while independently and collaboratively identifying and resolving issues. Fostered a positive work environment by building key relationships across teams. Maintained thorough documentation throughout development, testing, and analysis phases to boost organizational productivity. Utilized strong problem-solving skills to rigorously test defective devices, pinpointing product issues.
- Collaborated with teams to enhance design and testing processes.
- Managed workload effectively, ensuring timely issue resolution.
- Developed thorough documentation to improve team efficiency.
- Conducted rigorous tests on defective devices to identify core issues.
Skills
- Data Analysis
- Power BI
- Semantic Layer Architecture
- JIRA Project Management
- Problem Solving
- Snowflake and SQL Server
- Tableau
- Process Optimization
- Documentation
- Microsoft Excel
Timeline
Business Analyst
WatchGuard Technologies, Inc.
06.2021 - Current
Account Specialist
WatchGuard Technologies, Inc.
11.2019 - 06.2021
Quality Hardware Technician
WatchGuard Technologies, Inc.
09.2015 - 11.2019