Gabriel Steenhoek
Ankeny,IA
Summary
Versatile, experienced, and innovative Business Systems Professional with 15+ years of experience spanning process automation, application development, data analytics, and technical architecture. Proven leader in technical operations and project delivery with a foundation in software development and data architecture. Adept at translating business needs into executable workstreams, coaching developer teams, and driving Agile delivery within complex ecosystems. Known for bridging business strategy with technical implementation and fostering high-performance DevOps collaboration. Recently Alteryx core certified.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Lead Developer / Team Lead & Deployment Coordinator
FIDELITY & GUARANTY LIFE
01.2022 - 05.2025
- Initially hired as a BI/Power Query Developer and Actuarial Data Analyst, focusing on modernizing legacy actuarial reporting processes. Progressed to Alteryx Lead Developer and team lead, providing mentorship, strategic oversight, and critical troubleshooting. Oversaw deployment, documentation and implementation of code across various business units.
- Actuarial Process Management: Led comprehensive efforts to modernize legacy actuarial reporting processes by developing automated, robust solutions using Alteryx and Power Query, significantly reducing manual intervention, minimizing error risks, and greatly enhancing efficiency. Later directed the day-to-day operational work of my Alteryx development team by breaking down complex actuarial modernization projects into actionable deliverables aligned with Agile practices.
- Team Leadership & Mentorship: Served as Alteryx Lead Developer and functional team lead, providing strategic direction, technical mentorship, and frontline troubleshooting support. Acted as a central escalation resource, driving continuous improvement and collaboration across teams. Also acted as the de facto technical project lead managing developer workload, facilitating backlog grooming, and translating evolving business needs into prioritized tasks.
- Reporting Workflow Optimization: Designed, developed, and maintained automated reporting workflows for critical business units including RILA and FIADA. Delivered custom-built reporting solutions from inception for the RILA product line and revamped complex legacy workflows for FIADA, improving accuracy, performance, and maintainability.
- Strategic Business Collaboration: Worked closely with stakeholders to translate business requirements into scalable technical solutions. Conducted comprehensive data flow analyses, prototyped automation processes, and implemented repeatable strategies to expedite and streamline actuarial reporting. Translated ambiguous requirements into detailed user stories, managing stakeholder expectations and maintaining transparency across technical and non-technical audiences.
- Automation and Efficiency Enhancements: Engineered transformative Power Query solutions that significantly accelerated report refresh times—from a full business day down to less than an hour—while markedly improving data accuracy and user experience.
- Centralized Work Management Platform: Implemented a SharePoint-based work management system for streamlined report tracking, version control, and task management, significantly improving team productivity, accountability, and operational transparency.
- JIRA Customization & Automation: Led the implementation and customization of JIRA, designing bespoke workflows, dashboards, and automation scripts tailored specifically to the team's unique needs, dramatically enhancing project management efficiency and team transparency.
- Report Usability Overhaul: Spearheaded comprehensive aesthetic and usability redesigns of key reports, notably transforming critical business tools into streamlined, intuitive interfaces for enhanced usability and accuracy.
- Standards & Best Practices Development: Defined and documented universal standards and best practices across the modernization initiative, authoring reusable report templates, automated file systems, and layout guidelines, ensuring consistency and high-quality delivery.
- Core M-Code Function Deployment: Authored robust M-Code / Power Query functions for dozens Excel-based data imports as part of a major overhaul, replacing outdated Microsoft Access dependencies, resulting in consistent, secure, and reliable production-level data refresh capabilities across the actuarial reporting environment.
Population Data Lead / SQL Developer
WELLS FARGO & COMPANY
10.2020 - 01.2022
- Served as a Population Data Lead and SQL architect for the Deposit Products Group - The PDL is a mission-critical role within the remediation team and serves as the primary researcher, developer, and subject-matter expert for the bulk of the financial calculations.
- Full-Cycle Remediation Leadership: Lead over 20 customer remediation projects through full-cycle solution delivery—from business requirements and workflow design to complex SQL development. Focused on large-scale, consumer-facing scenarios with regulatory impact, ensuring accuracy, compliance, and technical precision across high-stakes datasets.
- High-Impact Project Delivery: Executed a complex, high-stakes customer remediation project exceeding $10 million in value, delivering the solution on time and several million dollars under budget. Closed a critical technical gap in a major branch-facing application by designing custom SQL code, tailored data models, and validation frameworks—all under rigorous quality controls and regulatory scrutiny.
- Advanced SQL Development & Analysis: Regularly performed deep-dive SQL development and data analysis to build, refine, and document customer remediation workflows. Focused on validating complex datasets to meet strict regulatory standards while ensuring scalability and accuracy for high-stakes, consumer-facing projects.
- Innovative SQL Solutions: Independently designed and deployed new SQL modules to address fringe-case tax withholding scenarios, improving accuracy, maintainability, and readability of outputs for business users. Replaced legacy logic with flexible, business-friendly code structures that streamlined integration with accounting systems and adjacent workflows.
Business Analyst / Feature Architect
PRINCIPAL FINANCIAL SERVICES
07.2019 - 08.2020
- Served as a hybrid Business Analyst, Cybersecurity Analyst, and Feature Architect within the Security Engineering Team, supporting enterprise cybersecurity initiatives. Led efforts in process discovery, solution architecture, feature design and development, technical documentation, and proof-of-concept delivery across multiple secure infrastructure projects.
- Strategic Project Facilitation: Played a pivotal role in the Prisma project proof-of-concept by facilitating cross-team collaboration, capturing and validating essential business requirements, and generating detailed documentation to align diverse stakeholder groups.
- Integration Strategy Development: Designed and executed a tactical integration strategy for two enterprise email systems, translating complex technical requirements into a cohesive, business-oriented solution delivered within stringent deadlines.
- Data Loss Prevention Enhancement: Led a major enhancement initiative for the Data Loss Prevention system, performing comprehensive analysis of infrastructure and workflow dependencies. Improved system performance through enhanced monitoring, metric capture, and cybersecurity tuning.
- High-Value Data Protection: Contributed significantly to a strategic initiative aimed at securing High Value Asset data transmissions between internal teams and external partners. Responsibilities included detailed risk assessment, user-experience evaluation, and technical limitation analysis.
- Product Development & Agile Collaboration: Authored, refined, and delivered various product features in collaboration with agile scrum teams. Clearly defined business value, drafted functional requirements, established foundational architecture, and ensured alignment and consensus among stakeholders for successful iterative releases.
Cybersecurity Threat Analyst
WELLS FARGO & COMPANY
12.2018 - 07.2019
- Served as a Data Analytics Consultant, specializing in vulnerability operations, infrastructure scanning, patch forecasting, and comprehensive data analytics for managerial decision-making. Key responsibilities included database trend analysis, infrastructure health checks via ping-testing, workflow optimization, business requirement development, and team-driven process improvements to enhance operational efficiency.
- Infrastructure Vulnerability Management: Conducted comprehensive infrastructure vulnerability assessments using QUALYS scanning tools. Aggregated, scrubbed, and parsed extensive vulnerability datasets, converting raw data into actionable tasks prioritized by threat severity, then integrated them seamlessly into our workflow management system for remediation by server management teams.
- Patch Forecasting & Data Analysis: Delivered precise weekly patch-forecasting reports to multiple cybersecurity teams by analyzing large-scale QUALYS datasets. Integrated diverse external data sources, employing advanced logical waterfall methodologies to distill complex data into concise, actionable insights, significantly enhancing vulnerability management decision-making.
- Advanced Analytics & Process Enhancement: Created and implemented robust data analytics processes, including topology assessments, threat prioritization, and action-plan scheduling. This initiative evolved into standardized business processes, improving operational efficiency, data accuracy, and reducing the exposure of sensitive vulnerability data.
- Automation & Tool Modernization: Developed and deployed an innovative PowerShell-based ping-testing and server analysis tool, replacing legacy code to significantly enhance diagnostic accuracy, reduce execution time, and gather detailed analytics for critical decision-making processes.
- Workflow Optimization & Compliance: Revamped and standardized multiple business procedures governing highly sensitive vulnerability data workflows. Identified and addressed critical gaps within partner-group data handling, driving increased accountability, consistency, and visibility across the end-to-end vulnerability management lifecycle.
- Customized Reporting & Continuous Improvement: Managed dynamic, highly customized weekly reporting models, performing meticulous oversight and audits to ensure report accuracy and punctuality. Proactively identified and resolved workflow inefficiencies and data management pain-points, substantially improving reporting reliability and operational transparency.
Business Analyst / Production Support Operational Manager
DE LAGE LANDEN FINANCIAL SERVICES (DLL)
10.2005 - 10.2018
- Served primarily as a hybrid Technical Expert, Business Analyst and Application Support Specialist with key responsibilities including requirements gathering, business process definition, test-case development, user acceptance testing, SQL database management, technical analysis, and process-automation. This was a 13-year role that included a wide range of duties, spanning into infrastructure, hardware, enterprise storage and more.
- Database Conversion & Modernization: Led a large-scale conversion project transitioning from a UniData hierarchical database to a modern SQL-based InfoLease 10 database, managing initial installation, data conversion mapping, automated data cleansing, and validation processes to ensure accuracy and reliability.
- Financial Reporting Automation: Designed and automated a paperless month-end financial reporting system, significantly reducing paper usage by 10,000 sheets monthly and eliminating 20 hours of overtime labor.
- System Renovation & Optimization: Served as system architect and lead developer for the multinational InfoLease 9 reporting system overhaul for Asia-Pacific operations, drastically reducing monthly error rates and service call frequency.
- Database Management & Implementation: Directed the Rabobank/Sydney database split, overseeing system architecture design, rigorous testing, and offshore coordination to deliver successful deployment well ahead of schedule without significant issues.
- Dealer-Facing System Development: Engineered a transformative SQL-based external application for dealer-facing dataflow, reducing monthly overtime by 16 hours, paper usage, and postage costs by nearly $5,000 monthly.
- Invoicing System Enhancement: Overhauled an obsolete invoicing system into an automated SQL solution, significantly reducing invoicing errors and customer service calls, facilitating the company's first external invoicing vendor partnership.
- Online Customer Portal: Co-managed the design and implementation of DLL's first customer-facing online portal, enhancing user convenience and access to critical account information.
- Global Database Upgrades: Managed comprehensive database upgrades, patches, and report queue enhancements globally, supporting market expansion and improved user experience across multiple international regions.
Education
Bachelor of Science - Management Information Systems
IOWA STATE UNIVERSITY OF SCIENCE AND TECHNOLOGY
Ames, IASkills
- Finance / Leasing / Insurance
- UAT / QA / Testing & Validation
- Requirements Gathering & Business Analysis
- Stakeholder Engagement & Communication
- Data Analytics & Data Transformation
- Process Modernization & Automation
- Application Lifecycle Management
- Agile Project Leadership
- Operational Team Management & Leadership
- Technical & Business Documentation
- SQL / Alteryx / Excel Advanced / Power BI
Certification
Alteryx Core Certification (Dec 2024)
Accomplishments
- Awarded 2015 Q2 “IT Rock star” by DLL Finance LLC (De Lage Landen)
- Awarded 2013 “Peak-Performer” by Agricredit Acceptance (De Lage Landen)
- Awarded 2012 “HR Spotlight on Performance” by Agricredit Acceptance (De Lage Landen)
- Awarded 2010 “Peak-Performer” by Agricredit Acceptance (De Lage Landen)
- Awarded 2008 “Peak-Performer” by Agricredit Acceptance (De Lage Landen)
Timeline
Lead Developer / Team Lead & Deployment Coordinator
FIDELITY & GUARANTY LIFE
01.2022 - 05.2025
Population Data Lead / SQL Developer
WELLS FARGO & COMPANY
10.2020 - 01.2022
Business Analyst / Feature Architect
PRINCIPAL FINANCIAL SERVICES
07.2019 - 08.2020
Cybersecurity Threat Analyst
WELLS FARGO & COMPANY
12.2018 - 07.2019
Business Analyst / Production Support Operational Manager
DE LAGE LANDEN FINANCIAL SERVICES (DLL)
10.2005 - 10.2018
Bachelor of Science - Management Information Systems
IOWA STATE UNIVERSITY OF SCIENCE AND TECHNOLOGY
Similar Profiles
Katelyn WinjumKatelyn Winjum
Sr. Compliance Analyst at Fidelity & Guaranty LifeSr. Compliance Analyst at Fidelity & Guaranty Life
Debbie CunninghamDebbie Cunningham
New Business Call Center Representative at Fidelity & Guaranty Life Insurance CompanyNew Business Call Center Representative at Fidelity & Guaranty Life Insurance Company
Jade BuffenbargerJade Buffenbarger
AVP - Claims, Issue Resolution, Business Controls at Fidelity & Guaranty LifeAVP - Claims, Issue Resolution, Business Controls at Fidelity & Guaranty Life
MARY BAISELMARY BAISEL
Host Home Provider at Faith And Family CareHost Home Provider at Faith And Family Care
Teagen BullockTeagen Bullock
Mechanical Engineering R&D Intern at Apogee Instruments, Inc.Mechanical Engineering R&D Intern at Apogee Instruments, Inc.