Manager Test Cases

Location:

McKinney, TX

Posted:

August 06, 2018

Contact this candidate

Resume:

Greg E. Muller

***** ******** **** **: 214-***-****

McKinney, TX 75071 Email: ***********@*******.***

Objective

Seeking a position as a Software Quality Assurance Tester, utilizing my expertise and experience in software testing and data analysis.

Summary Highlights

15+ years in software testing and data analysis as a Software Quality Analyst

Experienced in both Waterfall and Agile software development release cycles (SDLC)

8 years testing Java Web applications

4 years testing iOS Mobile applications

6 years creating SQL queries using MS SQL, Oracle and Teradata databases.

6 years designing Business Objects queries and testing BOBJ universe development.

Automation experience using Katalon Studio framework

Experienced in working with Data Warehouses and ETL projects

Experienced in testing software for compatibility on different platforms, operating systems, browsers, etc.

Expert with HP Application Lifecycle Management (ALM) (aka: Quality Center)

Self-starter and team player with excellent analytical skills used to troubleshoot issues. An eye for detail and accuracy in documenting testing procedures, data analysis and discovery of defects

Written test plans and test cases to exercise program / report functionality based on analysis and understanding of the requirements, functional specifications and technical integration design documents

Work Experience

Frito-Lay Headquarters - 7701 Legacy Dr, Plano, TX 75024-4002 (8 years, 5 months)

Analytics Reporting Test Analyst (Mar 2017 to Dec 2017 = 10 months)

Transitioned to the Analytics and Reporting team. My role was to take over many of the sustainment tasks in order to free up others to concentrate on development. Data was brought into our SQL Server databases via DTSX packages from other data repositories. From our databases we would then apply business rules and aggregate the data at the needed dimensions for each subject matter. The final reporting tables were then pushed out to dedicated reporting servers. Excel VB Models would then display the data by executing dynamic stored procedures.

Performed code and data analysis on SQL Servers using SSMS (SQL Server Management Studio)

Modified SQL code inside Job steps of SQL Server Agent Jobs, stored procedures and views

Manually started SQL (Agent) unscheduled Jobs to push data to our reporting servers

Created DTSX packages to load data (ETL process) into our tables from flat files or from other tables

Executed DTSX packages using Microsoft Execute Package Utility, SSIS (SQL Server Integration Services)

Sustainment and Technical Support Analyst (Jan 2015 to Feb 2017 = 2 years, 2 months)

Transitioned to the Sustainment and Support team.

Supported users of our Reporting Tools, which provided critical sales, service, payroll and expense analysis.

Provided support and mentoring to our group of business iOS iPad and iPhone application testers.

Provided Level 2 technical support for production Java Web applications and iOS mobile applications

Used HP Service manager to report, track and resolve production issues

Business User Acceptance Tester (Aug 2009 to Dec 2014 = 5 years, 5 months)

Tested numerous internally developed iOS mobile applications used by field users of iPads and iPhones

Lead Tester on the development and maintenance of Business Object Universes

Created SAP Business Objects queries and SQL queries used to validate data displayed in our applications against our sales data warehouse and other database repositories.

Lead QA resource for testing our flagship Enterprise Java Web application used by our frontline sales team leaders.

Developed Web application automation scripts in Katalon Studio for regression, to ensure existing functionality during maintenance releases

Tested IdM (Identity Manager) for SSO (Single Sign-on) access based on role and approved application access

Used HP Application Lifecycle Management (Quality Center) to write business user acceptance test cases and to report and track defects

Used Sharepoint as a collaboration tool for storing all project documentation

BlueCross BlueShield - 1201 Campbell Road, Richardson, TX 75081

Data Warehouse Testing Analyst (Oct 2006 to Aug 2009 = 2 years, 10 months)

Project Description:

Our project supported the client reporting needs for IL,NM and TX state accounts by pulling data from our Teradata EDW (Enterprise Data Warehouse) into our own set of tables, creating extracts of that data, and sending the data to 2 vendors. The vendors input the data using their own proprietary process to produce reports for all of our accounts in those states. Also worked on projects that loaded data into the EDW.

Worked closely with solutions definition team to identify missing or incomplete requirements

Wrote SQL scripts based on ETL (Extract, Transform, and Load) mapping rules to test target tables

Data Conversion testing was accomplished by transforming the data so that it could be loaded into our EDW data model.

The tables that we (in SQA) populated using our code would be compared to the developer’s table.

Source to target testing was accomplished by comparing each column in every row

Discrepancies in the comparisons between the contents of fields in each table would be researched and resolved

Discrepancies in row counts between each table would be researched and resolved

Used Teradata SQL Assistant to write and execute SQL code

Created Test Cases, Test Scripts and Test Plans

PepsiCo - 5600 Headquarters Dr. Plano, TX 75024 (Ph: 972-***-****)

Software QA tester (Sept. 2004 to Aug 2006 = 1 year, 11 months)

Project Description:

Worked in the PepsiCo Business Solutions Group (PBSG), doing SQA for the development of an Enterprise Transportation Management System (ETMS). This Enterprise Application Integration (EAI) project focused on the supply chain side and the solution involved the integration of various applications, incorporating a number of in-house and commercial off-the-shelf (COTS) tool solutions for the purpose of optimizing and executing orders from different divisions of PepsiCo at an enterprise level.

Testing procedures:

Wrote test scripts from Requirement, High level Design and Change Request documents

Creation of test data using legacy systems in a test environment to exercise test conditions

