John Crunk PhD ABD
Dallas, GA 30132 ******@*******.***
EDUCATION
Doctorate of Business and Information Technology enrolled
Capella University Minneapolis, Minnesota
Master of Information Technology 2006
American InterContinental University Hoffman Estates, IL
Bachelor of Science Computer Information Systems 1998
Devry Institute of Technology Decatur, GA
COURSE DEVELOPMENT AND TEACHING
Crunk Technical Services, Dallas, Georgia 2009
Advanced Performance Testing
• Taught people advanced concepts in performance testing.
• Class concentration was on Windows Services, AJAX, and Winsock protocols
• Created materials and samples for the class
• Assigned activities that were done in the class to allow students the opportunity to grasp concepts
Beginning Performance Testing
• Taught people beginning concepts in performance testing.
• Created materials and samples for the class
• Assigned activities that were done in the class to allow students the opportunity to grasp concepts
Beginning Test Automation Frameworks
• Class that teaches all QA individuals the ability to automate applications without knowing a
scripting language
• Created materials and samples for the class
Advanced Test Automation Frameworks
• Extends on the Beginning class to teach advanced techniques in frameworks and
implementations of new extensions of the framework.
• Created materials and samples for the class
Assigned activities that were done in the class to allow students the opportunity to grasp concepts
•
Goldleaf Financial Services, Norcross, Georgia 2009
• Taught 15 people training course on the use of testing framework for use in the organization.
• Created FAQ and discussion web site for the purpose of answering questions and facilitating
discussion of the framework.
Yahoo!, Atlanta, Georgia 2006
• Designed two week training classes specific to Yahoo needs for automation framework to teach
testing team locally and in satellite offices.
• Conducted two week training classes for testing teams helping them to become more proficient or
learn test automation.
ADP, Alpharetta, Georgia 2004
• Designed two week training class for the purpose of teaching the testing team automation using test
framework.
Conducted training class that successfully allowed users of the tool to automate applications with
•
100% feedback.
Novel 2002
• Designed online training class for the training of testing team in the use of test framework using
Netmeeting and other tools as visual aids along with conference lines for voice interaction.
• Facilitated training class for one week session online for people in U.S. and India with 100% success
in teaching them the use of the tool.
Instructional Materials: Included in all courses given above
Online Course Personal Experience
• W ebCT, American InterContinental, Masters in Information Technology
• Blackboard, Capella University, PhD in Business
• WebEX, Crunk Technical Services
WORK EXPERIENCE
Consultant 6/2000 – 2/2009
Crunk Technical Services Dallas, GA
Additional Information
Beta Tester for Loadrunner 9.5
•
Technical Environment
.Net, AS 400, ASP, BEA Weblogic, C, C#, C++, DB2, Frameworks, HP/UX, J2EE, Java, Javascript, Linux, Loadrunner, Lotus
Notes, MS SQL, MySQL, Oracle, Portals, Portlets, QALoad, Quicktest Pro, Rational Performance Tester, Rational Robot, SQL
Anywhere, Silk Test, Sitescope, Test Complete, Test Director, Toad, UNIX, VM Ware, Visual Basic, Windows, Windows 2000,
Windows 2008 Server, Windows Server, Windows XP, Windows Vista, Winrunner, Winsock, XML, XSL
Clients
GoldLeaf Financial
Developed tools for other testing analyst to use and conducted training on the use of the tools. Helped in the
analysis of performance test results to fix problems in the application. Developed executable requirements for
100% code coverage in test automation. Automated applications using Test Complete testing tool
Automated SDK Flatbed and SDK Feeder application using Test Complete scripts
•
Created generic libraries / extensions for use by other testers within test complete.
•
Used Test Complete to develop and implement Framework for test automation.
•
Did analysis of performance test to find problems in performance of application
•
Created executable requirements of framework so that 100% code coverage could be achieved.
•
Worked with developers to create all levels of testing activities.
•
Worked with management for reporting needs and created report for testing results.
•
Integrated automated testing in Agile testing methodologies.
•
HP/Affinity
Wrote and conducted performance test for Lotus Notes email database, the test included the creation of emails,
calendar entries, and sending invitations for appointments and repeating appointments.
Created VB Vuser Loadrunner test that stress tested the Lotus Notes environment
•
Implemented changes to help improve performance in the database
•
Analyzed result from performance test and monitors to provide feedback to the business.
•
Created reports for management personnel.
•
Tescom
Tescom was a contract where I worked on one of their clients sites, Rollins and GTA, to create performance test
for their software. This test were very high priority and important to them since it would be used at all their office
locations.
Created test plan to test Territory application
•
Used QALoad and Loadrunner for creation of test scripts.
•
Used Sitescope for monitoring of application and network traffic delays.
•
Planned and setup monitors for performance test runs
•
Trained and mentored testing analyst for script creation and execution.
•
Reported on results for test runs to stack holders.
•
Analyzed results and found bottlenecks and solutions for problem areas.
•
Created performance test for GTA web application.
•
Wells Fargo
While at Wells Fargo, I functioned as a testing analyst where I wrote scripts for many high priority financial
projects. Once the scripts were written, performance center or Loadrunner controller would be used to run the
scripts and monitors put in place to give additional information on the test results. After the test run, I would
produce results for the teams requesting the test and any other stakeholders in the project. I also assisted another
group in the writing and execution of QTP scripts
Provided help and assisted in testing of Triga project
•
Testing lead for high priority FDR project that is planned to take the place of TSYS in second quarter 08
•
Planned, tested, and executed performance test for 3cEntity project.
•
Used Sitescope for monitoring of application, database, and network traffic.
•
Worked on Lead Logistics and Megellan project which used both Winsock and HTML protocols.
•
Created performance test for COD Mail channel project.
•
Provided backup support to testing analyst for core project SP2EO
•
Worked on QTP script that did record insertion for Scenario Builder.
•
DHL Global Mail
The initial project for this position was to lead the software testing for the pilot release of a new project to handle
all mail that DHL Global Mail is responsible for. This volume accounts for approximately 15% of the world’s
mail and is expected to grow to 20% by project end.
Interviewed and hired team to assist in testing of the new applications that would be put in place.
•
Used Daughter Card for detection of network traffic delays.
•
Monitored traffic of network, application, and database using Sitescope.
•
Developed methodologies and processes that would be used by the testing team.
•
Train testing team on the use of testing methodologies and automation tools.
•
Train testing team on how to write test cases and test plans that will become the footprint for automation.
•
Developed Performance test for capacity of system using Loadrunner
•
Yahoo!
One of the purposes of my taking a position with Yahoo was for the work the work that I have done on
frameworks in the past on a project on Sourceforge. Yahoo is interested in developing tools that the manual testers
will be able to us to write automated test thus making them more efficient in their jobs. The testing tool they have
chosen for is TestComplete. TestComplete supports several languages including C++, C, Delphi, VBScript, and
Javascript.
Planned framework and testing tools for use in testing team.
•
Automate applications that have been tested manually be testing team
•
Train testing team on the use of automation tools.
•
Train testing team on how to write test cases and test plans that will become the footprint for automation.
•
Worked on Informatica application doing both performance and automated test.
•
Amdocs
One of Amdocs customers is RH Donnelley, I was brought on as the lead for the projects that we are doing for this
company. The main project being performance tested is the yellow pages project. We use Loadrunner for the
scripts and Site Scope to monitor the backend systems under test.
• Wrote scripts using Loadrunner performance testing tool.
• Collected information to determine the number of concurrent users that would be tested for the system
• Setup backend monitors for the purpose of producing reports on the various backend systems involved
including UNIX, BEA Weblogic, Windows NT Server, and Oracle databases.
Wrote queries to get data needed for the scripts that were to be run on the system.
•
Used Sitescope for monitoring of application, database, and network delays.
•
Evaluated results of the scripts and determined what was needing to be done to fix the problems.
•
Performance testing included in part Teradata information that was included in the application.
•
Park City Solutions
This was a contract position where I was charged with leading up the development effort for programming the
web site for Northern Arizona Healthcare. Some of the features that were included in this site were a discussion
board, faq pages, help pages, secure login, single signon, survey, and dynamic navigation based on security level.
Other responsibilities included but were not limited to enhancements requested by other clients and / or fixes to
defects in existing sites.
Used VBScript, ASP, XSL, XML and JavaScript technologies to develop web sites.
•
• Provided production support on sites for the purpose of loading data and migration of fixes.
• Designed new Informed Consent form for Shannon Medical Center.
• Developed Community Admin maintenance tool for Nebraska Methodist Hospital.
• Worked on hospital web site for Rush Copley Medical Center and St. Vincent’s Hospital
• Wrote ASP portal for Help Desk users to log in and emulate other users for trouble shooting of user
problems.
• Wrote Physician Merge process to merge duplicate physicians that occurred as a result of importing data.
• Used Sitescope for monitoring of application and network traffic.
• Developed load testing methodologies for the company to use for performance testing.
• Developed functional testing methodologies to be used by the company.
• Helped company select testing tools for automation and made recommendations on appropriate tools to use.
• Wrote documents to show how the company would save money through automation and performance testing.
JDA
As the subject matter expert in the area of performance testing, it was my responsibility to plan, write, and execute
winsock protocol performance test. It was discovered that the Loadrunner test would not be enough to accomplish
this, so for some of the test, Winrunner script were written and called from the Controller to test certain parts of
the application. This was a lead position on a team of several engineers.
Wrote performance test using Loadrunner 8.2 and Winrunner 8.2 for CVS Pharmacy application
•
• Made recommendations for performance enhancements to system
• Platform for application was Windows front-end and AS 400 backend
• Lead in effort of planning, writing, and executing scripts.
• Produced reports to show results of performance scripts.
BusinessEdge Solutions Inc
BusinessEdge is a vendor for Bellsouth; it was here that I was responsible for the performance test of a Java
application in a UNIX environment. I was responsible for diagramming and planning the test to be run and then
writing the test and executing them.
• Wrote test plan and developed methodology for performance test, and used Test Director to assist in this.
• Set up monitors using Site scope for monitoring of systems and network during performance test run.
• Wrote performance test and scenarios for Loadrunner performance test execution
U.P.S. – Supply Chain Solutions
This position evolved working with Loadrunner and Winrunner, the main goal here was to first get performance
scripts for an application that was already tested very quickly. Once this was done, a regression test suite need to
be updated. I discovered in this process that the regression suite was far too complex and could not run
unattended, so this was changed.
• Wrote test plan and developed methodology for performance test.
• Set up monitors using Site scope for monitoring of systems during performance test run.
• Wrote performance test and scenarios for Loadrunner performance test execution.
• Wrote performance test for shipping and inventory program
• Wrote regression test suite for testing of high priority supply chain application.
SunTrust Bank
SunTrust Bank has adopted a policy of performance testing all applications before they are promoted to
production. Some of the types of applications that I worked with were ASP.net, Java, and C++. The people
responsible for these applications were required to state expected results for the performance test and it was up to
the performance test team to write scripts to test these expectations. Some of the types of scripts written were
HTML and winsock using both Loadrunner and QALoad. Other responsibilities included writing COBOLs for
backend processes and Quicktest Pro test scripts for functional test.
• Used Loadrunner, QA Load, and Quicktest Pro testing tools for the purpose of performance and Functional
testing various projects.
• Meet with stakeholders of projects for the purpose of gathering requirements for load testing.
• Used Sitescope for monitoring of applications and network traffic.
• Worked on high priority Internet Banking project with Mercury consultants to write and conduct performance
tests.
• Used Loadrunner and QA Load for the purpose of testing Winsock applications.
• Wrote performance test for the purpose of testing soap protocol.
• Involved with critical testing of applications including Mainframe, Oracle, DB2, MS SQL and Client/Server
type environments.
ADP
Responsibilities at ADP included the implementation of the keyword driven engine that I had written and released
on open source. I was also responsible for the writing of performance test to test several different types of
applications including Java, ASP, Delphi, and Visual Basic applications. It was desired while I was there that the
other QA personnel would learn to use SAFS (Software Automation Framework Support) so I conducted training
classes for the people there to educate them in this and created applications to assist them in the writing of test
scripts.
• Implemented Keyword Driven test engine located at http://safsdev.sourceforge.net using Rational Robot and
Winrunner.
• Wrote load Test using Loadrunner for portal tests that were dynamic in that they worked on different servers.
• Used XML Parser and style sheets to generate documentation
• Wrote load test for several internal VB applications and Web Applications.
• Wrote VB Application for the purpose of generating scripts for Keyword Test Engine.
• Conducted training classes to teach testing team how to use Keyword Test Engine and write scripts.
Synovus / TSYS
Before going to TSYS, I did a proof of concept for the WRAFS; this proof of concept was presented to TSYS
when I started with them and I was given approval to develop this engine. During the process of developing this
engine, I also designed performance test to test the Department of Educations web site that we were designing in
Java.
• Wrote performance test for Department of Education government project using Loadrunner.
• Used Topaz and Sitescope for monitoring of Network traffic.
• Wrote Winrunner Version of Software Automation Framework Support located at
http://safsdev.sourceforge.net.
• Wrote MFC and COM+ DLLs using C++ and Visual Basic to add features to Winrunner that would
otherwise not be available
• Assisted organization to reach CMM level 3.
• Developed processes for Load Testing and regression automated test suite.
U.P.S.
While at U.P.S. I used both R.U.P. and eXtreame Programming for all aspects of project management. Some of
the tools used for this were Rational Robot and Rational Rose. Consultants were present that were subject matter
experts to consult on necessary steps to complete some of the tasks and to assist in getting the environments
properly configured.
• Worked on Data Warehouse project for UPS Financial report of International Shipping and Financing.
• Wrote Automated Scripts using Rational Robot for testing Delphi, and Web Reporting Applications written
in XML, and VB.
Wrote Automated Scripts using Rational Robot for testing several.
•
Trained the testing department on the use of Automated Tools using keyword driven testing.
•
Recommended Implementation of Testing Process to be used at UPS and created documents with supporting
•
details.
Used PL/SQL Developer for development of Packages and tuning of queries for applications.
•
Siemens
The application being tested at Siemens was a very advanced board placement application written in C++. A
combination of Winrunner, Loadrunner, and DLLs were used to accomplish what was needed to test this
application. The technology that was used to send messages to the different client computers was MSMQ.
• Wrote Automated Test using Winrunner, and Loadrunner.
• Responsible for setting up testing environment when new builds were delivered.
• Used VSS for configuration management of scripts.
• Assisted in establishing and implementing QA process including format of documentation and setup of Test
Director.
Senior Testing Analyst / Reporting Analyst 6/1998-6/2000
Powertel Atlanta, GA
Duties here included many different roles that included testing and writing of applications and automated scripts in the
testing department. Some of the applications that I wrote were Lotus Notes applications for the purpose of tracking projects
and time worked on those projects and logging defects to those projects. The last six months that I worked here were in the
capacity of a Reporting Analyst in the Data Warehouse department.
• Used Mercury Testing tools on Server Class and PC Level to create a variety of automated test scripts for the duration
of my time at Powertel.
• Used MS-SQL Server in the development and maintenance of the Fascor Database.
• Functioned as Lead in the Hydra Project designed to provide MS SQL Server interface with Peoplesoft including the
testing phase.
• Functioned as Lead in the planning and testing of the E-Commerce application.
• Involved in the design of the Visual Basic portion of an Access database to handle the interface with Lotus Notes.
• Lead responsibilities for the Inter-Voice Response Unit including testing phase.
• Lead testing phase of the Y2K Project which included the testing of all applications in the company.
• Worked as reporting analyst using Business Objects applications to write reports for Data Warehouse team.
Senior Testing Analyst / Testing Lead 5/1997-8/1998
Intelliquest Communications Marietta, GA
Worked in the testing department to write automated scripts that would test x.25 applications using Visual Test. Some of
this testing required using automated tools to call API’s to test internal abilities of the application. I was also involved in
some of the development efforts for the application which was written in C++.
• Involved in the design of the MS SQL Server EDI's for clients as well as in house Visual Basic application designed to
aide in extracts.
• Debugged and fixed Visual C++ program for SQL Server database inserts of Pipehost log files.
• Designed, planned, and wrote Visual Basic Test application for QA builds being shipped to clients.
• Wrote several Visual test applications for stress testing and X.25 testing.
• Worked on integration and testing of Informatica application into existing software.
Publications: Refereed (Peer Reviewed) Conference Papers
• Investigation of Computer Security and Ethics Awareness in University Environment, Max North, Greg
Quinet, Robert Thacker, DeAnthony Perryman, John Crunk, and Sarah North, The 2009
International Conference on Security and Management, SAM4306
• Decision Support Systems and Artificial Intelligence Technologies in Aid of Information Systems
Based Marketing, John Crunk and Max M. North, International Management Review Journal, 2007,
3(2), 61-67.
• Assessment of Brain Activities in Immersive Environments, Max North, Sarah North, John Crunk, and
Jeff Singleton, Proceedings of Medicine Meets Virtual Reality, California, January 2005, 362-364.
• Virtual Reality Combats Test Anxiety: A Case Study Report, Max M. North, Sarah M. North and John
Crunk, Proceedings of Medicine Meets Virtual Reality, California, January 2004, 278-280.