Programmer Analyst Resume
Princeton, NJ
SUMMARY:
- Over 15+ years of IT experience in Quality Assurance with exposure to full software development life cycle (SDLC), Methodologies and Validation
- Project Quality control in software application development of Web based applications, Client/server applications, Data warehousing applications, and other custom built applications on Windows and Mainframe platforms.
- Experience in variety of domains including Health Care, Financial Business, Telecom and Manufacturing.
- Experience in Data warehousing / ETL Testing within environments of Oracle, DB2, SQL Server, SQL Developer and Toad.
- Strong in analyzing Functional Requirement Specification (FRS), System Design Specification (SDS) and Detail Design documents.
- Hands on experience in Setting up QA Environment, Generating Automated and Manual Test Scripts, Functional testing, Regression testing, Integration testing, Stress testing, Load testing, Unit testing, System testing, Black - box testing, White-box testing, Interoperability testing, Compatibility testing and Tracking defects.
- Extensive experience in Back End testing in various data bases like DB2, Oracle 9i/10g and MS Access using SQL queries.
- Good Relational Database and SQL skills and good experience using RDBMS concepts for the manipulation of the data and to validate the results.
- Experience in Agile methodologies like Scrum.
- Proficient in Manual Testing and Automation Testing using Tools like Quick Test Professional, Win Runner, ALM, Quality Center, Test Director and Rational Robot.
- Experience using QTP and Selenium Web Browser automation tools.
- Experience in mainframe environments.
- Expertise in QA Testing in distributed UNIX Environment and Oracle databases as back end, Performed testing using SQL, PL/SQL.
- Experienced in Developing, executing and modifying the UNIX Shell scripts for Data Extraction and verification.
- Strong Experience in Defect tracking tools such as Quality Center and Test Director.
- Ability to interact with Analysts, Clients, Software Vendors and other participating groups to analyze any requirement gaps or any other conflicting issues.
- Experience in writing Test plans, Test cases and defect tracking with the Test Management and Defect Tracking Tools like Test Director/Quality Center.
- Microsoft Certified Professional in Network Infrastructure.
- Self-starter with strong work ethic, good time management skills, establishes and maintains productive working relationship with management, clients and team members.
TECHNICAL SKILLS:
Testing Tools: Quick Test professional, Selenium, Rational Robot, Win Runner
Management Tools: Quality Center, ALM, Test Director, Rational Requisite Pro
Languages: SQL, PLSQL, MF COBOL, C, JCL, UNIX Shell Scripting, FORTRAN
Databases: DB2, Oracle, Sybase 12.x, MS Access
Data Warehousing: Informatica 9.x/8.x
Operating Systems: UNIX, Linux, Windows 7/2000/XP/2003, MVS
Front End: Developer 2000, VB, CICS
Tools: /Utilities: TSO, ISPF, File-AID, TOAD, MS Office, DB Visualizer, MKS, Autosys
Bug Tracking System: Quality Center, Test Director, Rational Clear Quest, Bugzilla
MS Office: Excel, Word, Power Point
PROFESSIONAL EXPERIENCE:
Confidential
QA Test Lead
Responsibilities:
- Web, system and iOS App testing in the implementation and support of Confidential applications at TRowe Price websites.
- Responsible for implementing the QA standards and preparing the teams using tools like ALM for Test Management, UFT and Selenium for regression automation testing.
- Responsible for creation and implementation of best practices, guidelines and reporting templates, reviews, analyze results, reports preparation, End to End testing activities and UAT support activities.
- Responsible for reviewing Business Requirement and Functional documents provided by Analyst team.
- Responsible for coordinating with nonfunctional teams for Performance and Security testing.
- Responsibilities also include requirement analysis; test planning, test design, test data preparation, test execution, result analysis, bug tracking and quality assurance.
- Developed test cases using HP ALM and executed them in test lab.
- Responsible for checking the backend log files using UNIX commands for the validating scenarios.
- Created and maintained test cases and executed them in the ALM test lab. The defects are entered and follow-up with developers by maintaining defect life cycle.
- Developed test scenarios by coordinating with security team, collected test data and validated application for security gaps.
- Coordinating with Analysts, Developers and Testers to resolve issues on time.
- Involved in Functional, Regression and Ad-hoc testing of the application.
Environment: ALM 11.01, UFT 12.01, Selenium, Java, JSP, Java Script, HTML, XML, UNIX, PuTTy, Oracle, SQL, Informatica, DBVisualizer, Java Client, SoapUI, UNIX, Web Sphere, DBVisualizer, Windows 7/10, Internet Explorer, Chrome, Firefox, Edge, MS Office, MAC, iPad, iPhone.
Confidential
Subject Matter Expert
Responsibilities:
- Web and system testing in the implementation and support of Business Services Online and Electronic Disability applications, which are deployed through SSA website.
- Expertise in developing automated techniques and databases for improved effectiveness of SSA independent verification and validation activities in Division of Quality Testing Validation (DQTV), Office of Systems Electronic Services (OSES)
- Created test cases, scenarios and Test data processing by running scripts
- Executed automated test scenarios using very detailed Keyword driven QTP frame work called SMART to validate and to run Sanity and regression automated test scripts.
- Developed test cases using HP Quality Center and executed them in test lab and then automated them using HP QTP for regression testing.
- Developed automated test scripts using VB Script.
- Enhanced test scripts by parameterize, introducing check points, synchronization points.
- Performed backend testing in DB2, Oracle databases and analyzed the front end submitted values and process results in various tables the tools like DBVisualizer, Toad, DB2 Command Editor.
- Validated database insertion and deletion by executing SQL statements to verify the output data with reference to the recorded data in GUI front end.
- Performed responsibilities of validating the data by documenting SQL queries in the database systems.
- Responsible for creating test data using multiple schemas of variable components in the client environment.
- Developed high level SQL queries to automate the application using QTP.
- Web Services testing using soapUI and in-house Java Client application.
- Created and maintained test cases and executed them in the Quality Center test lab. The defects are entered and follow-up with developers by maintaining defect life cycle.
- Coordinating with Analysts, Developers and Testers to resolve issues on time.
- Attend Peer-Review meetings, Automation meetings and Risk Assessment meetings.
- Participated in User Acceptance, usability and 508 testing by creating test data and validated when required.
- Responsibilities also include requirement analysis; test planning, test design, test data preparation, test execution, result analysis, bug tracking, quality assurance and client support.
- Testing, Analyze and documented the requirements document from the existing Detailed Functional Requirements (DFR).
- Involved in Functional and Regression testing of the application.
Environment: QTP 10.0, Selenium, ALM, Quality Center 10.0, IBM Mainframe, Java, JSP, Java Script, HTML, XML, File-Aid, JCL, CICS, DB2, Oracle, SQL, Informatica, DB2 Command Editor, Toad, DBVisualizer, Java Client, SoapUI, UNIX, Web Sphere, Autosys, MS Access 2000, MVS, Windows XP/7, Internet Explorer, Chrome, Firefox, MS Office.
Confidential
Sr. Computer Systems Analyst
Responsibilities:
- Web and system testing in the implementation and support of Business Services Online and Electronic Disability applications, which are deployed through SSA website.
- Expertise in developing automated techniques and databases for improved effectiveness of SSA independent verification and validation activities in Division of Quality Testing Validation (DQTV), Office of Systems Electronic Services (OSES) and Office of Retirement and Survivors Insurance Systems(ORSIS).
- Created test cases, scenarios and Test data processing by running scripts
- Executed automated test scenarios using very detailed Keyword driven QTP frame work called SMART to validate and to run Sanity and regression automated test scripts.
- Automated CICS screens as part of End to End scenarios testing using the Terminal Emulator (TE), data entered through front end is verified properly propagated on CICS screens.
- Developed test cases using HP Quality Center and then automated them using HP QTP for regression testing.
- Enhanced WinRunner scripts by introducing GUI checkpoints, synchronization points, and bit map verification.
- Performed backend testing in DB2, Oracle databases and analyzed the front end submitted values and process results in various tables the tools like DBVisualizer, Toad, DB2 Command Editor
- Validated database insertion and deletion by executing SQL statements to verify the output data with ref to inputs entered on the application.
- Automated CICS application screens using WinRunner with help of terminal Emulator add-in.
- Created and maintained test cases and executed them in the Quality Center test lab. The defects are entered and follow-up with developers by maintaining defect life cycle.
- Coordinating with Analysts, Developers and Testers to resolve issues on time.
- Attend Peer-Review meetings, Automation meetings and Risk Assessment meetings.
- Executed automated test scenarios using Quick test Professional and Win Runner 8.2 in keyword architecture.
- Loading the extract file data into different stages of FSDIM DW database tables through informatica workflows using Autosys for defining, scheduling and monitoring jobs.
- Participated in User Acceptance, usability and 508 testing by creating test data and validated when required.
- Created and maintained Scenario and data files to conduct mainframe automation testing.
- Responsibilities also include requirement analysis; test planning, test design, test data preparation, test execution, result analysis, bug tracking, quality assurance and client support.
- Attend Peer-Review meetings, Automation meetings and Risk Assessment meetings
- Testing, Analyze and documented the requirements document from the existing Detailed Functional Requirements (DFR).
- Involved in Functional and Regression testing of the application.
- Developed test cases using HP Quality Center and executed them in test lab.
Environment: QTP 10.0, Win Runner 9, Quality Center 9.2/10.0, Test Director 8, Internet Explorer, MS Office, IBM Mainframe, Java, JSP, Java Script, HTML, XML, File-Aid, JCL, CICS, DB2, Oracle, SQL, Informatica, DB2 Command Editor, Toad, DBVisualizer, Java Client, SoapUI, UNIX, VS Cobol, Web Sphere, MS Access 2000, MVS, Windows XP.
Confidential
Programmer Analyst
Responsibilities:
- Web and system testing in the implementation and support of Business Services Online and Electronic Disability applications, which are deployed through SSA website.
- Expertise in developing automated techniques and databases for improved effectiveness of SSA independent verification and validation activities in Division of Quality Testing Validation (DQTV), Office of Systems Electronic Services (OSES) and Office of Retirement and Survivors Insurance Systems(ORSIS).
- Created test cases, scenarios and Test data processing by running scripts
- Automated CICS screens as part of End to End scenarios testing using the Terminal Emulator (TE), data entered through front end is verified properly propagated on CICS screens.
- Enhanced WinRunner scripts by introducing GUI checkpoints, synchronization points, and bit map verification.
- Performed backend testing in DB2 database and analyzed the front end submitted values and process results in various tables the tools like DB2 Command Editor
- Validated database insertion and deletion by executing SQL statements to verify the output data with ref to inputs entered on the application.
- Automated CICS application screens using WinRunner with help of terminal Emulator add-in.
- Created and maintained test cases and executed them in the Test Director test lab. The defects are entered and follow-up with developers by maintaining defect life cycle.
- Coordinating with Analysts, Developers and Testers to resolve issues on time.
- Attend Peer-Review meetings, Automation meetings and Risk Assessment meetings.
- Executed automated test scenarios using Win Runner 8.2 in keyword architecture.
- Created and maintained Scenario and data files to conduct mainframe automation testing.
- Responsibilities also include requirement analysis; test planning, test design, test data preparation, test execution, result analysis, bug tracking, quality assurance and client support.
- Attend Peer-Review meetings, Automation meetings and Risk Assessment meetings
- Testing, Analyze and documented the requirements document from the existing Detailed Functional Requirements (DFR).
- Involved in Functional and Regression testing of the application.
Environment: Win Runner 9, Quality Center 9.2/, Test Director 7/8, Internet Explorer, MS Office, IBM Mainframe, Java, JSP, Java Script, HTML, XML, File-Aid, JCL, CICS, DB2, Oracle, SQL, DB2 Command Editor, Java Client, UNIX, VS Cobol, Web Sphere, MS Access 2000, MVS, Windows XP, PAIRS.
Confidential
Programmer Analyst
Responsibilities:- Prepared test plan and performed manual testing.
- Created test Cases as per the business requirements and executed them.
- Created test cases, executed test cases and test scripts
- Performed manual testing of the application.
- Track the defects by using Test Director.
- Prepared test cases for different kinds of e-documents based on the mortgage application.
- Configured and installed the test director executed the test cases in test director.
- Responsible for migrating the test cases from excel spread sheet to quality center repository.
- Extensively worked on SQL database.
Environment: Test Director, WinRunner, QTP, .net, Xml, Toad, Oracle8i, Windows XP, Mortgage Ware, Jet Forms, Jet Weaver.
Confidential,Princeton, NJ
Programmer Analyst
Responsibilities:- Involved in designing Test Cases using Requirement specification documents and design documents.
- Involved in Functional and Regression testing of the application.
- Automated Test Cases using Mercury Win Runner.
- Performed backend testing in Oracle database using tools like TOAD and analyzed the log files for different error codes.
- Validated database insertion and deletion by executing SQL statements to verify the output data with ref to inputs entered on the application
- Enhanced the recorded script using Checkpoints, Sync points.
- Parameterize values to test with multiple sets of data.
- Tested the indexed collections of all the articles that are developed in Linux.
- Involved in Requirements review meeting with developers to ensure that business requirements are understood, and proposed technical solutions to meet business objectives.
- Performed Backend testing to validate data entered into database.
- Compared the test data with expected data by using EXCEL sheets that retrieved from data base by using TOAD.
- Reported and tracked defects using Test Director.
- Created weekly status reports describing status of testing process.
- Managed the functional specifications, development, user acceptance testing.
- Actively involved in all aspects of the analyses process including creating use cases, test cases, problem reporting, and documenting results.
- Determined test strategies based on requirements and architecture
- Created and implemented performance tests using Mercury Interactive Load Runner.
- Executed unit plans to test all physical transactions, edits, validations, calculations, summarization, restart and rerun capability, reporting and error handling routines for the specific module.
- Executing test cases, identifying mismatches and reporting defects into Test Director 7.6 and tracking them till they are fixed.
Environment: Win Runner 7.2, Test Director 7.6, Load Runner 7.0, Internet Explorer, Mozilla, Netscape Navigator, Opera, windows xp/2000, Mac, Linux, Web spear, MST, Oracle 8i, TOAD, V2 application server.
Confidential
QA Analyst
Responsibilities:- Responsible for quality assurance and system testing in the implementation and support of Web Enabled Services.
- Preparation of Test Plan for various modules using business specifications.
- Created test cases and scenarios and generated test data for execution of test cases.
- Executed both manual and automated testing on web applications.
- Conducted integration testing of complex applications with multi-tier architecture.
- Automated test scenarios using Win Runner 7.x.
- Created and maintained JCLs to conduct mainframe testing.
- Conducted Regression testing.
- Extensively used QMF, File-AID to query DB2 databases and VSAM files.
- Responsibilities also include test planning, test design, test data preparation, test execution, result analysis, bug tracking, quality assurance and client support.
- Used PVCS tracker to track bugs and report bugs to developers.
Environment: Win Runner 7.01, Test Director 7.5, Internet Explorer, Netscape Navigator, MS Office, IBM Mainframe, Visual Basic, Lotus Notes, Java, JSP, Java Script, HTML, XML, File-Aid, VSAM, JCL, CICS, DB2, Oracle, SQL, VS Cobol, Web Sphere, MS Access 2000, MVS, Windows 98/NT/2000/XP
