Kevin Abel
Suite C64
84-09 Talbot Street
Kew Gardens, NY 11415
(718) 441 2041
| SUMMARY More than 19 years of diversified experience as a Test Automator, Business/Technical Troubleshooter and Programmer. TECHNICAL COMPETENCIES Testing Tools: WinRunner 7.0, Test Director 7.01, LoadRunner, Autotester Inferno, CitraTest, Visual Source Safe, Visual Test, Astra Site Manager, Astra Web Test, Segue, and SQA Robot Hardware: IBM PC, IBM mainframe, DEC/VAX Languages: SAP, Clipper 5.2 , FoxPro for Windows, Visual BASIC 6.0, TSL, C, MEDIATOR, JOVIAL Databases: Clipper, Foxpro, xBASE, Oracle Operating Systems: Windows 2000, Windows NT, Windows 98, Windows 3.11, Windows Pocket CE, UNIX, VAX/VMS, MVS and DOS, Palm/OS CERTIFICATIONS Mercury Interactive Certified Product Specialist (CPS) for WinRunner and TestSuite version 7. First attempt at (CPI) Exam in June 2001. Currently working on my LoadRunner (CPS) Exam. WORK EXPERIENCE INDEPENDENT CONSULTANT OVERVIEW (November 90 present) Specializing in testing automation, programming, development and application
version enhancements. In addition to my testing background, I have also been complemented
on my software coding and whitebox debug talent. A sampling of the areas in which I have
gained experience are e-tailing, Siebel, SAP ERP, Magazine Publishing, Telecommunications,
Foreign Exchange, Banking, Insurance, Financial, Pharmaceutical, Medical Billing,
Accounting, Data Security and Aerospace Industries. June 2001 to present(JP Morgan CHASE, New York, NY) Mentoring new users on how to create and maintain WinRunner
7.0 Web and Powerbuilder scripts. Creating LoadRunner Virtual User Scripts in an HTTP environment. Running up to 250
Virtual Users in 7.0 Controller. Comparing results to Webload. Performed a Proof Of
Concept using Autotester Inferno from Gresham and CitraTest from Tevron to automate
non-intrusive Citrix/Siebel Automation testing. Citrix transmits screen information to the
client as screen bitmaps. It does not send individual object data. For example, the GUI
information needed by tools such as WinRunner regarding buttons and edit boxes is not
supplied to the client PC. The automation needs to be done on a bitmap representation
level. Participating in the manual Siebel testing process to look for common tasks that
can be automated using a functional testing tool. Attended Empirix demonstrations of
e-test and e-load. Using WebTest to stress test an in-house application. May 2001 to June 2001 (Deutsche Bank, New York, NY) Managed project to test the Fax Transmittal Program System (FTP). Set up testing
environment using Timbuktu Pro to connect with the developers test environment.
Performed predefined test scripts as well as ad-hoc testing. Communicated results at a
weekly telephone meeting. Located two critical issues, one important issue and several
suggestions about the product and documentation. Regression tested defect free version of
the entire system before successfully completing contract. Mentored other testers with
WinRunner 7.0 and TestDirector 7.0i. December 2000 to March 2001(Caminus Inc., New York, NY) Completed project of selecting and implementing a tool used for managing
requirements and the testing process of Zainet Power Trading Software. Worked with Mercury
Interactive to install client and Server portions of TestDirector internet versions 7I and
7.01. Analyzed and imported legacy test data from spread sheets into Test Director using
Excel Macros. Set up and maintained the administration portion of Test Director to manage
the project. Trained new users and worked with Mercury Interactive to resolve issues.
Installed and set up Merant and Borland drivers as well as databases for zainet using
Oracle, SQL Anywhere, and SQL Server 7. Consulted with Mercury Interactive customer
support on site to establish a method for recognizing C++ custom GUI objects with
WinRunner 7.0. Demonstrated utilizing a WinRunner version 7.0 TSL script that a lot of
hand coding would be required to establish a set of re-usable scripts that would work with
the current version of the application under test. I recommended that the development of
automated script development should resume upon completion of the new Zainet prototype in
order to gain the most benefit from the automation process. May 2000 to November 2000(IMPATH INC, New York, NY) Created Automated WinRunner scripts which emulated the processing of a
patients laboratory cancer analysis case. Automation components include
Accessioning, Reporting, Billing, Shipping and Accounts Receivable. The scripts have the
ability to determine which portions of a clients case are completed and can process
necessary sections. The scripts also have the ability to create a new case. The
application under test contains many custom third party objects, which WinRunner does not
directly recognize. Utilized WinRunners capability of communicating with custom
objects though their methods and properties. In addition to automation, I have also
located over 175 defects during manual testing. I am communicating with other QA testers
and departments to assist in the process of regression testing. Using Microsoft Anomaly
Tracking System as well as Excel sheets containing Screen Captures stored in Word
documents to manage testing process. December 99 to May 2000(Barnes and Noble.com, New York, NY) Developed WinRunner functions and scripts used to test future versions of the
barnesandnoble.com live web site. Utilized the WinRunner WebTest add-on. Managed function
and script creation in Test Director. Assisted Junior Test Developers on the WinRunner and
TestDirector products. Worked with the Volume and Stress Testing LoadRunner Team to insure
that a high volume of customer traffic can be maintained for the December shopping season. July 99 to December 99( Created a Sanity WinRunner Automated test, which exercises major components of SynCrypt 1.7. The sanity test has been run to check that major functionality is maintained for two beta versions of an encryption/decrtyption software application called SynCrypt. SynCrypt is a Java application running outside of a browser. Documented the process of connecting the WinRunner Java add-on to work with Windows 95, 98 and NT. Application under test is changing between builds, which leads to constant TSL modifications in Sanity test. Currently adding more specific modules to the top level TSL script to examine different portions of SynCrypt. Installed WinRunner 6.0 with new Java add-on and insured that existing scripts will run in new environment. Our goal is to eventually automate all areas of testing except for tasks such as swapping CD ROM disks and portions requiring human intervention to hardware such as Cylink Security card readers. August 99 (NYCE Corp.,Secaucus, New Jersey) Taught a 40-hour Mercury Interactive TestSuite Quick Start Class in my spare time. Students had previously completed a two-week intensive technical training class. The purpose of my class was to provide hands-on, shoulder to shoulder guidance and training in the students own testing environment. I spent a few hours explaining the automation process along with code examples. The students completed and demonstrated actual scripts that have been used in their regression and Y2K testing cycle. I am provided feedback and worked with students to enhance the scripts. The WinRunner 2000 TE add-in is being used to communicate with Case Maker DRSE on Tandem Workstations. August 99(Warner Lambert, New Jersey) Analyzed and discussed completeness and accuracy of SAP Y2K System Level QA Documentation for a 20 hour project. April 99 to May 99 (New York Mercantile Exchange, New York) Team member involved in completing an automation test harness to test the Access 2000 NYMEX Trading Application. The approach was to describe the workflow and test data in Excel Spread sheets. Perl was then used to automatically generate WinRunner TSL code. The generated code called a library of functions that I maintained. I wrote stabilization routine utilizing WinRunner physical properties to always insure that the automation testing begins from a known application state. I documetned errors and enhancements in the spreadsheet to WinRunner TSL generation System. December 98 to April 99 (Time Warner, New York, ) Utilized the new data based driven feature of WinRunner /Power Builder 5.01 to automate the data entry process. The OMSPRINT Application, which was under test, was being used to determine the structure of magazine layouts for different demographic groups in different regions of the world. Data was being provided in Microsoft Excel and SQL tables. Cleaned up code so that it closely matches screen entry requirements. Developed TSL scripts that use spreadsheet data to fill in Windows. In addition to being able to rapidly and accurately validate and enter data into the application, automation had directly lead to locating user interface bugs. Wrote WinRunner 5.01 TSL script which is currently used to Sanity Check all modules which are built by the Development Team. Wrote TSL scripts to test transaction functionality. February 98 - December 98 (Lucent Technologies, Warren, NJ) Corporate Division Returned to client to work with an enhanced version of the Test Harness, which is described below. Designed and built Test Lab consisting of 24 PCs clustered into groups of 4 using Belkin switch boxes. Wrote lab set-up procedures. Re-wrote automated procedure in WinRunner Test Scripting Language (TSL), which learns the objects on, more than 1200 SAP transaction screens. Designed, wrote, and maintaining TSL code which recognizes different types of pop-up SAP dialog boxes. The program recognizes objects on the dialog boxes utilizing real-time recognition of physical properties. This avoids having to learn thousands of possible permutations of dialog windows. The workflow for closing the dialog boxes can be read from instruction flat files created in advance by SAP specialists. The dialog boxes can also be handled in a generic way using a system, which I developed and coded. Automated Location Code SAP Transactions utilizing WinRunner and our Harness. Documented many TSL code enhancements to the harness as well as explaining several high level design strategies to our team. While working on the automation process of SAP, I have also gained valuable insight on many SAP modules such as Material Master, Sales and Distribution, and Human Resources. January 97 - January 98 (Lucent Technologies, Basking Ridge, NJ) Business Communications Division Reviewed and suggested improvements to a group of related functions, which we called the Test Harness. The functions included automatic detection of the success of an action. For example if a function were used to start a transaction, the function would determine if the correct transaction window were displayed after the application stabilizes. On a failure, the Test Harness would send a message to the log and move on to another script. I also wrote several functions that were reviewed and added to later versions of the Harness. Wrote WinRunner scripts using the Test Harness to test SAP security of each transaction to be implemented in our first release of SAP. A SAP security specialist wrote a script for each transaction including data to be entered as well as functional verification points. Each script was reviewed to determine if it was a candidate for automation. I coded 130 of the scripts, which were run on a semi-monthly basis to verify that each transaction could traverse, edit, view and delete proper data on the screens. The Harness Functions made the code much simpler to code as well as to read and document. When scripts failed, I checked whether it was due to a change in SAP configuration, data requirement, SAP security failure, or if a change was needed to my TSL code. Before leaving the project, I taught a full time employee how to maintain and write new scripts. In addition to automated testing, I also wrote two manual test scripts regarding changes to SAP order entry and Cost Centers. I gathered the information by interviewing SAP analysts and other members of the SAP testing team. Writing the scripts required an understanding of UNIX, Windows NT,SAP, Access and FTP. I presented the test scripts at Walkthrough Meetings consisting of business analysts, SAP ABAP programmers, and execution testers. I participated with the testing team to maintain tracking tools such as Lotus Notes Trouble Tracking System and the Price Waterhouse Toolkit which was used to document the SAP implementation. I worked with a BASIS consultant for several weeks to assist in tracking SAP Transports. In several instances, test scenarios required transmitting hundreds of similar transactions with different data to the SAP servers. For these scenarios, I worked with LoadRunner consultants to design LoadRunner Virtual Users. The volume and stress testing was monitored and controlled through the LoadRunner Test Controller. July 96 - January 97 (CITIBANK, New York, NY) Tested Citibanking Foreign Check Clearing System. The Application which was written in Visual BASIC 4.0, allows the user to fill fields on the screen that previously appeared on paper based checks. Each country requiring the product had similar but different rules for producing a check. The countries I was responsible for testing were Hong Kong, Australia, and Thailand. Since the testing process was very linear, I chose to base my testing on a checklist containing different variations of input data. Used Lotus Notes to track errors as well as for communicating with the development team, other testers and business analysts January 96 - July 96 (Reuters Hauppauge, NJ) Tested the D2000-3 Foreign Exchange Network, which was composed of a hierarchy of VAX/Alpha servers, local servers, and PCs running Windows NT. Tests consisted of entering thousands of variations of BIDs, OFFERs, ASKs and BUYs into several PCs in a lab which simulated users at multiple sites. Testing required setting up several PC that would be considered to be at a local site as well as users at foreign sites. The transactions at the multiple sites would all be executed. Verification of results at each workstation had to be closely examined. Some tests required data simulators to provide a constant flow of market data to work against. Many tests required a power down or artificial breakdown of hardware components to test for local and network data disaster recovery. Output logs of the individual workstations as well as the servers were highly scrutinized for transaction accuracy. Documented, communicated, and regression tested errors to the C++ development team. November 95 -December 95(NASDAQ, Trumbull, CT) Accepted short term project utilizing WinRunner to gain hands on experience with an Automated testing tool. The testing department was using Winrunner to test a new version of the Nasdaq Workstation II Product. The product was written in Open Interface. At the time, WinRunner could not recognize most attributes of Open Interface objects. 90% percent of the code was written using analog functions rather than context sensitive, which was a great challenge for coding the scripts as well as determining accuracy of validation points. After each recompile of the Nasdaq application, I would run the automated tests required to ensure functionality and object existence (windows, fields, buttons) of specific modules. If a script failed during a run or if there was an error in the logs, I could often determine the reason for the failure. After explaining the reason for the failure, I was often given the opportunity to fix the Test Script Language (TSL) WinRunner Code. During my last two weeks of the project I wrote my own code based on manual test scripts to test fractional ticker prices. May 95 - November 95 (American International Group, Livingston, NJ) AIG provided our entire team with training on the existing legacy system. We were then presented with the new Visual BASIC modules that were to replace the old interface. The goal was to consolidate the multiple legacy systems into one working environment that would be easier to understand, be more user-friendly and present data more logically. Some of the new systems gathered and scattered data directly from the mainframe database. Other information was sent between the legacy system and the new system by copying and pasting data to the mainframe screens. We wrote unit, field, and module and string tests. We performed these as well. The tests were repeated using variations of logon privileges. Modules I was involved with were Claims Re-engineering, Auto Residual, Claims Litigation and Claims Representative Calendar. The Visual BASIC developers used a combination of PVCS and WinRunner , and Visual BASIC to archive and perform new builds of the application. The archive structure in the PVCS changed during the development cycle. The originator of the Clipper code was no longer on the project, so I wrote a patch to allow the development team to continue producing new code. December 94 - May 95 (Standard & Poor's, New York, NY) Re-wrote existing Clipper 5.2 program that parsed a weekly feed from a mainframe, updated internal related database files and provided flat files to editors of several Standard & Poor's magazine publications. The data contained information on international Insurance Company's ability to Pay Claims. Most of the original code was for producing the pull down menu and other interface tasks but it was not properly functioning as required by the publishing departments. I spent two months re-writing the code in Clipper. After submitting the improved Clipper program, the publishing editors provided me with a new enhanced set of requirements. The users wanted a Windows front-end interface, which Clipper could not provide. I decided on using Foxpro for Windows 2.6B. Since both platforms are xBASE, about half of the code was re-usable. Created and maintained documentation for the FoxPro version of the application. Taught Editors how to use the new application. December 93 - December 94 (Kwasha Lipton, Fort Lee, NJ) Reference: Waquar Qureshi 732 393 0533 Updated and created more than 45 different 401(k) fund distribution systems for external corporations. The system my partner and I inherited contained about 75 thousand lines of code, which is used for switching participants retirement funds. I worked closely with the business partners and accountants to find a way to meet the clients documented requirements. I analyzed existing Clipper code in the Distribution and Allocation System (DAS). I Changed existing code, parameters, include statements and client specific functions to closely match the agreed upon rules. Worked with Quality Assurance group to verify that output flat files were extremely accurate. November 93 - December 93 (Wellington Consulting, Fort Lee, NJ) Reference: Dean Wellington201944 9004 Hired on a short-term basis to review existing Foxpro 2.6B code for the Fiduciary Trust Company. The multi-user networked system, which was to be used by brokers when a client called for a recommendation on purchasing stock. The system provided ratings as well as a description and the opinions of different internal brokers. After reviewing the system on both the code and application levels, I provided seven pages of bugs and recommended enhancements, which were greatly appreciated by the program developer. January 93 - October 93 (Clinical Systems, Princeton, NJ) Leader of validation group responsible for conducting functional testing and documentation of the ClinPro/LBL 5.0 Clinical Trial Labeling System which is written in Clipper Version Summer of 87. The lead programmer requested that I first Beta Test the package in the same way that a new user would receive and use the package. I recorded my findings in a log that was reviewed each day. I kept track of unclear documentation, unexpected functionality, warning and error messages. The product was highly dependent on a multi-dimensional relational database. I was not shown the Clipper code on purpose so that I would not have a bias as to which parts of the program to focus on. I had a pharmacist and sales person review how they use the program to gain insight into how the program will be used in clinical trials. After entering my own trial protocols, I immediately had several theories about ways to find weaknesses in the software. I began noticing patterns that seemed to cause improper results in label creation, screen results and database updates. My findings were often correct and adjustments were made to the application causing me to retest my earlier findings. The Testing strategy was to test the individual fields, test the screens, modules and then the entire system using advanced protocols. In addition to testing, I also wrote a database conversion program used in reformatting data from an earlier version of ClinPro. February 91 - January 93 Wrote and tested Clipper code for each of the following companies. Further information & references provided upon request.
November 90 - October 91 (UNISYS, Sunnyvale, CA) Ten month project as a Clipper Programmer responsible for standardizing Trouble Problem Reports (TPRs) for the Air Force Satellite Control Network Library. TPRs were being saved as dBASE III and Clipper databases in several classified locations. The project required me to store similar information from several sources as one large database file that would be updated on a monthly basis. Each data provider used different backup applications such as PKZIP, DOS backup, and Fastback requiring me to first extract data. Wrote and documented a user-friendly menu driven program which moved data records from individual databases into the library database. Each record was compared to existing data records. In case of data duplication, the user was given an opportunity to determine the more accurate record. The user was also prompted to enter missing required data. Wrote validity logic to scan each entry for improbable data and automatically correct record when possible with an entry made to an output log. Discussed progress of my code and the condition of the Library Database to the Air Force each month. Trained employees on usage of my library management software. Provided Metric Results based on library data in report format to management on an as needed basis. EMPLOYEE POSITIONS October 85 - November 90 (Lockheed Martin, Sunnyvale, CA) Reference: Lan Rupf 408 554 6345 Assigned to three different projects during my 5 years at Lockheed. For the Missiles Systems Division, I assisted a team which tests flight control boards for nuclear missiles on the Trident II Submarine. I wrote software in Sentry/Mediator on a DEC/VAX. The compiled software was downloaded to a Sentry tester which tested interface boxes used for connecting the tester to the Units Boards Under Test. I also Submitted and traced the teams redline drawings through document control. For the Aviation division, I built and began testing a prototype image recognition system based on experimental drawings. For Lockheed Aerospace, I was trained on the mainframe to assist in testing Telemetry displays. After the Software was developed for individual spacecraft, I would work with a team that would produce repetitive input data that would be fed through the telemetry processing. We would hand calculate expected results on paper or through another program written in dBASE III. We would then compare the expected results to the actual display data. When an error was located, I would work with my team members to locate it using utilizing TSO/ISPF, VSAM, DEFINE and dedicated applications. Tested telemetry database accuracy before spacecraft launch or critical maneuver. October 83 - October 85 (Schlumberger Technologies, San Jose, CA) Built 32 bit hardwired CPUs that consisted of 15 circuit boards containing discrete components inserted into a wire wrapped back plane. Troubleshot digital and analog problems down to the board and component level. Assisted senior staff in building digital high speed Sentry Automated Test Equipment which are used for testing chips at the wafer and chip stages. Integrated and tested DEC/VAX, Schlumberger Chip Testers and interface boards, and Ungermann Bass Network Interface Units to function as a local area network EDUCATION:
PROFESSIONAL ASSOCIATIONS:
CONFERENCES:
|
||||||||||||||||||||||||||