Brian Olmstead Email & Phone Number

Englewood, Colorado, Us

Projects: Test Automation of Desktop Apps, Websites, APIs and DatabasesThe main functionality I worked on the automation for the Field Service Management suite of applications. This included automated tests written using Selenium, RestSharp and our custom C# framework, which covered all aspects of our product: Web, Desktop Windows apps, API testing, and Oracle database validations.Responsibilities:Wrote automated tests based on user stories from QA teamWrote and executed complex SQL queries to validate user storiesWrote automation suite in C#/.Net for services and database testingWrote automation suite in T-SQL to test automated core loads of dataUsed Postman to test web services using JSONAdministered Jenkins setup for AutomationEnvironment: Test Automation, C#/.Net, Oracle SQL, Web Services/APIs, XML, JSON, JIRA, Jenkins

Denver, Colorado, Us

Projects: Fusion services, Master Data Management teamsThe main functionality I worked on involved a set of web services that would feed data into our data warehouses in a real-time manner, allowing for immediate updating on our website. I also worked on the data teams that enhanced our data processing functionality.Responsibilities:* Wrote and executed complex SQL queries to validate user stories* Wrote automation suite in C#/.Net for services and database testing* Wrote automation suite in T-SQL to test automated core loads of data* Used Postman to test web services using JSON* Involved in Agile sprint user story sizing, grooming and planning* Wrote test cases based on user storiesEnvironment: T-SQL/MS SQL, C#/.Net, XML, JSON, TFS, JIRA, Automation

Us

Project: HROne IntSys Integration The main objective of this project is integrate multiple HR systems and share data seamlessly between them. Responsibilities:* Lead 3-person QA team through full testing cycle of project* Wrote and executed complex SQL queries to validate project requirements* Involved in Rally sprint planning* Involved in writing test cases based on user stories* Used WCFStorm to test web services* Managed UAT testing interactions and recording of test resultsEnvironment: MS SQL, C#, XML, Rally/Agile, WCFStorm, Taleo, Lawson, HealthStream, SharePoint

Minneapolis, Minnesota, Us

Project: Velocity POS RolloutThe main objective of this project is to rollout a new POS system for all Regis salons that will help to retain stylists, build customer loyalty and transform the way Regis does business in over 7000 salons.Responsibilities:* Negotiated QA team priorities and commitments* Developed close relationships with Dev, BA, BUAT and PM teams to meet overall project commitments* Worked closely with Dev team to meet delivery deadlines* Refined defect tracking process in TFS* With Dev Lead, developed and refined build/release schedule* Participated in QA team member annual reviewsEnvironment: TFS, XML, MySQL, 3rd Party POS Software

Us

Project: Clinical Reporting Platform data warehouseThe main objective of this project is to build a central data warehouse to use for reporting within the larger organization. This was to be done over several releases and included a conversion from Oracle platform to Teradata. Responsibilities:* Analyzed user requirements for testability* Involved in prioritization of testable requirements* Involved in writing test scenarios based on user requirements* Involved in writing SQL to validate test scenarios* Executed test scenarios by manually running SQL scripts and recording results in QC* Participated in defect triage meetings* Participated in TeraData training* Converted Oracle test scripts into TeraData test scriptsEnvironment: Quality Center, Oracle, TOAD, SharePoint

Us

Project: Clinical Reporting Platform data warehouseThe main objective of this project is to build a central data warehouse to use for reporting within the larger organization. This was to be done over several releases and included a conversion from Oracle platform to Teradata. Responsibilities:* Analyzed user requirements for testability* Involved in prioritization of testable requirements* Involved in writing test scenarios based on user requirements* Involved in writing SQL to validate test scenarios* Executed test scenarios by manually running SQL scripts and recording results in QC* Participated in defect triage meetings* Participated in TeraData training* Converted Oracle test scripts into TeraData test scriptsEnvironment: Quality Center, Oracle, TOAD, SharePoint

Minneapolis, Mn, Us

Project: Payment Processing applicationThe main objective was to rewrite the front-end client app for processing of payments within the Syncada financial network. This project included both front-end testing and back-end MS SQL testing. Responsibilities:* Participated in daily stand-up project meetings* Wrote test scenarios based on project requirements* Wrote MS SQL scripts to be used in executing back-end test scenarios* Manually tested front-end application using written test scenario steps* Managed defect spreadsheet on SharePoint for the team; worked with QA Lead with sheet design* Wrote several data populating scripts for QA team to useEnvironment: MS SQL, SharePoint

Us

Project: Premium Designation 5.0 data warehouse rebuildThe main objective of this project was to completely rewrite the data warehouse used for Premium Designation.Responsibilities:* Led 12-person team including mix of Client QA, Consultant QA and borrowed BA/Dev resources* Coordinated closely with Client QA Manager on resourcing and task assignments* Represented QA team in all larger project meetings* Wrote MS SQL stored procedures to be used with pre-existing test automation framework* Reviewed stored proc test results after executions for defects* Managed my own defects in Quality Center from entry through closure* Facilitated defect meetings with larger team to track defects through resolution* Managed three QA resources whose primary goal was QTP automation of front-end client* Mentored Consultant QA resources in QA processes and SQL writingEnvironment: MS SQL, Quality Center, QuickTestPro, SharePoint

Minneapolis, Mn, Us

Projects: Regression Test Execution for existing client app; Localization of existing client-side applicationThe main objective was to allow for Kanji character set to be used in existing client-side application. There was also a 2-month window where there was a large regression test initiative for the client-side application.Responsibilities:* Executed existing test scenarios for regression test project* Wrote test scenarios to specifically test Japanese Kanji character set in client application* Participated in Agile daily stand-ups and sprintsEnvironment: SoapUI, Client-Server, Agile

Eden Prairie, Minnesota, Us

Project: Manage, Convert and Execute existing regression test suite for new product roll-outThe main objective of this project was to take LTCG's existing regression suite which was built up over several years, and identify scenarios to execute for the current product roll-out. Responsibilities:* Managed an offshore test team in all testing efforts* Led daily off-time meetings with the offshore team to manage daily assignments and issues* Reviewed all work performed by test team for quality and consistency* Communicated progress and results to project sponsorsEnvironment: Quality Center, SharePoint, Team Foundation Server

New York, Ny, Us

Major Clients: Ford, Marines, FEMAMy time at RMG Connect was spent in a small QA team where we would often have multiple assignments and projects, prioritizing our time to meet current project objectives. Responsibilities:* Administrator for PVCS Tracker, defect tracking tool* Prioritized time while often working on multiple projects* Wrote test plans for all major projects* Wrote test scripts to test requirements* Conducted browser compatibility testing* Conducted 508 web accessibility testing for government client sitesEnvironment: Web-Testing, PVCS Tracker, SQL

Project: Oracle to MySQL database conversionThe main objective of this project was to test the conversion of the company’s main databases from Oracle to MySQL. Responsibilities:* Wrote test scenarios to test database conversion from Oracle to MySQL* Wrote SQL scripts to execute test scenarios* Executed SQL scripts in Oracle and MySQL environments for comparison testing* Reported defects and tracked them through resolutionEnvironment: MySQL, Oracle

Minnetonka, Minnesota, Us

Project: Ongoing Techies.com updatesMy primary role at techies.com was to support ongoing updates to the techies.com web platform. Responsibilities:* Wrote test scenarios to test techies.com web site features based on requirements* Executed test scenarios Environment: SQL, Web-Based