Quality Assurance Tester Analyst
Resume:
ANDREW AIELLO
Little Falls, NJ 07424
Home: 201-***-**** ********@***.*** Cell: 201-***-****
SUMMARY
Very experienced manual QA tester and IT application software professional with diverse expertise in testing, quality assurance, implementation and development. Team member and mentor valued for attention to detail and analytical problem solving abilities. Strong understanding of functionality and experience in creation of test plans, developing test scenarios and test cases with demonstrated ability to test across various internet browsers and modules. Solid background in reporting software.
KEY TECHNICAL SKILLS
Languages:
Operating Systems:
Software:
DBMS:
SQL Server MS SQL, Oracle PL/SQL
Microsoft Windows 95/2000/2005/XP/7/8/10, UNIX (HP)
Microsoft SQL Server Reporting Services (SSRS) (Visual Studio, SQL Server Management Studio, Report Manager), Centura Team Developer, Secure Shell (SSH) Data Transfer Utility, MS Windows Batch Scripting, Teradata SQL Assistant, Powershell,
Oracle SQL*Plus, Business Objects, ClearQuest Web, Quality Center (QC), Application Lifecycle Management (ALM), Team Foundation Server (TFS), JIRA, Microsoft Test Manager (MTM), Microsoft Office 2007, TSO-Mainframe, File-Aid, SPUFI, FileWatcher, .NET, SoapUI 5.5.0, TestLink 1.9, Trackzilla
Microsoft SQL Server 2000/2005/2008/2014, Oracle 7/8/9i/10, DB2 9, Microsoft Access 2010
PROFESSIONAL EXPERIENCE
NEW JERSEY DEPARTMENT OF THE TREASURY – OFFICE OF MANAGEMENT AND BUDGETING (OMB), Trenton, NJ 2019 – 2021
Quality Assurance (QA) Tester/Analyst (2019-2021)
Provide detailed testing and analysis for the EDISON Budgeting System (Enhanced Decision Information System Of New Jersey), as a member of the Internal QA Test Team. Involved with testing the online web application as well as the many reports in the system. The application deals with budget planning and analysis for different sections such as budget requests and monitoring, decision support, schedule 1 revenues, agency spending plans, and at different security access levels. These systems are online UI client/server applications with .NET framework that run on the server and use C#, C++, Java Script, and the Oracle relational database. Trackzilla is used for maintaining test cases, test results, defects, and application enhancements. Testing done across all browsers in the user community: Internet Explorer (IE), Microsoft Edge, Mozilla Firefox, Google Chrome.
Write SQL statements against the Oracle relational database, to validate data and test case results.
Perform manual testing.
Develop detailed test plans, create test cases, and create test data.
Responsible for reporting and tracking defects.
Handle functional testing, integration testing, regression testing, comparison testing, end to end testing, UAT testing.
Comply with IT standards, best practices and methodologies.
Work closely with the QA group, developers, business analysts, to ensure successful testing.
ANDREW AIELLO
Page 2
Home: 201-***-**** ********@***.*** Cell: 201-***-****
ACCENTURE – ETS, Princeton, NJ 2019 – 2019
Quality Assurance (QA) Tester/Analyst (2019-2019)
Provide detailed testing and analysis for the ETS (Educational Test Service) onboarding applications, as a member of the Internal QA Test Team. Involved with testing both web and desktop components. The onboarding applications deal with creating assessments, develop, give, and score various tests such as SAT, GRE. Accenture supports the ETS account with maintenance and testing of their applications. These systems are online UI client/server applications with .NET framework that run on the server and use C#, C++, and the Oracle relational database. JIRA is used for maintaining test cases, test results, defects, and application enhancements. SoapUI is used at times for testing.
Testing done across all browsers in the user community: Internet Explorer (IE), Mozilla Firefox, Google Chrome.
Write SQL statements against the Oracle relational database, to validate data and test case results.
Perform manual testing.
Develop detailed test plans, create test cases, and create test data.
Responsible for reporting and tracking defects.
Handle functional testing, integration testing, regression testing, comparison testing, end to end testing.
Comply with IT standards, best practices and methodologies.
Work closely with the QA group, developers, business analysts, to ensure successful testing.
AMAZON, Avenel, NJ 2018 – 2018
Warehouse Fulfillment Center Associate (2018-2018)
Responsible for handling outbound amazon online orders, selecting and packing items for 10 customers at a given time for all paper supplies, canned and boxed food items, beverages, meat and produce items, which will then be shipped to the customers.
KPMG, Montvale / Roseland, NJ 2015 – 2017
Quality Assurance (QA) Tester/Analyst (2015-2017)
Provide detailed testing and analysis for the Link Enterprise Assignment Management System (LINK-E), the Cost Projection System (CP), and the Partner Track System (PartnerTrack), as a member of the Internal QA Test Team. Involved with testing both web and desktop components. LINK-E and CP deal with assignments, allowances, employee and vendor payments, currency rate overrides, and various standard and ad-hoc reports. PartnerTrack deals with how partners handle their taxes. Primary test focus is with data feeds for JP Morgan Chase, its investments, distributions, data conversions, calculations, done on accounts to be stored in various destination database relational tables. These systems are online UI client/server applications with .NET framework that run on the server and use C#, C++, and the Microsoft (MS) SQL Server relational database. Team Foundation Server (TFS) is used for maintaining test cases, test results, defects, and application enhancements.
Testing done across all browsers in the user community: Internet Explorer (IE), Mozilla Firefox, Google Chrome.
Write SQL statements against the MS SQL Server relational database, to validate data and test case results.
Perform manual testing
Develop detailed test plans, create test cases, and create test data.
Responsible for reporting and tracking defects.
Handle functional testing, integration testing, regression testing, comparison testing, end to end testing.
Comply with IT standards, best practices and methodologies.
Work closely with the QA group, developers, business analysts, to ensure successful testing.
VERIZON WIRELESS, Warren, NJ 2013 – 2014
Quality Assurance (QA) Tester/Analyst (2013-2014)
Provided detailed testing and analysis for the VISION Integrated Billing System (Virtual Information System Integrated Online Network) as a member of the VISION System Test Team. Involved with testing several components of the system, ACSS (Automated Customer Support System), POS (Point Of Sale), DVS (Distributed Vision Services). This system has JCL and COBOL run on the mainframe and uses the DB2 relational database. Quality Center / Application Lifecycle Management is mainly used for maintaining test cases, test results, and tracking defects. An in-house VISION Data Retrieval Tool is used as a SQL Assistant for queries.
ANDREW AIELLO
Page 3
Home: 201-***-**** ********@***.*** Cell: 201-***-****
VERIZON WIRELESS, Warren, NJ 2013 – 2014
Quality Assurance (QA) Tester/Analyst (2013-2014)
Wrote SQL statements against the DB2 relational database, to validate data and test case results.
Performed manual testing.
Developed detailed test plans, create test cases, and create test data
Responsible for reporting and tracking defects.
Handled functional testing, integration testing, regression testing, end to end testing.
Worked closely with the QA group, developers, business analysts, to ensure successful testing.
EXPRESS SCRIPTS INC., Franklin Lakes, NJ 2012 – 2013
Quality Assurance (QA) Tester/Analyst (2012-2013)
Provided detailed testing and analysis for the mainframe application Retail Network Management system and its DB2 relational database components to support the QA testing process using Teradata SQL Assistant for queries and ClearQuest Web to enter defects.
Wrote SQL statements against the DB2 relational database, to validate data and test case results.
Performed manual testing.
Developed detailed test plans, create test cases, and create test data.
Responsible for reporting and tracking defects.
Handled functional testing, regression testing.
Worked closely with the QA group, business analysts, to ensure successful testing.
ERNST AND YOUNG, Secaucus, NJ 1990 – 2010
Quality Assurance (QA) Tester/Analyst (2005-2010)
Assumed the role as a Quality Assurance (QA) team member providing detailed testing and analysis when QA staffing was needed to support the QA testing process. Tested web-based intranet and client/server user interface (UI) applications. Wrote SQL for the SQL Server relation database for data validation tests. Systems also tested contained .NET framework and used C#, C++, and the Microsoft (MS) SQL Server relational database.
Performed extensive manual testing.
Developed detailed test plans, created test cases, and created test data.
Responsible for reporting and tracking errors.
Handled functional testing, regression testing, end to end testing.
Worked closely with the QA group, developers, business analysts, and users, to ensure successful testing.
Senior Associate/Computer Programmer Analyst (2005-2010)
Developed, tested and implemented programs for the web-based intranet application Global Time and Expense Reporting (gT&E). Wrote back-end stored procedures and created front-end report design using Microsoft SQL Server Reporting Services (SSRS) suite of applications.
Wrote SQL statements against the SQL Server relational database with a quick turn around, to satisfy many ad-hoc database query requests; saved users valuable research time.
Reporting system developed saved accounting center valuable time by automating a manual process; also enabled users to ensure compliance rules were followed.
Assisted in analysis and problem solving for internal issues management.
Developed detailed test plans, performed detailed tests, created test data, and maintained program documentation.
Mentored several individuals on maintaining and enhancing the gT&E Reporting application.
Senior Computer Programmer (1996-2005)
Developed, tested and implemented programs for the client/server application Time Reporting and Expense (TRAX) using Centura Team Developer GUI software and Oracle PL/SQL. Assumed the role as a Quality Assurance (QA) team member providing detailed testing when QA staffing was needed
Assisted in analysis and problem solving.
Developed test plans and maintained program documentation.
Performed detailed tests and created test data while serving as a Quality Assurance (QA) team member
ANDREW AIELLO
Page 4
Home: 201-***-**** ********@***.*** Cell: 201-***-****
ERNST AND YOUNG, Secaucus, NJ 1990 – 2010
Computer Programmer (1990-1996)
Developed, tested and implemented programs for the mainframe application National Engagement Management System (NEMS) using COBOL and UNISYS 2200 ECL.
Solely responsible for maintaining the firm’s Independence System of Security Holdings using MAPPER (4GL), COBOL, and UNISYS 2200 ECL.
BELLCORE, Piscataway, NJ 1988 – 1990
Computer Programmer
Developed, tested and implemented programs for the mainframe application General Ledger Financial System using COBOL and IBM JCL providing users with valuable reports for book closing.
AUTOMATIC DATA PROCESSING, Roseland, NJ 1987 – 1988
Computer Programmer
Helped support the payroll system for different clients using Keyfast software.
AT&T CORPORATE HEADQUARTERS, Piscataway, NJ 1984 – 1986
Computer Programmer
Coded, tested, and implemented programs for the Corporate General Ledger Books System, the Corporate Headquarters Personnel Database, and the Retirement Database system using COBOL, DB2, Natural (4GL).
Assisted as Production Coordinator providing user and operation technical support for the Corporate Books System.
OTHER KNOWLEDGE AND SKILL AREAS
Languages:
Hardware:
Software:
DBMS:
Other:
COBOL, UNISYS ECL, IBM JCL
UNISYS mainframe 2200, IBM mainframe 3270
Intersolv DataDirect (Q&E), Microsoft (Word, Excel), WinFTP Utility, TOAD, InstallShield
DB2
Microsoft Reporting Services Transact SQL, Data Modeling, Data Flow Diagrams,
Stored Procedures, PeopleSoft (PeopleTools, PeopleCode/SQR)
EDUCATION
M.A., Computer Science, Overall GPA 3.67
Montclair State College, Upper Montclair, NJ
B.S., Computer Science; Minor in Mathematics, Overall GPA 3.74, magna cum laude
Montclair State College, Upper Montclair, NJ
B.A., Music Education, Certification: Teacher of Music, K-12, Overall GPA 3.58, cum laude
Montclair State College, Upper Montclair, NJ
HONORS
Kappa Delta Pi Honor Society
Dean’s List, Montclair State College
Contact this candidate