LAWRENCE GAGEN
West Des Moines,IA
Summary
Experienced Business Analyst and Administrator with a strong focus on managing the entire project life cycle for business software and systems. Skilled in gathering user stories, writing requirements, test plans, and test scripts. Ensures accuracy of test data through SQL queries from multiple data repositories. Proficient in testing, training, production validation, and implementing business systems. Proven track record in conducting System Integration and User Acceptance Testing for high-quality results. Capable of evaluating business needs and delivering value-driven solutions that exceed stakeholder expectations. Extensive industry experience in finance, banking, insurance, transportation, and healthcare sectors.
Overview
23
23
years of professional experience
Work History
Sr. Business Systems Analyst
Dupaco Community Credit Union
10.2023 - 02.2024
- Implement and support complex, critical software applications (20+) including Workday and Oracle Financials in collaboration with IT operations, infrastructure, and support teams
- As the subject matter expert on these systems, I was responsible for updates and working closely with the business units on future changes
- Track production issues from the Help Desk (2nd level support assigned to the Systems Analyst team utilizing MRM (internal case tracking application) for production support
- If necessary, open cases with Finastra (external case tracking with financial software vender) to produce solutions to production issues
- Implement necessary administrator duties such as installing patches, fixes and upgrades as scheduled and needed
- Meet weekly with support teams and various department managers to track, maintain, and improve any processes and functionalities
- Create, edit, and run SQL queries to be used in workable solutions to issues or as requested by various department managers
- Create queries for various department managers and stakeholders
- Liaison between IT Staff (developers, programmers, help desk, and managers) and financial\accounting departments.
Business Systems Analyst
T-Mobile (via TEK Systems)
05.2022 - 01.2023
- Leverage fraud expertise to analyze risks and fraud threats within T-Mobile product lines in partnership with the Sr
- Manager and Director of Fraud Technology
- Performed research and risk assessments, created risk matrices and profiles, and identified technology solution options within these spaces
- Developed into the subject matter expert and leader in these product spaces
- Leverage fraud expertise to research security and fraud risks for a variety of T-Mobile product lines
- Developed and maintained an understanding of the technology vendors and solution providers and how their solutions align to our identified fraud risk areas
- Utilized Salesforce as our ticketing system for issues
- Review and provide feedback on large-scale technical and business decisions and develop standards utilizing superior technical and analytical skills, excellent business knowledge, and knowledge of current and future technology roadmaps
- Acted as a business and technical resource for the Fraud Management team and provided direction to business and IT on technical issues associated with business production problems and/or projects
- Created User Stories and Business Requirements; Champion Fraud’s needs on Enterprise Projects; Track projects and provide Go/No-Go decisions
- Partnered with Product and Technology teams to define, analyze, and create requirements and business cases for new initiatives
- Identified major gaps and opportunities and introduced unique and repeatable solutions
- Concurrently managed multiple projects and initiatives
- Lead, inspire, influence, and manage across internal functions and external partners to deliver functional goals and KPIs.
Sr. Business QA Analyst
Wells Fargo & Co.
11.2019 - 12.2021
- Serve as lead in full test lifecycle tasks including creating test plans, condition test accounts with enhancement and regression scenarios, validate test outputs, document any test failures and resolutions, retest, and present final test results to key stakeholders before placing new products into production
- Coordinated remediations when necessary, between stakeholders and IT staff
- Work within the SMC (Systems Management & Consulting) department to support consumer and business credit products (credit cards, private label cards, lines, and loans) utilizing the First Data/Fiserv system of record and SQL to gather customer data and statistics, including (SSIS) SQL Server Integration Services to extract data from credit card related XMLs and data warehouses
- Work within the Plastics, Letters, Statements, Collateral channels in collaboration with internal line of business partners and the external third-party vendor, First Data/Fiserv utilizing SVP, CIV, Hogan and Hogan CIS
- This includes EMV chip and stripe card types
- Worked with Apple Wallet and Google Pay/Wallet validation testing and production account processing
- Complete required production audits, which may occasionally entail travel and/or validations during evenings, weekends, and holidays
- Partner with Marketing and other business teams (including SME) to ensure processes are compliant and risks have been identified and mitigated
- Manage process improvements for development processes to increase quality of testing and decrease defects
- Projects include the development and/or upgrade of existing or new applications and APIs
- Tasked with creating and updating documentation for projects on business applications
- Work as a liaison between business stakeholders, marketing, and IT to review and prioritize the backlog of requests.
Business Systems Analyst
Wells Fargo & Co.
04.2014 - 11.2019
- Serve as lead in full test lifecycle tasks including creating test plans, condition test accounts with enhancement and regression scenarios, validate test outputs, document any test failures and resolutions, retest, and present final test results to key stakeholders before placing new products into production
- Worked within the CTM Group with the FDR Validation team validating production account processes, billing, and statements, in addition to support all stages of Credit Card testing and the lead for Campaigns (Invitation to Apply (ITA), Invitation to Apply, MultiCard (ITA MC), and Firm Offer (FO))
- Work within the Plastics, Letters, Statements, and Collateral channels in collaboration with internal line of business partners and the external third-party vendor, First Data/Fiserv utilizing SVP, CIV, Hogan and Hogan CIS
- Worked with card types: EMV chip and stripe
- Worked with Apple Pay/Wallet and Google Pay/Wallet validation testing and production account processing
- Complete required production audits, which may occasionally entail travel and/or validations during evenings, weekends, and holidays
- Partner with Marketing and other business teams (including SME) to ensure processes are compliant and manage process improvements for development processes to increase quality of testing and decrease defects
- Identify, analyze, and mitigate potential risks and controls for the development and/or upgrade of existing or new applications and APIs
- Tasked with creating and updating documentation for projects on business applications
- Work as a liaison between business, marketing, and IT to review and prioritize the backlog of requests.
Business Systems Consultant
Wells Fargo (via TEK Systems)
04.2013 - 04.2014
- Worked within Card Services supporting technology activities for process automation and operational efficiency of the Disputes Automation System (DASH)
- Led requirement discovery sessions to gather and interpret business rules and define functional requirements utilizing PowerPoint presentations
- Assist in documenting requirements in a clear and concise manner providing accurate information on behalf of the business partners for the team of developers to allow for high quality application implementations
- Responsibilities include being a lead in full test lifecycle tasks including gathering test data (i.e
- Customer data) utilizing SQL queries and SAS, test scripting and execution for UAT, Regression, and SIT utilizing ALM extensively
- Partnered with Disputes, Developers and Technology Project Management organizations to ensure processes are compliant and manage process and application improvements, including APIs for development processes for increasing quality and decreasing defects
- Worked as an administrator of Oracle and Workday Financials creating user profiles and updating employee data.
Technical Administrator
FBL Financial Group
11.2012 - 02.2013
- Work with business units to implement, integrate and administer document management solutions using IBM FileNet products (P8 4.x)
- Administer IBM FileNet P8 Image and Content Management services including OnDemand, Business Process Management (BPM), Content Based Retrieval (CBR), Data Capture/Scanning, and Rendition Engine
- Lead on a project to roll out CMOD (Content Management OnDemand) including Systems Integration and User Acceptance testing as well as creating user documentation
- Oversee the daily operation of imaging services including batch processing, performance, monitoring, changes, additions and/or deletions of documents and classes
- Maintain Windows server and WebSphere environment for FileNet and Content Management systems.
Financial Applications Administrator/ Business Analyst
Ruan Transportation
07.2001 - 10.2012
- Functioned as lead business analyst and project manager to integrate TMW software with the Pegasus Transflo imaging application to create paperless billing solutions
- Managed many phases of the project including System Integration and User Acceptance Testing before final rollout
- Functioned as business analyst for financial (A/P, A/R, G/L, and Fixed Assets) and imaging applications
- Functioned as lead systems analyst and project manager on multiple projects to create imaging solutions for Accounts Receivable, Logistics, Contract Admin, and the Employee Hiring/Human Resources group
- Utilized Agile and Waterfall software development methods during the initial planning stages
- Maintained system interfaces, system utilization, documentation, database, and application backups
- Functioned as a system administrator including security, technical, and end-user support for several applications specializing in financial applications, imaging, and reporting repositories.
Education
Bachelor of Science - Computer Science
Simpson College
Indianola, IA05.2007
Skills
- Release Planning
- Process Mapping
- User Acceptance Testing
- Project Management
- Project Planning
- SQL
- SAS
- VBnet
- C
- C Sharp
- Java
- HTML/XML
- FDR( M & C Cycles)
- XPM
- Quality Center/ALM
- Selenium
- Atlassian JIRA
- DevOps
- Power BI
- SVP
- CIV
- OSMP
- Provenir Decisioning
- Compass
- DIBS
- PAC2000
- PASS
- Service Request
- ClearQuest
- CA Clarity
- STAMP
- DASH
- CSS
- FDR Query Tool
- APE
- Hogan
- CIS
- Snag-it
- MS Office Suite
- MS Visio
- MS Project
- MS PowerPoint
- Magic Help Desk software
- Standard Register (A/P checks)
- Visual Studio
- SAP Crystal Reports
- EDI
- Microsoft SharePoint
- ADP Enterprise HRMS
- Deposit Pro
- Laser Pro
- Finastra
- Traverse (Accounting Software)
- Computron (Accounting Software)
- AxsPoint Central (Document Storage)
- Pegasus Transflo (Imaging) Suite
- TMW Suite
- Adobe Acrobat
- Microsoft Access
- SQL Server Management Studio
- Oracle Financials
- Workday Financials
- Salesforce
- SQL Server and the SSIS component
- Oracle
- DB2 UDB 82
- Erwin 41/82
- Microsoft Windows Server 2008, 2012, 2016, 2019
- Microsoft Windows Desktop 10,11, 365
- Windows Terminal Server
- VMware
- VSphere
- UNIX AIX
- Quality Control
- SQL Proficiency
- Gap analysis
- Data Analysis
- Application support
- Business Development
- Business Documentation
- Cybersecurity
- Cloud Computing
- Business Intelligence
- Information Security
- System Testing
- Quality Assurance
City
Indianola
Zip
50266
Educationinstitution
Simpson College
Methodologies
- Agile
- Waterfall
- ITIL
Timeline
Sr. Business Systems Analyst
Dupaco Community Credit Union
10.2023 - 02.2024
Business Systems Analyst
T-Mobile (via TEK Systems)
05.2022 - 01.2023
Sr. Business QA Analyst
Wells Fargo & Co.
11.2019 - 12.2021
Business Systems Analyst
Wells Fargo & Co.
04.2014 - 11.2019
Business Systems Consultant
Wells Fargo (via TEK Systems)
04.2013 - 04.2014
Technical Administrator
FBL Financial Group
11.2012 - 02.2013
Financial Applications Administrator/ Business Analyst
Ruan Transportation
07.2001 - 10.2012
Bachelor of Science - Computer Science
Simpson College
Similar Profiles
Cydney PorterCydney Porter
Assistant Vice President, Branch Manager at Dupaco Community Credit UnionAssistant Vice President, Branch Manager at Dupaco Community Credit Union
Jennifer SernaJennifer Serna
Member Service Representative at Dupaco Community Credit UnionMember Service Representative at Dupaco Community Credit Union
Amy MeyerAmy Meyer
Lending Consultant/Operations Assistant at Dupaco Community Credit UnionLending Consultant/Operations Assistant at Dupaco Community Credit Union