Sql Server Business Analyst

Fred Zimmerman

**** *. ******** ****, **********, VA 22311

770-***-**** *************.*********@*****.*** LinkedIn

Summary

QA professional with many years of experience in functional and UI testing for web and mobile platforms. Expertise in designing test cases, executing tests, and using SQL for data validation. Proven ability to collaborate in agile environments and enhance QA processes to ensure high-quality releases. Demonstrated success in end-to-end testing and defect resolution on large-scale and enterprise projects.

Skills

•Core Tools & Technologies: Kubernetes, Minikube, Docker, Rancher Desktop, Insomnia, JMeter, Postman, Playwright, jFrog, Azure DevOps, GitHub Workflows, JIRA, Microsoft Playwright (Typescript, C#), Cucumber, NodeJS, Allure Report, VS Code, Azure Pipelines, YAML, Azure Git, Azure Test Plans, Selenium WebDriver, Visual Studio .NET Enterprise 2022, .NET Framework 4.5,

.NET Core 6, Specflow, Telerik/Progress Test Studio, Swagger, Java Selenium, Eclipse, Jenkins, Microsoft Dynamics, Appium, BDD, SpecFlow, NUnit, SQL Server 2017, Oracle 12c, VMWare, SoapUI, Restlet, Groovy (script), Rally, TFS, Git, SaFE Agile, Scrum, VSTS, PractiTest, Powershell, SQL Server 2016, Visual Studio.NET, MSTest, Visual Studio 2015, SQL Server 2012, BlazeMeter, JAWS

•QA Methodologies: Functional Testing, UI Testing, Test Case Management Tools

•Professional Competencies: SQL Proficiency, Analytical Thinking

Work Experience

Medix Technology (End client: Optum Serve) Mar 2025 - Jul 2025

Product Analyst/SDET

Collaborated in R&D projects for the federal medical information system, contributing to functional testing and proof-of-concept developments.

•Facilitated refinement and scrum ceremonies, contributing to the creation of software artifacts and DevOps workflows while ensuring adherence to QA methodologies.

•Partnered with the lead software engineer, scrum master, and product owner to design and execute test scenarios for UI and REST API validations using Playwright .NET.

•Conducted performance and load testing with JMeter and an in-house enterprise performance platform to support regression and functional test cycles.

•Utilized containerized .NET/Angular/Postgres framework to execute web-based front-end and back-end tests, reinforcing test case management principles with Azure DevOps and JIRA.

Randstad Digital (End clients: College Foundation Inc./CFI, North Carolina State Education Aug 2024 - Feb 2025

Assistance Authority/NCSEAA)

Lead SDET/Business Analyst (support)

Directed the re-write of a legacy cloud web application by designing and executing functional test cases for web UI testing across user stories in a fast-paced agile environment.

•Led a QA and test automation team, developing web test automation frameworks and managing test case execution from planning through regression phases.

•Supported business analysis efforts by gathering and documenting requirements that influenced the design of test cases and the defect lifecycle management process.

•Mentored junior test automation engineers in leveraging tools like Playwright and Postman for developing robust tests, enhancing UI testing and functional testing capabilities.

•Reported test process progress in daily stand-ups and periodic client meetings, ensuring alignment of testing activities with agile methodologies and QA standards.

Owens & Minor Jul 2020 - Jan 2024

Lead SDET/Business Analyst (support)

QSight medical inventory and billing management cloud web application.

•Elicited application feature requirements for testing and verification purposes. Extensive information gathering and stakeholder interviews (organizational customer support staff, developers, BA's).

•Web application testing automation framework: ground-up design and creation of web testing automation framework and ongoing maintenance of the framework.

•Test automation framework conversion: converted Selenium automation framework to Microsoft Playwright.

•API microservice: test suite created (Postman) from Swagger API requirement documentation.

•CI/CD: Created multiple Azure Devops pipelines for different automation test suites. Included email notification functionality to notify team members of pipeline suite execution completion and results.

•Testing Performed: Manual/exploratory, regression, system integration, compatibility, smoke, user acceptance, API, load testing.

•Tools: Office 365, Selenium WebDriver, Microsoft Playwright, C#, Visual Studio .NET Enterprise 2022, .NET Framework 4.5, .NET Core 6, Specflow, Microsoft Azure DevOps, Azure pipelines, Azure Git, Azure Test Plans, Telerik/Progress Test Studio, Postman, Swagger

Accelered (formerly Univ. of Maryland Global College, UMGC) Oct 2019 - Mar 2020

Lead SDET/Business Analyst (support)

Cloud-based Web application for student registration, financial transactions and matriculation data collection.

•Elicited application feature requirements for testing and verification purposes. Extensive information gathering and stakeholder interviews.

•Lead test automation engineer: On-shore QA group.

•Agile Scrum Daily standups: Meetings daily with remote off-shore staff in different timezone on deliverables.

•User Acceptance Testing: Designed and created user acceptance tests (automated/manual).

•System Integration Testing: Designed and created SIT tests (automated/manual).

•Performance/Load Testing: performed extensive performance and load tests against the base application with reporting of metadata metrics relevant to team on application stress performance.

•REST API services Testing: Performed back-end microservice testing with Postman.

•Mobile Platform Testing: Tested mobile platform for application.

•Mentoring: of junior test engineers through knowledge transfer sessions and brown bag lunch tech sessions on test artifacts under development and test methodology being performed.

•Tools: Java Selenium, Cucumber, JMeter, Eclipse, Postman, Microsoft Azure DevOps, Jenkins, Microsoft Dynamics, Swagger, Appium.

CVS Health (formerly Aetna Healthcare) Oct 2018 - Oct 2019

Lead SDET/Business Analysist (support)

Cloud-based web application/portal: for healthcare wellness and third party medical and wellness information.

•Elicited application feature requirements for testing and verification purposes. Extensive information gathering and stakeholder interviews

•Cross-team collaboration and requirements gathering: worked extensively with beta test group and developers for refining test and feature requirements. Functional specification and documentation involved.

•REST API services test automation framework: Designed and developed framework.

•Data testing: Tested data processed by and generated through the application. Data loading and scrubbing involved. Extensive verification of API services feeding that data and database code artifacts at the back-end (Oracle 11i).

•User Acceptance Testing: designed and wrote user stories for UAT test cases and suite and subsequently coded the automation scripts or manual test plans to execute those cases.

•Tools: C#, Selenium WebDriver, BDD, SpecFlow, NUnit, SQL Server 2017, Oracle 12c, VMWare, SoapUI, Postman, Restlet, Groovy (script), Rally, TFS, Git. SaFE agile, scrum.

GMAC Apr 2018 - Oct 2018

Lead SDET/Business Analysist (support)

MBA.com and GMAC.com informational websites for prospective graduate business school students.

•Elicited application feature requirements for testing and verification purposes. Extensive information gathering and stakeholder interviews

•Cross-team collaboration and requirements gathering: worked extensively with developers and organizational BA's for refining test and feature requirements. Functional specification and documentation involved.

•API testing: Microservice layer test automation framework designed and developed.

•Mobile device functional testing: Tested mobile platform for application.

•Scrum/Agile: Worked with multi-vendor team both on-site locally and remote teams involved in business analysis, UX/UI and development.

•Tools: Postman, VSTS, PractiTest, Selenium WebDriver, NUnit, C#, Azure.

Fulcrum IT Jul 2017 - Mar 2018

SDET/Business Analysist (support)

K12 national student assessment exam application (science, math, English) for Google Chromebook tablets. Application loaded on each device, with results uploaded to central data server via secure wifi network.

•Department of Education (NAEP) contract – https://nces.ed.gov/nationsreportcard.

•Elicited application feature requirements for testing and verification purposes. On-site educator forums involved for requirements gathering along with national educational standards documents and documentation specific to this national test.

•Web test automation framework: re-design in collaboration with test automation teammates. Extensive re-work of test automation script design patterns and code architecture.

•High volume automation test suite: over 2,000 automated test cases written for the application with reviews of each test case and workflow prior to implementation.

•Process and versioning automation: utilized Powershell CLI scripts for automating loading of the application updates, and deploying web test automation framework artifacts to tablet devices for test automation and manual testing iterations.

•Test automation script code review sessions: lead peer code review sessions for web test automation script code.

•Continuous Learning Environment: with extensive and frequent test automation knowledge assimilation and transfer sessions on weekly basis.

•Tools: Selenium WebDriver, C#, NUnit, Visual Studio.NET, Powershell, SQL Server 2017, AppliTools, BDD.

Federal Reserve Board Jan 2017 - Jul 2017

SDET/Business Analysist (support)

Federal Reserve Bank file and data transfer cloud-based web application.

•Elicited application feature requirements for testing and verification purposes. Worked closely with long-time developers and BA's to get organization data and metadata relevant to the application, data, and features published via the portal.

•Daily stand-up meetings: with developers, BA's, DBA's and project manager. Requirements were often hashed out in these meetings, along with progress, impediments and so forth.

•User Story development: through requirements gathering information, wrote user stories to cover user acceptance tests, system integration tests, smoke tests, and regression tests for our automation suite and manual test cases.

•Automation test framework: ground-up design and creation of Selenium Webdriver web test automation framework.

•Data validation testing: extensive data validation of data pre-transfer and post transfer of data to ensure correctness and accuracy of transfers. Working within a very strict secure network/cloud environment.

•Mentoring/Training: of recent college graduate intern at FRB. Teaching her Selenium WebDriver, C# and testing process and methodologies, testing types and scrum/agile process implemented in this environment.

•Tools: Selenium WebDriver, MSTest, TFS, Visual Studio 2015, SQL Server 2016, C#, Javascript, Angular, Scrum/Kanban

The John F. Kennedy Center for the Performing Arts Oct 2015 - Jan 2017

SDET/Business Analysist (support)

The Kennedy Center public website and ticketing application. www.kennedy-center.org

•Business Analysis: There was no dedicated BA working in the very small KCPA IT staff (under 25 people). I helped implement: process and procedures for requirements gathering; epics and user stories for feature development and testing; and refinement and maintenance of application feature requirements and service level requirements for the website and ticketing application.

•Web test automation: Designed, created, and refined the web test automation framework used to test the user interface of the application.

•Data validation testing: extensive data validation of general user workflows within the website UI as well as the ticket purchasing process/workflow. Database scripts (SQL) written against the test environment database behind the application to verify data.

•508 Certification Testing: for website handicap access per general standards and guidelines for such. Some testing done manually, and some automated via tools scripts and batch processes.

•API Testing: tested website microservices API with Postman.

•Performance/Load Testing: Extensive performance and load testing of the application under high variance user loads. Collective extensive metadata to match required service levels as per organizational standards and website traffic patterns.

•Extensive status reporting meetings: with CIO, Lead Architect, Project Manager and various managerial stakeholders throughout different departments at the organization.

•Daily stand-up meetings: with project manager architect and developers. Agile scrum process.

•Tools: Ranorex Studio, Selenium WebDriver, C#, MySQL, Protractor, HP UFT, SQL Server 2012, JMeter, BlazeMeter, Postman, JAWS, Powershell.

Education

University of Connecticut

2007

B.A., Business Administration

University of Georgia, Athens

2007 - 2009

M.Ed, Instructional Technology

•GPA: 3.7

Harvard University Extension

• Coursework: computer science, computer architecture, higher mathematics, software engineering

Certifications

•MCP -70-444: Optimizing and Maintaining a Database Administration Solution Using Microsoft® SQL Server™ 2005

•CompTIA Security+: (Both 2010)

•(In-Progress / Online) Google Cybersecurity Certification through Coursera

Contact this candidate