Validate order data mapping from source systems (COBOL copybook) into central system

Validate using SQL queries the transformation of data within ETMS database. (Business logic)

Verify data transmission (XML feeds in both directions along with API calls) into destination system databases.

Validate new, update and cancel transactions.

Validation of the flow of data through the graphs within the Ab Initio GUI to validate the business and system logic.

Validate using the business client software for expected behavior after transmitting the transformed data to destination systems (I2 TM – Transportation Manager (COTS))

Validate results after executing end to end business scenarios using all the interface GUI applications

Tools used.

Ab Initio (like Informatica only more robust) – An ETL (Extract, Transform, and Load) graphical development tool used for extracting data from outside sources, transforming it to fit business needs, and loading it into our ETMS database. Private sandboxes were used on a UNIX box to test code in isolated environments.

Benthic software’s Golden32 - used to query Oracle databases for data validation.

Telnet or Reflection for UNIX client - used to communicate with Unix HPUX RAID server box. Also “vi” editor.

Reflection FTP client – used to transfer test data files from one server to another.

Quality Center 8.2 (Mercury -TestDirector) – used for defect tracking and test case management.

United Healthcare - Student Resources - 2301 West Plano Parkway, Suite 300. Plano TX 75075 (Ph : 469-***-****)

Software QA Tester (Sept. 2002 to Dec. 2003 = 1 year, 3 months)

Tested various client / server VB applications using MTS components interfacing with SQL Servers, that provided the business with support to store client and insured information, create bids and policies, receive premiums, process refunds and track the financial accounting of the business.

Tested various Web Applications (HTTPS, ASP, IIS) that provided students with the ability of online insurance enrollment at www.student-resources.net/ and to manage their own health data and interact via secure messaging with their campus student health center.

Lead Test Engineer on one of the Web site projects responsible for finalizing requirement specifications, test plan and test case development, team assignments, coordination of defect tracking and generating project status reports.

Ran SQL queries using Query Analyzer and MS Access on SQL 2002 database servers to validate new code releases.

Recorded Vuser automated test scripts for Load / Stress testing using Mercury's LoadRunner 7.51 on Web sites.

Gathered LoadRunner metrics for benchmarking against subsequent revisions of code.

Recorded automated test scripts for functional testing using Mercury's WinRunner on Web sites and VB applications.

Responsible for the administration of a defect tracking tool called Test Director 7.6.

Analyzed Business Requirement and Technical Design docs. in order to create test plans and manual test cases.

Executed test cases, followed through with issue resolution and recorded results.

Macromedia - 1500 N. Greenville Ave., Suite 500, Richardson, TX 75081 (Ph: 972-***-****)

Software Test Engineer/ Designer (Dec. 2000 to Feb. 2002 = 1 year, 3 months)

Worked on a team responsible for the development of a graphical illustration program called FreeHand

Designed feature requirement specifications detailing new features

Wrote and executed test plans used to uncover errors in the software

Responsible for feature integration testing and then a demo of the feature during the handoff meeting

Used a database program called FileMaker for bug tracking.

Used a web site creation tool called Dreamweaver for designing and posting feature specifications and their corresponding test plan documents in HTML format linked to an intranet website

Used a bitmap editor called Fireworks to create mockups of user interface additions and changes

Verified that the software under development, worked on both Macintosh (OS 9 & 10) and Windows Platforms (98,ME, 2000 and XP).

Maintained clean computer environments of all required operating systems using a utility called Ghost

Monitored and responded to issues on our customer news group forum

Micrografx (became part of Corel) - 8144 Walnut Hill Ln., Suite 1050, Dallas, TX 75231 (9 years, 6 months)

Product Lead Software Test Engineer (Jan.1994 to Jun. 2000 = 7 years, 6 months)

Supervised a QA team during multiple releases of a graphical illustration program called “Micrografx Designer”

Reviewed functional specifications to determine test requirements for new features

Wrote test cases used to discover and eliminate errors in graphics software

Defined scope of testing effort to justify resources needed to ensure coverage

Coordinated workflow via Lotus Notes databases by assigning test cases, features and problem reports

Produced reports documenting the test cycle efforts

Implemented testing methods for product coverage and assigned tasks

Analyzed team members test results and helped guide them in their research efforts

Conducted bug scrubs and defined the scope of the regression testing effort

Reported project status to Development Manager and Director of QA

Researched or delegated escalated technical support issues

Quality Assurance Test Engineer (Jan.1992 to Jan. 1994 = 2 years)

Wrote and executed test cases to ensure the quality of various vector graphics and image editing software

Used PowerQuest Drive Image to maintain clean installations of OS’s.

Reported issues from beta software users via Lotus Notes databases

Provided technical support & resolved customer escalations

Education

Graduate of Stephen F. Austin State University, with a B.B.A in Computer Data Processing

Work Environments

Applications / Tools

SQL Server Management Studio (SSMS), MS Visual Studio. SQL Server Integration Services (SSIS), Quality Center (HP Application Lifecycle management), SAP Business Objects, DbVisualizer, Teradata SQL Assistant, Microsoft Office Suite, Ab Initio, HP Service Manager, Sharepoint, Katalon Studio, Skype.

Languages

COBOL, SQL, VB, HTML, XML, Java

Operating Systems

Windows, iOS, UNIX, AS400

Databases

MS SQL, Oracle, Teradata, DB2

References

Name

Title - Company

Phone

Prakash Jain

Business Innovation Manager – Frito-Lay